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