SAP ABAP Table CRMT_REC_DWP_TECHNICIAN_INFOS (Service Representative with Additional Information)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-RPL-SRV-RPT (Application Component) Resource Planning Tool
     ⤷ CRM_DWP_GRAPHIC (Package) Resource Planning Tool(Tech.Name:Dispatcher's Workplace/DWP)

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_REC_DWP_TECHNICIAN_INFOS	Table Relationship Diagram
Short Description	Service Representative with Additional Information

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	Service Representative in Resource Planning Tool
2	NAME	☐	STEXT	TEXT40	CHAR	40	0	Object Name
3	.INCLUDE	☐				0	0	RPT: Central Person -> Business Partner -> GUID
4	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
5	OBJID	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
6	BU_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
7	BU_PARTNER_GUID	☐	BU_PARTNER_GUID_BAPI	SYSUUID_C	CHAR	32	0	GUID of a Business Partner in CHAR 32 Format for BAPIs
8	REL_BEGDA	☐	I1001BEGDA	DATUM	DATS	8	0	Start Date of Relationship
9	REL_ENDDA	☐	I1001ENDDA	DATUM	DATS	8	0	End Date of Relationship
10	GROUP_OBJID	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
11	REL_VALIDITY	☐	CRMT_T_DWP_TIMEINTERVALS		TTYP	0	0
12	.INCLU-_AD	☐				0	0	SAP BP: BAPI Structure for Address Data
13	STANDARDADDRESS_AD	☐	BU_XDFADR	XFELD	CHAR	1	0	Indicator: Address is standard address
14	C_O_NAME_AD	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
15	CITY_AD	☐	AD_CITY1	TEXT40	CHAR	40	0	City
16	DISTRICT_AD	☐	AD_CITY2	TEXT40	CHAR	40	0	District
17	REGIOGROUP_AD	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	ADRREGGRP
18	POSTL_COD1_AD	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
19	POSTL_COD2_AD	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
20	POSTL_COD3_AD	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
21	PCODE1_EXT_AD	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
22	PCODE2_EXT_AD	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
23	PCODE3_EXT_AD	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
24	PO_BOX_AD	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
25	PO_W_O_NO_AD	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
26	PO_BOX_CIT_AD	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
27	PO_BOX_REG_AD	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	T005S
28	POBOX_CTRY_AD	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	T005
29	PO_CTRYISO_AD	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
30	STREET_AD	☐	AD_STREET	TEXT60	CHAR	60	0	Street
31	STR_ABBR_AD	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name	ADRSTRTYPE
32	HOUSE_NO_AD	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
33	HOUSE_NO2_AD	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
34	HOUSE_NO3_AD	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
35	STR_SUPPL1_AD	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
36	STR_SUPPL2_AD	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
37	STR_SUPPL3_AD	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
38	LOCATION_AD	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
39	BUILDING_AD	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
40	FLOOR_AD	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
41	ROOM_NO_AD	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
42	COUNTRY_AD	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
43	COUNTRYISO_AD	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
44	REGION_AD	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
45	TIME_ZONE_AD	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	TTZZ
46	TAXJURCODE_AD	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
47	HOME_CITY_AD	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
48	TRANSPZONE_AD	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	*
49	LANGU_AD	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
50	LANGUISO_AD	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
51	COMM_TYPE_AD	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	*
52	EXTADDRESSNUMBER_AD	☐	BU_ADEXT	BU_ADEXT	CHAR	20	0	Address number in external system
53	DONT_USE_P_AD	☐	AD_NO_USEP	AD_NO_USE	CHAR	4	0	PO Box Address Undeliverable Flag	*
54	DONT_USE_S_AD	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag	*
55	MOVE_DATE_AD	☐	BU_MOVEDAT	DATUM	DATS	8	0	Date of Move
56	MOVE_ADDRESS_AD	☐	BU_MOVE_ADDR	AD_ADDRNUM	CHAR	10	0	Number of Move Target Address for Address Moves	*
57	VALIDFROMDATE_AD	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
58	VALIDTODATE_AD	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
59	MOVE_ADDR_GUID_AD	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
60	CITY_NO_AD	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	*
61	DISTRCT_NO_AD	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	*
62	CHCKSTATUS_AD	☐	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
63	PBOXCIT_NO_AD	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)	*
64	STREET_NO_AD	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	*
65	HOMECITYNO_AD	☐	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file	*
66	PO_BOX_LOBBY_AD	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
67	DELI_SERV_TYPE_AD	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service	*
68	DELI_SERV_NUMBER_AD	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
69	COUNTY_AD	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
70	COUNTY_NO_AD	☐	AD_CNTYNUM	CNTY_CODE	CHAR	8	0	County code for county	*
71	TOWNSHIP_AD	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
72	TOWNSHIP_NO_AD	☐	AD_TWSHPNUM	TWSHP_CODE	CHAR	8	0	Township code for Township	*
73	.INCLU-_TE	☐				0	0	BAPI Structure for Telephone Numbers (Bus. Address Services)
74	COUNTRY_TE	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	T005
75	COUNTRYISO_TE	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
76	STD_NO_TE	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
77	TELEPHONE_TE	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
78	EXTENSION_TE	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
79	TEL_NO_TE	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
80	CALLER_NO_TE	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
81	STD_RECIP_TE	☐	AD_FLGSMS	AD_FLGSMS	CHAR	1	0	Indicator: Telephone is SMS-Enabled
82	R_3_USER_TE	☐	AD_FLGMOB	AD_FLGMOB	CHAR	1	0	Indicator: Telephone is a Mobile Telephone
83	HOME_FLAG_TE	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
84	CONSNUMBER_TE	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
85	ERRORFLAG_TE	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
86	FLG_NOUSE_TE	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
87	VALID_FROM_TE	☐	AD_VALFROM	TIMESTMP	CHAR	14	0	Communication Data: Valid From (YYYYMMDDHHMMSS)
88	VALID_TO_TE	☐	AD_VALTO	TIMESTAMP	CHAR	14	0	Communication Data: Valid To (YYYYMMDDHHMMSS)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_REC_DWP_TECHNICIAN_INFOS	COUNTRY_AD	T005	LAND1	REF	1	CN
2	CRMT_REC_DWP_TECHNICIAN_INFOS	COUNTRY_TE	T005	LAND1	REF	C	CN
3	CRMT_REC_DWP_TECHNICIAN_INFOS	POBOX_CTRY_AD	T005	LAND1	REF	C	CN
4	CRMT_REC_DWP_TECHNICIAN_INFOS	PO_BOX_REG_AD	T005S	BLAND		C	CN
5	CRMT_REC_DWP_TECHNICIAN_INFOS	REGIOGROUP_AD	ADRREGGRP	REGIOGROUP	REF	C	CN
6	CRMT_REC_DWP_TECHNICIAN_INFOS	REGION_AD	T005S	BLAND	REF	C	CN
7	CRMT_REC_DWP_TECHNICIAN_INFOS	STR_ABBR_AD	ADRSTRTYPE	STRTYPEAB	REF	C	CN
8	CRMT_REC_DWP_TECHNICIAN_INFOS	TIME_ZONE_AD	TTZZ	TZONE	REF	C	CN

History

Last changed by/on	SAP	20141013
SAP Release Created in	12A