P_SalesDocumentItemFulfillmnt0

Sales Document Item Fulfillment 0 | view: PSDSLSDOCITMFLF0 | TRAN | Extraction: Not supported | Component: Sales
Tables used: VBAPVBRKVBRPLIKPLIPSVBKDVEDAVBAKVBAKVBAPVBKDVEDAVBAPVBEP
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
Column Name Description
📏 Sales unit (OrderQuantityUnit):
OrderQuantity Cumulative order quantity in sales units
ShippedQuantityInOrderQtyUnit Shipped Quantity in Sales Unit
InvoicedQuantityInOrderQtyUnit Invoiced Quantity in Sales Unit
📏 Target Quantity UoM (TargetQuantityUnit):
TargetQuantity Target Quantity in Sales Units
Column Name Description
RequestedDeliveryDate Requested Delivery Date
NextPlannedProdAvailDate null
BillingDocumentDate Billing Date
Column Name Description
SDDocumentRejectionStatus Rejection Status (Item) Show values
SDProcessStatus Overall Processing Status (Item) Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
DeliveryStatus Delivery Status (Item) Show values
Column Name Description Domain name
SalesDocumentItemText Short text for sales order item TEXT40
ShippingStatus Sales order status of shipping fulfillment SHIPPING_STS
InvoicingStatus Sales order status of invoicing process INVOIC_STS
Master Data Relations Join Conditions
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • P_SALESDOCUMENTITEMFULFILLMNT0.SALESORGANIZATION == TVKOV.VKORG
  • P_SALESDOCUMENTITEMFULFILLMNT0.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_SALESDOCUMENTITEMFULFILLMNT0.MANDT == TVKOV.MANDT
Material: order item
  • Material Number
  • Product Number
  • Client
  • P_SALESDOCUMENTITEMFULFILLMNT0.MATERIAL == MARA.MATNR
  • P_SALESDOCUMENTITEMFULFILLMNT0.PRODUCT == MARA.MATNR
  • P_SALESDOCUMENTITEMFULFILLMNT0.MANDT == MARA.MANDT
Sales unit
  • Sales unit
  • Client
  • P_SALESDOCUMENTITEMFULFILLMNT0.ORDERQUANTITYUNIT == T006.MSEHI
  • P_SALESDOCUMENTITEMFULFILLMNT0.MANDT == T006.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • Division
  • P_SALESDOCUMENTITEMFULFILLMNT0.SALESORGANIZATION == TVTA.VKORG
  • P_SALESDOCUMENTITEMFULFILLMNT0.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_SALESDOCUMENTITEMFULFILLMNT0.MANDT == TVTA.MANDT
  • P_SALESDOCUMENTITEMFULFILLMNT0.ORGANIZATIONDIVISION == TVTA.SPART
Material: order item
  • Material Number
  • Product Number
  • Client
  • P_SALESDOCUMENTITEMFULFILLMNT0.MATERIAL == MARA.MATNR
  • P_SALESDOCUMENTITEMFULFILLMNT0.PRODUCT == MARA.MATNR
  • P_SALESDOCUMENTITEMFULFILLMNT0.MANDT == MARA.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • P_SALESDOCUMENTITEMFULFILLMNT0.SALESDOCUMENTTYPE == TVAK.AUART
  • P_SALESDOCUMENTITEMFULFILLMNT0.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • P_SALESDOCUMENTITEMFULFILLMNT0.SALESORGANIZATION == TVKO.VKORG
  • P_SALESDOCUMENTITEMFULFILLMNT0.MANDT == TVKO.MANDT
Target Quantity UoM
  • Target Quantity UoM
  • Client
  • P_SALESDOCUMENTITEMFULFILLMNT0.TARGETQUANTITYUNIT == T006.MSEHI
  • P_SALESDOCUMENTITEMFULFILLMNT0.MANDT == T006.MANDT