/SCMB/SPLRQDLV - ASN Queue
ASN Queue information is stored in SAP table /SCMB/SPLRQDLV.
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/SPLRQDLV
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_DLV | 0 | |||
GUID_DLV | Advanced Shipping Notification (GUID) | X | /SCMB/SPLR_GUID_DLV | RAW | 16 | |
GUID_DLV_ITEM | Advanced Shipping Notification (GUID) | X | /SCMB/SPLR_GUID_DLV_ITEM | RAW | 16 | |
TYPE_REF_PERI | Type of Reporting Period | X | /SCMB/SPLR_TYPE_REF_PERI | CHAR | 2 | |
.INCLUDE | /SCMB/SPLR_RAWS_DLV | 0 | ||||
DISP_DLV | ASN Number | /SCMB/SPLR_DISP_DLV | CHAR | 70 | ||
DISP_DLV_ITEM | ASN Item | /SCMB/SPLR_DISP_DLV_ITEM | CHAR | 20 | ||
DISP_PDL | Number of Split ASN | /SCMB/SPLR_DISP_PDL | CHAR | 70 | ||
DISP_PDL_ITEM | Higher-Level Shipping Notification Item | /SCMB/SPLR_DISP_PDL_ITEM | CHAR | 20 | ||
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_SUL | Ship-From Location (GUID) | /SCMB/SPLR_GUID_SUL | RAW | 16 | ||
DISP_SUL | Ship-From Location | /SCMB/SPLR_DISP_SUL | 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_SCH | Scheduling Agreement Release (GUID) | /SCMB/SPLR_GUID_SCH | RAW | 16 | ||
GUID_SCH_ITEM | Scheduling Agreement Release Item (GUID) | /SCMB/SPLR_GUID_SCH_ITEM | RAW | 16 | ||
DISP_SCH_ITEM | Release Number | /SCMB/SPLR_DISP_SCH_ITEM | CHAR | 70 | ||
DISP_SCA | Scheduling Agreement | /SCMB/SPLR_DISP_SCA | CHAR | 70 | ||
DISP_SCA_ITEM | Scheduling Agreement Item | /SCMB/SPLR_DISP_SCA_ITEM | CHAR | 20 | ||
GUID_SCO | Supplier Confirmation (GUID) | /SCMB/SPLR_GUID_SCO | RAW | 16 | ||
DISP_SCO | Supplier Confirmation | /SCMB/SPLR_DISP_SCO | CHAR | 70 | ||
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_BLP | Bill-To Party (GUID) | /SCMB/SPLR_GUID_BLP | RAW | 16 | ||
DISP_BLP | Bill-To Party | /SCMB/SPLR_DISP_BLP | CHAR | 20 | ||
GUID_BPA | Customer (GUID) | /SCMB/SPLR_GUID_BPA | RAW | 16 | ||
DISP_BPA | Customer | /SCMB/SPLR_DISP_BPA | CHAR | 20 | ||
GUID_BPG | Goods Recipient (GUID) | /SCMB/SPLR_GUID_BPG | RAW | 16 | ||
DISP_BPG | Goods Recipient | /SCMB/SPLR_DISP_BPG | 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 | ||
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 | ||
QUAN_PRO | Schedule Line Quantity (Adjusted) | /SCMB/SPLR_QUAN_PRO | QUAN | 10 | ||
QUAN_PRO_SHIP | Goods Issue Quantity | /SCMB/SPLR_QUAN_PRO_SHIP | QUAN | 10 | ||
QUAN_PRO_RECV | Quantity of Goods Received | /SCMB/SPLR_QUAN_PRO_RECV | QUAN | 10 | ||
QUAN_PRO_UNIT | Unit of Measure | /SCMB/SPLR_QUAN_PRO_UNIT | UNIT | 6 | * | |
QUAN_PRO_CQRI | Customer Cumulative Quantity | /SCMB/SPLR_QUAN_PRO_CQRI | QUAN | 10 | ||
QUAN_PRO_CQSU | Supplier Cumulative Quantity | /SCMB/SPLR_QUAN_PRO_CQSU | QUAN | 10 | ||
QUAN_PRO_CQRV | Cumulative Received Quantity | /SCMB/SPLR_QUAN_PRO_CQRV | QUAN | 10 | ||
TYPE_DLV | Delivery Type | /SCMB/SPLR_TYPE_DLV | CHAR | 6 | ||
TYPE_PRO_PRIO | Delivery Priority | /SCMB/SPLR_PRIO_DLV | CHAR | 2 | ||
TYPE_PRO_DAGC | Dangerous Goods: Class ID | /SCMB/SPLR_TYPE_PRO_DAGC | CHAR | 6 | ||
TYPE_PRO_DAGS | Dangerous Goods: Subclass ID | /SCMB/SPLR_TYPE_PRO_DAGS | CHAR | 12 | ||
TYPE_DLV_DUPL | Duplicate Exists | /SCMB/SPLR_TYPE_DLV_DUPL | CHAR | 2 | ||
TYPE_PRO_TRAN | Means of Transport | /SCMB/MDL_TTYPE | CHAR | 20 | ||
DISP_PRO_CTRY | Country/Region of Origin | /SCMB/SPLR_CNTY_ORG | CHAR | 6 | * | |
DATI_DOC_RECV | Document Creation Time | /SCMB/SPLR_DATI_DOC_CREA | DEC | 8 | ||
DATI_PRO_SHIP | Shipping Date/Time | /SCMB/SPLR_DATI_PRO_SHPS | DEC | 8 | ||
DATI_PRO_RECV | Delivery Date/Time | /SCMB/SPLR_DATI_PRO_RECS | DEC | 8 | ||
DATI_PRO_SDPR | Supplier Delivery Performance Rating Time | /SCMB/SPLR_DATI_PRO_SDPR | DEC | 8 | ||
CALE_PRO_SDPR | Calendar for Supplier Delivery Performance Rating Time | /SCMB/SPLR_CALE | CHAR | 20 | * | |
CALE_PRO_SHIP | Kalendar of Sending Location | /SCMB/SPLR_CALE_PRO_SHIP | CHAR | 20 | * | |
CALE_PRO_RECV | Calendar of Receiving Location | /SCMB/SPLR_CALE_PRO_RECV | CHAR | 20 | * | |
TYPE_DOC_MANU | ASN Created Manually | /SCMB/SPLR_TYPE_DOC_MANU | CHAR | 2 | ||
TYPE_REC_ACPT | Acceptance Status | /SCMB/SPLR_TYPE_REC_ACPT | CHAR | 2 | ||
TYPE_PRO_GRLI | Goods Receipt Status | /SCMB/SPLR_TYPE_PRO_GRLI | CHAR | 2 | ||
TYPE_DLV_SPLT | ASN Due to Split | /SCMB/SPLR_TYPE_DLV_SPLT | CHAR | 2 | ||
.INCLUDE | /SCMB/SPLR_COMP_DLV | 0 | ||||
QUAN_PRO_ONTI | Quantity Delivered on Time | /SCMB/SPLR_QUAN_PRO_ONTI | QUAN | 10 | ||
QUAN_PRO_EACP | Quantity Delivered Early (Current Period) | /SCMB/SPLR_QUAN_PRO_EACP | QUAN | 10 | ||
QUAN_PRO_EAFP | Quantity Delivered Early (Future Period) | /SCMB/SPLR_QUAN_PRO_EAFP | QUAN | 10 | ||
QUAN_PRO_LACP | Quantity Delivered Late (Current Period) | /SCMB/SPLR_QUAN_PRO_LACP | QUAN | 10 | ||
QUAN_PRO_LAPP | Quantity Delivered Late (Past Period) | /SCMB/SPLR_QUAN_PRO_LAPP | QUAN | 10 | ||
QUAN_PRO_OVER | Overdelivered Quantity | /SCMB/SPLR_QUAN_PRO_OVER | QUAN | 10 | ||
QUAN_POR_ONTI | Quantity of PO Delivered on Time | /SCMB/SPLR_QUAN_POR_ONTI | QUAN | 10 | ||
QUAN_POR_EACP | Quantity of PO Delivered Early (Current Period) | /SCMB/SPLR_QUAN_POR_EACP | QUAN | 10 | ||
QUAN_POR_EAFP | Quantity of PO Delivered Early (Future Period) | /SCMB/SPLR_QUAN_POR_EAFP | QUAN | 10 | ||
QUAN_POR_LACP | Quantity of PO Delivered Late (Current Period) | /SCMB/SPLR_QUAN_POR_LACP | QUAN | 10 | ||
QUAN_POR_LAPP | Quantity of PO Delivered Late (Past Period) | /SCMB/SPLR_QUAN_POR_LAPP | QUAN | 10 | ||
QUAN_POR_OVER | Overdelivered Quantity of PO | /SCMB/SPLR_QUAN_POR_OVER | QUAN | 10 | ||
QUAN_PRO_UNIT2 | Unit of Measure | /SCMB/SPLR_QUAN_PRO_UNIT | UNIT | 6 | * | |
TYPE_TIM | Timeliness (ASN) | /SCMB/SPLR_TYPE_TIM | CHAR | 2 | ||
TYPE_TIM_N | Counter for Timeliness (ASN) | /SCMB/SPLR_TYPE_TIM_N | INT4 | 4 | ||
TYPE_ACC_N | Counter for Accuracy of ASN | /SCMB/SPLR_TYPE_ACC_N | INT4 | 4 | ||
TYPE_ACC | Accuracy of ASN | /SCMB/SPLR_TYPE_ACC | CHAR | 2 | ||
LINE_REC_ORRJ | Number of Rejected ASN Originals | /SCMB/SPLR_LINE_REC_ORRJ | INT4 | 4 | ||
LINE_REC_RERJ | Number of Rejected (Transferred) Rows | /SCMB/SPLR_LINE_REC_RERJ | INT4 | 4 | ||
LINE_REC_ORAC | Number of Accepted ASN Originals | /SCMB/SPLR_LINE_REC_ORAC | INT4 | 4 | ||
LINE_REC_REAC | Number of Accepted ASN Substitutions | /SCMB/SPLR_LINE_REC_REAC | INT4 | 4 | ||
TYPE_REC_HIIN | Counter for Total | /SCMB/SPLR_TYPE_REC_HIIN | INT1 | 1 | ||
TYPE_HIIN_N | Counter for Total | /SCMB/SPLR_TYPE_REC_HIIN_N | INT4 | 4 | ||
TYPE_REC_WARN | Warnings for ASN Items | /SCMB/SPLR_TYPE_REC_WARN | CHAR | 2 | ||
QUAN_PRM_ONTI | Quantity Delivered on Time | /SCMB/SPLR_QUAN_PRO_ONTI | QUAN | 10 | ||
QUAN_PRM_EACP | Quantity Delivered Early (Current Period) | /SCMB/SPLR_QUAN_PRO_EACP | QUAN | 10 | ||
QUAN_PRM_EAFP | Quantity Delivered Early (Future Period) | /SCMB/SPLR_QUAN_PRO_EAFP | QUAN | 10 | ||
QUAN_PRM_LACP | Quantity Delivered Late (Current Period) | /SCMB/SPLR_QUAN_PRO_LACP | QUAN | 10 | ||
QUAN_PRM_LAPP | Quantity Delivered Late (Past Period) | /SCMB/SPLR_QUAN_PRO_LAPP | QUAN | 10 | ||
QUAN_PRM_OVER | Overdelivered Quantity | /SCMB/SPLR_QUAN_PRO_OVER | QUAN | 10 | ||
QUAN_RAT_ONTI | Quantity Delivered on Time | /SCMB/SPLR_QUAN_PRO_ONTI | QUAN | 10 | ||
QUAN_RAT_EACP | Quantity Delivered Early (Current Period) | /SCMB/SPLR_QUAN_PRO_EACP | QUAN | 10 | ||
QUAN_RAT_EAFP | Quantity Delivered Early (Future Period) | /SCMB/SPLR_QUAN_PRO_EAFP | QUAN | 10 | ||
QUAN_RAT_LACP | Quantity Delivered Late (Current Period) | /SCMB/SPLR_QUAN_PRO_LACP | QUAN | 10 | ||
QUAN_RAT_LAPP | Quantity Delivered Late (Past Period) | /SCMB/SPLR_QUAN_PRO_LAPP | QUAN | 10 | ||
QUAN_RAT_OVER | Overdelivered Quantity | /SCMB/SPLR_QUAN_PRO_OVER | QUAN | 10 | ||
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 | * | |
TYPE_ACC_ONT_N | Counter for Accuracy of ASN (On-Time Delivery) | /SCMB/SPRL_TYPE_ACC_ONT_N | INT4 | 4 | ||
TYPE_ACC_2_N | Counter for Accuracy of ASN (Accuracy/On-Time Delivery) | /SCMB/SPRL_TYPE_ACC_2_N | INT4 | 4 | ||
.INCLUDE | /SCMB/SPLR_ADMN_DLV | 0 | ||||
QUAN_POR_NASS | Schedule Line Quantity (Adjusted) | /SCMB/SPLR_QUAN_PRO | QUAN | 10 | ||
QUAN_PRO_NASS | Schedule Line Quantity (Adjusted) | /SCMB/SPLR_QUAN_PRO | QUAN | 10 | ||
QUAN_PRO_NASS_UN | Unit of Measure | /SCMB/SPLR_QUAN_PRO_UNIT | UNIT | 6 | * | |
FLAG_REC_ASSI | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 2 | ||
TYPE_REC_DOIT | Include Row in Evaluation | /SCMB/SPLR_TYPE_REC_DOIT | CHAR | 2 | ||
QUAN_PRO_AOVR | Quantity of "Overdelivery" Alerts | /SCMB/SPLR_QUAN_PRO_AOVR | QUAN | 10 | ||
QUAN_PRO_AEAY | Number of "Early Delivery" Alerts | /SCMB/SPLR_QUAN_PRO_AEAY | QUAN | 10 | ||
FLAG_REC_ATIM | "Accuracy (ASN)" Alert Generated | /SCMB/SPLR_FLAG_REC_ATIM | CHAR | 2 | ||
QUAN_PRM_NASS | Schedule Line Quantity (Adjusted) | /SCMB/SPLR_QUAN_PRO | QUAN | 10 | ||
QUAN_PRM_ASSI | Schedule Line Quantity (Adjusted) | /SCMB/SPLR_QUAN_PRO | QUAN | 10 | ||
LINE_REC_CHNG | Number of Changes | /SCMB/SPLR_LINE_REC_CHNG | INT4 | 4 | ||
FLAG_PRM_ASSI | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 2 | ||
TYPE_REC_SDPR | SDPR Calculated for this Element | /SCMB/SPLR_TYPE_REC_SDPR | CHAR | 2 | ||
TYPE_SDPR_N | SDPR Calculated for this Element (Counter) | /SCMB/SPLR_TYPE_REC_SDPR_N | INT4 | 4 | ||
TYPE_REC_MANC | Manual Changes Exist | /SCMB/SPLR_TYPE_REC_MANC | CHAR | 2 | ||
QUAN_PRO_NASS2 | Schedule Line Quantity (Adjusted) | /SCMB/SPLR_QUAN_PRO | QUAN | 10 | ||
QUAN_POR_NASS2 | Schedule Line Quantity (Adjusted) | /SCMB/SPLR_QUAN_PRO | QUAN | 10 | ||
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 |