P_GR_DocJournalBPItem

DDL: P_GR_DOCJOURNALBPITEM Type: view_entity CONSUMPTION
31 Fields 4 Data Sources

P_GR_DocJournalBPItem is a Consumption CDS View in SAP S/4HANA. It reads from 4 data sources (I_CADocumentBPItem, I_CADocumentBPItem, I_FiscCalendarDateForCompCode, I_FiscCalendarDateForCompCode) and exposes 31 fields with key fields CompanyCode, CAApplicationArea, ChartOfAccounts, FiscalYear, PostingDate.

Data Sources (4)

SourceAliasJoin Type
I_CADocumentBPItem _bp_item from
I_CADocumentBPItem _bp_item union_all
I_FiscCalendarDateForCompCode yr inner
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 (6)

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

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CADocumentBPItem CompanyCode Receiver Company Code
KEY CAApplicationArea I_CADocumentBPItem CAApplicationArea ApplicationArea
KEY ChartOfAccounts I_CADocumentBPItem ChartOfAccounts Node Class
KEY FiscalYear I_FiscCalendarDateForCompCode FiscalYear G/L Fiscal Year
KEY PostingDate I_CADocumentBPItem CAPostingDate Clrg Post. Date
KEY FiscalPeriod I_FiscCalendarDateForCompCode FiscalPeriod Tax period
KEY FiscalYearVariant I_FiscCalendarDateForCompCode FiscalYearVariant FY Variant
KEY CADocumentType I_CADocumentBPItem CADocumentType Document Type
KEY DocumentDate I_CADocumentBPItem DocumentDate Journal Entry Date
KEY CompanyCodeCurrency I_CADocumentBPItem CompanyCodeCurrency Local Currency
KEY TransactionCurrency I_CADocumentBPItem TransactionCurrency Transaction Currency
KEY BusinessPartnerendasBusinessPartner
KEY CAMainTransactionendasCAMainTransaction
KEY CASubTransactionendasCASubTransaction
KEY CAClearingDocumentNumber I_CADocumentBPItem CAClearingDocumentNumber Clearing Doc.
CompanyCodeasCompanyCode
KEY CADocumentNumber
KEY CAApplicationArea I_CADocumentBPItem CAApplicationArea ApplicationArea
KEY ChartOfAccounts I_CADocumentBPItem ChartOfAccounts Node Class
KEY FiscalYear I_FiscCalendarDateForCompCode FiscalYear G/L Fiscal Year
KEY PostingDate I_CADocumentBPItem CAPostingDateOfClearingDoc Clrg Post. Date
KEY FiscalPeriod I_FiscCalendarDateForCompCode FiscalPeriod Tax period
KEY FiscalYearVariant I_FiscCalendarDateForCompCode FiscalYearVariant FY Variant
KEY CADocumentType I_CADocumentBPItem CADocumentType Document Type
KEY DocumentDate I_CADocumentBPItem DocumentDate Journal Entry Date
KEY CompanyCodeCurrency I_CADocumentBPItem CompanyCodeCurrency Local Currency
KEY TransactionCurrency I_CADocumentBPItem TransactionCurrency Transaction Currency
KEY BusinessPartnerendasBusinessPartner
KEY CAMainTransactionendasCAMainTransaction
KEY CASubTransactionendasCASubTransaction
KEY CAClearingDocumentNumber I_CADocumentBPItem CAClearingDocumentNumber Clearing Doc.

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_DocJournalBPItem.
-- 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_DocJournalBPItem AS
SELECT
  _bp_item.CompanyCode AS CompanyCode,
  _bp_item.CAApplicationArea AS CAApplicationArea,
  _bp_item.ChartOfAccounts AS ChartOfAccounts,
  yr.FiscalYear AS FiscalYear,
  _bp_item.CAPostingDate AS PostingDate,
  yr.FiscalPeriod AS FiscalPeriod,
  yr.FiscalYearVariant AS FiscalYearVariant,
  _bp_item.CADocumentType AS CADocumentType,
  _bp_item.DocumentDate AS DocumentDate,
  _bp_item.CompanyCodeCurrency AS CompanyCodeCurrency,
  _bp_item.TransactionCurrency AS TransactionCurrency,
  case when _bp_item.CAIsDownPaymentRequest = 'X' and _bp_item.CAStatisticalItemCode = 'A' then '' else _bp_item.BusinessPartner end as BusinessPartner AS BusinessPartnerendasBusinessPartner,
  case when _bp_item.CAIsDownPaymentRequest = 'X' and _bp_item.CAStatisticalItemCode = 'A' then '' else _bp_item.CAMainTransaction end as CAMainTransaction AS CAMainTransactionendasCAMainTransaction,
  case when _bp_item.CAIsDownPaymentRequest = 'X' and _bp_item.CAStatisticalItemCode = 'A' then '' else _bp_item.CASubTransaction end as CASubTransaction AS CASubTransactionendasCASubTransaction,
  _bp_item.CAClearingDocumentNumber AS CAClearingDocumentNumber,
  cast( case when _bp_item.CAIsDownPaymentRequest = 'X' and _bp_item.CAStatisticalItemCode = 'A' then _bp_item.CATaxAmountInTransCurrency * -1 else _bp_item.CAAmountInTransactionCurrency end as betrw_kk ) as CAAmountInTransactionCurrency AS CompanyCodeasCompanyCode,
  cast( _bp_item.CAClearingDocumentNumber as opbel_kk ) AS CADocumentNumber
FROM I_CADocumentBPItem AS _bp_item
INNER JOIN I_FiscCalendarDateForCompCode AS yr ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_CADocumentBPItem
;

Learn More