P_EWM_InboundDeliveryItem

Private view for inbound delivery item | view: PEWMINBDELIVITEM | Extraction: Not supported | Component: Delivery Processing
Tables used: /SCDL/DB_BPLOC, /SCDL/DB_DATE, /SCDL/DB_PRCODES, /SCDL/DB_STATUS, /SCDL/DB_TRANS, /SCDL/DB_PROCH_I, /SCDL/DB_PROCI_I, ADCP, ADRC, ADR6, BUT000, /SCDL/TEXCODE, /SCMB/TOENTITY, TTZZT
Column Name Description
InboundDeliveryUUID Document ID
InboundDeliveryItemUUID Item ID
Column Name Description
Column Name Description
📏 Weight Unit (DisplayWeightUnit):
ProductQuantity Quantity
ItemNetWeight null
ItemGrossWeight null
EWMDeliveryAdjustmentQuantity null
📏 Volume Unit (DisplayVolumeUnit):
ItemVolume null
Column Name Description
PlndGoodsReceiptWhseTmznDate Display Date
PlndGoodsReceiptWhseTmznTime Display Time
UnloadingEndWhseTmznDate Display Date
UnloadingEndWhseTmznTime Display Time
PutawayEndWhseTmznDate Display Date
PutawayEndWhseTmznTime Display Time
GoodsReceiptEndWhseTmznDate Display Date
GoodsReceiptEndWhseTmznTime Display Time
InbDelivCompltnEndWhseTmznDate Display Date
InbDelivCompltnEndWhseTmznTime Display Time
PlannedDeliveryWhseTmznDate Display Date
PlannedDeliveryWhseTmznTime Display Time
ActualDeliveryWhseTmznDate Display Date
ActualDeliveryWhseTmznTime Display Time
PlndArrvlInYardWhseTmznDate Display Date
PlndArrvlInYardWhseTmznTime Display Time
ActlArrvlInYardWhseTmznDate Display Date
ActlArrvlInYardWhseTmznTime Display Time
EWMWarehouseCurrentDate null
Column Name Description
Column Name Description Domain name
Warehouse Warehouse Number/Warehouse Complex /SCWM/LGNUM
EWMWarehouse Warehouse Number/Warehouse Complex /SCWM/LGNUM
InboundDelivery Document Number /SCDL/DL_DOCNO_INT
EWMInboundDelivery Document Number /SCDL/DL_DOCNO_INT
InboundDeliveryItem Item Number /SCDL/DL_ITEMNO
EWMInboundDeliveryItem Item Number /SCDL/DL_ITEMNO
InboundDeliveryDocumentType Document Type /SCDL/DL_DOCTYPE
DeliveryDocumentCategory Document Category /SCDL/DL_DOCCAT
DeliveryItemCategory Item Category /SCDL/DL_ITEMCAT
EWMInboundDeliveryItemCategory Item Category /SCDL/DL_ITEMCAT
InboundDeliveryItemType Item Type /SCDL/DL_ITEMTYPE
EWMInboundDeliveryItemType Item Type /SCDL/DL_ITEMTYPE
WarehouseProcessType Warehouse Process Type /SCWM/DO_PROCTY
WarehouseDoor Warehouse Door /SCWM/DO_DOOR
StagingAreaGroup Staging Area Group /SCWM/LGTYP
StagingArea Staging Area /SCWM/LGBER
StagingBay Staging Bay /SCWM/LGPLA
GoodsMovementBin Storage Bin of Goods Movement Posting /SCWM/LGPLA
Product Product /SCMB/MDL_PRODUCT_NO
Batch Batch Number /SCDL/DL_BATCHNO
EntitledToDisposeParty Party Entitled to Dispose BU_PARTNER
StockOwner Owner /SCMB/DO_BU_PARTNER
EWMStockOwner Owner /SCMB/DO_BU_PARTNER
StockType Stock Type /SCDL/DL_STOCK_CATEGORY
EWMStockType Stock Type /SCDL/DL_STOCK_CATEGORY
CompletionStatus Status Value /SCDL/DL_STATUS_VALUE
GoodsReceiptStatus Status Value /SCDL/DL_STATUS_VALUE
LastChangeTime UTC Date and Time TZNTSTMPS
EWMDelivLastChangeUTCDateTime UTC Date and Time TZNTSTMPS
ShipFromParty Business Partner Number BU_PARTNER
Carrier Business Partner Number BU_PARTNER
ShipFromPartyName Name 1 of organization BU_NAME
CarrierName Name 1 of organization BU_NAME
NameOfEntitledToDisposeParty null
StockOwnerName null
CurrentUTCTimestamp null
ActualPutawayEndUTCDateTime Creation Date/Time TZNTSTMPS
ActualGRStartUTCDateTime Creation Date/Time TZNTSTMPS
PlannedGRStartUTCDateTime Creation Date/Time TZNTSTMPS
ActualGREndUTCDateTime Creation Date/Time TZNTSTMPS
PlannedGREndUTCDateTime Creation Date/Time TZNTSTMPS
UnloadingEndUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
InbDelivCompltnEndUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ActualArrivalInYardUTCDateTime Creation Date/Time TZNTSTMPS
PlndArrivalInYardUTCDateTime Creation Date/Time TZNTSTMPS
TransportationUnitAssgmtStatus Status Value /SCDL/DL_STATUS_VALUE
PlanningPutawayStatus Status Value /SCDL/DL_STATUS_VALUE
CheckToleranceStatus Status Value /SCDL/DL_STATUS_VALUE
GoodsMovementBlockStatus Status Value /SCDL/DL_STATUS_VALUE
QualityMgmtInspectionStatus Status Value /SCDL/DL_STATUS_VALUE
QualityMgmtInspPlngStatus Status Value /SCDL/DL_STATUS_VALUE
QualityMgmtCountPlngStatus Status Value /SCDL/DL_STATUS_VALUE
PutawayStatus Status Value /SCDL/DL_STATUS_VALUE
ValuationQtyAssignmentStatus Status Value /SCDL/DL_STATUS_VALUE
ValueAddedServiceOrderStatus Status Value /SCDL/DL_STATUS_VALUE
UnloadingStatus Status Value /SCDL/DL_STATUS_VALUE
TransitStatus Status Value /SCDL/DL_STATUS_VALUE
TransitProcedureStatus Status Value /SCDL/DL_STATUS_VALUE
TransportationPlanningStatus Status Value /SCDL/DL_STATUS_VALUE
OverallBlockStatus Status Value /SCDL/DL_STATUS_VALUE
ItemInconsistencyBlkStatus Status Value /SCDL/DL_STATUS_VALUE
TranspPlanBlockStatus Status Value /SCDL/DL_STATUS_VALUE
WarehouseActivityStatus Status Value /SCDL/DL_STATUS_VALUE
MeansOfTransport Means-of-Transport ID /SCDL/DL_TRANSMEANS_ID
EWMMeansOfTransport Means-of-Transport ID /SCDL/DL_TRANSMEANS_ID
MeansOfTransportType Means of Transport /SCDL/DL_TRANSMEANS_TYPE
EWMMeansOfTransportType Means of Transport /SCDL/DL_TRANSMEANS_TYPE
IsBusinessPurposeCompleted null
InbDelivItemCrtnUTCDateTime UTC Date and Time TZNTSTMPS
PlndGREndWhseTmznDateTime Date and Time of Planned Goods Receipt TZNTSTMPS
PlndGoodsReceiptWhseTmznYear Display Date (Year) NUM4
PlndGoodsReceiptWhseTmznMonth Display Date (Month) NUM6
PlndGoodsReceiptWhseTmznHour Display Time (Hour)
UnloadingEndWhseTmznDateTime End Date and Time of Unloading TZNTSTMPS
UnloadingEndWhseTmznYear Display Date (Year) NUM4
UnloadingEndWhseTmznMonth Display Date (Month) NUM6
UnloadingEndWhseTmznHour Display Time (Hour)
PutawayEndWhseTmznDateTime End Date and Time of Putaway TZNTSTMPS
PutawayEndWhseTmznYear Display Date (Year) NUM4
PutawayEndWhseTmznMonth Display Date (Month) NUM6
PutawayEndWhseTmznHour Display Time (Hour)
ActualGREndWhseTmznDateTime Goods Receipt Ended On TZNTSTMPS
GoodsReceiptEndWhseTmznYear Display Date (Year) NUM4
GoodsReceiptEndWhseTmznMonth Display Date (Month) NUM6
GoodsReceiptEndWhseTmznHour Display Time (Hour)
InbDelivItmCmpltWhseTmznDteTme Completion Date and Time TZNTSTMPS
InbDelivCompltnEndWhseTmznYear Display Date (Year) NUM4
InbDelivCompltnEndWhseTmznMnth Display Date (Month) NUM6
InbDelivCompltnEndWhseTmznHour Display Time (Hour)
InbDelivCrtnWhseTmznDateTime Created On TZNTSTMPS
PlndDeliveryWhseTmznDateTime Planned Delivery Date and Time TZNTSTMPS
ActualDeliveryWhseTmznDateTime Delivery Date and Time TZNTSTMPS
PlndArrvlInYardWhseTmznDteTme Planned Arrival Date and Time in Yard TZNTSTMPS
ActlArrvlInYardWhseTmznDteTme Arrival Time in Yard TZNTSTMPS
PlannedDeliveryWhseTmznYear Display Date (Year) NUM4
PlannedDeliveryWhseTmznMonth Display Date (Month) NUM6
PlannedDeliveryWhseTmznHour Display Time (Hour)
ActualDeliveryWhseTmznYear Display Date (Year) NUM4
ActualDeliveryWhseTmznMonth Display Date (Month) NUM6
ActualDeliveryWhseTmznHour Display Time (Hour)
PlndArrvlInYardWhseTmznYear Display Date (Year) NUM4
PlndArrvlInYardWhseTmznMonth Display Date (Month) NUM6
PlndArrvlInYardWhseTmznHour Display Time (Hour)
ActlArrvlInYardWhseTmznYear Display Date (Year) NUM4
ActlArrvlInYardWhseTmznMonth Display Date (Month) NUM6
ActlArrvlInYardWhseTmznHour Display Time (Hour)
WhseTmznPlannedDeliverymins null
WhseTmznPlndArrivalinYardmins null
WhseTmznActualDeliverymins null
WhseTmznActualArrvlinYardmins null
TimeZoneID Time Zone TZNZONE
WhseTmznItemCreationmins null
WhseTmznCompletionEndmins null
WhseTmznGoodsReceiptEndmins null
WhseTmznPutawayEndmins null
WhseTmznUnloadingEndmins null
ReceivingOffice Location Number /SCDL/DL_LOCATIONNO
EWMQuantityHasAdjustment Delivery Quantity Has Adjustments CHAR1
EWMPlndGRDateIsInPast Planned Goods Receipt Date Is in Past CHAR1
EWMActualGRDateIsOnTime Actual Goods Receipt Is on Time CHAR1
EWMPlndDeliveryTimeIsInPast Planned Delivery Time Is in Past CHAR1
EWMActGRIsBeforePlndDelivTime Actual Goods Receipt Date Is Before Planned Delivery Date CHAR1