SHSM_WRF_SALES_MAT_CHAR

DDL: SHSM_WRF_SALES_MAT_CHAR SQL: SHSMSALESMATCHAR Type: view
9 Fields 1 Data Sources

CDS replacing VBAP in WRF_SALES_MAT_CHAR

SHSM_WRF_SALES_MAT_CHAR is a CDS View that provides data about "CDS replacing VBAP in WRF_SALES_MAT_CHAR" in SAP S/4HANA. It reads from 1 data source (vbak) and exposes 9 fields with key field vbeln.

Data Sources (1)

SourceAliasJoin Type
vbak vbak from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName SHSMSALESMATCHAR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey vbeln view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label CDS replacing VBAP in WRF_SALES_MAT_CHAR view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY vbeln vbap vbeln SD Sched. Agmt
matnr vbap matnr Vehicle Model
wrf_charstc1 vbap wrf_charstc1 Characteristic 1
wrf_charstc2 vbap wrf_charstc2 Characteristic 2
wrf_charstc3 vbap wrf_charstc3 Characteristic 3
vkorg vbak vkorg SD Sales Org.
vtweg vbak vtweg RefDistCh-Cust/Mat.
spart vbak spart Source supplier
auart vbak auart Sales Doc. Type

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_WRF_SALES_MAT_CHAR.
-- 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: SHSMSALESMATCHAR

CREATE VIEW SHSM_WRF_SALES_MAT_CHAR AS
SELECT
  vbap.vbeln AS vbeln,
  vbap.matnr AS matnr,
  vbap.wrf_charstc1 AS wrf_charstc1,
  vbap.wrf_charstc2 AS wrf_charstc2,
  vbap.wrf_charstc3 AS wrf_charstc3,
  vbak.vkorg AS vkorg,
  vbak.vtweg AS vtweg,
  vbak.spart AS spart,
  vbak.auart AS auart
FROM vbak
;

Learn More