A_REIntegObjectContractAssgmt

DDL: A_REINTEGOBJECTCONTRACTASSGMT Type: view_entity CONSUMPTION
15 Fields 1 Data Sources

Contract Assignment

A_REIntegObjectContractAssgmt is a Consumption CDS View that provides data about "Contract Assignment" in SAP S/4HANA. It reads from 1 data source (R_REIntegObjContractAssgmtTP) and exposes 15 fields with key fields InternalRealEstateNumber, REObjectAssignmentType, CompanyCode, RealEstateContract, ValidityStartEndDateValue.

Data Sources (1)

SourceAliasJoin Type
R_REIntegObjContractAssgmtTP R_REIntegObjContractAssgmtTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Contract Assignment view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name REIntegObjectContractAssgmt_Type view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY REObjectAssignmentType REObjectAssignmentType Assignment Type
KEY CompanyCode CompanyCode Receiver Company Code
KEY RealEstateContract RealEstateContract Real Estate Contract
KEY ValidityStartEndDateValue ValidityStartEndDateValue Validity Period
REStatusObjectTarget REStatusObjectTarget Object Number
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
REOnlyInfoAssgmt REOnlyInfoAssgmt Informational
REStatusObjectSourceIsArchived REStatusObjectSourceIsArchived
REObjectPossessionStartDate REObjectPossessionStartDate Possession From
REObjectPossessionEndDate REObjectPossessionEndDate Possession To
REIdentificationKey
REContractType _REContract REContractType Contract Type
REContractName _REContract REContractName Contract Name

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 A_REIntegObjectContractAssgmt.
-- 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 A_REIntegObjectContractAssgmt AS
SELECT
  InternalRealEstateNumber,
  REObjectAssignmentType,
  CompanyCode,
  RealEstateContract,
  ValidityStartEndDateValue,
  REStatusObjectTarget,
  ValidityStartDate,
  ValidityEndDate,
  REOnlyInfoAssgmt,
  REStatusObjectSourceIsArchived,
  REObjectPossessionStartDate,
  REObjectPossessionEndDate,
  _REContract._REKeyAssgmt.REIdentificationKey AS REIdentificationKey,
  _REContract.REContractType AS REContractType,
  _REContract.REContractName AS REContractName
FROM R_REIntegObjContractAssgmtTP
;

Learn More