BBPS_SEARCH_SUBLIST_POST SAP (Search: Results List When Expanding for Purchase Orders) Structure details
Description: Search: Results List When Expanding for Purchase Orders
Related tables to BBPS_SEARCH_SUBLIST_POST
Access table BBPS_SEARCH_SUBLIST_POST
Structure field list including key, data, relationships and ABAP select examples
BBPS_SEARCH_SUBLIST_POST 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: Results List When Expanding for Purchase Orders" 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_SEARCH_SUBLIST_POST TYPE BBPS_SEARCH_SUBLIST_POST.
The BBPS_SEARCH_SUBLIST_POST table consists of various fields, each holding specific information or linking keys about Search: Results List When Expanding for Purchase Orders data available in SAP. These include NUMBER_INT (Item Number), DESCRIPTION (Short Text), ORDERED_PROD (Product Name Entered), CATEGORY_ID (Category ID).. 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. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP BBPS_SEARCH_SUBLIST_POST structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
NUMBER_INT | Item Number | BBP_ITEM_NO | NUMC | 10 | CRM_ITEM_NO | ||||
DESCRIPTION | Short Text | TXZ01 | CHAR | 40 | TEXT40 | ||||
ORDERED_PROD | Product Name Entered | CRMT_ORDERED_PROD_DB | CHAR | 54 | CRM_ORDERED_PROD | ||||
CATEGORY_ID | Category ID | COMT_CATEGORY_ID | CHAR | 20 | COM_CATEGORY_ID | COM_CATEGORY_ID | COM_CAT_HIER | ||
CATEGORY_TEXT | Category Description | COMT_CATEGORY_TEXT | CHAR | 80 | TEXT80 | ||||
CATALOGID | Catalog ID from which the line was selected | CATALOG | CHAR | 20 | BBP_WS_SERVICE_ID | ||||
CATALOGITEM | Catalog Item (Unique Key) | CATALOGITEM | CHAR | 40 | CATALOGITEM | ||||
PRICE | Net Price | BBP_PRICE | CURR | 13(2) | WERT7 | ||||
PRICE_UNIT | Price Unit | EPEIN | DEC | 5 | DEC5 | ||||
DELIV_DATE | Item Delivery Date | EINDT | DATS | 8 | DATUM | ||||
PARTNER_PROD | Product Number of Vendor | BBP_PARTNER_PROD | CHAR | 40 | PRSHTEXT40 | ||||
QUANTITY | Quantity in Order Unit | BBP_MNG | QUAN | 13(3) | MENG13 | ||||
UNIT | Unit of Measurement | BBP_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
VALUE | Net Value | BBP_VALUE | CURR | 15(2) | WERT8 | ||||
CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
RECIPIENT_DESC | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
TEL1_NUMBR_EXT | Telephone Number | BBP_TEL1_NUMBR_EXT | CHAR | 40 | TEXT40 | ||||
BUILDING_P | Building (number or code) | AD_BLDNG_P | CHAR | 10 | TEXT10 | ||||
ROOM_NO_P | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
INHOUSE_ML | Int. mail postal code | AD_IH_MAIL | CHAR | 10 | TEXT10 | ||||
REQUESTER_DESC | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
ICC_BR_STEUC | Brazilian NCM Code | ITL_NCM | CHAR | 16 | CRMC_TAX_TCODE | CHAR16 | |||
ICC_BR_MATUSE | Material Usage | ITL_MAT_USAGE | CHAR | 1 | ITL_MAT_USAGE | ||||
ICC_BR_MATORG | Origin of the material | ITL_NF_MATORG | CHAR | 1 | ITL_NF_MATORG | ||||
ICC_BR_OWNPRO | Produced in-house | ITL_OWNPRO | CHAR | 1 | XFELD | ||||
ICC_BR_INDUST | Material CFOP category | ITL_NF_INDUS3 | CHAR | 2 | ITL_NF_INDUS3 | ||||
ICC_IN_TXJCD | Tax Tariff Code | CRMT_TAX_TARIFF_CODE | CHAR | 16 | CHAR16 | ||||
DUMMY_EEW_PD_SEARCH_ISS_PO | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
.INCLU--AP | 0 | ||||||||
PS_US01 | User-Specified Status 01 | /SAPPSSRM/_US_01 | CHAR | 5 | Assigned to domain | J_ESTAT | /SAPPSSRM/H_US | ||
PS_US02 | User-Specified Status 02 | /SAPPSSRM/_US_02 | CHAR | 5 | Assigned to domain | J_ESTAT | /SAPPSSRM/H_US | ||
PS_US03 | User-Specified Status 03 | /SAPPSSRM/_US_03 | CHAR | 5 | Assigned to domain | J_ESTAT | /SAPPSSRM/H_US | ||
PS_US04 | User-Specified Status 04 | /SAPPSSRM/_US_04 | CHAR | 5 | Assigned to domain | J_ESTAT | /SAPPSSRM/H_US | ||
PS_US05 | User-Specified Status 05 | /SAPPSSRM/_US_05 | CHAR | 5 | Assigned to domain | J_ESTAT | /SAPPSSRM/H_US | ||
PS_US06 | User-Specified Status 06 | /SAPPSSRM/_US_06 | CHAR | 5 | Assigned to domain | J_ESTAT | /SAPPSSRM/H_US | ||
PS_US07 | User-Specified Status 07 | /SAPPSSRM/_US_07 | CHAR | 5 | Assigned to domain | J_ESTAT | /SAPPSSRM/H_US | ||
PS_US08 | User-Specified Status 08 | /SAPPSSRM/_US_08 | CHAR | 5 | Assigned to domain | J_ESTAT | /SAPPSSRM/H_US | ||
PS_US09 | User-Specified Status 09 | /SAPPSSRM/_US_09 | CHAR | 5 | Assigned to domain | J_ESTAT | /SAPPSSRM/H_US | ||
PS_US10 | User-Specified Status 10 | /SAPPSSRM/_US_10 | CHAR | 5 | Assigned to domain | J_ESTAT | /SAPPSSRM/H_US | ||
PS_US01_TXT | User-Specified Status 01 Description | /SAPPSSRM/_US_TXT_01 | CHAR | 30 | TEXT30 | /SAPPSSRM/H_TJ30 | |||
PS_US02_TXT | User-Specified Status 02 Description | /SAPPSSRM/_US_TXT_02 | CHAR | 30 | TEXT30 | /SAPPSSRM/H_TJ30 | |||
PS_US03_TXT | User-Specified Status 03 Description | /SAPPSSRM/_US_TXT_03 | CHAR | 30 | TEXT30 | /SAPPSSRM/H_TJ30 | |||
PS_US04_TXT | User-Specified Status 04 Description | /SAPPSSRM/_US_TXT_04 | CHAR | 30 | TEXT30 | /SAPPSSRM/H_TJ30 | |||
PS_US05_TXT | User-Specified Status 05 Description | /SAPPSSRM/_US_TXT_05 | CHAR | 30 | TEXT30 | /SAPPSSRM/H_TJ30 | |||
PS_US06_TXT | User-Specified Status 06 Description | /SAPPSSRM/_US_TXT_06 | CHAR | 30 | TEXT30 | /SAPPSSRM/H_TJ30 | |||
PS_US07_TXT | User-Specified Status 07 Description | /SAPPSSRM/_US_TXT_07 | CHAR | 30 | TEXT30 | /SAPPSSRM/H_TJ30 | |||
PS_US08_TXT | User-Specified Status 08 Description | /SAPPSSRM/_US_TXT_08 | CHAR | 30 | TEXT30 | /SAPPSSRM/H_TJ30 | |||
PS_US09_TXT | User-Specified Status 09 Description | /SAPPSSRM/_US_TXT_09 | CHAR | 30 | TEXT30 | /SAPPSSRM/H_TJ30 | |||
PS_US10_TXT | User-Specified Status 10 Description | /SAPPSSRM/_US_TXT_10 | CHAR | 30 | TEXT30 | /SAPPSSRM/H_TJ30 | |||
.INCLU--AP | 0 | ||||||||
PS_IPT | Public Sector Item Type | /SAPPSSRM/_IPT | CHAR | 10 | Assigned to domain | /SAPPSSRM/_IPT | |||
EXLIN | Configurable Line Item Number | /SAPSRM/EXLIN | CHAR | 40 | /SAPSRM/EXLIN | ||||
PS_CTRL_KEY | Item Process Type Control Key | /SAPPSSRM/_PS_CTRL_KEY | CHAR | 4 | Assigned to domain | /SAPPSSRM/_PS_CTRL_KEY | /SAPPSSRM/H_PS_CTRL_KEY | ||
PS_EXSNR | External Sort Number | /SAPPSSRM/_EXSNR | NUMC | 5 | NUMC5 | ||||
DUMMY_EEW_PD_SEARCH_ISC_PO | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
DUMMY_EEW_PD_SEARCH_ISD_PO | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
RECIPIENT | Partner Number | CRMT_PARTNER_NO | CHAR | 32 | CRM_PARTNER_NO | ||||
REQUESTER | Partner Number | CRMT_PARTNER_NO | CHAR | 32 | CRM_PARTNER_NO | ||||
VENDOR | Partner Number | CRMT_PARTNER_NO | CHAR | 32 | CRM_PARTNER_NO | ||||
VENDOR_DESC | Full Name of Person | AD_NAMTEXT | CHAR | 80 | TEXT80 | ||||
BE_REFOBJ_TYPE | Reference Object Type in Back-End System | BE_REFOBJ_TYPE | CHAR | 10 | Assigned to domain | OJ_NAME | |||
BE_REFOBJ | Reference Object in Back-End System | BE_REFOBJ | CHAR | 20 | BBP_BE_OBJECT_ID | ||||
BE_REFOBJ_ITEM | Reference Object Item in Back-End System | BE_REFOBJ_ITEM | CHAR | 10 | BBP_REF_ITEM | ||||
BE_LOG_SYSTEM | Logical System of Logistics Backend | BE_LOG_SYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
SUBTYPE | Specification Purchase Item (e.g. Direct Material/Hierarch.) | BBP_I_SUBTYPE | CHAR | 2 | BBP_I_SUBTYPE | ||||
GUID | Globally Unique identifier | BBP_GUID | RAW | 16 | SYSUUID | ||||
HEADER | Globally Unique identifier | BBP_GUID | RAW | 16 | SYSUUID | ||||
INV_NO_DISPLAY | Character field of length 40 | CHAR40 | CHAR | 40 | CHAR40 | ||||
ITM_TYPE | Item Category | CRMT_ITEM_TYPE_DB | CHAR | 4 | Assigned to domain | CRM_ITEM_TYPE | |||
LINE_NUMBER | Line Counter | SHLINE | NUMC | 5 | NUMC5 | ||||
HDR_LINE_NUMBER | Line Counter | SHLINE | NUMC | 5 | NUMC5 | ||||
MARK | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
EXPANDED | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
PARENT | Parent GUID | BBP_PGUID | RAW | 16 | SYSUUID |
Key field | Non-key field |
How do I retrieve data from SAP structure BBPS_SEARCH_SUBLIST_POST using ABAP code?
As BBPS_SEARCH_SUBLIST_POST 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_SEARCH_SUBLIST_POST as there is no data to select.How to access SAP table BBPS_SEARCH_SUBLIST_POST
Within an ECC or HANA version of SAP you can also view further information about BBPS_SEARCH_SUBLIST_POST and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects