P_DeliveryItemGIDelayCalc

Calculate Delay in Days for Delivery Items | view: PDLVISHAPDELAY | TRAN | Extraction: Not supported | Component: Delivery Document Analytical Apps
Tables used: LIKP, LIPS, VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, KNA1, CVI_CUST_LINK, CVI_VEND_LINK
Column Name Description
OutboundDelivery FK Outbound Delivery
OutboundDeliveryItem Outbound Delivery Item
Column Name Description
Column Name Description
Column Name Description
PlannedGoodsIssueDate Planned Goods Movement Date
AdjustedPlannedGoodsIssueDate Adjusted PLanned GI Date
ActualGoodsMovementDate Actual Goods Movement Date
CreationDate Date on which the record was created
Column Name Description
OverallGoodsMovementStatus Goods Movement Status (All Items) Show values
GoodsMovementStatus Goods Movement Status (Item) Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
Column Name Description Domain name
NmbrOfShpdAsPlndDelivItems Number of Delivery Items Shipped as Planned
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
GIToPlndGIDelayInDays Delay of Goods Issue Compared to the Planned GI Date (Days)
Master Data Relations Join Conditions
Customer Classification
  • Customer Classification
  • Client
  • P_DELIVERYITEMGIDELAYCALC.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • P_DELIVERYITEMGIDELAYCALC.MANDT == TKUKL.MANDT
Delivery Type
  • Delivery Type
  • Client
  • P_DELIVERYITEMGIDELAYCALC.DELIVERYDOCUMENTTYPE == TVLK.LFART
  • P_DELIVERYITEMGIDELAYCALC.MANDT == TVLK.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • P_DELIVERYITEMGIDELAYCALC.DELIVERYPRIORITY == TPRIO.LPRIO
  • P_DELIVERYITEMGIDELAYCALC.MANDT == TPRIO.MANDT
Vendor - Document Vendor
  • Account Number of Supplier
  • Client
  • P_DELIVERYITEMGIDELAYCALC.FORWARDINGAGENT == LFA1.LIFNR
  • P_DELIVERYITEMGIDELAYCALC.MANDT == LFA1.MANDT
Material Number
  • Product Number
  • Material Number
  • Client
  • P_DELIVERYITEMGIDELAYCALC.PRODUCT == MARA.MATNR
  • P_DELIVERYITEMGIDELAYCALC.MATERIAL == MARA.MATNR
  • P_DELIVERYITEMGIDELAYCALC.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Product Group
  • Client
  • P_DELIVERYITEMGIDELAYCALC.MATERIALGROUP == T023.MATKL
  • P_DELIVERYITEMGIDELAYCALC.PRODUCTGROUP == T023.MATKL
  • P_DELIVERYITEMGIDELAYCALC.MANDT == T023.MANDT
Plant
  • Plant
  • Receiving Plant for Deliveries
  • Client
  • P_DELIVERYITEMGIDELAYCALC.PLANT == T001W.WERKS
  • P_DELIVERYITEMGIDELAYCALC.RECEIVINGPLANT == T001W.WERKS
  • P_DELIVERYITEMGIDELAYCALC.MANDT == T001W.MANDT
Product Number
  • Product Number
  • Material Number
  • Client
  • P_DELIVERYITEMGIDELAYCALC.PRODUCT == MARA.MATNR
  • P_DELIVERYITEMGIDELAYCALC.MATERIAL == MARA.MATNR
  • P_DELIVERYITEMGIDELAYCALC.MANDT == MARA.MANDT
Product Group
  • Material Group
  • Product Group
  • Client
  • P_DELIVERYITEMGIDELAYCALC.MATERIALGROUP == T023.MATKL
  • P_DELIVERYITEMGIDELAYCALC.PRODUCTGROUP == T023.MATKL
  • P_DELIVERYITEMGIDELAYCALC.MANDT == T023.MANDT
Route
  • Route
  • Client
  • P_DELIVERYITEMGIDELAYCALC.PROPOSEDDELIVERYROUTE == TVRO.ROUTE
  • P_DELIVERYITEMGIDELAYCALC.MANDT == TVRO.MANDT
Receiving Plant for Deliveries
  • Plant
  • Receiving Plant for Deliveries
  • Client
  • P_DELIVERYITEMGIDELAYCALC.PLANT == T001W.WERKS
  • P_DELIVERYITEMGIDELAYCALC.RECEIVINGPLANT == T001W.WERKS
  • P_DELIVERYITEMGIDELAYCALC.MANDT == T001W.MANDT
Shipping Conditions
  • Shipping Conditions
  • Client
  • P_DELIVERYITEMGIDELAYCALC.SHIPPINGCONDITION == TVSB.VSBED
  • P_DELIVERYITEMGIDELAYCALC.MANDT == TVSB.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • P_DELIVERYITEMGIDELAYCALC.SHIPPINGPOINT == TVST.VSTEL
  • P_DELIVERYITEMGIDELAYCALC.MANDT == TVST.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • P_DELIVERYITEMGIDELAYCALC.SHIPTOPARTY == KNA1.KUNNR
  • P_DELIVERYITEMGIDELAYCALC.MANDT == KNA1.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • P_DELIVERYITEMGIDELAYCALC.SOLDTOPARTY == KNA1.KUNNR
  • P_DELIVERYITEMGIDELAYCALC.MANDT == KNA1.MANDT
Transportation Group
  • Transportation Group
  • Client
  • P_DELIVERYITEMGIDELAYCALC.TRANSPORTATIONGROUP == TTGR.TRAGR
  • P_DELIVERYITEMGIDELAYCALC.MANDT == TTGR.MANDT
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • P_DELIVERYITEMGIDELAYCALC.WAREHOUSE == T300.LGNUM
  • P_DELIVERYITEMGIDELAYCALC.MANDT == T300.MANDT