SAP ABAP Table JHVREKL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVREKL	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	AVM_NR	☑	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
3	AVM_HRKNFT	☑	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
4	REKLAM_NR	☑	REKLAM_NR	REKLAM	CHAR	10	0	IS-M: Complaint number
5	POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
6	UPOS_NR	☐	UPOS_NR	AVM_UPNR	NUMC	4	0	IS-M: Order Sub-Item Number	JHAU
7	EIN_NR	☐	EIN_NR	AVMENR	NUMC	6	0	IS-M: Schedule Line	JHAE
8	GRUPPABRNR	☐	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	JHAGA
9	REKL_GPNR	☐	REKL_GPNR	GPNR	CHAR	10	0	IS-M: Complaining Party	JGTGPNR
10	REKL_GPAS	☐	ISM_CP_COMPLAINT	BU_PARTNER	CHAR	10	0	IS-M: Contact Person for Complaining Party
11	REKL_DATUM	☐	REKL_DATUM	DATUM	DATS	8	0	IS-M: Complaint Date
12	REKL_GRUND	☐	REKL_GRUND	CHAR4	CHAR	4	0	IS-M: Reason for Complaint	TJJAD
13	REKL_STAT	☐	REKL_STAT	REKL_STAT	CHAR	2	0	IS-M: Complaint status	TJHB5
14	WEITERBEAR	☐	WEITERBEAR	USERNAME	CHAR	12	0	IS-M: Subsequent Processor
15	REKL_KOMM	☐	REKL_KOMM	XFELD	CHAR	1	0	IS-M: Comment has been entered for complaint
16	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
17	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TJHVBER
18	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TJHVBER
19	SPART	☐	SPART	SPART	CHAR	2	0	Division	TJHVBER
20	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
21	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
22	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVREKL	AUART	TJHAK	AUART	KEY	1	CN
2	JHVREKL	AVM_NR	JHAK	AVM_NR	KEY	1	CN
3	JHVREKL	EIN_NR	JHAE	EIN_NR		1	CN
4	JHVREKL	GPAG	JGTGPNR	GPNR	KEY	1	CN
5	JHVREKL	GRUPPABRNR	JHAGA	GRUPPABRNR	REF	1	CN
6	JHVREKL	MANDT	T000	MANDT	KEY	1	CN
7	JHVREKL	POS_NR	JHAP	POS_NR	REF	1	CN
8	JHVREKL	REKL_GPNR	JGTGPNR	GPNR	REF	1	CN
9	JHVREKL	REKL_GRUND	TJJAD	REKL_GRUND	KEY	1	CN
10	JHVREKL	REKL_STAT	TJHB5	REKL_STAT	REF	1	CN
11	JHVREKL	SPART	TJHVBER	SPART		1	CN
12	JHVREKL	UPOS_NR	JHAU	UPOS_NR	REF	1	CN
13	JHVREKL	VKBUR	TVKBZ	VKBUR		C	CN
14	JHVREKL	VKGRP	TVBVK	VKGRP		C	CN
15	JHVREKL	VKORG	TJHVBER	VKORG		1	CN
16	JHVREKL	VTWEG	TJHVBER	VTWEG		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in