Inbound Delivery Monitor:
Detail Data
Technical name: 0SPL_INB_DETAIL_1
Technical data
DataSource Type |
Transaction data |
Application Component |
Service Parts Planning (SCM-APO-SPP) |
Available as of OLTP Release |
SCM 4.15 |
Available from Plug-In Release |
PI 2004.1, SP1 |
RemoteCube Compatibility |
No |
Prerequisites
Activation of the DataSource.
Use
This DataSource is used to extract the detail data of the inbound delivery monitor (Inbound Delivery Monitor) for analysis of inbound deliveries, consistently to a BW system. The system makes the data of the inbound deliveries that are relevant for the inbound delivery monitor, available for every item and delivery status.
Delta Update
A delta update is supported. Delta process: AIED – After-Images with Deletion Indicator via extractor.
An extractor test is possible in delta mode.
Fields of Origin in the Extraction Structure
The following table gives you an overview of the contents of the extraction structure /SCMB/INB_EXTRACT_DATA_STR (extractor /SCMB/V_INBST).
Field in the Extraction Structure |
Description of Field in Extraction Structure |
Table of Origin |
Field in the Extraction Structure |
MANDT |
Client |
/SCMB/INBDLVST |
MANDT |
DLV_GUID |
Advanced Shipping Notification (GUID) |
/SCMB/INBDLVST |
DLV_GUID |
DLV_ITEM_GUID |
Advanced Shipping Notification Item (GUID) |
/SCMB/INBDLVST |
DLV_ITEM_GUID |
DLV_STATUS |
Delivery Status: Status the inbound delivery item obtained once it was determined that the product in question was to be rated “critical” due to a likely delivery bottleneck. If the calculation is carried out more than once, then this field contains the status that was valid at the time of the last current forecast. |
/SCMB/INBDLVST |
DLV_STATUS |
EXT_STATUS |
Delivery Status (Key in External System): This field contains the information of the field DLV_STATUS the way it (the information) appears in external systems, such as SAP R/3. The field serves to match the format of the inbound delivery monitor with the display in the source system. |
/SCMB/INBDLVST |
EXT_STATUS |
DLV_HDR |
Advanced Shipping Notification (ID): This field contains the header information for external deliveries. In SAP R/3, it represents the field VBELN: Sales Document Number. |
/SCMB/INBDLVDAT |
DLV_HDR |
DLV_ITEM |
Advanced Shipping Notification Item (ID): This field contains the item information for external deliveries. In SAP R/3, it represents the field VBELP: Sales Document Item. |
/SCMB/INBDLVDAT |
DLV_ITEM |
PU_REF_HDR |
Order number of reference purchase order. This field contains the header information of the purchasing document upon which the delivery is based. |
/SCMB/INBDLVDAT |
PU_REF_HDR |
PU_REF_ITM |
Item number of reference purchase order: This field contains the item information of the purchasing document upon which the delivery is based. |
/SCMB/INBDLVDAT |
PU_REF_ITM |
PU_REF_SCH |
Schedule line number of reference purchase order: This field contains information about the schedule line in the purchasing document upon which the delivery is based. |
/SCMB/INBDLVDAT |
PU_REF_SCH |
REF_DLV_HDR |
Reference Delivery Document (ID) |
/SCMB/INBDLVDAT |
REF_DLV_HDR |
REF_DLV_ITM |
Reference Delivery Item (ID) |
/SCMB/INBDLVDAT |
REF_DLV_ITM |
LIFEX |
External Delivery Note ID: External identification of supplier’s delivery note (supplier’s advanced shipping notification number). |
/SCMB/INBDLVDAT |
LIFEX |
TRAID |
SPLR: Transport ID: Identifies the means of transport, for example, the truck number Represents the field TRAID in the SAP R/3 delivery document. |
/SCMB/INBDLVDAT |
TRAID |
TRAMODE |
Means of Transport (External System): Type of the means of transport in the definition for the inbound delivery monitor. One or more means of transport types in the SAP R/3 delivery document are assigned a means of transport type in the inbound delivery monitor that is valid only in the monitor. Reference times are defined in the inbound delivery monitor for these types of means of transport. |
/SCMB/INBDLVDAT |
TRAMODE |
SUPPL_LOC |
Supplier location |
/SCMB/INBDLVDAT |
SUPPL_LOC |
LIFNR |
Supplier Location: External, readable supplier ID (LIFNR) in delivery document. |
/SCMB/INBDLVDAT |
LIFNR |
SHPFR_LOC |
Ship-from Location |
/SCMB/INBDLVDAT |
SHPFR_LOC |
SHPFR_TIMEZONE |
Time Zone of Ship-From Location |
/SCMB/INBDLVDAT |
SHPFR_TIMEZONE |
SHPFR_LOCTYPE |
Ship-From Location Location Type |
/SCMB/INBDLVDAT |
SHPFR_LOCTYPE |
SHPTO_LOC_GRP |
Location Group: Next Higher-Level Location in Location Hierarchy |
/SCMB/INBDLVDAT |
SHPTO_LOC_GRP |
SHPTO_LOC |
Ship-to Location |
/SCMB/INBDLVDAT |
SHPTO_LOC |
SHPTO_TIMEZONE |
Time Zone of Ship-To Location |
/SCMB/INBDLVDAT |
SHPTO_TIMEZONE |
SHPTO_LOCTYPE |
Location Type of Ship-To Location |
/SCMB/INBDLVDAT |
SHPTO_LOCTYPE |
PLANT |
SPLR: Plant (Ship-To Location) |
/SCMB/INBDLVDAT |
PLANT |
PRODGROUP |
SPP Inbound Delivery Monitor Product Group |
/SCMB/INBDLVDAT |
PRODGROUP |
PROD_NR |
Material/Product Identifier (External/Readable Key) |
/SCMB/INBDLVDAT |
PROD_NR |
DLVQUAN |
Total Delivery Quantity in Base Unit of Measure |
/SCMB/INBDLVDAT |
DLVQUAN |
DLVRECQTY |
Cumulative Goods Receipt Quantity |
/SCMB/INBDLVDAT |
DLVRECQTY |
ALTQUAN |
Total Quantity for Which an Alert Was Triggered |
/SCMB/INBDLVDAT |
ALTQUAN |
TGRMNG_BME |
Total Goods Receipt Quantity |
/SCMB/INBDLVDAT |
TGRMNG_BME |
AGRMNG_BME |
Last Posted Goods Receipt Quantity |
/SCMB/INBDLVDAT |
AGRMNG_BME |
BASE_UOM |
Base unit of measurement |
/SCMB/INBDLVDAT |
BASE_UOM |
SHP_DATE |
SPLR: Product Shipping Time Stamp |
/SCMB/INBDLVDAT |
SHP_DATE |
AVAIL_DATE |
Time stamp: shipping plus defined standard times |
/SCMB/INBDLVDAT |
AVAIL_DATE |
NEXT_CHG_DATE |
Time Stamp for Time of Next Expected Status Change |
/SCMB/INBDLVDAT |
NEXT_CHG_DATE |
TZONE |
Time Zone for Time Stamp of Inbound Table |
/SCMB/INBDLVDAT |
TZONE |
FLAG_OPEN |
SPLR: ASN Open |
/SCMB/INBDLVDAT |
FLAG_OPEN |
STARTT |
Start Date/Time of Work Process |
/SCMB/INBDLVST |
STARTT |
ENDT |
End Time of Work Process |
/SCMB/INBDLVST |
ENDT |
ENDD |
End Date of Work Process |
/SCMB/INBDLVST |
ENDD |
DELTAWDAYS |
Number of work days between target and actual dates |
/SCMB/INBDLVST |
DELTAWDAYS |
DELTAWHOURS |
Difference Between Target and Actual in Hours |
/SCMB/INBDLVST |
DELTAWHOURS |
DLVSTATQTY |
Delivery Quantity per Status |
/SCMB/INBDLVST |
DLVSTATQTY |
REF_DAYS |
Time Reference in Days |
/SCMB/INBDLVST |
REF_DAYS |
DEV_REF_DAYS |
Standard Deviation for Time Reference in Days |
/SCMB/INBDLVST |
DEV_REF_DAYS |
FLAG_LATE |
Delivery Late |
/SCMB/INBDLVST |
FLAG_LATE |
UPDATETIME |
Change date |
/SCMB/INBDLVST |
UPDATETIME |
CALCULATED |
If indicator is set, the data record was calculated |
/SCMB/INBDLVST |
CALCULATED |
CUSTVAL1 |
Quantity Field Customer-Specific |
/SCMB/INBDLVST |
CUSTVAL1 |
CUSTVAL2 |
Quantity Field Customer-Specific |
/SCMB/INBDLVST |
CUSTVAL2 |
CUSTATTR1 |
Customer Definition Attribute |
/SCMB/INBDLVST |
CUSTATTR1 |
CUSTATTR2 |
Customer Definition Attribute |
/SCMB/INBDLVST |
CUSTATTR2 |
CUSTTIME1 |
Customer Definition Time Stamp (YYYYMMDDHHMMSS) |
/SCMB/INBDLVST |
CUSTTIME1 |
CUSTTIME2 |
Customer Definition Time Stamp (YYYYMMDDHHMMSS) |
/SCMB/INBDLVST |
CUSTTIME2 |
FLAG_REC_DELE |
Deletion Indicator: Marks a data record as “deleted“ If you set this indicator, the data record is deleted in BW during the next delta upload |
/SCMB/INBDLVDAT |
FLAG_REC_DELE |
UPDTMODE |
Update-Modus BW |
/SCMB/INBDLVDAT |
UPDTMODE |
PRIOP_LAST |
Priority Points |
/SCMB/INBDLVDAT |
PRIOP_LAST |
SHPTO_MASTER_FC |
Assigned Location of CP |
/SCMB/INBDLVDAT |
SHPTO_MASTER_FC |
SHPTO_MASTER_LT |
Location Type of Assigned Location to CP |
/SCMB/INBDLVDAT |
SHPTO_MASTER_LT |
Particular Features of the Extractor
The two fields REF_DLV_HDR and REF_DLV_ITM (external code for a reference delivery item) are necessary to handle the splits of inbound deliveries. The following scenario is designed for this: The supplier sends an advanced shipping notification which references three products in three items. Accordingly, the system creates an inbound delivery in SAP R/3 with three items and the status “In Transit”. When the corresponding delivery arrives at the door, it may be the case that only two of the three items are contained in the delivery. The third item could, for example, be missing in the bill of lading, so that the bill of lading and advanced shipping notification contain different data. However, it is expected that the third item will arrive at a later point in time. The goods receipt processor can therefore decide to delete the third item from the existing inbound delivery and create a new inbound delivery for this item. To enable the inbound delivery monitor to follow this third item, the new inbound delivery document must contain a reference to the old document.
Availability date (AVAIL_DATE):
The availability date is calculated from the requested delivery date plus the sum of the standard times of all work steps that follow in the inbound delivery. If the actual processing time for a work step is shorter than the associated standard time, then the availability date is adjusted accordingly. If it takes longer to process a work step than is expected in the standard time, then the availability date remains unchanged. In other words, one expects that the steps following a work step with a shorter processing time will be processed within the time defined in the standard time. With delays, however, one expects that the processing of steps that follow can be sped up, if required.