SAP ABAP Table SPKO1_ROL (RE: Partner (Role, Object) - Telephone and Addit.Fields)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

Table Category	INTTAB	Structure
Structure	SPKO1_ROL	Table Relationship Diagram
Short Description	RE: Partner (Role, Object) - Telephone and Addit.Fields

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	RE: Partner (Role, Object) - Address and Additional Fields
2	SPRSLRCP	☐	VVSPRSLRCP	SPRAS	LANG	1	0	Language key for texts for letter printout	*
3	APPL	☐	BP_APPL	BP_APPL	CHAR	4	0	Application Category	*
4	XAPPL	☐	BP_XAPPL	TEXT30	CHAR	30	0	Application Name
5	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
6	ROLETYP	☐	BP_ROLETYP	BP_ROLETYP	CHAR	4	0	Business Partner Role Category	*
7	XROLETYP	☐	BP_XROLTYP	TEXT30	CHAR	30	0	Name of Role Category
8	ROLE	☐	BP_ROLE	BP_ROLE	CHAR	4	0	Business Partner Role Type	*
9	XROLE	☐	BP_XROLE	TEXT30	CHAR	30	0	Name of role type
10	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
11	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	*
12	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	*
13	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number	*
14	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	*
15	SMIVE	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
16	ADR_REF	☐	BP_ADR_REF	BP_ADR_REF	CHAR	10	0	Address ID	*
17	.INCLUDE	☐				0	0	BP Structure: Business Partner - Address
18	.INCLUDE	☐				0	0	BP: Business partner - address
19	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
20	PARTNR	☐	BP_PARTNR_OLD	BP_PARTNR	CHAR	10	0	Business Partner Number	BP000
21	ADR_REF_K	☐	BP_ADR_REF_OLD	BP_ADR_REF	CHAR	10	0	Address ID	TP14
22	ADR_DAT	☐	BP_ADR_DAT	DATUM	DATS	8	0	Business partner address relationship valid from
23	.INCLUDE	☐				0	0	BP: Business Partner - Address Data
24	ADRNR	☐	BP_ADRNR_OLD	SADRNR	CHAR	10	0	Address Number	SANS1
25	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
26	ADDRESS_ID	☐	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID
27	ADR_D_E	☐	BP_ADR_D_E	DATUM	DATS	8	0	Business Partner Address Relationship Valid Until
28	ADR_LOC	☐	BP_ADR_LOC	CHAR20	CHAR	20	0	Building
29	FLOOR	☐	BP_FLOOR	CHAR10	CHAR	10	0	Floor
30	ROOM_NR	☐	BP_ROOM_NR	CHAR10	CHAR	10	0	Room Number
31	NAME3	☐	BP_NAME3	TEXT40	CHAR	40	0	Name 3
32	NAME4	☐	BP_NAME4	TEXT40	CHAR	40	0	Name 4
33	NAME_CO	☐	BP_NAME_CO	TEXT40	CHAR	40	0	c/o Name
34	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
35	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
36	.INCLUDE	☐				0	0	BP: Screen Structure Telecommunications Data
37	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
38	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
39	TELFX1	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
40	TELFX2	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
41	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
42	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
43	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
44	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
45	ADSMTP	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
46	TELNR_CALL1	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
47	TELNR_CALL2	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
48	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
49	.INCLUDE	☐				0	0	Additional fields for BPDADREF
50	.INCLUDE	☐				0	0	Additional fields for BP030
51	XADR_REF	☐	BP_XADRREF	TEXT40	CHAR	40	0	Description of Address ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SPKO1_ROL	ADDRNUMBER	ADRC	ADDRNUMBER	KEY
2	SPKO1_ROL	ADRNR	SANS1	ADRNR		1	CN
3	SPKO1_ROL	ADR_REF_K	TP14	ADR_REF	KEY	1	CN
4	SPKO1_ROL	MANDT	T000	MANDT
5	SPKO1_ROL	PARTNR	BP000	PARTNR	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in