C_REContractOrglAssgmtTermTP

DDL: C_RECONTRACTORGLASSGMTTERMTP Type: view_entity CONSUMPTION Package: ODATA_RE_CONTRACT_APP
36 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

RE Contract Orgl Assignment Term

C_REContractOrglAssgmtTermTP is a Consumption CDS View that provides data about "RE Contract Orgl Assignment Term" in SAP S/4HANA. It reads from 1 data source (R_REContrOrglAssgmtTermTP) and exposes 36 fields with key fields InternalRealEstateNumber, RETermType, RETermNumber, ValidityStartEndDateValue. It is exposed through 1 OData service (UI_RECONTRACT). It is used in 1 Fiori application: Contract Management. Part of development package ODATA_RE_CONTRACT_APP.

Data Sources (1)

SourceAliasJoin Type
R_REContrOrglAssgmtTermTP R_REContrOrglAssgmtTermTP 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 RE Contract Orgl Assignment Term view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_RECONTRACT UI_RECONTRACT V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5273 Contract Management Transactional This Fiori App allows customers to manage and maintain their Real Estate Contracts. Through the App customers get the ability to easily understand their contracts and liabilities.

Contract Management

Business Role: Contract Specialist - Leasing

The term section of the contract has been restructured. It now includes subsections for dates, renewal terms, and notice terms to ease navigation inside the contract.

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY RETermType RETermType Term Category
KEY RETermNumber RETermNumber Number
KEY ValidityStartEndDateValue ValidityStartEndDateValue Validity Period
ValidityStartDate ValidityStartDate Validity Start Date
RETermName RETermName Name of Term
RealEstateObjectType RealEstateObjectType Object Type
REIdentificationKey _REKeyAssgmt REIdentificationKey Object ID
ValidityEndDate ValidityEndDate ValidTo
BusinessArea BusinessArea Business Area
ProfitCenter ProfitCenter Profit Center
REStatusObject REStatusObject Val. Obj. No.
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
Fund Fund Sender Fund
FunctionalArea FunctionalArea Sendr Fctl Area
REFundsManagementGrantID REFundsManagementGrantID Grant
BudgetPeriod BudgetPeriod Budget Period
ControllingArea ControllingArea Controlling Area
TaxCalculationProcedure TaxCalculationProcedure Tax Procedure
FinancialManagementArea FinancialManagementArea FM Area
REEntryValidity REEntryValidity Entry Validity
REEntryValidityCriticality REEntryValidityCriticality
virtualCompanyCodebukrs
virtualREFundIsHiddenabap_boolean
virtualNoteUUIDbobfconf_key
virtualNoteObjectnte_objectid
virtualREProfitCenterFromObjectprctr Profit Center from Object Assignment
virtualREBusinessAreaFromObjectgsber Business Area from Object Assignment
RETermTypeNameasRETermTypeNamelocalized
FundNameasFundNamelocalized
_RETermType _RETermType
_REObjectType _REObjectType
_RETerm _RETerm
_BusinessArea _BusinessArea
_FunctionalArea _FunctionalArea
_BudgetPeriod _BudgetPeriod

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_REContractOrglAssgmtTermTP.
-- 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_REContractOrglAssgmtTermTP AS
SELECT
  InternalRealEstateNumber,
  RETermType,
  RETermNumber,
  ValidityStartEndDateValue,
  ValidityStartDate,
  RETermName,
  RealEstateObjectType,
  _REKeyAssgmt.REIdentificationKey AS REIdentificationKey,
  ValidityEndDate,
  BusinessArea,
  ProfitCenter,
  REStatusObject,
  TaxJurisdiction,
  Fund,
  FunctionalArea,
  REFundsManagementGrantID,
  BudgetPeriod,
  ControllingArea,
  TaxCalculationProcedure,
  FinancialManagementArea,
  REEntryValidity,
  REEntryValidityCriticality,
  virtual CompanyCode : bukrs AS virtualCompanyCodebukrs,
  virtual REFundIsHidden : abap_boolean AS virtualREFundIsHiddenabap_boolean,
  virtual NoteUUID : /bobf/conf_key AS virtualNoteUUIDbobfconf_key,
  virtual NoteObject : nte_objectid AS virtualNoteObjectnte_objectid,
  virtual REProfitCenterFromObject : prctr AS virtualREProfitCenterFromObjectprctr,
  virtual REBusinessAreaFromObject : gsber AS virtualREBusinessAreaFromObjectgsber,
  _RETermType._Text.RETermTypeName as RETermTypeName : localized AS RETermTypeNameasRETermTypeNamelocalized,
  _Fund._Text.FundName as FundName : localized AS FundNameasFundNamelocalized
FROM R_REContrOrglAssgmtTermTP
;

Learn More