I_JournalEntry

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_JournalEntry.
-- 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_JournalEntry AS
SELECT
  bukrs AS CompanyCode,
  gjahr AS FiscalYear,
  belnr AS AccountingDocument,
  blart AS AccountingDocumentType,
  bldat AS DocumentDate,
  budat AS PostingDate,
  cast( monat as fins_fiscalperiod ) AS FiscalPeriod,
  cpudt AS AccountingDocumentCreationDate,
  cputm AS CreationTime,
  cast ( aedat as fis_lastmanualchangedate preserving type ) AS LastManualChangeDate,
  cast ( upddt as fis_lastautomaticchangedate preserving type ) AS LastAutomaticChangeDate,
  wwert AS ExchangeRateDate,
  usnam AS AccountingDocCreatedByUser,
  tcode AS TransactionCode,
  bvorg AS IntercompanyTransaction,
  xblnr AS DocumentReferenceID,
  dbblg AS RecurringAccountingDocument,
  stblg AS ReverseDocument,
  stjah AS ReverseDocumentFiscalYear,
  bktxt AS AccountingDocumentHeaderText,
  waers AS TransactionCurrency,
  cast(abs(kursf) as fis_absolute_exchangerate preserving type) AS AbsoluteExchangeRate,
  kursf AS ExchangeRate,
  bstat AS AccountingDocumentCategory,
  xnetb AS NetAmountIsPosted,
  xrueb AS JrnlEntryIsPostedToPrevPeriod,
  glvor AS BusinessTransactionType,
  grpid AS BatchInputSession,
  awtyp AS ReferenceDocumentType,
  awkey AS OriginalReferenceDocument,
  fikrs AS FinancialManagementArea,
  hwaer AS CompanyCodeCurrency,
  hwae2 AS AdditionalCurrency1,
  hwae3 AS AdditionalCurrency2,
  xstov AS ReversalIsPlanned,
  stodt AS PlannedReversalDate,
  xmwst AS TaxIsCalculatedAutomatically,
  curt2 AS AdditionalCurrency1Role,
  curt3 AS AdditionalCurrency2Role,
  xsnet AS TaxBaseAmountIsNetAmount,
  ausbk AS SourceCompanyCode,
  awsys AS LogicalSystem,
  cast(awsys as fis_awsys preserving type) AS ReferenceDocumentLogicalSystem,
  cast(abs(txkrs) as fis_absolute_txkrs_bkpf preserving type) AS TaxAbsoluteExchangeRate,
  txkrs AS TaxExchangeRate,
  cast(abs(ctxkrs) as ctrycrcytxabsoluteexchangerate preserving type) AS CtryCrcyTxAbsoluteExchangeRate,
  stgrd AS ReversalReason,
  cast(ppnam as fis_ppnam preserving type ) AS ParkedByUser,
  ppdat AS ParkingDate,
  pptme AS ParkingTime,
  brnch AS Branch,
  numpg AS NmbrOfPages,
  adisc AS IsDiscountDocument,
  xref1_hd AS Reference1InDocumentHeader,
  xref2_hd AS Reference2InDocumentHeader,
  reindat AS InvoiceReceiptDate,
  rldnr AS Ledger,
  ldgrp AS LedgerGroup,
  cast(xblnr_alt as fis_xblnr_alt_alpha preserving type ) AS AlternativeReferenceDocument,
  vatdate AS TaxReportingDate,
  fulfilldate AS TaxFulfillmentDate,
  doccat AS AccountingDocumentClass,
  kurst AS ExchangeRateType,
  cast(abs(kursx) as marketdataabsoluteexchangerate preserving type) AS MarketDataAbsoluteExchangeRate,
  logsystem_sender AS SenderLogicalSystem,
  bukrs_sender AS SenderCompanyCode,
  belnr_sender AS SenderAccountingDocument,
  gjahr_sender AS SenderFiscalYear,
  aworg_rev AS ReversalReferenceDocumentCntxt,
  awref_rev AS ReversalReferenceDocument,
  penrc AS LatePaymentReason,
  knumv AS SalesDocumentCondition,
  xreversing AS IsReversal,
  xreversed AS IsReversed,
  glbtgrp AS GLBusinessTransactionGroup,
  co_valdt AS CostAccountingValuationDate,
  TAX_COUNTRY_HD AS TaxCountry,
  last_change_datetime AS JournalEntryLastChangeDateTime,
  P_BKPF_COM.XSECONDARY AS JournalEntryIsSecondaryEntry,
  P_BKPF_COM.reprocessing_status_code AS JournalEntryReprocessingStatus,
  glo_ref1_hd AS JrnlEntryCntrySpecificRef1,
  glo_dat1_hd AS JrnlEntryCntrySpecificDate1,
  glo_ref2_hd AS JrnlEntryCntrySpecificRef2,
  glo_dat2_hd AS JrnlEntryCntrySpecificDate2,
  glo_ref3_hd AS JrnlEntryCntrySpecificRef3,
  glo_dat3_hd AS JrnlEntryCntrySpecificDate3,
  glo_ref4_hd AS JrnlEntryCntrySpecificRef4,
  glo_dat4_hd AS JrnlEntryCntrySpecificDate4,
  glo_ref5_hd AS JrnlEntryCntrySpecificRef5,
  glo_dat5_hd AS JrnlEntryCntrySpecificDate5,
  glo_bp1_hd AS JrnlEntryCntrySpecificBP1,
  glo_bp2_hd AS JrnlEntryCntrySpecificBP2,
  whtdate AS WithholdingTaxReportingDate,
  P_BKPF_COM.ev_postng_ctrl AS EntryViewPostingControl
