AT06 is a standard SAP table in SAP ERP (or) S/4HANA which stores Allocation of Processing Categories to Activity Categories data. There are total 8 fields in AT06 table.This blog post provides key technical details of SAP table AT06, including its availability across SAP S/4HANA versions and the list of CDS views for AT06 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 AT06 Table Fields
The following is the list of fields that are available in SAP AT06 table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| SANLF | Product Category | SANLF | VVSANLF | TZAF | NUMC (3) |
| ABWTYP | Processing Category | TB_ABWTYP | T_ABWTYP | AT05 | CHAR (5) |
| SFGTYP | Transaction Category | TB_SFGTYP | T_SFGTYP | AT01 | NUMC (3) |
| SFGZUSTT | Transaction Activity Category | TB_SFGZUTY | T_SFGZUTY | AT02 | NUMC (2) |
| LFDNR | Sequence (Numbers) | TB_LFDNR | T_LFDNR2 | NUMC (2) | |
| SEBENE | Posting Status of Activity | TB_SFGZUEB | T_SBEWEBE | CHAR (1) | |
| LVORGTYP | Indicator: no further activity transition permitted | TB_LVORGT | XFELD | CHAR (1) | |
| NNSTUFE | Level Number of Next Activity Category | TB_NNSTUFE | T_LFDNR2 | NUMC (2) |
Availability
The SAP table AT06 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 AT06 table
The following is the list of AT06 CDS views, which can also be used instead of AT06 table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| R_FINTRANSCASHFLOWACTIVITY | BASIC | Financial Transaction Cash Flow Activity |
| I_FINTRANSAMOUNT | COMPOSITE | Fin Trans Amt with ProdGrp and BkGrp |
| I_FINTRANSAMTCUBE | COMPOSITE | Fin Trans Amt – Cube |
| I_FINTRANSCNDNFMLAVARBL | COMPOSITE | Fin Trans Condition Formula Variable |
| I_FINTRANSCNDNSCALE | COMPOSITE | Fin Trans Condition Scaled Interest |
| I_FINTRANSCNDNSINGLEDATE | COMPOSITE | Fin Trans Condition Single Date |
| I_FINTRANSCONDITION | COMPOSITE | Financial Transaction Condition |
| I_FINTRANSFEEFLOW | COMPOSITE | Fin Trans Flows Relevant For Fee |
| I_FINTRANSFLOW | COMPOSITE | Financial Transaction Flow |
| I_FINTRANSHISTLFCSTFEECUBE | COMPOSITE | Fin Trans Histl Fcst Fee – Cube |
| I_FINTRANSINTEREST | COMPOSITE | Fin Trans Interest Information |
| I_FINTRANSNOMINAL | COMPOSITE | Fin Trans Nominal Amount |
| I_FINTRANSSECURITY | COMPOSITE | Fin Trans Securities Information |
| P_FINTRANSBUSVOLONBANKGROUP | COMPOSITE | Combined Business Volume for Fin Trans |
| P_FINTRANSFEEFLOW | COMPOSITE | private view for filtering Fee Flow data |
| P_FINTRANSHISTLFCSTFEEFLOW | COMPOSITE | private view for combining historical and forecast fee data |
| P_FINTRANSOPENFLOWBUSVOL | COMPOSITE | The Business Volume for Open Trans Flow |
| P_FINTRANSSUMBUSVOL | COMPOSITE | Business Volume sum for Fin Trans |
| C_FINTRANSAMTQRY | CONSUMPTION | Financial Transaction Amount – Query |
| C_FINTRANSFCSTHISTLFEEQRY | CONSUMPTION | Fin. Trans.: Histl/Fcstd Fee Amt – Query |
| C_FINTRANSSINGLEDAYAMTQRY | CONSUMPTION | Fin. Trans. Amt on Single Date – Query |
