I_REDocumentHeader

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 I_REDocumentHeader.
-- 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: IREDOCHEAD

CREATE VIEW I_REDocumentHeader AS
SELECT
  docguid AS RealEstateDocumentUUID,
  processguid AS REProcessUUID,
  cast(processid as recavdmprocessid preserving type ) AS RealEstateProcess,
  fisc_year AS FiscalYear,
  pstngdate AS PostingDate,
  docdate AS DocumentDate,
  refdocid AS OriginalReferenceDocument,
  logsystem AS LogicalSystem,
  revid AS REDocumentReversalStatus,
  revdocguid AS REReversalDocumentUUID,
  rerf AS CreatedByUser,
  derf AS CreationDate,
  terf AS CreationTime,
  reher AS RESourceOfCreation,
  rbear AS LastChangedByUser,
  dbear AS LastChangeDate,
  tbear AS LastChangeTime,
  rbher AS RESourceOfChange,
  ctrule AS RECurrencyTranslationRule,
  postcdcurr AS REIsPostInConditionCurrency,
  ctdatereq AS REPlndTranslationDate,
  ctdateact AS REActlTranslationDate,
  ctfccurrkey AS ForeignCurrency,
  cerule AS REValuationRule,
  accprinciple AS AccountingPrinciple
FROM viradoc
LEFT OUTER JOIN I_REProcess AS _REProcess ON REProcessUUID = _REProcess.REProcessUUID  -- association [1..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedByUser ON LastChangedByUser = _ChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocument AS _AccountingDocument ON OriginalReferenceDocument = _AccountingDocument.OriginalReferenceDocument AND FiscalYear = _AccountingDocument.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_AccountingPrinciple AS _AccountingPrinciple ON AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple  -- association [0..1]
LEFT OUTER JOIN I_RECurrencyTranslationRule AS _RECurrencyTranslationRule ON RECurrencyTranslationRule = _RECurrencyTranslationRule.RECurrencyTranslationRule  -- association [0..1]
LEFT OUTER JOIN I_REValuationRule AS _REValuationRule ON REValuationRule = _REValuationRule.REValuationRule  -- association [0..1]
;