Follow us on LinkedIn for your next SAP project

← Back to Search

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

Possible values

MANDT

Client

MANDT

T000

CLNT

WPGRO

Profit group

WPGRO

CHAR

MARGINP

Profit margin as a percentage

WPMAP

DEC

MARGINA

Absolute Minimum Margin

WPMAA

CURR

Currency for minimum profit margin

WCURR

TCURC

CUKY

INTEREST

Interest rate

WPVEP

DEC

CALCMETH

Agency business: Method of calculation interest, profit sim.

WZINM

CHAR

Value	Description
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
NULL	Not Specified

CALCPAYDAY

Method for Calculating the Date of Payment

CALCPAYDAY

CHAR

Value	Description
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

Value	Description
A	Percentage margin calculated using vendor business volume
B	Percentage margin calculated using customer business volume

DISC_CALC

Calculate cash discount

SKONTOBER

CHAR

Value	Description
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