P_PurchasingGroupAnalysis1

DDL: P_PURCHASINGGROUPANALYSIS1 SQL: PMMPURGRPAN1 Type: view CONSUMPTION
20 Fields 3 Data Sources

Purchasing Group Analysis 1

P_PurchasingGroupAnalysis1 is a Consumption CDS View that provides data about "Purchasing Group Analysis 1" in SAP S/4HANA. It reads from 3 data sources (I_CalendarDate, I_PurchasingDocument, I_PurchasingDocumentItem) and exposes 20 fields with key fields PurchasingDocument, PurchasingDocumentItem.

Data Sources (3)

SourceAliasJoin Type
I_CalendarDate CalendarDate inner
I_PurchasingDocument PurchaseDoc inner
I_PurchasingDocumentItem PurchaseItem from

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate bedat
P_EndDate bedat

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMMPURGRPAN1 view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Purchasing Group Analysis 1 view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurchasingDocumentItem PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem I_PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
PurchasingDocumentItemNo
PurchasingOrganization I_PurchasingDocument PurchasingOrganization Purchasing Organization
PurchasingGroup I_PurchasingDocument PurchasingGroup Purchasing Group
CompanyCode I_PurchasingDocument CompanyCode Receiver Company Code
Plant I_PurchasingDocumentItem Plant Valuation Area
Supplier I_PurchasingDocument Supplier Supplier
Material I_PurchasingDocumentItem Material Vehicle Model
MaterialGroup I_PurchasingDocumentItem MaterialGroup Product Group
PurchasingDocumentCategory I_PurchasingDocument PurchasingDocumentCategory Doc. Category
DocumentCurrency I_PurchasingDocumentItem DocumentCurrency Document Currency
PurchasingDocumentStatus I_PurchasingDocument PurchasingDocumentOrigin Status
DisplayCurrency
CalendarYear I_CalendarDate CalendarYear Year
CalendarMonth I_CalendarDate CalendarMonth Calendar Month
CalendarQuarter I_CalendarDate CalendarQuarter Calendar Quarter
CalendarWeek I_CalendarDate CalendarWeek Calendar Week
IsReturnsItem IsReturnsItem Returns Item
_Supplier _Supplier

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_PurchasingGroupAnalysis1.
-- 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: PMMPURGRPAN1
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : bedat, P_EndDate : bedat

CREATE VIEW P_PurchasingGroupAnalysis1 AS
SELECT
  PurchaseItem.PurchasingDocument AS PurchasingDocument,
  PurchaseItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  concat( PurchaseItem.PurchasingDocument , PurchaseItem.PurchasingDocumentItem ) AS PurchasingDocumentItemNo,
  PurchaseDoc.PurchasingOrganization AS PurchasingOrganization,
  PurchaseDoc.PurchasingGroup AS PurchasingGroup,
  PurchaseDoc.CompanyCode AS CompanyCode,
  PurchaseItem.Plant AS Plant,
  PurchaseDoc.Supplier AS Supplier,
  PurchaseItem.Material AS Material,
  PurchaseItem.MaterialGroup AS MaterialGroup,
  PurchaseDoc.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  PurchaseItem.DocumentCurrency AS DocumentCurrency,
  PurchaseDoc.PurchasingDocumentOrigin AS PurchasingDocumentStatus,
  :P_DisplayCurrency AS DisplayCurrency,
  CalendarDate.CalendarYear AS CalendarYear,
  CalendarDate.CalendarMonth AS CalendarMonth,
  CalendarDate.CalendarQuarter AS CalendarQuarter,
  CalendarDate.CalendarWeek AS CalendarWeek,
  IsReturnsItem
FROM I_PurchasingDocumentItem AS PurchaseItem
INNER JOIN I_PurchasingDocument AS PurchaseDoc ON /* join condition not captured in parsed metadata */
INNER JOIN I_CalendarDate AS CalendarDate ON /* join condition not captured in parsed metadata */
;

Learn More