SAP ABAP Table RJHA673 (IS-M: Screen Structure for Order Sales Agent Assignment III)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	RJHA673	Table Relationship Diagram
Short Description	IS-M: Screen Structure for Order Sales Agent Assignment III

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	.INCLUDE	☐				0	0	IS-M/AM: Screen Structure for Order Sales Agent Assignment
2	.INCLUDE	☐				0	0	IS-M/AM: Order Sales Agent Assignment
3	.INCLUDE	☐				0	0	IS-M/AM: Order Sales Agent Assignment
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
6	POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
7	GRUPPABRNR	☐	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	JHAGA
8	VNR	☐	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
9	BEDNR	☐	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	JJTVB
10	PROVTYP	☐	PROVTYP	PROVTYP	CHAR	1	0	IS-M/AM: Commission Category
11	VZUONR	☐	JH_VZUONR	JH_VZUONR	NUMC	2	0	IS-M/AM: Sales Agent Assignment Number (Corrections)	*
12	VERM	☐	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen	*
13	XAUTO	☐	JAUTOZUGPR	XFELD	CHAR	1	0	IS-M: Assigned automatically Indicator
14	XFOUND	☐	PR_XFOUND	XFELD	CHAR	1	0	Suitable Sales Agent Contract Requirement Found Indicator
15	XMANU	☐	PR_XMANU	XFELD	CHAR	1	0	IS-M: Sales Agent Assigned Manually Indicator
16	XKOPF_ZUO	☐	PRKOPF_ZUO	XFELD	CHAR	1	0	IS-M: "Sales Agent Copied from Order Header" Indicator
17	XPOS_ZUO	☐	PRPOS_ZUO	XFELD	CHAR	1	0	IS-M: Sales Agent Copied from Order Item
18	.INCLUDE	☐				0	0	Values that can be Modified Manually for Sales Agent Assign.
19	PR_BASIS	☐	VPROVBAS	DECV4_3	DEC	7	3	IS-M: Sales Agent Share of Calculation Base (in %)
20	PR_BETRAG	☐	VPROZP	DEC4_3	DEC	7	3	IS-M: Sales Agent Share of Commission (in %)
21	PRA_XMANU	☐	JHPRAXMANU	XFELD	CHAR	1	0	IS-M: Sales Agent Share was Changed Manually Indicator
22	PROSL	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
23	PROV_SATZ	☐	PROV_SATZ	DECV4_3	DEC	7	3	IS-M: Commission Rate (Percent)
24	PROVM_SATZ	☐	PROV_SATZM	WERTV8	CURR	15	2	IS-M: Commission Amount for mm Commission
25	PROVM_WAER	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
26	PROV_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
27	PROV_MEIN	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
28	BEZKOND	☐	JBEZKOND	JBEZKOND	CHAR	2	0	IS-M: Condition Reference	TJJ83
29	VZMANUAEND	☐	VZMANUAEND	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment was Changed Indicator
30	BEDGR	☐	BEDGR	BEDGR	CHAR	2	0	IS-M: Media Sales Agent Requirement Group	TJJ77
31	JVERMART	☐	JVERMART	JVERMART	CHAR	2	0	IS-M: Media Sales Agent Type: General/City/Special Agent	TJJ09
32	VANR	☐	JVANR	JVANR	CHAR	5	0	IS-M: Extra commission/exclusion
33	REF_VZUONR	☐	JH_REF_VZUONR	JH_VZUONR	NUMC	2	0	IS-M/AM: Reference Number of the Preceding Agent Assignmt	JHAGVZ
34	SUC_VZUONR	☐	JH_SUC_VZUONR	JH_VZUONR	NUMC	2	0	IS-M: Reference No.of Successor Sales Agent Assignment	JHAGVZ
35	CORRCAUSE	☐	JHVZCC	JHVZCC	CHAR	2	0	IS-M/AM: Reason for Correction to Sales Agent Assignment	TJHVZCC
36	CANCELCC	☐	JHCANCELCC	JHVZCC	CHAR	2	0	IS-M: Reversal Correction Reason for Sales Agent Assignment	TJHVZCC
37	.INCLUDE	☐				0	0	IS-PAM: Agent assignment grouping status fields
38	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
39	XPROV_EE	☐	XPROV_EE	XFELD	CHAR	1	0	IS-M: Settlement Performed (Sales Agent Payment) Indicator
40	XUVVZ	☐	XUVVZ_GVZ	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment is Incomplete
41	XZUOINACT	☐	XZUOINACT	XFELD	CHAR	1	0	IS-M: Indicator Sales Agent Assignment is Inactive
42	XDELETED	☐	PR_XDEL	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment Deleted Manually Indicator
43	.INCLUDE	☐				0	0	IS-PAM: Characteristics for individual use (Ad.sched.line)
44	MERKMAL0	☐	MERK0_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 0 for Ind.Use (Sales Agent Assignment)
45	MERKMAL1	☐	MERK1_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 1 for Ind.Use (Sales Agent Assignment)
46	MERKMAL2	☐	MERK2_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 2 for Ind.Use (Sales Agent Assignment)
47	MERKMAL3	☐	MERK3_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 3 for Ind.Use (Sales Agent Assignment)
48	MERKMAL4	☐	MERK4_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 4 for Ind.Use (Sales Agent Assignment)
49	MERKMAL5	☐	MERK5_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 5 for Ind.Use (Sales Agent Assignment)
50	MERKMAL6	☐	MERK6_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 6 for Ind.Use (Sales Agent Assignment)
51	MERKMAL7	☐	MERK7_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 7 for Ind.Use (Sales Agent Assignment)
52	MERKMAL8	☐	MERK8_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 8 for Ind.Use (Sales Agent Assignment)
53	MERKMAL9	☐	MERK9_VZ	XFELD	CHAR	1	0	CIS-M: Characteristic 9 for Ind.Use (Sales Agent Assignment)
54	VERM_NAME	☐	VERM_NAME	TEXT30	CHAR	30	0	IS-M: Sales Agent Name
55	BEDART	☐	VMBEDART	JVMBEDART	CHAR	2	0	IS-M/AM: Requirement Type in Media Sales Agent Contract	TJJ73
56	KTEXT_BA	☐	JJBEDART_KTEXT	TEXT15	CHAR	15	0	IS-M/AM: Requirement Type (Short Text)
57	KTEXT_VB	☐	JJBEDNR_KTEXT	TEXT15	CHAR	15	0	IS-M/AM: Contract Requirement (Short Text)
58	KTEXT_VV	☐	JJVNR_KTEXT	TEXT15	CHAR	15	0	IS-M/AM: Sales Agent Contract (Short Text)
59	KTEXT_VANR	☐	KURZTEXT	TEXT40	CHAR	40	0	Short text/description of the object
60	VTYP	☐	JVERMVTYP	JVERMVTYP	CHAR	1	0	IS-M: Contract Category for Media Sales Agent Contract
61	XBERICHT	☐	XBESBERICH	ISM_XBESBERICH	CHAR	1	0	IS-M/AM: Report Required, Reference to Partner (Role)
62	XSTDBED	☐	JSTDBED	XFELD	CHAR	1	0	IS-M: Standard Requirement
63	STAT_AMPEL	☐	STAT_AMPEL	SYCHAR132	CHAR	132	0	IS-M: Status visualization
64	EINTRAEGE	☐	JHGESEINTR	NUM6	NUMC	6	0	IS-M: Total number of entries in a table
65	EINTRAG	☐	JHAKTEINTR	NUM6	NUMC	6	0	IS-M: Current entry in 1st line of table
66	MARK1	☐	XFELD	XFELD	CHAR	1	0	Checkbox
67	HERKUNFT	☐	JH_GVZ_HERKUNFT	DDTEXT	CHAR	60	0	IS-M: Origin of Sales Agent Assignment (Text)
68	ORIGIN	☐	JH_GVZ_ORIGIN	JH_GVZ_ORIGIN	CHAR	1	0	IS-M/AM: Sales Agent Assignment Origin
69	VTYP_TEXT	☐	JH_GVZ_VTYP_TEXT	DDTEXT	CHAR	60	0	IS-M: Sales Agent Contract Category (Text for Table Control)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJHA673	AVM_NR	JHAK	AVM_NR	KEY	1	CN
2	RJHA673	BEDART	TJJ73	BEDART	KEY	1	CN
3	RJHA673	BEDGR	TJJ77	BEDGR	KEY	1	CN
4	RJHA673	BEDNR	JJTVB	BEDNR	KEY	1	CN
5	RJHA673	BEZKOND	TJJ83	BEZKOND	REF	1	CN
6	RJHA673	CANCELCC	TJHVZCC	CORRCAUSE	REF	1	CN
7	RJHA673	CORRCAUSE	TJHVZCC	CORRCAUSE	REF	1	CN
8	RJHA673	GRUPPABRNR	JHAGA	GRUPPABRNR	KEY	1	CN
9	RJHA673	JVERMART	TJJ09	JVERMART	KEY	1	CN
10	RJHA673	MANDT	T000	MANDT	KEY	1	CN
11	RJHA673	POS_NR	JHAP	POS_NR	KEY	1	CN
12	RJHA673	PROSL	TJH23	PRSCHL	KEY	1	CN
13	RJHA673	PROVM_WAER	TCURC	WAERS	REF	1	CN
14	RJHA673	PROV_MEIN	T006	MSEHI	REF	1	CN
15	RJHA673	REF_VZUONR	JHAGVZ	VZUONR	REF	1	CN
16	RJHA673	SUC_VZUONR	JHAGVZ	VZUONR	REF	1	C
17	RJHA673	VNR	JJTVV	VNR	KEY	1	CN

History

Last changed by/on	SAP	20060208
SAP Release Created in