P_SalesDocumentItemFulfillmnt2

Sales Document Item Fulfillment 2 | view: PSDSLSDOCITMFLF2 | TRAN | Extraction: Not supported | Component: Sales
Tables used: VBAPVBRKVBRPLIKPLIPSVBKDVEDAVBAKVBAKVBAPVBKDVEDAVBAP
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
BillingDocumentDate Billing Date
Column Name Description
ItemIsBillingRelevant Relevant for Billing Show values
SDDocumentRejectionStatus Rejection Status (Item) Show values
DeliveryStatus Delivery 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
OrderRelatedBillingStatus Order-Related Billing Status (Item) Show values
Column Name Description Domain name
SalesDocumentItemText Short text for sales order item TEXT40
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
MinimumDeliveryFulfillmntInPct null
UnderdeliveryInPct null
Master Data Relations Join Conditions
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • P_SALESDOCUMENTITEMFULFILLMNT2.MANDT == TVKOV.MANDT
  • P_SALESDOCUMENTITEMFULFILLMNT2.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_SALESDOCUMENTITEMFULFILLMNT2.SALESORGANIZATION == TVKOV.VKORG
Material: order item
  • Client
  • Material Number
  • Product Number
  • P_SALESDOCUMENTITEMFULFILLMNT2.MANDT == MARA.MANDT
  • P_SALESDOCUMENTITEMFULFILLMNT2.MATERIAL == MARA.MATNR
  • P_SALESDOCUMENTITEMFULFILLMNT2.PRODUCT == MARA.MATNR
Sales unit
  • Client
  • Sales unit
  • P_SALESDOCUMENTITEMFULFILLMNT2.MANDT == T006.MANDT
  • P_SALESDOCUMENTITEMFULFILLMNT2.ORDERQUANTITYUNIT == T006.MSEHI
Division in order header
  • Client
  • Distribution Channel
  • Division
  • Sales Organization
  • P_SALESDOCUMENTITEMFULFILLMNT2.MANDT == TVTA.MANDT
  • P_SALESDOCUMENTITEMFULFILLMNT2.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_SALESDOCUMENTITEMFULFILLMNT2.ORGANIZATIONDIVISION == TVTA.SPART
  • P_SALESDOCUMENTITEMFULFILLMNT2.SALESORGANIZATION == TVTA.VKORG
Material: order item
  • Client
  • Material Number
  • Product Number
  • P_SALESDOCUMENTITEMFULFILLMNT2.MANDT == MARA.MANDT
  • P_SALESDOCUMENTITEMFULFILLMNT2.MATERIAL == MARA.MATNR
  • P_SALESDOCUMENTITEMFULFILLMNT2.PRODUCT == MARA.MATNR
Order type in order header
  • Client
  • Sales Document Type
  • P_SALESDOCUMENTITEMFULFILLMNT2.MANDT == TVAK.MANDT
  • P_SALESDOCUMENTITEMFULFILLMNT2.SALESDOCUMENTTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • P_SALESDOCUMENTITEMFULFILLMNT2.MANDT == TVKO.MANDT
  • P_SALESDOCUMENTITEMFULFILLMNT2.SALESORGANIZATION == TVKO.VKORG
Target Quantity UoM
  • Client
  • Target Quantity UoM
  • P_SALESDOCUMENTITEMFULFILLMNT2.MANDT == T006.MANDT
  • P_SALESDOCUMENTITEMFULFILLMNT2.TARGETQUANTITYUNIT == T006.MSEHI