I_REControllingObject

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_REControllingObject.
-- 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: IRECTRLGGOBJECT

CREATE VIEW I_REControllingObject AS
SELECT
  _CostCenter.ObjectInternalID AS REAccountingObject,
  cast('KS' as recaobjtype preserving type ) AS REAccountingObjectType,
  cast( concat(concat(concat_with_space(_REObjectTypeText.REObjectTypePrefix, _CostCenter.ControllingArea ,1 ),'/'), _CostCenter.CostCenter ) as recaident ) as REIdentification AS CostCenterasrecaidentasREIdentification,
  _CostCenter.CompanyCode AS CompanyCode,
  cast( _CostCenter._Text[1: Language = $session.system_language ].CostCenterName as recaxdescription ) AS REObjectText,
  _CostCenter.CostCenter AS CostCenter,
  _InternalOrder.InternalOrder AS InternalOrder,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  _CostCenter.ControllingArea AS ControllingArea,
  cast(' ' as aufart preserving type ) AS OrderType,
  _CostCenter.ProfitCenter AS ProfitCenter,
  _REObjectTypeText.RealEstateObjectTypeName AS ControllingObjectasREAccountingObject,
  cast( concat_with_space(_REObjectTypeText.REObjectTypePrefix,_InternalOrder.InternalOrder, 1) as recaident ) AS REIdentification,
  cast(_InternalOrder.InternalOrder as recaidentkey ) AS REIdentificationKey,
  _REObjectTypeText.RealEstateObjectTypeName AS WBSElementObjectasREAccountingObject,
  _REObjectTypeText.RealEstateObjectTypeName AS RealEstateObjectTypeName
FROM I_CostCenter AS _CostCenter
LEFT OUTER JOIN I_REObjectTypeText AS _REObjectTypeText ON _REObjectTypeText.RealEstateObjectType = 'KS' AND _REObjectTypeText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON REAccountingObject = _InternalOrder.ControllingObject  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON REAccountingObject = _WBSElement.WBSElementObject  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON REAccountingObject = _CostCenter.ObjectInternalID  -- association [0..1]
-- UNION ALL with additional select branch(es): I_InternalOrder, I_WBSElementBasicData
;