/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".

Fields for table /SCMB/SPLRQDLV

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
.INCLUDEX/SCMB/SPLR_KEYS_Q0
LINE_REC_QUEUQueue Entry IDX/SCMB/SPLR_LINE_REC_QUEUNUMC32
.INCLUDEX/SCMB/SPLR_KEYS_DLV0
GUID_DLVAdvanced Shipping Notification (GUID)X/SCMB/SPLR_GUID_DLVRAW16
GUID_DLV_ITEMAdvanced Shipping Notification (GUID)X/SCMB/SPLR_GUID_DLV_ITEMRAW16
TYPE_REF_PERIType of Reporting PeriodX/SCMB/SPLR_TYPE_REF_PERICHAR2
.INCLUDE/SCMB/SPLR_RAWS_DLV0
DISP_DLVASN Number/SCMB/SPLR_DISP_DLVCHAR70
DISP_DLV_ITEMASN Item/SCMB/SPLR_DISP_DLV_ITEMCHAR20
DISP_PDLNumber of Split ASN/SCMB/SPLR_DISP_PDLCHAR70
DISP_PDL_ITEMHigher-Level Shipping Notification Item/SCMB/SPLR_DISP_PDL_ITEMCHAR20
GUID_SUPSupplier (GUID)/SCMB/SPLR_GUID_SUPRAW16
DISP_SUPVendor/SCMB/SPLR_DISP_SUPCHAR20
GUID_SPTCustomer Location (GUID)/SCMB/SPLR_GUID_SPTRAW16
DISP_SPTCustomer Location/SCMB/SPLR_DISP_SPTCHAR40
GUID_SULShip-From Location (GUID)/SCMB/SPLR_GUID_SULRAW16
DISP_SULShip-From Location/SCMB/SPLR_DISP_SULCHAR40
GUID_GRLShip-To Location (GUID)/SCMB/SPLR_GUID_GRLRAW16
DISP_GRLShip-To Location/SCMB/SPLR_DISP_GRLCHAR40
GUID_SCHScheduling Agreement Release (GUID)/SCMB/SPLR_GUID_SCHRAW16
GUID_SCH_ITEMScheduling Agreement Release Item (GUID)/SCMB/SPLR_GUID_SCH_ITEMRAW16
DISP_SCH_ITEMRelease Number/SCMB/SPLR_DISP_SCH_ITEMCHAR70
DISP_SCAScheduling Agreement/SCMB/SPLR_DISP_SCACHAR70
DISP_SCA_ITEMScheduling Agreement Item/SCMB/SPLR_DISP_SCA_ITEMCHAR20
GUID_SCOSupplier Confirmation (GUID)/SCMB/SPLR_GUID_SCORAW16
DISP_SCOSupplier Confirmation/SCMB/SPLR_DISP_SCOCHAR70
GUID_PROProduct (GUID)/SCMB/SPLR_GUID_PRORAW16
DISP_PROProduct/SCMB/SPLR_DISP_PROCHAR80
DISP_PRO_SUPPProduct Number of Assigned Partner/SCMB/SPLR_DISP_PRO_SUPPCHAR80
GUID_BLPBill-To Party (GUID)/SCMB/SPLR_GUID_BLPRAW16
DISP_BLPBill-To Party/SCMB/SPLR_DISP_BLPCHAR20
GUID_BPACustomer (GUID)/SCMB/SPLR_GUID_BPARAW16
DISP_BPACustomer/SCMB/SPLR_DISP_BPACHAR20
GUID_BPGGoods Recipient (GUID)/SCMB/SPLR_GUID_BPGRAW16
DISP_BPGGoods Recipient/SCMB/SPLR_DISP_BPGCHAR20
DISP_SORSales Order Number/SCMB/SPLR_DISP_SORCHAR70
DISP_SOR_ITEMSales Order Item/SCMB/SPLR_DISP_SOR_ITEMCHAR20
GUID_PORPurchase Order (GUID)/SCMB/SPLR_GUID_PORRAW16
DISP_PORPurchase Order Number/SCMB/SPLR_DISP_PORCHAR70
GUID_POR_ITEMPurchase Order Item (GUID)/SCMB/SPLR_GUID_POR_ITEMRAW16
DISP_POR_ITEMPurchase Order Item No./SCMB/SPLR_DISP_POR_ITEMCHAR20
QUAN_PROSchedule Line Quantity (Adjusted)/SCMB/SPLR_QUAN_PROQUAN10
QUAN_PRO_SHIPGoods Issue Quantity/SCMB/SPLR_QUAN_PRO_SHIPQUAN10
QUAN_PRO_RECVQuantity of Goods Received/SCMB/SPLR_QUAN_PRO_RECVQUAN10
QUAN_PRO_UNITUnit of Measure/SCMB/SPLR_QUAN_PRO_UNITUNIT6*
QUAN_PRO_CQRICustomer Cumulative Quantity/SCMB/SPLR_QUAN_PRO_CQRIQUAN10
QUAN_PRO_CQSUSupplier Cumulative Quantity/SCMB/SPLR_QUAN_PRO_CQSUQUAN10
QUAN_PRO_CQRVCumulative Received Quantity/SCMB/SPLR_QUAN_PRO_CQRVQUAN10
TYPE_DLVDelivery Type/SCMB/SPLR_TYPE_DLVCHAR6
TYPE_PRO_PRIODelivery Priority/SCMB/SPLR_PRIO_DLVCHAR2
TYPE_PRO_DAGCDangerous Goods: Class ID/SCMB/SPLR_TYPE_PRO_DAGCCHAR6
TYPE_PRO_DAGSDangerous Goods: Subclass ID/SCMB/SPLR_TYPE_PRO_DAGSCHAR12
TYPE_DLV_DUPLDuplicate Exists/SCMB/SPLR_TYPE_DLV_DUPLCHAR2
TYPE_PRO_TRANMeans of Transport/SCMB/MDL_TTYPECHAR20
DISP_PRO_CTRYCountry/Region of Origin/SCMB/SPLR_CNTY_ORGCHAR6*
DATI_DOC_RECVDocument Creation Time/SCMB/SPLR_DATI_DOC_CREADEC8
DATI_PRO_SHIPShipping Date/Time/SCMB/SPLR_DATI_PRO_SHPSDEC8
DATI_PRO_RECVDelivery Date/Time/SCMB/SPLR_DATI_PRO_RECSDEC8
DATI_PRO_SDPRSupplier Delivery Performance Rating Time/SCMB/SPLR_DATI_PRO_SDPRDEC8
CALE_PRO_SDPRCalendar for Supplier Delivery Performance Rating Time/SCMB/SPLR_CALECHAR20*
CALE_PRO_SHIPKalendar of Sending Location/SCMB/SPLR_CALE_PRO_SHIPCHAR20*
CALE_PRO_RECVCalendar of Receiving Location/SCMB/SPLR_CALE_PRO_RECVCHAR20*
TYPE_DOC_MANUASN Created Manually/SCMB/SPLR_TYPE_DOC_MANUCHAR2
TYPE_REC_ACPTAcceptance Status/SCMB/SPLR_TYPE_REC_ACPTCHAR2
TYPE_PRO_GRLIGoods Receipt Status/SCMB/SPLR_TYPE_PRO_GRLICHAR2
TYPE_DLV_SPLTASN Due to Split/SCMB/SPLR_TYPE_DLV_SPLTCHAR2
.INCLUDE/SCMB/SPLR_COMP_DLV0
QUAN_PRO_ONTIQuantity Delivered on Time/SCMB/SPLR_QUAN_PRO_ONTIQUAN10
QUAN_PRO_EACPQuantity Delivered Early (Current Period)/SCMB/SPLR_QUAN_PRO_EACPQUAN10
QUAN_PRO_EAFPQuantity Delivered Early (Future Period)/SCMB/SPLR_QUAN_PRO_EAFPQUAN10
QUAN_PRO_LACPQuantity Delivered Late (Current Period)/SCMB/SPLR_QUAN_PRO_LACPQUAN10
QUAN_PRO_LAPPQuantity Delivered Late (Past Period)/SCMB/SPLR_QUAN_PRO_LAPPQUAN10
QUAN_PRO_OVEROverdelivered Quantity/SCMB/SPLR_QUAN_PRO_OVERQUAN10
QUAN_POR_ONTIQuantity of PO Delivered on Time/SCMB/SPLR_QUAN_POR_ONTIQUAN10
QUAN_POR_EACPQuantity of PO Delivered Early (Current Period)/SCMB/SPLR_QUAN_POR_EACPQUAN10
QUAN_POR_EAFPQuantity of PO Delivered Early (Future Period)/SCMB/SPLR_QUAN_POR_EAFPQUAN10
QUAN_POR_LACPQuantity of PO Delivered Late (Current Period)/SCMB/SPLR_QUAN_POR_LACPQUAN10
QUAN_POR_LAPPQuantity of PO Delivered Late (Past Period)/SCMB/SPLR_QUAN_POR_LAPPQUAN10
QUAN_POR_OVEROverdelivered Quantity of PO/SCMB/SPLR_QUAN_POR_OVERQUAN10
QUAN_PRO_UNIT2Unit of Measure/SCMB/SPLR_QUAN_PRO_UNITUNIT6*
TYPE_TIMTimeliness (ASN)/SCMB/SPLR_TYPE_TIMCHAR2
TYPE_TIM_NCounter for Timeliness (ASN)/SCMB/SPLR_TYPE_TIM_NINT44
TYPE_ACC_NCounter for Accuracy of ASN/SCMB/SPLR_TYPE_ACC_NINT44
TYPE_ACCAccuracy of ASN/SCMB/SPLR_TYPE_ACCCHAR2
LINE_REC_ORRJNumber of Rejected ASN Originals/SCMB/SPLR_LINE_REC_ORRJINT44
LINE_REC_RERJNumber of Rejected (Transferred) Rows/SCMB/SPLR_LINE_REC_RERJINT44
LINE_REC_ORACNumber of Accepted ASN Originals/SCMB/SPLR_LINE_REC_ORACINT44
LINE_REC_REACNumber of Accepted ASN Substitutions/SCMB/SPLR_LINE_REC_REACINT44
TYPE_REC_HIINCounter for Total/SCMB/SPLR_TYPE_REC_HIININT11
TYPE_HIIN_NCounter for Total/SCMB/SPLR_TYPE_REC_HIIN_NINT44
TYPE_REC_WARNWarnings for ASN Items/SCMB/SPLR_TYPE_REC_WARNCHAR2
QUAN_PRM_ONTIQuantity Delivered on Time/SCMB/SPLR_QUAN_PRO_ONTIQUAN10
QUAN_PRM_EACPQuantity Delivered Early (Current Period)/SCMB/SPLR_QUAN_PRO_EACPQUAN10
QUAN_PRM_EAFPQuantity Delivered Early (Future Period)/SCMB/SPLR_QUAN_PRO_EAFPQUAN10
QUAN_PRM_LACPQuantity Delivered Late (Current Period)/SCMB/SPLR_QUAN_PRO_LACPQUAN10
QUAN_PRM_LAPPQuantity Delivered Late (Past Period)/SCMB/SPLR_QUAN_PRO_LAPPQUAN10
QUAN_PRM_OVEROverdelivered Quantity/SCMB/SPLR_QUAN_PRO_OVERQUAN10
QUAN_RAT_ONTIQuantity Delivered on Time/SCMB/SPLR_QUAN_PRO_ONTIQUAN10
QUAN_RAT_EACPQuantity Delivered Early (Current Period)/SCMB/SPLR_QUAN_PRO_EACPQUAN10
QUAN_RAT_EAFPQuantity Delivered Early (Future Period)/SCMB/SPLR_QUAN_PRO_EAFPQUAN10
QUAN_RAT_LACPQuantity Delivered Late (Current Period)/SCMB/SPLR_QUAN_PRO_LACPQUAN10
QUAN_RAT_LAPPQuantity Delivered Late (Past Period)/SCMB/SPLR_QUAN_PRO_LAPPQUAN10
QUAN_RAT_OVEROverdelivered Quantity/SCMB/SPLR_QUAN_PRO_OVERQUAN10
DISP_REFReporting Period/SCMB/SPLR_DISP_REFCHAR14
DISP_REF_NC6Reporting Period/SCMB/SPLR_DISP_REF_NC6NUMC12
TYPE_REF_PERVPeriod Variant of Reporting Period/SCMB/SPLR_TYPE_REF_PERVCHAR4*
TYPE_ACC_ONT_NCounter for Accuracy of ASN (On-Time Delivery)/SCMB/SPRL_TYPE_ACC_ONT_NINT44
TYPE_ACC_2_NCounter for Accuracy of ASN (Accuracy/On-Time Delivery)/SCMB/SPRL_TYPE_ACC_2_NINT44
.INCLUDE/SCMB/SPLR_ADMN_DLV0
QUAN_POR_NASSSchedule Line Quantity (Adjusted)/SCMB/SPLR_QUAN_PROQUAN10
QUAN_PRO_NASSSchedule Line Quantity (Adjusted)/SCMB/SPLR_QUAN_PROQUAN10
QUAN_PRO_NASS_UNUnit of Measure/SCMB/SPLR_QUAN_PRO_UNITUNIT6*
FLAG_REC_ASSIData element for domain BOOLE: TRUE (='X') and FALSE (=' ')BOOLE_DCHAR2
TYPE_REC_DOITInclude Row in Evaluation/SCMB/SPLR_TYPE_REC_DOITCHAR2
QUAN_PRO_AOVRQuantity of "Overdelivery" Alerts/SCMB/SPLR_QUAN_PRO_AOVRQUAN10
QUAN_PRO_AEAYNumber of "Early Delivery" Alerts/SCMB/SPLR_QUAN_PRO_AEAYQUAN10
FLAG_REC_ATIM"Accuracy (ASN)" Alert Generated/SCMB/SPLR_FLAG_REC_ATIMCHAR2
QUAN_PRM_NASSSchedule Line Quantity (Adjusted)/SCMB/SPLR_QUAN_PROQUAN10
QUAN_PRM_ASSISchedule Line Quantity (Adjusted)/SCMB/SPLR_QUAN_PROQUAN10
LINE_REC_CHNGNumber of Changes/SCMB/SPLR_LINE_REC_CHNGINT44
FLAG_PRM_ASSIData element for domain BOOLE: TRUE (='X') and FALSE (=' ')BOOLE_DCHAR2
TYPE_REC_SDPRSDPR Calculated for this Element/SCMB/SPLR_TYPE_REC_SDPRCHAR2
TYPE_SDPR_NSDPR Calculated for this Element (Counter)/SCMB/SPLR_TYPE_REC_SDPR_NINT44
TYPE_REC_MANCManual Changes Exist/SCMB/SPLR_TYPE_REC_MANCCHAR2
QUAN_PRO_NASS2Schedule Line Quantity (Adjusted)/SCMB/SPLR_QUAN_PROQUAN10
QUAN_POR_NASS2Schedule Line Quantity (Adjusted)/SCMB/SPLR_QUAN_PROQUAN10
TYPE_ORIGINOrigin of data in SDPR/SCMB/SPLR_ORIGINCHAR2
.INCLUDE/SCMB/SPLR_CHNG_REC0
DATI_REC_CHNGChanged On/SCMB/SPLR_DATI_REC_CHNGDEC8
FLAG_REC_DELEDeletion Indicator/SCMB/SPLR_FLAG_REC_DELECHAR2
DISP_REC_USERUser NameSYUNAMECHAR24
.INCLUDE/SCMB/SPLR_ADMN_Q0
DATI_REC_QUEUTime Added/SCMB/SPLR_DATI_REC_QUEUDEC8
TYPE_REC_QUEUType of Queue Entry/SCMB/SPLR_TYPE_REC_QUEUECHAR2
Privacy Policy