I_CashJournalDocument

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_CashJournalDocument.
-- 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: ICASHJNLDOC

CREATE VIEW I_CashJournalDocument AS
SELECT
  comp_code AS CompanyCode,
  cajo_number AS CashJournal,
  fisc_year AS FiscalYear,
  posting_number AS CashJournalDocumentInternalID,
  _CashJournal.Language AS Language,
  Currency,
  document_date AS DocumentDate,
  h_tax_amount AS TaxAmountInTransCrcy,
  h_net_amount AS CashJournalDocumentNetAmount,
  h_net_payment_wt AS WhldgTaxDeductedNetPaymentAmt,
  h_receipts AS CashJournalReceiptAmount,
  h_payments AS CashJournalPaymentAmount,
  ( h_net_amount + h_tax_amount ) AS AmountInTransactionCurrency,
  bp_name AS ReceiptRecipientName,
  d_posting_numb AS CashJournalDocument,
  document_number AS AccountingDocExternalReference,
  posting_date AS PostingDate,
  document_status AS CashJournalDocumentStatus,
  accountant AS CreatedByUser,
  print_ind AS CashJournalIsPrinted,
  tax_percent AS TaxRate,
  text1 AS CashJournalDocumentText1,
  text2 AS CashJournalDocumentText2,
  check_number AS Cheque,
  check_issuer AS CashJournalChequeIssuer,
  bank_key AS BankKey,
  bank_acct AS BankAccount,
  bank_ctry AS BankCountry,
  check_stack AS CashJournalChequeLot,
  check_status AS CashJournalChequePostingSts,
  revbelnr AS CashJournalReversalDocument,
  exch_rate AS ExchangeRate,
  bupla AS BusinessPlace,
  secco AS BusinessSectionCode,
  split AS CashJournalDocumentIsSplit,
  lzbkz AS StateCentralBankPaymentReason,
  landl AS SupplyingCountry,
  check_fy AS ChequeLotFiscalYear,
  valuta_date AS ValueDate,
  vatdate AS TaxReportingDate
FROM tcj_documents
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CashJournal AS _CashJournal ON CompanyCode = _CashJournal.CompanyCode AND CashJournal = _CashJournal.CashJournal AND Language = _CashJournal.Language  -- 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_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
;