C_CatalogMaterialValueHelp

DDL: C_CATALOGMATERIALVALUEHELP SQL: CCTLGMATVALHELP Type: view CONSUMPTION
6 Fields 1 Data Sources

Consumption view for Catalog materials

C_CatalogMaterialValueHelp is a Consumption CDS View that provides data about "Consumption view for Catalog materials" in SAP S/4HANA. It reads from 1 data source (I_CatalogMaterial) and exposes 6 fields with key fields CtlgMaterial, CompanyCode, CtlgPlant.

Data Sources (1)

SourceAliasJoin Type
I_CatalogMaterial I_CatalogMaterial from

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
AbapCatalog.sqlViewName CCTLGMATVALHELP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
EndUserText.label Consumption view for Catalog materials view
Search.searchable true view
ObjectModel.dataCategory #VALUE_HELP view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CtlgMaterial CtlgMaterial Vehicle Model
KEY CompanyCode I_CatalogMaterial CompanyCode Receiver Company Code
KEY CtlgPlant I_CatalogMaterial CtlgPlant Plant Name
OpnCtlgItemID OpnCtlgItemID Catalog Item Key
OpnCtlgWebServiceID I_CatalogMaterial OpnCtlgWebServiceID Web Service ID
_Text _Text

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_CatalogMaterialValueHelp.
-- 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: CCTLGMATVALHELP

CREATE VIEW C_CatalogMaterialValueHelp AS
SELECT
  CtlgMaterial,
  I_CatalogMaterial.CompanyCode AS CompanyCode,
  I_CatalogMaterial.CtlgPlant AS CtlgPlant,
  OpnCtlgItemID,
  I_CatalogMaterial.OpnCtlgWebServiceID AS OpnCtlgWebServiceID
FROM I_CatalogMaterial
;

Learn More