SAP ABAP Table V_T5DB8 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_T5DB8	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	WERKS	☑	PERSA	PERSA	CHAR	4	0	Personnel Area	T500P
3	BTRTL	☑	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	T001P
4	KOLON	☑	P01B_KOLON	P01B_KOLON	CHAR	4	0	Team	T5DB7
5	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
6	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
7	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
8	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
9	ZEITY	☐	DZEITY	ZEITY	CHAR	1	0	Employee Subgroup Grouping for Work Schedules
10	MOFID	☐	HIDENT	HIDENT	CHAR	2	0	Public Holiday Calendar	THOCI
11	KOSCH	☐	P01B_KOSCH	SCHKN	CHAR	8	0	Work schedule rule	T508A
12	MEHRR	☐	P01B_MEHRR	P01B_MEHKN	CHAR	2	0	Overtime Rule
13	AKKOR	☐	P01B_AKKOR	P01B_AKKOR	CHAR	2	0	Piecework Rule
14	RUEST	☐	P01B_RUEST	DEC3_2	DEC	5	2	Setup time
15	BTEXT	☐	BTRTX	TEXT15	CHAR	15	0	Personnel Subarea Text
16	KOTXT	☐	P01B_KOTXT	TEXT40	CHAR	40	0	Team Name
17	NAME1	☐	PBTXT	TEXT30	CHAR	30	0	Personnel Area Text
18	LTEXT	☐	FKTEXT	TEXT60	CHAR	60	0	Object Text
19	PRAEK	☐	P01B_PRAEK	P01B_KONST	CHAR	5	0	Premium Identifier	T5DBK
20	KOA01	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
21	KOA02	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
22	KOA03	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
23	KOA04	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
24	KOA05	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
25	KOA06	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
26	KOA07	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
27	KOA08	☐	P01B_BSATT	P01B_BSATT	CHAR	2	0	Attributes	T5DBH
28	POSNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
29	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
30	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
31	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
32	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
33	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
34	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
35	ARTDA	☐	P01B_ARTDA	P01B_BSATT	CHAR	2	0	Type of Work	T5DBH
36	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
37	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
38	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	CKPH
39	BSATX	☐	P01B_BSATX	TEXT20	CHAR	20	0	Text for Construction Industry Attributes

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_T5DB8	ARTDA	T5DBH	BSATT	REF	C	CN
2	V_T5DB8	AUFNR	AUFK	AUFNR	REF	C	CN
3	V_T5DB8	BTRTL	T001P	BTRTL	KEY	1	CN
4	V_T5DB8	BUKRS	T001	BUKRS		C	CN
5	V_T5DB8	KDAUF	VBUK	VBELN	REF	C	CN
6	V_T5DB8	KOA01	T5DBH	BSATT	REF	C	CN
7	V_T5DB8	KOA02	T5DBH	BSATT	REF	C	CN
8	V_T5DB8	KOA03	T5DBH	BSATT	REF	C	CN
9	V_T5DB8	KOA04	T5DBH	BSATT	REF	C	CN
10	V_T5DB8	KOA05	T5DBH	BSATT	REF	C	CN
11	V_T5DB8	KOA06	T5DBH	BSATT	REF	C	CN
12	V_T5DB8	KOA07	T5DBH	BSATT	REF	C	CN
13	V_T5DB8	KOA08	T5DBH	BSATT	REF	C	CN
14	V_T5DB8	KOKRS	TKA01	KOKRS	REF	C	CN
15	V_T5DB8	KOLON	T5DB7	KOLON	KEY	1	CN
16	V_T5DB8	KOSCH	T508A	SCHKZ	REF	C	CN
17	V_T5DB8	KOSTL	CSKS	KOSTL	REF	C	CN
18	V_T5DB8	KSTRG	CKPH	KSTRG	REF	C	CN
19	V_T5DB8	MANDT	T000	MANDT	KEY	1	CN
20	V_T5DB8	MOFID	THOCI	IDENT	REF	C	CN
21	V_T5DB8	NPLNR	AUFK	AUFNR	REF	C	CN
22	V_T5DB8	POSNR	PRPS	PSPNR	REF	C	CN
23	V_T5DB8	PRAEK	T5DBK	KONST	REF	C	CN
24	V_T5DB8	WERKS	T500P	PERSA	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in