I_REAccountingObject

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_REAccountingObject.
-- 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: IREACCOBJECT

CREATE VIEW I_REAccountingObject AS
SELECT
  _REObjectTypeDetails.REStatusObject AS REAccountingObject,
  _REObjectTypeDetails.RealEstateObjectType AS REAccountingObjectType,
  _REObjectTypeDetails.REIdentification AS REIdentification,
  _REObjectTypeDetails.REIdentificationKey AS REIdentificationKey,
  case _REObjectTypeDetails.RealEstateObjectType when 'IS' then _REObjectTypeDetails._REContract.CompanyCode when 'IW' then _REObjectTypeDetails._REBusinessEntity.CompanyCode when 'IB' then _REObjectTypeDetails._REBuilding.CompanyCode when 'IG' then _REObjectTypeDetails._REProperty.CompanyCode when 'IM' then _REObjectTypeDetails._RERentalObject.CompanyCode else '' end as CompanyCode AS CompanyCodeelseendasCompanyCode,
  cast(_REObjectTypeDetails._REKeyAssgmt.RealEstateContract as recnvdmcnnr preserving type ) AS RealEstateContract,
  _REObjectTypeDetails._REContract.REContractType AS REContractType,
  cast(_REObjectTypeDetails._REKeyAssgmt.REBusinessEntity as rebdvdmbeno preserving type) AS REBusinessEntity,
  cast(_REObjectTypeDetails._REKeyAssgmt.RealEstateBuilding as rebdvdmbuno preserving type) AS RealEstateBuilding,
  cast(_REObjectTypeDetails._REKeyAssgmt.RealEstateProperty as rebdvdmprno preserving type) AS RealEstateProperty,
  cast(_REObjectTypeDetails._REKeyAssgmt.RERentalObject as rebdvdmrono preserving type) AS RERentalObject,
  _REObjectTypeDetails._REContract.REAuthorizationGroup AS REAuthorizationGroup,
  cast(' ' as kostl preserving type) AS CostCenter,
  cast(' ' as fins_int_aufnr preserving type ) AS InternalOrder,
  ' ' AS WBSElement,
  cast(' ' as ps_posid_edit preserving type ) AS WBSElementExternalID,
  case _REObjectTypeDetails.RealEstateObjectType when 'IS' then _REObjectTypeDetails._REContract._CompanyCode.ControllingArea when 'IW' then _REObjectTypeDetails._REBusinessEntity._CompanyCode.ControllingArea when 'IB' then _REObjectTypeDetails._REBuilding._CompanyCode.ControllingArea when 'IG' then _REObjectTypeDetails._REProperty._CompanyCode.ControllingArea when 'IM' then _REObjectTypeDetails._RERentalObject._CompanyCode.ControllingArea else '' end as ControllingArea AS ControllingAreaelseendasControllingArea,
  cast(' ' as aufart preserving type ) AS OrderType,
  _REOrganizationalAssgmtTerm.ProfitCenter as ProfitCenter AS REAccountingObjectasREAccountingObject,
  _REControllingObject.CompanyCode AS CompanyCode,
  _REControllingObject.REObjectText AS REObjectText,
  _REControllingObject.ControllingArea AS ControllingArea,
  _REControllingObject.ProfitCenter AS ProfitCenter
FROM I_REOrganizationalAssgmtTerm AS _REOrganizationalAssgmtTerm
LEFT OUTER JOIN I_REObjectTypeDetails AS _REObjectTypeDetails ON _REOrganizationalAssgmtTerm.InternalRealEstateNumber = _REObjectTypeDetails.InternalRealEstateNumber  -- association [1..1]
-- UNION ALL with additional select branch(es): I_REControllingObject
;