SAP ABAP Table RJHEF001 (Display Structure for Sales Volumes in Media Partnerships)

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	RJHEF001	Table Relationship Diagram
Short Description	Display Structure for Sales Volumes in Media Partnerships

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	.INCLU-MPS	☐				0	0	Item Structure for ALV Bonus
2	KAPPLMPS	☐	KAPPL	KAPPL	CHAR	2	0	Application	*
3	KNUMAMPS	☐	KNUMA	KNUMA	CHAR	10	0	Agreement (various conditions grouped together)	*
4	KSCHLMPS	☐	KSCHL	KSCHL	CHAR	4	0	Condition Type	*
5	KOTABNRMPS	☐	KOTABNR	KOTABNR	NUMC	3	0	Condition table	*
6	VAKEYMPS	☐	VAKEY_50	VAKEY_50	CHAR	50	0	Variable key 50 bytes
7	DATABMPS	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
8	DATBIMPS	☐	DATBI	DATUM	DATS	8	0	Valid To Date
9	KUNXXMPS	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
10	MATNRMPS	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
11	SPMON_IMPS	☐	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
12	VBELNMPS	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
13	POSNRMPS	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
14	FBUDAMPS	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
15	KUNAGMPS	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
16	KUNRGMPS	☐	KUNRG	KUNNR	CHAR	10	0	Payer	*
17	RR_WAERSMPS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
18	KWAEH_AUFMPS	☐	KWAEH	WAERS	CUKY	5	0	Condition currency (for cumulation fields)	*
19	KONWS_AUFMPS	☐	KONWS	WAERS	CUKY	5	0	Currency Key: Condition Scale	*
20	KONBASMPS	☐			CUKY	5	0
21	KONSTAMPS	☐			CUKY	5	0
22	DECIMALSMPS	☐			CHAR	6	0
23	KNUMHMPS	☐	KNUMH	KNUMB	CHAR	10	0	Condition record number
24	KOPOSMPS	☐	KOPOS	NUM02	NUMC	2	0	Sequential number of the condition
25	SPMONMPS	☐	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
26	RUWRTMPS	☐	MC_RUWRT	WERTV10	CURR	19	2	Rebate: Accrued value in local currency
27	KAWRT_KMPS	☐	MC_KAWRT_K	WERTV10	CURR	19	2	Cumulative condition base value (cond.curr.)
28	KSTBSMPS	☐	MC_KSTBS	WERTV10	CURR	19	2	Cumulative scale base value
29	KWAEHMPS	☐	KWAEH	WAERS	CUKY	5	0	Condition currency (for cumulation fields)	*
30	RUWRT_KMPS	☐	MC_RUWRT_K	WERTV10	CURR	19	2	Rebate: Accruals value in condition currency
31	BONEM	☐	BONEM	KUNNR	CHAR	10	0	Rebate recipient	*
32	.INCLU-FAK	☐				0	0	Generated Table for View
33	MANDTFAK	☐	MANDT	MANDT	CLNT	3	0	Client	T000
34	VBELNFAK	☐	JJBELNR	JJBELNR	CHAR	10	0	IS-M/AM: Billing Document	*
35	POSNRFAK	☐	JJPOSNR	JJPOSNR	NUMC	6	0	IS-M/AM: Item (number) in settlement document	*
36	ERFUSERFAK	☐	ERFUSER	USNAM	CHAR	12	0	Created By
37	ERFDATEFAK	☐	ERFDATE	DATUM	DATS	8	0	Created On
38	SFAKNFAK	☐	JJBELNRSV	JJBELNR	CHAR	10	0	IS-M: Reversal Reference	JHTFK
39	BANKSFAK	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
40	BANKNFAK	☐	BANKN	BANKN	CHAR	18	0	Bank account number
41	BANKLFAK	☐	BANKL	BANKL	CHAR	15	0	Bank number
42	FKARTFAK	☐	FKART_PAM	FKART_PAM	CHAR	4	0	IS-M/AM: Billing/Settlement Document Type	TJH05
43	FKDATFAK	☐	JHFKDAT	DATUM	DATS	8	0	IS-M: Actual Billing/Settlement Date
44	FKTYPFAK	☐	JHFKTYP	JHFKTYP	CHAR	1	0	IS-M/AM: Billing Category	TJH19
45	VKORGFAK	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
46	WAERKFAK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
47	ZTERMFAK	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
48	ZLSCHFAK	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	*
49	STTYPFAK	☐	STORNOTYP	STORNOTYP	CHAR	1	0	IS-M: Reversal Type
50	XCNCLFAK	☐	JH_XCNCL	XFELD	CHAR	1	0	IS-M/AM: Reversal Indicator for Billing Item
51	BELNRFAK	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
52	BRTWKFAK	☐	JHBRTWRK	WERTV8	CURR	15	2	IS-M: Gross Value in Document Currency (Header)
53	NETWKFAK	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
54	MWSBKFAK	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
55	RFBSKFAK	☐	JHRFBSK	JHRFBSK	CHAR	1	0	IS-M/AM: Status for Transfer to Accounting / HR
56	STAFIFAK	☐	ISMSTAFI	ISMSTAFI	CHAR	1	0	IS-M: Status of the Financial Accounting Document
57	VBTYPFAK	☐	ISPVBTYP	ISPVBTYP	CHAR	1	0	IS-M/AM: Sales Document Category
58	BUKRSFAK	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
59	KUNRGFAK	☐	REGULIERER	GPNR	CHAR	10	0	IS-M: Payer	JGTGPNR
60	KUNREFAK	☐	GPNR_RECH	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	JGTGPNR
61	STCEGFAK	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
62	EKORGFAK	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
63	SD_VBELN_VFFAK	☐	JHVBELN_VF	VBELN	CHAR	10	0	IS-M: SD Billing Number Referenced	*
64	AUBELFAK	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
65	AUPOSFAK	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
66	AUGRPFAK	☐	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	JHAGA
67	BEINHFAK	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	JJTBE
68	BEINH_BASFAK	☐	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	JJTBE
69	IHKOMPFAK	☐	IKO_PREIS	INHALTSKOM	CHAR	8	0	IS-M: Content component for pricing call	JJTIKO
70	INHK_KFMFAK	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
71	INHK_TECH2FAK	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	JJTIKO
72	INSERENTFAK	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JJVDB_MK_FK
73	DIENSTLFAK	☐	MATNR_DIEN	MATNR_DIEN	CHAR	18	0	IS-M: Service material number	JJTDIEN
74	DITYPFAK	☐	DIENTYP	DIENTYP	CHAR	4	0	IS-M: Service Type	TJH71
75	POSARFAK	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
76	KUNAGFAK	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
77	PSTYVFAK	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
78	KREZEFAK	☐	JHKREZE	GPNR	CHAR	10	0	IS-M: Payee	JGTGPNR
79	KRERSFAK	☐	JHKRERS	GPNR	CHAR	10	0	IS-M: Invoicing Party	JGTGPNR
80	VNRFAK	☐	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
81	VTNRFAK	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
82	UEBERLARTFAK	☐	UEBERLZIEL	UEBERLZIEL	CHAR	1	0	IS-M: Transfer Destination
83	FBUDAFAK	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
84	XERLVFAK	☐	JHXERLV	JHXERLV	CHAR	1	0	IS-M: Revenue Distribution Status
85	SHKZGFAK	☐	JHSHKZG	JHSHKZG	CHAR	1	0	IS-M: Debit/Credit indicator
86	VGBELFAK	☐	JHVGBEL	JHVGBEL	CHAR	10	0	IS-M: Document Number of Template Document
87	VGPOSFAK	☐	JHVGPOS	JHVGPOS	NUMC	6	0	IS-M: Item Number of the Template Business Item
88	VGETEFAK	☐	GRABR_VG	GRUPPABR	NUMC	3	0	IS-M: Group/Settlement Number of Template Document	*
89	VGTYPFAK	☐	ISPVBTYP_V	ISPVBTYP	CHAR	1	0	IS-M: Preceding Sales Document Category
90	VGOBJFAK	☐	JHOBJAR_V	JHOBJKT	CHAR	2	0	IS-M: Preceding object type	TJH97
91	VGFKTYPFAK	☐	JHVGFKTYP	JHFKTYP	CHAR	1	0	IS-M: Billing Category for Preceding Billing Document	TJH19
92	VBELVFAK	☐	ISMVBELV	ISMVBELV	CHAR	10	0	IS-M: Originating sales document
93	POSNVFAK	☐	ISMPOSNV	ISMPOSNR	NUMC	6	0	IS-M: Originating item
94	ERFTIMEFAK	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
95	RRRELFAK	☐	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	RJHEF001	AUBELFAK	JHAK	AVM_NR	REF	1	CN
2	RJHEF001	AUGRPFAK	JHAGA	GRUPPABRNR	REF	1	CN
3	RJHEF001	AUPOSFAK	JHAP	POS_NR	REF	1	CN
4	RJHEF001	BANKSFAK	T005	LAND1	REF	1	CN
5	RJHEF001	BEINHFAK	JJTBE	BELEINH	REF	1	CN
6	RJHEF001	BEINH_BASFAK	JJTBE	BELEINH	REF	1	CN
7	RJHEF001	BUKRSFAK	T001	BUKRS	REF	1	CN
8	RJHEF001	DIENSTLFAK	JJTDIEN	MATNR	REF	1	CN
9	RJHEF001	DITYPFAK	TJH71	DIENTYP	REF	1	CN
10	RJHEF001	EKORGFAK	T024E	EKORG	REF	1	CN
11	RJHEF001	FKARTFAK	TJH05	FKART	REF	1	CN
12	RJHEF001	FKTYPFAK	TJH19	FKTYP
13	RJHEF001	IHKOMPFAK	JJTIKO	INHALTSKOM	REF	1	CN
14	RJHEF001	INHK_KFMFAK	JJTIKO	INHALTSKOM	REF	1	CN
15	RJHEF001	INHK_TECH2FAK	JJTIKO	INHALTSKOM	REF	1	CN
16	RJHEF001	INSERENTFAK	JJVDB_MK_FK	GPNR	REF	1	CN
17	RJHEF001	KRERSFAK	JGTGPNR	GPNR	REF	1	CN
18	RJHEF001	KREZEFAK	JGTGPNR	GPNR	REF	1	CN
19	RJHEF001	KUNAGFAK	JGTGPNR	GPNR
20	RJHEF001	KUNREFAK	JGTGPNR	GPNR	REF	1	CN
21	RJHEF001	KUNRGFAK	JGTGPNR	GPNR	REF	1	CN
22	RJHEF001	MANDTFAK	T000	MANDT	KEY	1	CN
23	RJHEF001	POSARFAK	TJH17	AVMPOS_ART	REF	1	CN
24	RJHEF001	PSTYVFAK	TJHAP	PSTYV	REF	1	CN
25	RJHEF001	SFAKNFAK	JHTFK	VBELN	REF	C	CN
26	RJHEF001	VGFKTYPFAK	TJH19	FKTYP
27	RJHEF001	VGOBJFAK	TJH97	OBJKT	REF
28	RJHEF001	VKORGFAK	TVKO	VKORG	REF	1	CN
29	RJHEF001	VNRFAK	JJTVV	VNR	REF	1	CN
30	RJHEF001	VTNRFAK	JHTVKO	VTNR	REF	1	CN
31	RJHEF001	WAERKFAK	TCURC	WAERS	REF	1	CN

History

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