The CDATA table in SAP ERP or S/4HANA stores Change Data data. There are total 10 fields in CDATA table. The Change Data 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 CDATA table. It is in Calculation of Planned Delivery Time (WPDTC) ABAP package and is part of the Vendor Master (LO-MD-BP-VM) module.
SAP CDATA Table Fields
Following is the list of fields that are available in SAP CDATA table. The primary key fields of the table are MANDANT (Client), TRANS_CODE (Transaction in which a change was made), TABLE_NAME (Table Name), COLUMN_NAME (Field Name), USER_NAME (User name of the person responsible in change document), DATE_STAMP (Creation date of the change document), TIME_STAMP (Time changed), TABLE_KEY (Changed table record key).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDANT | Client | MANDT | * | CLNT (3) |
| TRANS_CODE | Transaction in which a change was made | CDTCODE | * | CHAR (20) |
| TABLE_NAME | Table Name | TABNAME | * | CHAR (30) |
| COLUMN_NAME | Field Name | FIELDNAME | * | CHAR (30) |
| USER_NAME | User name of the person responsible in change document | CDUSERNAME | CHAR (12) | |
| DATE_STAMP | Creation date of the change document | CDDATUM | DATS (8) | |
| TIME_STAMP | Time changed | CDUZEIT | TIMS (6) | |
| TABLE_KEY | Changed table record key | CDTABKEY | CHAR (70) | |
| NEW_VALUE | New contents of changed field | CDFLDVALN | CHAR (254) | |
| OLD_VALUE | Old contents of changed field | CDFLDVALO | CHAR (254) |
