C_RecrrgSuplrInvcTmpl

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_RecrrgSuplrInvcTmpl.
-- 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_RecrrgSuplrInvcTmpl AS
SELECT
  _Tmpl.RecrrgSuplrInvcTmplUUID AS RecrrgSuplrInvcTmplUUID,
  _Tmpl.RecrrgSupplierInvoiceTemplate AS RecrrgSupplierInvoiceTemplate,
  _Tmpl.AccountingDocumentType AS AccountingDocumentType,
  _Tmpl.CompanyCode AS CompanyCode,
  _Tmpl.DocumentReferenceID AS DocumentReferenceID,
  _Tmpl.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  _Tmpl.TotalAmountInTransactionCrcy AS TotalAmountInTransactionCrcy,
  _Tmpl.InvoicingParty AS InvoicingParty,
  _Tmpl.ExchangeRate AS ExchangeRate,
  _Tmpl.TotalAmountInLocalCurrency AS TotalAmountInLocalCurrency,
  _Tmpl.TransactionCurrency AS TransactionCurrency,
  _Tmpl.LocalCurrency AS LocalCurrency,
  _Tmpl.AssignmentReference AS AssignmentReference,
  _Tmpl.SupplierBankType AS SupplierBankType,
  _Tmpl.IBAN AS IBAN,
  _Tmpl.SWIFTCode AS SWIFTCode,
  case when _Tmpl.SupplierBankType is initial then '' else _BPBankAlias._BusinessPartnerBankAlias.PaymentSystem end as PaymentSystem AS PaymentSystemendasPaymentSystem,
  case when _Tmpl.SupplierBankType is initial then '' else _BPBankAlias._BusinessPartnerBankAlias.AliasType end as AliasType AS AliasTypeendasAliasType,
  _Tmpl.ReportingCountry AS ReportingCountry,
  _Tmpl.CompanyCodeCountry AS CompanyCodeCountry,
  _Tmpl.SupplierVATRegistration AS SupplierVATRegistration,
  _Tmpl.IsEUTriangularDeal AS IsEUTriangularDeal,
  _Tmpl.DocumentItemText AS DocumentItemText,
  _Tmpl.CreatedByUser AS CreatedByUser,
  _Tmpl.CreatedByUserName AS CreatedByUserName,
  _Tmpl.CreationDate AS CreationDate,
  _Tmpl.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  _Tmpl.SupplyingCountry AS SupplyingCountry,
  _Tmpl.PaymentTerms AS PaymentTerms,
  _Tmpl.PaymentMethod AS PaymentMethod,
  _Tmpl.PaymentReference AS PaymentReference,
  _Tmpl.CashDiscount1Days AS CashDiscount1Days,
  _Tmpl.CashDiscount1Percent AS CashDiscount1Percent,
  _Tmpl.CashDiscount2Days AS CashDiscount2Days,
  _Tmpl.CashDiscount2Percent AS CashDiscount2Percent,
  _Tmpl.NetPaymentDays AS NetPaymentDays,
  _Tmpl.HouseBank AS HouseBank,
  _Tmpl.HouseBankAccount AS HouseBankAccount,
  _Tmpl.ManualCashDiscountAmount AS ManualCashDiscountAmount,
  _Tmpl.PaymentMethodSupplement AS PaymentMethodSupplement,
  _Tmpl.SuplrInvcPaymentBlockingReason AS SuplrInvcPaymentBlockingReason,
  _Tmpl.PaytSlipWthRefCheckDigit AS PaytSlipWthRefCheckDigit,
  _Tmpl.PaytSlipWthRefReference AS PaytSlipWthRefReference,
  _Tmpl.PaytSlipWthRefSubscriber AS PaytSlipWthRefSubscriber,
  _Tmpl.TaxCode AS TaxCode,
  _Tmpl.FixedCashDiscount AS FixedCashDiscount,
  _Tmpl.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  _Tmpl.TaxDeterminationDate AS TaxDeterminationDate,
  _Tmpl.TaxJurisdiction AS TaxJurisdiction,
  _Tmpl.TaxCountry AS TaxCountry,
  _Tmpl.WithholdingTaxIsEnabled AS WithholdingTaxIsEnabled,
  _Tmpl.GLAccount AS GLAccount,
  _Tmpl.SettlmtCoCodeTaxCountry AS SettlmtCoCodeTaxCountry,
  _Tmpl.RecurrenceStartDate AS RecurrenceStartDate,
  _Tmpl.FirstOccurrenceDate AS FirstOccurrenceDate,
  _Tmpl.NextOccurrenceDate AS NextOccurrenceDate,
  _Tmpl.NextOccurrenceAmountInTC AS NextOccurrenceAmountInTC,
  _Tmpl.RecurrencePattern AS RecurrencePattern,
  cast( _RecurrencePatternText._Text[ Language = $session.system_language ].RecurrenceTypeName as fap_rsiv_recurr_pattern preserving type ) AS RecurrencePatternName,
  _Tmpl.RecurrenceIntervalInDays AS RecurrenceIntervalInDays,
  _Tmpl.RecurrenceIntervalInWeeks AS RecurrenceIntervalInWeeks,
  _Tmpl.RecurrenceIntervalInMonths AS RecurrenceIntervalInMonths,
  _Tmpl.RecurrenceDayOfMonth AS RecurrenceDayOfMonth,
  _Tmpl.RecurrenceDayOfWeek AS RecurrenceDayOfWeek,
  _Tmpl.RecurrenceEndType AS RecurrenceEndType,
  cast( _RecurrenceEndTypeText._Text[ Language = $session.system_language ].RecurrenceEndTypeName as fap_rsiv_recurr_end_type preserving type ) AS RecurrenceEndTypeName,
  _Tmpl.NumberOfOccurrences AS NumberOfOccurrences,
  _Tmpl.NumberOfPostedInvoices AS NumberOfPostedInvoices,
  _Tmpl.NumberOfNotPostedInvoices AS NumberOfNotPostedInvoices,
  _Tmpl.LastOccurrenceDate AS LastOccurrenceDate,
  _Tmpl.ForeignCrcyAmtCnvrsnRule AS ForeignCrcyAmtCnvrsnRule,
  _Tmpl.BusinessPlace AS BusinessPlace,
  _Tmpl.BusinessSectionCode AS BusinessSectionCode,
  _Tmpl.IN_GSTPartner AS IN_GSTPartner,
  _Tmpl.IN_GSTPlaceOfSupply AS IN_GSTPlaceOfSupply,
  _Tmpl.IN_InvoiceReferenceNumber AS IN_InvoiceReferenceNumber,
  _Tmpl.QuickResponseIBAN AS QuickResponseIBAN,
  _Tmpl.OneTimeAcctCntrySpecificRef1 AS OneTimeAcctCntrySpecificRef1,
  _Tmpl.ReferenceAccountForIBAN AS ReferenceAccountForIBAN
