/SCMB/SPLRALR - Alerts
Alerts information is stored in SAP table /SCMB/SPLRALR.
It is part of development package /SCMB/SPLREP in software component SCM-BAS-SCR. This development package consists of objects that can be grouped under "Reporting Functions for Spares Logistics".
It is part of development package /SCMB/SPLREP in software component SCM-BAS-SCR. This development package consists of objects that can be grouped under "Reporting Functions for Spares Logistics".
Fields for table /SCMB/SPLRALR
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| .INCLUDE | X | /SCMB/SPLR_KEYS_ALR | 0 | |||
| GUID_ALR | Alert ID | X | /SCMB/AID | RAW | 16 | |
| TYPE_REF_PERI | Type of Reporting Period | X | /SCMB/SPLR_TYPE_REF_PERI | CHAR | 2 | |
| .INCLUDE | /SCMB/SPLR_RAWS_ALR | 0 | ||||
| DISP_ALR | External Alert Number | /SCMB/SPLR_DISP_ALR | NUMC | 40 | ||
| TYPE_ALR | Alert Type | /SCMB/ATID | NUMC | 8 | ||
| GUID_SUP | Supplier (GUID) | /SCMB/SPLR_GUID_SUP | RAW | 16 | ||
| DISP_SUP | Vendor | /SCMB/SPLR_DISP_SUP | CHAR | 20 | ||
| GUID_SPT | Customer Location (GUID) | /SCMB/SPLR_GUID_SPT | RAW | 16 | ||
| DISP_SPT | Customer Location | /SCMB/SPLR_DISP_SPT | CHAR | 40 | ||
| GUID_GRL | Ship-To Location (GUID) | /SCMB/SPLR_GUID_GRL | RAW | 16 | ||
| DISP_GRL | Ship-To Location | /SCMB/SPLR_DISP_GRL | CHAR | 40 | ||
| GUID_SUL | Ship-From Location (GUID) | /SCMB/SPLR_GUID_SUL | RAW | 16 | ||
| DISP_SUL | Ship-From Location | /SCMB/SPLR_DISP_SUL | CHAR | 40 | ||
| GUID_PRO | Product (GUID) | /SCMB/SPLR_GUID_PRO | RAW | 16 | ||
| DISP_PRO | Product | /SCMB/SPLR_DISP_PRO | CHAR | 80 | ||
| DISP_PRO_SUPP | Product Number of Assigned Partner | /SCMB/SPLR_DISP_PRO_SUPP | CHAR | 80 | ||
| GUID_BPA | Customer (GUID) | /SCMB/SPLR_GUID_BPA | RAW | 16 | ||
| DISP_BPA | Customer | /SCMB/SPLR_DISP_BPA | CHAR | 20 | ||
| DISP_SCH_ITEM | Release Number | /SCMB/SPLR_DISP_SCH_ITEM | CHAR | 70 | ||
| DISP_SCH_LINE | Delivery Schedule Line | /SCMB/SPLR_DISP_SCH_LINE | CHAR | 20 | ||
| DISP_SCA | Scheduling Agreement | /SCMB/SPLR_DISP_SCA | CHAR | 70 | ||
| DISP_SCA_ITEM | Scheduling Agreement Item | /SCMB/SPLR_DISP_SCA_ITEM | CHAR | 20 | ||
| DISP_SOR | Sales Order Number | /SCMB/SPLR_DISP_SOR | CHAR | 70 | ||
| DISP_SOR_ITEM | Sales Order Item | /SCMB/SPLR_DISP_SOR_ITEM | CHAR | 20 | ||
| DISP_DLV | ASN Number | /SCMB/SPLR_DISP_DLV | CHAR | 70 | ||
| DISP_DLV_ITEM | ASN Item | /SCMB/SPLR_DISP_DLV_ITEM | CHAR | 20 | ||
| GUID_DLV | Advanced Shipping Notification (GUID) | /SCMB/SPLR_GUID_DLV | RAW | 16 | ||
| GUID_DLV_ITEM | Advanced Shipping Notification (GUID) | /SCMB/SPLR_GUID_DLV_ITEM | RAW | 16 | ||
| GUID_POR | Purchase Order (GUID) | /SCMB/SPLR_GUID_POR | RAW | 16 | ||
| DISP_POR | Purchase Order Number | /SCMB/SPLR_DISP_POR | CHAR | 70 | ||
| GUID_POR_ITEM | Purchase Order Item (GUID) | /SCMB/SPLR_GUID_POR_ITEM | RAW | 16 | ||
| DISP_POR_ITEM | Purchase Order Item No. | /SCMB/SPLR_DISP_POR_ITEM | CHAR | 20 | ||
| DISP_POR_LINE | Order Item Schedule Line | /SCMB/SPLR_DISP_POR_LINE | CHAR | 20 | ||
| TYPE_DLV | Delivery Type | /SCMB/SPLR_TYPE_DLV | CHAR | 6 | ||
| TYPE_PRO_PRIO | Delivery Priority | /SCMB/SPLR_PRIO_DLV | CHAR | 2 | ||
| QUAN_PRO_RECV | Quantity of Goods Received | /SCMB/SPLR_QUAN_PRO_RECV | QUAN | 10 | ||
| QUAN_PRO_REQU | Purchase Order Quantity | /SCMB/SPLR_QUAN_PRO_REQU | QUAN | 10 | ||
| QUAN_PRO_UNIT | Unit of Measure | /SCMB/SPLR_QUAN_PRO_UNIT | UNIT | 6 | * | |
| DATI_PRO_SHIP | Goods Issue Date | /SCMB/SPLR_DATI_PRO_SHIP | DEC | 8 | ||
| DATI_PRO_RECV | Goods Receipt Date | /SCMB/SPLR_DATI_PRO_RECV | DEC | 8 | ||
| DATI_DOC_SEND | Send Time of Document | /SCMB/SPLR_DATI_DOC_SEND | DEC | 8 | ||
| DATI_DOC_ARES | Latest Possible Reaction Time of Alert | /SCMB/SPLR_DATI_DOC_ARES | DEC | 8 | ||
| DATI_DOC_CRES | Alert Reply Time | /SCMB/SPLR_DATI_DOC_CRES | DEC | 8 | ||
| TYPE_ALR_METR | Metric Category for Problem Reports | /SCMB/SPLR_TYPE_ALR_METR | CHAR | 6 | * | |
| RATE_SUB | Points Deducted from Supplier | /SCMB/SPLR_RATE_SUB | INT4 | 4 | ||
| DATI_DOC_SDPR | Supplier Delivery Performance Rating Time | /SCMB/SPLR_DATI_PRO_SDPR | DEC | 8 | ||
| CALE_DOC_SDPR | Calendar for Supplier Delivery Performance Rating Time | /SCMB/SPLR_CALE | CHAR | 20 | * | |
| TYPE_ALR_PRBL | Problem Report Type | /SCMB/SPLR_TYPE_ALR_PRBL | CHAR | 6 | ||
| .INCLUDE | /SCMB/SPLR_COMP_ALR | 0 | ||||
| TYPE_SNC | Rule Compliance of Supplier Response | /SCMB/SPLR_TYPE_SNC | CHAR | 4 | ||
| TYPE_REC_HIIN | Counter for Total | /SCMB/SPLR_TYPE_REC_HIIN | INT1 | 1 | ||
| DISP_REF | Reporting Period | /SCMB/SPLR_DISP_REF | CHAR | 14 | ||
| DISP_REF_NC6 | Reporting Period | /SCMB/SPLR_DISP_REF_NC6 | NUMC | 12 | ||
| TYPE_REF_PERV | Period Variant of Reporting Period | /SCMB/SPLR_TYPE_REF_PERV | CHAR | 4 | * | |
| .INCLUDE | /SCMB/SPLR_ADMN_ALR | 0 | ||||
| TYPE_REC_DOIT | Include Row in Evaluation | /SCMB/SPLR_TYPE_REC_DOIT | CHAR | 2 | ||
| FLAG_REC_CRES | Missing Supplier Answer | /SCMB/SPLR_FLAG_REC_CRES | CHAR | 2 | ||
| TYPE_REC_SDPR | SDPR Calculated for this Element | /SCMB/SPLR_TYPE_REC_SDPR | CHAR | 2 | ||
| TYPE_REC_MANC | Manual Changes Exist | /SCMB/SPLR_TYPE_REC_MANC | CHAR | 2 | ||
| TYPE_ORIGIN | Origin of data in SDPR | /SCMB/SPLR_ORIGIN | CHAR | 2 | ||
| .INCLUDE | /SCMB/SPLR_CHNG_REC | 0 | ||||
| DATI_REC_CHNG | Changed On | /SCMB/SPLR_DATI_REC_CHNG | DEC | 8 | ||
| FLAG_REC_DELE | Deletion Indicator | /SCMB/SPLR_FLAG_REC_DELE | CHAR | 2 | ||
| DISP_REC_USER | User Name | SYUNAME | CHAR | 24 |