fac_cds_uh_costcenter

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 fac_cds_uh_costcenter.
-- 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: FACV_UH_CCTR

CREATE VIEW fac_cds_uh_costcenter AS
SELECT
  ControllingArea,
  CostCenter,
  ValidityEndDate,
  ValidityStartDate,
  CompanyCode,
  CostCenterCategory,
  _CostCenterText[1:Language = $session.system_language and ValidityEndDate = ValidityEndDate and ValidityStartDate = ValidityStartDate ].CostCenterName AS CostCenter_T,
  cast(upper(_CostCenterText[1:Language = $session.system_language and ValidityEndDate = ValidityEndDate and ValidityStartDate = ValidityStartDate ].CostCenterName)as fis_kostl_name) AS CostCenter_T_Upper
FROM I_CostCenter
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter AND ValidityEndDate = _CostCenterText.ValidityEndDate  -- association [0..*]
;