SAP ABAP Table RJHA300 (IS-M/AM: OPM Header Structure)

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	RJHA300	Table Relationship Diagram
Short Description	IS-M/AM: OPM Header Structure

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: OPM Header Structure
2	.INCLUDE	☐				0	0	IS-M/AM: Order-Publishing-Media (Header Data)
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	*
5	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
6	ANGDT	☐	ANGDT_V	DATUM	DATS	8	0	Quotation/Inquiry is valid from
7	BNDDT	☐	BNDDT	DATUM	DATS	8	0	Date until which bid/quotation is binding (valid-to date)
8	AUDAT	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
9	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
10	TRVOG	☐	TRVOG_PAM	TRVOG_PAM	CHAR	1	0	IS-M: Transaction Process Group - Order Processing
11	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK
12	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
13	WAEHRG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
14	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TJHVBER
15	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TJHVBER
16	SPART	☐	SPART	SPART	CHAR	2	0	Division	TJHVBER
17	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
18	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
19	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
20	GSKST	☐	GSKST	GSBER	CHAR	4	0	Business area from cost center	TGSB
21	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
22	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
23	FKARA	☐	FKARA	FKART	CHAR	4	0	Proposed billing type for an order-related billing document	*
24	STAFO	☐	JHSTAFO	STAFO	CHAR	6	0	IS-M: Update group for statistics update	TMCB
25	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
26	.INCLUDE	☐				0	0	IS-M/AM: Credit Management: Order Header Fields
27	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
28	KNKLI	☐	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference	KNA1
29	GRUPP	☐	GRUPP_CM	GRUPP_CM	CHAR	4	0	Customer credit group	T691B
30	SBGRP	☐	SBGRP_CM	SBGRP_CM	CHAR	3	0	Credit Representative Group for Credit Management	T024B
31	CTLPC	☐	CTLPC_CM	CTLPC_CM	CHAR	3	0	Credit management: Risk category	T691A
32	CMWAE	☐	WAERS_CM	WAERS	CUKY	5	0	Currency key of credit control area	TCURC
33	CMFRE	☐	CMFRE	DATUM	DATS	8	0	Release date of the document determined by credit management
34	MANUSERF	☐	MANUSERF	TEXT12	CHAR	12	0	IS-M: Order data entered by (entry on paper)
35	MAN_VKBUR	☐	MAN_VKBUR	VKBUR	CHAR	4	0	IS-M/AM: Sales Office of Person who Entered Booking Details	TVBUR
36	REF_AVM_NR	☐	REF_AVM_NR	AVM_NR	CHAR	10	0	IS-M: Reference Order Number of Preceding Order	JHAK
37	SUC_AVM_NR	☐	SUC_AVM_NR	AVM_NR	CHAR	10	0	IS-M: Order Number of Subsequent Document	JHAK
38	FRD_AVM_NR	☐	FRD_AVM_NR	CHAR20	CHAR	20	0	IS-M: Externally Assigned Order Number
39	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
40	NOTIZKNZ	☐	NOTIZKNZ	XFELD	CHAR	1	0	IS-M: Indicates Whether Notes are Available for an OPM Objct
41	AENVERS_NR	☐	AENVERS_NR	AENVERS_NR	NUMC	4	0	IS-M: Last Change Version for Technical System
42	AENVERS_NR_OL	☐	AENVERS_NR	AENVERS_NR	NUMC	4	0	IS-M: Last Change Version for Technical System
43	AEVER_NR_OL_LAST	☐	AENVERS_NR_OL_LAST	AENVERS_NR	NUMC	4	0	IS-M/AM: Last Change Version Number for Technical System
44	AVM_HRKNFT	☐	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
45	.INCLUDE	☐				0	0	IS-PAM: Agent attributes outside agent assignment
46	VERMITTLER	☐	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen	*
47	VNR	☐	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
48	BEDNR	☐	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	JJTVB
49	PROSL	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
50	.INCLUDE	☐				0	0	IS-PAM: Status attributes order header
51	XUVKPV	☐	XUVKPV	XFELD	CHAR	1	0	IS-M: Incomplete Manual Header/Item Sales Agent Assignment
52	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
53	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
54	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
55	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
56	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
57	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
58	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
59	.INCLUDE	☐				0	0	IS-M/AM: Surcharges And Discounts (Update)
60	RAB1_BETR	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
61	RAB1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
62	RAB1_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
63	RAB2_BETR	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
64	RAB2_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
65	RAB2_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
66	RAB3_BETR	☐	JRABPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage discount
67	RAB3_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
68	RAB3_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
69	RAB4_BETR	☐	JRABMEIN	WERTV6	CURR	11	2	IS-M/AM: Quantity-dependent discount
70	RAB4_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
71	RAB4_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	*
72	RAB4_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
73	RAB4_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
74	RAB5_BETR	☐	JRABBETR	WERTV6	CURR	11	2	IS-M/AM: Amount discount
75	RAB5_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
76	RAB5_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
77	RABE_BETR	☐	JRABBETR	WERTV6	CURR	11	2	IS-M/AM: Amount discount
78	RABE_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
79	RABE_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
80	ZUS1_BETR	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
81	ZUS1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
82	ZUS1_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
83	ZUS2_BETR	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
84	ZUS2_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
85	ZUS2_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
86	ZUS3_BETR	☐	JZUSPROZ	DEC4_3	DEC	7	3	IS-M/AM: Percentage Surcharge
87	ZUS3_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
88	ZUS3_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
89	ZUS4_BETR	☐	JZUSMEIN	WERTV6	CURR	11	2	IS-M/AM: Quantity-dependent surcharge
90	ZUS4_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
91	ZUS4_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	*
92	ZUS4_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
93	ZUS4_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
94	ZUS5_BETR	☐	JZUSBETR	WERTV6	CURR	11	2	IS-M/AM: Amount Surcharge
95	ZUS5_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
96	ZUS5_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
97	ZUSE_BETR	☐	JZUSBETR	WERTV6	CURR	11	2	IS-M/AM: Amount Surcharge
98	ZUSE_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
99	ZUSE_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
100	FPRG_BETR	☐	JGPRBETR	WERTV6	CURR	11	2	IS-M/AM: Basic Price
101	FPRG_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
102	FPRG_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	*
103	FPRG_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
104	FPRG_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
105	FPR1_BETR	☐	JVPRBETR	WERTV6	CURR	11	2	IS-M/AM: Agreed price
106	FPR1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
107	FPR1_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
108	XRABZU	☐	XRABZU	XFELD	CHAR	1	0	IS-M: Discount/Surcharge Exists Indicator
109	WAER_IPZA	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
110	XUZUO_LOE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
111	.INCLUDE	☐				0	0	IS-PAM: Purchase Order Data Include
112	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
113	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	T176
114	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
115	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
116	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
117	BNAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
118	TELF1	☐	TELF1_VP	TELF1	CHAR	16	0	Telephone Number
119	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
120	PARNR	☐	ISM_CNTCT_PRSN	BU_PARTNER	CHAR	10	0	IS-M: Contact Person	*
121	ZUKOMM	☐	JZUKOMM	TEXT50	CHAR	50	0	IS-M: Additional Communication Data
122	AVMUPD_CAL	☐	AVMUPD_CAL	AVMUPD_CAL	CHAR	1	0	IS-M: Order Updater - Initiator	TJHAVMUPD
123	AVMUPD_EVN	☐	AVMUPD_EVN	AVMUPD_EVN	CHAR	1	0	IS-M: Order Updater - Event	TJHAVMUPD
124	SD_VBELN_VA	☐	JHVBELN_VA	VBELN	CHAR	10	0	IS-M: Referenced SD Order Number	*
125	PREIS_AVM1	☐	PREIS_AVM1	WERTV8	CURR	15	2	IS-M: Price Field 1 in the Order
126	PREIS_AVM2	☐	PREIS_AVM2	WERTV8	CURR	15	2	IS-M: Price Field 2 in the Order
127	AG_NAME	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
128	KUKARR	☐	JKUKARR	JKUKARR	CHAR	2	0	IS-M: Customer Profile	TJJ95
129	KUKARR_KZT	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
130	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
131	XAGENTUR	☐	XAGENTUR	XFELD	CHAR	1	0	IS-M: Agency Indicator
132	AE	☐	AGEN_AE	AGEN_AE	CHAR	1	0	IS-M: Agency Commission Entitlement
133	XCHKALTKNR	☐	XCHKALTKNR	XFELD	CHAR	1	0	IS-M: Check Alternative Advertiser Number of Agency
134	XCPDK	☐	XONETIMECUST	XFELD	CHAR	1	0	IS-M: 'One-Time Customer (OTC Customer) Indicator
135	ANZ_POS	☐	ANZ_POS	NUMC3	NUMC	3	0	IS-M: Number of Items in Order
136	GPAG_ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
137	VERM_NAME	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
138	YAENVER_NR	☐	AENVERS_NR	AENVERS_NR	NUMC	4	0	IS-M: Last Change Version for Technical System
139	AP_NAME	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
140	YAENVER_NR_OL	☐	AENVERS_NR	AENVERS_NR	NUMC	4	0	IS-M: Last Change Version for Technical System
141	STP_DESCRIPTION	☐	BU_DESCRIP_LONG	CHAR80	CHAR	80	0	Description of a Business Partner
142	PREISHEAD1	☐	PREISHEAD	CHAR15	CHAR	15	0	IS-M: Title template for price fields in order
143	PREISHEAD2	☐	PREISHEAD	CHAR15	CHAR	15	0	IS-M: Title template for price fields in order
144	VKORG_TXT	☐	VTXTK	TEXT20	CHAR	20	0	Name
145	VTWEG_TXT	☐	VTXTK	TEXT20	CHAR	20	0	Name
146	SPART_TXT	☐	VTXTK	TEXT20	CHAR	20	0	Name
147	VKGRP_TXT	☐	VTXTK	TEXT20	CHAR	20	0	Name
148	VKBUR_TXT	☐	VTXTK	TEXT20	CHAR	20	0	Name
149	AUART_TXT	☐	ISM_OBJNAME30	TEXT30	CHAR	30	0	IS-M: General Description of Objects (Length 30)
150	BSARK_TXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
151	VERMITTKNZ	☐	VERMITTKNZ	XFELD	CHAR	1	0	IS-M: Sales Agent Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJHA300	AUART	TJHAK	AUART	REF	1	CN
2	RJHA300	AVMUPD_CAL	TJHAVMUPD	AVMUPD_CAL
3	RJHA300	AVMUPD_EVN	TJHAVMUPD	AVMUPD_EVN
4	RJHA300	BEDNR	JJTVB	BEDNR	REF	1	CN
5	RJHA300	BSARK	T176	BSARK	REF	C	CN
6	RJHA300	CMWAE	TCURC	WAERS	REF	C	CN
7	RJHA300	CTLPC	T691A	CTLPC	REF	C	CN
8	RJHA300	GPAG	JGTGPNR	GPNR	KEY	1	CN
9	RJHA300	GRUPP	T691B	GRUPP
10	RJHA300	GSBER	TGSB	GSBER	REF	C	CN
11	RJHA300	GSKST	TGSB	GSBER	REF	C	CN
12	RJHA300	KALSM	T683	KALSM	REF	C	CN
13	RJHA300	KDGRP	T151	KDGRP	REF	1	CN
14	RJHA300	KKBER	T014	KKBER	REF	C	CN
15	RJHA300	KNKLI	KNA1	KUNNR	REF	C	CN
16	RJHA300	KUKARR	TJJ95	KUKARR	REF	C	CN
17	RJHA300	MANDT	T000	MANDT	KEY	1	CN
18	RJHA300	MAN_VKBUR	TVBUR	VKBUR	REF	1	CN
19	RJHA300	PROSL	TJH23	PRSCHL	REF	1	CN
20	RJHA300	REF_AVM_NR	JHAK	AVM_NR	REF	C	CN
21	RJHA300	SBGRP	T024B	SBGRP	REF	C	CN
22	RJHA300	SPART	TJHVBER	SPART	REF	1	CN
23	RJHA300	STAFO	TMCB	STAFO	REF	C	CN
24	RJHA300	STWAE	TCURC	WAERS	REF	C	CN
25	RJHA300	SUC_AVM_NR	JHAK	AVM_NR	REF	1	CN
26	RJHA300	VKBUR	TVKBZ	VKBUR	REF	C	CN
27	RJHA300	VKGRP	TVBVK	VKGRP	REF	C	CN
28	RJHA300	VKORG	TJHVBER	VKORG
29	RJHA300	VNR	JJTVV	VNR	REF	1	CN
30	RJHA300	VTWEG	TJHVBER	VTWEG	REF	1	CN
31	RJHA300	WAEHRG	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in