FROM P_BKPF_COM
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_BusTransactionTypeText AS _BusinessTransactionTypeText ON BusinessTransactionType = _BusinessTransactionTypeText.BusinessTransactionType  -- association [0..*]
LEFT OUTER JOIN I_FinancialManagementAreaText AS _FinancialManagementAreaText ON FinancialManagementArea = _FinancialManagementAreaText.FinancialManagementArea  -- association [0..*]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency1 ON AdditionalCurrency1 = _AdditionalCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency2 ON AdditionalCurrency2 = _AdditionalCurrency2.Currency  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForCmpnyCode AS _FiscalPeriod ON FiscalYear = _FiscalPeriod.FiscalYear AND FiscalPeriod = _FiscalPeriod.FiscalPeriod AND CompanyCode = _FiscalPeriod.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentCategory AS _AccountingDocumentCategory ON AccountingDocumentCategory = _AccountingDocumentCategory.AccountingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_BusinessTransactionType AS _BusinessTransactionType ON BusinessTransactionType = _BusinessTransactionType.BusinessTransactionType  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON LogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _RefDocumentLogicalSystem ON ReferenceDocumentLogicalSystem = _RefDocumentLogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON AccountingDocCreatedByUser = _User.UserID  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_LedgerGroup AS _LedgerGroup ON LedgerGroup = _LedgerGroup.LedgerGroup  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _AdditionalCurrency1Role ON AdditionalCurrency1Role = _AdditionalCurrency1Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _AdditionalCurrency2Role ON AdditionalCurrency2Role = _AdditionalCurrency2Role.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_JournalEntryItem AS _JournalEntryItem ON CompanyCode = _JournalEntryItem.CompanyCode AND FiscalYear = _JournalEntryItem.FiscalYear AND AccountingDocument = _JournalEntryItem.AccountingDocument  -- association [1..*]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON CompanyCode = _OperationalAcctgDocItem.CompanyCode AND FiscalYear = _OperationalAcctgDocItem.FiscalYear AND AccountingDocument = _OperationalAcctgDocItem.AccountingDocument  -- association [0..*]
LEFT OUTER JOIN I_AddlLedgerOplAcctgDocItem AS _AddlLedgerOplAcctgDocItem ON CompanyCode = _AddlLedgerOplAcctgDocItem.CompanyCode AND FiscalYear = _AddlLedgerOplAcctgDocItem.FiscalYear AND AccountingDocument = _AddlLedgerOplAcctgDocItem.AccountingDocument  -- association [0..*]
;