R_RecrrgSuplrInvcTmplTP

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 R_RecrrgSuplrInvcTmplTP.
-- 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: IRECRRGINVCTMPLR

CREATE VIEW R_RecrrgSuplrInvcTmplTP AS
SELECT
  _Tmpl.recrrgsuplrinvctmpluuid AS RecrrgSuplrInvcTmplUUID,
  $session.system_language AS Language,
  _Tmpl.recrrgsupplierinvoicetemplate AS RecrrgSupplierInvoiceTemplate,
  _Tmpl.fiscalyear AS FiscalYear,
  _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.grossamtintc AS GrossAmtInTC,
  _Tmpl.totalamountinlocalcurrency AS TotalAmountInLocalCurrency,
  _Tmpl.transactioncurrency AS TransactionCurrency,
  _Tmpl.localcurrency AS LocalCurrency,
  _Tmpl.documentcurrency AS DocumentCurrency,
  _Tmpl.transactiondate AS TransactionDate,
  _Tmpl.assignmentreference AS AssignmentReference,
  _Tmpl.supplierbanktype AS SupplierBankType,
  case when supplierbanktype is initial then '' else _Tmpl.iban end as IBAN AS ibanendasIBAN,
  case when supplierbanktype is initial then '' else _Tmpl.swiftcode end as SWIFTCode AS swiftcodeendasSWIFTCode,
  case when supplierbanktype is initial then '' else _BPBankAlias.PaymentSystem end as PaymentSystem AS PaymentSystemendasPaymentSystem,
  case when supplierbanktype is initial then '' else _BPBankAlias.AliasType end as AliasType AS AliasTypeendasAliasType,
  _Tmpl.businessarea AS BusinessArea,
  _Tmpl.companycodecountry AS CompanyCodeCountry,
  _Tmpl.activecountry AS ActiveCountry,
  _Tmpl.suppliervatregistration AS SupplierVATRegistration,
  _Tmpl.iseutriangulardeal AS IsEUTriangularDeal,
  _Tmpl.documentitemtext AS DocumentItemText,
  _Tmpl.createdbyuser AS CreatedByUser,
  _Tmpl.username AS UserName,
  _Tmpl.creationdate AS CreationDate,
  _Tmpl.recrrgsuplrinvcissrvcinvoice AS RecrrgSuplrInvcIsSrvcInvoice,
  _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.manualcashdiscount AS ManualCashDiscount,
  _Tmpl.invoicereference AS InvoiceReference,
  _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.taxjurisdictionbyprovider AS TaxJurisdictionByProvider,
  _Tmpl.taxcountry AS TaxCountry,
  _Tmpl.withholdingtaxisenabled AS WithholdingTaxIsEnabled,
  _Tmpl.glaccount AS GLAccount,
  _Tmpl.settlmtcocodetaxcountry AS SettlmtCoCodeTaxCountry,
  _Tmpl.startdate AS StartDate,
  _Tmpl.firstoccurrencedate AS FirstOccurrenceDate,
  _Tmpl.nextoccurrencedate AS NextOccurrenceDate,
  _Tmpl.estdcostcostgrunrcrrcdate AS EstdCostCostgRunRcrrcDate,
  _Tmpl.nextoccurrenceamountintc AS NextOccurrenceAmountInTC,
  _Tmpl.recurrencetype AS RecurrenceType,
  _Tmpl.recurrencepattern AS RecurrencePattern,
  _Tmpl.recurrencefrequency AS RecurrenceFrequency,
  _Tmpl.restartfrequencyweek AS REStartFrequencyWeek,
  _Tmpl.refrequencystart AS REFrequencyStart,
  _Tmpl.recurrenceinterval AS EHSTaskRecurrenceInterval,
  _Tmpl.occurrencetype AS OccurrenceType,
  _Tmpl.occurrencedaybyrecurrencetype AS OccurrenceDayByRecurrenceType,
  _Tmpl.calendarday AS CalendarDay,
  _Tmpl.weekday AS WeekDay,
  _Tmpl.recurrenceendtype AS RecurrenceEndType,
  _Tmpl.numberofoccurrences AS NumberOfOccurrences,
  _Tmpl.numberofpostedinvoices AS NumberOfPostedInvoices,
  _Tmpl.numberofnotpostedinvoices AS NumberOfNotPostedInvoices,
  _Tmpl.lastoccurrencedate AS LastOccurrenceDate,
  _Tmpl.foreigncrcyamtcnvrsnrule AS ForeignCrcyAmtCnvrsnRule,
  _Tmpl.recrrgsuplrinvctemplatestatus AS RecrrgSuplrInvcTemplateStatus,
  _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.lastchangedatetime AS LastChangeDateTime
FROM fap_rsiv_tmplr AS _Tmpl
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON InvoicingParty = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON PaymentTerms = _PaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountDocType ON AccountingDocumentType = _AccountDocType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_RecurrencePattern AS _RecurrenceTypeText ON RecurrenceType = _RecurrenceTypeText.RecurrenceType  -- association [0..1]
LEFT OUTER JOIN I_RecurrencePatternEndType AS _RecurrenceEndTypeText ON RecurrenceEndType = _RecurrenceEndTypeText.RecurrenceEndType  -- association [0..1]
LEFT OUTER JOIN I_CalendarDay AS _MonthDayText ON CalendarDay = _MonthDayText.CalendarDay  -- association [0..1]
LEFT OUTER JOIN I_RecurringSupplierInvoiceItem AS _PostStatus ON RecrrgSuplrInvcTmplUUID = _PostStatus.RecrrgSuplrInvcTmplUUID  -- association [0..1]
LEFT OUTER JOIN I_ForeignCrcyAmtCnvrsnRule AS _ForeignCrcyAmtCnvrsnRuleText ON ForeignCrcyAmtCnvrsnRule = _ForeignCrcyAmtCnvrsnRuleText.ForeignCrcyAmtCnvrsnRule  -- association [0..1]
LEFT OUTER JOIN I_SupplierBankDetailsVH AS _BPBankAlias ON SupplierBankType = _BPBankAlias.BPBankAccountInternalID AND InvoicingParty = _BPBankAlias.Supplier  -- association [0..1]
LEFT OUTER JOIN R_RecrrgSuplrInvcTmplItemTP AS _RecrrgSuplrInvcTmplItem ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_RecrrgSuplrInvcTmplInstceTP AS _RecrrgSuplrInvcTmplInstce ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_RecrrgSuplrInvcTmplWhgdTaxTP AS _RecrrgSuplrInvcTmplWhgdTax ON /* condition not available in parsed metadata */  -- association [0..*]
;