SAP table T242Q (Currency translation type)

SAP table T242Q has 3 primary key fields being MANDT,APPLCLASS,NUMBR.

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
APPLCLASS Application class for drilldown reporting CHAR 4 0 * CFAPPLCLAS
NUMBR Number of translation key in currency translation NUMC 3 0 CFNUMBR
ZWTYP Exchange Rate Type CHAR 4 0 TCURV KURST_CURR
TNAME_DAT Program/str.name for currency translation CHAR 30 0 * RKE_TNAME
FIELD_DAT Field Name CHAR 30 0 * FIELDNAME
ZWDAT Date as of which exchange rate is valid DATS 8 0 RKE_ZWDAT
TNAME_WAE Program/str.name for currency translation CHAR 30 0 * RKE_TNAME
FIELD_WAE Field Name CHAR 30 0 * FIELDNAME
WAERS From currency CUKY 5 0 TCURC KCDFCURR
TNAME_ZWAE Program/str.name for currency translation CHAR 30 0 * RKE_TNAME
FIELD_ZWAE Field Name CHAR 30 0 * FIELDNAME
ZWAERS To-currency CUKY 5 0 TCURC KCDTCURR_D
ZWZEI Time reference for currency translation CHAR 1 0 RKE_ZWZEI
1 Fiscal Year End Date
2 End of period
3 Beginning of period
4 End of week
5 For exact day
INVKZ Currency translation: Inversion flag CHAR 1 0 RKE_INVKZ

T242Q foreign key relationships

Table Field Check Table Check Field
0 T242Q MANDT T000 Clients MANDT
1 T242Q WAERS TCURC Currency Codes MANDT
1 T242Q WAERS TCURC Currency Codes WAERS
0 T242Q ZWAERS TCURC Currency Codes MANDT
0 T242Q ZWAERS TCURC Currency Codes WAERS
1 T242Q ZWTYP TCURV Exchange rate types for currency translation MANDT
1 T242Q ZWTYP TCURV Exchange rate types for currency translation KURST