SAP ABAP Table JHVCIC_ORDERITEM (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVCIC_ORDERITEM	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	POS_NR	☑	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number
4	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
5	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TJHVBER
6	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TJHVBER
7	SPART	☐	SPART	SPART	CHAR	2	0	Division	TJHVBER
8	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
9	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
10	AVM_HRKNFT	☐	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
11	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK
12	WAEHRG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
13	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
14	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
15	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
16	WERBK_TYP	☐	WKOMBI_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Combination Sale Type	TJH91
17	WERBK_KNZ	☐	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
18	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	TBRC
19	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
20	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
21	SELDAT_VON	☐	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
22	SELDAT_BIS	☐	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
23	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
24	STORNOGRND	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	TJHSTOG
25	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
26	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
27	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
28	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVCIC_ORDERITEM	AUART	TJHAK	AUART	KEY	1	CN
2	JHVCIC_ORDERITEM	AVM_NR	JHAK	AVM_NR	KEY	1	CN
3	JHVCIC_ORDERITEM	BRAN_PAM	TBRC	BRACO	REF	1	CN
4	JHVCIC_ORDERITEM	GPAG	JGTGPNR	GPNR	KEY	1	CN
5	JHVCIC_ORDERITEM	KAMPAGNE	TJJKAMP	KAMPAGNE	REF	1	CN
6	JHVCIC_ORDERITEM	MANDT	T000	MANDT	KEY	1	CN
7	JHVCIC_ORDERITEM	POS_ART	TJH17	AVMPOS_ART	REF	1	CN
8	JHVCIC_ORDERITEM	PSTYV	TJHAP	PSTYV	REF	1	CN
9	JHVCIC_ORDERITEM	SPART	TJHVBER	SPART		1	CN
10	JHVCIC_ORDERITEM	STORNOGRND	TJHSTOG	STORNOGRD	REF	1	CN
11	JHVCIC_ORDERITEM	VKBUR	TVKBZ	VKBUR		C	CN
12	JHVCIC_ORDERITEM	VKGRP	TVBVK	VKGRP		C	CN
13	JHVCIC_ORDERITEM	VKORG	TJHVBER	VKORG		1	CN
14	JHVCIC_ORDERITEM	VTWEG	TJHVBER	VTWEG		1	CN
15	JHVCIC_ORDERITEM	WAEHRG	TCURC	WAERS	REF	1	CN
16	JHVCIC_ORDERITEM	WERBK_TYP	TJH91	WKOMBI_TYP		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in