BUS000FLDS SAP (CBP: Work fields and screen fields) Structure details
Description: CBP: Work fields and screen fields
Structure field list including key, data, relationships and ABAP select examples
BUS000FLDS 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 "CBP: Work fields and screen fields" 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_BUS000FLDS TYPE BUS000FLDS.
The BUS000FLDS table consists of various fields, each holding specific information or linking keys about CBP: Work fields and screen fields data available in SAP. These include BU_GROUP (Business Partner Grouping), TYPE (Business partner category), BPKIND (Business Partner Type), BPEXT (Business Partner Number in External 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. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP BUS000FLDS 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 |
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
BU_GROUP | Business Partner Grouping | BU_GROUP | CHAR | 4 | TB001 | BU_GROUP | BPP | ||
TYPE | Business partner category | BU_TYPE | CHAR | 1 | BU_TYPE | BPY | |||
BPKIND | Business Partner Type | BU_BPKIND | CHAR | 4 | TB004 | BU_KIND | |||
BPEXT | Business Partner Number in External System | BU_BPEXT | CHAR | 20 | CHAR20 | ||||
XSAVE | Indicator: Business partner safeguards himself | BU_XSAVE | CHAR | 1 | XFELD | ||||
XCHNG | Indicator: Data has been changed | BU_XCHNG | CHAR | 1 | XFELD | ||||
XBUPO | Business partner is an organization | BU_XBUPO | CHAR | 1 | XFELD | ||||
XBUPP | Business partner is a natural person | BU_XBUPP | CHAR | 1 | XFELD | ||||
XBUPG | Business partner is a group | BU_XBUPG | CHAR | 1 | XFELD | ||||
TBFLD | Table field (table name-field name) | BU_TBFLD | CHAR | 70 | CHAR70 | ||||
XTECH | Display technical field names | BU_XTECH | CHAR | 1 | XFELD | ||||
ABLSO | Change document sort sequence | BU_ABLSO | CHAR | 1 | BU_ABLSO | ||||
XALLG | Indicator: Display changes to general data | BU_XALLG | CHAR | 1 | XFELD | ||||
ABFLD | Table field for which changes should be displayed | BU_ABFLD | CHAR | 61 | CHAR61 | ||||
FLDSTAT | Field status (req. entry, opt. entry, display, hidden) | BU_FLDSTAT | CHAR | 1 | BU_FLDSTAT | ||||
INTSIZE | Maximum number of partners per interval | BU_INTSIZE | NUMC | 6 | NUMC06 | ||||
INTNMBR | Number of intervals | BU_INTNMBR | INT4 | 10 | INT4 | ||||
DESCRIP | Short name of business partner | BU_DESCRIP | CHAR | 50 | BU_TEXT50 | ||||
DESCRIP_LONG | Description of a Business Partner | BU_DESCRIP_LONG | CHAR | 80 | CHAR80 | ||||
ACTIVIT | Screen title: Activity-dependent part | BU_ACTIVIT | CHAR | 30 | CHAR30 | ||||
CHAR1 | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
SEXID | Sex of business partner (person) | BU_SEXID | CHAR | 1 | BU_SEXID | ||||
POSTXT_BK | Item details for tabular entries | BU_POSTXT | CHAR | 25 | TEXT25 | ||||
POSTXT_CC | Item details for tabular entries | BU_POSTXT | CHAR | 25 | TEXT25 | ||||
POSTXT_ID | Item details for tabular entries | BU_POSTXT | CHAR | 25 | TEXT25 | ||||
POSTXT_IS | Item details for tabular entries | BU_POSTXT | CHAR | 25 | TEXT25 | ||||
POSTXT_US | Item details for tabular entries | BU_POSTXT | CHAR | 25 | TEXT25 | ||||
POSTXT_TX | Item details for tabular entries | BU_POSTXT | CHAR | 25 | TEXT25 | ||||
COUNTER1 | Integer 1 | INTEGER1 | INT1 | 3 | INT1 | ||||
DTITL | Title of screen | BU_DTITL2 | CHAR | 30 | TEXT30 | ||||
FCDTL | GUI Function Code | BU_FCODE | CHAR | 20 | Assigned to domain | BU_FCODE | |||
TITLE_MEDI | Title text | AD_TITLETX | CHAR | 30 | TEXT30 | ||||
PREFIX_TX1 | Name prefix | AD_PREFIXT | CHAR | 20 | TEXT20 | ||||
PREFIX_TX2 | Name prefix | AD_PREFIXT | CHAR | 20 | TEXT20 | ||||
TTLACA_TX1 | Academic Title: Written Form | AD_TITLE1T | CHAR | 20 | TEXT20 | ||||
TTLACA_TX2 | 2nd academic title: written form | AD_TITLE2T | CHAR | 20 | TEXT20 | ||||
TTLRYL_TXT | Name supplement, e.g. noble title (written form) | AD_TITLEST | CHAR | 20 | TEXT20 | ||||
BIRTHDT | Date of Birth of Business Partner | BU_BRTHSTR | CHAR | 10 | CHAR10 | ||||
DEATHDT | Date of death of business partner | BU_DEATSTR | CHAR | 10 | CHAR10 | ||||
BKDSC | Name of bank | BU_BKDSC | CHAR | 100 | CHAR100 | ||||
ADDSC | BP: Address Description | BU_ADDSC | CHAR | 60 | TEXT60 | ||||
MOVE_ADDSC | BP: Description of Move Address | BU_MOVE_ADDSC | CHAR | 60 | TEXT60 | ||||
SCSL0 | Screen selection as for application object | BU_SCSL0 | CHAR | 1 | CHAR1 | ||||
SCSL1 | Display screen selection | BU_SCSL1 | CHAR | 1 | CHAR1 | ||||
SCSL2 | Do not display screen selection | BU_SCSL2 | CHAR | 1 | CHAR1 | ||||
ADSTN | Use Standard Address | BU_ADSTN | CHAR | 1 | XFELD | ||||
ADFIX | Use fixed address | BU_ADFIX | CHAR | 1 | XFELD | ||||
ADREFTYP | Address Reference Category | BU_ADREFTYP | CHAR | 30 | TEXT30 | ||||
VALDT | Validity Date of Changes | BU_VALSTR | CHAR | 10 | CHAR10 | ||||
CTTAX | Country Name | LANDX | CHAR | 15 | TEXT15 | ||||
CTDSC | Country Name | LANDX | CHAR | 15 | TEXT15 | ||||
CTNAM | Country Name | LANDX | CHAR | 15 | TEXT15 | ||||
ADEXT | Address number in external system | BU_ADEXT | CHAR | 20 | BU_ADEXT | ||||
TXT50 | Text Field | TEXT50 | CHAR | 50 | TEXT50 | ||||
NATIO | Nationality | NATIO | CHAR | 15 | TEXT15 | ||||
LANGU_CORR | Name of Language | SPTXT | CHAR | 16 | SPTXT16 | DSB | |||
VALUE | Comment | CHAR50 | CHAR | 50 | TEXT50 | ||||
COMREG_DAT | Business partner: Entry in trade register | BU_CREGDATSTR | CHAR | 10 | CHAR10 | ||||
FOUND_DAT | Date Organization Founded | BU_FOUNDDATSTR | CHAR | 10 | CHAR10 | ||||
LIQUID_DAT | Business partner: Liquidation date of organization | BU_LIQUDATSTR | CHAR | 10 | CHAR10 | ||||
DATAB | Payment cards: Valid from | BU_DATABSTR | CHAR | 10 | CHAR10 | ||||
DATBI | Payment Cards: Valid To | BU_DATBISTR | CHAR | 10 | CHAR10 | ||||
AUSGDAT | Payment Cards: Date of Issue | BU_AUSGDATSTR | CHAR | 10 | CHAR10 | ||||
ROLE | BP role | BU_ROLE | CHAR | 6 | Assigned to domain | BU_RLTYP | BUPA_ROLE | ||
RLGRP | BP role grouping | BU_RLGRP | CHAR | 6 | Assigned to domain | BU_RLTGR | |||
OBJECTID | BDT object where-used list: Object identification name | BU_OBJECTID | CHAR | 200 | CHAR200 | ||||
SUB_GRP | BDT object where-used list: Sort in application table | BU_SUBGRP | CHAR | 40 | TEXT40 | ||||
NODE_BEZ | Description | BU_BEZ50 | CHAR | 50 | TEXT50 | ||||
MAXSEL | Maximum number of selected entries | BU_MAXSEL | INT4 | 10 | |||||
TIMEOUT | Maximum search time [s] | BU_TIMEOUT | NUMC | 4 | NUMC4 | ||||
ALVVAR | Layout | SLIS_VARI | CHAR | 12 | SLIS_VARI | ||||
LOCATION_1 | Business partner: International location number part 1 (DI) | BU_LOCATION1STR | CHAR | 7 | CHAR7 | ||||
LOCATION_2 | Business partner: International location number part 2 (DI) | BU_LOCATION2STR | CHAR | 5 | CHAR5 | ||||
LOCATION_3 | Business partner: International location number part 3 (DI) | BU_LOCATION3STR | CHAR | 1 | CHAR1 | ||||
USERNAME | User Name | SYUNAME | CHAR | 12 | SYCHAR12 | ||||
EMPLOYEE_ID | Personnel Number | BU_PERNO | NUMC | 8 | PERSONID | ||||
LANGU | Business partner: Language | BU_LANGUSTR | CHAR | 2 | CHAR2 | ||||
LANGUCORR | Business Partner: Correspondence Language | BU_LANGUCORRSTR | CHAR | 2 | CHAR2 | ||||
LANGU_TEXT | Name of Language | SPTXT | CHAR | 16 | SPTXT16 | DSB | |||
POSTXT_ROLES | Item details for tabular entries | BU_POSTXT | CHAR | 25 | TEXT25 | ||||
CONTACT_BEZ | Description | BU_BEZ50 | CHAR | 50 | TEXT50 | ||||
CONTACT | Business Partner: Contact Permission | BU_CONTACT_CHAR | CHAR | 1 | CHAR1 | ||||
FCODE_ACTVT | Activate via Activity, View and Screen Sequence Category | BU_FCODE_ACTVT | CHAR | 1 | CHAR1 | ||||
FCODE_FLDGR | Activate via Status of Field Group | BU_FCODE_FLDGR | CHAR | 1 | CHAR1 | ||||
APPLI | Application | BU_APPLI | CHAR | 4 | TBZ0A | BU_APPLI | |||
TABNM | Table Name | TABNAME | CHAR | 30 | TBZ1H | AS4TAB | DTB | ||
USER_CLASS_TEXT | Texts in user master/authorizations | XUTEXT | CHAR | 60 | XUTEXT | XUT | |||
USER_LANGU | Business Partner: User Logon Language | BU_USER_LANGUSTR | CHAR | 2 | CHAR2 | ||||
USER_LANGU_TEXT | Name of Language | SPTXT | CHAR | 16 | SPTXT16 | DSB | |||
DCPFM | Decimal Format | XUDCPFM | CHAR | 1 | XUDCPFM | ||||
DCPFMX | Decimal Format | XUDCPFM | CHAR | 1 | XUDCPFM | ||||
DCPFMY | Decimal Format | XUDCPFM | CHAR | 1 | XUDCPFM | ||||
DATFM1 | Date format | XUDATFM | CHAR | 1 | XUDATFM | ||||
DATFM2 | Date format | XUDATFM | CHAR | 1 | XUDATFM | ||||
DATFM3 | Date format | XUDATFM | CHAR | 1 | XUDATFM | ||||
DATFM4 | Date format | XUDATFM | CHAR | 1 | XUDATFM | ||||
DATFM5 | Date format | XUDATFM | CHAR | 1 | XUDATFM | ||||
DATFM6 | Date format | XUDATFM | CHAR | 1 | XUDATFM | ||||
BK_VALID_FROM | Validity Start of Business Partner Bank Details | BU_BK_VALID_FROM_STR | CHAR | 10 | CHAR10 | ||||
BK_VALID_TO | Valid to Date of BP Bank Details | BU_BK_VALID_TO_STR | CHAR | 10 | CHAR10 | ||||
BKU_VALID_FROM | Valid From Date of a BP Bank Details Usage | BU_BKU_VALID_FROM_STR | CHAR | 10 | CHAR10 | ||||
BKU_VALID_TO | Valid to Date of a BP Bank Details Usage | BU_BKU_VALID_TO_STR | CHAR | 10 | CHAR10 | ||||
ADDR_VALID_FROM | Valid From Date of a BP Address | BU_ADDR_VALID_FROM_STR | CHAR | 10 | CHAR10 | ||||
ADDR_VALID_TO | Validity End of a BP Address | BU_ADDR_VALID_TO_STR | CHAR | 10 | CHAR10 | ||||
ADVW_VALID_FROM | Validity Start of a BP Address Usage | BU_ADVW_VALID_FROM_STR | CHAR | 10 | CHAR10 | ||||
ADVW_VALID_TO | Validity End of a BP Address Usage | BU_ADVW_VALID_TO_STR | CHAR | 10 | CHAR10 | ||||
BK_MOVE_DATE | Date of Change to Bank Details (BP) | BU_BK_MOVE_DATE_STR | CHAR | 10 | CHAR10 | ||||
ADDR_MOVE_DATE | Date of Move for Address Moves | BU_AD_MOVE_DATE_STR | CHAR | 10 | CHAR10 | ||||
BU_SORT | Search term 1 for business partner | BU_SORT1 | CHAR | 20 | BU_SORT1 | ||||
DESCRIP_BKVID | Short Description of Business Partner Bank Details | BU_DESCRIP_BKVID | CHAR | 140 | CHAR140 | ||||
BU_SORT1_TXT | Search Term 1 for Business Partner | BU_SORT1_TXT | CHAR | 20 | TEXT20 | ||||
BU_SORT2_TXT | Search Term 2 for Business Partner | BU_SORT2_TXT | CHAR | 20 | TEXT20 | ||||
PRINT_MODE_TEXT | Text for Print Format | BU_PRINT_MODE_TEXT | CHAR | 60 | TEXT60 |
Key field | Non-key field |
How do I retrieve data from SAP structure BUS000FLDS using ABAP code?
As BUS000FLDS 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 BUS000FLDS as there is no data to select.How to access SAP table BUS000FLDS
Within an ECC or HANA version of SAP you can also view further information about BUS000FLDS 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