C_SlsOrdFlfmtPurOrdSchedLineQ

SOFM Purchase Order Scheduleline Query | view: CSOFPURORDSCHDLQ | Extraction: Not supported | Component: Sales Analytics
Tables used: EKKOEKPOEKETT024E
Column Name Description
PurchasingDocument FK Purchasing Document Number
PurchasingDocumentItem FK Item Number of Purchasing Document
ScheduleLine Delivery Schedule Line Counter
Column Name Description
Column Name Description
📏 Purchase Order Unit of Measure (PurgDocOrderQuantityUnit):
RoughGoodsReceiptQty Quantity of goods received
ScheduleLineOrderQuantity Scheduled Quantity
Column Name Description
ScheduleLineDeliveryDate Item delivery date
Column Name Description
GoodsReceiptIsExpected Goods Receipt Indicator Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
IsFinallyInvoiced Final Invoice Indicator Show values
Column Name Description Domain name
PurchasingOrganization Purchasing Organization EKORG
Master Data Relations Join Conditions
Plant
  • Client
  • Plant
  • C_SLSORDFLFMTPURORDSCHEDLINEQ.MANDT == T001W.MANDT
  • C_SLSORDFLFMTPURORDSCHEDLINEQ.PLANT == T001W.WERKS
Purchase Order Type
  • Client
  • Purchase Order Type
  • ?
  • C_SLSORDFLFMTPURORDSCHEDLINEQ.MANDT == T161.MANDT
  • C_SLSORDFLFMTPURORDSCHEDLINEQ.PURCHASEORDERTYPE == T161.BSART
  • C_SLSORDFLFMTPURORDSCHEDLINEQ.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • C_SLSORDFLFMTPURORDSCHEDLINEQ.MANDT == T024.MANDT
  • C_SLSORDFLFMTPURORDSCHEDLINEQ.PURCHASINGGROUP == T024.EKGRP
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_SLSORDFLFMTPURORDSCHEDLINEQ.MANDT == T006.MANDT
  • C_SLSORDFLFMTPURORDSCHEDLINEQ.PURGDOCORDERQUANTITYUNIT == T006.MSEHI