SAP TCMS_BII_DEXPR CMS-Basel II: Data Extraction Process Settings Table data and field list

TCMS_BII_DEXPR is a standard SAP Table which is used to store CMS-Basel II: Data Extraction Process Settings data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The TCMS_BII_DEXPR table consists of various fields, each holding specific information or linking keys about CMS-Basel II: Data Extraction Process Settings data available in SAP. These include DEX_PR_TYPE (CMS-Basel II: Data Extraction Process Type), OBJ_CAT (CMS-Basel II: Data Extraction Object Category), ALE_MSG_TYP (Message Type), PORT (Receiver port (SAP System, EDI subsystem))... 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. .

TCMS_BII_DEXPR table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

Text table = TCMS_BII_DEXPR_T

SAP TCMS_BII_DEXPR table 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 TCMS_BII_DEXPR 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
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
DEX_PR_TYPE	CMS-Basel II: Data Extraction Process Type	CMS_DTE_BII_DEX_PR_TYP	CHAR	4			CMS_BII_DEX_TYPE		CMS_BII_DEX_PR_TYP
OBJ_CAT	CMS-Basel II: Data Extraction Object Category	CMS_DTE_BII_DEX_OBJ_CAT	NUMC	2			CMS_BII_DEX_OBJ_CAT
ALE_MSG_TYP	Message Type	EDI_MESTYP	CHAR	30	Assigned to domain		EDI_MESTYP	MES
PORT	Receiver port (SAP System, EDI subsystem)	EDI_RCVPOR	CHAR	10			EDI_PORT
PARTNER_TYP	Partner Type of Receiver	EDI_RCVPRT	CHAR	2			EDI_PARTYP
PARTNER_NUM	Partner Number of Receiver	EDI_RCVPRN	CHAR	10	Assigned to domain	ALPHA	EDI_PARNUM
APPL_LOG_OBJ	Application Log: Object Name (Application Code)	BALOBJ_D	CHAR	20	Assigned to domain		BALOBJ	BALOBJ
APPL_LOG_SUB_OBJ	Application Log: Subobject	BALSUBOBJ	CHAR	20	Assigned to domain		BALSUBOBJ	BALSUBOBJ
DEF_BLK_SIZE	CMS-Basel II: Data Extraction Block Size	CMS_DTE_BII_DEX_BLK_SIZE	INT4	10			TABIX
COLL_VAL_TYP	CMS-Basel II: Collateral Value type selection Indicator	CMS_DTE_BII_COLL_VAL_TYP	NUMC	2			CMS_BII_COLL_VAL_TYP

Key field

Non-key field

< TCMS_BDT_V_PL - Plausibility checks for view TCMS_BII_DEXPR_T - CMS-Basel II: Data Extraction Process Settings ( Text Table) >

How do I retrieve data from SAP table TCMS_BII_DEXPR using ABAP code

The following ABAP code Example will allow you to do a basic selection on TCMS_BII_DEXPR to SELECT all data from the table
DATA: WA_TCMS_BII_DEXPR TYPE TCMS_BII_DEXPR.

SELECT SINGLE *
FROM TCMS_BII_DEXPR
INTO CORRESPONDING FIELDS OF WA_TCMS_BII_DEXPR
WHERE...

How to access SAP table TCMS_BII_DEXPR

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

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