I_REPostingTermAddl

DDL: I_REPOSTINGTERMADDL SQL: IREPOSTGTRMADDL Type: view COMPOSITE Package: VDM_RE_TM
21 Fields 1 Data Sources 1 Associations

RE Posting Term additional

I_REPostingTermAddl is a Composite CDS View that provides data about "RE Posting Term additional" in SAP S/4HANA. It reads from 1 data source (I_REPostingTerm) and exposes 21 fields with key fields InternalRealEstateNumber, RETermType, RETermNumber, ValidityStartDate. It has 1 association to related views. Part of development package VDM_RE_TM.

Data Sources (1)

SourceAliasJoin Type
I_REPostingTerm I_REPostingTerm from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_REEntryValidity _REEntryValidity $projection.REEntryValidity = _REEntryValidity.REEntryValidity

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IREPOSTGTRMADDL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label RE Posting Term additional view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY RETermType RETermType Term Category
KEY RETermNumber RETermNumber Number
KEY ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
CompanyCode CompanyCode Receiver Company Code
Country Country Venue: Ctry/Reg
TaxCalculationProcedure TaxCalculationProcedure Tax Procedure
HouseBank HouseBank House Bank
HouseBankAccount HouseBankAccount House Bank Account
DunningArea DunningArea Dunning Area
PaymentMethod PaymentMethod Pymt Meth.
RETaxType RETaxType Tax Type
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
_PaymentMethod _PaymentMethod
_HouseBankBasic _HouseBankBasic
_HouseBankAccount _HouseBankAccount
_DunningArea _DunningArea
_RETaxType _RETaxType
_TaxJurisdiction _TaxJurisdiction
_REEntryValidity _REEntryValidity

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 I_REPostingTermAddl.
-- 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: IREPOSTGTRMADDL

CREATE VIEW I_REPostingTermAddl AS
SELECT
  InternalRealEstateNumber,
  RETermType,
  RETermNumber,
  ValidityStartDate,
  ValidityEndDate,
  CompanyCode,
  Country,
  TaxCalculationProcedure,
  HouseBank,
  HouseBankAccount,
  DunningArea,
  PaymentMethod,
  RETaxType,
  TaxJurisdiction
FROM I_REPostingTerm
LEFT OUTER JOIN I_REEntryValidity AS _REEntryValidity ON REEntryValidity = _REEntryValidity.REEntryValidity  -- association [1..1]
;

Learn More