SAP ABAP Table CRMT_BUPA_IL_EMP_STDWP_ADDRESS (IL structure for standard work address - enhanced)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP-DAT (Application Component) CRM Specific Business Partner Data
     ⤷ CRM_BUPA_BOL (Package) Interaction Layer for Business Partner (From 5.1)

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BUPA_IL_EMP_STDWP_ADDRESS	Table Relationship Diagram
Short Description	IL structure for standard work address - enhanced

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	IL: Employee Workplace Address
2	.INCLUDE	☐				0	0	Key Structure for Relations in BOL
3	PARENT_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
4	PARTNER1	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
5	PARTNER2	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
6	RELATIONSHIPCATEGORY	☐	BU_RELTYP	BU_RELTYP	CHAR	6	0	Business Partner Relationship Category	*
7	VALIDFROMDATE	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
8	VALIDUNTILDATE	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
9	DIFFERENTIATIONTYPEVALUE	☐	BU_DFTVAL	CHAR20	CHAR	20	0	BP: Differentiation type characteristic (change doc.-rel.)
10	ADDRESS_GUID	☐	BU_ADDRESS_GUID	SYSUUID	RAW	16	0	GUID of a Business Partner Address
11	.INCLUDE	☐				0	0	SAP BP, CP Rel.: BAPI Structure for Address Data
12	STANDARDADDRESS	☐	BU_XDFADR	XFELD	CHAR	1	0	Indicator: Address is standard address
13	BUILDING_P	☐	AD_BLDNG_P	TEXT10	CHAR	10	0	Building (number or code)
14	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
15	ROOM_NO	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
16	INITS_SIG	☐	AD_ID_CODE	TEXT10	CHAR	10	0	Short name for correspondence
17	INHOUSE_ML	☐	AD_IH_MAIL	TEXT10	CHAR	10	0	Int. mail postal code
18	COMM_TYPE	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	TSAC
19	DEPARTMENT	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
20	FUNCTION	☐	AD_FNCTN	TEXT40	CHAR	40	0	Function
21	ADDR_SHORT	☐	AD_LINE_S	CHAR80	CHAR	80	0	One-line short form of formatted address
22	.INCLU-TEL	☐				0	0	BUIL: Structure of the Telephone Number Object
23	.INCLUDE	☐				0	0	BAPI Structure for Telephone Numbers (Bus. Address Services)
24	COUNTRYTEL	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	T005
25	COUNTRYISOTEL	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
26	STD_NOTEL	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
27	TELEPHONETEL	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
28	EXTENSIONTEL	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
29	TEL_NOTEL	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
30	CALLER_NOTEL	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
31	STD_RECIPTEL	☐	AD_FLGSMS	AD_FLGSMS	CHAR	1	0	Indicator: Telephone is SMS-Enabled
32	R_3_USERTEL	☐	AD_FLGMOB	AD_FLGMOB	CHAR	1	0	Indicator: Telephone is a Mobile Telephone
33	HOME_FLAGTEL	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
34	CONSNUMBERTEL	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
35	ERRORFLAGTEL	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
36	FLG_NOUSETEL	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
37	VALID_FROMTEL	☐	AD_VALFROM	TIMESTMP	CHAR	14	0	Communication Data: Valid From (YYYYMMDDHHMMSS)
38	VALID_TOTEL	☐	AD_VALTO	TIMESTAMP	CHAR	14	0	Communication Data: Valid To (YYYYMMDDHHMMSS)
39	LANGUTEL	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
40	LANGU_ISOTEL	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
41	COMM_NOTESTEL	☐	AD_REMARK2	TEXT50	CHAR	50	0	Communication link notes
42	VALIDFROMDATETEL	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
43	VALIDTODATETEL	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
44	.INCLU-FAX	☐				0	0	BUIL : structure for Fax numbers
45	.INCLUDE	☐				0	0	BAPI Structure for Fax Numbers (Business Address Services)
46	COUNTRYFAX	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	T005
47	COUNTRYISOFAX	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
48	STD_NOFAX	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
49	FAXFAX	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
50	EXTENSIONFAX	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
51	FAX_NOFAX	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
52	SENDER_NOFAX	☐	AD_FAXNRCL	CHAR30	CHAR	30	0	Fax number for finding sender
53	FAX_GROUPFAX	☐	AD_FXGRP	AD_FXGRP	CHAR	1	0	Fax group (G3, G4, ...)
54	STD_RECIPFAX	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
55	R_3_USERFAX	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
56	HOME_FLAGFAX	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
57	CONSNUMBERFAX	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
58	ERRORFLAGFAX	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
59	FLG_NOUSEFAX	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
60	VALID_FROMFAX	☐	AD_VALFROM	TIMESTMP	CHAR	14	0	Communication Data: Valid From (YYYYMMDDHHMMSS)
61	VALID_TOFAX	☐	AD_VALTO	TIMESTAMP	CHAR	14	0	Communication Data: Valid To (YYYYMMDDHHMMSS)
62	LANGUFAX	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
63	LANGU_ISOFAX	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
64	COMM_NOTESFAX	☐	AD_REMARK2	TEXT50	CHAR	50	0	Communication link notes
65	VALIDFROMDATEFAX	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
66	VALIDTODATEFAX	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
67	.INCLU-SMT	☐				0	0	BUIL: structure for Email Addresses
68	.INCLUDE	☐				0	0	BAPI Structure for E-Mail Addresses (Bus. Address Services)
69	STD_NOSMT	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
70	E_MAILSMT	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
71	EMAIL_SRCHSMT	☐	AD_SMTPAD2	CHAR20	CHAR	20	0	E-Mail Address Search Field
72	STD_RECIPSMT	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
73	R_3_USERSMT	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
74	ENCODESMT	☐	AD_ENCODE	AD_ENCODE	CHAR	1	0	Desired Data Coding (E-Mail)
75	TNEFSMT	☐	AD_TNEF6	XFELD	CHAR	1	0	Flag: Receiver can receive TNEF coding via SMTP
76	HOME_FLAGSMT	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
77	CONSNUMBERSMT	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
78	ERRORFLAGSMT	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
79	FLG_NOUSESMT	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
80	VALID_FROMSMT	☐	AD_VALFROM	TIMESTMP	CHAR	14	0	Communication Data: Valid From (YYYYMMDDHHMMSS)
81	VALID_TOSMT	☐	AD_VALTO	TIMESTAMP	CHAR	14	0	Communication Data: Valid To (YYYYMMDDHHMMSS)
82	LANGUSMT	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
83	LANGU_ISOSMT	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
84	COMM_NOTESSMT	☐	AD_REMARK2	TEXT50	CHAR	50	0	Communication link notes
85	VALIDFROMDATESMT	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
86	VALIDTODATESMT	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
87	.INCLU-MOB	☐				0	0	BUIL: Structure of the Telephone Number Object
88	.INCLUDE	☐				0	0	BAPI Structure for Telephone Numbers (Bus. Address Services)
89	COUNTRYMOB	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	T005
90	COUNTRYISOMOB	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
91	STD_NOMOB	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
92	TELEPHONEMOB	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
93	EXTENSIONMOB	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
94	TEL_NOMOB	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
95	CALLER_NOMOB	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
96	STD_RECIPMOB	☐	AD_FLGSMS	AD_FLGSMS	CHAR	1	0	Indicator: Telephone is SMS-Enabled
97	R_3_USERMOB	☐	AD_FLGMOB	AD_FLGMOB	CHAR	1	0	Indicator: Telephone is a Mobile Telephone
98	HOME_FLAGMOB	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
99	CONSNUMBERMOB	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
100	ERRORFLAGMOB	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
101	FLG_NOUSEMOB	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
102	VALID_FROMMOB	☐	AD_VALFROM	TIMESTMP	CHAR	14	0	Communication Data: Valid From (YYYYMMDDHHMMSS)
103	VALID_TOMOB	☐	AD_VALTO	TIMESTAMP	CHAR	14	0	Communication Data: Valid To (YYYYMMDDHHMMSS)
104	LANGUMOB	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
105	LANGU_ISOMOB	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
106	COMM_NOTESMOB	☐	AD_REMARK2	TEXT50	CHAR	50	0	Communication link notes
107	VALIDFROMDATEMOB	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
108	VALIDTODATEMOB	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
109	REM_LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
110	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
111	POSTL_COD1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
112	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
113	HOUSE_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
114	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
115	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BUPA_IL_EMP_STDWP_ADDRESS	COMM_TYPE	TSAC	COMM_TYPE	REF	C	CN
2	CRMT_BUPA_IL_EMP_STDWP_ADDRESS	COUNTRYFAX	T005	LAND1	REF	C	CN
3	CRMT_BUPA_IL_EMP_STDWP_ADDRESS	COUNTRYMOB	T005	LAND1	REF	C	CN
4	CRMT_BUPA_IL_EMP_STDWP_ADDRESS	COUNTRYTEL	T005	LAND1	REF	C	CN

History

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