P_SlsDocItmFlfmtAnlyts

Sales Document Item Fulfillment Analytics | view: PLESOIFLFMTANLY | Extraction: Not supported | Component: Delivery Document Analytical Apps
Tables used: VBAP, LIKP, LIPS, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBAK, VBAP, VBKD, VEDA, VBEP, TVKO
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of Sales Order in Transaction Currency
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
OrderQuantity Cumulative order quantity in sales units
Column Name Description
SalesDocumentDate 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
CompleteDeliveryIsDefined Complete Delivery Defined for Each Sales Order? Show values
TotalDeliveryStatus Overall Delivery Status (Item) Show values
DeliveryStatus Delivery Status (Item) Show values
SlsDocItmDelivFlfmtSts Processing Status of Sales Order Item Delivery Fulfillment Show values
Column Name Description Domain name
SalesDocumentItemUUID GUID in 'CHAR' Format in Uppercase SYSUUID_C
SoldToParty Sold-to Party KUNNR
SalesDocumentType Sales Document Type AUART
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Division SPART
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
Plant Plant (Own or External) WERKS
ShippingCondition Shipping Conditions VSBED
NumberOfIncomingSlsOrderItems 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)
NmbrOfCmpltlyShpdSlsDocItems Number of Completely Shipped Sales Order Items
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
Delivery Type
  • Delivery Type
  • Client
  • P_SLSDOCITMFLFMTANLYTS.DELIVDOCTYPE == TVLK.LFART
  • P_SLSDOCITMFLFMTANLYTS.MANDT == TVLK.MANDT
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • P_SLSDOCITMFLFMTANLYTS.DELIVERYBLOCKREASON == TVLS.LIFSP
  • P_SLSDOCITMFLFMTANLYTS.MANDT == TVLS.MANDT
Delivery Priority
  • Delivery Priority
  • Delivery Priority
  • Client
  • P_SLSDOCITMFLFMTANLYTS.DELIVERYPRIORITY == TPRIO.LPRIO
  • P_SLSDOCITMFLFMTANLYTS.DELIVPRIO == TPRIO.LPRIO
  • P_SLSDOCITMFLFMTANLYTS.MANDT == TPRIO.MANDT
Route
  • Client
  • Route
  • Route
  • P_SLSDOCITMFLFMTANLYTS.MANDT == TVRO.MANDT
  • P_SLSDOCITMFLFMTANLYTS.DELIVERYROUTE == TVRO.ROUTE
  • P_SLSDOCITMFLFMTANLYTS.ROUTE == TVRO.ROUTE
Delivery Priority
  • Delivery Priority
  • Delivery Priority
  • Client
  • P_SLSDOCITMFLFMTANLYTS.DELIVERYPRIORITY == TPRIO.LPRIO
  • P_SLSDOCITMFLFMTANLYTS.DELIVPRIO == TPRIO.LPRIO
  • P_SLSDOCITMFLFMTANLYTS.MANDT == TPRIO.MANDT
Shipping Conditions
  • Shipping Conditions
  • Client
  • P_SLSDOCITMFLFMTANLYTS.DELIVSHPCONDT == TVSB.VSBED
  • P_SLSDOCITMFLFMTANLYTS.MANDT == TVSB.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • P_SLSDOCITMFLFMTANLYTS.DELIVSHPPOINT == TVST.VSTEL
  • P_SLSDOCITMFLFMTANLYTS.SHIPPINGPOINT == TVST.VSTEL
  • P_SLSDOCITMFLFMTANLYTS.MANDT == TVST.MANDT
Transportation Group
  • Client
  • Transportation Group
  • P_SLSDOCITMFLFMTANLYTS.MANDT == TTGR.MANDT
  • P_SLSDOCITMFLFMTANLYTS.DELIVTRANSGROUP == TTGR.TRAGR
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • P_SLSDOCITMFLFMTANLYTS.DELIVWAREHOUSE == T300.LGNUM
  • P_SLSDOCITMFLFMTANLYTS.MANDT == T300.MANDT
Division
  • Client
  • Division
  • P_SLSDOCITMFLFMTANLYTS.MANDT == TSPA.MANDT
  • P_SLSDOCITMFLFMTANLYTS.DIVISION == TSPA.SPART
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • P_SLSDOCITMFLFMTANLYTS.INCOTERMSCLASSIFICATION == TINC.INCO1
  • P_SLSDOCITMFLFMTANLYTS.MANDT == TINC.MANDT
Material: order item
  • Material Number
  • Client
  • P_SLSDOCITMFLFMTANLYTS.MATERIAL == MARA.MATNR
  • P_SLSDOCITMFLFMTANLYTS.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_SLSDOCITMFLFMTANLYTS.MATERIALGROUP == T023.MATKL
  • P_SLSDOCITMFLFMTANLYTS.MANDT == T023.MANDT
Route
  • Client
  • Route
  • Route
  • P_SLSDOCITMFLFMTANLYTS.MANDT == TVRO.MANDT
  • P_SLSDOCITMFLFMTANLYTS.DELIVERYROUTE == TVRO.ROUTE
  • P_SLSDOCITMFLFMTANLYTS.ROUTE == TVRO.ROUTE
Sales District
  • Client
  • Sales District
  • P_SLSDOCITMFLFMTANLYTS.MANDT == T171.MANDT
  • P_SLSDOCITMFLFMTANLYTS.SALESDISTRICT == T171.BZIRK
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • P_SLSDOCITMFLFMTANLYTS.DELIVSHPPOINT == TVST.VSTEL
  • P_SLSDOCITMFLFMTANLYTS.SHIPPINGPOINT == TVST.VSTEL
  • P_SLSDOCITMFLFMTANLYTS.MANDT == TVST.MANDT
Shipping Type
  • Client
  • Shipping Type
  • P_SLSDOCITMFLFMTANLYTS.MANDT == T173.MANDT
  • P_SLSDOCITMFLFMTANLYTS.SHIPPINGTYPE == T173.VSART
SD Document Currency
  • SD Document Currency
  • Client
  • P_SLSDOCITMFLFMTANLYTS.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_SLSDOCITMFLFMTANLYTS.MANDT == TCURC.MANDT