C_REContractPostingTermTP

DDL: C_RECONTRACTPOSTINGTERMTP Type: view_entity CONSUMPTION
75 Fields 1 Data Sources

RE Contract Posting Term

C_REContractPostingTermTP is a Consumption CDS View that provides data about "RE Contract Posting Term" in SAP S/4HANA. It reads from 1 data source (R_REContrPostingTermTP) and exposes 75 fields with key fields InternalRealEstateNumber, RETermType, RETermNumber, ValidityStartEndDateValue.

Data Sources (1)

SourceAliasJoin Type
R_REContrPostingTermTP R_REContrPostingTermTP 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 Posting Term view
Metadata.allowExtensions true view

Fields (75)

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
ValidityEndDate ValidityEndDate ValidTo
RETermName RETermName Name of Term
RealEstateObjectType RealEstateObjectType Object Type
REIdentificationKey _REContract REIdentificationKey Object ID
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
REAccountingObjectType REAccountingObjectType Object Type of Assigned Object
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 _REContract CompanyCode Receiver Company Code
REContractType _REContract REContractType Contract Type
Country
TaxCalculationProcedure TaxCalculationProcedure Tax Procedure
REStatusObject REStatusObject Val. Obj. No.
REEntryValidity REEntryValidity Entry Validity
REEntryValidityCriticality REEntryValidityCriticality
virtualRETaxCountryIsHiddenabap_boolean
virtualNoteUUIDbobfconf_key
virtualNoteObjectnte_objectid
REIdentification REIdentification Object
virtualCostCenterkostl
virtualControllingAreakokrs
virtualWBSElementExternalIDps_posid_edit
virtualInternalOrderfins_int_aufnr
RETermTypeNameasRETermTypeNamelocalized
BankName _HouseBankBasic BankName Bank Name
BankAccountName _BusinessPartnerBank BankName Bank Name
RETaxTypeNameasRETaxTypeNamelocalized
TaxGroupNameasTaxGroupNamelocalized
CountryNameasCountryNamelocalized
BusinessPartnerFullName _BusinessPartner BusinessPartnerFullName Broker Name
REBusinessPartnerRole1 _REContract REBusinessPartnerRole1 BP Role
SemanticObject _REAccObjectTypeTarget SemanticObject Semantic Object
_REKeyAssgmt _REKeyAssgmt
_RETermType _RETermType
_RETerm _RETerm
_PaymentBlockingReason _PaymentBlockingReason
_PaymentTerms _PaymentTerms
_BusinessPartnerBank _BusinessPartnerBank
_DunningKey _DunningKey
_DunningBlockingReasonCode _DunningBlockingReasonCode
_REAcctDeterminationValue _REAcctDeterminationValue
_RETaxGroup _RETaxGroup
_Country _Country
_BusinessPartner _BusinessPartner
_CostCenter _CostCenter
_WBSElement _WBSElement
_InternalOrder _InternalOrder
_RECurrencyTranslationRule _RECurrencyTranslationRule
_SEPAMandate _SEPAMandate

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_REContractPostingTermTP.
-- 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_REContractPostingTermTP AS
SELECT
  InternalRealEstateNumber,
  RETermType,
  RETermNumber,
  ValidityStartEndDateValue,
  ValidityStartDate,
  ValidityEndDate,
  RETermName,
  RealEstateObjectType,
  _REContract.REIdentificationKey AS REIdentificationKey,
  PaymentMethod,
  REPaymentMethodCreditMemo,
  PaymentBlockingReason,
  PaymentTerms,
  HouseBank,
  HouseBankAccount,
  BankIdentification,
  RENoteToPayeeText,
  DunningArea,
  DunningKey,
  DunningBlockingReason,
  REAcctDeterminationKey,
  RETaxType,
  TaxGroup,
  REIsConditionGrossAmount,
  TaxCountry,
  BusinessPartner,
  REAccountingObjectType,
  REAccountingObject,
  TaxJurisdiction,
  REIsConditionSplit,
  RECurrencyTranslationRule,
  REIsPartnerBlocked,
  SEPAMandate,
  SEPAMandateCreditor,
  _REContract.CompanyCode AS CompanyCode,
  _REContract.REContractType AS REContractType,
  _REContract._CompanyCode.Country AS Country,
  TaxCalculationProcedure,
  REStatusObject,
  REEntryValidity,
  REEntryValidityCriticality,
  virtual RETaxCountryIsHidden : abap_boolean AS virtualRETaxCountryIsHiddenabap_boolean,
  virtual NoteUUID : /bobf/conf_key AS virtualNoteUUIDbobfconf_key,
  virtual NoteObject : nte_objectid AS virtualNoteObjectnte_objectid,
  REIdentification,
  virtual CostCenter : kostl AS virtualCostCenterkostl,
  virtual ControllingArea : kokrs AS virtualControllingAreakokrs,
  virtual WBSElementExternalID : ps_posid_edit AS virtualWBSElementExternalIDps_posid_edit,
  virtual InternalOrder : fins_int_aufnr AS virtualInternalOrderfins_int_aufnr,
  _RETermType._Text.RETermTypeName as RETermTypeName : localized AS RETermTypeNameasRETermTypeNamelocalized,
  _HouseBankBasic.BankName AS BankName,
  _BusinessPartnerBank.BankName AS BankAccountName,
  _RETaxType._Text.RETaxTypeName as RETaxTypeName : localized AS RETaxTypeNameasRETaxTypeNamelocalized,
  _RETaxGroup._Text.TaxGroupName as TaxGroupName : localized AS TaxGroupNameasTaxGroupNamelocalized,
  _Country._Text.CountryName as CountryName : localized AS CountryNameasCountryNamelocalized,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _REContract.REBusinessPartnerRole1 AS REBusinessPartnerRole1,
  _REAccObjectTypeTarget.SemanticObject AS SemanticObject
FROM R_REContrPostingTermTP
;

Learn More