I_CashJournalOneTimeAccount

DDL: I_CASHJOURNALONETIMEACCOUNT SQL: ICASHJNLOTACCT Type: view BASIC
9 Fields 1 Data Sources

View for table TCJ_CPD

I_CashJournalOneTimeAccount is a Basic CDS View that provides data about "View for table TCJ_CPD" in SAP S/4HANA. It reads from 1 data source (tcj_cpd) and exposes 9 fields with key fields CompanyCode, CashJournal, FiscalYear, CashJournalDocumentInternalID, CashJournalDocumentItem.

Data Sources (1)

SourceAliasJoin Type
tcj_cpd tcj_cpd from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICASHJNLOTACCT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label View for table TCJ_CPD 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 (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode comp_code Procuring Comp. Cde
KEY CashJournal cajo_number Cash Journal Number
KEY FiscalYear fisc_year Year
KEY CashJournalDocumentInternalID posting_number Internal doc. number
KEY CashJournalDocumentItem position_number Item
BusinessPartnerName1 name1 PA text
BusinessPartnerName2 name2 Name2/First nme
BusinessPartnerName3 name3 Name 3
BusinessPartnerName4 name4 Name 4

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_CashJournalOneTimeAccount.
-- 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: ICASHJNLOTACCT

CREATE VIEW I_CashJournalOneTimeAccount AS
SELECT
  comp_code AS CompanyCode,
  cajo_number AS CashJournal,
  fisc_year AS FiscalYear,
  posting_number AS CashJournalDocumentInternalID,
  position_number AS CashJournalDocumentItem,
  name1 AS BusinessPartnerName1,
  name2 AS BusinessPartnerName2,
  name3 AS BusinessPartnerName3,
  name4 AS BusinessPartnerName4
FROM tcj_cpd
;

Learn More