SAP AUAB Settlement Document: Distribution Rules Table data and field list

AUAB is a standard SAP Cluster Table which is used to store Settlement Document: Distribution Rules data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The AUAB table consists of various fields, each holding specific information or linking keys about Settlement Document: Distribution Rules data available in SAP. These include BELNR (Number of a settlement document), BUREG (Distribution rule group), LFDNR (Sequence number (three characters)), BREST (Settled Amount for the Amount Settlement)... 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. .

AUAB cluster table Technical Details:

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 AUAB cluster table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the AUAB table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
BELNRNumber of a settlement document AA_BELNRCHAR10AUAKALPHAAA_BELNRBLN
BUREGDistribution rule group BRSGRNUMC3NUMC3
LFDNRSequence number (three characters) LFDNR3NUMC3NUMC3
BRESTSettled Amount for the Amount Settlement BRESTCURR15(2) WERTV8
RLFNRSequence number of distribution rule BR_LFDNRNUMC3NUMC3
PLFNRSequence number of primary assignment BR_TLFNRNUMC4NUMC4
SLFNRSequence number of secondary assignment BR_SLFNRNUMC4NUMC4
ATTYPDistribution Type for the Posting Rule BR_ATTYPCHAR2BR_ATTYP
ATVALDistribution Value of Posting Rule (Dependent on Acty Type) BR_ATVALNUMC15NUMC15

Key field Non-key field



How do I retrieve data from SAP table AUAB using ABAP code

The following ABAP code Example will allow you to do a basic selection on AUAB to SELECT all data from the table
DATA: WA_AUAB TYPE AUAB.

SELECT SINGLE *
FROM AUAB
INTO CORRESPONDING FIELDS OF WA_AUAB
WHERE...

How to access SAP table AUAB

Within an ECC or HANA version of SAP you can also view further information about AUAB and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to AUAB

    AUAK - Document Header for Settlement
        AUAA - Settlement Document: Receiver Segment
        AUAB - Settlement Document: Distribution Rules
        AUAO - Document Segment: CO Objects to be Settled
        AUAS - Settlement Document: Totals Segment
        AUAV - Document Segment: Transactions