SAP ABAP Table /TDAG/CPS_ADDR_COMPANY_EXT (CP: Extended company address)

Hierarchy

☛ TDAGBCA (Software Component) TechniData Basic Components
   ⤷ EHS (Application Component) Environment, Health and Safety
     ⤷ /TDAG/CP (Package) Compliance for products

Basic Data

Table Category	INTTAB	Structure
Structure	/TDAG/CPS_ADDR_COMPANY_EXT	Table Relationship Diagram
Short Description	CP: Extended company 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	CP: Company address
2	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
3	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
4	NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
5	NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
6	NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
7	NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
8	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
9	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
10	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
11	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	*
12	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	*
13	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
14	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
15	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
16	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
17	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
18	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
19	DEFLT_COMM	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	*
20	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
21	EXT_NUMBER	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
22	FAX_NUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
23	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
24	URL_ADDR	☐	/TDAG/CPE_WWW	CHAR80	CHAR	80	0	URL Address
25	DUNS	☐	/TDAG/CPE_DUNS	TEXT9	CHAR	9	0	Data Universal Numbering System
26	SMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
27	TEL_COUNTRY	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
28	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
29	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
30	LGENT	☐	/TDAG/RCSE_LEGENT	BUKRS	CHAR	4	0	Legal Entity	*
31	P_ROLE	☐	PARVW	PARVW	CHAR	2	0	Partner Role	*
32	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
33	KTOKK	☐	KTOKK	KTOKK	CHAR	4	0	Vendor account group	*
34	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	*
35	TITLETX	☐	AD_TITLETX	TEXT30	CHAR	30	0	Title text
36	COUNTRYTX	☐	LANDX	TEXT15	CHAR	15	0	Country Name
37	REGIONTX	☐	BEZEI20	TEXT20	CHAR	20	0	Description
38	TELEFFROM	☐	SKTELFFROM	CHAR4	CHAR	4	0	International Dialing Code for Telephone/Fax
39	TELEFTO	☐	SKTELFTO	CHAR4	CHAR	4	0	Country telephone/fax dialling code

History

Last changed by/on	SAP	20141109
SAP Release Created in	110_600