SAP ABAP Table COMT_BSP_BP_EMPLOYEE_REL_DATA (Employee Relationship Data)

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ CA-GTF-PCU-BP (Application Component) Dialog People-Centric UI for Business Partner
     ⤷ COM_BSP_MODEL_IL_BP (Package) Central Parts of BP from the BSP Development

Basic Data

Table Category	INTTAB	Structure
Structure	COMT_BSP_BP_EMPLOYEE_REL_DATA	Table Relationship Diagram
Short Description	Employee Relationship Data

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	Data of Organization x
2	RELNR	☐	BU_RELNR	BU_RELNR	CHAR	12	0	BP Relationship Number	*
3	ORG_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
4	ORG_NAME1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
5	ORG_NAME2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
6	REL_ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
7	REL_CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
8	REL_POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
9	REL_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
10	REL_REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
11	REL_STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
12	REL_HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
13	REL_COUNTRY_TEXT	☐	COMT_BU_COUNTRY_DESCRIPTION	TEXT50	CHAR	50	0	Country Description
14	REL_REGION_TEXT	☐	COMT_BU_REGION_DESCRIPTION	TEXT20	CHAR	20	0	Region (State, Province, County)
15	.INCLUDE	☐				0	0	Person Data of Relation
16	REL_BUILDING_P	☐	AD_BLDNG_P	TEXT10	CHAR	10	0	Building (number or code)
17	REL_FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
18	REL_ROOM_NO	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
19	REL_INITS_SIG	☐	AD_ID_CODE	TEXT10	CHAR	10	0	Short name for correspondence
20	REL_INHOUSE_ML	☐	AD_IH_MAIL	TEXT10	CHAR	10	0	Int. mail postal code
21	REL_COMM_TYPE	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	*
22	REL_DEPARTMENT	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
23	REL_FUNCTION	☐	AD_FNCTN	TEXT40	CHAR	40	0	Function
24	REL_PAFKT	☐	BU_PAFKT	BU_PAFKT	CHAR	4	0	Function of partner	*
25	REL_ABTNR	☐	BU_ABTNR	BU_ABTNR	CHAR	4	0	Department	*
26	REL_CALLER_NO	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
27	REL_PHONE_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
28	REL_COUNTRY_FOR_TEL	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
29	REL_TELEPHONE	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
30	REL_PHONE_EXTENSION	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
31	REL_MOBIL_PHONE	☐	AD_MBNMBR1	CHAR30	CHAR	30	0	First Mobile Telephone No.: Dialing Code + Number
32	REL_MOBIL_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
33	REL_MOBIL_COUNTRY	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
34	REL_MOBILE_TELEPHONE	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
35	REL_EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
36	REL_EMAIL_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
37	REL_FAXNUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
38	REL_FAX_CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
39	REL_FAX_COUNTRY	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
40	REL_FAX	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
41	REL_FAX_EXTENSION	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	COMT_BSP_BP_EMPLOYEE_REL_DATA	REL_COUNTRY	T005	LAND1	REF	C	CN
2	COMT_BSP_BP_EMPLOYEE_REL_DATA	REL_REGION	T005S	BLAND	REF	C	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	700