C_ProdByAreaOfRespyVH

DDL: C_PRODBYAREAOFRESPYVH SQL: CPRODBYAORVH Type: view CONSUMPTION Package: ODATA_PP_DD_STLM
10 Fields 1 Data Sources 1 OData Services

Product By Area of Responisbility Value Help

C_ProdByAreaOfRespyVH is a Consumption CDS View that provides data about "Product By Area of Responisbility Value Help" in SAP S/4HANA. It reads from 1 data source (I_MRPArea) and exposes 10 fields with key fields Material, Plant, MRPArea. It is exposed through 1 OData service (ASQL_F2832). Part of development package ODATA_PP_DD_STLM.

Data Sources (1)

SourceAliasJoin Type
I_MRPArea _MRPArea left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CPRODBYAORVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Product By Area of Responisbility Value Help view
ObjectModel.dataCategory #VALUE_HELP view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey Material view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F2832 ASQL_F2832 C2 NOT_RELEASED

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Material _MaterialVH Material Product
KEY Plant _MaterialVH Plant Valuation Area
KEY MRPArea _MaterialVH MRPArea MRP Area
MaterialName _MaterialVH MaterialName Product Description
MRPType _MaterialVH MRPType MRP Type
MaterialGroup _MaterialVH MaterialGroup Product Group
MaterialBaseUnit _MaterialVH MaterialBaseUnit Valuation Unit
ProductAuthorizationGroup ProductAuthorizationGroup
ProductTypeAuthorizationGroup ProductTypeAuthorizationGroup
ProductGroupAuthorizationGroup ProductGroupAuthorizationGroup

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 C_ProdByAreaOfRespyVH.
-- 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: CPRODBYAORVH

CREATE VIEW C_ProdByAreaOfRespyVH AS
SELECT
  _MaterialVH.Material AS Material,
  _MaterialVH.Plant AS Plant,
  _MaterialVH.MRPArea AS MRPArea,
  _MaterialVH.MaterialName AS MaterialName,
  _MaterialVH.MRPType AS MRPType,
  _MaterialVH.MaterialGroup AS MaterialGroup,
  _MaterialVH.MaterialBaseUnit AS MaterialBaseUnit,
  ProductAuthorizationGroup,
  ProductTypeAuthorizationGroup,
  ProductGroupAuthorizationGroup
LEFT OUTER JOIN I_MRPArea AS _MRPArea ON /* join condition not captured in parsed metadata */
;

Learn More