| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TZONE | Time Zone | nvarchar | 6 | 0 | | | | Allow NULL? |
| 3 | TSTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 4 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 5 | LAND1 | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | PWGGR | Grouping for cross-plant preference determination | nvarchar | 6 | 0 | | | | Allow NULL? |
| 7 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | GZOLX | Preference zone | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | REGEL | Normal preference determination rule | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | LFDNR | Sequence number for the check rule | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | VERFA | Preference determination procedure | nvarchar | 5 | 0 | | | | Allow NULL? |
| 12 | BEZEI | Description | nvarchar | 20 | 0 | | | | Allow NULL? |
| 13 | XPW | ID: Classification change - Preference determination | char | 1 | 0 | | | | Allow NULL? |
| 14 | XOPW | ID preference determination without item change | char | 1 | 0 | | | | Allow NULL? |
| 15 | XDRITTL | ID for third country share for preference determination | char | 1 | 0 | | | | Allow NULL? |
| 16 | XEU | ID: Value - European Union preference determination | char | 1 | 0 | | | | Allow NULL? |
| 17 | XHSPOS | ID for HS item preference determination | char | 1 | 0 | | | | Allow NULL? |
| 18 | HSPOS | Commodity code (8 digits) preference | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | OPCODE | Operation code preference | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | PROZP | Percentage preference determination | decimal | 5 | 2 | | | | |
| 21 | KP | Price | decimal | 11 | 2 | | | | |
| 22 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 23 | GEWIN | Preference determination - Archiving - Profit Rule | char | 1 | 0 | | | | Allow NULL? |