SAP ABAP Table OPS_IHPAD (Structure for partner details)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ IPRT (Package) Application Development R/3 Plant Maintenance Print

Basic Data

Table Category	INTTAB	Structure
Structure	OPS_IHPAD	Table Relationship Diagram
Short Description	Structure for partner details

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	LANDX	☐	LANDX	TEXT15	CHAR	15	0	Country Name
2	.INCLUDE	☐				0	0	Partner dialog table
3	.INCLUDE	☐				0	0	Reference structure for XIHPA
4	.INCLUDE	☐				0	0	Plant Maintenance: Partners
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
6	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
7	PARVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	TPAR
8	COUNTER	☐	I_COUNT	NUM6	NUMC	6	0	Counter for differentiation 6-digit
9	OBTYP	☐	J_OBTYP	J_OBTYP	CHAR	3	0	Object Category	TJ03
10	PARNR	☐	I_PARNR	I_PARNR	CHAR	12	0	Partner
11	INHER	☐	INHER	INHER	CHAR	1	0	Data origin indicator
12	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
13	ERZEIT	☐	ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
14	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
15	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
16	AEZEIT	☐	AEZEIT	UHRZT	TIMS	6	0	Time of Change
17	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
18	KZLOESCH	☐	KZLOESCH	CHAR1	CHAR	1	0	Delete Data Record
19	ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
20	TZONSP	☐	TZONSP	TZNZONE	CHAR	6	0	Time zone for partner	TTZZ
21	TABPT	☐	SYTABIX	SYST_LONG	INT4	10	0	Row Index of Internal Tables
22	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
23	SLKNZ	☐	SLKNZ	XFELD	CHAR	1	0	Checkbox
24	PARVW_EXT	☐	PARVW	PARVW	CHAR	2	0	Partner Role	*
25	ADR_FLAG	☐	ADRNRX	UPDKZ	CHAR	1	0	Address exists for object
26	ADR_HANDLE	☐	AD_HANDLE	TEXT140	CHAR	140	0	Handle for Creating Addresses/Persons (Bus. Addr. Services)
27	ADRNR_KUPAV	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
28	ADRDA	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
29	ADRND	☐	ADRND	ADRNR	CHAR	10	0	Business address	*
30	ADRNP	☐	ADRNP	ADRNR	CHAR	10	0	Private address	*
31	VTEXT	☐	VTXTK	TEXT20	CHAR	20	0	Name
32	NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
33	NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
34	NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
35	NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
36	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
37	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
38	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
39	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
40	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
41	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
42	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
43	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
44	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
45	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
46	FAX_NUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
47	TLX_NUMBER	☐	AD_TLXNMBR	TEXT30	CHAR	30	0	Telex number
48	TTX_NUMBER	☐	AD_TTXNMBR	TEXT30	CHAR	30	0	Teletex number
49	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
50	NAME_LIST	☐	NAME_LIST	NAME	CHAR	35	0	Name for list displays
51	TITLE	☐	AD_TITLETX	TEXT30	CHAR	30	0	Title text
52	DEPARTMENT	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
53	FUNCTION	☐	AD_FNCTN	TEXT40	CHAR	40	0	Function
54	NICKNAME	☐	AD_NICKNAM	TEXT40	CHAR	40	0	Nickname or name used
55	SEX	☐	AD_SEX	AD_SEX	CHAR	1	0	Gender key
56	PAFKT	☐	PAFKT	PAFKT	CHAR	2	0	Contact person function	*
57	PARVO	☐	PARVO	PARVO	CHAR	1	0	Partner's power of attorney	*
58	PAVIP	☐	PAVIP	PAVIP	CHAR	1	0	VIP Partner	*
59	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
60	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	*
61	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
62	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OPS_IHPAD	COUNTRY	T005	LAND1
2	OPS_IHPAD	LANGU	T002	SPRAS
3	OPS_IHPAD	MANDT	T000	MANDT
4	OPS_IHPAD	OBJNR	ONR00	OBJNR
5	OPS_IHPAD	OBTYP	TJ03	OBTYP
6	OPS_IHPAD	PARVW	TPAR	PARVW
7	OPS_IHPAD	REGION	T005S	BLAND
8	OPS_IHPAD	TZONSP	TTZZ	TZONE	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	604