SAP table ERTPDAYTYPEX (Allocate Exceptions to Day Groups)

SAP table ERTPDAYTYPEX has 4 primary key fields being MANDT,DAYTYPEBLOCK,DAYTYPEXID,CSNO.

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 * MANDT
DAYTYPEBLOCK Day group CHAR 10 0 EDAYTYPBLOCK E_DAYTYPEBLOCK
DAYTYPEXID Exception to Day Type CHAR 2 0 ERTPDAYTYPEXID E_RTP_DAYTYPEXID
CSNO Consecutive number NUMC 4 0 E_CSNO
DAYFROM From-Date NUMC 2 0 E_RTP_DAYFROM
01 Days in Month
MONTHFROM Month from NUMC 2 0 E_RTP_MONTHFROM
01 January
02 February
03 March
04 April
05 May
06 June
07 July
08 August
09 September
10 October
11 November
12 December
DAYTO To-Date NUMC 2 0 E_RTP_DAYTO
01 Days in Month
MONTHTO Month to NUMC 2 0 E_RTP_MONTHTO
01 January
02 February
03 March
04 April
05 May
06 June
07 July
08 August
09 September
10 October
11 November
12 December
YEARFROM Year from NUMC 4 0 E_RTP_YEARFROM
YEARTO To year NUMC 4 0 E_RTP_YEARTO
DAYTYPE Day type CHAR 10 0 EDAYTYPE E_DAYTYPE

ERTPDAYTYPEX foreign key relationships

Table Field Check Table Check Field
0 ERTPDAYTYPEX DAYTYPE EDAYTYPE Day Types DAYTYPE
1 ERTPDAYTYPEX DAYTYPEBLOCK EDAYTYPBLOCK Day Group DAYTYPEBLOCK
0 ERTPDAYTYPEX DAYTYPEXID ERTPDAYTYPEXID Exception to Day Type MANDT
0 ERTPDAYTYPEX DAYTYPEXID ERTPDAYTYPEXID Exception to Day Type DAYTYPEXID