I_FinSGLJrnlEntrItm

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_FinSGLJrnlEntrItm.
-- 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_FinSGLJrnlEntrItm AS
SELECT
  cast(rldnr as fins_ledger_pers preserving type) AS Ledger,
  cast(rbukrs as fis_bukrs preserving type) AS CompanyCode,
  cast(gjahr as fis_gjahr_no_conv preserving type) AS FiscalYear,
  belnr AS AccountingDocument,
  docln AS LedgerGLLineItem,
  cast(ryear as fis_ryear_no_conv preserving type) AS LedgerFiscalYear,
  docnr_ld AS JrnlEntrAltvFYConsecutiveID,
  rrcty AS GLRecordType,
  cast(racct as fis_racct preserving type) AS GLAccount,
  cast(rbusa as gsber preserving type) AS BusinessArea,
  cast(sbusa as pargb preserving type) AS PartnerBusinessArea,
  bldat AS DocumentDate,
  bstat AS AccountingDocumentCategory,
  cast(rcntr as fis_kostl preserving type) AS CostCenter,
  cast(prctr as fis_prctr preserving type) AS ProfitCenter,
  cast(rfarea as fm_farea preserving type) AS FunctionalArea,
  cast(segment as fb_segment preserving type) AS Segment,
  cast(scntr as fis_skost preserving type) AS PartnerCostCenter,
  cast(pprctr as fis_pprctr preserving type) AS PartnerProfitCenter,
  cast(sfarea as fis_sfkber preserving type) AS PartnerFunctionalArea,
  cast(rassc as fis_rassc preserving type) AS PartnerCompany,
  cast(psegment as fb_psegment preserving type) AS PartnerSegment,
  drcrk AS DebitCreditCode,
  poper AS FiscalPeriod,
  cast(periv as fis_periv preserving type) AS FiscalYearVariant,
  cast(fiscyearper as fis_jahrper_conv preserving type) AS FiscalYearPeriod,
  budat AS PostingDate,
  cast(blart as fis_blart preserving type) AS AccountingDocumentType,
  buzei AS AccountingDocumentItem,
  zuonr AS AssignmentReference,
  cast(linetype as fis_linetype preserving type) AS JournalEntryItemCategory,
  cast(bschl as bschl preserving type) AS PostingKey,
  timestamp AS CreationDateTime,
  glaccount_type AS GLAccountType,
  sgtxt AS DocumentItemText,
  cast(ktopl as fis_ktopl preserving type) AS ChartOfAccounts,
  cast(ktop2 as fis_ktop2 preserving type) AS CountryChartOfAccounts,
  cast(rbunit as fis_md_bunit preserving type) AS ConsolidationUnit,
  cast(rbuptr as fis_md_buptr preserving type) AS PartnerConsolidationUnit,
  cast(rcomp as fis_rcomp preserving type) AS Company,
  cast(ritclg as fis_itclg preserving type) AS ConsolidationChartOfAccounts,
  cast(ritem as fis_fsi_item preserving type) AS CnsldtnFinancialStatementItem,
  cast(sityp as fis_fc_sityp preserving type) AS CnsldtnSubitemCategory,
  cast(subit as fis_fc_sitem preserving type) AS CnsldtnSubitem,
  cast(kokrs as fis_kokrs ) AS ControllingArea,
  cast(pbukrs as fis_pbukrs preserving type) AS PartnerCompanyCode,
  fs_product_group AS FinancialServicesProductGroup,
  branch_id AS FinancialServicesBranch,
  datasource_id AS FinancialDataSource,
  cast( kdgrp as fis_kdgrp ) AS CustomerGroup,
  cast( land1 as fis_land1_gp preserving type ) AS CustomerSupplierCountry,
  cast( brsch as fis_brsch preserving type ) AS CustomerSupplierIndustry,
  cast(rtcur as fins_currt preserving type) AS BalanceTransactionCurrency,
  tsl AS AmountInBalanceTransacCrcy,
  cast( rhcur as fis_hwaer preserving type ) AS CompanyCodeCurrency,
  hsl AS AmountInCompanyCodeCurrency,
  cast(rkcur as fis_rkcur preserving type) AS GlobalCurrency,
  ksl AS AmountInGlobalCurrency,
  cast( rfccur as fins_currfc ) AS FunctionalCurrency,
  fcsl AS AmountInFunctionalCurrency,
  cast(rocur as fis_rocur preserving type) AS FreeDefinedCurrency1,
  osl AS AmountInFreeDefinedCurrency1,
  cast(rvcur as fis_rvcur preserving type) AS FreeDefinedCurrency2,
  vsl AS AmountInFreeDefinedCurrency2
FROM acdoca
;