AT19 is a standard SAP table in SAP ERP (or) S/4HANA which stores Supplements to Flow Types data. There are total 19 fields in AT19 table.This blog post provides key technical details of SAP table AT19, including its availability across SAP S/4HANA versions and the list of CDS views for AT19 table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering switched on |
| Buffering Type | Full buffering as specified by generic key |
| Package | R/3 appl. development for Treasury money,forex,forward gen (FTA) |
| Technical Component | Transaction Manager (FIN-FSCM-TRM-TM) |
SAP AT19 Table Fields
The following is the list of fields that are available in SAP AT19 table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT (3) |
| RANTYP | Contract Type | RANTYP | RANTYP | CHAR (1) | |
| SBEWART | Flow Type | SBEWART | SBEWART | TZB0A | CHAR (4) |
| SBKKLAS | Classification of Flows and Conditions | TB_SBKKLAS | T_SBKKLAS | CHAR (1) | |
| SBKTYP | Category of Flows and Conditions | TB_SBKTYP | T_SBKTYP | AT08 | CHAR (2) |
| SBESTAND | Flow Relevant to Position | TB_SBSTAND | XFELD | CHAR (1) | |
| SERFOLG | Flow Is Relevant to Profit/Loss | TB_SERFOLG | XFELD | CHAR (1) | |
| SBWRTNG | Flow Is Relevant to Valuation | TB_SBWRTNG | XFELD | CHAR (1) | |
| SABGRZG | Flow is relevant for accrual/deferral | TB_SABGRZG | XFELD | CHAR (1) | |
| SABGV | Accrual/deferral procedure | TB_SABGV | T_SABGV | CHAR (1) | |
| SABGM | Accrual/Deferral Method | TB_SABGM | T_SABGM | CHAR (1) | |
| SBAABA | Flow type for accrual | TB_SBAABA | SBEWART | TZB0A | CHAR (4) |
| SBAABAR | Flow type for reset of accrual | TB_SBAABAR | SBEWART | TZB0A | CHAR (4) |
| SBAABT | Flow type of deferral | TB_SBAABT | SBEWART | TZB0A | CHAR (4) |
| SBAABTR | Flow type of reset of deferral | TB_SBAABTR | SBEWART | TZB0A | CHAR (4) |
| SBAABG | Flow type of accrual/deferral flow | TB_SBAABG | SBEWART | TZB0A | CHAR (4) |
| SSUMREL | Indicator: Flow Is Relevant for Net Payment Amount | TB_SUMREL | XFELD | CHAR (1) | |
| SEARLYREP | Flow Is Relevant for Accrued Interest Calculation | TB_SEARLYREP | T_SEARLYREP | CHAR (1) | |
| SFEE | Fee Indicator | TB_SFEE | XFELD | CHAR (1) |
Availability
The SAP table AT19 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 AT19 table
The following is the list of AT19 CDS views, which can also be used instead of AT19 table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_CASHFLOWTYPE | BASIC | Cash Flow Type |
| I_FINTRANSFLOWTYPE | BASIC | Financial Transaction Flow Type |
| I_FINTRANSFEEFLOW | COMPOSITE | Fin Trans Flows Relevant For Fee |
| I_FINTRANSHISTLFCSTFEECUBE | COMPOSITE | Fin Trans Histl Fcst Fee – Cube |
| P_FINTRANSFEEFLOW | COMPOSITE | private view for filtering Fee Flow data |
| P_FINTRANSHISTLFCSTFEEFLOW | COMPOSITE | private view for combining historical and forecast fee data |
| P_FINTRANSNOMINTRATE | COMPOSITE | Nominal Flows with Applied Int.Rate |
| C_FINTRANSFCSTHISTLFEEQRY | CONSUMPTION | Fin. Trans.: Histl/Fcstd Fee Amt – Query |
