SAP table T5DB8 (Obsolete: Construction Sector: Team Assignment to Work Site)

SAP table T5DB8 has 5 primary key fields being MANDT,WERKS,BTRTL,KOLON,ENDDA.

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
WERKS Personnel Area CHAR 4 0 T500P PERSA
BTRTL Personnel Subarea CHAR 4 0 T001P BTRTL
KOLON Team CHAR 4 0 T5DB7 P01B_KOLON
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
AEDTM Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
ZEITY Employee Subgroup Grouping for Work Schedules CHAR 1 0 DZEITY
MOFID Public Holiday Calendar CHAR 2 0 THOCI HIDENT
KOSCH Work schedule rule CHAR 8 0 T508A P01B_KOSCH
MEHRR Overtime Rule CHAR 2 0 P01B_MEHRR
AKKOR Piecework Rule CHAR 2 0 P01B_AKKOR
PRAEK Premium Identifier CHAR 5 0 T5DBK P01B_PRAEK
RUEST Setup time DEC 5 2 P01B_RUEST
KOA01 Attributes CHAR 2 0 T5DBH P01B_BSATT
KOA02 Attributes CHAR 2 0 T5DBH P01B_BSATT
KOA03 Attributes CHAR 2 0 T5DBH P01B_BSATT
KOA04 Attributes CHAR 2 0 T5DBH P01B_BSATT
KOA05 Attributes CHAR 2 0 T5DBH P01B_BSATT
KOA06 Attributes CHAR 2 0 T5DBH P01B_BSATT
KOA07 Attributes CHAR 2 0 T5DBH P01B_BSATT
KOA08 Attributes CHAR 2 0 T5DBH P01B_BSATT
POSNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PRPS PS_PSP_PNR
AUFNR Order Number CHAR 12 0 AUFK AUFNR
BUKRS Company Code CHAR 4 0 T001 BUKRS
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
KOSTL Cost Center CHAR 10 0 CSKS KOSTL
NPLNR Network Number for Account Assignment CHAR 12 0 AUFK NPLNR
VORNR Operation/Activity Number CHAR 4 0 VORNR
ARTDA Type of Work CHAR 2 0 T5DBH P01B_ARTDA
KDAUF Sales Order Number CHAR 10 0 VBUK KDAUF
KDPOS Item number in Sales Order NUMC 6 0 KDPOS
KSTRG Cost Object CHAR 12 0 CKPH KSTRG

T5DB8 foreign key relationships

Table Field Check Table Check Field
0 T5DB8 ARTDA T5DBH Construction Attributes MANDT
0 T5DB8 ARTDA T5DBH Construction Attributes BSATY
0 T5DB8 ARTDA T5DBH Construction Attributes BSATT
0 T5DB8 ARTDA T5DBH Construction Attributes ENDDA
1 T5DB8 AUFNR AUFK Order master data AUFNR
0 T5DB8 BTRTL T001P Personnel Area/Subarea MANDT
0 T5DB8 BTRTL T001P Personnel Area/Subarea WERKS
0 T5DB8 BTRTL T001P Personnel Area/Subarea BTRTL
1 T5DB8 BUKRS T001 Company Codes BUKRS
0 T5DB8 KDAUF VBUK Sales Document: Header Status and Administrative Data MANDT
0 T5DB8 KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
1 T5DB8 KOA01 T5DBH Construction Attributes MANDT
1 T5DB8 KOA01 T5DBH Construction Attributes BSATY
1 T5DB8 KOA01 T5DBH Construction Attributes BSATT
1 T5DB8 KOA01 T5DBH Construction Attributes ENDDA
0 T5DB8 KOA02 T5DBH Construction Attributes MANDT
0 T5DB8 KOA02 T5DBH Construction Attributes BSATY
0 T5DB8 KOA02 T5DBH Construction Attributes BSATT
0 T5DB8 KOA02 T5DBH Construction Attributes ENDDA
1 T5DB8 KOA03 T5DBH Construction Attributes MANDT
1 T5DB8 KOA03 T5DBH Construction Attributes BSATY
1 T5DB8 KOA03 T5DBH Construction Attributes BSATT
1 T5DB8 KOA03 T5DBH Construction Attributes ENDDA
0 T5DB8 KOA04 T5DBH Construction Attributes MANDT
0 T5DB8 KOA04 T5DBH Construction Attributes BSATY
0 T5DB8 KOA04 T5DBH Construction Attributes BSATT
0 T5DB8 KOA04 T5DBH Construction Attributes ENDDA
1 T5DB8 KOA05 T5DBH Construction Attributes MANDT
1 T5DB8 KOA05 T5DBH Construction Attributes BSATY
1 T5DB8 KOA05 T5DBH Construction Attributes BSATT
1 T5DB8 KOA05 T5DBH Construction Attributes ENDDA
0 T5DB8 KOA06 T5DBH Construction Attributes MANDT
0 T5DB8 KOA06 T5DBH Construction Attributes BSATY
0 T5DB8 KOA06 T5DBH Construction Attributes BSATT
0 T5DB8 KOA06 T5DBH Construction Attributes ENDDA
1 T5DB8 KOA07 T5DBH Construction Attributes MANDT
1 T5DB8 KOA07 T5DBH Construction Attributes BSATY
1 T5DB8 KOA07 T5DBH Construction Attributes BSATT
1 T5DB8 KOA07 T5DBH Construction Attributes ENDDA
0 T5DB8 KOA08 T5DBH Construction Attributes MANDT
0 T5DB8 KOA08 T5DBH Construction Attributes BSATY
0 T5DB8 KOA08 T5DBH Construction Attributes BSATT
0 T5DB8 KOA08 T5DBH Construction Attributes ENDDA
1 T5DB8 KOKRS TKA01 Controlling Areas MANDT
0 T5DB8 KOLON T5DB7 Obsolete: Team Description MANDT
0 T5DB8 KOLON T5DB7 Obsolete: Team Description WERKS
0 T5DB8 KOLON T5DB7 Obsolete: Team Description BTRTL
0 T5DB8 KOLON T5DB7 Obsolete: Team Description ENDDA
1 T5DB8 KOSCH T508A Work Schedule Rules MANDT
1 T5DB8 KOSCH T508A Work Schedule Rules ZEITY
1 T5DB8 KOSCH T508A Work Schedule Rules MOFID
1 T5DB8 KOSCH T508A Work Schedule Rules MOSID
1 T5DB8 KOSCH T508A Work Schedule Rules SCHKZ
1 T5DB8 KOSCH T508A Work Schedule Rules ENDDA
0 T5DB8 KOSTL CSKS Cost Center Master Record MANDT
0 T5DB8 KOSTL CSKS Cost Center Master Record KOKRS
0 T5DB8 KOSTL CSKS Cost Center Master Record KOSTL
0 T5DB8 KOSTL CSKS Cost Center Master Record DATBI
1 T5DB8 KSTRG CKPH Master Record: Cost Object ID Number MANDT
1 T5DB8 KSTRG CKPH Master Record: Cost Object ID Number KSTRG
1 T5DB8 KSTRG CKPH Master Record: Cost Object ID Number DATBI
0 T5DB8 NPLNR AUFK Order master data AUFNR
1 T5DB8 POSNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
1 T5DB8 POSNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
0 T5DB8 PRAEK T5DBK Construction Pay Constants MANDT
0 T5DB8 PRAEK T5DBK Construction Pay Constants KONST
0 T5DB8 PRAEK T5DBK Construction Pay Constants ENDDA
1 T5DB8 WERKS T500P Personnel Areas MANDT
1 T5DB8 WERKS T500P Personnel Areas PERSA