TCMS_BII_DEXPR SAP table for – CMS-Basel II: Data Extraction Process Settings

Here we would like to draw your attention to TCMS_BII_DEXPR table in SAP. As we know it is being mainly used with the SAP FS-CMS (Collateral Management System in FS) component which is coming under FS module (Financial Services). TCMS_BII_DEXPR is a SAP standard transp table used for storing CMS-Basel II: Data Extraction Process Settings related data in SAP. It comes under the package CMS_BASEL.

SAP TCMS_BII_DEXPR table

Table TCMS_BII_DEXPR technical data

TableTCMS_BII_DEXPR
Data storingCMS-Basel II: Data Extraction Process Settings
ModuleFS
Sub ModuleFS-CMS-IS
SAP PackageCMS_BASEL
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentEA-FINSERV
Table CategoryTRANSP

SAP TCMS_BII_DEXPR Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in TCMS_BII_DEXPR table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • DEX_PR_TYPE : CMS-Basel II: Data Extraction Process Type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • OBJ_CAT : CMS-Basel II: Data Extraction Object Category
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • .INCLUDE : CMS-Basel II: Data Extraction Process Settings
  • ALE_MSG_TYP : Message Type
    Its data type is CHAR (Character String) with field length 30
  • PORT : Receiver port (SAP System, EDI subsystem)
    Its data type is CHAR (Character String) with field length 10
  • PARTNER_TYP : Partner Type of Receiver
    Its data type is CHAR (Character String) with field length 2
  • PARTNER_NUM : Partner Number of Receiver
    Its data type is CHAR (Character String) with field length 10
  • APPL_LOG_OBJ : Application log: Object name (Application code)
    Its data type is CHAR (Character String) with field length 20
  • APPL_LOG_SUB_OBJ : Application Log: Subobject
    Its data type is CHAR (Character String) with field length 20
  • DEF_BLK_SIZE : CMS-Basel II: Data Extraction Block Size
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • COLL_VAL_TYP : CMS-Basel II: Collateral Value type selection Indicator
    Its data type is NUMC (Character String with Digits Only) with field length 2