C_SetlMgmtDocumentProcessFlow

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_SetlMgmtDocumentProcessFlow.
-- 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.

CREATE VIEW C_SetlMgmtDocumentProcessFlow AS
SELECT
  cast( '' as val_text ) AS SettlmtPrecdgDocCatName,
  cast( lpad( '', 4, '') as wcb_contract_type preserving type ) AS SettlmtPrecdgCndnContrType,
  cast( '' as abap.char(10) ) AS SettlmtPrecdgBscCndnContr,
  cast( '' as val_text ) AS SettlmtSubsqntDocCatName,
  cast( lpad( '', 4, '') as wcb_contract_type preserving type ) AS SettlmtSubsqntCndnContrType,
  cast( 'WBRF' as abap.char(6) ) AS SettlmtDocFlowDataSource,
  '' AS SettlmtSubsqntProcessCat,
  '' AS SettlmtSubsqntBusProcCat,
  '' AS SettlmtSubsqntDocPartnerCat,
  '' AS SettlmtSubsqntActlSettlmtDate,
  '' AS SettlmtSubsqntSettlmtDteCat,
  '' AS SettlmtSubsqntSalesOrg,
  '' AS SettlmtSubsqntDistrChannel,
  '' AS SettlmtSubsqntDivision,
  '' AS SettlmtSubsqntPurgOrganization,
  '' AS SettlmtSubsqntPurgGroup,
  '' AS SettlmtSubsqntCompanyCode,
  '' AS SettlmtSubsqntSetlMgmtDocCat,
  '' AS SettlmtSubsqntSettlmtDocType,
  '' AS SettlmtSubsqntPersCostCenter,
  '' AS SettlmtPrecdgProcessCat,
  '' AS SettlmtPrecdgBusProcCat,
  '' AS SettlmtPrecdgDocPartnerCat,
  '' AS SettlmtPrecdgActlSettlmtDate,
  '' AS SettlmtPrecdgSettlmtDteCat,
  '' AS SettlmtPrecdgSetlMgmtDocCat,
  '' AS SettlmtPrecdgSettlmtDocType,
  '000000' AS SettlmtPrecdgDocFlowItem,
  '70' AS SettlmtPrecdgDocCat,
  '000000' AS SettlmtSubsqntDocFlowItem,
  '70' AS SettlmtSubsqntDocCat,
  '' AS SettlmtMgmtUIDocBehvrCat,
  '' AS SettlmtPrecdgSalesOrg,
  '' AS SettlmtPrecdgDistrChannel,
  '' AS SettlmtPrecdgDivision,
  '' AS SettlmtPrecdgPersCostCenter,
  R_ConditionContract.ConditionContract AS SettlmtSubsqntDocFlowNumber,
  R_SettlmtMgmtDocProcessFlow.SettlmtMgmtDocRelshpUUID AS SettlmtMgmtDocRelshpUUID,
  R_SettlmtMgmtDocProcessFlow.SettlmtPrecdgDoc AS SettlmtPrecdgDocFlowNumber,
  _PrecdgConditionContract.PurchasingOrganization AS SettlmtPrecdgPurgOrganization,
  _PrecdgConditionContract.PurchasingGroup AS SettlmtPrecdgPurgGroup,
  _PrecdgConditionContract.CompanyCode AS SettlmtPrecdgCompanyCode
FROM R_SettlmtMgmtDocProcessFlow
LEFT OUTER JOIN R_SettlmtMgmtDoc AS _PrecdgSettlmtDocument ON R_SettlmtMgmtDocProcessFlow.SettlmtPrecdgDoc = _PrecdgSettlmtDocument.SettlmtMgmtDoc  -- association [0..1]
LEFT OUTER JOIN R_SettlmtMgmtDoc AS _SubsqntSettlmtDocument ON R_SettlmtMgmtDocProcessFlow.SettlmtSubsqntDoc = _SubsqntSettlmtDocument.SettlmtMgmtDoc  -- association [0..1]
LEFT OUTER JOIN C_SetlMgmtDocumentProcessFlow AS _PrecdgDocFlow ON SettlmtPrecdgDocFlowNumber = _PrecdgDocFlow.SettlmtSubsqntDocFlowNumber AND SettlmtPrecdgDocCat = _PrecdgDocFlow.SettlmtSubsqntDocCat  -- association [0..*]
LEFT OUTER JOIN C_SetlMgmtDocumentProcessFlow AS _SubsqntDocFlow ON SettlmtSubsqntDocFlowNumber = _SubsqntDocFlow.SettlmtPrecdgDocFlowNumber AND SettlmtSubsqntDocCat = _SubsqntDocFlow.SettlmtPrecdgDocCat  -- association [0..*]
LEFT OUTER JOIN R_ConditionContract AS _PrecdgConditionContract ON R_SettlmtMgmtDocProcessFlow.SettlmtPrecdgDoc = _PrecdgConditionContract.ConditionContract  -- association [0..1]
LEFT OUTER JOIN R_PurchasingDocument AS _PrecdgPurchasingDocument ON R_SettlmtMgmtDocProcessFlow.SettlmtPrecdgDoc = _PrecdgPurchasingDocument.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN R_TrdgContr AS _PrecdgTradingContract ON R_SettlmtMgmtDocProcessFlow.SettlmtPrecdgDoc = _PrecdgTradingContract.TradingContract  -- association [0..1]
-- UNION with additional select branch(es): R_SettlmtMgmtDocProcessFlow, R_ConditionContract, R_BscCndnContrRefcdCndnContr
;