SAP ABAP Table JHVSI_PLZ (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVSI_PLZ	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	SELDAT_VON	☑	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
3	BELEGEINH	☑	ISM_SI_PLAZBE	BELEINH	CHAR	10	0	IS-M: AI Booking Unit for Positioning	JJTBE
4	AVM_NR	☑	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
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
7	BEARB	☐	SINSBEARB	SIBEAR_ART	CHAR	2	0	IS-M: Ad Insert Processing Type	TJH03
8	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TJHVBER
9	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TJHVBER
10	SPART	☐	SPART	SPART	CHAR	2	0	Division	TJHVBER
11	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
12	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
13	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
14	SELDAT_BIS	☐	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
15	XTBEL_SI	☐	XTBEL_SI	XFELD	CHAR	1	0	IS-M: Selective Booking of an AI BU
16	XSI_PLAZ	☐	XSI_PLAZ	XFELD	CHAR	1	0	IS-M: Ad insert "positioned" indicator
17	XSI_WARTET	☐	XSI_WARTET	XFELD	CHAR	1	0	IS-M: Ad Insert Is On The Waiting List Indicator
18	XRESERV	☐	XRESERV	XFELD	CHAR	1	0	IS-M: Reservation indicator
19	XRESBEST	☐	XRESBEST	XFELD	CHAR	1	0	IS-M: Reservation confirmed
20	UR_BELEINH	☐	UR_BELEINH	BELEINH	CHAR	10	0	IS-M: Initial Booking Unit for the OPM Item	JJTBE
21	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
22	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
23	KONKAUS	☐	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	TJH89
24	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
25	DISPMENGE	☐	DSPMGE_PAM	STMENGE	DEC	9	0	IS-M: Planning Quantity for Ad Inserts
26	SIMENGE_RH	☐	DSPMGE_RH	STMENGE	DEC	9	0	IS-M: Non-Reader Circulation for TMC
27	POSTMENGE	☐	POSTMENGE	STMENGE	DEC	9	0	IS-M: Postal Circulation Quantity
28	STICHW	☐	STICHW	TEXT40	CHAR	40	0	IS-M: Keyword
29	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
30	STORNOGRND	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	TJHSTOG
31	XRESTHSHLT	☐	XRESTHSHLT	XFELD	CHAR	1	0	IS-M: Total Market Coverage
32	POS_ANZSEITEN	☐	ANZSEITEN	NUM8	NUMC	8	0	Number of Pages in Issue
33	POS_SI_TYP	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	TJH29
34	POS_SI_GEWICHT	☐	ISM_SI_GEWICHT	ISPMNG9	QUAN	9	3	IS-M: Ad Insert Weight
35	POS_MEINHGEWBL	☐	MEINHGEWBL	MEINS	UNIT	3	0	IS-M: Unit of Weight for Ad Insert	T006

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVSI_PLZ	AVM_NR	JHAK	AVM_NR	KEY	1	CN
2	JHVSI_PLZ	BEARB	TJH03	BEARB	KEY	1	CN
3	JHVSI_PLZ	BELEGEINH	JJTBE	BELEINH	REF	1	CN
4	JHVSI_PLZ	KAMPAGNE	TJJKAMP	KAMPAGNE	REF	1	CN
5	JHVSI_PLZ	KONKAUS	TJH89	KONKAUS	KEY	1	CN
6	JHVSI_PLZ	MANDT	T000	MANDT	KEY	1	CN
7	JHVSI_PLZ	POS_MEINHGEWBL	T006	MSEHI
8	JHVSI_PLZ	POS_NR	JHAP	POS_NR	KEY	1	CN
9	JHVSI_PLZ	POS_SI_TYP	TJH29	SI_TYP
10	JHVSI_PLZ	PRODH	JJT179	PRODH	REF	1	CN
11	JHVSI_PLZ	PSTYV	TJHAP	PSTYV	REF	1	CN
12	JHVSI_PLZ	SPART	TJHVBER	SPART		1	CN
13	JHVSI_PLZ	STORNOGRND	TJHSTOG	STORNOGRD	REF	1	CN
14	JHVSI_PLZ	UR_BELEINH	JJTBE	BELEINH	REF	1	CN
15	JHVSI_PLZ	VKBUR	TVKBZ	VKBUR		C	CN
16	JHVSI_PLZ	VKGRP	TVBVK	VKGRP		C	CN
17	JHVSI_PLZ	VKORG	TJHVBER	VKORG		1	CN
18	JHVSI_PLZ	VTWEG	TJHVBER	VTWEG		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in