I_REIntegObjectAcctObjAssgmt

DDL: I_REINTEGOBJECTACCTOBJASSGMT SQL: IREINTOBJACCASS Type: view COMPOSITE
23 Fields 1 Data Sources 4 Associations

Real Estate IO Accounting Object Assgmt

I_REIntegObjectAcctObjAssgmt (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_REIntegObjectAcctObjAssgmt is a Composite CDS View that provides data about "Real Estate IO Accounting Object Assgmt" in SAP S/4HANA. It reads from 1 data source (I_REObjectAssgmt) and exposes 23 fields with key fields InternalRealEstateNumber, REAccountingObject, ValidityStartDate. It has 4 associations to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentRE-FX-IP
CapabilitiesData Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source for Data Extraction
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_REObjectAssgmt _REObjectAssignment from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_REIntegrationObjectBasicData _REIntegrationObject _REObjectAssignment.REStatusObjectSource = _REIntegrationObject.REStatusObject
[1..1] I_REControllingObject _REAccountingObject _REObjectAssignment.REStatusObjectTarget = _REAccountingObject.REAccountingObject
[1..1] I_CompanyCode _CompanyCode _REAccountingObject.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_REObjectTypeDetails _REObjectTypeDetails _REObjectAssignment.REStatusObjectTarget = _REObjectTypeDetails.REStatusObject

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IREINTOBJACCASS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
EndUserText.label Real Estate IO Accounting Object Assgmt view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber _REIntegrationObject InternalRealEstateNumber Internal Key of Real Estate Object
KEY REAccountingObject I_REObjectAssgmt REStatusObjectTarget Object Number
KEY ValidityStartDate I_REObjectAssgmt ValidityStartDate Validity Start Date
ValidityEndDate I_REObjectAssgmt ValidityEndDate Validity End Date
REStatusObjectSource I_REObjectAssgmt REStatusObjectSource Object Number
CompanyCode _REAccountingObject CompanyCode Receiver Company Code
REAccountingObjectType _REAccountingObject REAccountingObjectType Object Type
REOnlyInfoAssgmt I_REObjectAssgmt REOnlyInfoAssgmt Informational Assignment
REIsLeadingObject I_REObjectAssgmt REIsLeadingObject Leading object Indicator
REIntegObjSpaceGroupType _REIntegrationObject REIntegObjSpaceGroupType Group Type
REParentIntegObjectType _REIntegrationObject REParentIntegObjectType Parent Object Type
REParentIntegObjectExternalID _REIntegrationObject REParentIntegObjectExternalID Parent External Identification
CostCenter _REAccountingObject CostCenter Cost Center
InternalOrder _REAccountingObject InternalOrder Internal Order
OrderType _REAccountingObject OrderType Order Type
ControllingArea _REAccountingObject ControllingArea Controlling Area
ProfitCenter _REAccountingObject ProfitCenter Profit Center
_CompanyCode _CompanyCode
_CostCenter _CostCenter
_InternalOrder _InternalOrder
_WBSElement _WBSElement
_REAccountingObject _REAccountingObject
_REObjectTypeDetails _REObjectTypeDetails

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_REIntegObjectAcctObjAssgmt.
-- 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: IREINTOBJACCASS

CREATE VIEW I_REIntegObjectAcctObjAssgmt AS
SELECT
  _REIntegrationObject.InternalRealEstateNumber AS InternalRealEstateNumber,
  _REObjectAssignment.REStatusObjectTarget AS REAccountingObject,
  _REObjectAssignment.ValidityStartDate AS ValidityStartDate,
  _REObjectAssignment.ValidityEndDate AS ValidityEndDate,
  _REObjectAssignment.REStatusObjectSource AS REStatusObjectSource,
  _REAccountingObject.CompanyCode AS CompanyCode,
  _REAccountingObject.REAccountingObjectType AS REAccountingObjectType,
  _REObjectAssignment.REOnlyInfoAssgmt AS REOnlyInfoAssgmt,
  _REObjectAssignment.REIsLeadingObject AS REIsLeadingObject,
  _REIntegrationObject.REIntegObjSpaceGroupType AS REIntegObjSpaceGroupType,
  _REIntegrationObject.REParentIntegObjectType AS REParentIntegObjectType,
  _REIntegrationObject.REParentIntegObjectExternalID AS REParentIntegObjectExternalID,
  _REAccountingObject.CostCenter AS CostCenter,
  _REAccountingObject.InternalOrder AS InternalOrder,
  _REAccountingObject.OrderType AS OrderType,
  _REAccountingObject.ControllingArea AS ControllingArea,
  _REAccountingObject.ProfitCenter AS ProfitCenter
FROM I_REObjectAssgmt AS _REObjectAssignment
LEFT OUTER JOIN I_REIntegrationObjectBasicData AS _REIntegrationObject ON _REObjectAssignment.REStatusObjectSource = _REIntegrationObject.REStatusObject  -- association [1..1]
LEFT OUTER JOIN I_REControllingObject AS _REAccountingObject ON _REObjectAssignment.REStatusObjectTarget = _REAccountingObject.REAccountingObject  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _REAccountingObject.CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_REObjectTypeDetails AS _REObjectTypeDetails ON _REObjectAssignment.REStatusObjectTarget = _REObjectTypeDetails.REStatusObject  -- association [1..1]
;

Learn More