SAP ABAP Table JHVSTAT05 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVSTAT05	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	POS_NR	☑	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
5	UPOS_NR	☑	UPOS_NR	AVM_UPNR	NUMC	4	0	IS-M: Order Sub-Item Number
6	EIN_NR	☑	EIN_NR	AVMENR	NUMC	6	0	IS-M: Schedule Line
7	MOTIV	☑	MOTIV_NR	PAM_MOTIV	NUMC	6	0	IS-M: Ad Spec Number (Ad)	JHAMOT
8	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
9	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TJHVBER
10	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TJHVBER
11	SPART	☐	SPART	SPART	CHAR	2	0	Division	TJHVBER
12	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
13	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
14	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK
15	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
16	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
17	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
18	XRESERV	☐	XRESERV	XFELD	CHAR	1	0	IS-M: Reservation indicator
19	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
20	XEINAENDER	☐	XEINAENDER	XFELD	CHAR	1	0	IS-M: Schedule line change indicator
21	XTERM_AEND	☐	XTERM_AEND	XFELD	CHAR	1	0	IS-M: Publication date changed manually indicator
22	EIN_ART	☐	JHAE_ART	AVMPOS_ART	CHAR	2	0	IS-M: Schedule Line Type
23	UR_BELEINH	☐	UR_BELEINH	BELEINH	CHAR	10	0	IS-M: Initial Booking Unit for the OPM Item	JJTBE
24	BELEGEINH	☐	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	JJTBE
25	INHK_EINT	☐	INHK_EINT	INHALTSKOM	CHAR	8	0	IS-M: Schedule line content component	JJTIKO
26	INHK_PLAZ	☐	INHK_PLAZ	INHALTSKOM	CHAR	8	0	IS-M: Positioning content component	JJTIKO
27	INHK_PLEV1	☐	INHK_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Level 1 content component in the hierarchy	JJTIKO
28	INHK_SOVER	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	JJTIKO
29	TERMINART	☐	TERMINART	TERMINART	CHAR	1	0	IS-M/AM: Type of Publication Date
30	E_TERMIN	☐	E_TERMIN	DATUM	DATS	8	0	IS-M: Publication Date
31	E_HEFT	☐	E_HEFT	PAM_PERIOD	CHAR	14	0	IS-M: Publication Copy Number
32	E_VAVARTYP	☐	VAVARTYPTA	VAVARTYP	CHAR	2	0	Actual issue variant type	TJD05
33	VAUSGB	☐	VAUSGB	VAUSGB	CHAR	10	0	Issue	JDTVAUSGB
34	SEITE_FSP	☐	SEITE_FSP	SEITE_FSP	CHAR	4	0	IS-M: Page/column format	TJJ47
35	XSPERR_TEC	☐	XSPERR_TEC	XFELD	CHAR	1	0	IS-M: Blocked in technical system indicator
36	XANNSCHLAB	☐	XANNSCHLAB	XFELD	CHAR	1	0	IS-M: Order Deadline is Past
37	XSTPLAZ	☐	XSTPLAZ	XFELD	CHAR	1	0	IS-M: Positioned indicator
38	XBELICHTET	☐	XBELICHTET	XFELD	CHAR	1	0	IS-M: "Exposed" Indicator
39	XERSCH	☐	XERSCH	XFELD	CHAR	1	0	IS-M: Schedule Line Published Indicator
40	XDIFF_BBE	☐	XDIFF_BBE	XFELD	CHAR	1	0	IS-M: Alternative planned/actual basic booking unit
41	XDIFF_COL	☐	XDIFF_COL	XFELD	CHAR	1	0	IS-M: Alternative Planned/Actual Color Scheme
42	XDIFF_TERM	☐	XDIFF_TERM	XFELD	CHAR	1	0	IS-M: Alternative planned/actual date
43	XDIFF_PLZ	☐	XDIFF_PLZ	XFELD	CHAR	1	0	IS-M: Alternative planned/actual positioning
44	MERKMAL0	☐	MERK0_EA	XFELD	CHAR	1	0	IS-M: Characteristic 0 for Individual Use (Ad Schedule Line)
45	MERKMAL1	☐	MERK1_EA	XFELD	CHAR	1	0	IS-M: Characteristic 1 for Individual Use (Ad Schedule Line)
46	MERKMAL2	☐	MERK2_EA	XFELD	CHAR	1	0	IS-M: Characteristic 2 for Individual Use (Ad Schedule Line)
47	MERKMAL3	☐	MERK3_EA	XFELD	CHAR	1	0	IS-M: Characteristic 3 for Individual Use (Ad Schedule Line)
48	MERKMAL4	☐	MERK4_EA	XFELD	CHAR	1	0	IS-M: Characteristic 4 for Individual Use (Ad Schedule Line)
49	MERKMAL5	☐	MERK5_EA	XFELD	CHAR	1	0	IS-M: Characteristic 5 for Individual Use (Ad Schedule Line)
50	MERKMAL6	☐	MERK6_EA	XFELD	CHAR	1	0	IS-M: Characteristic 6 for Individual Use (Ad Schedule Line)
51	MERKMAL7	☐	MERK7_EA	XFELD	CHAR	1	0	IS-M: Characteristic 7 for Individual Use (Ad Schedule Line)
52	MERKMAL8	☐	MERK8_EA	XFELD	CHAR	1	0	IS-M: Characteristic 8 for Individual Use (Ad Schedule Line)
53	MERKMAL9	☐	MERK9_EA	XFELD	CHAR	1	0	IS-M: Characteristic 9 for Individual Use (Ad Schedule Line)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVSTAT05	AUART	TJHAK	AUART	KEY	1	CN
2	JHVSTAT05	AVM_NR	JHAK	AVM_NR	KEY	1	CN
3	JHVSTAT05	BELEGEINH	JJTBE	BELEINH	REF	1	CN
4	JHVSTAT05	E_VAVARTYP	TJD05	VAVARTYP
5	JHVSTAT05	GPAG	JGTGPNR	GPNR	KEY	1	CN
6	JHVSTAT05	INHK_EINT	JJTIKO	INHALTSKOM
7	JHVSTAT05	INHK_PLAZ	JJTIKO	INHALTSKOM	REF	1	CN
8	JHVSTAT05	INHK_PLEV1	JJTIKO	INHALTSKOM	REF	1	CN
9	JHVSTAT05	INHK_SOVER	JJTIKO	INHALTSKOM	REF	1	CN
10	JHVSTAT05	MANDT	T000	MANDT	KEY	1	CN
11	JHVSTAT05	MOTIV	JHAMOT	MOTIV		1	CN
12	JHVSTAT05	POS_NR	JHAP	POS_NR	KEY	1	CN
13	JHVSTAT05	PSTYV	TJHAP	PSTYV	REF	1	CN
14	JHVSTAT05	SEITE_FSP	TJJ47	SEITE_FSP	REF	1	CN
15	JHVSTAT05	SPART	TJHVBER	SPART		1	CN
16	JHVSTAT05	UR_BELEINH	JJTBE	BELEINH	REF	1	CN
17	JHVSTAT05	VAUSGB	JDTVAUSGB	VAUSGB
18	JHVSTAT05	VKBUR	TVKBZ	VKBUR		C	CN
19	JHVSTAT05	VKGRP	TVBVK	VKGRP		C	CN
20	JHVSTAT05	VKORG	TJHVBER	VKORG		1	CN
21	JHVSTAT05	VTWEG	TJHVBER	VTWEG		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in