SAP Table TMPA1

Agency Business: Profit Group

TMPA1 (Agency Business: Profit Group) 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 TMPA1 to other SAP tables.

TMPA1 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
WPGRO Profit group WPGRO CHAR 4 0
MARGINP Profit margin as a percentage WPMAP DEC 5 3
MARGINA Absolute Minimum Margin WPMAA CURR 15 2
CURR Currency for minimum profit margin WCURR TCURC CUKY 5 0
INTEREST Interest rate WPVEP DEC 7 3
CALCMETH Agency business: Method of calculation interest, profit sim. WZINM CHAR 1 0
1 360E/360
B 360E/365
F 360/360 (ISDA)
H 360/365 (ISDA)
7 360/360
2 Act/360
E Act/364
3 Act/365
4 Act/366
5 Act/ActP (ICMA)
6 Act/ActY (ISDA)
G Act/ActE (AFB)
A ActW/252
D 365/360
C 365/365
I 360E/ActY
8 *365/360
9 *365.25/360
P 1/1
J m+act/360
K m+30/360
0 Not Specified
CALCPAYDAY Method for Calculating the Date of Payment CALCPAYDAY CHAR 1 0
A Baseline date for payment + days in first condition
B Baseline date for payment + days in second condition
C Baseline date for payment + due date for net payment
D Baseline date for payment
TURNOVER_SIDE Business Volume of Vendor or Customer TURNOVER_SIDE CHAR 1 0
A Percentage margin calculated using vendor business volume
B Percentage margin calculated using customer business volume
DISC_CALC Calculate cash discount SKONTOBER CHAR 1 0
X Yes
NULL No

TMPA1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TMPA1 CURR TMPA1 MANDT TCURC Currency Codes MANDT
TMPA1 CURR TMPA1 CURR TCURC Currency Codes WAERS
TMPA1 MANDT TMPA1 MANDT T000 Clients MANDT