R_RecrrgSuplrInvcTmplItemTP

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_RecrrgSuplrInvcTmplItemTP.
-- 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: IRECRRGINVCITEMR

CREATE VIEW R_RecrrgSuplrInvcTmplItemTP AS
SELECT
  _GlLine.recrrgsuplrinvctmplitemuuid AS RecrrgSuplrInvcTmplItemUUID,
  _GlLine.recrrgsuplrinvctmpluuid AS RecrrgSuplrInvcTmplUUID,
  _GlLine.recrrgsuplrinvoicetemplateitem AS RecrrgSuplrInvoiceTemplateItem,
  _GlLine.glaccount AS GLAccount,
  _GlLine.amountintransactioncurrency AS AmountInTransactionCurrency,
  _GlLine.actualamountintransactioncrcy AS ActualAmountInTransactionCrcy,
  _GlLine.debitcreditcode AS DebitCreditCode,
  _GlLine.isnegativeposting AS IsNegativePosting,
  _GlLine.companycode AS CompanyCode,
  _GlLine.taxcode AS TaxCode,
  _GlLine.taxcountry AS TaxCountry,
  _GlLine.taxjurisdiction AS TaxJurisdiction,
  _GlLine.documentitemtext AS DocumentItemText,
  _GlLine.costcenter AS CostCenter,
  _GlLine.salesorder AS SalesOrder,
  _GlLine.salesorderitem AS SalesOrderItem,
  _GlLine.internalorder AS InternalOrder,
  _GlLine.settlementreferencedate AS SettlementReferenceDate,
  _GlLine.fundscenter AS FundsCenter,
  _GlLine.functionalarea AS FunctionalArea,
  _GlLine.profitcenter AS ProfitCenter,
  _GlLine.fund AS Fund,
  _GlLine.businessarea AS BusinessArea,
  _GlLine.partnerbusinessarea AS PartnerBusinessArea,
  _GlLine.costobject AS CostObject,
  _GlLine.projectnetwork AS ProjectNetwork,
  _GlLine.networkactivity AS NetworkActivity,
  _GlLine.wbselement AS WBSElement,
  _GlLine.receiveractivitytype AS ReceiverActivityType,
  _GlLine.realestateobject AS RealEstateObject,
  _GlLine.personnelnumber AS PersonnelNumber,
  _GlLine.businessprocess AS BusinessProcess,
  _GlLine.assetgrant AS AssetGrant,
  _GlLine.commitmentitem AS CommitmentItem,
  _GlLine.quantityinbaseunit AS QuantityInBaseUnit,
  _GlLine.baseunit AS BaseUnit,
  _GlLine.assignmentreference AS AssignmentReference,
  _GlLine.isnotcashdiscountliable AS IsNotCashDiscountLiable,
  _GlLine.taxbaseamountintranscrcy AS TaxBaseAmountInTransCrcy,
  _GlLine.taxamountintranscrcy AS TaxAmountInTransCrcy,
  _GlLine.profitabilitysegment AS ProfitabilitySegment,
  _GlLine.plant AS Plant,
  _GlLine.budgetperiod AS BudgetPeriod,
  _GlLine.controllingarea AS ControllingArea,
  _GlLine.jointventurecostrecoverycode AS JointVentureCostRecoveryCode,
  _GlLine.workitem AS WorkItem,
  _Tmpl.TransactionCurrency AS TransactionCurrency
FROM fap_rsiv_glliner AS _GlLine
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCodeText ON DebitCreditCode = _DebitCreditCodeText.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _GLAccountText ON CompanyCode = _GLAccountText.CompanyCode AND GLAccount = _GLAccountText.GLAccount AND _GLAccountText.Language = $session.system_language  -- association [0..1]
;