SHSM_H_KO_STBLG

DDL: SHSM_H_KO_STBLG SQL: SHSMHKOSTBLG Type: view
17 Fields 1 Data Sources 1 Associations

CDS replacing H_KO_STBLG in search help

SHSM_H_KO_STBLG is a CDS View that provides data about "CDS replacing H_KO_STBLG in search help" in SAP S/4HANA. It reads from 1 data source (h_ko_stblg) and exposes 17 fields. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
h_ko_stblg h_ko_stblg from

Associations (1)

CardinalityTargetAliasCondition
[1..1] rbkp _RBKP $projection.belnr = _RBKP.belnr and $projection.gjahr = _RBKP.gjahr and $projection.mandt = _RBKP.mandt

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName SHSMHKOSTBLG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label CDS replacing H_KO_STBLG in search help view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view

Fields (17)

KeyFieldSource TableSource FieldDescription
mandt mandt Editing Client
belnr belnr SD Document
gjahr gjahr Settlement Year
bldat bldat Journal Entry Date
budat budat Posting Date
cpudt cpudt Imported On
usnam usnam User Name
stblg stblg Reversed With
stjah stjah Year
buzei buzei Posting View Item
ebeln ebeln Source PurchDoc
ebelp ebelp Item pur. doc.
matnr matnr Vehicle Model
werks werks Receiving Plant
bwtar bwtar Valuation Type
bukrs bukrs Value
iseopblocked _RBKP iseopblocked Business Usage Comp.

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_H_KO_STBLG.
-- 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: SHSMHKOSTBLG

CREATE VIEW SHSM_H_KO_STBLG AS
SELECT
  mandt,
  belnr,
  gjahr,
  bldat,
  budat,
  cpudt,
  usnam,
  stblg,
  stjah,
  buzei,
  ebeln,
  ebelp,
  matnr,
  werks,
  bwtar,
  bukrs,
  _RBKP.iseopblocked AS iseopblocked
FROM h_ko_stblg
LEFT OUTER JOIN rbkp AS _RBKP ON belnr = _RBKP.belnr AND gjahr = _RBKP.gjahr AND mandt = _RBKP.mandt  -- association [1..1]
;

Learn More