I_RecrrgSuplrInvcTmplItem

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_RecrrgSuplrInvcTmplItem.
-- 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 I_RecrrgSuplrInvcTmplItem AS
SELECT
  cast( _GlLine.recrrgsuplrinvctmplitemuuid as fap_rsiv_tmpl_item_guid preserving type ) AS RecrrgSuplrInvcTmplItemUUID,
  _GlLine.recrrgsuplrinvctmpluuid AS RecrrgSuplrInvcTmplUUID,
  _GlLine.recrrgsuplrinvoicetemplateitem AS RecrrgSuplrInvoiceTemplateItem,
  _GlLine.glaccount AS GLAccount,
  _GlLine.amountintransactioncurrency AS AmountInTransactionCurrency,
  _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 SalesDocument,
  _GlLine.salesorderitem AS SalesDocumentItem,
  _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.costobject AS CostObject,
  _GlLine.projectnetwork AS ProjectNetwork,
  cast( _GlLine.networkactivity as ps_s4_vornr preserving type ) AS NetworkActivity,
  _GlLine.wbselement AS WBSElement,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  _GlLine.receiveractivitytype AS CostCtrActivityType,
  _GlLine.personnelnumber AS PersonnelNumber,
  cast( _GlLine.realestateobject as recaimkeyfi preserving type ) AS REInternalFinNumber,
  _GlLine.businessprocess AS BusinessProcess,
  _GlLine.assetgrant AS GrantID,
  _GlLine.commitmentitem AS CommitmentItem,
  _GlLine.quantityinbaseunit AS Quantity,
  _GlLine.baseunit AS BaseUnit,
  _GlLine.assignmentreference AS AssignmentReference,
  _GlLine.isnotcashdiscountliable AS IsNotCashDiscountLiable,
  _GlLine.taxbaseamountintranscrcy AS TaxBaseAmountInTransCrcy,
  _GlLine.profitabilitysegment AS ProfitabilitySegment,
  _GlLine.plant AS Plant,
  _GlLine.budgetperiod AS BudgetPeriod,
  _GlLine.controllingarea AS ControllingArea,
  _GlLine.jointventurecostrecoverycode AS JointVentureCostRecoveryCode,
  _GlLine.workitem AS WorkItem
FROM fap_rsiv_glliner AS _GlLine
LEFT OUTER JOIN I_RecrrgSuplrInvcTmpl AS _Tmpl ON RecrrgSuplrInvcTmplUUID = _Tmpl.RecrrgSuplrInvcTmplUUID  -- association [1..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElement = _WBSElement.WBSElement  -- association [0..1]
;