I_OpnCtlgSearchTerm

DDL: I_OPNCTLGSEARCHTERM SQL: IOPNCTLGSRCHTERM Type: view BASIC
4 Fields 1 Data Sources

Search term for Catalog Item

I_OpnCtlgSearchTerm is a Basic CDS View that provides data about "Search term for Catalog Item" in SAP S/4HANA. It reads from 1 data source (mmpur_ct_itm_srh) and exposes 4 fields with key fields OpnCtlgItemID, LanguageCode, OpenCatalogSrchSequenceNumber.

Data Sources (1)

SourceAliasJoin Type
mmpur_ct_itm_srh search_term from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IOPNCTLGSRCHTERM view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Search term for Catalog Item view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY OpnCtlgItemID mmpur_ct_itm_srh ctlg_itm_key Catalog Item Key
KEY LanguageCode mmpur_ct_itm_srh languagecode Language Key
KEY OpenCatalogSrchSequenceNumber mmpur_ct_itm_srh sequence_no Sqnc No. in Ext File
OpnCtlgSearchTerm mmpur_ct_itm_srh search_term Recipe

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 I_OpnCtlgSearchTerm.
-- 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: IOPNCTLGSRCHTERM

CREATE VIEW I_OpnCtlgSearchTerm AS
SELECT
  search_term.ctlg_itm_key AS OpnCtlgItemID,
  search_term.languagecode AS LanguageCode,
  search_term.sequence_no AS OpenCatalogSrchSequenceNumber,
  search_term.search_term AS OpnCtlgSearchTerm
FROM mmpur_ct_itm_srh AS search_term
;

Learn More