/SCMB/SPLRQALR - Alerts Queue
Alerts Queue information is stored in SAP table /SCMB/SPLRQALR.
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/SPLRQALR
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | |
.INCLUDE | X | /SCMB/SPLR_KEYS_Q | 0 | |||
LINE_REC_QUEU | Queue Entry ID | X | /SCMB/SPLR_LINE_REC_QUEU | NUMC | 32 | |
.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 | ||
.INCLUDE | /SCMB/SPLR_ADMN_Q | 0 | ||||
DATI_REC_QUEU | Time Added | /SCMB/SPLR_DATI_REC_QUEU | DEC | 8 | ||
TYPE_REC_QUEU | Type of Queue Entry | /SCMB/SPLR_TYPE_REC_QUEUE | CHAR | 2 |