SHSM_KNA14

DDL: SHSM_KNA14 SQL: SHSMKNA14 Type: view

SHSM_KNA14 is a CDS View in SAP S/4HANA. It reads from 1 data source (kna1) and exposes 15 fields with key field kunnr.

Data Sources (1)

SourceAliasJoin Type
kna1 kna1 from

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName SHSMKNA14 view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey kunnr view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY kunnr
name1
begru
ktokd
DataControllerSet kna1 xdcset Data Ctrlr. Set
DataController1 kna1 data_ctrlr1 Data Controller
DataController2 kna1 data_ctrlr2 Data Controller
DataController3 kna1 data_ctrlr3 Data Controller
DataController4 kna1 data_ctrlr4 Data Controller
DataController5 kna1 data_ctrlr5 Data Controller
DataController6 kna1 data_ctrlr6 Data Controller
DataController7 kna1 data_ctrlr7 Data Controller
DataController8 kna1 data_ctrlr8 Data Controller
DataController9 kna1 data_ctrlr9 Data Controller
DataController10 kna1 data_ctrlr10 Data Controller

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_KNA14.
-- 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: SHSMKNA14

CREATE VIEW SHSM_KNA14 AS
SELECT
  cast( kna1.kunnr as kunnr preserving type ) AS kunnr,
  cast( kna1.name1 as name1_gp preserving type ) AS name1,
  cast( kna1.begru as begru preserving type ) AS begru,
  cast( kna1.ktokd as ktokd preserving type ) AS ktokd,
  kna1.xdcset AS DataControllerSet,
  kna1.data_ctrlr1 AS DataController1,
  kna1.data_ctrlr2 AS DataController2,
  kna1.data_ctrlr3 AS DataController3,
  kna1.data_ctrlr4 AS DataController4,
  kna1.data_ctrlr5 AS DataController5,
  kna1.data_ctrlr6 AS DataController6,
  kna1.data_ctrlr7 AS DataController7,
  kna1.data_ctrlr8 AS DataController8,
  kna1.data_ctrlr9 AS DataController9,
  kna1.data_ctrlr10 AS DataController10
FROM kna1
;