AUAT SAP (Settlement Document: Totals Segment Per Period) Cluster Table details
Dictionary Type: Cluster Table
Description: Settlement Document: Totals Segment Per Period
Description: Settlement Document: Totals Segment Per Period
Cluster Table field list including key, data, relationships and ABAP select examples
AUAT is a standard SAP Cluster Table which is used to store Settlement Document: Totals Segment Per Period data and is available within R/3 SAP systems depending on the version and release level.
The AUAT table consists of various fields, each holding specific information or linking keys about Settlement Document: Totals Segment Per Period data available in SAP. These include BELNR (Number of a settlement document), PERIO (Settlement Period), LFDNR (Sequence number), VRGNG (CO Business Transaction).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP AUAT cluster table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| BELNR | Number of a settlement document | AA_BELNR | CHAR | 10 | AUAK | ALPHA | AA_BELNR | BLN | |
| PERIO | Settlement Period | ABR_PERIO | NUMC | 3 | PERBL | 74P | |||
| LFDNR | Sequence number | LFDNR5 | NUMC | 5 | NUMC5 | ||||
| VRGNG | CO Business Transaction | CO_VORGANG | CHAR | 4 | TJ01 | J_VORGANG | |||
| PERBZ | Settlement type | PERBZ | CHAR | 3 | PERBZ | ||||
| PLFNR | Sequence number of primary assignment | BR_TLFNR | NUMC | 4 | NUMC4 | ||||
| SLFNR | Sequence number of secondary assignment | BR_SLFNR | NUMC | 4 | NUMC4 | ||||
| KSTAR | Cost Element | KSTAR | CHAR | 10 | CSKA | ALPHA | KSTAR | KAT | |
| TWAER | Transaction Currency | TWAER | CUKY | 5 | TCURC | WAERS | FWS | ||
| MEINH | Unit of Measure | CO_MEINH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| KLFNR | Current Key Number | BR_KLFNR | NUMC | 5 | NUMC5 | ||||
| ERZUO | PA Transfer structure assignment | ERZUO | CHAR | 3 | TKB9C | ALPHA | ERZUO | ||
| BELTP | Debit type | BP_INOUT | NUMC | 1 | BP_INOUT | ||||
| SC_RECID | Sender Clearing Recovery Indicator | SC_RECID | CHAR | 2 | T8JJ | ALPHA | JV_RECIND | ||
| RD_RECID | Receiver Debit Recovery Indicator | RD_RECID | CHAR | 2 | T8JJ | ALPHA | JV_RECIND | ||
| WTGBTR | Total Value in Transaction Currency | WTGXXX | CURR | 15(2) | WERTV8 | ||||
| WOGBTR | Total Value in Object Currency | WOGXXX | CURR | 15(2) | WERTV8 | ||||
| WKGBTR | Total Value in Controlling Area Currency | WKGXXX | CURR | 15(2) | WERTV8 | ||||
| WKFBTR | Fixed Value in Controlling Area Currency | WKFXXX | CURR | 15(2) | WERTV8 | ||||
| PAGBTR | Total Price Variance in CO Area Currency | PAGXXX | CURR | 15(2) | WERTV8 | ||||
| PAFBTR | Fixed Price Variance in CO Area Currency | PAFXXX | CURR | 15(2) | WERTV8 | ||||
| MEGBTR | Total Quantity | MEGXXX | QUAN | 15(3) | MENGV8 | ||||
| MEFBTR | Fixed Quantity | MEFXXX | QUAN | 15(3) | MENGV8 | ||||
| WKSBTR | Sender-Independent Value in Controlling Area Currency | WKSXXX | CURR | 15(2) | WERTV8 | ||||
| MESBTR | Total quantity (sender) | MESXXX | QUAN | 15(3) | MENGV8 | ||||
| PASBTR | Fixed Price Variance in CO Area Currency | PAFXXX | CURR | 15(2) | WERTV8 |
| Key field | Non-key field |
How do I retrieve data from SAP table AUAT using ABAP code
The following ABAP code Example will allow you to do a basic selection on AUAT to SELECT all data from the tableDATA: WA_AUAT TYPE AUAT.
SELECT SINGLE *
FROM AUAT
INTO CORRESPONDING FIELDS OF WA_AUAT
WHERE...
How to access SAP table AUAT
Within an ECC or HANA version of SAP you can also view further information about AUAT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects