SHSM_KNMT_REF

DDL: SHSM_KNMT_REF Type: view
13 Fields 3 Data Sources 1 Associations

CDS View replacing KNMT_REF

SHSM_KNMT_REF is a CDS View that provides data about "CDS View replacing KNMT_REF" in SAP S/4HANA. It reads from 3 data sources (knmt, knmt, knmta) and exposes 13 fields with key fields kunnr, vkorg, kdmat, matnr, vtweg. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
knmt knmt from
knmt knmt union
knmta knmta inner

Associations (1)

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

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName SHSMKNMTREF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey kunnr view
EndUserText.label CDS View replacing KNMT_REF view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY kunnr kunnr Stock customer
KEY vkorg vkorg SD Sales Org.
KEY kdmat kdmat Customer Mat.
KEY matnr matnr Vehicle Model
KEY vtweg vtweg RefDistCh-Cust/Mat.
kdptx postx CustMatDescr.
kunnr Stock customer
KEY vkorg knmt vkorg SD Sales Org.
KEY kdmat knmta kdmat Customer Mat.
KEY matnr knmt matnr Vehicle Model
KEY vtweg knmt vtweg RefDistCh-Cust/Mat.
kdptx knmta addpostx CustMatDescr.
_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 SHSM_KNMT_REF.
-- 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.

CREATE VIEW SHSM_KNMT_REF AS
SELECT
  kunnr,
  vkorg,
  kdmat,
  matnr,
  vtweg,
  postx AS kdptx
FROM knmt
INNER JOIN knmta ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer AS _Customer ON kunnr = _Customer.Customer  -- association [0..1]
-- UNION with additional select branch(es): knmt
;

Learn More