P_STOItemAnlyts

Basic STO Item Analytical View | view: PSTOITMANLY | Extraction: Not supported | Component: Delivery Document Analytical Apps
Tables used: LIKP, LIPS, EKKO, EKPO, EKPV, EKET, TPAR, EKPA
Column Name Description
PurchaseOrder FK Stock Transport Order
POItem Stock Transport Order Item
Column Name Description
💲 Currency Key (DocumentCurrency):
NetAmount Net Order Value in PO Currency
IncomingOrdersNetAmount 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
STODeliveredQuantity null
Column Name Description
PurchaseOrderDate Creation Date of Purchasing Document
EarliestReqDelivDate Requested Delivery Date of Earliest Scheduled Delivery
EarliestPlndGIDate Planned Goods Issue Date of Earliest Scheduled Delivery
Column Name Description
PurchaseOrderCategory Purchasing Document Category Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
SlsDocItmDelivFlfmtSts Processing Status of Sales Order Item Delivery Fulfillment Show values
IsReturnsItem Returns Item Show values
PartiallyDelivered Indicator of partially delivered Stock Transport Order Item Show values
Column Name Description Domain name
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Stock Transport Order Item EBELP
NumberOfIncomingOrderItems Number of Incoming Sales Order Items
NmbrOfDlvrdAsReqdSlsDocItems Number of Sales Order Items Delivered as Requested
DelivToReqdDelivDelayInDays Delay of Delivery Compared to Requested Deliv. Date (Days)
NmbrOfShippedAsPlndSlsDocItems Number of Sales Order Items Shipped as Planned
GIToPlndGIDelayInDays Delay of Goods Issue Compared to the Planned GI Date (Days)
Master Data Relations Join Conditions
Route
  • Route
  • Client
  • P_STOITEMANLYTS.DELIVERYROUTE == TVRO.ROUTE
  • P_STOITEMANLYTS.MANDT == TVRO.MANDT
Delivery Type
  • Delivery Type
  • Client
  • P_STOITEMANLYTS.DELIVERYTYPE == TVLK.LFART
  • P_STOITEMANLYTS.MANDT == TVLK.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • P_STOITEMANLYTS.DELIVPRIO == TPRIO.LPRIO
  • P_STOITEMANLYTS.MANDT == TPRIO.MANDT
Shipping Conditions
  • Shipping Conditions
  • Client
  • P_STOITEMANLYTS.DELIVSHPCONDT == TVSB.VSBED
  • P_STOITEMANLYTS.MANDT == TVSB.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • P_STOITEMANLYTS.DELIVSHPPOINT == TVST.VSTEL
  • P_STOITEMANLYTS.MANDT == TVST.MANDT
Currency Key
  • Currency Key
  • Client
  • P_STOITEMANLYTS.DOCUMENTCURRENCY == TCURC.WAERS
  • P_STOITEMANLYTS.MANDT == TCURC.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • P_STOITEMANLYTS.FORWARDINGAGENT == LFA1.LIFNR
  • P_STOITEMANLYTS.MANDT == LFA1.MANDT
Material Group
  • Material Group
  • Client
  • P_STOITEMANLYTS.MATERIALGROUP == T023.MATKL
  • P_STOITEMANLYTS.MANDT == T023.MANDT
Material Number
  • Material Number
  • Client
  • P_STOITEMANLYTS.MATERIALNUMBER == MARA.MATNR
  • P_STOITEMANLYTS.MANDT == MARA.MANDT
Purchase Order Type
  • Purchase Order Type
  • Purchasing Document Category
  • Client
  • P_STOITEMANLYTS.ORDERTYPE == T161.BSART
  • P_STOITEMANLYTS.PURCHASEORDERCATEGORY == T161.BSTYP
  • P_STOITEMANLYTS.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_STOITEMANLYTS.PURCHASINGGROUP == T024.EKGRP
  • P_STOITEMANLYTS.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_STOITEMANLYTS.PURCHASINGORG == T024E.EKORG
  • P_STOITEMANLYTS.MANDT == T024E.MANDT
Plant
  • Plant
  • Client
  • P_STOITEMANLYTS.RECEIVINGPLANT == T001W.WERKS
  • P_STOITEMANLYTS.MANDT == T001W.MANDT
Customer Number
  • Customer Number
  • Client
  • P_STOITEMANLYTS.SHIPTOPARTY == KNA1.KUNNR
  • P_STOITEMANLYTS.MANDT == KNA1.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • P_STOITEMANLYTS.SOLDTOPARTY == KNA1.KUNNR
  • P_STOITEMANLYTS.MANDT == KNA1.MANDT
Supplying (issuing) plant in case of stock transport order
  • Supplying (issuing) plant in case of stock transport order
  • Client
  • P_STOITEMANLYTS.SUPPLPLANT == T001W.WERKS
  • P_STOITEMANLYTS.MANDT == T001W.MANDT
Transportation Group
  • Transportation Group
  • Client
  • P_STOITEMANLYTS.TRANSPORTATIONGROUP == TTGR.TRAGR
  • P_STOITEMANLYTS.MANDT == TTGR.MANDT
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • P_STOITEMANLYTS.WAREHOUSENUMBER == T300.LGNUM
  • P_STOITEMANLYTS.MANDT == T300.MANDT