P_REArchtrObjAssgmtCalc2

DDL: P_REARCHTROBJASSGMTCALC2 Type: view_entity COMPOSITE Package: VDM_RE_OB
20 Fields 1 Data Sources

RE AO Controlling Object Assgmt Calc 2

P_REArchtrObjAssgmtCalc2 is a Composite CDS View that provides data about "RE AO Controlling Object Assgmt Calc 2" in SAP S/4HANA. It reads from 1 data source (P_REArchtrObjAssgmtCalc1) and exposes 20 fields with key fields InternalRealEstateNumber, REGnrcRentalObjPortfolioID, REAccountingObject, ValidityStartDate. Part of development package VDM_RE_OB.

Data Sources (1)

SourceAliasJoin Type
P_REArchtrObjAssgmtCalc1 _REObjectAssignment from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label RE AO Controlling Object Assgmt Calc 2 view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY REGnrcRentalObjPortfolioID REGnrcRentalObjPortfolioID Portfolio ID
KEY REAccountingObject REAccountingObject Object Number Account Assignment
KEY ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate
CompanyCode CompanyCode Receiver Company Code
REArchtrObjectNumberBldngLand REArchtrObjectNumberBldngLand Building/Land Object Number
REArchtrObjectBldngLandName REArchtrObjectBldngLandName
REArchitectureObjectUUID REArchitectureObjectUUID UUID Architecture Object
REGenericRentalObjParentUUID REGenericRentalObjParentUUID UUID Parent GO
ControllingArea ControllingArea Controlling Area
CostCenter _CostCenter CostCenter Cost Center
WBSElementExternalID _WBSElement WBSElementExternalID WBS Element External ID
WBSElementInternalID _WBSElement WBSElementInternalID WBS Internal ID
InternalOrder _InternalOrder InternalOrder Order
_REObjectTypeDetails _REObjectTypeDetails
_CostCenter _CostCenter
_WBSElement _WBSElement
_InternalOrder _InternalOrder
_REArchitectureObject _REArchitectureObject

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_REArchtrObjAssgmtCalc2.
-- 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_REArchtrObjAssgmtCalc2 AS
SELECT
  InternalRealEstateNumber,
  REGnrcRentalObjPortfolioID,
  REAccountingObject,
  ValidityStartDate,
  max( ValidityEndDate ) AS ValidityEndDate,
  CompanyCode,
  REArchtrObjectNumberBldngLand,
  REArchtrObjectBldngLandName,
  REArchitectureObjectUUID,
  REGenericRentalObjParentUUID,
  ControllingArea,
  _CostCenter.CostCenter AS CostCenter,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  _WBSElement.WBSElementInternalID AS WBSElementInternalID,
  _InternalOrder.InternalOrder AS InternalOrder
FROM P_REArchtrObjAssgmtCalc1 AS _REObjectAssignment
;

Learn More