SHSM_BNKA

DDL: SHSM_BNKA SQL: SHSMBNKA Type: view
9 Fields 1 Data Sources

CDS View replacing BNKA in search help

SHSM_BNKA is a CDS View that provides data about "CDS View replacing BNKA in search help" in SAP S/4HANA. It reads from 1 data source (bnka) and exposes 9 fields.

Data Sources (1)

SourceAliasJoin Type
bnka bnka from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName SHSMBNKA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.dataCategory #VALUE_HELP view
EndUserText.label CDS View replacing BNKA in search help view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (9)

KeyFieldSource TableSource FieldDescription
banks banks Bank Ctry/Rgn. Key
bankl bankl House Bank
banka banka Bank Name
ort01 ort01 Province
bnklz bnklz Bank Number
swift swift SWIFT/BIC
brnch brnch Business Place
stras stras Street/House
loevm loevm End Contract

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_BNKA.
-- 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: SHSMBNKA

CREATE VIEW SHSM_BNKA AS
SELECT
  banks,
  bankl,
  banka,
  ort01,
  bnklz,
  swift,
  brnch,
  stras,
  loevm
FROM bnka
;

Learn More