SAP ABAP Table DIADRP (Person Address)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ ICSV (Package) R/3 Customer Service

Basic Data

Table Category	INTTAB	Structure
Structure	DIADRP	Table Relationship Diagram
Short Description	Person 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	Address
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
4	NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
5	NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
6	NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
7	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
8	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
9	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
10	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
11	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
12	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
13	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
14	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
15	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
16	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
17	FAX_NUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
18	TLX_NUMBER	☐	AD_TLXNMBR	TEXT30	CHAR	30	0	Telex number
19	TTX_NUMBER	☐	AD_TTXNMBR	TEXT30	CHAR	30	0	Teletex number
20	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
21	NAME_LIST	☐	I_NAME_LST	NAME	CHAR	35	0	Name for list displays
22	REMARK	☐	AD_REMARK1	TEXT50	CHAR	50	0	Address notes
23	TZONSP	☐	TZONSP	TZNZONE	CHAR	6	0	Time zone for partner	TTZZ
24	DATUM	☐	SYDATUM	SYDATS	DATS	8	0	System Date
25	UZEIT	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
26	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
27	TITLE	☐	AD_TITLETX	TEXT30	CHAR	30	0	Title text
28	DEPARTMENT	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
29	FUNCTION	☐	AD_FNCTN	TEXT40	CHAR	40	0	Function
30	NICKNAME	☐	AD_NICKNAM	TEXT40	CHAR	40	0	Nickname or name used
31	SEX	☐	AD_SEX	AD_SEX	CHAR	1	0	Gender key
32	PAFKT	☐	PAFKT	PAFKT	CHAR	2	0	Contact person function	*
33	PARVO	☐	PARVO	PARVO	CHAR	1	0	Partner's power of attorney	*
34	PAVIP	☐	PAVIP	PAVIP	CHAR	1	0	VIP Partner	*
35	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
36	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	*
37	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DIADRP	COUNTRY	T005	LAND1
2	DIADRP	LANGU	T002	SPRAS
3	DIADRP	MANDT	T000	MANDT
4	DIADRP	REGION	T005S	BLAND
5	DIADRP	TZONSP	TTZZ	TZONE

History

Last changed by/on	SAP	20130529
SAP Release Created in