ICA_BSEG_ENTRY_VIEW_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_BSEG_ENTRY_VIEW_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_BSEG_ENTRY_VIEW_3SL AS
SELECT
  $session.client AS RCLNT,
  bseg.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,
  bseg.CompanyCode AS rbukrs,
  bseg.AccountingDocument AS ref_belnr,
  bseg.FiscalYear AS gjahr,
  cast(concat('000', bseg.AccountingDocumentItem) as abap.char( 6 )) AS ref_docln,
  finsc_fisc_date.fiscal_year AS ryear,
  finsc_fisc_date.fiscal_period AS poper,
  finsc_fisc_date.fiscal_year_period AS fiscyearper,
  finsc_fisc_date.fiscal_year_variant AS periv,
  bseg.IsOpenItemManaged AS xopvw,
  bseg.ClearingDate AS augdt,
  bseg.ClearingJournalEntry AS augbl,
  bseg.ClearingJournalEntryFiscalYear AS auggj,
  bseg.PostingKey AS bschl,
  bseg.FinancialAccountType AS koart,
  bseg.SpecialGLCode AS umskz,
  bseg.TransactionCurrency AS rwcur,
  case when bseg.DebitCreditCode = 'H' then -bseg.AmountInTransactionCurrency else bseg.AmountInTransactionCurrency end as wsl AS AmountInTransactionCurrencyendaswsl,
  bseg.CompanyCodeCurrency AS rhcur,
  case when bseg.DebitCreditCode = 'H' then -bseg.AmountInCompanyCodeCurrency else bseg.AmountInCompanyCodeCurrency end as hsl AS AmountInCompanyCodeCurrencyendashsl,
  bseg.FunctionalCurrency AS rfccur,
  case when bseg.DebitCreditCode = 'H' then -bseg.AmountInFunctionalCurrency else bseg.AmountInFunctionalCurrency end as fcsl AS AmountInFunctionalCurrencyendasfcsl,
  bseg.AssignmentReference AS zuonr,
  bseg.DocumentItemText AS sgtxt,
  bseg.Company AS rcomp,
  bseg.PartnerCompany AS rassc,
  bseg.GLAccount AS racct,
  bseg.OperationalGLAccount AS lracct,
  bseg.Customer AS kunnr,
  bseg.Supplier AS lifnr,
  bseg.ReferenceDocumentType AS awtyp,
  bseg.OriginalReferenceDocument AS awkey,
  bseg.ReferenceDocumentLogicalSystem AS awsys,
  bseg.PostingDate AS budat,
  bseg.DocumentDate AS bldat,
  bseg.AccountingDocumentType AS blart,
  bseg.DocumentReferenceID AS xblnr,
  bseg.AccountingDocumentHeaderText AS bktxt,
  bseg.Reference1InDocumentHeader AS xref1_hd,
  bseg.Reference2InDocumentHeader AS xref2_hd,
  bseg.AccountingDocCreatedByUser AS usnam,
  bseg.Timestamp AS timestamp,
  bseg.LastManualChangeDate AS aedat,
  bseg.IntercompanyTransaction AS bvorg,
  bseg.IsReversal AS xreversing,
  bseg.IsReversed AS xreversed,
  bseg.AccountingDocumentCategory AS bstat
FROM ICA_MatchingOplAcctgDocItem AS bseg
INNER JOIN ICA_FiscalCalendarDate AS finsc_fisc_date ON /* join condition not captured in parsed metadata */
;