C_APProcFlwNodeClearingDoc

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 C_APProcFlwNodeClearingDoc.
-- 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: CAPPRCFLWCLRGDOC

CREATE VIEW C_APProcFlwNodeClearingDoc AS
SELECT
  bseg.CompanyCode AS ParentProcFlowNodeCompanyCode,
  bseg.AccountingDocument AS ParentProcessFlowNodeDocument,
  bseg.FiscalYear AS ParentProcFlowNodeFiscalYear,
  bseg.AccountingDocumentItem AS ParentProcessFlowNodeDocItem,
  concat(concat(bseg.AccountingDocument,concat('000',bseg.AccountingDocumentItem)),concat(bseg.CompanyCode,concat(bseg.FiscalYear,'3'))) AS ParentProcessFlowNode,
  cast( '3' as char1 ) AS ParentProcFlwNodeDocCategory,
  concat(concat(clrg.AccountingDocument,'000000'),concat(bseg.CompanyCode,concat(clrg.FiscalYear,'4'))) AS ProcessFlowNode,
  clrg.AccountingDocument AS ProcessFlowNodeDocument,
  cast( '4' as char1 ) AS ProcessFlowNodeDocCategory,
  clrg.FiscalYear AS FiscalYear,
  clrg.CompanyCode AS CompanyCode,
  clrg._CompanyCode.CompanyCodeName AS CompanyCodeName,
  bseg._CompanyCode.CompanyCodeName AS ParProcFlwNodeCompanyCodeName,
  clrg.PostingDate AS PostingDate,
  clrg.AccountingDocumentType AS AccountingDocumentType,
  clrg._AccountingDocumentType._Text[1:Language = $session.system_language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  clrg._JournalEntry.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _journalEntry.FullName AS FullName,
  clrg.TransactionCurrency AS TransactionCurrency,
  clrg.FinancialAccountType AS FinancialAccountType,
  clrg.BusinessArea AS BusinessArea,
  clrg.FunctionalArea AS FunctionalArea,
  clrg.Segment AS Segment,
  clrg.ProfitCenter AS ProfitCenter,
  clrg.ControllingArea AS ControllingArea,
  clrg.CostCenter AS CostCenter,
  clrg.Plant AS Plant,
  clrg.ValuationArea AS ValuationArea,
  clrg.GLAccount AS GLAccount,
  clrg._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  clrg.Supplier AS Supplier,
  clrg._Supplier AS _Supplier,
  clrg.Customer AS Customer,
  clrg._Customer AS _Customer,
  clrg._AccountingDocumentType AS _AccountingDocumentType,
  clrg.SalesDocument AS SalesDocument,
  clrg._SalesDocument AS _SalesDocument,
  clrg.OrderID AS OrderID,
  clrg.FixedAsset AS FixedAsset,
  clrg.MasterFixedAsset AS MasterFixedAsset,
  clrg._FixedAsset AS _FixedAsset,
  bseg._Supplier.AuthorizationGroup AS AuthorizationGroup,
  clrg._ProfitCenter.ProfitCtrResponsibleUser AS ProfitCtrResponsibleUser
INNER JOIN I_OperationalAcctgDocItem AS clrg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_APProcFlowJournalEntry AS _journalEntry ON clrg.CompanyCode = _journalEntry.CompanyCode AND clrg.AccountingDocument = _journalEntry.AccountingDocument AND clrg.FiscalYear = _journalEntry.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON OrderID = _InternalOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
;