SAP ABAP Table JHVFKRAJO (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVFKRAJO	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VBELN	☑	JJBELNR	JJBELNR	CHAR	10	0	IS-M/AM: Billing Document
3	POSNR	☑	JJPOSNR	JJPOSNR	NUMC	6	0	IS-M/AM: Item (number) in settlement document
4	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
5	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
6	SFAKN	☐	JJBELNRSV	JJBELNR	CHAR	10	0	IS-M: Reversal Reference	JHTFK
7	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
8	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
9	BANKL	☐	BANKL	BANKL	CHAR	15	0	Bank number
10	FKART	☐	FKART_PAM	FKART_PAM	CHAR	4	0	IS-M/AM: Billing/Settlement Document Type	TJH05
11	FKDAT	☐	JHFKDAT	DATUM	DATS	8	0	IS-M: Actual Billing/Settlement Date
12	FKTYP	☐	JHFKTYP	JHFKTYP	CHAR	1	0	IS-M/AM: Billing Category	TJH19
13	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
14	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
15	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
16	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method
17	STTYP	☐	STORNOTYP	STORNOTYP	CHAR	1	0	IS-M: Reversal Type
18	XCNCL	☐	JH_XCNCL	XFELD	CHAR	1	0	IS-M/AM: Reversal Indicator for Billing Item
19	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
20	BRTWK	☐	JHBRTWRK	WERTV8	CURR	15	2	IS-M: Gross Value in Document Currency (Header)
21	NETWK	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
22	MWSBK	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
23	RFBSK	☐	JHRFBSK	JHRFBSK	CHAR	1	0	IS-M/AM: Status for Transfer to Accounting / HR
24	STAFI	☐	ISMSTAFI	ISMSTAFI	CHAR	1	0	IS-M: Status of the Financial Accounting Document
25	VBTYP	☐	ISPVBTYP	ISPVBTYP	CHAR	1	0	IS-M/AM: Sales Document Category
26	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
27	KUNRG	☐	REGULIERER	GPNR	CHAR	10	0	IS-M: Payer	JGTGPNR
28	KUNRE	☐	GPNR_RECH	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	JGTGPNR
29	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
30	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
31	SD_VBELN_VF	☐	JHVBELN_VF	VBELN	CHAR	10	0	IS-M: SD Billing Number Referenced
32	AUBEL	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
33	AUPOS	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
34	AUGRP	☐	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	JHAGA
35	BEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	JJTBE
36	BEINH_BAS	☐	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	JJTBE
37	IHKOMP	☐	IKO_PREIS	INHALTSKOM	CHAR	8	0	IS-M: Content component for pricing call	JJTIKO
38	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
39	INHK_TECH2	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	JJTIKO
40	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JJVDB_MK_FK
41	DIENSTL	☐	MATNR_DIEN	MATNR_DIEN	CHAR	18	0	IS-M: Service material number	JJTDIEN
42	DITYP	☐	DIENTYP	DIENTYP	CHAR	4	0	IS-M: Service Type	TJH71
43	POSAR	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
44	KUNAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
45	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
46	KREZE	☐	JHKREZE	GPNR	CHAR	10	0	IS-M: Payee	JGTGPNR
47	KRERS	☐	JHKRERS	GPNR	CHAR	10	0	IS-M: Invoicing Party	JGTGPNR
48	VNR	☐	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
49	VTNR	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
50	UEBERLART	☐	UEBERLZIEL	UEBERLZIEL	CHAR	1	0	IS-M: Transfer Destination
51	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
52	XERLV	☐	JHXERLV	JHXERLV	CHAR	1	0	IS-M: Revenue Distribution Status
53	SHKZG	☐	JHSHKZG	JHSHKZG	CHAR	1	0	IS-M: Debit/Credit indicator
54	VGBEL	☐	JHVGBEL	JHVGBEL	CHAR	10	0	IS-M: Document Number of Template Document
55	VGPOS	☐	JHVGPOS	JHVGPOS	NUMC	6	0	IS-M: Item Number of the Template Business Item
56	VGETE	☐	GRABR_VG	GRUPPABR	NUMC	3	0	IS-M: Group/Settlement Number of Template Document
57	VGTYP	☐	ISPVBTYP_V	ISPVBTYP	CHAR	1	0	IS-M: Preceding Sales Document Category
58	VGOBJ	☐	JHOBJAR_V	JHOBJKT	CHAR	2	0	IS-M: Preceding object type	TJH97
59	VGFKTYP	☐	JHVGFKTYP	JHFKTYP	CHAR	1	0	IS-M: Billing Category for Preceding Billing Document	TJH19
60	VBELV	☐	ISMVBELV	ISMVBELV	CHAR	10	0	IS-M: Originating sales document
61	POSNV	☐	ISMPOSNV	ISMPOSNR	NUMC	6	0	IS-M: Originating item
62	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
63	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	JHVFKRAJO	AUBEL	JHAK	AVM_NR	REF	1	CN
2	JHVFKRAJO	AUGRP	JHAGA	GRUPPABRNR	REF	1	CN
3	JHVFKRAJO	AUPOS	JHAP	POS_NR	REF	1	CN
4	JHVFKRAJO	BANKS	T005	LAND1	REF	1	CN
5	JHVFKRAJO	BEINH	JJTBE	BELEINH	REF	1	CN
6	JHVFKRAJO	BEINH_BAS	JJTBE	BELEINH	REF	1	CN
7	JHVFKRAJO	BUKRS	T001	BUKRS	REF	1	CN
8	JHVFKRAJO	BUKRS	T001	MANDT	REF	1	CN
9	JHVFKRAJO	DIENSTL	JJTDIEN	MATNR	REF	1	CN
10	JHVFKRAJO	DITYP	TJH71	DIENTYP	REF	1	CN
11	JHVFKRAJO	EKORG	T024E	EKORG	REF	1	CN
12	JHVFKRAJO	FKART	TJH05	FKART	REF	1	CN
13	JHVFKRAJO	FKTYP	TJH19	FKTYP
14	JHVFKRAJO	IHKOMP	JJTIKO	INHALTSKOM	REF	1	CN
15	JHVFKRAJO	INHK_KFM	JJTIKO	INHALTSKOM	REF	1	CN
16	JHVFKRAJO	INHK_TECH2	JJTIKO	INHALTSKOM	REF	1	CN
17	JHVFKRAJO	INSERENT	JJVDB_MK_FK	GPNR	REF	1	CN
18	JHVFKRAJO	KRERS	JGTGPNR	GPNR	REF	1	CN
19	JHVFKRAJO	KREZE	JGTGPNR	GPNR	REF	1	CN
20	JHVFKRAJO	KUNAG	JGTGPNR	GPNR
21	JHVFKRAJO	KUNRE	JGTGPNR	GPNR	REF	1	CN
22	JHVFKRAJO	KUNRG	JGTGPNR	GPNR	REF	1	CN
23	JHVFKRAJO	MANDT	T000	MANDT	KEY	1	CN
24	JHVFKRAJO	POSAR	TJH17	AVMPOS_ART	REF	1	CN
25	JHVFKRAJO	PSTYV	TJHAP	PSTYV	REF	1	CN
26	JHVFKRAJO	SFAKN	JHTFK	VBELN	REF	C	CN
27	JHVFKRAJO	VGFKTYP	TJH19	FKTYP
28	JHVFKRAJO	VGOBJ	TJH97	OBJKT	REF
29	JHVFKRAJO	VKORG	TVKO	VKORG	REF	1	CN
30	JHVFKRAJO	VNR	JJTVV	VNR	REF	1	CN
31	JHVFKRAJO	VTNR	JHTVKO	VTNR	REF	1	CN
32	JHVFKRAJO	WAERK	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in