SAP table AUAT (Settlement Document: Totals Segment Per Period)

SAP table AUAT has 4 primary key fields being MANDT,BELNR,PERIO,LFDNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BELNR Number of a Settlement Document CHAR 10 0 AUAK AA_BELNR
PERIO Settlement Period NUMC 3 0 ABR_PERIO
LFDNR Sequence Number NUMC 5 0 LFDNR5
VRGNG CO Business Transaction CHAR 4 0 TJ01 CO_VORGANG
PERBZ Settlement Type CHAR 3 0 PERBZ
AUT Automatic Settlement
EPA Line Item Settlement
GES Full Settlement
JHR Capitalization in AUC
PER Periodic Settlement
VOR Preliminary Settlement
PLFNR Sequence Number of Primary Assignment NUMC 4 0 BR_TLFNR
SLFNR Sequence Number of Secondary Assignment NUMC 4 0 BR_SLFNR
KSTAR Cost Element CHAR 10 0 CSKA KSTAR
TWAER Transaction Currency CUKY 5 0 TCURC TWAER
MEINH Unit of Measure UNIT 3 0 T006 CO_MEINH
KLFNR Current Key Number NUMC 5 0 BR_KLFNR
ERZUO PA Transfer Structure Assignment CHAR 3 0 TKB9C ERZUO
BELTP Debit Type NUMC 1 0 BP_INOUT
0
1 Costs and credit-side payments
2 Revenues and debit-side payments
SC_RECID Sender Clearing Recovery Indicator CHAR 2 0 T8JJ SC_RECID
RD_RECID Receiver Debit Recovery Indicator CHAR 2 0 T8JJ RD_RECID
WTGBTR Total Value in Transaction Currency CURR 23 2 WTGXXX
WOGBTR Total Value in Object Currency CURR 23 2 WOGXXX
WKGBTR Total Value in Controlling Area Currency CURR 23 2 WKGXXX
WKFBTR Fixed Value in Controlling Area Currency CURR 23 2 WKFXXX
PAGBTR Total Price Variance in CO Area Currency CURR 23 2 PAGXXX
PAFBTR Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX
MEGBTR Total Quantity QUAN 15 3 MEGXXX
MEFBTR Fixed Quantity QUAN 15 3 MEFXXX
WKSBTR Sender-Independent Value in Controlling Area Currency CURR 23 2 WKSXXX_CO
MESBTR Total quantity (sender) QUAN 15 3 MESXXX
PASBTR Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX

AUAT foreign key relationships

Table Field Check Table Check Field
0 AUAT BELNR AUAK Document Header for Settlement BELNR
1 AUAT ERZUO TKB9C Assignment in PA Transfer Structures MANDT
0 AUAT KSTAR CSKA Cost Elements (Data Dependent on Chart of Accounts) MANDT
0 AUAT KSTAR CSKA Cost Elements (Data Dependent on Chart of Accounts) KTOPL
1 AUAT MANDT T000 Clients MANDT
0 AUAT MEINH T006 Units of Measurement MANDT
0 AUAT MEINH T006 Units of Measurement MSEHI
1 AUAT RD_RECID T8JJ Recovery Indicator MANDT
1 AUAT RD_RECID T8JJ Recovery Indicator BUKRS
0 AUAT SC_RECID T8JJ Recovery Indicator MANDT
0 AUAT SC_RECID T8JJ Recovery Indicator BUKRS
1 AUAT TWAER TCURC Currency Codes MANDT
1 AUAT TWAER TCURC Currency Codes WAERS
0 AUAT VRGNG TJ01 Business Transactions VRGNG