Sunday, May 19, 2024

SAP Table ADJT_TRANSACTION – Treasury: Reconciliation business transactions

ADJT_TRANSACTION is a standard SAP table in SAP ECC (or) S/4HANA which stores Treasury: Reconciliation business transactions data. There are total 11 fields in ADJT_TRANSACTION table.This blog post provides key technical details of SAP table ADJT_TRANSACTION, including its availability across SAP S/4HANA versions and the list of CDS views for ADJT_TRANSACTION table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package Treasury: Reconciliation Business Transactions (FTR_ADJUSTMENT)
Technical Component Transfer to Financial Accounting (FIN-FSCM-TRM-TM-AC)

SAP ADJT_TRANSACTION Table Fields

The following is the list of fields that are available in SAP ADJT_TRANSACTION table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
MANDT Client MANDT MANDT * CLNT (3)
OS_GUID Object Identity in Database Format TPM_DB_OS_GUID TPM_DB_OS_GUID CHAR (32)
USER_DATA_CLS Object Identity in Database Format TPM_DB_OS_GUID TPM_DB_OS_GUID CHAR (32)
USER_DATA_OID Object Identity in Database Format TPM_DB_OS_GUID TPM_DB_OS_GUID CHAR (32)
IDENTIFIER_CLS Object Identity in Database Format TPM_DB_OS_GUID TPM_DB_OS_GUID CHAR (32)
IDENTIFIER_OID Object Identity in Database Format TPM_DB_OS_GUID TPM_DB_OS_GUID DIFT_POS_IDENT CHAR (32)
ADJUSTMENT_CAT Treasury: Reconciliation Category TPM_ADJUSTMENT_CAT TPM_ADJUSTMENT_CAT CHAR (4)
BUSTRANSID Identifier of the Distributor Business Transaction TPM_BUSTRANSID SYSUUID RAW (16)
POSTING_STATE Update Status of a Reconciliation Business Transaction TPM_ADJTRANSTATE TPM_ADJTRANSTATE CHAR (1)
ADJUSTMENT_DATE Reconciliation Key Date TPM_ADJUSTMENT_DATE TPM_ADJUSTMENT_DATE DATS (8)
DIST_FLOWTYPE Update Type TPM_DIS_FLOWTYPE TPM_DIS_FLOWTYPE * CHAR (8)

Availability

The SAP table ADJT_TRANSACTION is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Available?
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for ADJT_TRANSACTION table

There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.