SAP ABAP View JHVFPALL (BAPI_ADMGMTBILLDOC_GETLIST - Select by Item)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

View Type	D	Database View
Database View	JHVFPALL
Short Description	BAPI_ADMGMTBILLDOC_GETLIST - Select by Item
Root table	JHTFP	IS-M/AM: Billing/Settlement Documents - Item

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JHTFP	JHTFP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20110901
SAP Release Created in	464