SAP BBPS_SEARCH_MAINLIST_INV Search: the Results List for the Invoices Table data and field list

BBPS_SEARCH_MAINLIST_INV 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: the Results List for the Invoices" 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_MAINLIST_INV TYPE BBPS_SEARCH_MAINLIST_INV.

The BBPS_SEARCH_MAINLIST_INV table consists of various fields, each holding specific information or linking keys about Search: the Results List for the Invoices data available in SAP. These include OBJECT_ID (Transaction Number), SUBTYPE (Specification of a Purchasing Doc.(e.g. Credit Memo/Invoice)), DESCRIPTION (Name of SRM Document), REF_DOC_NO (Reference Document Number)... 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_SEARCH_MAINLIST_INV structure Technical Details:

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_MAINLIST_INV 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_SEARCH_MAINLIST_INV 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
OBJECT_ID	Transaction Number	CRMT_OBJECT_ID_DB	CHAR	10		ALPHA	CRM_OBJECT_ID
SUBTYPE	Specification of a Purchasing Doc.(e.g. Credit Memo/Invoice)	BBP_H_SUBTYPE	CHAR	2			BBP_H_SUBTYPE
DESCRIPTION	Name of SRM Document	BBP_DOCNAME	CHAR	40			TEXT40
REF_DOC_NO	Reference Document Number	XBLNR	CHAR	16			XBLNR
CREATED_BY_NAME	Full Name of Person	AD_NAMTEXT	CHAR	80			TEXT80
POSTING_DATE	Document Date (Posting Date of Log. Business Transaction)	BBP_POSTING_DATE	DATS	8			DATUM
CREATED_ON	Created on	BBP_CREATE_DATE	DATS	8			DATUM
STATUS_DESCR	Object status	J_TXT30	CHAR	30			TEXT30
MARK	Checkbox	XFELD	CHAR	1			XFELD
ICC_BUPLA_AR	Business Place	ICC_BUPLA	CHAR	4			BBP_ICC_J_1BBRANCH
ICC_BR_NF_FRE	Nota Fiscal: Freight Value including Taxes	BBP_ICC_NFFRE	CURR	15(2)			BBP_ICC_WERTV8
ICC_BR_NF_INS	Nota Fiscal: Insurance Value including Taxes	BBP_ICC_NFINS	CURR	15(2)			BBP_ICC_WERTV8
ICC_BR_NF_OTH	Nota Fiscal: Expenses including Taxes	BBP_ICC_NFOTH	CURR	15(2)			BBP_ICC_WERTV8
ICC_BR_NF_DIS	Nota Fiscal: Discount Value including Taxes	BBP_ICC_NFDIS	CURR	15(2)			BBP_ICC_WERTV8
ICC_BR_NF_NET	Nota Fiscal: Net Value including Taxes	BBP_ICC_NFNET	CURR	15(2)			BBP_ICC_WERTV8
ICC_BR_NF_TOT	Nota Fiscal: Total Value including All Taxes	BBP_ICC_NFTOT	CURR	15(2)			BBP_ICC_WERTV8
ICC_BUPLA_BR	Business Place	ICC_BUPLA	CHAR	4			BBP_ICC_J_1BBRANCH
ICC_KIDNO_DK	Payment Reference Number	ID_KIDNO	CHAR	30			CHAR30
ICC_KIDNO_FI	Payment Reference Number	ID_KIDNO	CHAR	30			CHAR30
ICC_BUPLA_KR	Business Place	ICC_BUPLA	CHAR	4			BBP_ICC_J_1BBRANCH
ICC_KIDNO_NO	Payment Reference Number	ID_KIDNO	CHAR	30			CHAR30
ICC_KIDNO_SE	Payment Reference Number	ID_KIDNO	CHAR	30			CHAR30
ICC_BUPLA_TH	Business Place	ICC_BUPLA	CHAR	4			BBP_ICC_J_1BBRANCH
ICC_BUPLA_TW	Business Place	ICC_BUPLA	CHAR	4			BBP_ICC_J_1BBRANCH
DUMMY_EEW_PD_SEARCH_HSS_INV	Dummy function in length 1	DUMMY	CHAR	1			DUMMY
DUMMY_EEW_PD_SEARCH_HSC_INV	Dummy function in length 1	DUMMY	CHAR	1			DUMMY
GUID	Globally Unique identifier	BBP_GUID	RAW	16			SYSUUID
OBJECT_TYPE	Object Type	SWO_OBJTYP	CHAR	10	Assigned to domain		OJ_NAME	OBJ
CREATED_BY	User that Created the Transaction	CRMT_CREATED_BY	CHAR	12			UNAME		USER_ADDR
CURRENCY	Currency Key	WAERS	CUKY	5	Assigned to domain		WAERS	FWS
STATUS	Object status	J_STATUS	CHAR	5			J_STATUS
LINE_NUMBER	Line Counter	SHLINE	NUMC	5			NUMC5
BE_LOG_SYSTEM	Logical System of Logistics Backend	BE_LOG_SYSTEM	CHAR	10	Assigned to domain	ALPHA	LOGSYS
STATUS_LONG	BBP text	BBP_TEXT	CHAR	132			ITEX132
PROC_ORG	Responsible Purchasing Organization	BBP_PROC_ORG	CHAR	14			HROBJEC_14		BBP_PROC_ORG
PROC_GROUP	Responsible Purchasing Group	BBP_PROC_GROUP	CHAR	14			HROBJEC_14		BBP_PROC_GROUP

Key field

Non-key field

< BBPS_SEARCH_MAINLIST_IMS_WEB - Search: the List for the WEB Transport for the Exceptions BBPS_SEARCH_MAINLIST_INV_WEB - Search: the List for the WEB Transport for the Invoices >

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

As BBPS_SEARCH_MAINLIST_INV 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_MAINLIST_INV as there is no data to select.

How to access SAP table BBPS_SEARCH_MAINLIST_INV

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

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