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

History

Last changed by/on	SAP	20110901
SAP Release Created in