SAP ABAP Table JHVGA_CM (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVGA_CM	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	JHAP
4	GRUPPABRNR	☑	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset
5	KKBER	☑	KKBER	KKBER	CHAR	4	0	Credit control area	T014
6	XCMP_FAILED	☐	XCMP_FAILED	XFELD	CHAR	1	0	IS-M/AM: Credit check failed
7	CMPRE_FLT	☐	CMPRE_FLT	FLTP	FLTP	16	16	Item credit price
8	XFAKT_EE	☐	XFAKT_EE	XFELD	CHAR	1	0	IS-M: Billed Indicator
9	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
10	BELEGEINH	☐	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	JJTBE
11	UR_BELEINH	☐	UR_BELEINH	BELEINH	CHAR	10	0	IS-M: Initial Booking Unit for the OPM Item	JJTBE
12	BER_TERMIN	☐	BER_TERMIN	DATUM	DATS	8	0	IS-M: Date Services were Created for Settlement Purposes
13	BER_HEFT	☐	ISM_BER_HEFT	PAM_PERIOD	CHAR	14	0	IS-M: Service Creation Copy Number for Settlement
14	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
15	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
16	CMGST	☐	ISMAM_CMGST	CMGST	CHAR	1	0	IS-M/AM: Credit Management: Overall Status of Credit Checks
17	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JJVDB_MK_FK
18	REGULIERER	☐	REGULIERER	GPNR	CHAR	10	0	IS-M: Payer	JGTGPNR
19	CCINS	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	TVCIN
20	AVM_HRKNFT	☐	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
21	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
22	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TJHVBER
23	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TJHVBER
24	SPART	☐	SPART	SPART	CHAR	2	0	Division	TJHVBER
25	KLIMP_K	☐	KLIMP	KLIMP	CHAR	1	0	Check credit limit
26	CMGRA_K	☐	CMGRA	CRMGR_CM	CHAR	2	0	Credit Group for Sales Order	T691D
27	KLIMP	☐	KLIMP	KLIMP	CHAR	1	0	Check credit limit
28	CMPNT	☐	CMPNT	XFELD	CHAR	1	0	ID: Item with active credit function / relevant for credit
29	CMGRA	☐	CMGRA	CRMGR_CM	CHAR	2	0	Credit Group for Sales Order
30	KNKLI	☐	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference	KNA1
31	CTLPC	☐	CTLPC_CM	CTLPC_CM	CHAR	3	0	Credit management: Risk category	T691A
32	CRBLB	☐	CRBLB_CM	XFELD	CHAR	1	0	Indicator: Blocked by credit management ?
33	SBGRP	☐	SBGRP_CM	SBGRP_CM	CHAR	3	0	Credit Representative Group for Credit Management	T024B
34	GRUPP	☐	GRUPP_CM	GRUPP_CM	CHAR	4	0	Customer credit group	T691B
35	KDGRP	☐	KDGRP_CM	CHAR8	CHAR	8	0	Customer Group
36	KKBER_K	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
37	KNKLI_K	☐	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference	KNA1
38	GRUPP_K	☐	GRUPP_CM	GRUPP_CM	CHAR	4	0	Customer credit group	T691B
39	SBGRP_K	☐	SBGRP_CM	SBGRP_CM	CHAR	3	0	Credit Representative Group for Credit Management	T024B
40	CTLPC_K	☐	CTLPC_CM	CTLPC_CM	CHAR	3	0	Credit management: Risk category	T691A
41	CMWAE_K	☐	WAERS_CM	WAERS	CUKY	5	0	Currency key of credit control area	TCURC
42	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
43	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	JHVGA_CM	AUART	TJHAK	AUART	KEY	1	CN
2	JHVGA_CM	AVM_NR	JHAK	AVM_NR	KEY	1	CN
3	JHVGA_CM	BELEGEINH	JJTBE	BELEINH	KEY	1	CN
4	JHVGA_CM	CCINS	TVCIN	CCINS	REF	1	CN
5	JHVGA_CM	CMGRA_K	T691D	CRMGR_CM	REF	1	CN
6	JHVGA_CM	CMWAE_K	TCURC	WAERS	REF	C	CN
7	JHVGA_CM	CTLPC	T691A	CTLPC	REF	C	CN
8	JHVGA_CM	CTLPC_K	T691A	CTLPC	REF	C	CN
9	JHVGA_CM	GPAG	JGTGPNR	GPNR	KEY	1	CN
10	JHVGA_CM	GRUPP	T691B	GRUPP	REF	C	CN
11	JHVGA_CM	GRUPP_K	T691B	GRUPP
12	JHVGA_CM	INSERENT	JJVDB_MK_FK	GPNR	KEY	1	CN
13	JHVGA_CM	KKBER	T014	KKBER	KEY	1	CN
14	JHVGA_CM	KKBER_K	T014	KKBER	REF	C	CN
15	JHVGA_CM	KNKLI	KNA1	KUNNR	REF	1	CN
16	JHVGA_CM	KNKLI_K	KNA1	KUNNR	REF	C	CN
17	JHVGA_CM	MANDT	T000	MANDT	KEY	1	CN
18	JHVGA_CM	POS_NR	JHAP	POS_NR	KEY	1	CN
19	JHVGA_CM	PSTYV	TJHAP	PSTYV	KEY	1	CN
20	JHVGA_CM	REGULIERER	JGTGPNR	GPNR	REF	1	CN
21	JHVGA_CM	SBGRP	T024B	SBGRP	REF	C	CN
22	JHVGA_CM	SBGRP_K	T024B	SBGRP	REF	C	CN
23	JHVGA_CM	SPART	TJHVBER	SPART		1	CN
24	JHVGA_CM	UR_BELEINH	JJTBE	BELEINH	REF	1	CN
25	JHVGA_CM	VKORG	TJHVBER	VKORG		1	CN
26	JHVGA_CM	VTWEG	TJHVBER	VTWEG		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in