The ADJT_TRANSACTION table in SAP ERP or S/4HANA stores Treasury: Reconciliation business transactions data. There are total 11 fields in ADJT_TRANSACTION table. The Treasury: Reconciliation business transactions 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 ADJT_TRANSACTION table. It is in Treasury: Reconciliation Business Transactions (FTR_ADJUSTMENT) ABAP package and is part of the Transfer to Financial Accounting (FIN-FSCM-TRM-TM-AC) module.
SAP ADJT_TRANSACTION Table Fields
Following is the list of fields that are available in SAP ADJT_TRANSACTION table. The primary key fields of the table are MANDT (Client), OS_GUID (Object Identity in Database Format).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| OS_GUID | Object Identity in Database Format | TPM_DB_OS_GUID | CHAR (32) | |
| USER_DATA_CLS | Object Identity in Database Format | TPM_DB_OS_GUID | CHAR (32) | |
| USER_DATA_OID | Object Identity in Database Format | TPM_DB_OS_GUID | CHAR (32) | |
| IDENTIFIER_CLS | Object Identity in Database Format | TPM_DB_OS_GUID | CHAR (32) | |
| IDENTIFIER_OID | Object Identity in Database Format | TPM_DB_OS_GUID | DIFT_POS_IDENT | CHAR (32) |
| ADJUSTMENT_CAT | Treasury: Reconciliation Category | TPM_ADJUSTMENT_CAT | CHAR (4) | |
| BUSTRANSID | Identifier of the Distributor Business Transaction | TPM_BUSTRANSID | RAW (16) | |
| POSTING_STATE | Update Status of a Reconciliation Business Transaction | TPM_ADJTRANSTATE | CHAR (1) | |
| ADJUSTMENT_DATE | Reconciliation Key Date | TPM_ADJUSTMENT_DATE | DATS (8) | |
| DIST_FLOWTYPE | Update Type | TPM_DIS_FLOWTYPE | * | CHAR (8) |
