C_ElectronicDocByMetaStatus

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_ElectronicDocByMetaStatus.
-- 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_ElectronicDocByMetaStatus AS
SELECT
  I_ElectronicDoc.ElectronicDocUUID AS ElectronicDocUUID,
  I_ElectronicDoc.ElectronicDocCompanyCode AS ElectronicDocCompanyCode,
  I_ElectronicDoc.ElectronicDocCreationDate AS ElectronicDocCreationDate,
  I_ElectronicDoc.ElectronicDocProcess AS ElectronicDocProcess,
  I_ElectronicDoc.ElectronicDocCountry AS Country,
  I_ElectronicDoc.ElectronicDocMetaStatus AS ElectronicDocMetaStatus,
  _ElectronicDocMetaStatusText.ElectronicDocMetaStatusText AS ElectronicDocMetaStatusText,
  _ElectronicDocMetaStatusText.ElectronicDocMetaStatusIntgr AS ElectronicDocMetaStatusIntgr,
  cast(1 as abap.int4) AS NumberOfElectronicDocs,
  cast( case I_ElectronicDoc.ElectronicDocMetaStatus when '0002' then 1 when '' then 1 when '0003' then 1 else 0 end as abap.int4) as NumberOfIncmpltElectronicDocs AS int4asNumberOfIncmpltElectronicDocs,
  cast(1 as abap.int4) AS ElectronicDocNegativeCritlty,
  _ElectronicDocCockpitActvProc.ElectronicDocIsActive AS ElectronicDocIsActive
FROM I_ElectronicDoc
LEFT OUTER JOIN I_ElectronicDocCockpitActvProc AS _ElectronicDocCockpitActvProc ON ElectronicDocProcess = _ElectronicDocCockpitActvProc.ElectronicDocProcess  -- association [0..1]
LEFT OUTER JOIN I_ElectronicDocProcess AS _ElectronicDocProcess ON ElectronicDocProcess = _ElectronicDocProcess.ElectronicDocProcess  -- association [0..1]
LEFT OUTER JOIN I_ElectronicDocProcessText AS _ElectronicDocProcessText ON ElectronicDocProcess = _ElectronicDocProcessText.ElectronicDocProcess  -- association [0..*]
LEFT OUTER JOIN I_ElectronicDocMetaStatusText AS _ElectronicDocMetaStatusText ON ElectronicDocMetaStatus = _ElectronicDocMetaStatusText.ElectronicDocMetaStatus AND _ElectronicDocMetaStatusText.Language = $session.system_language  -- association [0..1]
;