SAP CFX_ORG_TS_DATA Organizational Data Table data and field list

CFX_ORG_TS_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_CFX_ORG_TS_DATA TYPE CFX_ORG_TS_DATA.

The CFX_ORG_TS_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. .

CFX_ORG_TS_DATA structure Technical Details:

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

SAP CFX_ORG_TS_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 CFX_ORG_TS_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_ID	Business Partner GUID	BU_PARTNER_GUID	RAW	16			SYSUUID
PARTNER	Business Partner Number	BU_PARTNER	CHAR	10	Assigned to domain	ALPHA	BU_PARTNER	BPA	BUPA
MC_NAME1	Search Help Field 1 (Name 1/Last Name)	BU_MCNAME1	CHAR	35			CHAR35
MC_NAME2	Search Help Field 2 (Name 2/First Name)	BU_MCNAME2	CHAR	35			CHAR35
SEARCHTERM1	Search term 1 for business partner	BU_SORT1	CHAR	20			BU_SORT1
SEARCHTERM2	Search term 2 for business partner	BU_SORT2	CHAR	20			BU_SORT1
PARTNERCATEGORY	Business partner category	BU_TYPE	CHAR	1			BU_TYPE	BPY
CITY1	City name in upper case for search help	AD_MC_CITY	CHAR	25			CHAR25
POSTL_COD1	City postal code	AD_PSTCD1	CHAR	10			CHAR10
COUNTRY	Country Key	LAND1	CHAR	3	Assigned to domain		LAND1	LND
COUNTRYISO	Country ISO code	INTCA	CHAR	2			INTCA		F4_INTCA
REGION	STATE (State, Province, County)	REGIO	CHAR	3	Assigned to domain		REGIO
STREET	Street name in upper case for search help	AD_MC_STRT	CHAR	25			CHAR25
HOUSE_NO	House Number	AD_HSNM1	CHAR	10			TEXT10
EXT_ORG_NUMBER	Business Partner Number in External System	BU_BPEXT	CHAR	20			CHAR20
IS_INTERNAL	Internal Organization	CFX_ORG_INTERNAL	CHAR	1			CFX_BOOLEAN

Key field

Non-key field

< CFX_ORG_TS_ACTIONS - Determine Organization CFX_ORG_TS_DETAIL - Detailed Data for Organization >

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

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

How to access SAP table CFX_ORG_TS_DATA

Within an ECC or HANA version of SAP you can also view further information about CFX_ORG_TS_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).