SAP ABAP Table JHVFKFP1 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVFKFP1	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	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
7	SFAKN	☐	JJBELNRSV	JJBELNR	CHAR	10	0	IS-M: Reversal Reference	JHTFK
8	FKART	☐	FKART_PAM	FKART_PAM	CHAR	4	0	IS-M/AM: Billing/Settlement Document Type	TJH05
9	FKDAT	☐	JHFKDAT	DATUM	DATS	8	0	IS-M: Actual Billing/Settlement Date
10	FKTYP	☐	JHFKTYP	JHFKTYP	CHAR	1	0	IS-M/AM: Billing Category	TJH19
11	STTYP	☐	STORNOTYP	STORNOTYP	CHAR	1	0	IS-M: Reversal Type
12	RFBSK	☐	JHRFBSK	JHRFBSK	CHAR	1	0	IS-M/AM: Status for Transfer to Accounting / HR
13	STAFI	☐	ISMSTAFI	ISMSTAFI	CHAR	1	0	IS-M: Status of the Financial Accounting Document
14	VBTYP	☐	ISPVBTYP	ISPVBTYP	CHAR	1	0	IS-M/AM: Sales Document Category
15	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
16	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
17	NETWK	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
18	MWSBK	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
19	AUBEL	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
20	AUPOS	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
21	AUGRP	☐	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	JHAGA
22	VGBEL	☐	JHVGBEL	JHVGBEL	CHAR	10	0	IS-M: Document Number of Template Document
23	VGPOS	☐	JHVGPOS	JHVGPOS	NUMC	6	0	IS-M: Item Number of the Template Business Item
24	VGETE	☐	GRABR_VG	GRUPPABR	NUMC	3	0	IS-M: Group/Settlement Number of Template Document
25	VGTYP	☐	ISPVBTYP_V	ISPVBTYP	CHAR	1	0	IS-M: Preceding Sales Document Category
26	VGOBJ	☐	JHOBJAR_V	JHOBJKT	CHAR	2	0	IS-M: Preceding object type	TJH97
27	VGFKTYP	☐	JHVGFKTYP	JHFKTYP	CHAR	1	0	IS-M: Billing Category for Preceding Billing Document	TJH19
28	VBELV	☐	ISMVBELV	ISMVBELV	CHAR	10	0	IS-M: Originating sales document
29	POSNV	☐	ISMPOSNV	ISMPOSNR	NUMC	6	0	IS-M: Originating item
30	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
31	XERLV	☐	JHXERLV	JHXERLV	CHAR	1	0	IS-M: Revenue Distribution Status
32	SHKZG	☐	JHSHKZG	JHSHKZG	CHAR	1	0	IS-M: Debit/Credit indicator
33	XCNCL	☐	JH_XCNCL	XFELD	CHAR	1	0	IS-M/AM: Reversal Indicator for Billing Item

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVFKFP1	AUBEL	JHAK	AVM_NR	REF	1	CN
2	JHVFKFP1	AUGRP	JHAGA	GRUPPABRNR	REF	1	CN
3	JHVFKFP1	AUPOS	JHAP	POS_NR	REF	1	CN
4	JHVFKFP1	FKART	TJH05	FKART	REF	1	CN
5	JHVFKFP1	FKTYP	TJH19	FKTYP
6	JHVFKFP1	MANDT	T000	MANDT	KEY	1	CN
7	JHVFKFP1	SFAKN	JHTFK	VBELN	REF	C	CN
8	JHVFKFP1	VGFKTYP	TJH19	FKTYP
9	JHVFKFP1	VGOBJ	TJH97	OBJKT	REF

History

Last changed by/on	SAP	20130529
SAP Release Created in