FROM I_RecrrgSuplrInvcTmpl AS _Tmpl
LEFT OUTER JOIN C_RecrrgSuplrInvcTmplItem AS _RecrrgSuplrInvcTmplItem ON RecrrgSuplrInvcTmplUUID = _RecrrgSuplrInvcTmplItem.RecrrgSuplrInvcTmplUUID  -- association [0..*]
LEFT OUTER JOIN C_RecrrgSuplrInvcTmplInstce AS _RecrrgSuplrInvcTmplInstce ON RecrrgSuplrInvcTmplUUID = _RecrrgSuplrInvcTmplInstce.RecrrgSuplrInvcTmplUUID  -- association [0..*]
LEFT OUTER JOIN C_RecrrgSuplrInvcTmplWhgdTax AS _RecrrgSuplrInvcTmplWhgdTax ON RecrrgSuplrInvcTmplUUID = _RecrrgSuplrInvcTmplWhgdTax.RecrrgSuplrInvcTmplUUID  -- association [0..*]
LEFT OUTER JOIN I_RecurrencePattern AS _RecurrencePatternText ON RecurrencePattern = _RecurrencePatternText.RecurrenceType  -- association [0..1]
LEFT OUTER JOIN I_RecurrencePatternEndType AS _RecurrenceEndTypeText ON RecurrenceEndType = _RecurrenceEndTypeText.RecurrenceEndType  -- association [0..1]
LEFT OUTER JOIN I_SupplierBankDetails AS _BPBankAlias ON SupplierBankType = _BPBankAlias.BPBankAccountInternalID AND ReferenceAccountForIBAN = _BPBankAlias.Supplier  -- association [0..1]
;