SAP table TTSTR (Time stream: Administration table)

SAP table TTSTR has 4 primary key fields being MANDT,TSTRTYPE,TSTREAMID,CALENDARID.

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
TSTRTYPE Time stream: Type CHAR 2 0 TSTRTYPE
DY dynamically generated (overlay, etc)
FC Factory calendar
PC Calendar (calendar only, all days are work days)
TS Time stream (shift models, etc.)
TSTREAMID Time stream: External ID CHAR 10 0 TSTRID
CALENDARID Calendar ID CHAR 2 0 TFACD TSTRCALID
RELID Time stream: Area in IMPORT/EXPORT data table TSTRCOMP CHAR 2 0 TSTRRELID
HANDLE Time stream: Time stream handle CHAR 32 0 TSTRHANDLE
BUFFEROPT Time stream: Buffer option CHAR 1 0 TSTRBUFFOP
in the shared buffer of the application server
1 on the database
2 unbuffered (time stream only dynamic)
CALCOPT Time stream: Option for arith. operations CHAR 1 0 TSTRCALCOP
Start within time slice
1 Start only at the beginning of the time slice
GENOPT Time stream: Generation options CHAR 1 0 TSTRGENOP
dynamically at runtime
1 With separate generation run
FLAGCONTIN Time stream: 'Without gaps' flag CHAR 1 0 TSTRCONTIN
TZONE Time Zone CHAR 6 0 TTZZ TZNZONE
SCOPEGENFW Time stream: No. of years generated in the future NUMC 2 0 TSTRSCOPFW
SCOPEGENBW Time stream: No. of years generated in the past NUMC 2 0 TSTRSCOPBW
CALIDGEN -- obsolete after 4.5A -- CHAR 2 0 TSTRCALIDG
FBGEN Time stream: FM for generating time segments CHAR 30 0 TFDIR TSTRFBGEN
TBGEN Table for applic.-specific data for generation (optional) CHAR 30 0 DD02L TSTRTBGEN
FBDEL Timestream: FM for checks (deletion) CHAR 30 0 TSTRFBDEL
RUNTRELEAS Release (development level) of the runtime objects CHAR 4 0 TSTRSAPRL
FLAGEXTENT Flag - time slots have extents CHAR 1 0 TSTRFLEXT
CREATED Time at which object was created DEC 15 0 TSTRCREATS
CREATEDBY User that created object CHAR 12 0 USR02 TSTRCREATN
CHANGED Time at which object was last changed DEC 15 0 TSTRCHANGS
CHANGEDBY Last user to change object CHAR 12 0 USR02 TSTRCHANGN
GENERATE Time stream: Time of last generation DEC 15 0 TSTRGENERS
GENERATEBY Time stream: User who generated object CHAR 12 0 USR02 TSTRGENERN

TTSTR foreign key relationships

Table Field Check Table Check Field
0 TTSTR CHANGEDBY USR02 Logon Data (Kernel-Side Use) BNAME
1 TTSTR CREATEDBY USR02 Logon Data (Kernel-Side Use) BNAME
0 TTSTR FBGEN TFDIR Function Module FUNCNAME
1 TTSTR GENERATEBY USR02 Logon Data (Kernel-Side Use) BNAME
0 TTSTR TBGEN DD02L SAP Tables TABNAME
0 TTSTR TBGEN DD02L SAP Tables AS4LOCAL
0 TTSTR TBGEN DD02L SAP Tables AS4VERS
1 TTSTR TZONE TTZZ Time zones TZONE