I_CustomerMaterialValueHelp

DDL: I_CUSTOMERMATERIALVALUEHELP SQL: ICUSTMATVH Type: view BASIC
8 Fields 1 Data Sources 1 Associations

Customer Material Value Help

I_CustomerMaterialValueHelp is a Basic CDS View that provides data about "Customer Material Value Help" in SAP S/4HANA. It reads from 1 data source (knmt) and exposes 8 fields with key fields MaterialByCustomer, Customer, Material, Product, SalesOrganization. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
knmt knmt from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICUSTMATVH view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Customer Material Value Help view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
Search.searchable true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MaterialByCustomer kdmat Customer Mat.
KEY Customer kunnr Stock customer
KEY Material matnr Vehicle Model
KEY Product Vehicle Model
KEY SalesOrganization vkorg SD Sales Org.
KEY DistributionChannel vtweg RefDistCh-Cust/Mat.
KEY MaterialDescriptionByCustomer postx Customer Material Description
_Customer _Customer

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 I_CustomerMaterialValueHelp.
-- 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: ICUSTMATVH

CREATE VIEW I_CustomerMaterialValueHelp AS
SELECT
  kdmat AS MaterialByCustomer,
  kunnr AS Customer,
  matnr AS Material,
  cast (matnr as productnumber preserving type) AS Product,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  postx AS MaterialDescriptionByCustomer
FROM knmt
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
;

Learn More