P_NonMngdPurchasingSpend

DDL: P_NONMNGDPURCHASINGSPEND SQL: PMMNONMNGDPURSP Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
24 Fields 1 Data Sources 3 Associations

Non Managed Purchasing Spend

P_NonMngdPurchasingSpend is a Consumption CDS View that provides data about "Non Managed Purchasing Spend" in SAP S/4HANA. It reads from 1 data source (P_NonMngdPurchasingSpend3) and exposes 24 fields with key fields AccountingDocument, FiscalYear, CompanyCode, Supplier, GLAccount. It has 3 associations to related views. Part of development package ODATA_MM_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
P_NonMngdPurchasingSpend3 P_NonMngdPurchasingSpend3 from

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate mm_a_delivery_date
P_EndDate mm_a_delivery_date

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_GLAccount _GLAccount $projection.GLAccount = _GLAccount.GLAccount and $projection.CompanyCode = _GLAccount.CompanyCode
[0..1] I_Material _Material $projection.Material = _Material.Material

Annotations (7)

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

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocument PostedAccountDocEn1 AccountingDocument Journal Entry
KEY FiscalYear PostedAccountDocEn1 FiscalYear G/L Fiscal Year
KEY CompanyCode PostedAccountDocEn1 CompanyCode Receiver Company Code
KEY Supplier PostedAccountDocEn1 Creditor Supplier
KEY GLAccount PostedAccountDocEn1 GLAccount General Ledger
AccountingDocumentType PostedAccountDocEn1 AccountingDocumentType Journal Entry Type
PostingDate PostedAccountDocEn1 PostingDate Posting Date for GR
Material PostedAccountDocEn1 Material Vehicle Model
ProfitCenter PostedAccountDocEn1 ProfitCenter Profit Center
CostCenter PostedAccountDocEn1 CostCenter Cost Center
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
ControllingArea PostedAccountDocEn1 ControllingArea Controlling Area
WBSElement PostedAccountDocEn1 WBSElement WBS Internal ID
WBSElementInternalID PostedAccountDocEn1 WBSElementInternalID WBS Internal ID
Fund PostedAccountDocEn1 Fund Sender Fund
Plant PostedAccountDocEn1 Plant Valuation Area
MaterialGroup _Material MaterialGroup Product Group
PurchaseOrder PostedAccountDocEn1 PurchaseOrder Purchasing Document
CompanyCodeCurrency PostedAccountDocEn1 CompanyCodeCurrency Local Currency
SupplierAmount SupplierAmount
DisplayCurrency
_CompanyCode _CompanyCode
_GLAccount _GLAccount
_Material _Material

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

CREATE VIEW P_NonMngdPurchasingSpend AS
SELECT
  PostedAccountDocEn1.AccountingDocument AS AccountingDocument,
  PostedAccountDocEn1.FiscalYear AS FiscalYear,
  PostedAccountDocEn1.CompanyCode AS CompanyCode,
  PostedAccountDocEn1.Creditor AS Supplier,
  PostedAccountDocEn1.GLAccount AS GLAccount,
  PostedAccountDocEn1.AccountingDocumentType AS AccountingDocumentType,
  PostedAccountDocEn1.PostingDate AS PostingDate,
  PostedAccountDocEn1.Material AS Material,
  PostedAccountDocEn1.ProfitCenter AS ProfitCenter,
  PostedAccountDocEn1.CostCenter AS CostCenter,
  AccountingDocCreatedByUser,
  PostedAccountDocEn1.ControllingArea AS ControllingArea,
  PostedAccountDocEn1.WBSElement AS WBSElement,
  PostedAccountDocEn1.WBSElementInternalID AS WBSElementInternalID,
  PostedAccountDocEn1.Fund AS Fund,
  PostedAccountDocEn1.Plant AS Plant,
  _Material.MaterialGroup AS MaterialGroup,
  PostedAccountDocEn1.PurchaseOrder AS PurchaseOrder,
  PostedAccountDocEn1.CompanyCodeCurrency AS CompanyCodeCurrency,
  SupplierAmount,
  $parameters.P_DisplayCurrency AS DisplayCurrency
FROM P_NonMngdPurchasingSpend3
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
;

Learn More