EPROFHEAD
Profile Header Data
EPROFHEAD is an SAP database table in S/4HANA. Profile Header Data. It contains 37 fields. 10 CDS views read from this table.
CDS Views using this table (10)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /UCOM/i_EPROFHEAD | view_entity | from | BASIC | Profile Header Data |
| I_UtilitiesTimeSeriesHeader | view_entity | from | BASIC | Time series header data |
| v_sumintgr10 | view | from | ||
| v_sumintgr15 | view | from | ||
| v_sumintgr30 | view | from | ||
| V_SUMINTGR60 | view | from | ||
| v_sumintsu10 | view | from | ||
| v_sumintsu15 | view | from | ||
| v_sumintsu30 | view | from | ||
| V_SUMINTSU60 | view | from |
Fields (37)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | profile | E_PROFILE | Profile | |||
| sparte | SPARTE | Division | ||||
| proftype | PROFTYPE | Profile type | ||||
| profvalcat | E_PROFVALCAT | PV category | ||||
| valuecum | VALUECUM | Cumulative vals | ||||
| intsizeid | INTSIZEID | Interval Length | ||||
| mass | E_MASS | Unit of meas. | ||||
| profdecimals | PROFDECIMALS | Decimal places | ||||
| source | E_SOURCE | Object source | ||||
| objnr | J_OBJNR | Object number | ||||
| profoffset | PROFOFFSET | Offset | ||||
| concheckgrp | E_CONCHECKGRP | Cons. check grp | ||||
| forward_oriented | FORWARD_ORIENTED | Forward orient. | ||||
| lastversno | CVERSNO | Version number | ||||
| datefrom | E_EDMDATEFROM | From-Date | ||||
| timefrom | E_EDMTIMEFROM | Time from | ||||
| dateto | E_EDMDATETO | To-Date | ||||
| timeto | E_EDMTIMETO | To-Time | ||||
| erdat | ERDAT | Created On | ||||
| ernam | ERNAM | Created By | ||||
| aedat | AEDAT | Changed On | ||||
| aenam | AENAM | Changed By | ||||
| begru | BEGRU | AuthorizGroup | ||||
| loevm | LOEVM | Delete | ||||
| waers | WAERS | Currency | ||||
| arch_datefrom | E_EDMDATETO_A | Prof. Arch. to | ||||
| arch_timefrom | E_EDMTIMETO_A | Prof. Arch. to | ||||
| arch_dateto | E_EDMDATETO_A | Prof. Arch. to | ||||
| arch_timeto | E_EDMTIMETO_A | Prof. Arch. to | ||||
| ref_profile | E_REFPROFILE | Reference Prof. | ||||
| replacemethodgrp | E_REPLACEGRP | RVP Group | ||||
| day_offset | EDM_DAY_OFFSET | Day Offset | ||||
| time_zone | EDM_TIMEZONE | Time Zone | ||||
| srcprofile | E_SRCPROFILE | Source Profile | ||||
| mdus_located | E_AMI_MDUS_LOCATED_PROFILE | Location of PVs | ||||
| tou_billable | E_TOU_BILLABLE | TOU Billable |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Profile Header Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EPROFHEAD (
MANDT, -- Client [MANDT]
PROFILE, -- Profile [E_PROFILE]
SPARTE, -- Division [SPARTE]
PROFTYPE, -- Profile type [PROFTYPE]
PROFVALCAT, -- PV category [E_PROFVALCAT]
VALUECUM, -- Cumulative vals [VALUECUM]
INTSIZEID, -- Interval Length [INTSIZEID]
MASS, -- Unit of meas. [E_MASS]
PROFDECIMALS, -- Decimal places [PROFDECIMALS]
SOURCE, -- Object source [E_SOURCE]
OBJNR, -- Object number [J_OBJNR]
PROFOFFSET, -- Offset [PROFOFFSET]
CONCHECKGRP, -- Cons. check grp [E_CONCHECKGRP]
FORWARD_ORIENTED, -- Forward orient. [FORWARD_ORIENTED]
LASTVERSNO, -- Version number [CVERSNO]
DATEFROM, -- From-Date [E_EDMDATEFROM]
TIMEFROM, -- Time from [E_EDMTIMEFROM]
DATETO, -- To-Date [E_EDMDATETO]
TIMETO, -- To-Time [E_EDMTIMETO]
ERDAT, -- Created On [ERDAT]
ERNAM, -- Created By [ERNAM]
AEDAT, -- Changed On [AEDAT]
AENAM, -- Changed By [AENAM]
BEGRU, -- AuthorizGroup [BEGRU]
LOEVM, -- Delete [LOEVM]
WAERS, -- Currency [WAERS]
ARCH_DATEFROM, -- Prof. Arch. to [E_EDMDATETO_A]
ARCH_TIMEFROM, -- Prof. Arch. to [E_EDMTIMETO_A]
ARCH_DATETO, -- Prof. Arch. to [E_EDMDATETO_A]
ARCH_TIMETO, -- Prof. Arch. to [E_EDMTIMETO_A]
REF_PROFILE, -- Reference Prof. [E_REFPROFILE]
REPLACEMETHODGRP, -- RVP Group [E_REPLACEGRP]
DAY_OFFSET, -- Day Offset [EDM_DAY_OFFSET]
TIME_ZONE, -- Time Zone [EDM_TIMEZONE]
SRCPROFILE, -- Source Profile [E_SRCPROFILE]
MDUS_LOCATED, -- Location of PVs [E_AMI_MDUS_LOCATED_PROFILE]
TOU_BILLABLE, -- TOU Billable [E_TOU_BILLABLE]
PRIMARY KEY (MANDT, PROFILE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA