P_STOItemAnlyts_2

STO Item Analytical View | view: PSTOITMANLY_2 | Extraction: Not supported | Component: Delivery Document Analytical Apps
Tables used: LIKP, LIPS, EKKO, EKPO, EKPV, EKET, KNA1, MARC, TPAR, EKPA
Column Name Description
PurchaseOrder FK Stock Transport Order
POItem Stock Transport Order Item
Column Name Description
💲 Display Currency (DisplayCurrency):
IncomingOrdersNetAmount Incoming Sales Orders Net Value in Transaction Currency
NetAmountInDisplayCurrency Net Value in Display Currency
DlvrdAsReqdSlsDocItmNetAmt Items Delivered as Requested Value in Transaction Currency
DlvrdAsReqdSlsDocItmAmtinDC Net Value in Display Currency
ShpdAsPlndSlsDocItmNetAmt Items Shipped as Planned Value in Transaction Currency
ShpdAsPlndSlsDocItmNetAmtinDC Net Value in Display Currency
Column Name Description
Column Name Description
PurchaseOrderDate Creation Date of Purchasing Document
EarliestPlndGIDate Planned Goods Issue Date of Earliest Scheduled Delivery
EarliestReqDelivDate Requested Delivery Date of Earliest Scheduled Delivery
Column Name Description
PurchaseOrderCategory Purchasing Document Category Show values
SlsDocItmDelivFlfmtSts Processing Status of Sales Order Item Delivery Fulfillment Show values
IsReturnsItem Returns Item Show values
Column Name Description Domain name
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)
MaxDelivToReqdDelivDelayInDays Max. Delay of Deliv. Compared to the Reqd Deliv. Date (Days)
TotDelivToReqdDelivDelayInDays Tot. Delay of Deliv. Compared to the Reqd Deliv. Date (Days)
NmbrOfShippedAsPlndSlsDocItems Number of Sales Order Items Shipped as Planned
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
Customer Classification
  • Customer Classification
  • Client
  • P_STOITEMANLYTS_2.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • P_STOITEMANLYTS_2.MANDT == TKUKL.MANDT
Route
  • Client
  • Route
  • P_STOITEMANLYTS_2.MANDT == TVRO.MANDT
  • P_STOITEMANLYTS_2.DELIVERYROUTE == TVRO.ROUTE
Delivery Type
  • Client
  • Delivery Type
  • P_STOITEMANLYTS_2.MANDT == TVLK.MANDT
  • P_STOITEMANLYTS_2.DELIVERYTYPE == TVLK.LFART
Delivery Priority
  • Delivery Priority
  • Client
  • P_STOITEMANLYTS_2.DELIVPRIO == TPRIO.LPRIO
  • P_STOITEMANLYTS_2.MANDT == TPRIO.MANDT
Shipping Conditions
  • Shipping Conditions
  • Client
  • P_STOITEMANLYTS_2.DELIVSHPCONDT == TVSB.VSBED
  • P_STOITEMANLYTS_2.MANDT == TVSB.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • P_STOITEMANLYTS_2.DELIVSHPPOINT == TVST.VSTEL
  • P_STOITEMANLYTS_2.MANDT == TVST.MANDT
Currency Key
  • Currency Key
  • Client
  • P_STOITEMANLYTS_2.DOCUMENTCURRENCY == TCURC.WAERS
  • P_STOITEMANLYTS_2.MANDT == TCURC.MANDT
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • P_STOITEMANLYTS_2.MANDT == LFA1.MANDT
  • P_STOITEMANLYTS_2.FORWARDINGAGENT == LFA1.LIFNR
Material Group
  • Client
  • Material Group
  • P_STOITEMANLYTS_2.MANDT == T023.MANDT
  • P_STOITEMANLYTS_2.MATERIALGROUP == T023.MATKL
Material Number
  • Material Number
  • Client
  • P_STOITEMANLYTS_2.MATERIALNUMBER == MARA.MATNR
  • P_STOITEMANLYTS_2.MANDT == MARA.MANDT
MRP controller
  • MRP Controller
  • Plant
  • Client
  • P_STOITEMANLYTS_2.MRPCONTROLLER == T024D.DISPO
  • P_STOITEMANLYTS_2.RECEIVINGPLANT == T024D.WERKS
  • P_STOITEMANLYTS_2.MANDT == T024D.MANDT
Purchase Order Type
  • Purchase Order Type
  • Purchasing Document Category
  • Client
  • P_STOITEMANLYTS_2.ORDERTYPE == T161.BSART
  • P_STOITEMANLYTS_2.PURCHASEORDERCATEGORY == T161.BSTYP
  • P_STOITEMANLYTS_2.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_STOITEMANLYTS_2.PURCHASINGGROUP == T024.EKGRP
  • P_STOITEMANLYTS_2.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_STOITEMANLYTS_2.PURCHASINGORG == T024E.EKORG
  • P_STOITEMANLYTS_2.MANDT == T024E.MANDT
Plant
  • Plant
  • Client
  • P_STOITEMANLYTS_2.RECEIVINGPLANT == T001W.WERKS
  • P_STOITEMANLYTS_2.MANDT == T001W.MANDT
Customer Number
  • Client
  • Customer Number
  • P_STOITEMANLYTS_2.MANDT == KNA1.MANDT
  • P_STOITEMANLYTS_2.SHIPTOPARTY == KNA1.KUNNR
Sold-to Party
  • Sold-to Party
  • Client
  • P_STOITEMANLYTS_2.SOLDTOPARTY == KNA1.KUNNR
  • P_STOITEMANLYTS_2.MANDT == KNA1.MANDT
Supplying (issuing) plant in case of stock transport order
  • Supplying (issuing) plant in case of stock transport order
  • Client
  • P_STOITEMANLYTS_2.SUPPLPLANT == T001W.WERKS
  • P_STOITEMANLYTS_2.MANDT == T001W.MANDT
Transportation Group
  • Transportation Group
  • Client
  • P_STOITEMANLYTS_2.TRANSPORTATIONGROUP == TTGR.TRAGR
  • P_STOITEMANLYTS_2.MANDT == TTGR.MANDT
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • P_STOITEMANLYTS_2.WAREHOUSENUMBER == T300.LGNUM
  • P_STOITEMANLYTS_2.MANDT == T300.MANDT