| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 3 | PLANT | Plant Key for Global Trade Services | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | LGREG | Legal Regulation for Legal Control for GTS | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | DATBI | Date - Valid To - For GTS | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | DATAB | Date - Valid From - For GTS | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | PRFTY | Type of Preference Data in Material Master Record | char | 1 | 0 | | | | Allow NULL? |
| 8 | PRMET | Preference: Comparison Method for GTS | char | 1 | 0 | | | | Allow NULL? |
| 9 | PREFE | Preference: Preference Indicator for GTS | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | QUANT | Quantity as Floating Point Field for GTS | float | 15 | 16 | | | | |
| 11 | QUAUM | Unit of Measure of Dimension for GTS | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | VALCP | Preferential Threshold Value for Preference for GTS | float | 15 | 16 | | | | |
| 13 | VALOR | Positive Portion for Preference for GTS | float | 15 | 16 | | | | |
| 14 | VALNO | Negative Portion for Preference for GTS | float | 15 | 16 | | | | |
| 15 | VALRB | RVC Benefit for Designated Intermediate Materials for Pref. | float | 15 | 16 | | | | |
| 16 | VLCUR | Currency of a Value for Legal and Logistics Services | nvarchar | 5 | 0 | | | | Allow NULL? |
| 17 | PURLA | Preferential Country of Origin for GTS | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | ERNAM | Name of Person Who Created Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 19 | CRTSP | Time Stamp on Which Object Was Added | decimal | 15 | 0 | | | | |
| 20 | AENAM | Name of Person Responsible for Changing Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 21 | CHTSP | Time Stamp on Which Object Was Changed | decimal | 15 | 0 | | | | |