P_GR_DocJournalGLItem

DDL: P_GR_DOCJOURNALGLITEM Type: view_entity CONSUMPTION
13 Fields 2 Data Sources

P_GR_DocJournalGLItem is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_GR_DocJournalGLBasic, I_FiscCalendarDateForCompCode) and exposes 13 fields with key fields CompanyCode, CADocumentNumber, PostingDate, FiscalYear, FiscalPeriod.

Data Sources (2)

SourceAliasJoin Type
P_GR_DocJournalGLBasic P_GR_DocJournalGLBasic from
I_FiscCalendarDateForCompCode yr inner

Parameters (3)

NameTypeDefault
P_ToPostingDate fis_budat_to
P_GR_JournalFromDate fis_gr_docjrnl_budat_frm
P_CompanyCode fis_bukrs

Annotations (7)

NameValueLevelField
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode _gl_item CompanyCode Receiver Company Code
KEY CADocumentNumber _gl_item CADocumentNumber Document Number
KEY PostingDate _gl_item PostingDate Posting Date for GR
KEY FiscalYear I_FiscCalendarDateForCompCode FiscalYear G/L Fiscal Year
KEY FiscalPeriod I_FiscCalendarDateForCompCode FiscalPeriod Tax period
KEY FiscalYearVariant I_FiscCalendarDateForCompCode FiscalYearVariant FY Variant
KEY GLAccount _gl_item GLAccount General Ledger
KEY CompanyCodeCurrency _gl_item CompanyCodeCurrency Local Currency
KEY TransactionCurrency _gl_item TransactionCurrency Transaction Currency
AmountInCompanyCodeCurrency _gl_item AmountInCompanyCodeCurrency Local Crcy Amt
CAAmountInTransactionCurrency _gl_item CAAmountInTransactionCurrency Amount
_DocHeader _gl_item _DocHeader
_CompCode _gl_item _CompCode

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_DocJournalGLItem.
-- 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_ToPostingDate : fis_budat_to, P_GR_JournalFromDate : fis_gr_docjrnl_budat_frm, P_CompanyCode : fis_bukrs

CREATE VIEW P_GR_DocJournalGLItem AS
SELECT
  _gl_item.CompanyCode AS CompanyCode,
  _gl_item.CADocumentNumber AS CADocumentNumber,
  _gl_item.PostingDate AS PostingDate,
  yr.FiscalYear AS FiscalYear,
  yr.FiscalPeriod AS FiscalPeriod,
  yr.FiscalYearVariant AS FiscalYearVariant,
  _gl_item.GLAccount AS GLAccount,
  _gl_item.CompanyCodeCurrency AS CompanyCodeCurrency,
  _gl_item.TransactionCurrency AS TransactionCurrency,
  _gl_item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _gl_item.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  _gl_item._DocHeader AS _DocHeader,
  _gl_item._CompCode AS _CompCode
FROM P_GR_DocJournalGLBasic
INNER JOIN I_FiscCalendarDateForCompCode AS yr ON /* join condition not captured in parsed metadata */
;

Learn More