P_WhereUsdPrftCtrMstrMaterial

DDL: P_WHEREUSDPRFTCTRMSTRMATERIAL SQL: PWUPCMM Type: view CONSUMPTION Package: ODATA_WHERE_USED_PROFIT_CENTER
9 Fields 2 Data Sources

Where-Used Profit Centers - Master Material

P_WhereUsdPrftCtrMstrMaterial is a Consumption CDS View that provides data about "Where-Used Profit Centers - Master Material" in SAP S/4HANA. It reads from 2 data sources (I_ProductPlantBasic, I_ProfitCenter) and exposes 9 fields with key fields Product, Plant, ControllingArea, ProfitCenter, ValidityEndDate. Part of development package ODATA_WHERE_USED_PROFIT_CENTER.

Data Sources (2)

SourceAliasJoin Type
I_ProductPlantBasic _ProductPlantBasic inner
I_ProfitCenter I_ProfitCenter from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PWUPCMM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Product I_ProductPlantBasic Product Product Sold
KEY Plant I_ProductPlantBasic Plant Valuation Area
KEY ControllingArea I_ProfitCenter ControllingArea Controlling Area
KEY ProfitCenter I_ProfitCenter ProfitCenter Profit Center
KEY ValidityEndDate I_ProfitCenter ValidityEndDate ValidTo
ProductType
ProfitCenterName
ValidityStartDate I_ProfitCenter ValidityStartDate Validity Start Date
_Product I_ProductPlantBasic _Product

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_WhereUsdPrftCtrMstrMaterial.
-- 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: PWUPCMM

CREATE VIEW P_WhereUsdPrftCtrMstrMaterial AS
SELECT
  _ProductPlantBasic.Product AS Product,
  _ProductPlantBasic.Plant AS Plant,
  I_ProfitCenter.ControllingArea AS ControllingArea,
  I_ProfitCenter.ProfitCenter AS ProfitCenter,
  I_ProfitCenter.ValidityEndDate AS ValidityEndDate,
  _ProductPlantBasic._Product.ProductType AS ProductType,
  I_ProfitCenter._Text[ 1: Language = $session.system_language ].ProfitCenterName AS ProfitCenterName,
  I_ProfitCenter.ValidityStartDate AS ValidityStartDate,
  _ProductPlantBasic._Product AS _Product
FROM I_ProfitCenter
INNER JOIN I_ProductPlantBasic AS _ProductPlantBasic ON /* join condition not captured in parsed metadata */
;

Learn More