SE11 ABAP Dictionary SE11 IHPA

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

IHPA

Plant Maintenance: Partners

SAP SAP Transparent Table 16 Fields

Primary Key:

MANDT OBJNR PARVW COUNTER

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	OBJNR	KEY	Obj. no.	CHAR	22	-	-	Object number
3	PARVW	KEY	Function	CHAR	2	-	-	Partner Function
4	COUNTER	KEY	Counter	NUMC	6	-	-	Counter for differentiation 6-digit
5	OBTYP	-	Obj.type	CHAR	3	-	-	Object Category
6	PARNR	-	Partner	CHAR	12	-	-	Partner
7	INHER	-	Origin	CHAR	1	-	-	Data origin indicator
8	ERDAT	-	On	DATS	8	-	-	Date on Which Record Was Created
9	ERZEIT	-	At	TIMS	6	-	-	Time, at Which Record Was Added
10	ERNAM	-	Created	CHAR	12	-	-	Name of Person who Created the Object
11	AEDAT	-	Chngd	DATS	8	-	-	Changed On
12	AEZEIT	-	At	TIMS	6	-	-	Time of Change
13	AENAM	-	By	CHAR	12	-	-	Name of Person Who Changed Object
14	KZLOESCH	-	Delete	CHAR	1	-	-	Delete Data Record
15	ADRNR	-	Addr. no.	CHAR	10	-	-	Address number
16	TZONSP	-	PartTimeZo	CHAR	6	-	-	Time Zone for Partner

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk IHPA.

Interactive ERD Diagrams

SAP PM & SD - Plant Maintenance Main Tables Relation →

Standard T-Codes

SE11 SE16

Related Tables

EQUI EQKT EQUZ EQST IFLOT IFLOTX ILOA AUFK

ANSI SQL Query

SELECT a.OBJNR,
       a.PARVW,
       a.COUNTER,
       a.OBTYP,
       a.PARNR,
       a.INHER,
       a.ERDAT
FROM IHPA AS a
WHERE a.OBJNR = '0001'
  AND a.PARVW = '0001';

ABAP OpenSQL (7.40+)

SELECT a~objnr,
       a~parvw,
       a~counter,
       a~obtyp,
       a~parnr,
       a~inher,
       a~erdat
  FROM ihpa AS a
  WHERE a~objnr = '0001'
  and a~parvw = '0001'
  INTO TABLE @DATA(lt_ihpa)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 IHPA

IHPA

Dictionary Fields Fields

Related References & SQL