P_CASHJOURNALPOSITION

DDL: P_CASHJOURNALPOSITION SQL: PCASHJNLPOS Type: view BASIC
20 Fields 1 Data Sources

P_CASHJOURNALPOSITION is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (tcj_positions) and exposes 20 fields with key fields CompanyCode, CashJournal, FiscalYear, CashJournalDocumentInternalID, CashJournalDocumentItem.

Data Sources (1)

SourceAliasJoin Type
tcj_positions tcj_positions from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCASHJNLPOS view
VDM.viewType #BASIC view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (20)

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
Currency currency Valuation Crcy
CashJournalItemType position_type Item Category
CashJournalTransaction Trans.number
TaxAmountInTransCrcy p_tax_amount Tax Amount
TaxRate tax_percent Tax Rate Code
CostCenter kostl Substitute CC
ProfitCenter prctr Profit Centers
BusinessArea gsber Business Area
CashJournalDocumentTransType transact_type Trans type
TaxCode tax_code Tax Code
GLAccount gl_account G/L Acct
CashJournalDocumentItemText position_text Text for item
Supplier vendor_no Supplier
CustomerNum customer Sold-to Party
PersonnelNumber pernr Personnel no.

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_CASHJOURNALPOSITION.
-- 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: PCASHJNLPOS

CREATE VIEW P_CASHJOURNALPOSITION AS
SELECT
  comp_code AS CompanyCode,
  cajo_number AS CashJournal,
  fisc_year AS FiscalYear,
  posting_number AS CashJournalDocumentInternalID,
  position_number AS CashJournalDocumentItem,
  Currency,
  position_type AS CashJournalItemType,
  cast(transact_number as abap.char(4)) AS CashJournalTransaction,
  p_tax_amount AS TaxAmountInTransCrcy,
  tax_percent AS TaxRate,
  kostl AS CostCenter,
  prctr AS ProfitCenter,
  gsber AS BusinessArea,
  transact_type AS CashJournalDocumentTransType,
  tax_code AS TaxCode,
  gl_account AS GLAccount,
  position_text AS CashJournalDocumentItemText,
  vendor_no AS Supplier,
  customer AS CustomerNum,
  pernr AS PersonnelNumber
FROM tcj_positions
;

Learn More