P_PSMMatDocJournalEntry

DDL: P_PSMMATDOCJOURNALENTRY SQL: PPSMMATDOCJE Type: view BASIC
16 Fields 1 Data Sources

P_PSMMatDocJournalEntry is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (acdoca) and exposes 16 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

Data Sources (1)

SourceAliasJoin Type
acdoca _Journal_item from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PPSMMATDOCJE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger acdoca rldnr Ledger (Compat.)
KEY CompanyCode acdoca rbukrs Company Code
KEY FiscalYear acdoca gjahr Settlement Year
KEY AccountingDocument acdoca belnr SD Document
KEY LedgerGLLineItem acdoca docln Matching Document Line Item
ReferenceDocumentType acdoca awtyp Reference Document Type
ReferenceDocument acdoca awref Reference Doc.
ReferenceDocumentItem acdoca awitem Ref. Doc. Line Item
ReferenceDocumentUnits acdoca aworg Refer. Org.Unit
FinancialManagementArea acdoca fikrs FM Area
Fund acdoca rfund Fund
GrantID acdoca rgrant_nbr Grant
BudgetPeriod acdoca rbudget_pd Rec BudPer
FunctionalArea acdoca rfarea R FuncArea
FundsCenter acdoca fistl Funds Center
FundedProgram acdoca measure obsolete

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_PSMMatDocJournalEntry.
-- 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: PPSMMATDOCJE

CREATE VIEW P_PSMMatDocJournalEntry AS
SELECT
  _Journal_item.rldnr AS SourceLedger,
  _Journal_item.rbukrs AS CompanyCode,
  _Journal_item.gjahr AS FiscalYear,
  _Journal_item.belnr AS AccountingDocument,
  _Journal_item.docln AS LedgerGLLineItem,
  _Journal_item.awtyp AS ReferenceDocumentType,
  _Journal_item.awref AS ReferenceDocument,
  _Journal_item.awitem AS ReferenceDocumentItem,
  _Journal_item.aworg AS ReferenceDocumentUnits,
  _Journal_item.fikrs AS FinancialManagementArea,
  _Journal_item.rfund AS Fund,
  _Journal_item.rgrant_nbr AS GrantID,
  _Journal_item.rbudget_pd AS BudgetPeriod,
  _Journal_item.rfarea AS FunctionalArea,
  _Journal_item.fistl AS FundsCenter,
  _Journal_item.measure AS FundedProgram
FROM acdoca AS _Journal_item
;

Learn More