C_REUseEnableAddlObjAssgmtTP

DDL: C_REUSEENABLEADDLOBJASSGMTTP Type: view_entity CONSUMPTION
26 Fields 1 Data Sources

Real Estate Use Addl Cost Objects

C_REUseEnableAddlObjAssgmtTP is a Consumption CDS View that provides data about "Real Estate Use Addl Cost Objects" in SAP S/4HANA. It reads from 1 data source (R_REUseEnableAddlObjAssgmtTP) and exposes 26 fields with key fields InternalRealEstateNumber, REObjectAssignmentType, REStatusObjectTarget, ValidityStartEndDateValue.

Data Sources (1)

SourceAliasJoin Type
R_REUseEnableAddlObjAssgmtTP R_REUseEnableAddlObjAssgmtTP projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Real Estate Use Addl Cost Objects view
Metadata.allowExtensions true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY REObjectAssignmentType REObjectAssignmentType Assignment Type
KEY REStatusObjectTarget REStatusObjectTarget Object Number
KEY ValidityStartEndDateValue ValidityStartEndDateValue Validity Period
REStatusObjectTargetForEdit REStatusObjectTargetForEdit Object Number
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
REObjectTypeTarget REObjectTypeTarget BusObjType
REIsLeadingObject REIsLeadingObject
REIntegrationObjectType _REIntegrationObjectTP REIntegrationObjectType
CompanyCodeEnableUse _REIntegrationObjectTP CompanyCode Receiver Company Code
REIdentification REIdentification Object
virtualCompanyCodebukrs
virtualREObjectTextrecnvdmobjname
virtualSemanticObjectchar40
virtualCostCenterkostl
virtualControllingAreakokrs
virtualWBSElementExternalIDps_posid_edit
virtualInternalOrderfins_int_aufnr
virtualREBusinessEntityrebdvdmbeno
virtualRealEstateBuildingrebdvdmbuno
virtualRealEstatePropertyrebdvdmprno
virtualRERentalObjectrebdvdmrono
virtualRealEstateContractrecnvdmcnnr
REEntryValidity REEntryValidity Entry Validity
REEntryValidityCriticality REEntryValidityCriticality

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 C_REUseEnableAddlObjAssgmtTP.
-- 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 C_REUseEnableAddlObjAssgmtTP AS
SELECT
  InternalRealEstateNumber,
  REObjectAssignmentType,
  REStatusObjectTarget,
  ValidityStartEndDateValue,
  REStatusObjectTargetForEdit,
  ValidityStartDate,
  ValidityEndDate,
  REObjectTypeTarget,
  REIsLeadingObject,
  _REIntegrationObjectTP.REIntegrationObjectType AS REIntegrationObjectType,
  _REIntegrationObjectTP.CompanyCode AS CompanyCodeEnableUse,
  REIdentification,
  virtual CompanyCode : bukrs AS virtualCompanyCodebukrs,
  virtual REObjectText : recnvdmobjname AS virtualREObjectTextrecnvdmobjname,
  virtual SemanticObject : char40 AS virtualSemanticObjectchar40,
  virtual CostCenter : kostl AS virtualCostCenterkostl,
  virtual ControllingArea : kokrs AS virtualControllingAreakokrs,
  virtual WBSElementExternalID : ps_posid_edit AS virtualWBSElementExternalIDps_posid_edit,
  virtual InternalOrder : fins_int_aufnr AS virtualInternalOrderfins_int_aufnr,
  virtual REBusinessEntity : rebdvdmbeno AS virtualREBusinessEntityrebdvdmbeno,
  virtual RealEstateBuilding : rebdvdmbuno AS virtualRealEstateBuildingrebdvdmbuno,
  virtual RealEstateProperty : rebdvdmprno AS virtualRealEstatePropertyrebdvdmprno,
  virtual RERentalObject : rebdvdmrono AS virtualRERentalObjectrebdvdmrono,
  virtual RealEstateContract : recnvdmcnnr AS virtualRealEstateContractrecnvdmcnnr,
  REEntryValidity,
  REEntryValidityCriticality
FROM R_REUseEnableAddlObjAssgmtTP
;

Learn More