SAP ABAP Table SH_PREMS (Generated Table for View)

Basic Data

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

Delivery and Maintenance

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

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	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	KOSTL	☑	KOSTL	KOSTL	CHAR	10	0	Cost Center
4	GSBER	☑	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
5	WERKS	☑	PERSA	PERSA	CHAR	4	0	Personnel Area	T500P
6	PERSG	☑	PERSG	PERSG	CHAR	1	0	Employee Group	T501
7	PERSK	☑	PERSK	PERSK	CHAR	2	0	Employee Subgroup	T503K
8	BTRTL	☑	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	T001P
9	ORGEH	☑	ORGEH	ORGEH	NUMC	8	0	Organizational Unit	T527X
10	VDSK1	☑	VDSK1	VDSK1	CHAR	14	0	Organizational Key	T527O
11	SBMOD	☑	SBMOD	CHAR4	CHAR	4	0	Administrator Group
12	SACHZ	☑	SACHZ	SACHA	CHAR	3	0	Administrator for Time Recording	T526
13	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	PA0003
14	BEGDA	☑	BEGDA	DATUM	DATS	8	0	Start Date
15	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SH_PREMS	BTRTL	T001P	BTRTL	KEY	1	CN
2	SH_PREMS	BUKRS	T001	BUKRS	KEY	1	CN
3	SH_PREMS	GSBER	TGSB	GSBER	KEY	1	CN
4	SH_PREMS	MANDT	T000	MANDT	KEY	1	CN
5	SH_PREMS	ORGEH	T527X	ORGEH
6	SH_PREMS	PERNR	PA0003	PERNR	KEY	1	CN
7	SH_PREMS	PERSG	T501	PERSG	KEY	1	CN
8	SH_PREMS	PERSK	T503K	PERSK	KEY	1	CN
9	SH_PREMS	SACHZ	T526	SACHX
10	SH_PREMS	VDSK1	T527O	ORGKY
11	SH_PREMS	WERKS	T500P	PERSA	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in