SAP ABAP Table JHVCIC_ORDER_MAM (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVCIC_ORDER_MAM	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	INSZ_NR	☑	INSZ_NR	NUMC4	NUMC	4	0	IS-M: Advertiser assignment number
6	INSERENT	☑	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JJVDB_MK_FK
7	ALTINSGPNR	☐	ALTINSGPNR	CHAR15	CHAR	15	0	IS-M: Alternative Customer Number for Advertiser
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	AVM_HRKNFT	☐	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
14	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK
15	WAEHRG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
16	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
17	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
18	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
19	WERBK_TYP	☐	WKOMBI_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Combination Sale Type	TJH91
20	WERBK_KNZ	☐	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
21	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	TBRC
22	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
23	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
24	SELDAT_VON	☐	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
25	SELDAT_BIS	☐	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
26	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
27	STORNOGRND	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	TJHSTOG
28	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
29	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
30	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
31	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_ORDER_MAM	AUART	TJHAK	AUART	KEY	1	CN
2	JHVCIC_ORDER_MAM	AVM_NR	JHAK	AVM_NR	KEY	1	CN
3	JHVCIC_ORDER_MAM	BRAN_PAM	TBRC	BRACO	REF	1	CN
4	JHVCIC_ORDER_MAM	GPAG	JGTGPNR	GPNR	KEY	1	CN
5	JHVCIC_ORDER_MAM	INSERENT	JJVDB_MK_FK	GPNR	KEY	1	CN
6	JHVCIC_ORDER_MAM	KAMPAGNE	TJJKAMP	KAMPAGNE	REF	1	CN
7	JHVCIC_ORDER_MAM	MANDT	T000	MANDT	KEY	1	CN
8	JHVCIC_ORDER_MAM	POS_ART	TJH17	AVMPOS_ART	REF	1	CN
9	JHVCIC_ORDER_MAM	PSTYV	TJHAP	PSTYV	REF	1	CN
10	JHVCIC_ORDER_MAM	SPART	TJHVBER	SPART		1	CN
11	JHVCIC_ORDER_MAM	STORNOGRND	TJHSTOG	STORNOGRD	REF	1	CN
12	JHVCIC_ORDER_MAM	VKBUR	TVKBZ	VKBUR		C	CN
13	JHVCIC_ORDER_MAM	VKGRP	TVBVK	VKGRP		C	CN
14	JHVCIC_ORDER_MAM	VKORG	TJHVBER	VKORG		1	CN
15	JHVCIC_ORDER_MAM	VTWEG	TJHVBER	VTWEG		1	CN
16	JHVCIC_ORDER_MAM	WAEHRG	TCURC	WAERS	REF	1	CN
17	JHVCIC_ORDER_MAM	WERBK_TYP	TJH91	WKOMBI_TYP		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in