TEMT_PROFILE - Planning profile

Planning profile information is stored in SAP table TEMT_PROFILE.
It is part of development package FTEM_EXPOSURE_MGT_PER in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "Treasury: Exposure Management - Persistency Layer".

Fields for table TEMT_PROFILE

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
PROFILE_IDPlanning ProfileXTEM_PLANNING_PROFILECHAR20
PROFILE_TYPEType of Exposure Planning ProfileTEM_PROFILE_TYPECHAR8TEMC_PROF_TYPE
YEAR_VARIANTFiscal Year VariantPERIVCHAR4T009
TRANSCATTransaction Category (E-HA)THM_TRANSCATNUMC4THMEXTS_CATEGORY
TRANSACTTransaction Activity (E-HA)THM_TRANSACTNUMC4THMEXTS_ACTIVITY
COMPANY_CODE_RELIndicator: "Company Code" as AttributeTEM_FLAG_COMPANY_CODE_RELCHAR2
COUNTRY_RELIndicator: "Country/Region" as AttributeTEM_FLAG_COUNTRY_RELCHAR2
ATTRIBUTE_01_RELGeneral FlagFLAGCHAR2
ATTRIBUTE_02_RELGeneral FlagFLAGCHAR2
ATTRIBUTE_03_RELGeneral FlagFLAGCHAR2
ATTRIBUTE_04_RELGeneral FlagFLAGCHAR2
ATTRIBUTE_05_RELGeneral FlagFLAGCHAR2
ATTRIBUTE_06_RELGeneral FlagFLAGCHAR2
SIGN_RELIndicator: "Plus/Minus Sign" as AttributeTEM_FLAG_SIGN_RELCHAR2
MAX_AGEMaximum Age of an Exposure in DaysTEM_MAX_AGENUMC6
CREATION_DATEFirst Entered OnDERFDATS16
CREATION_TIMETime of CreationTERFTIMS12
CREATION_USEREntered ByRERFCHAR24
LASTCHANGE_DATELast Edited OnDBEARDATS16
LASTCHANGE_TIMELast Edited AtTBEARTIMS12
LASTCHANGE_USEREmployee IDRBEARCHAR24
Privacy Policy