SAP ABAP Table JHVFPALL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVFPALL	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	JHTFK
3	POSNR	☑	JJPOSNR	JJPOSNR	NUMC	6	0	IS-M/AM: Item (number) in settlement document
4	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
5	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
6	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
7	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
8	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
9	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
10	ARKTX	☐	ISM_ARKTX	TEXT40	CHAR	40	0	IS-M: Short Text for Document Item (Billing Doc.,Settlement)
11	AUBEL	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
12	AUPOS	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
13	AUGRP	☐	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	JHAGA
14	AUETE	☐	EIN_NR	AVMENR	NUMC	6	0	IS-M: Schedule Line	JHAE
15	AVMAUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK
16	AUREF	☐	AUREF	XFELD	CHAR	1	0	Sales document was created from reference
17	BEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	JJTBE
18	BEINH_BAS	☐	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	JJTBE
19	DRERZ	☐	JHDRERZ	DRERZ	CHAR	8	0	IS-M: Publication	JDTDRER
20	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
21	IHKOMP	☐	IKO_PREIS	INHALTSKOM	CHAR	8	0	IS-M: Content component for pricing call	JJTIKO
22	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
23	INHK_TECH2	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	JJTIKO
24	AZAFOV	☐	AZART_AREA	AZART_AREA	CHAR	4	0	IS-M/AM: Fixed Format Proposal /Ad Dimensions	TJJ13
25	AZAFO	☐	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	TJJ17
26	AZAFA	☐	AZART_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Ad Type	TJJ11
27	AZAGST	☐	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	TJJ19
28	TERMINSPEZ	☐	TERMINSPEZ	TERMINSPEZ	CHAR	6	0	IS-M/AM: Specify Dates for Date Combinations
29	VAVTYP	☐	VAVARTYP	VAVARTYP	CHAR	2	0	Issue Variant Type	TJD05
30	CHIFFRE	☐	CHIFFRE_KZ	CHIFFRE_KZ	CHAR	1	0	IS-M: Box Number Indicator	TJH59
31	ABSRB	☐	AB_RABATT	RABATT	DEC	5	2	IS-M: Current Valid Contract Discount Rate
32	ABSBO	☐	AKTBONUS	RABATT	DEC	5	2	IS-M/AM: Current Valid Contract Bonus
33	ABSFMPR	☐	AB_PREIS	WERTV8	CURR	15	2	IS-M: Current Valid Price from Contract
34	GO_PREIS	☐	GO_PREIS	GO_PREIS	CHAR	1	0	IS-M: Basic/Local Price
35	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JJVDB_MK_FK
36	STICHW	☐	STICHW	TEXT40	CHAR	40	0	IS-M: Keyword
37	DIENSTL	☐	MATNR_DIEN	MATNR_DIEN	CHAR	18	0	IS-M: Service material number	JJTDIEN
38	DITYP	☐	DIENTYP	DIENTYP	CHAR	4	0	IS-M: Service Type	TJH71
39	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
40	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
41	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
42	FSART	☐	ISP_FSART	ISP_FSART	CHAR	1	0	IS-M/AM: Billing Method
43	KTGRM	☐	KTGRM	KTGRM	CHAR	2	0	Account assignment group for this material	TVKM
44	KTGRB	☐	KTGRB	KTGRB	CHAR	2	0	IS-M: Booking Unit Account Assignment Group	TJJ39
45	PRSFD	☐	PRSFD	PRSFD	CHAR	1	0	Carry out pricing
46	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
47	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
48	SHKZG	☐	JHSHKZG	JHSHKZG	CHAR	1	0	IS-M: Debit/Credit indicator
49	SMENG	☐	SMENG	MENG13	QUAN	13	3	Scale quantity in base unit of measure
50	FKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
51	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
52	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
53	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
54	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
55	VGBEL	☐	JHVGBEL	JHVGBEL	CHAR	10	0	IS-M: Document Number of Template Document
56	VGPOS	☐	JHVGPOS	JHVGPOS	NUMC	6	0	IS-M: Item Number of the Template Business Item
57	VGETE	☐	GRABR_VG	GRUPPABR	NUMC	3	0	IS-M: Group/Settlement Number of Template Document
58	VGTYP	☐	ISPVBTYP_V	ISPVBTYP	CHAR	1	0	IS-M: Preceding Sales Document Category
59	VGOBJ	☐	JHOBJAR_V	JHOBJKT	CHAR	2	0	IS-M: Preceding object type	TJH97
60	VGFKTYP	☐	JHVGFKTYP	JHFKTYP	CHAR	1	0	IS-M: Billing Category for Preceding Billing Document	TJH19
61	VBELV	☐	ISMVBELV	ISMVBELV	CHAR	10	0	IS-M: Originating sales document
62	POSNV	☐	ISMPOSNV	ISMPOSNR	NUMC	6	0	IS-M: Originating item
63	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
64	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
65	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
66	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
67	POSAR	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
68	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
69	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
70	TAXM1	☐	TAXM1	TAXKM	CHAR	1	0	Tax classification material
71	TAXM2	☐	TAXM2	TAXKM	CHAR	1	0	Tax classification material
72	TAXM3	☐	TAXM3	TAXKM	CHAR	1	0	Tax classification material
73	TAXM4	☐	TAXM4	TAXKM	CHAR	1	0	Tax Classification 4 Material
74	TAXM5	☐	TAXM5	TAXKM	CHAR	1	0	Tax classification 5 for material
75	TAXM6	☐	TAXM6	TAXKM	CHAR	1	0	Tax classification 6 for material
76	TAXM7	☐	TAXM7	TAXKM	CHAR	1	0	Tax classification 7 for material
77	TAXM8	☐	TAXM8	TAXKM	CHAR	1	0	Tax Classification 8 Material
78	TAXM9	☐	TAXM9	TAXKM	CHAR	1	0	Tax Classification 9 Material
79	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
80	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
81	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
82	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
83	RK_AUFNR	☐	J_RK_AUFNR	J_RK_AUFNR	CHAR	8	0	Order Number of RK Order for Account Assignment
84	RK_POSNR	☐	J_RK_POSNR	J_RK_POSNR	NUMC	2	0	Item Number of RK Order for Account Assignment
85	KOSTL_R2	☐	KOSTL_R2	KOSTL_R2	CHAR	8	0	Cost center in R/2
86	STGRB	☐	BEGRP_STAT	BEGRP_STAT	CHAR	4	0	IS-M: BU Grouping for Statistics	TJJ67
87	SKTOF	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
88	RRREL	☐	ISMRR_RELTYP	ISMRR_RELTYP	CHAR	1	0	IS-M/AM: Revenue Recognition Category
89	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
90	KUNAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
91	ELAND	☐	LLAND	LAND1	CHAR	3	0	Destination Country	T005
92	POSPA	☐	POSPA	POSNR	NUMC	6	0	Item number in the partner segment
93	PLTYP_AUFT	☐	PLTYP_AUFT	PLTYP	CHAR	2	0	Price list type of sales order
94	MPROK	☐	MPROK	MPROK	CHAR	1	0	Status manual price change
95	KOWRR	☐	KOWRR	KOWRR	CHAR	1	0	Statistical values
96	BONBA	☐	BONBA	WERTV7	CURR	13	2	Rebate basis 1
97	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
98	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
99	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
100	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
101	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
102	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
103	WAVWR	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
104	SKFBP	☐	SKFBP	WERTV7	CURR	13	2	Amount eligible for cash discount in document currency
105	BRTWP	☐	JHBRTWRP	WERTV8	CURR	15	2	IS-M: Gross Value in Document Currency (Item)
106	NETWP	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
107	MWSBP	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
108	CMPRE_FLT	☐	CMPRE_FLT	FLTP	FLTP	16	16	Item credit price
109	UVPRS	☐	ISM_UVPRS	XFELD	CHAR	1	0	Incomplete with Regard to Pricing
110	UVALL	☐	JHUVALL	XFELD	CHAR	1	0	IS-M: Generally incomplete
111	XERLV	☐	JHXERLV	JHXERLV	CHAR	1	0	IS-M: Revenue Distribution Status
112	XPEAB	☐	JHXPEAB	XFELD	CHAR	1	0	IS-M: Period end accrual performed indicator
113	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
114	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
115	STCUR	☐	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
116	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
117	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
118	KOUPD	☐	KOUPD	XFELD	CHAR	1	0	Condition update
119	XCNCL	☐	JH_XCNCL	XFELD	CHAR	1	0	IS-M/AM: Reversal Indicator for Billing Item
120	BEDNR	☐	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	JJTVB
121	PROVTYP	☐	PROVTYP	PROVTYP	CHAR	1	0	IS-M/AM: Commission Category
122	VZUONR	☐	JH_VZUONR	JH_VZUONR	NUMC	2	0	IS-M/AM: Sales Agent Assignment Number (Corrections)
123	BERART	☐	JBERART	BERART	CHAR	1	0	IS-M/AM: Calculation Type for Media Sales Agent Commission
124	PBSCHL	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
125	SCBAS	☐	JHSCBAS	JHSCBAS	CHAR	1	0	IS-M/AM: Scale Base Value for Commission Key
126	VERMART	☐	JVERMART	JVERMART	CHAR	2	0	IS-M: Media Sales Agent Type: General/City/Special Agent	TJJ09
127	PR_BETRAG	☐	VPROZP	DEC4_3	DEC	7	3	IS-M: Sales Agent Share of Commission (in %)
128	PBBASIS	☐	JPBBASIS	WERTV7	CURR	13	2	IS-M/AM: Commission/Bonus Basis Amount (Percentage Calc.)
129	ISPBEDART	☐	VMBEDART	JVMBEDART	CHAR	2	0	IS-M/AM: Requirement Type in Media Sales Agent Contract
130	ALAND	☐	ALAND	LAND1	CHAR	3	0	Departure country (country from which the goods are sent)	T005
131	XSTEIG	☐	XJSTEIG	XFELD	CHAR	1	0	IS-M: Can be Incremented Indicator
132	VKORG_AUFT	☐	JHVKORGAUF	VKORG	CHAR	4	0	IS-M: Sales Organization for Customer Order	TVKO
133	EPROZ	☐	ISPPROZERL	ISPPROZERL	DEC	8	5	IS-M: Percentage rate from rev.distributed billing item
134	NETWPV	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
135	KTGRP	☐	JPVAKNTGRP	KTGRM	CHAR	2	0	Account assignment grouping for edition	TVKM
136	FP_STAFO	☐	JHSTAFO	STAFO	CHAR	6	0	IS-M: Update group for statistics update	TMCB
137	FP_ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
138	FP_ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
139	FP_ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
140	FP_AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
141	FP_AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
142	FP_AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
143	FP_TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction
144	FP_ZUONR	☐	JHZUONR	ZUONR	CHAR	18	0	IS-M: Assignment number in FI document

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVFPALL	ALAND	T005	LAND1
2	JHVFPALL	AUBEL	JHAK	AVM_NR	REF	1	CN
3	JHVFPALL	AUETE	JHAE	EIN_NR		1	CN
4	JHVFPALL	AUFNR	AUFK	AUFNR	KEY	1	CN
5	JHVFPALL	AUGRP	JHAGA	GRUPPABRNR	REF	1	CN
6	JHVFPALL	AUPOS	JHAP	POS_NR	REF	1	CN
7	JHVFPALL	AVMAUART	TJHAK	AUART	REF	1	CN
8	JHVFPALL	AZAFA	TJJ11	AZART_FARB	REF	1	CN
9	JHVFPALL	AZAFO	TJJ17	AZART_FORM	REF	1	CN
10	JHVFPALL	AZAFOV	TJJ13	AZART_AREA	REF	1	CN
11	JHVFPALL	AZAGST	TJJ19	AZART_GEST	REF	1	CN
12	JHVFPALL	BEDNR	JJTVB	BEDNR	REF	1	CN
13	JHVFPALL	BEINH	JJTBE	BELEINH	REF	1	CN
14	JHVFPALL	BEINH_BAS	JJTBE	BELEINH	REF	1	CN
15	JHVFPALL	CHIFFRE	TJH59	CHIFFRE_KZ	REF	1	CN
16	JHVFPALL	DIENSTL	JJTDIEN	MATNR	REF	1	CN
17	JHVFPALL	DITYP	TJH71	DIENTYP	REF	1	CN
18	JHVFPALL	DRERZ	JDTDRER	DRERZ	REF	1	CN
19	JHVFPALL	ELAND	T005	LAND1
20	JHVFPALL	FP_STAFO	TMCB	STAFO	REF	1	CN
21	JHVFPALL	GEWEI	T006	MSEHI	REF	1	CN
22	JHVFPALL	GSBER	TGSB	GSBER	REF	1	CN
23	JHVFPALL	IHKOMP	JJTIKO	INHALTSKOM	REF	1	CN
24	JHVFPALL	INHK_KFM	JJTIKO	INHALTSKOM	REF	1	CN
25	JHVFPALL	INHK_TECH2	JJTIKO	INHALTSKOM	REF	1	CN
26	JHVFPALL	INSERENT	JJVDB_MK_FK	GPNR	REF	1	CN
27	JHVFPALL	KALSM	T683	KALSM	REF	1	CN
28	JHVFPALL	KAPPL	T681A	KAPPL	REF	1	CN
29	JHVFPALL	KDGRP	T151	KDGRP	REF	1	CN
30	JHVFPALL	KOKRS	TKA01	KOKRS	REF	1	CN
31	JHVFPALL	KONDA	T188	KONDA	REF	1	CN
32	JHVFPALL	KOSTL	CSKS	KOSTL	REF	1	CN
33	JHVFPALL	KTGRB	TJJ39	KTGRB	REF	1	CN
34	JHVFPALL	KTGRM	TVKM	KTGRM	REF	1	CN
35	JHVFPALL	KTGRP	TVKM	KTGRM	REF	1	CN
36	JHVFPALL	KUNAG	JGTGPNR	GPNR
37	JHVFPALL	MANDT	T000	MANDT	KEY	1	CN
38	JHVFPALL	MATNR	MARA	MATNR	REF	1	CN
39	JHVFPALL	MEINS	T006	MSEHI	REF	1	CN
40	JHVFPALL	PBSCHL	TJH23	PRSCHL	REF	C	CN
41	JHVFPALL	POSAR	TJH17	AVMPOS_ART	REF	1	CN
42	JHVFPALL	PRCTR	CEPC	PRCTR	REF	1	CN
43	JHVFPALL	PRODH	JJT179	PRODH	REF	1	CN
44	JHVFPALL	PSTYV	TJHAP	PSTYV	REF	1	CN
45	JHVFPALL	PVA	JDTPVA	PVA	REF	1	CN
46	JHVFPALL	SPART	TSPA	SPART	REF	1	CN
47	JHVFPALL	STGRB	TJJ67	BEGRP_STAT	REF	1	CN
48	JHVFPALL	VAVTYP	TJD05	VAVARTYP	REF	1	CN
49	JHVFPALL	VBELN	JHTFK	VBELN	KEY	1	CN
50	JHVFPALL	VERMART	TJJ09	JVERMART	REF	C	CN
51	JHVFPALL	VGFKTYP	TJH19	FKTYP
52	JHVFPALL	VGOBJ	TJH97	OBJKT	REF
53	JHVFPALL	VKBUR	TVBUR	VKBUR	REF	1	CN
54	JHVFPALL	VKGRP	TVKGR	VKGRP	REF	1	CN
55	JHVFPALL	VKORG_AUFT	TVKO	VKORG	REF	1	CN
56	JHVFPALL	VRKME	T006	MSEHI	REF	1	CN
57	JHVFPALL	VTWEG	TVTW	VTWEG	REF	1	CN
58	JHVFPALL	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in