| 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 | T000 | MANDT | Allow NULL? |
| 2 | GEGRU | Legal regulation for legal control | nvarchar | 2 | 0 | CHAR | (N' ') | No | T606G | GEGRU | Allow NULL? |
| 3 | GEART | License type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T606 | GEART | Allow NULL? |
| 4 | KUNNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | KNA1 | KUNNR | Allow NULL? |
| 5 | GENNR | Internal license number | nvarchar | 10 | 0 | CHAR | (N' ') | No | EMBK | GENNR | Allow NULL? |
| 6 | PARAG | Sold-to party function for license | char | 1 | 0 | CHAR | (N' ') | Yes | | PARAG | Allow NULL? |
| 7 | PARWF | Ship-to party function for license | char | 1 | 0 | CHAR | (N' ') | Yes | | PARWF | Allow NULL? |
| 8 | PARRS | Bill-to party function for license | char | 1 | 0 | CHAR | (N' ') | Yes | | PARRS | Allow NULL? |
| 9 | PARRE | Payer function for license | char | 1 | 0 | CHAR | (N' ') | Yes | | PARRE | Allow NULL? |
| 10 | PAREN | Ultimate consignee function for license | char | 1 | 0 | CHAR | (N' ') | Yes | | PAREN | Allow NULL? |
| 11 | PARR1 | Reserve_01 function for license | char | 1 | 0 | CHAR | (N' ') | Yes | | PARR1 | Allow NULL? |
| 12 | PARR2 | Reserve_02 function for license | char | 1 | 0 | CHAR | (N' ') | Yes | | PARR2 | Allow NULL? |
| 13 | PARR3 | Function of Reserve_03 for license | char | 1 | 0 | CHAR | (N' ') | Yes | | PARR3 | Allow NULL? |
| 14 | VBDNR | Affiliated company number | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T880 | VBDNR | Allow NULL? |
| 15 | VBDFG | Validity of export license for affiliated companies | char | 1 | 0 | CHAR | (N' ') | Yes | | VBDFG | Allow NULL? |