1. Home
  2. Resources
  3. SAP Tables
  4. EPROFILE - EDM Profile

SAP Table EPROFILE

EDM Profile

EPROFILE (EDM Profile) 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 EPROFILE to other SAP tables.

EPROFILE table fields

Field Data element Checktable Datatype Length Decimals
PROFILENR Number of EDM Profile E_PROFILE NUMC 18 0
PROFCONTR EPROFCONTR STRU 0 0
READ_VALUES Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
READ_STATUS Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
READ_STATUSHIST Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
READ_VERSION Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
READ_VERSION_HD_ONLY CHAR 1 0
FILL_PROFVALUES Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
PROFVAL_IMPORT_ONLY Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
PI_HEADER_CHANGED Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
READ_ONLY Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
READ_ARCHIVED_DATA Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
READ_TMP_PROFILE Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
OPENING_INTSIZEID Interval Length ID INTSIZEID CHAR 4 0
OPENING_MASS Unit of Measurement E_MASS UNIT 3 0
PROF_INTSIZETYPE Interval length category INTSIZETYPE NUMC 1 0
1 Minutes
2 Days
3 Months
4 Years
DAY_PROF_TIME_MODE CHAR 1 0
DAY_PROF_NO_OFFSET CHAR 1 0
DAY_PROF_DAY_TIME EPROF_DAYMODE_DAY_TIME STRU 0 0
T_DT_MODE_LCL TEDM_DATE_TIME_LCL_UTC TTYP 0 0
T_DT_MODE_UTC TEDM_DATE_TIME_LCL_UTC TTYP 0 0
T_DT_MODE_UTC_OPEN TEDM_DATE_TIME_LCL_UTC TTYP 0 0
DATE_FROM Day of profile values PROFVALDAY DATS 8 0
TIME_FROM From-time for profile PROFTIMEFROM TIMS 6 0
DATE_TO Day of profile values PROFVALDAY DATS 8 0
TIME_TO To-Time for Profile PROFTIMETO TIMS 6 0
PROF_TIMEZONE Time Zone TIMEZONE CHAR 6 0
DATE_FROM_UTC Day of profile values PROFVALDAY DATS 8 0
TIME_FROM_UTC From-time for profile PROFTIMEFROM TIMS 6 0
DATE_TO_UTC Day of profile values PROFVALDAY DATS 8 0
TIME_TO_UTC To-Time for Profile PROFTIMETO TIMS 6 0
DATE_FROM_UTC_DB EEDMDATEFROM_UTC STRU 0 0
DATEFROM_UTC From-Date E_EDMDATEFROM DATS 8 0
TIMEFROM_UTC From-time E_EDMTIMEFROM TIMS 6 0
DATE_TO_UTC_DB EEDMDATETO_UTC STRU 0 0
DATETO_UTC To-Date E_EDMDATETO DATS 8 0
TIMETO_UTC To-Time E_EDMTIMETO TIMS 6 0
DATE_FIRST_CHANGE EEDMDATEFROM STRU 0 0
DATEFROM From-Date E_EDMDATEFROM DATS 8 0
TIMEFROM From-time E_EDMTIMEFROM TIMS 6 0
DATE_LAST_CHANGE EEDMDATETO STRU 0 0
DATETO To-Date E_EDMDATETO DATS 8 0
TIMETO To-Time E_EDMTIMETO TIMS 6 0
DATE_FIRST_CHANGE_UTC EEDMDATEFROM_UTC STRU 0 0
DATEFROM_UTC From-Date E_EDMDATEFROM DATS 8 0
TIMEFROM_UTC From-time E_EDMTIMEFROM TIMS 6 0
DATE_LAST_CHANGE_UTC EEDMDATETO_UTC STRU 0 0
DATETO_UTC To-Date E_EDMDATETO DATS 8 0
TIMETO_UTC To-Time E_EDMTIMETO TIMS 6 0
REF_TO_DB_HD DATA REF 0 0
REF_TO_DB_HD_TXT DATA REF 0 0
REF_TO_DB_DATA DATA REF 0 0
REF_TO_UPD DATA REF 0 0
REF_TO_INS DATA REF 0 0
REF_TO_DEL DATA REF 0 0
REF_TO_STAT_DB DATA REF 0 0
REF_TO_STAT_OLD DATA REF 0 0
REF_TO_STAT_PREV DATA REF 0 0
REF_TO_ARCH_DATA DATA REF 0 0
REF_TO_AMI_PROFILE_MANAGER CL_ISU_AMI_PROFILE_MANAGER REF 0 0
PROFHEAD_DATA EPROFHEAD_MAIN STRU 0 0
SPARTE Division SPARTE CHAR 2 0
PROFTYPE Profile type PROFTYPE NUMC 2 0
PROFVALCAT Profile value category E_PROFVALCAT NUMC 2 0
VALUECUM Cumulative values VALUECUM CHAR 1 0
NULL Field inactive
X Field active
INTSIZEID Interval Length ID INTSIZEID CHAR 4 0
MASS Unit of Measurement E_MASS UNIT 3 0
PROFDECIMALS Number of decimal places in a profile value PROFDECIMALS NUMC 2 0
SOURCE Source of object E_SOURCE NUMC 18 0
OBJNR Object number J_OBJNR CHAR 22 0
PROFOFFSET Profile value offset PROFOFFSET TIMS 6 0
CONCHECKGRP Consistency check group E_CONCHECKGRP CHAR 10 0
FORWARD_ORIENTED Profile values have forward orientation FORWARD_ORIENTED CHAR 1 0
NULL Field inactive
X Field active
LASTVERSNO Consecutive number of version CVERSNO NUMC 6 0
DATEFROM From-Date E_EDMDATEFROM DATS 8 0
TIMEFROM From-time E_EDMTIMEFROM TIMS 6 0
DATETO To-Date E_EDMDATETO DATS 8 0
TIMETO To-Time E_EDMTIMETO TIMS 6 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
BEGRU Authorization Group BEGRU CHAR 4 0
LOEVM Deletion Indicator LOEVM CHAR 1 0
X Yes
NULL No
WAERS Currency Key WAERS CUKY 5 0
ARCH_DATEFROM Date, up to Which Profile Values Have Been Archived E_EDMDATETO_A DATS 8 0
ARCH_TIMEFROM Time until which, profile values are archived. E_EDMTIMETO_A TIMS 6 0
ARCH_DATETO Date, up to Which Profile Values Have Been Archived E_EDMDATETO_A DATS 8 0
ARCH_TIMETO Time until which, profile values are archived. E_EDMTIMETO_A TIMS 6 0
REF_PROFILE Profile Referenced During Settlement E_REFPROFILE NUMC 18 0
REPLACEMETHODGRP Replacement Value Procedure Group E_REPLACEGRP CHAR 10 0
DAY_OFFSET Day Offset EDM_DAY_OFFSET TIMS 6 0
TIME_ZONE Time Zone for EDM Objects EDM_TIMEZONE CHAR 6 0
SRCPROFILE Source Profile for Copy Profile E_SRCPROFILE NUMC 18 0
MDUS_LOCATED Location of Original Profile Values E_AMI_MDUS_LOCATED_PROFILE CHAR 1 0
NULL Profile Values Originate from EDM
1 Profile Values Originate from External System; Copy in EDM
2 Profile Values Originate from External System
TOU_BILLABLE Profile Can Be Billed with TOU Interface E_TOU_BILLABLE CHAR 1 0
NULL Field inactive
X Field active
SPRAS Language Key SPRAS LANG 1 0
PROFTEXT Name of Profile E_PROFTEXT CHAR 60 0
PROFVALUES TEPROFVALUES TTYP 0 0
PROFVALUES_UTC TEPROFVALUES_SORTED TTYP 0 0
PROFSTATUS TEPROFSTATUS TTYP 0 0
PROFSTATUS_UTC TEPROFSTATUS_UTC TTYP 0 0
PROFSTATUSHIST TEPROFSTATUSHIST TTYP 0 0
PROFVERSIONS TEPROFVERSION TTYP 0 0