P_SlsDocFlfmtProcHierarchyD31

SOF Hierarchy: Purchase Order | view: PSOFTREED31 | Extraction: Not supported | Component: Sales Analytics
Tables used: EKKOEKPOEKKNVBFATKA01T000PRPS
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem FK Item Number of Purchasing Document
SalesOrder Sales and Distribution Document Number
Column Name Description
💲 Currency Key (DocumentCurrency):
NetAmount Net Order Value in PO Currency
Column Name Description
Column Name Description
Column Name Description
GoodsReceiptIsExpected Goods Receipt Indicator Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
InvoiceIsExpected Invoice receipt indicator Show values
IsFinallyInvoiced Final Invoice Indicator Show values
Column Name Description Domain name
SalesOrderItem Sales Document Item POSNR
NbrOfPOLinesDlvOpen 2 Byte Signed Integer INT2
NbrOfPOLinesDlvCompleted 2 Byte Signed Integer INT2
NbrOfPOLinesInvOpen 2 Byte Signed Integer INT2
NbrOfPOLinesInvCompleted 2 Byte Signed Integer INT2
Master Data Relations Join Conditions
Currency Key
  • Currency Key
  • Client
  • P_SLSDOCFLFMTPROCHIERARCHYD31.DOCUMENTCURRENCY == TCURC.WAERS
  • P_SLSDOCFLFMTPROCHIERARCHYD31.MANDT == TCURC.MANDT
Purchase Order Type
  • Purchase Order Type
  • ?
  • Client
  • P_SLSDOCFLFMTPROCHIERARCHYD31.PURCHASEORDERTYPE == T161.BSART
  • P_SLSDOCFLFMTPROCHIERARCHYD31.[column in domain "BSTYP"] == T161.BSTYP
  • P_SLSDOCFLFMTPROCHIERARCHYD31.MANDT == T161.MANDT