| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client ID | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ID | Supplier-Managed Inventory Replenishment Profile | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | ACTIVE_FLAG | Profile is Active | char | 1 | 0 | | | | Allow NULL? |
| 4 | NAME | Text Field | nvarchar | 50 | 0 | | | | Allow NULL? |
| 5 | CUSTOMER_ID | Customer Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | KDMAT | Material Number Used by Customer | nvarchar | 35 | 0 | | | | Allow NULL? |
| 7 | BSTKD | Customer purchase order number | nvarchar | 35 | 0 | | | | Allow NULL? |
| 8 | POSEX | Item Number of the Underlying Purchase Order | nvarchar | 6 | 0 | | | | Allow NULL? |
| 9 | WERKS_EXT | Customer description of partner (plant, storage location) | nvarchar | 30 | 0 | | | | Allow NULL? |
| 10 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 11 | VBELN | Sales Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | POSNR | Sales Document Item | nvarchar | 6 | 0 | | | | Allow NULL? |
| 13 | SOBKZ | Special Stock Indicator | char | 1 | 0 | | | | Allow NULL? |
| 14 | STOP_HORIZON | Stop Horizon in Days | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | REPL_METH | SMI Replenishment Method | char | 1 | 0 | | | | Allow NULL? |
| 16 | SAFETY_PERC | Safety Tolerance (%) | decimal | 4 | 1 | | | | |
| 17 | SAFETY_QTY | Safety Quantity | decimal | 13 | 6 | | | | |
| 18 | SFTY_QTY_UOM | Safety Level Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | CUST_ROUND_VAL | Indicator for Usage of Customer Rounding Values | char | 1 | 0 | | | | Allow NULL? |
| 20 | REPL_PROC_LOGIC | Processing Trigger Replenishment (Autom., Batch, Manually) | char | 1 | 0 | | | | Allow NULL? |
| 21 | SEND_PROC_LOGIC | Processing Trigger Send (Autom., Batch, Manually) | char | 1 | 0 | | | | Allow NULL? |
| 22 | STOP_FLAG | Stop Processing Indicator | char | 1 | 0 | | | | Allow NULL? |
| 23 | COMP_LOGIC | SMI Comparison Logic Type | char | 1 | 0 | | | | Allow NULL? |
| 24 | SMI_HORIZON_S | Short-Term Period in Days | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | SMI_HORIZON_M | Mid-Term Period in Days | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | SMI_HORIZON_L | Long-Term Period in Days | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | HIGH_PERC_S | Upper Tolerance (%) | decimal | 4 | 1 | | | | |
| 28 | LOW_PERC_S | Lower Tolerance (%) | decimal | 4 | 1 | | | | |
| 29 | HIGH_PERC_M | Upper Tolerance (%) | decimal | 4 | 1 | | | | |
| 30 | LOW_PERC_M | Lower Tolerance (%) | decimal | 4 | 1 | | | | |
| 31 | HIGH_PERC_L | Upper Tolerance (%) | decimal | 4 | 1 | | | | |
| 32 | LOW_PERC_L | Lower Tolerance (%) | decimal | 4 | 1 | | | | |
| 33 | ALERTCATEGORY | Alert Category | nvarchar | 30 | 0 | | | | Allow NULL? |
| 34 | CREATOR | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 35 | CHANGER | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 36 | CREATED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 37 | CHANGED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
