SAP table EPROFHEAD (Profile Header Data)

SAP table EPROFHEAD has 2 primary key fields being MANDT,PROFILE.

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
PROFILE Number of EDM Profile NUMC 18 0 E_PROFILE
SPARTE Division CHAR 2 0 TSPA SPARTE
PROFTYPE Profile type NUMC 2 0 EPROFTYPE PROFTYPE
PROFVALCAT Profile value category NUMC 2 0 EPROFVALCAT E_PROFVALCAT
VALUECUM Cumulative values CHAR 1 0 VALUECUM
INTSIZEID Interval Length ID CHAR 4 0 EPROFINTSIZE INTSIZEID
MASS Unit of Measurement UNIT 3 0 T006 E_MASS
PROFDECIMALS Number of decimal places in a profile value NUMC 2 0 PROFDECIMALS
SOURCE Source of object NUMC 18 0 * E_SOURCE
OBJNR Object number CHAR 22 0 * J_OBJNR
PROFOFFSET Profile value offset TIMS 6 0 PROFOFFSET
CONCHECKGRP Consistency check group CHAR 10 0 EEDMCONGRP E_CONCHECKGRP
FORWARD_ORIENTED Profile values have forward orientation CHAR 1 0 FORWARD_ORIENTED
LASTVERSNO Consecutive number of version NUMC 6 0 CVERSNO
DATEFROM From-Date DATS 8 0 E_EDMDATEFROM
TIMEFROM From-time TIMS 6 0 E_EDMTIMEFROM
DATETO To-Date DATS 8 0 E_EDMDATETO
TIMETO To-Time TIMS 6 0 E_EDMTIMETO
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
BEGRU Authorization Group CHAR 4 0 BEGRU
LOEVM Deletion Indicator CHAR 1 0 LOEVM
WAERS Currency Key CUKY 5 0 TCURC WAERS
ARCH_DATEFROM Date, up to Which Profile Values Have Been Archived DATS 8 0 E_EDMDATETO_A
ARCH_TIMEFROM Time until which, profile values are archived. TIMS 6 0 E_EDMTIMETO_A
ARCH_DATETO Date, up to Which Profile Values Have Been Archived DATS 8 0 E_EDMDATETO_A
ARCH_TIMETO Time until which, profile values are archived. TIMS 6 0 E_EDMTIMETO_A
REF_PROFILE Profile Referenced During Settlement NUMC 18 0 EPROFHEAD E_REFPROFILE
REPLACEMETHODGRP Replacement Value Procedure Group CHAR 10 0 EEDMREPLACEGRP E_REPLACEGRP
DAY_OFFSET Day Offset TIMS 6 0 EDM_DAY_OFFSET
TIME_ZONE Time Zone for EDM Objects CHAR 6 0 TTZZ EDM_TIMEZONE
SRCPROFILE Source Profile for Copy Profile NUMC 18 0 E_SRCPROFILE
MDUS_LOCATED Location of Original Profile Values CHAR 1 0 E_AMI_MDUS_LOCATED_PROFILE
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 CHAR 1 0 E_TOU_BILLABLE

EPROFHEAD foreign key relationships

Table Field Check Table Check Field
0 EPROFHEAD CONCHECKGRP EEDMCONGRP IS-U EDM Consistency Check Group for Profile Import MANDT
0 EPROFHEAD CONCHECKGRP EEDMCONGRP IS-U EDM Consistency Check Group for Profile Import CONCHECKGRP
1 EPROFHEAD INTSIZEID EPROFINTSIZE Interval Lengths MANDT
1 EPROFHEAD INTSIZEID EPROFINTSIZE Interval Lengths INTSIZEID
0 EPROFHEAD MANDT T000 Clients MANDT
1 EPROFHEAD MASS T006 Units of Measurement MANDT
1 EPROFHEAD MASS T006 Units of Measurement MSEHI
0 EPROFHEAD PROFTYPE EPROFTYPE Profile Type MANDT
1 EPROFHEAD REF_PROFILE EPROFHEAD Profile Header Data MANDT
1 EPROFHEAD REF_PROFILE EPROFHEAD Profile Header Data PROFILE
0 EPROFHEAD REPLACEMETHODGRP EEDMREPLACEGRP IS-U-EDM Replacement Value Procedure Group MANDT
0 EPROFHEAD REPLACEMETHODGRP EEDMREPLACEGRP IS-U-EDM Replacement Value Procedure Group REPLACEMETHODGRP
1 EPROFHEAD SPARTE TSPA Organizational Unit: Sales Divisions MANDT
1 EPROFHEAD SPARTE TSPA Organizational Unit: Sales Divisions SPART
0 EPROFHEAD TIME_ZONE TTZZ Time zones TZONE
1 EPROFHEAD WAERS TCURC Currency Codes MANDT
1 EPROFHEAD WAERS TCURC Currency Codes WAERS