R_RECONTRPOSTINGTERMTP

CDS View

Real Estate Posting Rule Term TP

R_RECONTRPOSTINGTERMTP is a CDS View in S/4HANA. Real Estate Posting Rule Term TP. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_REContrPostingTerm view_entity projection CONSUMPTION Posting Terms
C_REContractPostingTermTP view_entity projection CONSUMPTION RE Contract Posting Term 
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Posting Rule Term TP'
@ObjectModel.representativeKey: 'InternalRealEstateNumber'
@Analytics.technicalName: 'RREPOSTGTRMTM'
@ObjectModel.semanticKey: ['InternalRealEstateNumber', 'RETermType', 'RETermNumber', 'ValidityStartEndDateValue' ]
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]

define view entity R_REContrPostingTermTP
  as select from I_REPostingTerm as _REPostingTerm
  association        to parent R_REContractTP as _REContract            on  $projection.InternalRealEstateNumber = _REContract.InternalRealEstateNumber
  association [1..1] to I_REEntryValidity     as _REEntryValidity       on  $projection.REEntryValidity = _REEntryValidity.REEntryValidity
  association [1..1] to I_REPostingTermAddl   as _REPostingTermAddl     on  $projection.InternalRealEstateNumber = _REPostingTermAddl.InternalRealEstateNumber
                                                                        and $projection.RETermType               = _REPostingTermAddl.RETermType
                                                                        and $projection.RETermNumber             = _REPostingTermAddl.RETermNumber
                                                                        and $projection.ValidityStartDate        = _REPostingTermAddl.ValidityStartDate
  association [1..1] to I_REObjectType        as _REAccObjectTypeTarget on  $projection.REAccountingObjectType = _REAccObjectTypeTarget.RealEstateObjectType
  //association [1..*] to I_REObjectTypeText    as _REObjectTypeText      on  _REObjectTypeText.Language = $session.system_language

{
  key InternalRealEstateNumber,
  key RETermType,
  key RETermNumber,
  key cast(concat(ValidityStartDate, ValidityEndDate ) as recadateperiod) as ValidityStartEndDateValue,

      @Semantics.businessDate.from: true
      cast( coalesce(ValidityStartDate,'00000000' ) as rebdvdmvalidfrom ) as ValidityStartDate,
      @Semantics.businessDate.to: true
      cast( coalesce(ValidityEndDate, '99991231') as rebdvdmvalidto )     as ValidityEndDate,

      @ObjectModel.foreignKey.association: '_REEntryValidity'
      case
           when ValidityStartDate > $session.system_date then cast ('2' as recavdmentryvalidity)
           when ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date then cast('3' as recavdmentryvalidity)
           else cast ('1' as recavdmentryvalidity)
      end                                                                 as REEntryValidity,

      case
           when ValidityStartDate > $session.system_date then 2
           when ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date then 3
      else 1
      end                                                                 as REEntryValidityCriticality,

      _RETerm.RETermName,
      RealEstateObjectType,
      _REContract.REIdentificationKey,
      _REContract.REStatusObject,
      //      _REAccountingObject.REAccountingObjectType,

      left(REAccountingObject,2)                                          as REAccountingObjectType,
      @ObjectModel.virtualElement: true
      cast( '' as recaident )                                             as REIdentification,
      PaymentMethod,
      REPaymentMethodCreditMemo,
      PaymentBlockingReason,
      PaymentTerms,
      HouseBank,
      HouseBankAccount,
      @ObjectModel.foreignKey.association: '_BusinessPartnerBank'
      cast(BankIdentification as retmvdmbankident preserving type )       as BankIdentification,
      RENoteToPayeeText,
      DunningArea,
      DunningKey,
      DunningBlockingReason,
      REAcctDeterminationKey,
      RETaxType,
      TaxGroup,
      REIsConditionGrossAmount,
      TaxCountry,
      BusinessPartner,
      REAccountingObject,
      TaxJurisdiction,
      REIsConditionSplit,
      RECurrencyTranslationRule,
      REIsPartnerBlocked,
      SEPAMandate,
      SEPAMandateCreditor,
      
      //needed to avoid Addl view access & resolving text associations

      CompanyCode,
      @ObjectModel.foreignKey.association: '_Country'
      Country,
      TaxCalculationProcedure,
  
      _REContract,
      _REEntryValidity,
      _REPostingTermAddl,
      _REKeyAssgmt,
      _RETermType,
      _RETerm,
      _PaymentMethod,
      _PaymentBlockingReason,
      _PaymentTerms,
      _HouseBankBasic,
      _HouseBankAccount,
      _BusinessPartnerBank,
      _DunningArea,
      _DunningKey,
      _DunningBlockingReasonCode,
      _REAcctDeterminationValue,
      _RETaxType,
      _RETaxGroup,
      _Country,
      _BusinessPartner,
      _CostCenter,
      _WBSElement,
      _InternalOrder,
      _TaxJurisdiction,
      _RECurrencyTranslationRule,
      _SEPAMandate,
      _REAccountingObject,
      _REAccObjectTypeTarget
      //_REObjectTypeText

} 
where
  _REContract.RealEstateObjectType = 'IS'

Learn More