SHSM_VMVAH

DDL: SHSM_VMVAH SQL: SHSMVMVAH Type: view
15 Fields 1 Data Sources

CDS view replacing V_VMVAH in search help VMVAH

SHSM_VMVAH is a CDS View that provides data about "CDS view replacing V_VMVAH in search help VMVAH" in SAP S/4HANA. It reads from 1 data source (vbak) and exposes 15 fields with key fields vbeln, kkber, cmgst, sbgrp, cmngv.

Data Sources (1)

SourceAliasJoin Type
vbak vbak from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName SHSMVMVAH 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 view replacing V_VMVAH in search help VMVAH view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY vbeln vbeln SD Sched. Agmt
KEY kkber kkber Cred.Contr.Area
KEY cmgst cmgst OverallCredStat
KEY sbgrp sbgrp Rep. group
KEY cmngv cmngv Next date
KEY knkli knkli Credit Account
KEY ctlpc ctlpc Risk Category
KEY grupp grupp Planning group
KEY cmfre cmfre Release date
KEY cmnup cmnup Next Check
KEY vkorg vkorg SD Sales Org.
KEY vtweg vtweg RefDistCh-Cust/Mat.
KEY spart spart Source supplier
auart auart Sales Doc. Type
gbstk gbstk Overall Status

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_VMVAH.
-- 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: SHSMVMVAH

CREATE VIEW SHSM_VMVAH AS
SELECT
  vbeln,
  kkber,
  cmgst,
  sbgrp,
  cmngv,
  knkli,
  ctlpc,
  grupp,
  cmfre,
  cmnup,
  vkorg,
  vtweg,
  spart,
  auart,
  gbstk
FROM vbak
;

Learn More