C_RDPDeliveryDocumentItemDEX

Delivery Document Item Extractor for RDP | view: CRDPDLVYDCITMDEX | TRAN | Extraction: Full or Incremental | Component: Sustainability - RDP integration with S4
Tables used: LIKP, LIPS
Column Name Description
DeliveryDocument FK Delivery
DeliveryDocumentItem Delivery Item
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
ActualDeliveredQtyInBaseUnit Actual quantity delivered in stockkeeping units
📏 Sales unit (DeliveryQuantityUnit):
ActualDeliveryQuantity Actual quantity delivered (in sales units)
Column Name Description
CreationDate Date on which the record was created
CreationTime Entry time
LastChangeDate Last Changed On
Column Name Description
OverallGoodsMovementStatus Goods Movement Status (All Items) Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_RDPDELIVERYDOCUMENTITEMDEX.BASEUNIT == T006.MSEHI
  • C_RDPDELIVERYDOCUMENTITEMDEX.MANDT == T006.MANDT
Batch Number
  • Batch Number
  • Client
  • Plant
  • Material Number
  • C_RDPDELIVERYDOCUMENTITEMDEX.BATCH == MCHA.CHARG
  • C_RDPDELIVERYDOCUMENTITEMDEX.MANDT == MCHA.MANDT
  • C_RDPDELIVERYDOCUMENTITEMDEX.PLANT == MCHA.WERKS
  • C_RDPDELIVERYDOCUMENTITEMDEX.MATERIAL == MCHA.MATNR
Delivery item category
  • Client
  • Delivery item category
  • C_RDPDELIVERYDOCUMENTITEMDEX.MANDT == TVPT.MANDT
  • C_RDPDELIVERYDOCUMENTITEMDEX.DELIVERYDOCUMENTITEMCATEGORY == TVPT.PSTYV
Delivery Type
  • Delivery Type
  • Client
  • C_RDPDELIVERYDOCUMENTITEMDEX.DELIVERYDOCUMENTTYPE == TVLK.LFART
  • C_RDPDELIVERYDOCUMENTITEMDEX.MANDT == TVLK.MANDT
Sales unit
  • Client
  • Sales unit
  • C_RDPDELIVERYDOCUMENTITEMDEX.MANDT == T006.MANDT
  • C_RDPDELIVERYDOCUMENTITEMDEX.DELIVERYQUANTITYUNIT == T006.MSEHI
Distribution Channel
  • Client
  • Distribution Channel
  • C_RDPDELIVERYDOCUMENTITEMDEX.MANDT == TVTW.MANDT
  • C_RDPDELIVERYDOCUMENTITEMDEX.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_RDPDELIVERYDOCUMENTITEMDEX.MANDT == TSPA.MANDT
  • C_RDPDELIVERYDOCUMENTITEMDEX.DIVISION == TSPA.SPART
Material Number
  • Client
  • Material Number
  • C_RDPDELIVERYDOCUMENTITEMDEX.MANDT == MARA.MANDT
  • C_RDPDELIVERYDOCUMENTITEMDEX.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • C_RDPDELIVERYDOCUMENTITEMDEX.MANDT == T001W.MANDT
  • C_RDPDELIVERYDOCUMENTITEMDEX.PLANT == T001W.WERKS