P_SlsOrdDelivPerfCardCube

Sales Document Item Analytical Cube for OVP Card | view: PSOIDLVPERFCARD | Extraction: Not supported | Component: Delivery Document Analytical Apps
Column Name Description
SalesOrder FK Sales Order
SalesOrderItem Sales Order Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of Sales Order Item in Transaction Currency
IncomingSalesOrdersNetAmount Incoming Sales Orders Net Value in Transaction Currency
DlvrdAsReqdSlsDocItmNetAmt Items Delivered as Requested Value in Transaction Currency
ShpdAsPlndSlsDocItmNetAmt Items Shipped as Planned Value in Transaction Currency
Column Name Description
Column Name Description
CreationDate Document Date (Date Received/Sent)
RequestedDeliveryDate Requested Delivery Date
EarliestReqdDelivDate Requested Delivery Date of Earliest Scheduled Delivery
EarliestPlndGIDate Planned Goods Issue Date of Earliest Scheduled Delivery
Column Name Description
SDDocumentCategory SD Document Category Show values
IsReturnsItem Returns Item Show values
StatisticalValueControl Statistical Values Show values
SlsDocItmDelivFlfmtSts Processing Status of Sales Order Item Delivery Fulfillment Show values
Column Name Description Domain name
SalesOrderType Sales Document Type AUART
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Organization Division SPART
SalesOffice Sales office VKBUR
Plant Plant (Own or External) WERKS
ProductionPlantName Plant Name TEXT30
SoldToParty Sold-to Party KUNNR
SoldToPartyName Name of Sold-to Party TEXT80
ShipToParty Ship-to Party KUNNR
ShipToPartyName Name of Ship-to Party TEXT80
NumberOfIncomingSlsOrderItems Number of Incoming Sales Order Items
NmbrOfDlvrdAsReqdSlsDocItems Number of Sales Order Items Delivered as Requested
NmbrOfShippedAsPlndSlsDocItems Number of Sales Order Items Shipped as Planned
DelivToReqdDelivDelayInDays Delay of Delivery Compared to Requested Deliv. Date (Days)
MaxDelivToReqdDelivDelayInDays Max. Delay of Deliv. Compared to the Reqd Deliv. Date (Days)
TotDelivToReqdDelivDelayInDays Tot. Delay of Deliv. Compared to the Reqd Deliv. Date (Days)
GIToPlndGIDelayInDays Delay of Goods Issue Compared to the Planned GI Date (Days)
MaxGIToPlndGIDelayInDays Max. Delay of GI Compared to the Planned GI Date (Days)
TotGIToPlndGIDelayInDays Tot. Delay of GI Compared to the Planned GI Date (Days)
Master Data Relations Join Conditions
Delivery Type
  • Delivery Type
  • Client
  • P_SLSORDDELIVPERFCARDCUBE.DELIVERYDOCUMENTTYPE == TVLK.LFART
  • P_SLSORDDELIVPERFCARDCUBE.MANDT == TVLK.MANDT
Delivery Priority
  • Client
  • Delivery Priority
  • P_SLSORDDELIVPERFCARDCUBE.MANDT == TPRIO.MANDT
  • P_SLSORDDELIVPERFCARDCUBE.DELIVERYPRIORITY == TPRIO.LPRIO
Division
  • Division
  • Client
  • P_SLSORDDELIVPERFCARDCUBE.DIVISION == TSPA.SPART
  • P_SLSORDDELIVPERFCARDCUBE.MANDT == TSPA.MANDT
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • P_SLSORDDELIVPERFCARDCUBE.MANDT == TINC.MANDT
  • P_SLSORDDELIVPERFCARDCUBE.INCOTERMSCLASSIFICATION == TINC.INCO1
Material: order item
  • Client
  • Material Number
  • P_SLSORDDELIVPERFCARDCUBE.MANDT == MARA.MANDT
  • P_SLSORDDELIVPERFCARDCUBE.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_SLSORDDELIVPERFCARDCUBE.MANDT == T023.MANDT
  • P_SLSORDDELIVPERFCARDCUBE.MATERIALGROUP == T023.MATKL
Route
  • Client
  • Route
  • P_SLSORDDELIVPERFCARDCUBE.MANDT == TVRO.MANDT
  • P_SLSORDDELIVPERFCARDCUBE.ROUTE == TVRO.ROUTE
Shipping Conditions
  • Shipping Conditions
  • Client
  • P_SLSORDDELIVPERFCARDCUBE.SHIPPINGCONDITION == TVSB.VSBED
  • P_SLSORDDELIVPERFCARDCUBE.MANDT == TVSB.MANDT
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • P_SLSORDDELIVPERFCARDCUBE.MANDT == TVST.MANDT
  • P_SLSORDDELIVPERFCARDCUBE.SHIPPINGPOINT == TVST.VSTEL
Shipping Type
  • Client
  • Shipping Type
  • P_SLSORDDELIVPERFCARDCUBE.MANDT == T173.MANDT
  • P_SLSORDDELIVPERFCARDCUBE.SHIPPINGTYPE == T173.VSART
Customer Classification
  • Client
  • Customer Classification
  • P_SLSORDDELIVPERFCARDCUBE.MANDT == TKUKL.MANDT
  • P_SLSORDDELIVPERFCARDCUBE.SOLDTOPARTYCLASSIFICATION == TKUKL.KUKLA
SD Document Currency
  • Client
  • SD Document Currency
  • P_SLSORDDELIVPERFCARDCUBE.MANDT == TCURC.MANDT
  • P_SLSORDDELIVPERFCARDCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
Transportation Group
  • Client
  • Transportation Group
  • P_SLSORDDELIVPERFCARDCUBE.MANDT == TTGR.MANDT
  • P_SLSORDDELIVPERFCARDCUBE.TRANSPORTATIONGROUP == TTGR.TRAGR
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • P_SLSORDDELIVPERFCARDCUBE.WAREHOUSE == T300.LGNUM
  • P_SLSORDDELIVPERFCARDCUBE.MANDT == T300.MANDT