P_Searchterms

DDL: P_SEARCHTERMS SQL: PSRCHTERMS Type: view BASIC
5 Fields 1 Data Sources

P_Searchterms is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (mmpur_ct_itm_srh) and exposes 5 fields with key fields SAPClient, OpnCtlgItemID, LanguageCode, SequenceNumber.

Data Sources (1)

SourceAliasJoin Type
mmpur_ct_itm_srh search_term from

Annotations (4)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
ClientDependent true view
AbapCatalog.sqlViewName PSRCHTERMS view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SAPClient mmpur_ct_itm_srh mandt Editing Client
KEY OpnCtlgItemID mmpur_ct_itm_srh ctlg_itm_key Catalog Item Key
KEY LanguageCode mmpur_ct_itm_srh languagecode Language Key
KEY SequenceNumber 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 P_Searchterms.
-- 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: PSRCHTERMS

CREATE VIEW P_Searchterms AS
SELECT
  search_term.mandt AS SAPClient,
  search_term.ctlg_itm_key AS OpnCtlgItemID,
  search_term.languagecode AS LanguageCode,
  search_term.sequence_no AS SequenceNumber,
  search_term.search_term AS OpnCtlgSearchTerm
FROM mmpur_ct_itm_srh AS search_term
;

Learn More