P_SlsOrdFlfmtProcHierNode2

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_SlsOrdFlfmtProcHierNode2.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PSDSOFPROCHRCND2

CREATE VIEW P_SlsOrdFlfmtProcHierNode2 AS
SELECT
  SalesDocument,
  cast( concat( '_', SalesDocument ) as dme_node ) AS HierarchyNode,
  cast( 0 as int2 ) AS HierarchyNodeLevel,
  cast( 'ROOT' as sls_ord_flfllmnt_node_type ) AS NodeType,
  cast( SOOvrl.SalesDocumentCategory as vbtypl ) AS DocumentCategory,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  cast( SalesDocumentType as auart ) AS RootNodeDocumentSalesDocType,
  SalesDocumentType,
  TotalNetAmount,
  TransactionCurrency,
  cast( '' as lfart ) AS DeliveryDocumentType,
  cast( '' as fkart ) AS BillingDocumentType,
  cast( '' as esart ) AS PurchaseOrderType,
  cast( '' as manufacturingordertype ) AS ManufacturingOrderType,
  SalesOrdOvrlDelivFlfmtSts,
  SalesOrdOvrlInvcgFlfmtSts,
  cast( '' as salesdocfulfillmentstatus ) AS SalesDocFulfillmentStatus,
  cast( '' as outbdelivfulfillmentstatus ) AS OutbDelivFulfillmentStatus,
  cast( '' as rfbsk ) AS AccountingTransferStatus,
  cast( '' as mmpur_doc_status ) AS PurchasingDocumentStatus,
  cast( '' as slsordreltdpurprocflfmtsts ) AS SlsOrdReltdPurProcFlfmtSts,
  cast( '' as slsordreltdmfgprocflfmtsts ) AS SlsOrdReltdMfgProcFlfmtSts,
  Lvl0.OverallSDProcessStatus AS OverallSDProcessStatus
FROM P_SlsOrdWithOvrlFlfmtSts1 AS SOOvrl
LEFT OUTER JOIN I_SalesDocumentType AS _RootNodeDocumentSalesDocType ON RootNodeDocumentSalesDocType = _RootNodeDocumentSalesDocType.SalesDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentType AS _SalesDocumentType ON SalesDocumentType = _SalesDocumentType.SalesDocumentType  -- association [0..1]
LEFT OUTER JOIN I_DeliveryDocumentType AS _DeliveryDocumentType ON DeliveryDocumentType = _DeliveryDocumentType.DeliveryDocumentType  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentType AS _BillingDocumentType ON BillingDocumentType = _BillingDocumentType.BillingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchaseOrderType ON _PurchaseOrderType.PurchasingDocumentCategory = 'F' AND PurchaseOrderType = _PurchaseOrderType.PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderType AS _MfgOrderType ON ManufacturingOrderType = _MfgOrderType.ManufacturingOrderType  -- association [0..1]
LEFT OUTER JOIN I_SalesDocFulfillmentStatus AS _SalesDocFulfillmentStatus ON SalesDocFulfillmentStatus = _SalesDocFulfillmentStatus.SalesDocFulfillmentStatus  -- association [0..1]
LEFT OUTER JOIN I_OutbDelivFulfillmentStatus AS _OutbDelivFulfillmentStatus ON OutbDelivFulfillmentStatus = _OutbDelivFulfillmentStatus.OutbDelivFulfillmentStatus  -- association [0..1]
LEFT OUTER JOIN I_AccountingTransferStatus AS _AccountingTransferStatus ON AccountingTransferStatus = _AccountingTransferStatus.AccountingTransferStatus  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentStatus AS _PurchasingDocumentStatus ON PurchasingDocumentStatus = _PurchasingDocumentStatus.PurchasingDocumentStatus  -- association [0..1]
LEFT OUTER JOIN I_SlsOrdReltdPurProcFlfmtSts AS _SlsOrdReltdPurProcFlfmtSts ON SlsOrdReltdPurProcFlfmtSts = _SlsOrdReltdPurProcFlfmtSts.SlsOrdReltdPurProcFlfmtSts  -- association [0..1]
LEFT OUTER JOIN I_SlsOrdReltdMfgProcFlfmtSts AS _SlsOrdReltdMfgProcFlfmtSts ON SlsOrdReltdMfgProcFlfmtSts = _SlsOrdReltdMfgProcFlfmtSts.SlsOrdReltdMfgProcFlfmtSts  -- association [0..1]
LEFT OUTER JOIN I_SalesOrdOvrlDelivFlfmtSts AS _SalesOrdOvrlDelivFlfmtSts ON SalesOrdOvrlDelivFlfmtSts = _SalesOrdOvrlDelivFlfmtSts.SalesOrdOvrlDelivFlfmtSts  -- association [0..1]
LEFT OUTER JOIN I_SalesOrdOvrlInvcgFlfmtSts AS _SalesOrdOvrlInvcgFlfmtSts ON SalesOrdOvrlInvcgFlfmtSts = _SalesOrdOvrlInvcgFlfmtSts.SalesOrdOvrlInvcgFlfmtSts  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_OverallSDProcessStatus AS _OverallSDProcessStatus ON OverallSDProcessStatus = _OverallSDProcessStatus.OverallSDProcessStatus  -- association [0..1]
-- UNION ALL with additional select branch(es): I_SalesDocumentBasic, P_SlsOrdFlfmt1stLvlSDProcSqnc1, P_SlsOrdFlfmtSupProcSqnc, P_SlsOrdFlfmt2ndLvlSDProcSqnc1
;