| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client ID | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | SYMANDT | Allow NULL? |
| 2 | ID | Supplier-Managed Inventory Replenishment Profile | nvarchar | 10 | 0 | CHAR | (N' ') | No | | SMI_PROFILE_ID | Allow NULL? |
| 3 | ACTIVE_FLAG | Profile is Active | char | 1 | 0 | CHAR | (N' ') | Yes | | SMI_PROFILE_ACTIVE | Allow NULL? |
| 4 | NAME | Text Field | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | TEXT50 | Allow NULL? |
| 5 | CUSTOMER_ID | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SMI_AGREEMENTS | KUNNR | Allow NULL? |
| 6 | KDMAT | Material Number Used by Customer | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | SMI_AGREEMENTS | MATNR_KU | Allow NULL? |
| 7 | BSTKD | Customer purchase order number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BSTKD | Allow NULL? |
| 8 | POSEX | Item Number of the Underlying Purchase Order | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | POSEX | Allow NULL? |
| 9 | WERKS_EXT | Customer description of partner (plant, storage location) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | SMI_AGREEMENTS | KNREF | Allow NULL? |
| 10 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 11 | VBELN | Sales Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VBELN_VA | Allow NULL? |
| 12 | POSNR | Sales Document Item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | POSNR_VA | Allow NULL? |
| 13 | SOBKZ | Special Stock Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | * | SOBKZ | Allow NULL? |
| 14 | STOP_HORIZON | Stop Horizon in Days | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | SMI_STOP_HORIZON | Allow NULL? |
| 15 | REPL_METH | SMI Replenishment Method | char | 1 | 0 | CHAR | (N' ') | Yes | | SMI_REPL_METH | Allow NULL? |
| 16 | SAFETY_PERC | Safety Tolerance (%) | decimal | 4 | 1 | DEC | ((0)) | Yes | | SMI_SAFETY_PERC | |
| 17 | SAFETY_QTY | Safety Quantity | decimal | 13 | 6 | QUAN | ((0)) | Yes | | SMI_SAFETY_QTY | |
| 18 | SFTY_QTY_UOM | Safety Level Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | SMI_SAFETY_UOM | Allow NULL? |
| 19 | CUST_ROUND_VAL | Indicator for Usage of Customer Rounding Values | char | 1 | 0 | CHAR | (N' ') | Yes | | SMI_CUST_ROUNDING_VAL | Allow NULL? |
| 20 | REPL_PROC_LOGIC | Processing Trigger Replenishment (Autom., Batch, Manually) | char | 1 | 0 | CHAR | (N' ') | Yes | | SMI_PROCTRIG_REPL | Allow NULL? |
| 21 | SEND_PROC_LOGIC | Processing Trigger Send (Autom., Batch, Manually) | char | 1 | 0 | CHAR | (N' ') | Yes | | SMI_PROCTRIG_SEND | Allow NULL? |
| 22 | STOP_FLAG | Stop Processing Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SMI_STOP_FLAG | Allow NULL? |
| 23 | COMP_LOGIC | SMI Comparison Logic Type | char | 1 | 0 | CHAR | (N' ') | Yes | | SMI_COMP_LOGIC | Allow NULL? |
| 24 | SMI_HORIZON_S | Short-Term Period in Days | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SMI_HORIZON_SHORT | Allow NULL? |
| 25 | SMI_HORIZON_M | Mid-Term Period in Days | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | SMI_HORIZON_MID | Allow NULL? |
| 26 | SMI_HORIZON_L | Long-Term Period in Days | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | SMI_HORIZON_HIGH | Allow NULL? |
| 27 | HIGH_PERC_S | Upper Tolerance (%) | decimal | 4 | 1 | DEC | ((0)) | Yes | | SMI_HIGH_PERC | |
| 28 | LOW_PERC_S | Lower Tolerance (%) | decimal | 4 | 1 | DEC | ((0)) | Yes | | SMI_LOW_PERC | |
| 29 | HIGH_PERC_M | Upper Tolerance (%) | decimal | 4 | 1 | DEC | ((0)) | Yes | | SMI_HIGH_PERC | |
| 30 | LOW_PERC_M | Lower Tolerance (%) | decimal | 4 | 1 | DEC | ((0)) | Yes | | SMI_LOW_PERC | |
| 31 | HIGH_PERC_L | Upper Tolerance (%) | decimal | 4 | 1 | DEC | ((0)) | Yes | | SMI_HIGH_PERC | |
| 32 | LOW_PERC_L | Lower Tolerance (%) | decimal | 4 | 1 | DEC | ((0)) | Yes | | SMI_LOW_PERC | |
| 33 | ALERTCATEGORY | Alert Category | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | SALRTCAT | SALRTDCAT | Allow NULL? |
| 34 | CREATOR | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 35 | CHANGER | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 36 | CREATED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TZNTSTMPS | |
| 37 | CHANGED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TZNTSTMPS | |
