| 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 | * | MANDT | Allow NULL? |
| 2 | LAND1 | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | No | T005 | LAND1 | Allow NULL? |
| 3 | PWGGR | Grouping for cross-plant preference determination | nvarchar | 6 | 0 | CHAR | (N' ') | No | T604WG | PWGGR | Allow NULL? |
| 4 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 5 | KALK_ART | Preference: Indicator for determination type | char | 1 | 0 | CHAR | (N' ') | No | | P_KALKART | Allow NULL? |
| 6 | STLAN | BOM Usage | char | 1 | 0 | CHAR | (N' ') | Yes | T416 | STLAN | Allow NULL? |
| 7 | CAPID | Application | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TC04 | CAPID | Allow NULL? |
| 8 | STLAL | Alternative BOM | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | STLAL | Allow NULL? |
| 9 | RNDKZ | Indicator: Perform rounding | char | 1 | 0 | CHAR | (N' ') | Yes | | RNDKZ | Allow NULL? |
| 10 | SANFE | Indicator: item relevant to production | char | 1 | 0 | CHAR | (N' ') | Yes | | SANFE | Allow NULL? |
| 11 | SANKA | Indicator: item relevant to costing | char | 1 | 0 | CHAR | (N' ') | Yes | | SANKA | Allow NULL? |
| 12 | SANIN | Indicator: item relevant to plant maintenance | char | 1 | 0 | CHAR | (N' ') | Yes | | SANIN | Allow NULL? |
| 13 | SANKO | Indicator: item relevant to engineering | char | 1 | 0 | CHAR | (N' ') | Yes | | SANKO | Allow NULL? |
| 14 | RVREL | Indicator: item relevant to sales | char | 1 | 0 | CHAR | (N' ') | Yes | * | RVREL | Allow NULL? |
| 15 | PWLEN | Preference: Length of commodity code for position change | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PWLEN | Allow NULL? |
| 16 | PEINH | Price Unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | PEINH | |
| 17 | MDMPS | Preference: Indicator explode dummy assembly | char | 1 | 0 | CHAR | (N' ') | Yes | | P_MDMPS | Allow NULL? |
| 18 | PROZEN | Security percent | decimal | 5 | 2 | DEC | ((0)) | Yes | | P_PROZEN | |
| 19 | P_BET_A | Indicator: Purchase order tolerance check/Vendor declaration | char | 1 | 0 | CHAR | (N' ') | Yes | | P_BET_A | Allow NULL? |
| 20 | P_BETOL | PO tolerance for corresp./aggreg. for vendor declaration | decimal | 3 | 0 | DEC | ((0)) | Yes | | P_BETOL | |
| 21 | L_CUST | Preference: Issue customs log | char | 1 | 0 | CHAR | (N' ') | Yes | | P_CUSTOM | Allow NULL? |
| 22 | L_CONT | Preference: Issue control log | char | 1 | 0 | CHAR | (N' ') | Yes | | P_CONTROL | Allow NULL? |
| 23 | L_ERROR | Preference: Issue error log | char | 1 | 0 | CHAR | (N' ') | Yes | | P_ERROR | Allow NULL? |
| 24 | L_DATA | Preference: Issue flow trace | char | 1 | 0 | CHAR | (N' ') | Yes | | P_DATALOG | Allow NULL? |
| 25 | KALK_AUTO | Preference: Perform Calculation in Export Order | char | 1 | 0 | CHAR | (N' ') | Yes | | P_KALKAUTO | Allow NULL? |
