SAP ABAP Table RJHAVTPOS (IS-M/AM: Distribution Data Transfer - Item Data)

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	RJHAVTPOS	Table Relationship Diagram
Short Description	IS-M/AM: Distribution Data Transfer - Item Data

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: Data Transfer: Common Item Data (JHAP)
2	AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	*
3	FRD_AVM_NR	☐	FRD_AVM_NR	CHAR20	CHAR	20	0	IS-M: Externally Assigned Order Number
4	POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	*
5	SATZART	☐	AVM_STZART	AVM_STZART	CHAR	2	0	IS-M: Record Types for Order Transfer
6	SART_REIFO	☐	SART_REIFO	SART_REIFO	NUMC	2	0	IS-M: Record Type Sequence Number for Order Transfer
7	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	*
8	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	*
9	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
10	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	*
11	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	*
12	XNACHBEARB	☐	XNACHBEARB	XFELD	CHAR	1	0	IS-M: Post-Editing Required
13	XRESERV	☐	XRESERV	XFELD	CHAR	1	0	IS-M: Reservation indicator
14	RAB1_BETR	☐	PAMTPRZ_AB	NUMC6	NUMC	6	0	IS-M: Discount to a thousandth of a percent
15	RAB1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
16	RAB2_BETR	☐	PAMTPRZ_AB	NUMC6	NUMC	6	0	IS-M: Discount to a thousandth of a percent
17	RAB2_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
18	RAB3_BETR	☐	PAMTPRZ_AB	NUMC6	NUMC	6	0	IS-M: Discount to a thousandth of a percent
19	RAB3_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
20	RAB4_BETR	☐	BETR_11_2	NUM11	NUMC	11	0	IS-M/AM: 11-Char.Amount Field (Incl.Dec 2) for Data Transfer
21	RAB4_PEIN	☐	PAMPEIN_NC	NUMC5	NUMC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
22	RAB4_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	*
23	RAB4_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
24	RAB4_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
25	RAB5_BETR	☐	BETR_11_2	NUM11	NUMC	11	0	IS-M/AM: 11-Char.Amount Field (Incl.Dec 2) for Data Transfer
26	RAB5_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
27	RAB5_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
28	ZUS1_BETR	☐	PAMTPRZ_ZU	NUMC6	NUMC	6	0	IS-M: Surcharge to a thousandth of a percent
29	ZUS1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
30	ZUS2_BETR	☐	PAMTPRZ_ZU	NUMC6	NUMC	6	0	IS-M: Surcharge to a thousandth of a percent
31	ZUS2_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
32	ZUS3_BETR	☐	PAMTPRZ_ZU	NUMC6	NUMC	6	0	IS-M: Surcharge to a thousandth of a percent
33	ZUS3_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
34	ZUS4_BETR	☐	BETR_11_2	NUM11	NUMC	11	0	IS-M/AM: 11-Char.Amount Field (Incl.Dec 2) for Data Transfer
35	ZUS4_PEIN	☐	PAMPEIN_NC	NUMC5	NUMC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
36	ZUS4_MEIN	☐	PAMMEIN	ISPEINH_PR	UNIT	3	0	IS-M: Unit of Measure (Discount, Surcharge, Basic Price)	*
37	ZUS4_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
38	ZUS4_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
39	ZUS5_BETR	☐	BETR_11_2	NUM11	NUMC	11	0	IS-M/AM: 11-Char.Amount Field (Incl.Dec 2) for Data Transfer
40	ZUS5_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
41	ZUS5_BKTYP	☐	BKTYP	BKTYP	CHAR	2	0	IS-M: Condition Input Type in the Order
42	FPR1_BETR	☐	BETR_11_2	NUM11	NUMC	11	0	IS-M/AM: 11-Char.Amount Field (Incl.Dec 2) for Data Transfer
43	FPR1_GRUND	☐	JGRKOND	JGRUND	CHAR	2	0	IS-M: Reason for Entering Conditions
44	FPRG_BETR	☐			NUMC	11	0
45	FPRG_PEIN	☐			NUMC	5	0
46	FPRG_MEIN	☐			UNIT	3	0
47	FPRG_GRUND	☐			CHAR	2	0
48	WERBK_TYP	☐	WKOMBI_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Combination Sale Type	*
49	WERBK_KNZ	☐	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
50	.INCLUDE	☐				0	0	IS-M/AM: Structure for Transferring DT Item (JHAPV)
51	BELEGEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	*
52	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	*
53	ANFANG_PER	☐	ANFANG_PER	PAM_PERIOD	CHAR	14	0	IS-M: Start of Copy/Publication Date Period
54	JVTBEPMART	☐	JVTBEPMART	JVTBEPMART	CHAR	4	0	IS-M/AM: Distribution Planned Quantity Types	TJJBEVTPA
55	XTBEL_VT	☐	XTBEL_VT	XFELD	CHAR	1	0	IS-M: Selective Booking For Distribution BU Indicator
56	VRTMENGE	☐	NUMC15	NUMC15	NUMC	15	0	Numerical field, 15 characters long
57	JVERTPOTZUS	☐	NUMC15	NUMC15	NUMC	15	0	Numerical field, 15 characters long
58	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
59	STORNOGRND	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	*
60	KONKAUS	☐	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	*
61	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	*
62	STICHW	☐	STICHW	TEXT40	CHAR	40	0	IS-M: Keyword
63	.INCLUDE	☐				0	0	IS-M/AM: Purchase Order Data Include (No Enhancement Here)
64	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
65	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	*
66	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
67	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
68	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
69	BNAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
70	TELF1	☐	TELF1_VP	TELF1	CHAR	16	0	Telephone Number
71	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
72	PARNR	☐	ISM_CNTCT_PRSN	BU_PARTNER	CHAR	10	0	IS-M: Contact Person	*
73	ZUKOMM	☐	JZUKOMM	TEXT50	CHAR	50	0	IS-M: Additional Communication Data
74	.INCLUDE	☐				0	0	IS-M/AM: AI Data for RJHAVTPOS (No enhancement here!!)
75	DRERZ_PRO	☐	DRERZ_PRO	DRERZ	CHAR	8	0	Ad Pre-Print Publication	JDTDRER
76	ERSCHDAT_P	☐	ERSCHDAT_P	DATUM	DATS	8	0	Ad Pre-Print Publication Date
77	SI_TYP	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	*
78	BEZEI10	☐	KBEZDRERZ	TEXT10	CHAR	10	0	Short Text for Publication
79	BEZEI40	☐	BEZEI50	TEXT50	CHAR	50	0	Long Text
80	KZPOSTFORM	☐	KZPOSTFORM	KZPOSTFORM	CHAR	1	0	Postal format of publication/postcard/other object
81	SPART	☐	SPARTDRERZ	SPART	CHAR	2	0	Division for publication	*
82	SI_KENNZIF	☐	PAM_KENNZI	PAM_KENNZI	CHAR	10	0	IS-M: Identification Number
83	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
84	KOSTL_R2	☐	KOSTL_R2	KOSTL_R2	CHAR	8	0	Cost center in R/2
85	XINDIVANG	☐	XINDIVANG	XFELD	CHAR	1	0	Contains individual specifications (for postal settlement)
86	SI_ENTSPFL	☐	ISM_SI_ENTSPFL	XFELD	CHAR	1	0	IS-M: Waste Disposal Required Indicator
87	SI_VERBWER	☐	ISM_SI_VERBWER	XFELD	CHAR	1	0	IS-M: Tie-In Ads Indicator
88	ANZSEITEN	☐	ANZSEITEN	NUM8	NUMC	8	0	Number of Pages in Issue
89	FORMATBR	☐	FORMATBR_T	FORMATBR_T	CHAR	9	0	IS-M: Page Width (to a Thousandth of a Unit of Measure)
90	MEINHBREIT	☐	MEINHBREIT	MEINS	UNIT	3	0	IS-M: Unit of measure for page width	*
91	FORMATHOE	☐	FORMATHOE_T	FORMATHOE_T	CHAR	9	0	IS-M: Page Length (to a Thousandth of a Unit of Measure)
92	MEINHHOE	☐	MEINHHOE	MEINS	UNIT	3	0	IS-M: Unit of measurement for page length	*
93	STAERKE	☐	STAERKE_T	STAERKE_T	CHAR	9	0	IS-M: Issue thickness (to a thousandth of a unit of meas.)
94	MEINHSTRK	☐	MEINHSTRK	MEINS	UNIT	3	0	Unit of measurement for thickness	*
95	PAPIERGEW	☐	PAPIERGEW_T	PAPIERGEW_T	CHAR	9	0	IS-M: Weight of paper (to a thousandth of a unit of meas.)
96	MEINHPAGEW	☐	MEINHPAGEW	MEINS	UNIT	3	0	Unit of measure for weight of paper	*
97	PAGEWMANTL	☐	PAGEWMANTL_T	PAGEWMANTL_T	CHAR	9	0	Actual paper weight for common part (to a thousandth of UM)
98	MEINHPAGMT	☐	MEINHPAGEW	MEINS	UNIT	3	0	Unit of measure for weight of paper	*
99	VAGEWPLAN	☐	VAGEWPLAN_T	VAGEWPLAN_T	CHAR	9	0	IS-M: Planned issue weight (to a thousandth of a UM)
100	MEINHGEWP	☐	MEINHVAGEP	MEINS	UNIT	3	0	Unit of weight for planned issue weight	*
101	VAGEWIST	☐	VAGEWIST_T	VAGEWIST_T	CHAR	9	0	IS-M: Actual issue weight (to a thousandth of a UM)
102	MEINHGEWI	☐	MEINHVAGEI	MEINS	UNIT	3	0	Unit of weight for actual issue weight	*
103	DRKEI_01	☐	SIDRKEI_01	WERKS	CHAR	4	0	IS-M/AM: 1st plant for ad insert (Legacy data transfer)	*
104	LAGERORT_01	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
105	LIEFMENGE_01	☐	LIEFMENGE_T	LIEFMENGE_T	CHAR	10	0	IS-M: Quantity Arrival Quantity (to a Thousandth of a UM)
106	MEINLIEF_01	☐	MEINLIEF	MEINS	UNIT	3	0	Unit of Measure for Delivery Quantity	*
107	VERFBKTAG_01	☐	VERFBKTAG	DATUM	DATS	8	0	Earl.date of availability (for shipping from printing works)
108	VERFBKZEIT_01	☐	VERFBKZEIT	UZEIT	TIMS	6	0	Availability time
109	ANLIEFTAGS_01	☐	ANLIEFTAGS	DATUM	DATS	8	0	Planned Goods Arrival Date
110	ANLIEFERZS_01	☐	ANLIEFERZS	UZEIT	TIMS	6	0	Planned Goods Arrival Time
111	ANLIEFTAGI_01	☐	ANLIEFTAGI	DATUM	DATS	8	0	Actual Goods Arrival Date
112	ANLIEFERZI_01	☐	ANLIEFERZI	UZEIT	TIMS	6	0	Actual Goods Arrival Time
113	ABWBEZR_RH_01	☐	ABWBEZR_RH	BEZRUNDE	CHAR	10	0	Alternative Delivery Round for Total Market Coverage	*
114	ABWBEZR_VT_01	☐	ABWBEZR_VT	BEZRUNDE	CHAR	10	0	Delivery Round for Ad Insert Distribution	*
115	DRKEI_02	☐	SIDRKEI_02	WERKS	CHAR	4	0	IS-M/AM: 2nd plant for ad insert (Legacy data transfer)	*
116	LAGERORT_02	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
117	LIEFMENGE_02	☐	LIEFMENGE_T	LIEFMENGE_T	CHAR	10	0	IS-M: Quantity Arrival Quantity (to a Thousandth of a UM)
118	MEINLIEF_02	☐	MEINLIEF	MEINS	UNIT	3	0	Unit of Measure for Delivery Quantity	*
119	VERFBKTAG_02	☐	VERFBKTAG	DATUM	DATS	8	0	Earl.date of availability (for shipping from printing works)
120	VERFBKZEIT_02	☐	VERFBKZEIT	UZEIT	TIMS	6	0	Availability time
121	ANLIEFTAGS_02	☐	ANLIEFTAGS	DATUM	DATS	8	0	Planned Goods Arrival Date
122	ANLIEFERZS_02	☐	ANLIEFERZS	UZEIT	TIMS	6	0	Planned Goods Arrival Time
123	ANLIEFTAGI_02	☐	ANLIEFTAGI	DATUM	DATS	8	0	Actual Goods Arrival Date
124	ANLIEFERZI_02	☐	ANLIEFERZI	UZEIT	TIMS	6	0	Actual Goods Arrival Time
125	ABWBEZR_RH_02	☐	ABWBEZR_RH	BEZRUNDE	CHAR	10	0	Alternative Delivery Round for Total Market Coverage	*
126	ABWBEZR_VT_02	☐	ABWBEZR_VT	BEZRUNDE	CHAR	10	0	Delivery Round for Ad Insert Distribution	*
127	DRKEI_03	☐	SIDRKEI_03	WERKS	CHAR	4	0	IS-M/AM: Third plant for ad insert (Legacy data transfer)	*
128	LAGERORT_03	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
129	LIEFMENGE_03	☐	LIEFMENGE_T	LIEFMENGE_T	CHAR	10	0	IS-M: Quantity Arrival Quantity (to a Thousandth of a UM)
130	MEINLIEF_03	☐	MEINLIEF	MEINS	UNIT	3	0	Unit of Measure for Delivery Quantity	*
131	VERFBKTAG_03	☐	VERFBKTAG	DATUM	DATS	8	0	Earl.date of availability (for shipping from printing works)
132	VERFBKZEIT_03	☐	VERFBKZEIT	UZEIT	TIMS	6	0	Availability time
133	ANLIEFTAGS_03	☐	ANLIEFTAGS	DATUM	DATS	8	0	Planned Goods Arrival Date
134	ANLIEFERZS_03	☐	ANLIEFERZS	UZEIT	TIMS	6	0	Planned Goods Arrival Time
135	ANLIEFTAGI_03	☐	ANLIEFTAGI	DATUM	DATS	8	0	Actual Goods Arrival Date
136	ANLIEFERZI_03	☐	ANLIEFERZI	UZEIT	TIMS	6	0	Actual Goods Arrival Time
137	ABWBEZR_RH_03	☐	ABWBEZR_RH	BEZRUNDE	CHAR	10	0	Alternative Delivery Round for Total Market Coverage	*
138	ABWBEZR_VT_03	☐	ABWBEZR_VT	BEZRUNDE	CHAR	10	0	Delivery Round for Ad Insert Distribution	*
139	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN_EXTERN	PS_POSID	CHAR	24	0	IS-M: Marketing Campaign

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJHAVTPOS	DRERZ_PRO	JDTDRER	DRERZ
2	RJHAVTPOS	JVTBEPMART	TJJBEVTPA	JVTBEPMART

History

Last changed by/on	SAP	20130529
SAP Release Created in