ICA_GENJOURNALENTRIES_C2_3SL

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 ICA_GENJOURNALENTRIES_C2_3SL.
-- 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 ICA_GENJOURNALENTRIES_C2_3SL AS
SELECT
  $session.client AS rclnt,
  acdoca.MatchingMethodID AS method_id,
  cast ('0000000000' as ica_docnr) AS DOCNR,
  cast (0 as ica_docln) AS DOCLN,
  cast ('000000000000' as ica_grref) AS GRREF,
  cast ('00' as ica_pstat) AS PSTAT,
  cast ('' as ica_cstat) AS CSTAT,
  cast ('00000000' as ica_due_date) AS DUE_DATE,
  1 Open AS 1Open,
  2 Parked AS 2Parked,
  acdoca.ClearingDate AS augdt,
  acdoca.ClearingJournalEntry AS augbl,
  acdoca.ClearingJournalEntryFiscalYear AS auggj,
  acdoca.SourceLedger AS rldnr,
  acdoca.CompanyCode AS rbukrs,
  acdoca.Company AS rcomp,
  acdoca.AccountingDocumentType AS blart,
  acdoca.AccountingDocument AS ref_belnr,
  acdoca.LedgerGLLineItem AS ref_docln,
  acdoca.JrnlEntrAltvFYConsecutiveID AS docnr_ld,
  acdoca.GLRecordType AS rrcty,
  acdoca.IsReversal AS xreversing,
  acdoca.IsReversed AS xreversed,
  acdoca.IsTrueReversed AS xtruerev,
  acdoca.ReversalReferenceDocumentCntxt AS aworg_rev,
  acdoca.ReversalReferenceDocument AS awref_rev,
  acdoca.ReferenceDocumentContext AS aworg,
  acdoca.ReferenceDocument AS awref,
  finsc_fisc_date.fiscal_year_variant AS periv,
  acdoca.FiscalYear AS gjahr,
  finsc_fisc_date.fiscal_period AS poper,
  finsc_fisc_date.fiscal_year_period AS fiscyearper,
  finsc_fisc_date.fiscal_year AS ryear,
  acdoca.PostingDate AS budat,
  acdoca.DocumentDate AS bldat,
  acdoca.ChartOfAccounts AS ktopl,
  acdoca.GLAccount AS racct,
  acdoca.CostCenter AS rcntr,
  acdoca.ProfitCenter AS prctr,
  acdoca.Segment AS segment,
  acdoca.PartnerCostCenter AS scntr,
  acdoca.PartnerProfitCenter AS pprctr,
  acdoca.PartnerCompany AS rassc,
  acdoca.PartnerSegment AS psegment,
  acdoca.TransactionCurrency AS rwcur,
  acdoca.CompanyCodeCurrency AS rhcur,
  acdoca.GlobalCurrency AS rkcur,
  acdoca.BaseUnit AS runit,
  acdoca.AmountInTransactionCurrency AS wsl,
  acdoca.AmountInCompanyCodeCurrency AS hsl,
  acdoca.AmountInGlobalCurrency AS ksl,
  acdoca.Quantity AS msl,
  acdoca.DebitCreditCode AS drcrk,
  acdoca.PostingKey AS bschl,
  acdoca.FinancialTransactionType AS rmvct,
  acdoca.BusinessTransactionCategory AS bttype,
  acdoca.AssignmentReference AS zuonr,
  acdoca.AccountingDocumentCategory AS bstat,
  acdoca.JournalEntryItemCategory AS linetype,
  acdoca.TransactionTypeDetermination AS ktosl,
  acdoca.SubLedgerAcctLineItemType AS slalittype,
  acdoca.AccountingDocCreatedByUser AS usnam,
  acdoca.CreationDateTime AS timestamp,
  acdoca.EliminationProfitCenter AS eprctr,
  acdoca.InvoiceReference AS rebzg,
  acdoca.InvoiceReferenceFiscalYear AS rebzj,
  acdoca.InvoiceItemReference AS rebzz,
  acdoca.ReferencePurchaseOrderCategory AS rbest,
  acdoca.PurchasingDocument AS ebeln,
  acdoca.PurchasingDocumentItem AS ebelp,
  acdoca.DocumentItemText AS sgtxt,
  acdoca.SalesDocument AS kdauf,
  acdoca.SalesDocumentItem AS kdpos,
  acdoca.Product AS matnr,
  acdoca.Plant AS werks,
  acdoca.Supplier AS lifnr,
  acdoca.Customer AS kunnr,
  acdoca.FinancialAccountType AS koart,
  acdoca.SpecialGLCode AS umskz,
  acdoca.TaxCode AS mwskz,
  acdoca.IsOpenItemManaged AS xopvw,
  acdoca.AssetDepreciationArea AS afabe,
  acdoca.MasterFixedAsset AS anln1,
  acdoca.FixedAsset AS anln2,
  acdoca.AssetTransactionType AS anbwa,
  acdoca.AssetClass AS anlkl,
  acdoca.PartnerMasterFixedAsset AS panl1,
  acdoca.PartnerFixedAsset AS panl2,
  acdoca.BillingDocumentType AS fkart,
  acdoca.SalesOrganization AS vkorg,
  acdoca.DistributionChannel AS vtweg,
  acdoca.OrganizationDivision AS spart,
  acdoca.SoldProduct AS matnr_copa,
  acdoca.SoldProductGroup AS matkl,
  acdoca.CustomerGroup AS kdgrp,
  acdoca.CustomerSupplierCountry AS land1,
  acdoca.CustomerSupplierIndustry AS brsch,
  acdoca.SalesDistrict AS bzirk,
  acdoca.BillToParty AS kunre,
  acdoca.ShipToParty AS kunwe,
  acdoca.CustomerSupplierCorporateGroup AS konzs,
  acdoca.OffsettingAccount AS gkont,
  acdoca.OffsettingAccountType AS gkoar,
  acdoca.FunctionalCurrency AS rfccur,
  acdoca.AmountInFunctionalCurrency AS fcsl,
  acdoca.BalanceTransactionCurrency AS rtcur
FROM ICA_MatchingJournalEntryItem AS acdoca
INNER JOIN ICA_FiscalCalendarDate AS finsc_fisc_date ON /* join condition not captured in parsed metadata */
INNER JOIN ICA_FiscalYearVariant AS t009 ON /* join condition not captured in parsed metadata */
;