I_EWM_InboundDeliveryItemC

Inbound Delivery Item - Cube | view: IEWMINBDELIVC | TRAN | 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, MARA, ADCP, ADRC, ADR6, BUT000, /SCDL/TITMCAT, /SCDL/TITMCATT, /SCDL/TITYPE, /SCDL/TITYPET, /SCDL/TDTYPE, /SCDL/TDTYPET, /SAPAPO/TRTYPET, /SAPAPO/TRTYPE, /SCDL/TEXCODE, /SCWM/TCAT, /SCWM/TCAT_TXT, /SCMB/TOENTITY, TTZZT, /LIME/CUST_CATSP, /SCWM/T333, /SCWM/T333T, MAKT, TJ02T
Column Name Description
InboundDeliveryUUID Document ID
InboundDeliveryItemUUID Item ID
Column Name Description
Column Name Description
📏 Unit of Measure (QuantityUnit):
ProductQuantity Quantity
📏 Volume Unit (DisplayVolumeUnit):
ItemVolume null
📏 Weight Unit (DisplayWeightUnit):
ItemNetWeight null
ItemGrossWeight 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
Column Name Description
Column Name Description Domain name
Warehouse Warehouse Number/Warehouse Complex /SCWM/LGNUM
InboundDelivery Document Number /SCDL/DL_DOCNO_INT
InboundDeliveryItem Item Number /SCDL/DL_ITEMNO
NumberOfInbDelivItems null
ReceivingOffice Location Number /SCDL/DL_LOCATIONNO
MeansOfTransportType Means of Transport /SCDL/DL_TRANSMEANS_TYPE
MeansOfTransportTypeName Means of Transport Description /SAPAPO/TR_TRATYDESCR
MeansOfTransport Means-of-Transport ID /SCDL/DL_TRANSMEANS_ID
DeliveryItemCategory Item Category /SCDL/DL_ITEMCAT
DeliveryDocumentCategory Document Category /SCDL/DL_DOCCAT
DeliveryItemCategoryName Description TEXT40
InboundDeliveryDocumentType Document Type /SCDL/DL_DOCTYPE
InbDeliveryDocumentTypeName Description TEXT40
InboundDeliveryItemType Item Type /SCDL/DL_ITEMTYPE
InboundDeliveryItemTypeName Description TEXT40
WarehouseProcessType Warehouse Process Type /SCWM/DO_PROCTY
WarehouseProcessTypeName Description /SCWM/DO_DESC40
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
ProductName Product Description TEXT40
Batch Batch Number /SCDL/DL_BATCHNO
EntitledToDisposeParty Party Entitled to Dispose BU_PARTNER
NameOfEntitledToDisposeParty null
ShipFromParty Business Partner Number BU_PARTNER
ShipFromPartyName Name 1 of organization BU_NAME
IsBusinessPurposeCompleted null
Carrier Business Partner Number BU_PARTNER
CarrierName Name 1 of organization BU_NAME
TimeZoneID Time Zone TZNZONE
StockOwner Owner /SCMB/DO_BU_PARTNER
StockOwnerName null
StockType Stock Type /SCDL/DL_STOCK_CATEGORY
StockTypeName Description of Stock Type /LIME/STOCK_CATEGORY_TXT
CompletionStatus Status Value /SCDL/DL_STATUS_VALUE
CompletionStatusName null
UnloadingStatus Status Value /SCDL/DL_STATUS_VALUE
UnloadingStatusName null
PutawayStatus Status Value /SCDL/DL_STATUS_VALUE
PutawayStatusName null
GoodsReceiptStatus Status Value /SCDL/DL_STATUS_VALUE
GoodsReceiptStatusName null
QualityMgmtCountPlngStatus Status Value /SCDL/DL_STATUS_VALUE
QualityMgmtCountPlngStatusName null
QualityMgmtInspPlngStatus Status Value /SCDL/DL_STATUS_VALUE
QualityMgmtInspPlngStsName null
QualityMgmtInspectionStatus Status Value /SCDL/DL_STATUS_VALUE
QualityMgmtInspectionStsName null
GoodsMovementBlockStatus Status Value /SCDL/DL_STATUS_VALUE
GoodsMovementBlockStatusName null
CheckToleranceStatus Status Value /SCDL/DL_STATUS_VALUE
CheckToleranceStatusName null
PlanningPutawayStatus Status Value /SCDL/DL_STATUS_VALUE
PlanningPutawayStatusName null
TransportationUnitAssgmtStatus Status Value /SCDL/DL_STATUS_VALUE
TranspUnitAssgmtStatusName null
ValueAddedServiceOrderStatus Status Value /SCDL/DL_STATUS_VALUE
ValueAddedDelivStsName null
ValuationQtyAssignmentStatus Status Value /SCDL/DL_STATUS_VALUE
ValuationQtyAssgmtStatusName null
WarehouseActivityStatus Status Value /SCDL/DL_STATUS_VALUE
WarehouseActivityStatusName null
TransitStatus Status Value /SCDL/DL_STATUS_VALUE
TransitStatusName null
TransitProcedureStatus Status Value /SCDL/DL_STATUS_VALUE
TransitProcedureStatusName null
TransportationPlanningStatus Status Value /SCDL/DL_STATUS_VALUE
TranspPlngStatusName null
OverallBlockStatus Status Value /SCDL/DL_STATUS_VALUE
OverallBlockStatusName null
ItemInconsistencyBlkStatus Status Value /SCDL/DL_STATUS_VALUE
ItemInconsistencyBlkStatusName null
TranspPlanBlockStatus Status Value /SCDL/DL_STATUS_VALUE
TranspPlanBlockStatusName null
WarehouseLocation Location Number /SCDL/DL_LOCATIONNO
InbDelivCompltnEndUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ActualGRStartUTCDateTime Creation Date/Time TZNTSTMPS
PlannedGRStartUTCDateTime Creation Date/Time TZNTSTMPS
ActualPutawayEndUTCDateTime Creation Date/Time TZNTSTMPS
UnloadingEndUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ActualGREndUTCDateTime Creation Date/Time TZNTSTMPS
PlannedGREndUTCDateTime Creation Date/Time TZNTSTMPS
InbDelivItemCrtnUTCDateTime UTC Date and Time TZNTSTMPS
PutawayEndWhseTmznDateTime End Date and Time of Putaway TZNTSTMPS
ActualGREndWhseTmznDateTime Goods Receipt Ended On TZNTSTMPS
UnloadingEndWhseTmznDateTime End Date and Time of Unloading TZNTSTMPS
InbDelivItmCmpltWhseTmznDteTme Completion Date and Time TZNTSTMPS
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
PlndGREndWhseTmznDateTime Date and Time of Planned Goods Receipt TZNTSTMPS
PlndGoodsReceiptWhseTmznYear Display Date (Year) NUM4
PlndGoodsReceiptWhseTmznMonth Display Date (Month) NUM6
PlndGoodsReceiptWhseTmznHour Display Time (Hour)
UnloadingEndWhseTmznYear Display Date (Year) NUM4
UnloadingEndWhseTmznMonth Display Date (Month) NUM6
UnloadingEndWhseTmznHour Display Time (Hour)
PutawayEndWhseTmznYear Display Date (Year) NUM4
PutawayEndWhseTmznMonth Display Date (Month) NUM6
PutawayEndWhseTmznHour Display Time (Hour)
GoodsReceiptEndWhseTmznYear Display Date (Year) NUM4
GoodsReceiptEndWhseTmznMonth Display Date (Month) NUM6
GoodsReceiptEndWhseTmznHour Display Time (Hour)
InbDelivCompltnEndWhseTmznYear Display Date (Year) NUM4
InbDelivCompltnEndWhseTmznMnth Display Date (Month) NUM6
InbDelivCompltnEndWhseTmznHour Display Time (Hour)
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)
ActualArrivalInYardUTCDateTime Creation Date/Time TZNTSTMPS
PlndArrivalInYardUTCDateTime Creation Date/Time TZNTSTMPS
NoWhseActivityTimeInMinutes null
ArrivalInYardOvrdDurnInMinutes null
WaitInYardDurationInMinutes null
GoodsReceiptDurationInMinutes null
PlndDelivTo30MinsWhseDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
PlndDelivTo60MinsWhseDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
PlndArrvlTo30MinsWhseDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
PlndArrvlTo60MinsWhseDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ActlDelivTo30MinsWhseDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ActlDelivTo60MinsWhseDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ActlArrvlTo30MinsWhseDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ActlArrvlTo60MinsWhseDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CompltnEndTo30MinsWhseDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CompltnEndTo60MinsWhseDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
GREndRnddTo30MinsWhseDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
GREndRnddTo60MinsWhseDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
PtwyEndRnddTo30MinsWhseDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
PtwyEndRnddTo60MinsWhseDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
UnldgEndRnddTo30MinsWhseDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
UnldgEndRnddTo60MinsWhseDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
EWMPlndGRWhseTmznHour Planned GR Time in Hours (Whse Time Zone) CHAR2
EWMPlndDeliveryWhseTmznHour Planned Delivey Time in Hours (Warehouse Time Zone) CHAR2
EWMPlndGoodsReceiptDateIsToday Planned Goods Receipt Date Is Today (Whse Time Zone) CHAR1
EWMActualPutawayDateIsToday Actual Putaway Date Is Today (Warehouse Time Zone) CHAR1
EWMPlndOrActGRIsToday Planned/Actual Goods Receipt Date Is Today CHAR1
EWMPlndDeliveryDateIsToday Planned Delivery Date Is Today (Warehouse Time Zone) CHAR1
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