1. Home
  2. Resources
  3. SAP Tables
  4. T51AV_A - Calculation Rules for Averages

SAP Table T51AV_A

Calculation Rules for Averages

T51AV_A (Calculation Rules for Averages) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T51AV_A to other SAP tables.

T51AV_A table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MOLGA Country Grouping MOLGA T500L CHAR 2 0
AVRULE Calculation rule for averages AVRULE CHAR 4 0
ENDDA End Date ENDDA DATS 8 0
BEGDA Start Date BEGDA DATS 8 0
RELRULE Relevance rule averages RELRULE T51AV_R CHAR 4 0
CUMRULE Cumulation rule for bases for calculating average values CUMRULE T51AV_B CHAR 4 0
ENDRULE Rule for final processing of average calculation ENDRULE T51AV_E CHAR 4 0
COMPRULE Rule for comparison with wage types COMPRULE T51AV_W CHAR 4 0
RELNUMP Number of relevant periods RELNUMP NUMC 3 0
RELUNIT Time unit for average periods AVER_UNIT NUMC 2 0
01 Calendar months
03 Calendar weeks (acc. to feature LDAYW)
05 Rolling months
MAXNUMP Maximum number of periods included MAXNUMP NUMC 3 0
MAXUNIT Time unit for average periods AVER_UNIT NUMC 2 0
01 Calendar months
03 Calendar weeks (acc. to feature LDAYW)
05 Rolling months
CURRENT_PER Also take current period into account CURRENT_PER CHAR 1 0
FROZEN Freeze average value FROZEN CHAR 1 0
0 Value is frozen for a year (01.10.-30.09)
1 Value is frozen for the calendar year (01/01-31/12)
2 Value is frozen for a year (01.02.-31.01)
3 Value is frozen for a year (01.03.-28.02.29.02)
4 Value is frozen for one year (01/04-31/03)
5 Value is frozen for a year (01.05.-30.04)
6 Value is frozen for a year (01.06.-31.05)
7 Value is frozen for a year (01.07.-30.06)
8 Value is frozen for a year (01.08.-30.07)
9 Value is frozen for a year (01.09.-31.08)
A Value frozen for duration of absence
C Value is frozen for a year (01.11.-31.10)
D Value is frozen for a year (01.12.-30.11)
Q Freeze for a quarter (only for Finland)
T Cumulation period (for Brazil only)
Y Freeze for One Year (only for Finland)
N Freeze for period determined by country
WGTYP_AV Wage Type LGART T512W CHAR 4 0
NUMBER_AV Hourly Average (Number Average) NUMBER_AV CHAR 1 0

T51AV_A foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T51AV_A COMPRULE T51AV_A MANDT T51AV_W Comparison Rules for Calculating Averages MANDT
T51AV_A COMPRULE T51AV_A MOLGA T51AV_W Comparison Rules for Calculating Averages MOLGA
T51AV_A COMPRULE T51AV_A COMPRULE T51AV_W Comparison Rules for Calculating Averages COMPRULE
T51AV_A CUMRULE * T51AV_B Cumulation Rules for Bases for Calculating Average Values ENDDA
T51AV_A CUMRULE T51AV_A MANDT T51AV_B Cumulation Rules for Bases for Calculating Average Values MANDT
T51AV_A CUMRULE T51AV_A MOLGA T51AV_B Cumulation Rules for Bases for Calculating Average Values MOLGA
T51AV_A CUMRULE T51AV_A CUMRULE T51AV_B Cumulation Rules for Bases for Calculating Average Values CUMRULE
T51AV_A CUMRULE * T51AV_B Cumulation Rules for Bases for Calculating Average Values AVBASE
T51AV_A ENDRULE T51AV_A MANDT T51AV_E Final Processing Rules for Averages MANDT
T51AV_A ENDRULE T51AV_A MOLGA T51AV_E Final Processing Rules for Averages MOLGA
T51AV_A ENDRULE T51AV_A ENDRULE T51AV_E Final Processing Rules for Averages ENDRULE
T51AV_A MANDT T51AV_A MANDT T000 Clients MANDT
T51AV_A MOLGA T51AV_A MOLGA T500L Personnel Country Grouping MOLGA
T51AV_A RELRULE T51AV_A MOLGA T51AV_R Relevance Rule for Calculating Averages MOLGA
T51AV_A RELRULE T51AV_A RELRULE T51AV_R Relevance Rule for Calculating Averages RELRULE
T51AV_A RELRULE T51AV_A MANDT T51AV_R Relevance Rule for Calculating Averages MANDT
T51AV_A WGTYP_AV T51AV_A WGTYP_AV T512W Wage Type Valuation LGART
T51AV_A WGTYP_AV * T512W Wage Type Valuation ENDDA
T51AV_A WGTYP_AV T51AV_A MANDT T512W Wage Type Valuation MANDT
T51AV_A WGTYP_AV T51AV_A MOLGA T512W Wage Type Valuation MOLGA