SAP ABAP Table SCY_PERSON (Subset structure of PERSON)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ CY01 (Package) R/3 Application Development: Resource Planning

Basic Data

Table Category	INTTAB	Structure
Structure	SCY_PERSON	Table Relationship Diagram
Short Description	Subset structure of PERSON

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	.INCLUDE	☐				0	0	Standard Selection of Persons for Manpower Planning
2	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
3	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
4	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
5	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
6	STATUS	☐	STAT2	STATA	CHAR	1	0	Employment Status
7	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	WERKS	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	*
9	PERSG	☐	PERSG	PERSG	CHAR	1	0	Employee Group	*
10	PERSK	☐	PERSK	PERSK	CHAR	2	0	Employee Subgroup	*
11	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
12	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
13	ORGEH	☐	ORGEH	ORGEH	NUMC	8	0	Organizational Unit	*
14	ORGEH_TXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
15	PLANS	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID	*
16	PLANS_TXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
17	STELL	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID	*
18	STELL_TXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
19	ANRED	☐	ANRDE	ANRDE	CHAR	1	0	Form-of-Address Key	*
20	ENAME	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
21	NACHN	☐	NACHN	NACHN	CHAR	25	0	Last Name
22	VORNA	☐	VORNA	VORNM	CHAR	25	0	First Name
23	TITEL	☐	TITEL	TITEL	CHAR	15	0	Title	*
24	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
25	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
26	NATIO	☐	NATSL	LAND1	CHAR	3	0	Nationality	T005
27	KONFE	☐	KONFE	KONFE	CHAR	2	0	Religious Denomination Key	*
28	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	*
29	PSTLZ	☐	PSTLZ_BAS	PSTLZ	CHAR	10	0	Postal code
30	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
31	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
32	LAND	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
33	TELNR	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
34	USRTY	☐	USRTY	SUBTY_591A	CHAR	4	0	Communication Type	*
35	SYSID	☐	SYSID	CHAR30	CHAR	30	0	Communication Identification/Number
36	.INCLU--AP	☐				0	0	Append Structure for PERSON

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SCY_PERSON	BUKRS	T001	BUKRS
2	SCY_PERSON	KOKRS	TKA01	KOKRS
3	SCY_PERSON	KOSTL	CSKS	KOSTL
4	SCY_PERSON	LAND	T005	LAND1
5	SCY_PERSON	NATIO	T005	LAND1
6	SCY_PERSON	OTYPE	T778O	OTYPE

History

Last changed by/on	SAP	20130529
SAP Release Created in