SAP ABAP Table V_5DB4_B (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_5DB4_B	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	BAUID	☑	P01B_BAUID	P01B_BAUID	CHAR	1	0	Identification of CO Objects for HR Construction Sites
3	POSNR	☑	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
4	AUFNR	☑	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
5	KOKRS	☑	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
6	KOSTL	☑	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
7	NPLNR	☑	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
8	VORNR	☑	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
9	KDAUF	☑	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
10	KDPOS	☑	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
11	KSTRG	☑	KSTRG	KSTRG	CHAR	12	0	Cost Object	CKPH
12	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
13	GMDTX	☐	GMDTX	TEXT48	CHAR	48	0	Municipality
14	BGTXT	☐	BGTXT	TEXT25	CHAR	25	0	Workers' compensation association
15	GTTXT	☐	GTTXT	TEXT18	CHAR	18	0	Hazard Pay Scale Text
16	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
17	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
18	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
19	GMDN1	☐	GMNDN	GMNDN	NUMC	8	0	Municipality Number (D)	T5D2B
20	GMDP1	☐	P01B_GMDPR	DEC3_2	DEC	5	2	Percentage Rate of Trade Tax for Municipality
21	GMDN2	☐	GMNDN	GMNDN	NUMC	8	0	Municipality Number (D)	T5D2B
22	GMDP2	☐	P01B_GMDPR	DEC3_2	DEC	5	2	Percentage Rate of Trade Tax for Municipality
23	GMDN3	☐	GMNDN	GMNDN	NUMC	8	0	Municipality Number (D)	T5D2B
24	GMDP3	☐	P01B_GMDPR	DEC3_2	DEC	5	2	Percentage Rate of Trade Tax for Municipality
25	STSPA	☐	P01B_STSPA	P013_STSPA	CHAR	4	0	Division of State Statistics Office
26	BRFGN	☐	P015_BRFGN	P015_BRFGN	CHAR	2	0	Workers' Compensation Association	T5D3A
27	GFTGE	☐	P01B_GFTGE	P015_GFTST	CHAR	2	0	Hazard Pay Area: Industrial Workers	T5D3B
28	GFTAN	☐	P01B_GFTAN	P015_GFTST	CHAR	2	0	Hazard Pay Area Employees	T5D3B
29	BRFGP	☐	P01B_BRFGP	DEC3_2	DEC	5	2	Workers' Compensation Association Percentage
30	BGKAG	☐	P01B_BGKAG	CHAR10	CHAR	10	0	WCA Company Number: Risk Category (Salaried Employees)
31	BGKGW	☐	P01B_BGKGW	CHAR10	CHAR	10	0	WCA Company Number: Risk Category (Industrial Workers)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_5DB4_B	AUFNR	AUFK	AUFNR	KEY	C	CN
2	V_5DB4_B	BRFGN	T5D3A	BRFGN	REF	C	CN
3	V_5DB4_B	GFTAN	T5D3B	GFTST	REF	C	CN
4	V_5DB4_B	GFTGE	T5D3B	GFTST	REF	C	CN
5	V_5DB4_B	GMDN1	T5D2B	GMDNR	REF	1	CN
6	V_5DB4_B	GMDN2	T5D2B	GMDNR	REF	1	CN
7	V_5DB4_B	GMDN3	T5D2B	GMDNR	REF	1	CN
8	V_5DB4_B	KDAUF	VBUK	VBELN	KEY	C	CN
9	V_5DB4_B	KOKRS	TKA01	KOKRS	KEY	C	CN
10	V_5DB4_B	KOSTL	CSKS	KOSTL	KEY	C	CN
11	V_5DB4_B	KSTRG	CKPH	KSTRG	KEY	C	CN
12	V_5DB4_B	MANDT	T000	MANDT	KEY	1	CN
13	V_5DB4_B	NPLNR	AUFK	AUFNR	KEY	C	CN
14	V_5DB4_B	POSNR	PRPS	PSPNR	KEY	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in