SAP table TPRG (Date display format)

SAP table TPRG has 3 primary key fields being MANDT,SPRAS,PRGBZ.

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
SPRAS Language Key LANG 1 0 T002 SPRAS
PRGBZ External Date Type CHAR 1 0 PRGBZ
PRGRS Date type (day, week, month, interval) CHAR 1 0 PRGRS
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
PRGTX Description of date type CHAR 20 0 PRGTX
PRITX Period description in printout CHAR 6 0 PRITX

TPRG foreign key relationships

Table Field Check Table Check Field
0 TPRG SPRAS T002 Language Keys (Component BC-I18) SPRAS