P_REIntegObjectSubObjTimeline

DDL: P_REINTEGOBJECTSUBOBJTIMELINE Type: view_entity
12 Fields 1 Data Sources 4 Associations

RE Integration Object Sub Object Timeline

P_REIntegObjectSubObjTimeline is a CDS View that provides data about "RE Integration Object Sub Object Timeline" in SAP S/4HANA. It reads from 1 data source (P_REIntegObjOccpcyHierCalc3) and exposes 12 fields with key fields InternalRealEstateNumber, ValidityEndDate. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_REIntegObjOccpcyHierCalc3 _REIntegObjOccpcyHierCalc3 from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_REIntegrationObject _REUseEnableIntegrationObject $projection.REInternalNumberForUseEnable = _REUseEnableIntegrationObject.InternalRealEstateNumber
[1..1] I_REContract _REContract _REIntegObjectOccupancy.CompanyCode = _REContract.CompanyCode and _REIntegObjectOccupancy.RealEstateContract = _REContract.RealEstateContract
[0..1] I_REControllingObject _REControllingObject $projection.reaccountingobject = _REControllingObject.REAccountingObject
[0..1] I_BusinessPartner _BusinessPartner $projection.businesspartner = _BusinessPartner.BusinessPartner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label RE Integration Object Sub Object Timeline view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber P_REIntegObjOccpcyHierCalc3 InternalRealEstateNumber RE Key
KEY ValidityEndDate P_REIntegObjOccpcyHierCalc3 ValidityEndDate ValidTo
ValidityStartDate P_REIntegObjOccpcyHierCalc3 ValidityStartDate Validity Start Date
REIntegrationObjectType P_REIntegObjOccpcyHierCalc3 REIntegrationObjectType
REInternalNumberForOccupancy _REIntegObjectObject2SpaceGrp InternalRealEstateNumberLvl0
REInternalNumberForUseEnable _REIntegObjectObject2SpaceGrp REInternalNumberForUseEnable
REIsObjectRelationPartial _REIntegObjectObject2SpaceGrp REIsObjectRelationPartial
CompanyCode _REUseEnableIntegrationObject CompanyCode Receiver Company Code
BusinessPartner
REAccountingObject
_BusinessPartner _BusinessPartner
_REControllingObject _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 P_REIntegObjectSubObjTimeline.
-- 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.

CREATE VIEW P_REIntegObjectSubObjTimeline AS
SELECT
  _REIntegObjOccpcyHierCalc3.InternalRealEstateNumber AS InternalRealEstateNumber,
  _REIntegObjOccpcyHierCalc3.ValidityEndDate AS ValidityEndDate,
  _REIntegObjOccpcyHierCalc3.ValidityStartDate AS ValidityStartDate,
  _REIntegObjOccpcyHierCalc3.REIntegrationObjectType AS REIntegrationObjectType,
  _REIntegObjectObject2SpaceGrp.InternalRealEstateNumberLvl0 AS REInternalNumberForOccupancy,
  _REIntegObjectObject2SpaceGrp.REInternalNumberForUseEnable AS REInternalNumberForUseEnable,
  _REIntegObjectObject2SpaceGrp.REIsObjectRelationPartial AS REIsObjectRelationPartial,
  _REUseEnableIntegrationObject.CompanyCode AS CompanyCode,
  _REContract._REPartnerAssgmt[1: ( ValidityStartDate <= validityenddate and ValidityEndDate >= validitystartdate ) ].BusinessPartner AS BusinessPartner,
  _REContract._REPostingTerm[1: ( ValidityStartDate <= validityenddate and ValidityEndDate >= validitystartdate ) ].REAccountingObject AS REAccountingObject
FROM P_REIntegObjOccpcyHierCalc3 AS _REIntegObjOccpcyHierCalc3
LEFT OUTER JOIN I_REIntegrationObject AS _REUseEnableIntegrationObject ON REInternalNumberForUseEnable = _REUseEnableIntegrationObject.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_REContract AS _REContract ON _REIntegObjectOccupancy.CompanyCode = _REContract.CompanyCode AND _REIntegObjectOccupancy.RealEstateContract = _REContract.RealEstateContract  -- association [1..1]
LEFT OUTER JOIN I_REControllingObject AS _REControllingObject ON reaccountingobject = _REControllingObject.REAccountingObject  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON businesspartner = _BusinessPartner.BusinessPartner  -- association [0..1]
;

Learn More