| 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 | XMLGUID | XML GUID | nvarchar | 35 | 0 | CHAR | (N' ') | No | SMI_HEADER | SMI_XMLGUID | Allow NULL? |
| 3 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | * | MATNR | Allow NULL? |
| 4 | VBELN | Sales Document | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | VBELN_VA | Allow NULL? |
| 5 | POSNR | Sales Document Item | nvarchar | 6 | 0 | NUMC | (N'000000') | No | * | POSNR_VA | Allow NULL? |
| 6 | KDMAT | Material Number Used by Customer | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | MATNR_KU | Allow NULL? |
| 7 | BP_KUNNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNNR | Allow NULL? |
| 8 | BP_BUYID | Customer description of partner (plant, storage location) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | KNREF | Allow NULL? |
| 9 | SHIP_FROM_BUYID | Customer description of partner (plant, storage location) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | KNREF | Allow NULL? |
| 10 | WERKS | Plant (Own or External) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_EXT | Allow NULL? |
| 11 | KNREF | Customer description of partner (plant, storage location) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | KNREF | Allow NULL? |
| 12 | WERKSTO | Plant (Own or External) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_EXT | Allow NULL? |
| 13 | BSTKD | Customer purchase order number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BSTKD | Allow NULL? |
| 14 | POSEX | Item Number of the Underlying Purchase Order | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | POSEX | Allow NULL? |
| 15 | PROCTRIGGER | Processing Trigger (Automatically, Background, Manually) | char | 1 | 0 | CHAR | (N' ') | Yes | | SMI_PROCTRIG | Allow NULL? |
| 16 | PROCTSTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TZNTSTMPS | |
| 17 | STATUS | Processing Status | char | 1 | 0 | CHAR | (N' ') | Yes | | SMI_STATUS | Allow NULL? |
| 18 | STOPIND | Stop Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SMI_STOPIND | Allow NULL? |
| 19 | STATUSDT | DateTime | decimal | 15 | 0 | DEC | ((0)) | Yes | | SMI_STATUSDT | |
| 20 | UNRQUAN | Unrestricted-Use Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMI_UNRQUAN | |
| 21 | QUALQUAN | Quality Inspection Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMI_QUALQUAN | |
| 22 | BLOCQUAN | Blocked Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMI_BLOCQUAN | |
| 23 | PROMOQUAN | Promotion Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMI_PROMOQUAN | |
| 24 | STATUSDT_C | DateTime | decimal | 15 | 0 | DEC | ((0)) | Yes | | SMI_STATUSDT | |
| 25 | UNRQUAN_C | Unrestricted-Use Quantity Consignment | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMI_UNRQUAN_C | |
| 26 | QUALQUAN_C | Quality Inspection Quantity Consignment | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMI_QUALQUAN_C | |
| 27 | BLOCQUAN_C | Blocked Quantity Consignment | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMI_BLOCQUAN_C | |
| 28 | PROMOQUAN_C | Promotion Quantity Consignment | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMI_PROMOQUAN_C | |
| 29 | STOCKONHAND | Stock on Hand for Replenishment | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMI_STOCKONHAND | |
| 30 | MINSTOCK | Minimum Stock Level | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMI_MINSTOCK | |
| 31 | MINSTOCK_C | Minimum Stock Level Consignment | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMI_MINSTOCK_C | |
| 32 | MAXSTOCK | Maximum Stock Level | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMI_MAXSTOCK | |
| 33 | MAXSTOCK_C | Maximum Stock Level Consignment | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMI_MAXSTOCK_C | |
| 34 | ROUNDQUAN | Rounding Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMI_ROUNDQUAN | |
| 35 | ROUNDQUAN_C | Rounding Quantity Consignment | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMI_ROUNDQUAN_C | |
| 36 | PACKQUAN | Packing Quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMI_PACKQUAN | |
| 37 | ABEFZ | Cumulative Quantity Received by Customer | decimal | 15 | 3 | QUAN | ((0)) | Yes | | ABKFZ | |
| 38 | VRKME | Sales unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | VRKME | Allow NULL? |
| 39 | LABNK | Customer number for forecast / JIT dlv. sched. | nvarchar | 17 | 0 | CHAR | (N' ') | Yes | | LABNK | Allow NULL? |
| 40 | SCHEMAGNTID | Internal ID - Scheme Agency ID | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | SMI_SCAGNTID | Allow NULL? |
| 41 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | TIMEZONE | Allow NULL? |
| 42 | ID | Supplier-Managed Inventory Replenishment Profile | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SMI_PROFILE_ID | Allow NULL? |
| 43 | CUSTOMER_ID | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNNR | Allow NULL? |
| 44 | KDMAT_PROF | Material Number Used by Customer | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | MATNR_KU | Allow NULL? |
| 45 | BSTKD_PROF | Customer purchase order number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BSTKD | Allow NULL? |
| 46 | POSEX_PROF | Item Number of the Underlying Purchase Order | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | POSEX | Allow NULL? |
| 47 | WERKS_EXT | Customer description of partner (plant, storage location) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | KNREF | Allow NULL? |
| 48 | HORIZON_USE | Horizon Usage Control Indicator | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SMI_HORIZON_USE | Allow NULL? |
| 49 | SMI_HORIZON | Planning Horizon in Days | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | SMI_HORIZON | Allow NULL? |
| 50 | REPL_METH | SMI Replenishment Method | char | 1 | 0 | CHAR | (N' ') | Yes | | SMI_REPL_METH | Allow NULL? |
| 51 | SAFETY_PERC | Safety Tolerance (%) | decimal | 4 | 1 | DEC | ((0)) | Yes | | SMI_SAFETY_PERC | |
| 52 | SAFETY_QTY | Safety Quantity | decimal | 13 | 6 | QUAN | ((0)) | Yes | | SMI_SAFETY_QTY | |
| 53 | SFTY_QTY_UOM | Safety Level Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | SMI_SAFETY_UOM | Allow NULL? |
| 54 | CUST_ROUND_VAL | Indicator for Usage of Customer Rounding Values | char | 1 | 0 | CHAR | (N' ') | Yes | | SMI_CUST_ROUNDING_VAL | Allow NULL? |
| 55 | REPL_PROC_LOGIC | Processing Trigger Replenishment (Autom., Batch, Manually) | char | 1 | 0 | CHAR | (N' ') | Yes | | SMI_PROCTRIG_REPL | Allow NULL? |
| 56 | SEND_PROC_LOGIC | Processing Trigger Send (Autom., Batch, Manually) | char | 1 | 0 | CHAR | (N' ') | Yes | | SMI_PROCTRIG_SEND | Allow NULL? |
| 57 | STOP_FLAG | Stop Processing Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SMI_STOP_FLAG | Allow NULL? |
| 58 | SMI_HORIZON_S | Short-Term Period in Days | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SMI_HORIZON_SHORT | Allow NULL? |
| 59 | SMI_HORIZON_M | Mid-Term Period in Days | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | SMI_HORIZON_MID | Allow NULL? |
| 60 | SMI_HORIZON_L | Long-Term Period in Days | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | SMI_HORIZON_HIGH | Allow NULL? |
| 61 | HIGH_PERC_S | Upper Tolerance (%) | decimal | 4 | 1 | DEC | ((0)) | Yes | | SMI_HIGH_PERC | |
| 62 | LOW_PERC_S | Lower Tolerance (%) | decimal | 4 | 1 | DEC | ((0)) | Yes | | SMI_LOW_PERC | |
| 63 | HIGH_PERC_M | Upper Tolerance (%) | decimal | 4 | 1 | DEC | ((0)) | Yes | | SMI_HIGH_PERC | |
| 64 | LOW_PERC_M | Lower Tolerance (%) | decimal | 4 | 1 | DEC | ((0)) | Yes | | SMI_LOW_PERC | |
| 65 | HIGH_PERC_L | Upper Tolerance (%) | decimal | 4 | 1 | DEC | ((0)) | Yes | | SMI_HIGH_PERC | |
| 66 | LOW_PERC_L | Lower Tolerance (%) | decimal | 4 | 1 | DEC | ((0)) | Yes | | SMI_LOW_PERC | |
| 67 | ALERTCATEGORY | Alert Category | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | SALRTDCAT | Allow NULL? |
| 68 | COMP_LOGIC | SMI Comparison Logic Type | char | 1 | 0 | CHAR | (N' ') | Yes | | SMI_COMP_LOGIC | Allow NULL? |
| 69 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VKORG | Allow NULL? |
| 70 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | VTWEG | Allow NULL? |
