SAP table T043G (Tolerances for Groups of Customers/Vendors)
SAP table T043G has 3 primary key fields being MANDT,BUKRS,TOGRU.
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
BUKRS
Company Code
CHAR
4
0
T001
BUKRS
TOGRU
Tolerance Group for Business Partner/G/L Account
CHAR
4
0
TOGRU
BETRS
Maximum Payment Difference for Revenue
CURR
7
2
BETRS_043T
BETRH
Maximum Payment Difference for Expense
CURR
7
2
BETRH_043T
PROZS
Maximum Allowable Revenues from Payment Differences
DEC
3
1
PROZS_043T
PROZH
Maximum Expense Permitted from Payment Differences
DEC
3
1
PROZH_043T
SKNTS
Maximum Discount Adjust. for Gain from Payment Differences
CURR
7
2
SKNTS_043T
SKNTH
Maximum Discount Adjust. for Loss from Payment Differences
CURR
7
2
SKNTH_043T
TOLER
Grace Days
NUMC
2
0
TOLER_043G
SKTRE
Cash Discount Terms Used for Displaying Items when Clearing
CHAR
1
0
SKTRE_043G
XKONR
Indicator: Transfer Payment Conditions from the Invoice?
CHAR
1
0
XKONR_043G
ZTERM
Standard Payment Term for Carryforward Postings
CHAR
4
0
DZTERM_043
XSKAN
Indicator: Only Grant Partial Cash Discount?
CHAR
1
0
XSKAN_043G
MSLRP
Dunning Key for Residual Items
CHAR
1
0
T040
MSLRP_043G
PRAVS
Tolerance Limit for Difference Compared with Pmnt Advce Item
DEC
3
1
PRAVS_043G
PRAVH
Tolerance Limit for Difference Compared with Pmnt Advce Item
DEC
3
1
PRAVH_043G
BEAVS
Tolerance Limit for Difference Compared with Pmnt Advce Item
CURR
7
2
BEAVS_043G
BEAVH
Tolerance Limit for Difference Compared with Pmnt Advce Item
CURR
7
2
BEAVH_043G
VRZDE
Base Date for Determining Arrears Days for OI Processing
CHAR
1
0
VRZDE
Possible values
Determine Days in Arrears According to Document Date
1
Determine Days in Arrears According to Value Date of Bk Item
BEADS
Maximum Payment Diff. for Revenue with Function Code AD
CURR
7
2
BETRADS_043T
BEADH
Maximum Payment Diff. for Expense with Function Code AD
CURR
7
2
BETRADH_043T
PRADS
Max. Permitted Rev. from Payment Diff. with Function Code AD
DEC
3
1
PROZADS_043T
PRADH
Max. Permitted Exp. from Payment Diff. with Function Code AD
DEC
3
1
PROZADH_043T
T043G foreign key relationships
Table
Field
Check Table
Check Field
0 T043G
BUKRS
T001
Company Codes
BUKRS
1 T043G
MANDT
T000
Clients
MANDT
0 T043G
MSLRP
T040
Dunning keys
MSCHL