SAP ABAP Table JHAREV1 (IS-M/AM: Order Revenue Recognition Key Date Values)

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	TRANSP	Transparent table
Transparent table	JHAREV1	Table Relationship Diagram
Short Description	IS-M/AM: Order Revenue Recognition Key Date Values

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	*
2	COUNT_JHFREV1	☑	COUNT_JHFREV1	COUNTREV	NUMC	18	0	IS-M/AM: Counter for Order Key Date Logic
3	.INCLUDE	☐				0	0	IS-M/AM: BW Key Structure for IS 0ME_ISM_AM_REV 1 and 2
4	EOBPO	☐	EOBPO	EOBPO	NUMC	6	0	IS-M/AM: Revenue Object Document Item	*
5	EVBWTYP	☐	EVBWTYP	EVBWTYP	CHAR	1	0	IS-M/AM: Valuation Category in Revenue Distribution	*
6	EVBWKEY	☐	EVBWKEY	EVBWKEY	CHAR	20	0	IS-M/AM: Variable Valuation Key for Revenue Distribution
7	.INCLUDE	☐				0	0	IS-M/AM: BW Structure for IS 0ME_ISM_AM_REV_1 Key Date
8	BW_STICHTAG	☐	BW_STICHTAG	DATUM	DATS	8	0	IS-M/AM: Key Date For BW Key Date Logic
9	.INCLUDE	☐				0	0	IS-M/AM: BW Structure for IS 0ME_ISM_AM_REV_1
10	KWERT_EV	☐	EVKWERT_EV	WERTV8	CURR	15	2	IS-M/AM: Condition Value in Revenue Distribution
11	SAKN1_EV	☐	ISM_SAKN2	SAKNR	CHAR	10	0	IS-M: Actual P&L Account	*
12	SAKN2_EV	☐	SAKN1	SAKNR	CHAR	10	0	Interim Account for Revenue Accrual	*
13	KTOPL	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	T004
14	REF_BELID	☐	EOREF_BELID	EOREF_BELID	CHAR	10	0	IS-M/AM: Doc.Number of Rev.Distributed Document Object
15	REF_POSID	☐	EOREF_POSID	EOREF_POSID	NUMC	6	0	IS-M: Item Number of Revenue Distributed Document Object
16	REF_BELTYP	☐	EOBELTYP	EOBELTYP	CHAR	1	0	IS-M: Document Category for which Revenue Dist.is Performed	*
17	REF_WAERS	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
18	UVEVB	☐	JH_UVEVB	JH_UVEVB	CHAR	1	0	IS-M: Incompleteness Status for Revenue Object Document	*
19	EVOBJ	☐	EVOBJ	EVOBJ	CHAR	10	0	IS-M/AM: Revenue Object
20	PFOBJ	☐	PFOBJ	PFOBJ	CHAR	10	0	IS-M/AM: Partner Object	*
21	BDJPOPER	☐	EV_BDJPOPER		NUMC	7	0	IS-M: Posting Year and Posting Period Format YYYYMMM)
22	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
23	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
24	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
25	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
26	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
27	.INCLUDE	☐				0	0	IS-MAM: BW Structure for IS 0ME_ISM_AM_REV1
28	STORNO_KZ	☐	XSTORNO_KZ	XFELD	CHAR	1	0	IS-M: Reversal BW (0Recordmode)
29	AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	*
30	GPAG	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
31	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	*
32	UR_BELEINH	☐	UR_BELEINH	BELEINH	CHAR	10	0	IS-M: Initial Booking Unit for the OPM Item	*
33	BELEGEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	*
34	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
35	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
36	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
37	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
38	REGULIERER	☐	REGULIERER	GPNR	CHAR	10	0	IS-M: Payer	*
39	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	*
40	XFAKT_EE	☐	XFAKT_EE	XFELD	CHAR	1	0	IS-M: Billed Indicator
41	BER_TERMIN	☐	BER_TERMIN	DATUM	DATS	8	0	IS-M: Date Services were Created for Settlement Purposes
42	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
43	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	*
44	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
45	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
46	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
47	AVM_HRKNFT	☐	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
48	VERMITTLER	☐	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen	*
49	POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	*
50	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	*
51	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	*
52	INHK_TECH1	☐	INHK_TECH1	INHALTSKOM	CHAR	8	0	IS-M: Technical Content Component (Positioning View)	*
53	INHK_TLEV1	☐	INHK_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Level 1 content component in the hierarchy	*
54	INHK_TECH2	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	*
55	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	*
56	AZART_PLAZ	☐	AZART_PLAZ	AZART_PLAZ	CHAR	4	0	IS-M: Ad Type with Regard to General Positioning	*
57	KONKAUS	☐	KONKAUS	KONKAUS	CHAR	2	0	IS-M: Competitor exclusion	*
58	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	*
59	SI_TYP	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	*
60	MATNR	☐	MATNR_DIEN	MATNR_DIEN	CHAR	18	0	IS-M: Service material number	*
61	DIENTYP	☐	DIENTYP	DIENTYP	CHAR	4	0	IS-M: Service Type	*
62	DIEN_BE	☐	DIEN_BE	BELEINH	CHAR	10	0	IS-M: Service: Assigned Booking Unit	*
63	DIEN_IKO	☐	DIEN_IKO	INHALTSKOM	CHAR	8	0	IS-M: Service: Assigned Content Component	*
64	XTECH_MIN1	☐	XTECH_MIN1	XFELD	CHAR	1	0	IS-M: Tech.process.started (for at least 1 schedule line)
65	XTECH_EE	☐	XTECH_EE	XFELD	CHAR	1	0	IS-M: Tech.Complete (All Schedule Lines Fully Processed)
66	GPNR_RECH	☐	GPNR_RECH	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	*
67	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	*
68	BER_HEFT	☐	ISM_BER_HEFT	PAM_PERIOD	CHAR	14	0	IS-M: Service Creation Copy Number for Settlement
69	VAVARTYP	☐	VAVARTYPTA	VAVARTYP	CHAR	2	0	Actual issue variant type	*
70	IHKOMP	☐	INHK_PRICE	INHALTSKOM	CHAR	8	0	IS-M: Content component from price hierarchy	*
71	SEITE_FSP	☐	SEITE_FSP	SEITE_FSP	CHAR	4	0	IS-M: Page/column format	*
72	SEITE_FORM	☐	SEITE_FORM	SEITE_FORM	CHAR	2	0	IS-M: Page Format	*
73	SFSP_ABR	☐	SFSP_ABR	SEITE_FSP	CHAR	4	0	IS-M: Column Format for Settlement	*
74	WERBK_TYP	☐	WERBK_TYP	WKOMBI_TYP	CHAR	2	0	IS-M: Advertising Combination Type	*
75	AZART_GEST	☐	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	*
76	AZART_FORM	☐	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	*
77	AZART_FARB	☐	AZART_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Ad Type	*
78	AZART_SOND	☐	AZART_SOND	AZART_SOND	CHAR	2	0	IS-M: Ad Type - Special Handling Type	*
79	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
80	STORNOGRND	☐	STOGRD_PAM	STOGRD_PAM	CHAR	3	0	IS-M: Cancellation Reason	*
81	INHK_KLEV1	☐	JSBW_LEV1	INHALTSKOM	CHAR	8	0	IS-M: Content component level 1 of hierarchy JSBW	*
82	BNAME	☐	JSBW_B_V	TEXT32	CHAR	32	0	IS-M: Name of Ordering Party JSBW
83	GRUPPABRNR	☐	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	*
84	BOOK_OL	☐	ISM_BOOK_OL	ISM_BOOK_OL	CHAR	4	0	IS-M/AM: Booking Type for Online Advertising	*
85	SELDAT_VON	☐	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
86	SELDAT_BIS	☐	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
87	WERBK_KNZ	☐	WERBK_KNZ	WERBEKKNZ	NUMC	4	0	IS-M: Combination Sale Indicator
88	WS_TIMESLC	☐	WS_TIMESLC	WS_TIMESLC	CHAR	2	0	IS-M: Commercial Time Slice	*
89	WS_BLOCK	☐	WS_BLOCK	WS_BLOCK	CHAR	2	0	IS-M: Commercial Cluster	*
90	WS_STELLE	☐	WS_STELLE	NUMC3	NUMC	3	0	IS-M: Position (Sequence) Within a Commercial Cluster
91	FORMAT_ONL	☐	FORMAT_ONL	FORMAT_ONL	CHAR	4	0	IS-M/AM: Format Proposal (Online)	*
92	XAEPROV	☐	XAEPROV	XFELD	CHAR	1	0	IS-M: Agency Commission Credit Memo Indicator
93	IKO_STAT	☐	IKO_STAT	INHALTSKOM	CHAR	8	0	IS-M: Statistical content component	*
94	BEGRP_STAT	☐	BEGRP_STAT	BEGRP_STAT	CHAR	4	0	IS-M: BU Grouping for Statistics	*
95	TERM_TYP	☐	TERMINTYP	TERMINTYP	CHAR	1	0	IS-M/AM: Date Category Copy Number/Publication Date	*
96	STGVB_PAM	☐	STGVB_PAM	STGVB_PAM	CHAR	2	0	IS-M: Statistics Group for Sales Documents	*
97	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
98	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
99	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
100	CAMPAIGN_PSP	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
101	REF_VBELN	☐	JJBELNR	JJBELNR	CHAR	10	0	IS-M/AM: Billing Document	*
102	REF_POSNR	☐	JJPOSNR	JJPOSNR	NUMC	6	0	IS-M/AM: Item (number) in settlement document	*
103	RRREL	☐	ISMRR_RELTYP	ISMRR_RELTYP	CHAR	1	0	IS-M/AM: Revenue Recognition Category

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHAREV1	KTOPL	T004	KTOPL	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	463