SAP table AUAS (Settlement Document: Totals Segment)

SAP table AUAS has 3 primary key fields being MANDT,BELNR,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
LFDNR Sequence Number NUMC 10 0 LFDNR10
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
WTGBTR Total Value in Transaction Currency CURR 23 2 WTGXXX
WKGBTR Total Value in Controlling Area Currency CURR 23 2 WKGXXX
WKFBTR Fixed Value in Controlling Area Currency CURR 23 2 WKFXXX
WOGBTR Total Value in Object Currency CURR 23 2 WOGXXX
PAGBTR Total Price Variance in CO Area Currency CURR 23 2 PAGXXX
PAFBTR Fixed Price Variance in CO Area Currency CURR 23 2 PAFXXX
MEINH Unit of Measure UNIT 3 0 T006 CO_MEINH
MEGBTR Total Quantity QUAN 15 3 MEGXXX
MEFBTR Fixed Quantity QUAN 15 3 MEFXXX
WAGBTR Total Value in Freely Defined CO Currency 1 CURR 23 2 WAGXXX
WVGBTR Total Value in Freely-Defined CO Currency 2 CURR 23 2 WVGXXX
WBGBTR Total Value in Freely Defined CO Currency 3 CURR 23 2 W3GXXX
WCGBTR Total Value in Freely Defined CO Currency 4 CURR 23 2 WCGXXX
WDGBTR Total Value in Freely-Defined CO Currency 5 CURR 23 2 WDGXXX
WEGBTR Total Value in Freely Defined CO Currency 6 CURR 23 2 WEGXXX
WFGBTR Total Value in Freely Defined CO Currency 7 CURR 23 2 W7GXXX
WGGBTR Total Value in Freely Defined CO Currency 8 CURR 23 2 WGGXXX
WHGBTR Total Value in Local Currency CURR 23 2 WHGXXX
WSGBTR Total Value in alternative Object Currency CURR 23 2 WOGXXX_ALT
DATEI Structure Name for Interpretation of Field KEY01 CHAR 10 0 KEYSTRUCT
KEY01 Area for table key CHAR 120 0 TABKEYL
BWASL Asset Transaction Type CHAR 3 0 TABW BWASL
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
HRKFT CO key subnumber CHAR 14 0 CO_SUBKEY
SC_RECID Sender Clearing Recovery Indicator CHAR 2 0 T8JJ SC_RECID
RD_RECID Receiver Debit Recovery Indicator CHAR 2 0 T8JJ RD_RECID
MUVFLG Quantities Incomplete CHAR 1 0 MUVXX

AUAS foreign key relationships

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