SAP BUS_AS_ALL_FIELDS Business Partner: Fields of the Field Catalog (for Search) Table data and field list

BUS_AS_ALL_FIELDS 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 "Business Partner: Fields of the Field Catalog (for Search)" 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_BUS_AS_ALL_FIELDS TYPE BUS_AS_ALL_FIELDS.

The BUS_AS_ALL_FIELDS table consists of various fields, each holding specific information or linking keys about Business Partner: Fields of the Field Catalog (for Search) data available in SAP. These include BP_NUMBER (Business Partner Number), MC_NAME1 (Search Help Field 1 (Name 1/Last Name)), MC_NAME2 (Search Help Field 2 (Name 2/First Name)), GUID (Business Partner GUID)... 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. .

BUS_AS_ALL_FIELDS structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP BUS_AS_ALL_FIELDS 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 BUS_AS_ALL_FIELDS 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
BP_NUMBERBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
MC_NAME1Search Help Field 1 (Name 1/Last Name) BU_MCNAME1CHAR35CHAR35
MC_NAME2Search Help Field 2 (Name 2/First Name) BU_MCNAME2CHAR35CHAR35
GUIDBusiness Partner GUID BU_PARTNER_GUIDRAW16SYSUUID
EXT_NUMBERBusiness Partner Number in External System BU_BPEXTCHAR20CHAR20
SORT1Search term 1 for business partner BU_SORT1CHAR20BU_SORT1
SORT2Search term 2 for business partner BU_SORT2CHAR20BU_SORT1

Key field Non-key field



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

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

How to access SAP table BUS_AS_ALL_FIELDS

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

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