A_SUPPLIER
- Last Updated: August 10, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- SAP S/4HANA 6.0
- Documentation
Columns
The A_SUPPLIER table contains the following columns. Columns marked with an asterisk comprise the primary key.
| Column Name | Data Type |
|---|---|
| SUPPLIER* | STRING(10) |
| ALTERNATIVEPAYEEACCOUNTNUMBER | STRING(10) |
| AUTHORIZATIONGROUP | STRING(4) |
| BIRTHDATE | DATETIME(0) |
| CONCATENATEDINTERNATIONALLOCNO | STRING(20) |
| CREATEDBYUSER | STRING(12) |
| CREATIONDATE | DATETIME(0) |
| CUSTOMER | STRING(10) |
| DELETIONINDICATOR | BOOLEAN |
| FISCALADDRESS | STRING(10) |
| INDUSTRY | STRING(4) |
| INTERNATIONALLOCATIONNUMBER1 | STRING(7) |
| INTERNATIONALLOCATIONNUMBER2 | STRING(5) |
| INTERNATIONALLOCATIONNUMBER3 | STRING(1) |
| ISNATURALPERSON | STRING(1) |
| PAYMENTISBLOCKEDFORSUPPLIER | BOOLEAN |
| POSTINGISBLOCKED | BOOLEAN |
| PURCHASINGISBLOCKED | BOOLEAN |
| RESPONSIBLETYPE | STRING(2) |
| SUPLRPROOFOFDELIVRLVTCODE | STRING(1) |
| SUPLRQLTYINPROCMTCERTFNVALIDTO | DATETIME(0) |
| SUPLRQUALITYMANAGEMENTSYSTEM | STRING(4) |
| SUPPLIERACCOUNTGROUP | STRING(4) |
| SUPPLIERCORPORATEGROUP | STRING(10) |
| SUPPLIERFULLNAME | STRING(220) |
| SUPPLIERNAME | STRING(80) |
| SUPPLIERPROCUREMENTBLOCK | STRING(2) |
| TAXNUMBER1 | STRING(16) |
| TAXNUMBER2 | STRING(11) |
| TAXNUMBER3 | STRING(18) |
| TAXNUMBER4 | STRING(18) |
| TAXNUMBER5 | STRING(60) |
| TAXNUMBERRESPONSIBLE | STRING(18) |
| TAXNUMBERTYPE | STRING(2) |
| VATREGISTRATION | STRING(20) |