C_REContractConditionPostgTerm

DDL: C_RECONTRACTCONDITIONPOSTGTERM SQL: CRECCNDPOSTTRM Type: view CONSUMPTION Package: ODATA_RE_CONTRACT_APP
80 Fields 1 Data Sources 2 Associations

RE Contract Condition Posting Term

C_REContractConditionPostgTerm is a Consumption CDS View that provides data about "RE Contract Condition Posting Term" in SAP S/4HANA. It reads from 1 data source (I_REPostingTerm) and exposes 80 fields with key fields InternalRealEstateNumber, RETermType, RETermNumber, ValidityStartEndDateValue. It has 2 associations to related views. Part of development package ODATA_RE_CONTRACT_APP.

Data Sources (1)

SourceAliasJoin Type
I_REPostingTerm I_REPostingTerm from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_REContract _REContract $projection.InternalRealEstateNumber = _REContract.InternalRealEstateNumber
[1..1] I_REPostingTermAddl _REPostingTermAddl $projection.InternalRealEstateNumber = _REPostingTermAddl.InternalRealEstateNumber and $projection.RETermType = _REPostingTermAddl.RETermType and $projection.RETermNumber = _REPostingTermAddl.RETermNumber and $projection.ValidityStartDate = _REPostingTermAddl.ValidityStartDate

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CRECCNDPOSTTRM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
EndUserText.label RE Contract Condition Posting Term view

Fields (80)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY RETermType RETermType Term Category
KEY RETermNumber RETermNumber Number
KEY ValidityStartEndDateValue
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
RealEstateObjectType RealEstateObjectType Object Type
RETermName _RETerm RETermName Name of Term
PaymentMethod PaymentMethod Pymt Meth.
REPaymentMethodCreditMemo REPaymentMethodCreditMemo Payment Method for Credit Memos
PaymentBlockingReason PaymentBlockingReason Pmnt block
PaymentTerms PaymentTerms Pyt Terms
HouseBank HouseBank House Bank
HouseBankAccount HouseBankAccount House Bank Account
BankIdentification BankIdentification Bank Details
RENoteToPayeeText RENoteToPayeeText Note to Payee
DunningArea DunningArea Dunning Area
DunningKey DunningKey Dunning Key
DunningBlockingReason DunningBlockingReason Set Dunning Block
REAcctDeterminationKey REAcctDeterminationKey Account Determination Value
RETaxType RETaxType Tax Type
TaxGroup TaxGroup Tax Group
REIsConditionGrossAmount REIsConditionGrossAmount Gross
TaxCountry TaxCountry Tax Ctry/Reg.
BusinessPartner BusinessPartner Issuing Authority
REAccountingObject REAccountingObject Object Number Account Assignment
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
REIsConditionSplit REIsConditionSplit Split
RECurrencyTranslationRule RECurrencyTranslationRule Currency Translation Rule
REIsPartnerBlocked REIsPartnerBlocked Partner Lock
SEPAMandate SEPAMandate SEPA Mandate
SEPAMandateCreditor SEPAMandateCreditor Creditor ID
CompanyCode CompanyCode Receiver Company Code
Country Country Venue: Ctry/Reg
TaxCalculationProcedure TaxCalculationProcedure Tax Procedure
REStatusObject _REContract REStatusObject Val. Obj. No.
REEntryValidity _REPostingTermAddl REEntryValidity Entry Validity
REEntryValidityCriticality _REPostingTermAddl REEntryValidityCriticality
RETermTypeName
PaymentMethodDescription
PaymentBlockingReasonName
PaymentTermsName
BankName
HouseBankAccountDescription
BankAccountName _BusinessPartnerBank BankAccountName Account Name
DunningAreaName
MaximumDunningLevelDescription
DunningBlockingReasonDesc
REAcctDeterminationKeyName
RETaxTypeName
TaxGroupName
CountryName
BusinessPartnerFullName _BusinessPartner BusinessPartnerFullName Broker Name
TaxJurisdictionName
RECurrencyTranslationRuleName
REEntryValidityText
_REKeyAssgmt _REKeyAssgmt
_RETermType _RETermType
_RETerm _RETerm
_PaymentMethod _PaymentMethod
_PaymentBlockingReason _PaymentBlockingReason
_PaymentTerms _PaymentTerms
_HouseBankBasic _HouseBankBasic
_HouseBankAccount _HouseBankAccount
_BusinessPartnerBank _BusinessPartnerBank
_DunningArea _DunningArea
_DunningKey _DunningKey
_DunningBlockingReasonCode _DunningBlockingReasonCode
_REAcctDeterminationValue _REAcctDeterminationValue
_RETaxType _RETaxType
_RETaxGroup _RETaxGroup
_Country _Country
_BusinessPartner _BusinessPartner
_CostCenter _CostCenter
_WBSElement _WBSElement
_InternalOrder _InternalOrder
_TaxJurisdiction _TaxJurisdiction
_RECurrencyTranslationRule _RECurrencyTranslationRule
_SEPAMandate _SEPAMandate
_REContract _REContract

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_REContractConditionPostgTerm.
-- 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.
-- SQL view name: CRECCNDPOSTTRM

