C_SlsDocFlfmtPurgDocItem

Sales Doc Fulfillment: Purg Doc Item | view: CSOFPURGDOCITM | Extraction: Not supported | Component: Sales Analytics
Tables used: EKKOEKPOEKETMARAMAKT
Column Name Description
PurchasingDocument FK Purchasing Document Number
PurchasingDocumentItem Item Number of Purchasing Document
Column Name Description
💲 Currency Key (DocumentCurrency):
NetAmount Net Order Value in PO Currency
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
OrderQuantity Purchase Order Quantity
Column Name Description
DeliveryDate Item delivery date
Column Name Description
IsCompletelyDelivered "Delivery Completed" Indicator Show values
IsFinallyInvoiced Final Invoice Indicator Show values
Column Name Description Domain name
MaterialName Material Description TEXT40
PurchasingDocumentItemText Short Text TEXT40
Master Data Relations Join Conditions
Currency Key
  • Currency Key
  • Client
  • C_SLSDOCFLFMTPURGDOCITEM.DOCUMENTCURRENCY == TCURC.WAERS
  • C_SLSDOCFLFMTPURGDOCITEM.MANDT == TCURC.MANDT
Product Number
  • Product Number
  • Client
  • C_SLSDOCFLFMTPURGDOCITEM.MATERIAL == MARA.MATNR
  • C_SLSDOCFLFMTPURGDOCITEM.MANDT == MARA.MANDT
Product Group
  • Product Group
  • Client
  • C_SLSDOCFLFMTPURGDOCITEM.MATERIALGROUP == T023.MATKL
  • C_SLSDOCFLFMTPURGDOCITEM.MANDT == T023.MANDT
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_SLSDOCFLFMTPURGDOCITEM.MANDT == T006.MANDT
  • C_SLSDOCFLFMTPURGDOCITEM.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • C_SLSDOCFLFMTPURGDOCITEM.MANDT == T001W.MANDT
  • C_SLSDOCFLFMTPURGDOCITEM.PLANT == T001W.WERKS
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • C_SLSDOCFLFMTPURGDOCITEM.MANDT == T163.MANDT
  • C_SLSDOCFLFMTPURGDOCITEM.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP