SAP table TMPA1 (Profit Group)

SAP table TMPA1 has 2 primary key fields being MANDT,WPGRO.

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
WPGRO Profit Group CHAR 4 0 WPGRO
MARGINP Profit Margin as a Percentage DEC 5 3 WPMAP
MARGINA Absolute Minimum Margin CURR 15 2 WPMAA
CURR Currency for Minimum Profit Margin CUKY 5 0 TCURC WCURR
INTEREST Interest Rate DEC 7 3 WPVEP
CALCMETH Interest Calculation Method, Profit Simulation CHAR 1 0 WZINM
CALCPAYDAY Method for Calculating the Date of Payment CHAR 1 0 CALCPAYDAY
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 Supplier or Customer CHAR 1 0 TURNOVER_SIDE
A Percentage Margin Calculated Using Supplier Business Volume
B Percentage Margin Calculated Using Customer Business Volume
DISC_CALC Calculate Cash Discount CHAR 1 0 SKONTOBER

TMPA1 foreign key relationships

Table Field Check Table Check Field
0 TMPA1 CURR TCURC Currency Codes MANDT
0 TMPA1 CURR TCURC Currency Codes WAERS