SAP ABAP View JHVGA_CM (IS-M/AM: Credit Management: Relevant Order Fields)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

View Type	D	Database View
Database View	JHVGA_CM
Short Description	IS-M/AM: Credit Management: Relevant Order Fields
Root table	JHAISZ	IS-M/AM: Assignment Table of Advertisers for OPM Order

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JHAISZ	JHAISZ
2	JHAGA
3	JHAGA2
4	TJHAP
5	JHAK
6	TJHAK
7	KNKK

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JHAISZ	MANDT	JL	EQ				0	0
2	JHAGA	MANDT	JR	EQ			AND	0	0
3	JHAISZ	AVM_NR	JL	EQ				0	0
4	JHAGA	AVM_NR	JR	EQ			AND	0	0
5	JHAISZ	POS_NR	JL	EQ				0	0
6	JHAGA	POS_NR	JR	EQ			AND	0	0
7	JHAISZ	INSERENT	JL	EQ				0	0
8	JHAGA	INSERENT	JR	EQ			AND	0	0
9	JHAGA	MANDT	JL	EQ				0	0
10	JHAGA2	MANDT	JR	EQ			AND	0	0
11	JHAGA	AVM_NR	JL	EQ				0	0
12	JHAGA2	AVM_NR	JR	EQ			AND	0	0
13	JHAGA	POS_NR	JL	EQ				0	0
14	JHAGA2	POS_NR	JR	EQ			AND	0	0
15	JHAGA	GRUPPABRNR	JL	EQ				0	0
16	JHAGA2	GRUPPABRNR	JR	EQ			AND	0	0
17	KNKK	MANDT	JL	EQ				0	0
18	JHAISZ	MANDT	JR	EQ			AND	0	0
19	KNKK	KUNNR	JL	EQ				0	0
20	JHAISZ	REGULIERER	JR	EQ			AND	0	0
21	TJHAP	MANDT	JL	EQ				0	0
22	JHAGA	MANDT	JR	EQ			AND	0	0
23	TJHAP	PSTYV	JL	EQ				0	0
24	JHAGA	PSTYV	JR	EQ			AND	0	0
25	JHAK	MANDT	JL	EQ				0	0
26	JHAISZ	MANDT	JR	EQ			AND	0	0
27	JHAK	AVM_NR	JL	EQ				0	0
28	JHAISZ	AVM_NR	JR	EQ			AND	0	0
29	TJHAK	MANDT	JL	EQ				0	0
30	JHAK	MANDT	JR	EQ			AND	0	0
31	TJHAK	AUART	JL	EQ				0	0
32	JHAK	AUART	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JHAISZ	MANDT		☐	MANDT	☐	Client
2	AVM_NR	JHAISZ	AVM_NR		☐	AVM_NR	☐	IS-M/AM: Sales Document Number
3	POS_NR	JHAISZ	POS_NR		☐	POS_NR	☐	IS-M: Order Item Number
4	GRUPPABRNR	JHAGA	GRUPPABRNR		☐	GRUPPABRNR	☐	IS-M/AM: Billing Dataset
5	KKBER	KNKK	KKBER		☐	KKBER	☐	Credit control area
6	XCMP_FAILED	JHAGA	XCMP_FAILED		☐	XCMP_FAILED	☐	IS-M/AM: Credit check failed
7	CMPRE_FLT	JHAGA	CMPRE_FLT		☐	CMPRE_FLT	☐	Item credit price
8	XFAKT_EE	JHAGA	XFAKT_EE		☐	XFAKT_EE	☐	IS-M: Billed Indicator
9	XSTORNIERT	JHAGA	XSTORNIERT		☐	XSTORNIERT	☐	IS-M: Canceled Order Object Indicator
10	BELEGEINH	JHAGA	BELEGEINH		☐	BE_BASIS	☐	IS-M: Basic Booking Unit
11	UR_BELEINH	JHAGA	UR_BELEINH		☐	UR_BELEINH	☐	IS-M: Initial Booking Unit for the OPM Item
12	BER_TERMIN	JHAGA	BER_TERMIN		☐	BER_TERMIN	☐	IS-M: Date Services were Created for Settlement Purposes
13	BER_HEFT	JHAGA	BER_HEFT		☐	ISM_BER_HEFT	☐	IS-M: Service Creation Copy Number for Settlement
14	AENDATE	JHAGA	AENDATE		☐	AENDATE	☐	Date of Last Change
15	AENTIME	JHAGA	AENTIME		☐	AENTIME	☐	Time of Last Change
16	CMGST	JHAGA2	CMGST		☐	ISMAM_CMGST	☐	IS-M/AM: Credit Management: Overall Status of Credit Checks
17	INSERENT	JHAISZ	INSERENT		☐	INSERENT	☐	IS-M: Advertiser
18	REGULIERER	JHAISZ	REGULIERER		☐	REGULIERER	☐	IS-M: Payer
19	CCINS	JHAISZ	CCINS		☐	CCINS	☐	Payment cards: Card type
20	AVM_HRKNFT	JHAK	AVM_HRKNFT		☐	AVM_HRKNFT	☐	IS-M/AM: Order Origin
21	GPAG	JHAK	GPAG		☐	GPAG	☐	Business Partner: Sold-to Party
22	VKORG	JHAK	VKORG		☐	VKORG	☐	Sales Organization
23	VTWEG	JHAK	VTWEG		☐	VTWEG	☐	Distribution Channel
24	SPART	JHAK	SPART		☐	SPART	☐	Division
25	KLIMP_K	TJHAK	KLIMP		☐	KLIMP	☐	Check credit limit
26	CMGRA_K	TJHAK	CMGRA		☐	CMGRA	☐	Credit Group for Sales Order
27	KLIMP	TJHAP	KLIMP		☐	KLIMP	☐	Check credit limit
28	CMPNT	TJHAP	CMPNT		☐	CMPNT	☐	ID: Item with active credit function / relevant for credit
29	CMGRA	TJHAP	CMGRA		☐	CMGRA	☐	Credit Group for Sales Order
30	KNKLI	KNKK	KNKLI		☐	KNKLI	☐	Customer's account number with credit limit reference
31	CTLPC	KNKK	CTLPC		☐	CTLPC_CM	☐	Credit management: Risk category
32	CRBLB	KNKK	CRBLB		☐	CRBLB_CM	☐	Indicator: Blocked by credit management ?
33	SBGRP	KNKK	SBGRP		☐	SBGRP_CM	☐	Credit Representative Group for Credit Management
34	GRUPP	KNKK	GRUPP		☐	GRUPP_CM	☐	Customer credit group
35	KDGRP	KNKK	KDGRP		☐	KDGRP_CM	☐	Customer Group
36	KKBER_K	JHAK	KKBER		☐	KKBER	☐	Credit control area
37	KNKLI_K	JHAK	KNKLI		☐	KNKLI	☐	Customer's account number with credit limit reference
38	GRUPP_K	JHAK	GRUPP		☐	GRUPP_CM	☐	Customer credit group
39	SBGRP_K	JHAK	SBGRP		☐	SBGRP_CM	☐	Credit Representative Group for Credit Management
40	CTLPC_K	JHAK	CTLPC		☐	CTLPC_CM	☐	Credit management: Risk category
41	CMWAE_K	JHAK	CMWAE		☐	WAERS_CM	☐	Currency key of credit control area
42	PSTYV	JHAGA	PSTYV		☐	PSTYV_PAM	☐	IS-M: Item Category for Sales Document
43	AUART	JHAK	AUART		☐	AUART_PAM	☐	IS-M: Sales Document Type

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in