SAP ADJT_TRANSACTION Treasury: Reconciliation business transactions Table
Overview
ADJT_TRANSACTION is a standard SAP S/4HANA table that stores Treasury: Reconciliation business transactions data. There are total 11 fields in the ADJT_TRANSACTION table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ADJT_TRANSACTION belongs to Transfer to Financial Accounting (FIN-FSCM-TRM-TM-AC) module and is located in the package Treasury: Reconciliation Business Transactions (FTR_ADJUSTMENT).
In addition, following links provide an overview of foreign key relationships, if any, that link ADJT_TRANSACTION to other SAP tables and standard CDS views available based on ADJT_TRANSACTION table in S/4HANA 2020.
Techincal Settings of ADJT_TRANSACTION
Below are technical details of the table ADJT_TRANSACTION
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ADJT_TRANSACTION Fields
The following table gives you an overview of the fields available in ADJT_TRANSACTION
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| 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 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ADJT_TRANSACTION
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| ADJT_TRANSACTION | IDENTIFIER_OID | : | DIFT_POS_IDENT |