SAP BURS_JOEL_SELECTION Dynpro Structure: Selections for Relationship Overview Table data and field list

BURS_JOEL_SELECTION 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 "Dynpro Structure: Selections for Relationship Overview" 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_BURS_JOEL_SELECTION TYPE BURS_JOEL_SELECTION.

The BURS_JOEL_SELECTION table consists of various fields, each holding specific information or linking keys about Dynpro Structure: Selections for Relationship Overview data available in SAP. These include PARTNER (Business Partner Number), MC_NAME1 (Search Help Field 1 (Name 1/Last Name)), MC_NAME2 (Search Help Field 2 (Name 2/First Name)), BU_SORT1 (Search term 1 for business partner)... 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. .

BURS_JOEL_SELECTION 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 BURS_JOEL_SELECTION 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 BURS_JOEL_SELECTION 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
MAX_RECORDSAP BP Dialog: Maximum Number of Hits BUR_MAX_RECORDSINT410INT4
PARTNERBusiness Partner Number BU_PARTNERCHAR10BUT000ALPHABU_PARTNERBPABUPA
MC_NAME1Search Help Field 1 (Name 1/Last Name) BU_MCNAME1CHAR35CHAR35
MC_NAME2Search Help Field 2 (Name 2/First Name) BU_MCNAME2CHAR35CHAR35
BU_SORT1Search term 1 for business partner BU_SORT1CHAR20BU_SORT1
BU_SORT2Search term 2 for business partner BU_SORT2CHAR20BU_SORT1
ID_TYPEIdentification Type BU_ID_TYPECHAR6TB039ABU_ID_TYPE
ID_NUMBERIdentification Number BU_ID_NUMBERCHAR60CHAR60
PAFKTFunction of partner BU_PAFKTCHAR4TB912BU_PAFKT
ABTNRDepartment BU_ABTNRCHAR4TB910BU_ABTNR
PAVIPVIP Partner BU_PAVIPCHAR1TB916BU_PAVIP
VALIDTY_IDSAP BP Dialog: Validity Type BUR_VALIDITY_IDCHAR1BUR_VALIDITY_IDBUPR_VALIDITY_ID
DATE_FROMScreen: 'From' Date in Character Format BU_DATE_FROM_CHARCHAR10CHAR10BU_DATE_CHAR
DATE_TOScreen: 'Valid To' Date in Character Format BU_DATE_TO_CHARCHAR10CHAR10BU_DATE_CHAR

Key field Non-key field



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

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

How to access SAP table BURS_JOEL_SELECTION

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

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