| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | XMLGUID | XML GUID | nvarchar | 35 | 0 | | | | Allow NULL? |
| 3 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 4 | VBELN | Sales Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | POSNR | Sales Document Item | nvarchar | 6 | 0 | | | | Allow NULL? |
| 6 | KDMAT | Material Number Used by Customer | nvarchar | 35 | 0 | | | | Allow NULL? |
| 7 | BP_KUNNR | Customer Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | BP_BUYID | Customer description of partner (plant, storage location) | nvarchar | 30 | 0 | | | | Allow NULL? |
| 9 | SHIP_FROM_BUYID | Customer description of partner (plant, storage location) | nvarchar | 30 | 0 | | | | Allow NULL? |
| 10 | WERKS | Plant (Own or External) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | KNREF | Customer description of partner (plant, storage location) | nvarchar | 30 | 0 | | | | Allow NULL? |
| 12 | WERKSTO | Plant (Own or External) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | BSTKD | Customer purchase order number | nvarchar | 35 | 0 | | | | Allow NULL? |
| 14 | POSEX | Item Number of the Underlying Purchase Order | nvarchar | 6 | 0 | | | | Allow NULL? |
| 15 | PROCTRIGGER | Processing Trigger (Automatically, Background, Manually) | char | 1 | 0 | | | | Allow NULL? |
| 16 | PROCTSTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 17 | STATUS | Processing Status | char | 1 | 0 | | | | Allow NULL? |
| 18 | STOPIND | Stop Indicator | char | 1 | 0 | | | | Allow NULL? |
| 19 | STATUSDT | DateTime | decimal | 15 | 0 | | | | |
| 20 | UNRQUAN | Unrestricted-Use Quantity | decimal | 15 | 3 | | | | |
| 21 | QUALQUAN | Quality Inspection Quantity | decimal | 15 | 3 | | | | |
| 22 | BLOCQUAN | Blocked Quantity | decimal | 15 | 3 | | | | |
| 23 | PROMOQUAN | Promotion Quantity | decimal | 15 | 3 | | | | |
| 24 | STATUSDT_C | DateTime | decimal | 15 | 0 | | | | |
| 25 | UNRQUAN_C | Unrestricted-Use Quantity Consignment | decimal | 15 | 3 | | | | |
| 26 | QUALQUAN_C | Quality Inspection Quantity Consignment | decimal | 15 | 3 | | | | |
| 27 | BLOCQUAN_C | Blocked Quantity Consignment | decimal | 15 | 3 | | | | |
| 28 | PROMOQUAN_C | Promotion Quantity Consignment | decimal | 15 | 3 | | | | |
| 29 | STOCKONHAND | Stock on Hand for Replenishment | decimal | 15 | 3 | | | | |
| 30 | MINSTOCK | Minimum Stock Level | decimal | 15 | 3 | | | | |
| 31 | MINSTOCK_C | Minimum Stock Level Consignment | decimal | 15 | 3 | | | | |
| 32 | MAXSTOCK | Maximum Stock Level | decimal | 15 | 3 | | | | |
| 33 | MAXSTOCK_C | Maximum Stock Level Consignment | decimal | 15 | 3 | | | | |
| 34 | ROUNDQUAN | Rounding Quantity | decimal | 15 | 3 | | | | |
| 35 | ROUNDQUAN_C | Rounding Quantity Consignment | decimal | 15 | 3 | | | | |
| 36 | PACKQUAN | Packing Quantity | decimal | 15 | 3 | | | | |
| 37 | ABEFZ | Cumulative Quantity Received by Customer | decimal | 15 | 3 | | | | |
| 38 | VRKME | Sales unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 39 | LABNK | Customer number for forecast / JIT dlv. sched. | nvarchar | 17 | 0 | | | | Allow NULL? |
| 40 | SCHEMAGNTID | Internal ID - Scheme Agency ID | nvarchar | 32 | 0 | | | | Allow NULL? |
| 41 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | | | Allow NULL? |
| 42 | ID | Supplier-Managed Inventory Replenishment Profile | nvarchar | 10 | 0 | | | | Allow NULL? |
| 43 | CUSTOMER_ID | Customer Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 44 | KDMAT_PROF | Material Number Used by Customer | nvarchar | 35 | 0 | | | | Allow NULL? |
| 45 | BSTKD_PROF | Customer purchase order number | nvarchar | 35 | 0 | | | | Allow NULL? |
| 46 | POSEX_PROF | Item Number of the Underlying Purchase Order | nvarchar | 6 | 0 | | | | Allow NULL? |
| 47 | WERKS_EXT | Customer description of partner (plant, storage location) | nvarchar | 30 | 0 | | | | Allow NULL? |
| 48 | HORIZON_USE | Horizon Usage Control Indicator | nvarchar | 2 | 0 | | | | Allow NULL? |
| 49 | SMI_HORIZON | Planning Horizon in Days | nvarchar | 4 | 0 | | | | Allow NULL? |
| 50 | REPL_METH | SMI Replenishment Method | char | 1 | 0 | | | | Allow NULL? |
| 51 | SAFETY_PERC | Safety Tolerance (%) | decimal | 4 | 1 | | | | |
| 52 | SAFETY_QTY | Safety Quantity | decimal | 13 | 6 | | | | |
| 53 | SFTY_QTY_UOM | Safety Level Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 54 | CUST_ROUND_VAL | Indicator for Usage of Customer Rounding Values | char | 1 | 0 | | | | Allow NULL? |
| 55 | REPL_PROC_LOGIC | Processing Trigger Replenishment (Autom., Batch, Manually) | char | 1 | 0 | | | | Allow NULL? |
| 56 | SEND_PROC_LOGIC | Processing Trigger Send (Autom., Batch, Manually) | char | 1 | 0 | | | | Allow NULL? |
| 57 | STOP_FLAG | Stop Processing Indicator | char | 1 | 0 | | | | Allow NULL? |
| 58 | SMI_HORIZON_S | Short-Term Period in Days | nvarchar | 2 | 0 | | | | Allow NULL? |
| 59 | SMI_HORIZON_M | Mid-Term Period in Days | nvarchar | 3 | 0 | | | | Allow NULL? |
| 60 | SMI_HORIZON_L | Long-Term Period in Days | nvarchar | 4 | 0 | | | | Allow NULL? |
| 61 | HIGH_PERC_S | Upper Tolerance (%) | decimal | 4 | 1 | | | | |
| 62 | LOW_PERC_S | Lower Tolerance (%) | decimal | 4 | 1 | | | | |
| 63 | HIGH_PERC_M | Upper Tolerance (%) | decimal | 4 | 1 | | | | |
| 64 | LOW_PERC_M | Lower Tolerance (%) | decimal | 4 | 1 | | | | |
| 65 | HIGH_PERC_L | Upper Tolerance (%) | decimal | 4 | 1 | | | | |
| 66 | LOW_PERC_L | Lower Tolerance (%) | decimal | 4 | 1 | | | | |
| 67 | ALERTCATEGORY | Alert Category | nvarchar | 30 | 0 | | | | Allow NULL? |
| 68 | COMP_LOGIC | SMI Comparison Logic Type | char | 1 | 0 | | | | Allow NULL? |
| 69 | VKORG | Sales Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 70 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | | | | Allow NULL? |
