SAP Table ERTPDAYTYPEX

Allocate Exceptions to Day Groups

ERTPDAYTYPEX (Allocate Exceptions to Day Groups) 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 ERTPDAYTYPEX to other SAP tables.

Source: ERTPDAYTYPEX (Allocate Exceptions to Day Groups)

ERTPDAYTYPEX table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
DAYTYPEBLOCK Day group E_DAYTYPEBLOCK EDAYTYPBLOCK CHAR 10 0
DAYTYPEXID Exception to Day Type E_RTP_DAYTYPEXID ERTPDAYTYPEXID CHAR 2 0
CSNO Consecutive number E_CSNO NUMC 4 0
DAYFROM From-Date E_RTP_DAYFROM NUMC 2 0
01 Days in Month
MONTHFROM Month from E_RTP_MONTHFROM NUMC 2 0
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 E_RTP_DAYTO NUMC 2 0
01 Days in Month
MONTHTO Month to E_RTP_MONTHTO NUMC 2 0
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 E_RTP_YEARFROM NUMC 4 0
YEARTO To year E_RTP_YEARTO NUMC 4 0
DAYTYPE Day type E_DAYTYPE EDAYTYPE CHAR 10 0

ERTPDAYTYPEX foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ERTPDAYTYPEX DAYTYPE ERTPDAYTYPEX MANDT EDAYTYPE Day Types MANDT
ERTPDAYTYPEX DAYTYPE ERTPDAYTYPEX DAYTYPE EDAYTYPE Day Types DAYTYPE
ERTPDAYTYPEX DAYTYPEBLOCK ERTPDAYTYPEX MANDT EDAYTYPBLOCK Day Group MANDT
ERTPDAYTYPEX DAYTYPEBLOCK ERTPDAYTYPEX DAYTYPEBLOCK EDAYTYPBLOCK Day Group DAYTYPEBLOCK
ERTPDAYTYPEX DAYTYPEXID ERTPDAYTYPEX MANDT ERTPDAYTYPEXID Exception to Day Type MANDT
ERTPDAYTYPEX DAYTYPEXID ERTPDAYTYPEX DAYTYPEXID ERTPDAYTYPEXID Exception to Day Type DAYTYPEXID