/SCMB/SPLRQPOR - Purchase Order Queue
Purchase Order Queue information is stored in SAP table /SCMB/SPLRQPOR.
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/SPLRQPOR
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_POR | 0 | |||
| GUID_POR | Purchase Order (GUID) | X | /SCMB/SPLR_GUID_POR | RAW | 16 | |
| GUID_POR_ITEM | Purchase Order Item (GUID) | X | /SCMB/SPLR_GUID_POR_ITEM | RAW | 16 | |
| GUID_POR_LINE | Purchase Order Schedule Line (GUID) | X | /SCMB/SPLR_GUID_POR_LINE | RAW | 16 | |
| TYPE_REF_PERI | Type of Reporting Period | X | /SCMB/SPLR_TYPE_REF_PERI | CHAR | 2 | |
| .INCLUDE | /SCMB/SPLR_RAWS_POR | 0 | ||||
| DISP_POR | Purchase Order Number | /SCMB/SPLR_DISP_POR | CHAR | 70 | ||
| 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 | ||
| DISP_POR_PITM | Purchase Order Item No. | /SCMB/SPLR_DISP_POR_ITEM | CHAR | 20 | ||
| TYPE_DLV | Delivery Type | /SCMB/SPLR_TYPE_DLV | CHAR | 6 | ||
| TYPE_POR_ITEM | ODM: Item Category | /SCMB/ODM_ITMTYPE | CHAR | 8 | * | |
| TYPE_POR | ODM: Order Data Type | /SCMB/ODM_ORDTYPE | CHAR | 8 | * | |
| TYPE_POR_LINE | ODM: Schedule Line Category | /SCMB/ODM_SDLTYPE | CHAR | 8 | * | |
| GUID_SUP | Supplier (GUID) | /SCMB/SPLR_GUID_SUP | RAW | 16 | ||
| GUID_SUL | Ship-From Location (GUID) | /SCMB/SPLR_GUID_SUL | RAW | 16 | ||
| DISP_SUP | Vendor | /SCMB/SPLR_DISP_SUP | CHAR | 20 | ||
| DISP_SUL | Ship-From Location | /SCMB/SPLR_DISP_SUL | CHAR | 40 | ||
| GUID_SPT | Customer Location (GUID) | /SCMB/SPLR_GUID_SPT | RAW | 16 | ||
| DISP_SPT | Customer Location | /SCMB/SPLR_DISP_SPT | CHAR | 40 | ||
| GUID_BLP | Bill-To Party (GUID) | /SCMB/SPLR_GUID_BLP | RAW | 16 | ||
| DISP_BLP | Bill-To Party | /SCMB/SPLR_DISP_BLP | CHAR | 20 | ||
| 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_GRL | Ship-To Location (GUID) | /SCMB/SPLR_GUID_GRL | RAW | 16 | ||
| DISP_GRL | Ship-To Location | /SCMB/SPLR_DISP_GRL | CHAR | 40 | ||
| QUAN_PRO | Schedule Line Quantity (Adjusted) | /SCMB/SPLR_QUAN_PRO | QUAN | 10 | ||
| QUAN_PRO_CANC | Rejected Quantity | /SCMB/SPLR_QUAN_PRO_CANC | QUAN | 10 | ||
| QUAN_PRO_UNIT | Unit of Measure | /SCMB/SPLR_QUAN_PRO_UNIT | UNIT | 6 | * | |
| TYPE_PRO_PRIO | Delivery Priority | /SCMB/SPLR_PRIO_DLV | CHAR | 2 | ||
| DISP_SCA | Scheduling Agreement | /SCMB/SPLR_DISP_SCA | CHAR | 70 | ||
| DISP_SCA_ITEM | Scheduling Agreement Item | /SCMB/SPLR_DISP_SCA_ITEM | CHAR | 20 | ||
| 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 | ||
| GUID_SCH_LINE | Scheduling Agreement Release Schedule Line (GUID) | /SCMB/SPLR_GUID_SCH_LINE | RAW | 16 | ||
| 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_DSO | Sales Order at Supplier | /SCMB/SPLR_DISP_DSO | CHAR | 70 | ||
| DISP_DSO_ITEM | Sales Order Item at Supplier | /SCMB/SPLR_DISP_DSO_ITEM | CHAR | 20 | ||
| DISP_DPO | Original PO Number | /SCMB/SPLR_DISP_DPO | CHAR | 70 | ||
| DISP_DPO_ITEM | Purchase Order Item at Dealer | /SCMB/SPLR_DISP_DPO_ITEM | CHAR | 20 | ||
| DATI_DOC_CREA | Document Creation Time | /SCMB/SPLR_DATI_DOC_CREA | DEC | 8 | ||
| DATI_DOC_CHNG | Changed On | /SCMB/SPLR_DATI_REC_CHNG | DEC | 8 | ||
| DATI_PRO_SHPS | Shipping Date/Time | /SCMB/SPLR_DATI_PRO_SHPS | DEC | 8 | ||
| DATI_PRO_SHPE | Shipping Time End | /SCMB/SPLR_DATI_PRO_SHPE | DEC | 8 | ||
| DATI_PRO_RECS | Delivery Date/Time | /SCMB/SPLR_DATI_PRO_RECS | DEC | 8 | ||
| DATI_PRO_RECE | Delivery Time End | /SCMB/SPLR_DATI_PRO_RECE | DEC | 8 | ||
| DATI_PRO_SDPR | Supplier Delivery Performance Rating Time | /SCMB/SPLR_DATI_PRO_SDPR | DEC | 8 | ||
| DATI_PRO_SDPS | Start Time of SDPR Period | /SCMB/SPLR_DATI_PRO_SDPS | DEC | 8 | ||
| DATI_PRO_SDPE | End Time of SDPR Period | /SCMB/SPLR_DATI_PRO_SDPE | DEC | 8 | ||
| DATI_POR_CLOS | Time Purchase Order was Closed | /SCMB/SPLR_DATI_POR_CLOS | DEC | 8 | ||
| TYPE_POR_STAT | Status | /SCMB/SPLR_TYPE_POR_STAT | CHAR | 2 | ||
| 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 | ||
| 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 | * | |
| DATI_PRO_CANC | Quantity Rejection Time | /SCMB/SPLR_DATI_PRO_CANC | DEC | 8 | ||
| .INCLUDE | /SCMB/SPLR_COMP_POR | 0 | ||||
| QUAN_PRO_LONT | Quantity Delivered on Time | /SCMB/SPLR_QUAN_PRO_LONT | QUAN | 10 | ||
| QUAN_PRO_LEAY | Quantity Delivered Early | /SCMB/SPLR_QUAN_PRO_LEAY | QUAN | 10 | ||
| QUAN_PRO_LLAT | Quantity Delivered Late | /SCMB/SPLR_QUAN_PRO_LLAT | QUAN | 10 | ||
| QUAN_PRO_LOVR | Overdelivered Quantity | /SCMB/SPLR_QUAN_PRO_LOVR | QUAN | 10 | ||
| QUAN_PRO_LUNM | Overdue Quantity (Current Period) | /SCMB/SPLR_QUAN_PRO_LUNM | QUAN | 10 | ||
| QUAN_PRO_LPDU | Overdue Quantity (Previous Period) | /SCMB/SPLR_QUAN_PRO_LPDU | QUAN | 10 | ||
| TYPE_PDU | Lateness of Schedule Line | /SCMB/SPLR_TYPE_PDU | CHAR | 2 | ||
| TYPE_PDU_N | Lateness of Schedule Line (Counter) | /SCMB/SPLR_TYPE_PDU_N | INT4 | 4 | ||
| QUAN_PRO_UNIT2 | Unit of Measure | /SCMB/SPLR_QUAN_PRO_UNIT | UNIT | 6 | * | |
| 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_EON | Schedule Line Delivered on Time | /SCMB/SPLR_TYPE_EON | CHAR | 2 | ||
| TYPE_EON_N | Schedule Line Delivered on Time (Counter) | /SCMB/SPLR_TYPE_EON_N | INT4 | 4 | ||
| QUAN_RAT_LONT | Quantity Delivered on Time | /SCMB/SPLR_QUAN_PRO_LONT | QUAN | 10 | ||
| QUAN_RAT_LEAY | Quantity Delivered Early | /SCMB/SPLR_QUAN_PRO_LEAY | QUAN | 10 | ||
| QUAN_RAT_LLAT | Quantity Delivered Late | /SCMB/SPLR_QUAN_PRO_LLAT | QUAN | 10 | ||
| QUAN_RAT_LOVR | Overdelivered Quantity | /SCMB/SPLR_QUAN_PRO_LOVR | QUAN | 10 | ||
| QUAN_RAT_LUNM | Overdue Quantity (Current Period) | /SCMB/SPLR_QUAN_PRO_LUNM | QUAN | 10 | ||
| QUAN_RAT_LPDU | Overdue Quantity (Previous Period) | /SCMB/SPLR_QUAN_PRO_LPDU | QUAN | 10 | ||
| LINE_DLV_GRLI | Number of ASNs with Goods Receipt | /SCMB/SPLR_LINE_DLV_GRLI | INT4 | 4 | ||
| TYPE_DLV_GRLI | GR over ASN | /SCMB/SPLR_TYPE_DLV_GRLI | CHAR | 2 | ||
| TYPE_REF_PERV | Period Variant of Reporting Period | /SCMB/SPLR_TYPE_REF_PERV | CHAR | 4 | * | |
| .INCLUDE | /SCMB/SPLR_ADMN_POR | 0 | ||||
| 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 | No Open Quantity | /SCMB/SPLR_FLAG_REC_ASSI | CHAR | 2 | ||
| QUAN_PRO_APDU | Quantity of "Overdue Delivery" Alerts | /SCMB/SPLR_QUAN_PRO_APDU | QUAN | 10 | ||
| LINE_REC_CHNG | Number of Changes | /SCMB/SPLR_LINE_REC_CHNG | INT4 | 4 | ||
| FLAG_REC_LPDU | Overdue Quantity Not Yet on QUAN_PRO_LPDU | /SCMB/SPLR_FLAG_REC_LPDU | 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 | ||
| 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 |