P_MatlGrpPurgCat

DDL: P_MATLGRPPURGCAT SQL: PMATLGRPPURGCAT Type: view CONSUMPTION
6 Fields 2 Data Sources

Material Group and Purchasing Category

P_MatlGrpPurgCat is a Consumption CDS View that provides data about "Material Group and Purchasing Category" in SAP S/4HANA. It reads from 2 data sources (I_PurchaseContractItem, I_PurchasingCategoryMatlGroup) and exposes 6 fields with key fields PurchaseContract, PurchaseContractItem.

Data Sources (2)

SourceAliasJoin Type
I_PurchaseContractItem I_PurchaseContractItem from
I_PurchasingCategoryMatlGroup I_PurchasingCategoryMatlGroup left_outer

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMATLGRPPURGCAT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Material Group and Purchasing Category view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurchaseContractItem PurchaseContract Purchasing Doc.
KEY PurchaseContractItem I_PurchaseContractItem PurchaseContractItem Item
MaterialGroup I_PurchaseContractItem MaterialGroup Product Group
PurchasingCategory I_PurchaseContractItem PurchasingCategory Purchasing Category
PurgCatName I_PurchaseContractItem PurgCatName Purchasing Cat. Name
PurgCatUUID PurgCatUUID

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_MatlGrpPurgCat.
-- 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: PMATLGRPPURGCAT

CREATE VIEW P_MatlGrpPurgCat AS
SELECT
  I_PurchaseContractItem.PurchaseContract AS PurchaseContract,
  I_PurchaseContractItem.PurchaseContractItem AS PurchaseContractItem,
  I_PurchaseContractItem.MaterialGroup AS MaterialGroup,
  I_PurchaseContractItem.PurchasingCategory AS PurchasingCategory,
  I_PurchaseContractItem.PurgCatName AS PurgCatName,
  PurgCatUUID
FROM I_PurchaseContractItem
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup ON /* join condition not captured in parsed metadata */
;

Learn More