| 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 | | GEART | Allow NULL? |
| 4 | KNDSP | Validity for specific customers for Legal Control | char | 1 | 0 | CHAR | (N' ') | No | | KNDSP | Allow NULL? |
| 5 | MATSP | Validity for specif. export control class for Legal Control | char | 1 | 0 | CHAR | (N' ') | No | | MATSP | Allow NULL? |
| 6 | SEDSP | AERP/SED: Relevance for AERP/SED message, NAFTA | char | 1 | 0 | CHAR | (N' ') | No | | SEDSP | Allow NULL? |
| 7 | SEDIM | AERP/SED: Official code for type of control master record | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SEDIM | Allow NULL? |
| 8 | HWTSP | Legal Control: Max. Export License Indicator | char | 1 | 0 | CHAR | (N' ') | No | | HWTSP | Allow NULL? |
| 9 | LNDCO | Validity for specific ctries of destination for Legal Contrl | char | 1 | 0 | CHAR | (N' ') | No | | LNDCO | Allow NULL? |
| 10 | EXACO | Validity for specific bus.trans.type for Legal Control | char | 1 | 0 | CHAR | (N' ') | No | | EXACO | Allow NULL? |
| 11 | EXTRA | Relevance for EXTRASTAT Declaration | char | 1 | 0 | CHAR | (N' ') | Yes | | EXAKO | Allow NULL? |
| 12 | KOBRA | Relevance for KOBRA Declaration | char | 1 | 0 | CHAR | (N' ') | Yes | | KOBKO | Allow NULL? |
| 13 | KURST | Exchange Rate Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCURV | KURST_CURR | Allow NULL? |
| 14 | TRMCO | Validity of specific term of payment for export control | char | 1 | 0 | CHAR | (N' ') | Yes | | TRMCO | Allow NULL? |
| 15 | TXTGR | Text determination procedure | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TTXG | TXTGR | Allow NULL? |
| 16 | PRZCO | Max. value excess in percent for Legal Control | char | 1 | 0 | CHAR | (N' ') | Yes | | PRZCO | Allow NULL? |
| 17 | ANZCO | Legal Control: Quantity update indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ANZCO | Allow NULL? |
| 18 | AMILI | Indicator for exclusively military use | char | 1 | 0 | CHAR | (N' ') | Yes | | AMILI | Allow NULL? |
| 19 | ADITI | Additive check for several partner functions | char | 1 | 0 | CHAR | (N' ') | Yes | | ADITI | Allow NULL? |
| 20 | BELSP | Validity for specific sales documents for export control | char | 1 | 0 | CHAR | (N' ') | Yes | | BELSP | Allow NULL? |
| 21 | VBDSP | Valid only for affiliated companies for export | char | 1 | 0 | CHAR | (N' ') | Yes | | VBDSP | Allow NULL? |
| 22 | MATCO | Validity for specific materials for legal control | char | 1 | 0 | CHAR | (N' ') | Yes | | MATCO | Allow NULL? |
| 23 | COICO | Validity for specif. import code nos for legal control | char | 1 | 0 | CHAR | (N' ') | Yes | | COICO | Allow NULL? |
| 24 | LIFCO | Validity for specif. vendors for legal control | char | 1 | 0 | CHAR | (N' ') | Yes | | LIFCO | Allow NULL? |
| 25 | SHCCO | Indicator: Active Special Characteristics Code for Goods | char | 1 | 0 | CHAR | (N' ') | Yes | | SHCCO | Allow NULL? |