C_RevnVarcMaterialVH

DDL: C_REVNVARCMATERIALVH SQL: CRVAMATLVH Type: view CONSUMPTION Package: ODATA_REVENUE_VARIANCE
7 Fields 1 Data Sources 1 OData Services

Value help for Material

C_RevnVarcMaterialVH is a Consumption CDS View that provides data about "Value help for Material" in SAP S/4HANA. It reads from 1 data source (I_Material) and exposes 7 fields with key fields Material, MaterialGroup, MaterialType. It is exposed through 1 OData service (ASQL_F3072). Part of development package ODATA_REVENUE_VARIANCE.

Data Sources (1)

SourceAliasJoin Type
I_Material I_Material from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CRVAMATLVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Value help for Material view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F3072 ASQL_F3072 C2 NOT_RELEASED

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Material Vehicle Model
KEY MaterialGroup Product Group
KEY MaterialType MaterialType Material Type
MaterialName
AuthorizationGroup AuthorizationGroup AuthorizGroup
ProductTypeAuthorizationGroup _MaterialType AuthorizationGroup AuthorizGroup
ProductAuthorizationGroup _MaterialGroup MaterialAuthorizationGroup

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_RevnVarcMaterialVH.
-- 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: CRVAMATLVH

CREATE VIEW C_RevnVarcMaterialVH AS
SELECT
  cast(Material as fins_matnr_pa) AS Material,
  cast(MaterialGroup as fins_matkl_pa) AS MaterialGroup,
  MaterialType,
  cast(_Text[1: Language = $session.system_language ].MaterialName as fac_revvar_matnr_name) AS MaterialName,
  AuthorizationGroup,
  _MaterialType.AuthorizationGroup AS ProductTypeAuthorizationGroup,
  _MaterialGroup.MaterialAuthorizationGroup AS ProductAuthorizationGroup
FROM I_Material
;

Learn More