| 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 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVTA | VKORG | Allow NULL? |
| 3 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVTA | VTWEG | Allow NULL? |
| 4 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVTA | SPART | Allow NULL? |
| 5 | POS_ART | IS-M: Order-Publishing-Media - Item Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | TJH17 | AVMPOS_ART | Allow NULL? |
| 6 | BEZKONDPR1 | IS-M: Condition Reference for Price Field 1 in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ83 | BEZKONDPR1 | Allow NULL? |
| 7 | DEDOKU_PR1 | IS-M: Supplementary Data Element Docum.for Price Field 1 | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | DEDOKU_PR1 | Allow NULL? |
| 8 | BEZKONDPR2 | IS-M/AM: Condition Reference for Price Field 2 in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ83 | BEZKONDPR2 | Allow NULL? |
| 9 | DEDOKU_PR2 | IS-M: Supplementary Data Element Doc. for Price Field 2 | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | DEDOKU_PR2 | Allow NULL? |
| 10 | BEZKONDPR3 | IS-M: Condition Reference for Price Field 3 in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ83 | ISM_BEZKONDPR3 | Allow NULL? |
| 11 | DEDOKU_PR3 | IS-M: Data Element Suppl.Documentation for Price Field 3 | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISM_DEDOKU_PR3 | Allow NULL? |
| 12 | BEZKONDPR4 | IS-M: Condition Reference for Price Field 4 in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ83 | ISM_BEZKONDPR4 | Allow NULL? |
| 13 | DEDOKU_PR4 | IS-M: Data Element Suppl.Documentation for Price Field 4 | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISM_DEDOKU_PR4 | Allow NULL? |
| 14 | BEZKONDPR5 | IS-M: Condition Reference for Price Field 5 in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ83 | ISM_BEZKONDPR5 | Allow NULL? |
| 15 | DEDOKU_PR5 | Data Element Supplementary Documentation for Price Field 5 | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISM_DEDOKU_PR5 | Allow NULL? |
| 16 | BEZKONDPR6 | IS-M: Condition Reference for Price Field 6 in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ83 | ISM_BEZKONDPR6 | Allow NULL? |
| 17 | DEDOKU_PR6 | IS-M: Data Element Suppl.Documentation for Price Field 6 | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISM_DEDOKU_PR6 | Allow NULL? |
| 18 | BEZKONDPR7 | IS-M: Condition Reference for Price Field 7 in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ83 | ISM_BEZKONDPR7 | Allow NULL? |
| 19 | DEDOKU_PR7 | IS-M: Data Element Suppl.Documentation for Price Field 7 | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISM_DEDOKU_PR7 | Allow NULL? |
| 20 | BEZKONDPR8 | IS-M: Condition Reference for Price Field 8 in the Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJJ83 | ISM_BEZKONDPR8 | Allow NULL? |
| 21 | DEDOKU_PR8 | IS-M: Data Element Suppl.Documentation for Price Field 8 | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISM_DEDOKU_PR8 | Allow NULL? |