| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | TKONN | Trading Contract: Trading Contract Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | TKONN | Allow NULL? |
| 3 | TPOSN | Trading Contract: Item Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | TPOSN | Allow NULL? |
| 4 | TPOSN_SUB | Trading Contract: Sub-Item Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | TPOSN_SUB | Allow NULL? |
| 5 | PARVW | Partner Function | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | PARVW | Allow NULL? |
| 6 | PARZA | Partner counter | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PARZA | Allow NULL? |
| 7 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 8 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 9 | LIFNR | Reference to other vendor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LIFN2 | Allow NULL? |
| 10 | KUNNR | Customer number of business partner | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNN2 | Allow NULL? |
| 11 | DEFPA | Default Partner | char | 1 | 0 | CHAR | (N' ') | Yes | | DEFPA | Allow NULL? |
| 12 | PARNR | Number of contact person | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | PARNR | Allow NULL? |
| 13 | PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | PERNR_D | Allow NULL? |
| 14 | ADRNR | Address | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ADRNR | Allow NULL? |
| 15 | ADRDA | Address indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ADRDA | Allow NULL? |
| 16 | HISTUNR | Level number within hierarchy | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | HISTUNR | Allow NULL? |
| 17 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | STCD1 | Allow NULL? |
| 18 | STCD2 | Tax Number 2 | nvarchar | 11 | 0 | CHAR | (N' ') | Yes | | STCD2 | Allow NULL? |
| 19 | STCD3 | Tax Number 3 | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | STCD3 | Allow NULL? |
| 20 | STCD4 | Tax Number 4 | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | STCD4 | Allow NULL? |
| 21 | STKZN | Natural Person | char | 1 | 0 | CHAR | (N' ') | Yes | | STKZN | Allow NULL? |
| 22 | STCDT | Tax Number Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | J_1ATOID | Allow NULL? |
| 23 | J_1KFREPRE | Name of Representative | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | REPRES | Allow NULL? |
| 24 | J_1KFTBUS | Type of Business | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | BUSTYPE | GESTYP | Allow NULL? |
| 25 | J_1KFTIND | Type of Industry | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | INDUSTYPE | INDTYP | Allow NULL? |
| 26 | HITYP_SD | Customer hierarchy type | char | 1 | 0 | CHAR | (N' ') | Yes | * | HITYP_KH | Allow NULL? |
| 27 | HITYP_MM | Hierarchy category: vendor hierarchy | char | 1 | 0 | CHAR | (N' ') | Yes | * | HITYP_LH | Allow NULL? |
| 28 | PRFRE | Relevant for price determination ID | char | 1 | 0 | CHAR | (N' ') | Yes | | PRFRE | Allow NULL? |
| 29 | BOKRE | Indicator: Customer Is Rebate-Relevant | char | 1 | 0 | CHAR | (N' ') | Yes | | BOKRE | Allow NULL? |
| 30 | BOLRE | Indicator: vendor subject to subseq. settlement accounting | char | 1 | 0 | CHAR | (N' ') | Yes | | BOLRE | Allow NULL? |
