| 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 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | VBUK | VBELN | Allow NULL? |
| 3 | POSNR | Item number of the SD document | nvarchar | 6 | 0 | NUMC | (N'000000') | No | VBUP | POSNR | Allow NULL? |
| 4 | GEGRU | Legal regulation for legal control | nvarchar | 2 | 0 | CHAR | (N' ') | No | T606G | GEGRU | Allow NULL? |
| 5 | ALNUM | Export control class according the legal reg. for legal ctrl | nvarchar | 14 | 0 | CHAR | (N' ') | No | T606H | ALNUM | Allow NULL? |
| 6 | EMBGR | Grouping for Legal Control | nvarchar | 14 | 0 | CHAR | (N' ') | No | T606B | EMBGR | Allow NULL? |
| 7 | GEART | License type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T606 | GEART | Allow NULL? |
| 8 | GENNR | Internal license number | nvarchar | 10 | 0 | CHAR | (N' ') | No | EMBK | GENNR | Allow NULL? |
| 9 | EXKUA | Exchange rate for export license on requested delivery date | decimal | 9 | 5 | DEC | ((0)) | No | | EXKUA | |
| 10 | EXWAE | Currency of export license | nvarchar | 5 | 0 | CUKY | (N' ') | No | * | EXWAE | Allow NULL? |
| 11 | MODCO | Indicator: Manual Change / by System for Export Control | char | 1 | 0 | CHAR | (N' ') | Yes | | MODCO | Allow NULL? |
| 12 | AHBAS | Basis document category for foreign trade processing | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | AHBAS | Allow NULL? |
| 13 | SECGK | Legal Control: Special Characteristics Code for Goods | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T606D | SECGK | Allow NULL? |