P_GR_CADocumentJournal

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 P_GR_CADocumentJournal.
-- 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.
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_GR_JournalFromDate : fis_gr_docjrnl_budat_frm, P_CompanyCode : fis_bukrs

CREATE VIEW P_GR_CADocumentJournal AS
SELECT
  CompanyCode,
  CADocumentNumber,
  FiscalYear,
  PostingDate,
  FiscalPeriod,
  CADocumentType,
  DocumentDate,
  BusinessPartner,
  GLAccount,
  CompanyCodeCurrency,
  TransactionCurrency,
  CAReferenceDocument,
  CAMainTransaction,
  CASubTransaction,
  CASubTransactionName,
  ChartOfAccounts,
  _DocTypeTxt.CADocumentTypeName AS CADocumentTypeName,
  _AlternateGLAcctInCompany.AlternativeGLAccount AS AlternativeGLAccount,
  cast(case when BusinessPartnerName is not initial then BusinessPartnerName else _GLAcctCOAText.GLAccountLongName end as txt50 ) as LongText AS GLAccountLongNameendastxt50asLongText,
  CarryFwdBalAmtInCCCrcy,
  cast( 0 as glo_dr_cfwd_bal_hsl ) AS DebitCarryFwdBalAmtInCCCrcy,
  cast( 0 as glo_cr_cfwd_bal_hsl ) AS CreditCarryFwdBalAmtInCCCrcy,
  cast( AmountInCompanyCodeCurrency as fis_end_bal_hsl ) AS EndingBalanceAmtInCoCodeCrcy,
  CarryFwdBalanceAmtInTransCrcy,
  cast( '0' as glo_dr_cfwd_bal_wsl ) AS DebitCarryFwdBalAmtInTransCrcy,
  cast( '0' as glo_cr_cfwd_bal_wsl ) AS CrdtCarryFwdBalAmtInTransCrcy,
  cast( 0 as fis_start_bal_wsl_ui ) AS StartingBalanceAmtInTransCrcy,
  cast( 0 as glo_dr_strt_bal_wsl ) AS DebitStartingBalAmtInTransCrcy,
  cast( 0 as glo_cr_strt_bal_wsl ) AS CrdtStartingBalAmtInTransCrcy,
  cast( CAAmountInTransactionCurrency as fis_end_bal_hsl ) AS EndingBalanceAmtInTransCrcy
FROM P_GR_CADocJournalItem
;