I_TempGLAccountLineItem

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_TempGLAccountLineItem.
-- 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: ITEMPGLACCTLIT

CREATE VIEW I_TempGLAccountLineItem AS
SELECT
  cast(acdoctemp.rldnr as fins_ledger preserving type) AS Ledger,
  cast(acdoctemp.rbukrs as fis_bukrs preserving type) AS CompanyCode,
  cast(acdoctemp.gjahr as fis_gjahr preserving type) AS FiscalYear,
  cast(acdoctemp.belnr as fis_belnr preserving type) AS AccountingDocument,
  cast(acdoctemp.docln as fis_docln preserving type) AS LedgerGLLineItem,
  closing_run_id AS JrnlPeriodEndClosingRunLogUUID,
  temp_appl AS TemporaryDataCreatingAppl,
  temp_id AS TemporaryJournalEntry,
  cast(racct as fis_racct preserving type) AS GLAccount,
  cast(gkont as fis_gkont preserving type) AS OffsettingAccount,
  valobjtype AS FinancialValuationObjectType,
  valobj_id AS FinancialValuationObject,
  valsobj_id AS FinancialValuationSubobject,
  cast(netdt as faedt_fpos preserving type) AS NetDueDate,
  slalittype AS SubLedgerAcctLineItemType,
  cast(ktopl as fis_ktopl preserving type) AS ChartOfAccounts,
  cast(budat as fis_budat preserving type) AS PostingDate,
  cast(bstat as fis_bstat preserving type) AS AccountingDocumentCategory,
  cast(xopvw as fis_xopvw preserving type) AS IsOpenItemManaged,
  cast(augdt as fis_augdt preserving type) AS ClearingDate,
  cast(augbl as fis_augbl preserving type) AS ClearingAccountingDocument,
  cast(auggj as fis_auggj preserving type ) AS ClearingDocFiscalYear,
  cast(poper as fins_fiscalperiod preserving type) AS FiscalPeriod,
  prec_awtyp AS PredecessorReferenceDocType,
  prec_aworg AS PredecessorReferenceDocCntxt,
  prec_awref AS PredecessorReferenceDocument,
  prec_awitem AS PredecessorReferenceDocItem,
  cast( prec_bukrs as fins_prec_bukrs_gfc preserving type ) AS PrdcssrJournalEntryCompanyCode,
  cast( prec_gjahr as fins_prec_gjahr_gfc preserving type ) AS PrdcssrJournalEntryFiscalYear,
  cast( prec_belnr as fins_prec_belnr_gfc preserving type ) AS PredecessorJournalEntry,
  cast( prec_docln as fins_prec_docln_gfc preserving type ) AS PredecessorJournalEntryItem,
  cast(rebzz as fis_rebzz preserving type) AS InvoiceItemReference,
  cast(rebzg as fis_rebzg preserving type) AS InvoiceReference,
  cast(rebzj as fis_rebzj preserving type) AS InvoiceReferenceFiscalYear,
  cast(rebzt as farp_rebzt preserving type) AS FollowOnDocumentType,
  cast(buzei as fis_buzei preserving type) AS AccountingDocumentItem,
  cast(rtcur as fis_rtcur preserving type) AS BalanceTransactionCurrency,
  cast(tsl as fis_tsl preserving type) AS AmountInBalanceTransacCrcy,
  cast(rwcur as fis_rwcur preserving type) AS TransactionCurrency,
  cast(wsl as fis_wsl preserving type) AS AmountInTransactionCurrency,
  cast(rhcur as fis_hwaer preserving type) AS CompanyCodeCurrency,
  cast(hsl as fis_hsl preserving type) AS AmountInCompanyCodeCurrency,
  cast(rkcur as fis_rkcur preserving type) AS GlobalCurrency,
  cast(ksl as fis_ksl preserving type) AS AmountInGlobalCurrency,
  cast(rocur as fis_rocur preserving type) AS FreeDefinedCurrency1,
  cast(osl as fis_osl preserving type) AS AmountInFreeDefinedCurrency1,
  cast(rvcur as fis_rvcur preserving type) AS FreeDefinedCurrency2,
  cast(vsl as fis_vsl preserving type) AS AmountInFreeDefinedCurrency2,
  rbcur AS FreeDefinedCurrency3,
  cast(bsl as fis_bsl preserving type) AS AmountInFreeDefinedCurrency3,
  rccur AS FreeDefinedCurrency4,
  cast(csl as fis_csl preserving type) AS AmountInFreeDefinedCurrency4,
  rdcur AS FreeDefinedCurrency5,
  cast(dsl as fis_dsl preserving type) AS AmountInFreeDefinedCurrency5,
  recur AS FreeDefinedCurrency6,
  cast(esl as fis_esl preserving type) AS AmountInFreeDefinedCurrency6,
  cast(rfcur as fis_rfcur preserving type) AS FreeDefinedCurrency7,
  cast(fsl as fis_fsl preserving type) AS AmountInFreeDefinedCurrency7,
  rgcur AS FreeDefinedCurrency8,
  cast(gsl as fis_gsl preserving type) AS AmountInFreeDefinedCurrency8,
  rmvct AS FinancialTransactionType,
  prctr AS ProfitCenter,
  cast(kdauf as vdm_sales_order preserving type) AS SalesOrder,
  cast(kdpos as sales_order_item preserving type) AS SalesOrderItem,
  cast(lifnr as md_supplier preserving type) AS Supplier,
  cast(kunnr as kunnr preserving type) AS Customer,
  cast(hbkid as farp_hbkid preserving type) AS HouseBank,
  cast(hktid as fac_hktid preserving type) AS HouseBankAccount,
  lstar AS CostCtrActivityType,
  cast(aufnr as fis_aufnr preserving type) AS OrderID,
  cast(ps_psp_pnr as ps_posnr preserving type) AS WBSElementInternalID,
  nplnr AS ProjectNetwork,
  nplnr_vorgn AS RelatedNetworkActivity,
  prznr AS BusinessProcess,
  rcntr AS CostCenter,
  rfarea AS FunctionalArea,
  rbusa AS BusinessArea,
  kokrs AS ControllingArea,
  Segment,
  scntr AS PartnerCostCenter,
  pprctr AS PartnerProfitCenter,
  sfarea AS PartnerFunctionalArea,
  sbusa AS PartnerBusinessArea,
  rassc AS PartnerCompany,
  kstrg AS CostObject,
  psegment AS PartnerSegment,
  vname AS JointVenture,
  egrup AS JointVentureEquityGroup,
  recid AS JointVentureCostRecoveryCode,
  vptnr AS JointVenturePartner,
  pvname AS PartnerVenture,
  swenr AS REBusinessEntity,
  sgenr AS RealEstateBuilding,
  sgrnr AS RealEstateProperty,
  cbttype AS BusinessTransactionType,
  koart AS FinancialAccountType,
  aging AS GeneralLedgerAgingScope,
  aging_incrmnt AS GeneralLedgerAgingIncrement
FROM acdoctemp
LEFT OUTER JOIN I_Currency AS _BalanceTransactionCurrency ON BalanceTransactionCurrency = _BalanceTransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency1 ON FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency2 ON FreeDefinedCurrency2 = _FreeDefinedCurrency2.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency3 ON FreeDefinedCurrency3 = _FreeDefinedCurrency3.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency4 ON FreeDefinedCurrency4 = _FreeDefinedCurrency4.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency5 ON FreeDefinedCurrency5 = _FreeDefinedCurrency5.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency6 ON FreeDefinedCurrency6 = _FreeDefinedCurrency6.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency7 ON FreeDefinedCurrency7 = _FreeDefinedCurrency7.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency8 ON FreeDefinedCurrency8 = _FreeDefinedCurrency8.Currency  -- association [0..1]
;