SAP BBPS_PROD_SH_EXT search parameter & search result Table data and field list

BBPS_PROD_SH_EXT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "search parameter & search result" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_BBPS_PROD_SH_EXT TYPE BBPS_PROD_SH_EXT.

The BBPS_PROD_SH_EXT table consists of various fields, each holding specific information or linking keys about search parameter & search result data available in SAP. These include DESCRIPTION (Product Description in Uppercase for F4 Help), CATEGORY_ID (Category ID), PRODUCT_TYPE (Product Type), LOGICAL_SYSTEM (Original System)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

BBPS_PROD_SH_EXT structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP BBPS_PROD_SH_EXT structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the BBPS_PROD_SH_EXT table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
PRODUCT_IDProduct ID COMT_PRODUCT_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
DESCRIPTIONProduct Description in Uppercase for F4 Help COMT_PRSHTEXTGCHAR40PRSHTEXTG40
CATEGORY_IDCategory ID COMT_CATEGORY_IDCHAR20COM_CATEGORY_IDCOM_CATEGORY_IDCOM_CAT_HIER
PRODUCT_TYPEProduct Type COMT_PRODUCT_TYPECHAR2Assigned to domainCOM_PRODUCT_TYPECOM_PRODUCT_TYPECOM_PR_TYPE_ACTIVE
LOGICAL_SYSTEMOriginal System COMT_LOGSYSCHAR10Assigned to domainALPHALOGSYSCOM_LOGSYSCOM_PRODUCT_LOGSYS

Key field Non-key field



How do I retrieve data from SAP structure BBPS_PROD_SH_EXT using ABAP code?

As BBPS_PROD_SH_EXT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BBPS_PROD_SH_EXT as there is no data to select.

How to access SAP table BBPS_PROD_SH_EXT

Within an ECC or HANA version of SAP you can also view further information about BBPS_PROD_SH_EXT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).