I_CashJournalBalance

DDL: I_CASHJOURNALBALANCE SQL: ICASHJNLBAL Type: view BASIC Package: FINS_FIS_FICO
8 Fields 1 Data Sources

View for table TCJ_BALANCE

I_CashJournalBalance is a Basic CDS View that provides data about "View for table TCJ_BALANCE" in SAP S/4HANA. It reads from 1 data source (tcj_balance) and exposes 8 fields with key fields CompanyCode, CashJournal, CashJournalBalanceType, CashJournalBalanceCrtnDteTme. Part of development package FINS_FIS_FICO.

Data Sources (1)

SourceAliasJoin Type
tcj_balance tcj_balance from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICASHJNLBAL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label View for table TCJ_BALANCE view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode comp_code Procuring Comp. Cde
KEY CashJournal cajo_number Cash Journal Number
KEY CashJournalBalanceType rec_type Totals rec.type
KEY CashJournalBalanceCrtnDteTme time_stamp Time Stamp
TransactionCurrency currency Valuation Crcy
CashJournalBalanceInTransCrcy closing_sum Transactn curr.
CreatedByUser accountant User Name
IsArchived sarch Arch. CJ Totals Rec.

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_CashJournalBalance.
-- 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: ICASHJNLBAL

CREATE VIEW I_CashJournalBalance AS
SELECT
  comp_code AS CompanyCode,
  cajo_number AS CashJournal,
  rec_type AS CashJournalBalanceType,
  time_stamp AS CashJournalBalanceCrtnDteTme,
  currency AS TransactionCurrency,
  closing_sum AS CashJournalBalanceInTransCrcy,
  accountant AS CreatedByUser,
  sarch AS IsArchived
FROM tcj_balance
;

Learn More