R_HierRuntimeRepresentation

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 R_HierRuntimeRepresentation.
-- 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: RHRRPDIR

CREATE VIEW R_HierRuntimeRepresentation AS
SELECT
  hryid_42 AS HierarchyID,
  cast( '000000000000001' as hryversn preserving type ) AS HierarchyVersion,
  cast(hryvalto as fis_datbi preserving type ) AS ValidityEndDate,
  hrytyp AS HierarchyType,
  cast(hryvalfrom as fis_datab preserving type ) AS ValidityStartDate,
  upduser AS LastChangedByUser,
  updtime AS LastChangeDateTime,
  hrycls AS HierarchyClass,
  hrysid AS HierarchyShortID,
  cretime AS FromCreationDateTime,
  creuser AS CreatedByUser,
  kokrs AS ControllingArea,
  ktopl AS ChartOfAccounts,
  itclg AS ConsolidationChartOfAccounts,
  sityp AS SubItemCategory,
  scen_id AS ValidationScenarioID,
  fikrs AS FinancialManagementArea,
  fma_fisyear AS FinMgmtAreaFiscalYear,
  SalesOrganization,
  DistributionChannel,
  Division,
  dspra AS Language,
  xergs AS GroupChartOfAccountIsUsed,
  aktva AS FinancialStatementAssetsItem,
  pssva AS FinStatementLiabilitiesItem,
  ergak AS FinancialStatementNetLossItem,
  ergpa AS FinStatementNetProfitItem,
  erggv AS FinStatementProfitAndLossItem,
  zuord AS FinancialStatementOrphansItem,
  anhng AS FinancialStatementNotesItem,
  aging AS GeneralLedgerAgingScope,
  funareaassigned AS FunctionalAreaIsUsed,
  semtagassigned AS SemanticTagIsUsed
FROM hrrp_dir_n
LEFT OUTER JOIN R_HierRuntimeRprstnText AS _Text ON HierarchyID = _Text.HierarchyID AND ValidityEndDate = _Text.ValidityEndDate  -- association [0..*]
;