SAP ABAP Table SANS1_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	SANS1_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	PARTNR	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number	*
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: Address
18	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
19	ADRNR	☐	BP_ADRNR_OLD	SADRNR	CHAR	10	0	Address Number	*
20	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
21	STRA1	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
22	STRA2	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
23	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
24	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
25	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
26	PSTBZ	☐	PSTBZ	PSTBZ	CHAR	15	0	Post delivery district
27	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
28	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
29	.INCLUDE	☐				0	0	Additional fields for BPADR
30	XLAND	☐	LANDX	TEXT15	CHAR	15	0	Country Name
31	XREGIO	☐	XREGIO	TEXT20	CHAR	20	0	Name of region
32	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SANS1_ROL	LAND1	T005	LAND1
2	SANS1_ROL	MANDT	T000	MANDT
3	SANS1_ROL	REGIO	T005S	BLAND

History

Last changed by/on	SAP	20130529
SAP Release Created in