CREATE VIEW C_REContractConditionPostgTerm AS
SELECT
  InternalRealEstateNumber,
  RETermType,
  RETermNumber,
  cast(concat(ValidityStartDate, ValidityEndDate ) as recadateperiod) AS ValidityStartEndDateValue,
  ValidityStartDate,
  ValidityEndDate,
  RealEstateObjectType,
  _RETerm.RETermName AS RETermName,
  PaymentMethod,
  REPaymentMethodCreditMemo,
  PaymentBlockingReason,
  PaymentTerms,
  HouseBank,
  HouseBankAccount,
  BankIdentification,
  RENoteToPayeeText,
  DunningArea,
  DunningKey,
  DunningBlockingReason,
  REAcctDeterminationKey,
  RETaxType,
  TaxGroup,
  REIsConditionGrossAmount,
  TaxCountry,
  BusinessPartner,
  REAccountingObject,
  TaxJurisdiction,
  REIsConditionSplit,
  RECurrencyTranslationRule,
  REIsPartnerBlocked,
  SEPAMandate,
  SEPAMandateCreditor,
  CompanyCode,
  Country,
  TaxCalculationProcedure,
  _REContract.REStatusObject AS REStatusObject,
  _REPostingTermAddl.REEntryValidity AS REEntryValidity,
  _REPostingTermAddl.REEntryValidityCriticality AS REEntryValidityCriticality,
  _RETermType._Text[1:Language=$session.system_language].RETermTypeName AS RETermTypeName,
  _REPostingTermAddl._PaymentMethod._Text[1:Language=$session.system_language].PaymentMethodDescription AS PaymentMethodDescription,
  _PaymentBlockingReason._Text[1:Language=$session.system_language].PaymentBlockingReasonName AS PaymentBlockingReasonName,
  _PaymentTerms._Text[1:Language=$session.system_language].PaymentTermsName AS PaymentTermsName,
  _REPostingTermAddl._HouseBankBasic.BankName AS BankName,
  _REPostingTermAddl._HouseBankAccount._Text[1:Language=$session.system_language].HouseBankAccountDescription AS HouseBankAccountDescription,
  _BusinessPartnerBank.BankAccountName AS BankAccountName,
  _REPostingTermAddl._DunningArea._Text[1:Language=$session.system_language].DunningAreaName AS DunningAreaName,
  _DunningKey._Text[1:Language=$session.system_language].MaximumDunningLevelDescription AS MaximumDunningLevelDescription,
  _DunningBlockingReasonCode._Text[1:Language=$session.system_language].DunningBlockingReasonDesc AS DunningBlockingReasonDesc,
  _REAcctDeterminationValue._Text[1:Language=$session.system_language].REAcctDeterminationKeyName AS REAcctDeterminationKeyName,
  _REPostingTermAddl._RETaxType._Text[1:Language=$session.system_language].RETaxTypeName AS RETaxTypeName,
  _RETaxGroup._Text[1:Language=$session.system_language].TaxGroupName AS TaxGroupName,
  _Country._Text[1:Language=$session.system_language].CountryName AS CountryName,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _REPostingTermAddl._TaxJurisdiction._Text[1:Language=$session.system_language].TaxJurisdictionName AS TaxJurisdictionName,
  _RECurrencyTranslationRule._Text[1:Language=$session.system_language].RECurrencyTranslationRuleName AS RECurrencyTranslationRuleName,
  _REPostingTermAddl._REEntryValidity._Text[1:Language=$session.system_language].REEntryValidityText AS REEntryValidityText
FROM I_REPostingTerm
LEFT OUTER JOIN I_REContract AS _REContract ON InternalRealEstateNumber = _REContract.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_REPostingTermAddl AS _REPostingTermAddl ON InternalRealEstateNumber = _REPostingTermAddl.InternalRealEstateNumber AND RETermType = _REPostingTermAddl.RETermType AND RETermNumber = _REPostingTermAddl.RETermNumber AND ValidityStartDate = _REPostingTermAddl.ValidityStartDate  -- association [1..1]
;

Learn More