P_NonMngdPurchasingSpend1

DDL: P_NONMNGDPURCHASINGSPEND1 SQL: PMMNONMNGDPURSP1 Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
8 Fields 2 Data Sources

Non Managed Spend

P_NonMngdPurchasingSpend1 is a Consumption CDS View that provides data about "Non Managed Spend" in SAP S/4HANA. It reads from 2 data sources (I_JournalEntry, I_OperationalAcctgDocItem) and exposes 8 fields with key fields AccountingDocument, FiscalYear, CompanyCode, Creditor. Part of development package ODATA_MM_ANALYTICS.

Data Sources (2)

SourceAliasJoin Type
I_JournalEntry JournalEntry inner
I_OperationalAcctgDocItem Supplier from

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate mm_a_delivery_date
P_EndDate mm_a_delivery_date

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PMMNONMNGDPURSP1 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Non Managed Spend view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode Receiver Company Code
KEY Creditor I_OperationalAcctgDocItem Supplier Supplier
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency Local Currency
PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
AccountingDocumentType I_JournalEntry AccountingDocumentType Journal Entry Type
AmountInCompanyCodeCurrency

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_NonMngdPurchasingSpend1.
-- 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: PMMNONMNGDPURSP1
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : mm_a_delivery_date, P_EndDate : mm_a_delivery_date

CREATE VIEW P_NonMngdPurchasingSpend1 AS
SELECT
  Supplier.AccountingDocument AS AccountingDocument,
  Supplier.FiscalYear AS FiscalYear,
  Supplier.CompanyCode AS CompanyCode,
  Supplier.Supplier AS Creditor,
  Supplier.CompanyCodeCurrency AS CompanyCodeCurrency,
  Supplier.PostingDate AS PostingDate,
  JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  sum( Supplier.AmountInCompanyCodeCurrency ) AS AmountInCompanyCodeCurrency
FROM I_OperationalAcctgDocItem AS Supplier
INNER JOIN I_JournalEntry AS JournalEntry ON /* join condition not captured in parsed metadata */
;

Learn More