C_REOutpReqContract

DDL: C_REOUTPREQCONTRACT Type: view_entity CONSUMPTION
28 Fields 1 Data Sources

Real Estate Contract for Output Request

C_REOutpReqContract is a Consumption CDS View that provides data about "Real Estate Contract for Output Request" in SAP S/4HANA. It reads from 1 data source (I_REContract) and exposes 28 fields with key field InternalRealEstateNumber.

Data Sources (1)

SourceAliasJoin Type
I_REContract REContract from

Annotations (8)

NameValueLevelField
EndUserText.label Real Estate Contract for Output Request view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
Search.searchable true view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
CompanyCode CompanyCode Receiver Company Code
RealEstateContract Real Estate Contract
REStatusObject REStatusObject Val. Obj. No.
REInternalFinNumber REInternalFinNumber Real Estate Key
RECreationType RECreationType How Created
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
RESourceOfCreation RESourceOfCreation Source.In.Entry
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
RESourceOfChange RESourceOfChange Editing Source
Responsible Responsible User Name
REUserExclusive REUserExclusive Change Auth.
REAuthorizationGroup REAuthorizationGroup Authoriz. Group
REContractType REContractType Contract Type
ContractStartDate ContractStartDate Contract Start Date
ContractEndDate ContractEndDate Contract End Date
REContractName REContractName Contract Name
REContractActivateDate REContractActivateDate Active From
RETenancyLaw RETenancyLaw Tenancy Law
REContractNumberOld REContractNumberOld Old Contract
REMainContractCompanyCode REMainContractCompanyCode Main Contract Company Code
REMainContract REMainContract Main Contract
CompanyCodeName _CompanyCode CompanyCodeName Company Name
REContractTypeName

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_REOutpReqContract.
-- 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_REOutpReqContract AS
SELECT
  InternalRealEstateNumber,
  CompanyCode,
  cast( RealEstateContract as recnnumber preserving type ) AS RealEstateContract,
  REStatusObject,
  REInternalFinNumber,
  RECreationType,
  CreatedByUser,
  CreationDate,
  CreationTime,
  RESourceOfCreation,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  RESourceOfChange,
  Responsible,
  REUserExclusive,
  REAuthorizationGroup,
  REContractType,
  ContractStartDate,
  ContractEndDate,
  REContractName,
  REContractActivateDate,
  RETenancyLaw,
  REContractNumberOld,
  REMainContractCompanyCode,
  REMainContract,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _REContractType._Text[Language = $session.system_language].REContractTypeName AS REContractTypeName
FROM I_REContract AS REContract
;

Learn More