C_REContractDEX

DDL: C_RECONTRACTDEX Type: view_entity CONSUMPTION

Extraction for REContract

C_REContractDEX is a Consumption CDS View (Dimension) that provides data about "Extraction for REContract" in SAP S/4HANA. It reads from 1 data source (I_REContract) and exposes 33 fields with key field InternalRealEstateNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_REContract I_REContract from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_REContract _Extension $projection.InternalRealEstateNumber = _Extension.InternalRealEstateNumber

Annotations (19)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey InternalRealEstateNumber view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.sapObjectNodeType.name RealEstateContract view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.elementSuffix Rec view
AbapCatalog.extensibility.quota.maximumBytes 8160 view
AbapCatalog.extensibility.quota.maximumFields 408 view
AbapCatalog.extensibility.allowNewCompositions false view
EndUserText.label Extraction for REContract view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber
CompanyCode CompanyCode
RealEstateContract RealEstateContract
REStatusObject REStatusObject
REInternalFinNumber REInternalFinNumber
RECreationType RECreationType
REAuthorizationGroup REAuthorizationGroup
REContractType REContractType
ContractStartDate ContractStartDate
ContractEndDate ContractEndDate
REContractName REContractName
REContractActivateDate REContractActivateDate
RETenancyLaw RETenancyLaw
REContractNumberOld REContractNumberOld
REMainContractCompanyCode REMainContractCompanyCode
REMainContract REMainContract
REContractCurrency REContractCurrency
RECashFlowPostingFromDate RECashFlowPostingFromDate
REBusinessEntity REBusinessEntity
REObjectAvailableFromDate REObjectAvailableFromDate
REObjectAvailableToDate REObjectAvailableToDate
REHasMultipleAssignments REHasMultipleAssignments
RealEstateObjectType RealEstateObjectType
REIdentificationKey REIdentificationKey
_CompanyCode _CompanyCode
_REObjectType _REObjectType
_RECreationType _RECreationType
_StatusObject _StatusObject
_REContractType _REContractType
_RETenancyLaw _RETenancyLaw
_MainContractCompanyCode _MainContractCompanyCode
_Currency _Currency
_REAuthorizationGroup _REAuthorizationGroup
@AccessControl.authorizationCheck: #CHECK

@VDM.viewType: #CONSUMPTION
@Analytics:{
  dataCategory: #DIMENSION,
  dataExtraction.enabled: true,
  internalName:#LOCAL
}

@Metadata.allowExtensions:true
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.representativeKey: 'InternalRealEstateNumber'
@ObjectModel.supportedCapabilities: [ #EXTRACTION_DATA_SOURCE,
                                      #CDS_MODELING_ASSOCIATION_TARGET,
                                      #ANALYTICAL_DIMENSION ]
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.sapObjectNodeType.name: 'RealEstateContract'
@AbapCatalog.extensibility: {
 extensible: true,
 allowNewDatasources: false,
 dataSources: ['_Extension'],
 elementSuffix: 'Rec',
 quota: { maximumBytes: 8160, maximumFields: 408 },
 allowNewCompositions: false }

@EndUserText.label: 'Extraction for REContract'
define view entity C_REContractDEX
  as select from I_REContract
  association [1..1] to E_REContract                 as _Extension                  on  $projection.InternalRealEstateNumber = _Extension.InternalRealEstateNumber
{
  key InternalRealEstateNumber,
      CompanyCode,
      RealEstateContract,
      REStatusObject,
      REInternalFinNumber,
      RECreationType,
      //  CreatedByUser,

      //  CreationDate,

      //  CreationTime,

      //  RESourceOfCreation,

      //  LastChangedByUser,

      //  LastChangeDate,

      //  LastChangeTime,

      //  RESourceOfChange,

      //  Responsible,

      //  REUserExclusive,

      REAuthorizationGroup,
      REContractType,
      ContractStartDate,
      ContractEndDate,
      REContractName,
      REContractActivateDate,
      RETenancyLaw,
      REContractNumberOld,
      REMainContractCompanyCode,
      REMainContract,
      REContractCurrency,
      //  REIndustrySector,

      //  REIsSalesRelevant,

      //  REContractDepositType,

      //  REContractSignDate,

      //  REContract2SignDate,

      //  REContractCashFlowDate,

      //  REContractFirstEndDate,

      //  REContractNoticeDate,

      //  REContractNoticeInDate,

      //  REContractNoticeReason,

      //  REContractNoticeActivationDate,

      //  RECashFlowArchivedToDate,

      //  RECashFlowLockedToDate,

      RECashFlowPostingFromDate,
      REBusinessEntity,
      REObjectAvailableFromDate,
      REObjectAvailableToDate,
      REHasMultipleAssignments,
      //  REPossessionStartDate,

      //  REPossessionEndDate,

      //  ValuationRelevance,

      RealEstateObjectType,
      REIdentificationKey,
//      REBusinessPartnerRole1,


       _CompanyCode,
       _REObjectType,
       _RECreationType,
       _StatusObject,
       _REContractType,
       _RETenancyLaw,
       _MainContractCompanyCode,
       _Currency,
       _REAuthorizationGroup
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RECONTRACT"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_CURRENCY",
"I_REAUTHORIZATIONGROUP",
"I_RECONTRACTTYPE",
"I_RECREATIONTYPE",
"I_REOBJECTTYPE",
"I_RETENANCYLAW",
"I_STATUSOBJECT"
],
"BASE":
[
"I_RECONTRACT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/