SAP BBP_CFX_TS_ORG_DATA Organizational Data Table data and field list

BBP_CFX_TS_ORG_DATA 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 "Organizational Data" 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_BBP_CFX_TS_ORG_DATA TYPE BBP_CFX_TS_ORG_DATA.

The BBP_CFX_TS_ORG_DATA table consists of various fields, each holding specific information or linking keys about Organizational Data 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)), SEARCHTERM1 (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. .

BBP_CFX_TS_ORG_DATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP BBP_CFX_TS_ORG_DATA 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 BBP_CFX_TS_ORG_DATA 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
COMPANY_IDGlobally Unique identifier BBP_GUIDRAW16SYSUUID
PARTNERBusiness 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
SEARCHTERM1Search term 1 for business partner BU_SORT1CHAR20BU_SORT1
SEARCHTERM2Search term 2 for business partner BU_SORT2CHAR20BU_SORT1
PARTNERCATEGORYBusiness partner category BU_TYPECHAR1BU_TYPEBPY
CITY1City name in upper case for search help AD_MC_CITYCHAR25CHAR25
POSTL_COD1City postal code AD_PSTCD1CHAR10CHAR10
COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
COUNTRYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
STREETStreet name in upper case for search help AD_MC_STRTCHAR25CHAR25
HOUSE_NOHouse Number AD_HSNM1CHAR10TEXT10
EXT_ORG_NUMBERBusiness Partner Number in External System BU_BPEXTCHAR20CHAR20
IS_INTERNALInternal Organization BBP_CFX_INTERNAL_COMPANYCHAR1BOOLEAN

Key field Non-key field



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

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

How to access SAP table BBP_CFX_TS_ORG_DATA

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

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