TMPA1 SAP table for – Agency Business: Profit Group

Here we would like to draw your attention to TMPA1 table in SAP. As we know it is being mainly used with the SAP LO-AB (Agency Business (Global Trade) in LO) component which is coming under LO module (Logistics). TMPA1 is a SAP standard transparent table used for storing Agency Business: Profit Group related data in SAP. It comes under the package WZRE.

SAP TMPA1 table

Table TMPA1 technical data

TableTMPA1
Data storingAgency Business: Profit Group
ModuleLO
ComponentLO-AB
SAP PackageWZRE
Delivery ClassG – Customer table, SAP may insert new data records but may not overwrite or delete existing ones
Table CategoryTRANSPARENT

SAP TMPA1 Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in TMPA1 table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • DISC_CALC
    Its data type is C (Character String) with field length 1
  • WPGRO
    Its a key field. Its data type is C (Character String) with field length 4
  • MARGINP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • MARGINA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • CURR
    Its data type is C (Character String) with field length 5
  • INTEREST
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 4
  • CALCMETH
    Its data type is C (Character String) with field length 1
  • CALCPAYDAY
    Its data type is C (Character String) with field length 1
  • TURNOVER_SIDE
    Its data type is C (Character String) with field length 1