P_SlsOrdFlfmtProcHierNode1

Sales Order Fulfillment Process Hierarchy Node 1 | view: PSDSOFPROCHRCND1 | Extraction: Not supported | Component: Sales Analytics
Tables used: VBRPVBRKLIKPLIPSAFKOAFPOEKKOEKPOEKKNEKETEKESVBAKFPLTVBAPVBEPVBFAEKKOEKPOTKA01AUFKTVAKT000PRPS
Column Name Description
SalesDocument Sales Document
HierarchyNode Node Identification
HierarchyNodeLevel 2 Byte Signed Integer
ParentNode Hierarchy parent node
NodeType Node Type Show values
DocumentCategory SD Document Category Show values
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
Column Name Description
NodeType Node Type Show values
DocumentCategory SD Document Category Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
SalesOrdOvrlDelivFlfmtSts Sales Order Overall Delivery Fulfillment Status Show values
SalesOrdOvrlInvcgFlfmtSts Sales Order Overall Invoicing Fulfillment Status Show values
SalesDocFulfillmentStatus Sales Document Fulfillment Status Show values
OutbDelivFulfillmentStatus Outbound Delivery Fulfillment Status Show values
AccountingTransferStatus Status for Transfer to Accounting Show values
PurchasingDocumentStatus Purchasing Document Status Show values
SlsOrdReltdPurProcFlfmtSts Sales-Order-Related Purchase Process Fulfillment Status Show values
SlsOrdReltdMfgProcFlfmtSts Sales-Order-Related Manufacturing Process Fulfillment Status Show values
Issue Issue Show values
DueDateStatus Due Date Status Show values
Column Name Description Domain name
DeliveryDocumentType Delivery Type LFART
BillingDocumentType Billing Type FKART
PurchaseOrderType Purchasing Document Type BSART
ManufacturingOrderType Manufacturing Order Type AUFART
NumberOfItemsWithIssue 2 Byte Signed Integer INT2
DueDays Next Action in Days DUE_DAYS
Master Data Relations Join Conditions
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • P_SLSORDFLFMTPROCHIERNODE1.SALESORGANIZATION == TVKOV.VKORG
  • P_SLSORDFLFMTPROCHIERNODE1.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_SLSORDFLFMTPROCHIERNODE1.MANDT == TVKOV.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • Division
  • P_SLSORDFLFMTPROCHIERNODE1.SALESORGANIZATION == TVTA.VKORG
  • P_SLSORDFLFMTPROCHIERNODE1.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_SLSORDFLFMTPROCHIERNODE1.MANDT == TVTA.MANDT
  • P_SLSORDFLFMTPROCHIERNODE1.ORGANIZATIONDIVISION == TVTA.SPART
Order type in order header
  • Client
  • Sales Document Type
  • Sales Document Type
  • P_SLSORDFLFMTPROCHIERNODE1.MANDT == TVAK.MANDT
  • P_SLSORDFLFMTPROCHIERNODE1.ROOTNODEDOCUMENTSALESDOCTYPE == TVAK.AUART
  • P_SLSORDFLFMTPROCHIERNODE1.SALESDOCUMENTTYPE == TVAK.AUART
Order type in order header
  • Client
  • Sales Document Type
  • Sales Document Type
  • P_SLSORDFLFMTPROCHIERNODE1.MANDT == TVAK.MANDT
  • P_SLSORDFLFMTPROCHIERNODE1.ROOTNODEDOCUMENTSALESDOCTYPE == TVAK.AUART
  • P_SLSORDFLFMTPROCHIERNODE1.SALESDOCUMENTTYPE == TVAK.AUART
Sales organization in order header
  • Sales Organization
  • Client
  • P_SLSORDFLFMTPROCHIERNODE1.SALESORGANIZATION == TVKO.VKORG
  • P_SLSORDFLFMTPROCHIERNODE1.MANDT == TVKO.MANDT
Currency in order header
  • Client
  • SD Document Currency
  • P_SLSORDFLFMTPROCHIERNODE1.MANDT == TCURC.MANDT
  • P_SLSORDFLFMTPROCHIERNODE1.TRANSACTIONCURRENCY == TCURC.WAERS