C_REUsblObjToContractAssgmtTP

DDL: C_REUSBLOBJTOCONTRACTASSGMTTP Type: view_entity CONSUMPTION
20 Fields 1 Data Sources

Real Estate Usable Object Contr Assign

C_REUsblObjToContractAssgmtTP is a Consumption CDS View that provides data about "Real Estate Usable Object Contr Assign" in SAP S/4HANA. It reads from 1 data source (R_REUsblObjToContractAssgmtTP) and exposes 20 fields with key fields RealEstateUsableObjectUUID, REObjectAssignmentType, CompanyCode, RealEstateContract, ValidityStartEndDateValue.

Data Sources (1)

SourceAliasJoin Type
R_REUsblObjToContractAssgmtTP R_REUsblObjToContractAssgmtTP projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Real Estate Usable Object Contr Assign view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY RealEstateUsableObjectUUID RealEstateUsableObjectUUID
KEY REObjectAssignmentType REObjectAssignmentType Assignment Type
KEY CompanyCode CompanyCode Receiver Company Code
KEY RealEstateContract RealEstateContract Real Estate Contract
KEY ValidityStartEndDateValue ValidityStartEndDateValue Validity Period
CompanyCodeForEdit CompanyCodeForEdit Company Code
RealEstateContractForEdit RealEstateContractForEdit Real Estate Contract
REStatusObjectTarget REStatusObjectTarget Object Number
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
REOnlyInfoAssgmt REOnlyInfoAssgmt Informational
REStatusObjectSourceIsArchived REStatusObjectSourceIsArchived
REStatusObject _REUsableObject REStatusObject Val. Obj. No.
REContractType _REContract REContractType Contract Type
REContractName _REContract REContractName Contract Name
RealEstateContractOID _REContract RealEstateContractOID Real Estate Contract OID
REEntryValidity REEntryValidity Entry Validity
REEntryValidityCriticality REEntryValidityCriticality
CompanyCodeName _CompanyCode CompanyCodeName Company Name
_REContract _REContract

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_REUsblObjToContractAssgmtTP.
-- 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_REUsblObjToContractAssgmtTP AS
SELECT
  RealEstateUsableObjectUUID,
  REObjectAssignmentType,
  CompanyCode,
  RealEstateContract,
  ValidityStartEndDateValue,
  CompanyCodeForEdit,
  RealEstateContractForEdit,
  REStatusObjectTarget,
  ValidityStartDate,
  ValidityEndDate,
  REOnlyInfoAssgmt,
  REStatusObjectSourceIsArchived,
  _REUsableObject.REStatusObject AS REStatusObject,
  _REContract.REContractType AS REContractType,
  _REContract.REContractName AS REContractName,
  _REContract.RealEstateContractOID AS RealEstateContractOID,
  REEntryValidity,
  REEntryValidityCriticality,
  _CompanyCode.CompanyCodeName AS CompanyCodeName
FROM R_REUsblObjToContractAssgmtTP
;

Learn More