I_REPostingTerm

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_REPostingTerm.
-- 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: IREPOSTGTRM

CREATE VIEW I_REPostingTerm AS
SELECT
  intreno AS InternalRealEstateNumber,
  termtype AS RETermType,
  termno AS RETermNumber,
  cast(validfrom as rebdvdmvalidfrom) AS ValidityStartDate,
  cast(validto as rebdvdmvalidto) AS ValidityEndDate,
  cast(pymtmeth as farp_schzw_bseg) AS PaymentMethod,
  cast(pymtmethcrmo as retmvdmpymtmethcrmo) AS REPaymentMethodCreditMemo,
  cast(pymtblock as farp_dzlspr) AS PaymentBlockingReason,
  pymtterm AS PaymentTerms,
  cast(housebkid as farp_hbkid) AS HouseBank,
  cast(housebkacc as fac_hktid) AS HouseBankAccount,
  cast(bankdetailid as bu_bkvid) AS BankIdentification,
  notetopayee AS RENoteToPayeeText,
  cast(dunnarea as farp_maber) AS DunningArea,
  cast(dunnkey as farp_mschl) AS DunningKey,
  cast(dunnblock as farp_mansp) AS DunningBlockingReason,
  cast(accdetkey as retmvdmaccdetkey) AS REAcctDeterminationKey,
  taxtype AS RETaxType,
  TaxGroup,
  isgross AS REIsConditionGrossAmount,
  cast(taxcountry as retmvdmtaxcountry) AS TaxCountry,
  partner AS BusinessPartner,
  cast(partnerobjnr as retmvdmpartnerobjnr) AS REAccountingObject,
  txjcd AS TaxJurisdiction,
  iscdsplit AS REIsConditionSplit,
  cast(ctrule as retmvdmcactrule) AS RECurrencyTranslationRule,
  ispartnerblocked AS REIsPartnerBlocked,
  sepamndid AS SEPAMandate,
  separeccrdid AS SEPAMandateCreditor,
  _REKeyAssgmt.RealEstateObjectType AS RealEstateObjectType,
  _REKeyAssgmt.CompanyCode AS CompanyCode,
  _REKeyAssgmt._CompanyCode.Country AS Country,
  _REKeyAssgmt._CompanyCode._Country.TaxCalculationProcedure AS TaxCalculationProcedure
FROM vitmpy AS _REPostingTerm
LEFT OUTER JOIN I_REKeyAssgmt AS _REKeyAssgmt ON InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_RETermType AS _RETermType ON RETermType = _RETermType.RETermType AND RealEstateObjectType = _RETermType.RealEstateObjectType  -- association [1..1]
LEFT OUTER JOIN I_RETerm AS _RETerm ON InternalRealEstateNumber = _RETerm.InternalRealEstateNumber AND RETermType = _RETerm.RETermType AND RETermNumber = _RETerm.RETermNumber  -- association [1..1]
LEFT OUTER JOIN I_PaymentMethod AS _PaymentMethod ON Country = _PaymentMethod.Country AND PaymentMethod = _PaymentMethod.PaymentMethod  -- association [0..1]
LEFT OUTER JOIN I_PaymentBlockingReason AS _PaymentBlockingReason ON PaymentBlockingReason = _PaymentBlockingReason.PaymentBlockingReason  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON PaymentTerms = _PaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_HouseBankBasic AS _HouseBankBasic ON CompanyCode = _HouseBankBasic.CompanyCode AND HouseBank = _HouseBankBasic.HouseBank  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccount AS _HouseBankAccount ON CompanyCode = _HouseBankAccount.CompanyCode AND HouseBank = _HouseBankAccount.HouseBank AND HouseBankAccount = _HouseBankAccount.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerBank AS _BusinessPartnerBank ON BusinessPartner = _BusinessPartnerBank.BusinessPartner AND BankIdentification = _BusinessPartnerBank.BankIdentification  -- association [0..1]
LEFT OUTER JOIN I_DunningArea AS _DunningArea ON CompanyCode = _DunningArea.CompanyCode AND DunningArea = _DunningArea.DunningArea  -- association [0..1]
LEFT OUTER JOIN I_DunningKey AS _DunningKey ON DunningKey = _DunningKey.DunningKey  -- association [0..1]
LEFT OUTER JOIN I_DunningBlockingReasonCode AS _DunningBlockingReasonCode ON DunningBlockingReason = _DunningBlockingReasonCode.DunningBlockingReason  -- association [0..1]
LEFT OUTER JOIN I_REAcctDeterminationValue AS _REAcctDeterminationValue ON REAcctDeterminationKey = _REAcctDeterminationValue.REAcctDeterminationKey  -- association [0..1]
LEFT OUTER JOIN I_RETaxType AS _RETaxType ON Country = _RETaxType.Country AND RETaxType = _RETaxType.RETaxType  -- association [0..1]
LEFT OUTER JOIN I_RETaxGroup AS _RETaxGroup ON TaxGroup = _RETaxGroup.TaxGroup  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON TaxCountry = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON REAccountingObject = _CostCenter.ObjectInternalID AND _CostCenter.ObjectInternalID is not initial  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON REAccountingObject = _WBSElement.WBSElementObject  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON REAccountingObject = _InternalOrder.ControllingObject  -- association [0..1]
LEFT OUTER JOIN I_TaxJurisdiction AS _TaxJurisdiction ON TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction AND TaxCalculationProcedure = _TaxJurisdiction.TaxJurisdictionCalcProcedure  -- association [0..1]
LEFT OUTER JOIN I_RECurrencyTranslationRule AS _RECurrencyTranslationRule ON RECurrencyTranslationRule = _RECurrencyTranslationRule.RECurrencyTranslationRule  -- association [0..1]
LEFT OUTER JOIN I_SEPAMandate AS _SEPAMandate ON SEPAMandate = _SEPAMandate.SEPAMandate  -- association [0..*]
LEFT OUTER JOIN I_REControllingObject AS _REAccountingObject ON REAccountingObject = _REAccountingObject.REAccountingObject  -- association [0..1]
LEFT OUTER JOIN I_PaymentTermsText AS _PaymentTermsText ON PaymentTerms = _PaymentTermsText.PaymentTerms  -- association [0..*]
LEFT OUTER JOIN I_PaymentMethodText AS _PaymentMethodText ON Country = _PaymentMethodText.Country AND PaymentMethod = _PaymentMethodText.PaymentMethod  -- association [0..*]
LEFT OUTER JOIN I_HouseBankAccountText AS _HouseBankAccountText ON CompanyCode = _HouseBankAccountText.CompanyCode AND HouseBank = _HouseBankAccountText.HouseBank AND HouseBankAccount = _HouseBankAccountText.HouseBankAccount  -- association [0..*]
LEFT OUTER JOIN I_DunningAreaText AS _DunningAreaText ON CompanyCode = _DunningAreaText.CompanyCode AND DunningArea = _DunningAreaText.DunningArea  -- association [0..*]
LEFT OUTER JOIN I_RETaxTypeText AS _RETaxTypeText ON Country = _RETaxTypeText.Country AND RETaxType = _RETaxTypeText.RETaxType  -- association [0..*]
LEFT OUTER JOIN I_TaxJurisdictionText AS _TaxJurisdictionText ON TaxCalculationProcedure = _TaxJurisdictionText.TaxJurisdictionCalcProcedure AND TaxJurisdiction = _TaxJurisdictionText.TaxJurisdiction  -- association [0..*]
;