SAP CTBW Table – Characteristics for DataSources

The CTBW table in SAP ERP or S/4HANA stores Characteristics for DataSources data. There are total 7 fields in CTBW table. The Characteristics for DataSources table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CTBW table. It is in Classification System and SAP BW (CLBW) ABAP package and is part of the Environment (CA-CL-ENV) module.

SAP CTBW Table Fields

Following is the list of fields that are available in SAP CTBW table. The primary key fields of the table are INFOSOURCE (DataSource (OSOA/OSOD)), ATNAM (Characteristic Name).

Field Description Data Element Check Table Data Type
INFOSOURCE DataSource (OSOA/OSOD) ROOSOURCER CLBW_SOURCES CHAR (30)
ATNAM Characteristic Name ATNAM CHAR (30)
POSNR Position of Characteristic in Structure POSNR_CTBW NUMC (6)
STATUS Maintenance Status of Characteristic STATUS_CTBW CHAR (1)
ATTRSOURCE Attribute Source ATTRSOURCE CHAR (30)
IOBJTP Type of an InfoObject RSIOBJTP CHAR (3)
FIELDNM Field name RSFIELDNM CHAR (30)