SAP ABAP View JHVFKFPALL (BAPI_ADMGMTBILLDOC_GETLIST - Select by Header and 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 JHVFKFPALL  
Short Description BAPI_ADMGMTBILLDOC_GETLIST - Select by Header and Item    
Root table JHTFK   IS-M/AM: Settlement Documents (Billing, Commission) - Header 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 JHTFK JHTFK
2 JHTFP  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 JHTFK MANDT JL EQ 0 0
2 JHTFP MANDT JR EQ AND 0 0
3 JHTFK VBELN JL EQ 0 0
4 JHTFP VBELN JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 * JHTFK *    
2 MANDT JHTFK MANDT   MANDT Client
3 VBELN JHTFK VBELN   JJBELNR IS-M/AM: Billing Document
4 ERFUSER JHTFK ERFUSER   ERFUSER Created By
5 ERFDATE JHTFK ERFDATE   ERFDATE Created On
6 ERFTIME JHTFK ERFTIME   ERFTIME Time Created
7 AENUSER JHTFK AENUSER   AENUSER Last Changed By
8 AENDATE JHTFK AENDATE   AENDATE Date of Last Change
9 AENTIME JHTFK AENTIME   AENTIME Time of Last Change
10 SFAKN JHTFK SFAKN   JJBELNRSV IS-M: Reversal Reference
11 XEZER JHTFK XEZER   XEZER Indicator: Is there collection authorization ?
12 BANKS JHTFK BANKS   BANKS Bank country key
13 BANKN JHTFK BANKN   BANKN Bank account number
14 BANKL JHTFK BANKL   BANKL Bank number
15 BKONT JHTFK BKONT   BKONT Bank Control Key
16 BVTYP JHTFK BVTYP   BVTYP Partner bank type
17 FKART JHTFK FKART   FKART_PAM IS-M/AM: Billing/Settlement Document Type
18 FKDAT JHTFK FKDAT   JHFKDAT IS-M: Actual Billing/Settlement Date
19 FKTYP JHTFK FKTYP   JHFKTYP IS-M/AM: Billing Category
20 INCO1 JHTFK INCO1   INCO1 Incoterms (part 1)
21 INCO2 JHTFK INCO2   INCO2 Incoterms (part 2)
22 KNUMV JHTFK KNUMV   KNUMV Number of the document condition
23 KURST JHTFK KURST   KURST Exchange Rate Type
24 LAND1 JHTFK LAND1   LLAND Destination Country
25 REGIO JHTFK REGIO   REGIO Region (State, Province, County)
26 VKORG JHTFK VKORG   VKORG Sales Organization
27 TAXK1 JHTFK TAXK1   JTACLGP1 IS-M: Tax classification for business partner
28 TAXK2 JHTFK TAXK2   JTACLGP2 IS-M: Tax classification 2 for business partner
29 TAXK3 JHTFK TAXK3   JTACLGP3 IS-M: Tax classification 3 for business partner
30 TAXK4 JHTFK TAXK4   JTACLGP4 IS-M: Tax classification 4 for business partner
31 TAXK5 JHTFK TAXK5   JTACLGP5 IS-M: Tax classification 5 for business partner
32 TAXK6 JHTFK TAXK6   JTACLGP6 IS-M: Tax classification 6 for business partner
33 TAXK7 JHTFK TAXK7   JTACLGP7 IS-M: Tax classification 7 for business partner
34 TAXK8 JHTFK TAXK8   JTACLGP8 IS-M: Tax classification 8 for business partner
35 TAXK9 JHTFK TAXK9   JTACLGP9 IS-M: Tax classification 9 for business partner
36 UEBAR JHTFK UEBAR   JHUEBART IS-M: Transfer type
37 WAERK JHTFK WAERK   WAERK SD document currency
38 ZTERM JHTFK ZTERM   DZTERM Terms of payment key
39 VALTG JHTFK VALTG   VALTG Additional value days
40 VALDT JHTFK VALDT   VALDT Fixed value date
41 ZLSCH JHTFK ZLSCH   SCHZW_BSEG Payment Method
42 MSCHL JHTFK MSCHL   MSCHL Dunning key
43 MANSP JHTFK MANSP   MANSP Dunning block
44 NATIO JHTFK NATIO   INTER International address version ID
45 ADRNR JHTFK ADRNR   ISM_CPDADDRNUM IS-M: One-Time Customer Address
46 CCINS JHTFK CCINS   CCINS Payment cards: Card type
47 CCNUM JHTFK CCNUM   CCNUM Payment cards: Card number
48 DATBI JHTFK DATBI   DATBI_CC Payment Cards: Valid To
49 CCNAME JHTFK CCNAME   CCNAME Payment Cards: Name of Cardholder
50 CCAUA JHTFK CCAUA   CCAUA Payment cards: Authorization type
51 CCACT JHTFK CCACT   CCACT G/L Account Number for Payment Card Receivables
52 AUDAT_CC JHTFK AUDAT_CC   AUDAT_CC Payment cards: Authorization date
53 AUTIM JHTFK AUTIM   AUTIM Payment cards: Authorization time
54 CCALL JHTFK CCALL   CCALL Payment cards: Status when external system is called?
55 REACT JHTFK REACT   REACT_SD Payment cards: Response to authorization checks
56 AUTWR JHTFK AUTWR   AUTWR Payment cards: Authorized amount
57 CCWAE JHTFK CCWAE   WAERS Currency Key
58 AUNUM JHTFK AUNUM   AUNUM Payment cards: Authorization number
59 AUTRA JHTFK AUTRA   AUTRA Payment cards: Authoriz. reference code of clearing house
60 SETTL JHTFK SETTL   SETTL Payment cards: Settlement carried out
61 CGUID JHTFK CGUID   CARD_GUID GUID of a Payment Card
62 ENCTP JHTFK ENCTP   CCSECA_ENCTYPE Type of Encryption
63 IBAN JHTFK IBAN   IBAN IBAN (International Bank Account Number)
64 MNDID JHTFK MNDID   SEPA_MNDID Unique Referene to Mandate per Payment Recipient
65 STTYP JHTFK STTYP   STORNOTYP IS-M: Reversal Type
66 MRNKZ JHTFK MRNKZ   MRNKZ Manual invoice maintenance
67 EXPKZ JHTFK EXPKZ   EXPKZ Export indicator
68 EXNUM JHTFK EXNUM   EXNUM Number of foreign trade data in MM and SD documents
69 POPER JHTFK POPER   POPER Posting period
70 GJAHR JHTFK GJAHR   GJAHR Fiscal Year
71 MONAT JHTFK MONAT   MONAT Fiscal period
72 XBLNR JHTFK XBLNR   XBLNR1 Reference Document Number
73 ZUONR JHTFK ZUONR   DZUONR Assignment number
74 BELNR JHTFK BELNR   BELNR_D Accounting Document Number
75 UNRFI JHTFK UNRFI   JHUNRFI IS-M: Field is not used
76 KURRF JHTFK KURRF   KURRF Exchange rate for FI postings
77 CPKUR JHTFK CPKUR   CPKUR ID:Exchange rate setting (no new rate determ.in bill.doc.)
78 BRTWK JHTFK BRTWK   JHBRTWRK IS-M: Gross Value in Document Currency (Header)
79 NETWK JHTFK NETWK   NETWR Net Value in Document Currency
80 MWSBK JHTFK MWSBK   MWSBP Tax amount in document currency
81 STWAE JHTFK STWAE   STWAE Statistics currency
82 STAFO JHTFK STAFO   JHSTAFO IS-M: Update group for statistics update
83 RFBSK JHTFK RFBSK   JHRFBSK IS-M/AM: Status for Transfer to Accounting / HR
84 STAFI JHTFK STAFI   ISMSTAFI IS-M: Status of the Financial Accounting Document
85 MABER JHTFK MABER   MABER Dunning Area
86 VBTYP JHTFK VBTYP   ISPVBTYP IS-M/AM: Sales Document Category
87 PERFK JHTFK PERFK   PERFK Invoice dates (calendar identification)
88 BUKRS JHTFK BUKRS   BUKRS Company Code
89 KTGRD JHTFK KTGRD   KTGRD Account assignment group for this customer
90 PLTYP JHTFK PLTYP   PLTYP Price list type
91 KUNRG JHTFK KUNRG   REGULIERER IS-M: Payer
92 KUNRE JHTFK KUNRE   GPNR_RECH IS-M: Business Partner - Bill-To Party
93 STCEG JHTFK STCEG   STCEG VAT Registration Number
94 STCEG_H JHTFK STCEG_H   STCEG_H Origin of sales tax ID number
95 STCEG_L JHTFK STCEG_L   STCEG_L Country of sales tax ID number
96 LANDTX JHTFK LANDTX   LANDTX Tax Departure Country
97 COUNC JHTFK COUNC   COUNC County Code
98 CITYC JHTFK CITYC   CITYC City Code
99 TXJCD JHTFK TXJCD   TXJCD Tax Jurisdiction
100 ZUKRI JHTFK ZUKRI   DZUKRI Combination criteria in the billing document
101 LOGSYS JHTFK LOGSYS   LOGSYS Logical system
102 EKORG JHTFK EKORG   EKORG Purchasing organization
103 KREZE JHTFK KREZE   JHKREZE IS-M: Payee
104 KRERS JHTFK KRERS   JHKRERS IS-M: Invoicing Party
105 VNR JHTFK VNR   JVMVVNR IS-M: Media Sales Agent Contract Number
106 VTYP JHTFK VTYP   JVERMVTYP IS-M: Contract Category for Media Sales Agent Contract
107 KTGRV JHTFK KTGRV   KTGRV IS-M: Account Assignment Group for Sales Agent Contract
108 UEBERLART JHTFK UEBERLART   UEBERLZIEL IS-M: Transfer Destination
109 PERNR JHTFK PERNR   JJPERNR IS-M: Personnel Number
110 VTNR JHTFK VTNR   ABS_VTNR IS-M: Contract Number
111 ABRGNR JHTFK ABRGNR   ABRGNR IS-M/AM: Contract Settlement Number
112 FAB_PROZNT JHTFK FAB_PROZNT   FAB_PROZNT IS-M: Percentage Rate for Receivables Charge-Off
113 SD_VBELN_VF JHTFK SD_VBELN_VF   JHVBELN_VF IS-M: SD Billing Number Referenced
114 * JHTFP *    
115 - JHTFP MANDT   MANDT Client
116 - JHTFP VBELN   JJBELNR IS-M/AM: Billing Document
117 POSNR JHTFP POSNR   JJPOSNR IS-M/AM: Item (number) in settlement document
118 VTWEG JHTFP VTWEG   VTWEG Distribution Channel
119 SPART JHTFP SPART   SPART Division
120 KDGRP JHTFP KDGRP   KDGRP Customer group
121 KONDA JHTFP KONDA   KONDA Price Group (Customer)
122 KAPPL JHTFP KAPPL   KAPPL Application
123 KALSM JHTFP KALSM   KALSMASD Sales and Distribution: Pricing Procedure in Pricing
124 ARKTX JHTFP ARKTX   ISM_ARKTX IS-M: Short Text for Document Item (Billing Doc.,Settlement)
125 AUBEL JHTFP AUBEL   AVM_NR IS-M/AM: Sales Document Number
126 AUPOS JHTFP AUPOS   POS_NR IS-M: Order Item Number
127 AUGRP JHTFP AUGRP   GRUPPABRNR IS-M/AM: Billing Dataset
128 AUETE JHTFP AUETE   EIN_NR IS-M: Schedule Line
129 AVMAUART JHTFP AVMAUART   AUART_PAM IS-M: Sales Document Type
130 AUREF JHTFP AUREF   AUREF Sales document was created from reference
131 BEINH JHTFP BEINH   BELEGEINH IS-M/AM: Booking Unit
132 BEINH_BAS JHTFP BEINH_BAS   BE_BASIS IS-M: Basic Booking Unit
133 DRERZ JHTFP DRERZ   JHDRERZ IS-M: Publication
134 PVA JHTFP PVA   PVA Edition
135 IHKOMP JHTFP IHKOMP   IKO_PREIS IS-M: Content component for pricing call
136 INHK_KFM JHTFP INHK_KFM   INHK_KFM IS-M: Business Content Component
137 INHK_TECH2 JHTFP INHK_TECH2   INHK_SOVER IS-M: Special Publication Content Component
138 AZAFOV JHTFP AZAFOV   AZART_AREA IS-M/AM: Fixed Format Proposal /Ad Dimensions
139 AZAFO JHTFP AZAFO   AZART_FORM IS-M: Shape Ad Type
140 AZAFA JHTFP AZAFA   AZART_FARB IS-M: Color Scheme Ad Type
141 AZAGST JHTFP AZAGST   AZART_GEST IS-M: Design Ad Type
142 TERMINSPEZ JHTFP TERMINSPEZ   TERMINSPEZ IS-M/AM: Specify Dates for Date Combinations
143 VAVTYP JHTFP VAVTYP   VAVARTYP Issue Variant Type
144 CHIFFRE JHTFP CHIFFRE   CHIFFRE_KZ IS-M: Box Number Indicator
145 ABSRB JHTFP ABSRB   AB_RABATT IS-M: Current Valid Contract Discount Rate
146 ABSBO JHTFP ABSBO   AKTBONUS IS-M/AM: Current Valid Contract Bonus
147 ABSFMPR JHTFP ABSFMPR   AB_PREIS IS-M: Current Valid Price from Contract
148 GO_PREIS JHTFP GO_PREIS   GO_PREIS IS-M: Basic/Local Price
149 INSERENT JHTFP INSERENT   INSERENT IS-M: Advertiser
150 STICHW JHTFP STICHW   STICHW IS-M: Keyword
151 DIENSTL JHTFP DIENSTL   MATNR_DIEN IS-M: Service material number
152 DITYP JHTFP DITYP   DIENTYP IS-M: Service Type
153 MATNR JHTFP MATNR   MATNR Material Number
154 EAN11 JHTFP EAN11   EAN11 International Article Number (EAN/UPC)
155 FBUDA JHTFP FBUDA   FBUDA Date When Services Rendered
156 FSART JHTFP FSART   ISP_FSART IS-M/AM: Billing Method
157 KTGRM JHTFP KTGRM   KTGRM Account assignment group for this material
158 KTGRB JHTFP KTGRB   KTGRB IS-M: Booking Unit Account Assignment Group
159 PRSFD JHTFP PRSFD   PRSFD Carry out pricing
160 KURSK JHTFP KURSK   KURSK Exchange Rate for Pricing and Statistics
161 PRSDT JHTFP PRSDT   PRSDT Date for pricing and exchange rate
162 SHKZG JHTFP SHKZG   JHSHKZG IS-M: Debit/Credit indicator
163 SMENG JHTFP SMENG   SMENG Scale quantity in base unit of measure
164 FKIMG JHTFP FKIMG   FKIMG Actual billed quantity
165 MEINS JHTFP MEINS   MEINS Base Unit of Measure
166 BRGEW JHTFP BRGEW   BRGEW Gross weight
167 NTGEW JHTFP NTGEW   NTGEW Net weight
168 GEWEI JHTFP GEWEI   GEWEI Weight Unit
169 VGBEL JHTFP VGBEL   JHVGBEL IS-M: Document Number of Template Document
170 VGPOS JHTFP VGPOS   JHVGPOS IS-M: Item Number of the Template Business Item
171 VGETE JHTFP VGETE   GRABR_VG IS-M: Group/Settlement Number of Template Document
172 VGTYP JHTFP VGTYP   ISPVBTYP_V IS-M: Preceding Sales Document Category
173 VGOBJ JHTFP VGOBJ   JHOBJAR_V IS-M: Preceding object type
174 VGFKTYP JHTFP VGFKTYP   JHVGFKTYP IS-M: Billing Category for Preceding Billing Document
175 VBELV JHTFP VBELV   ISMVBELV IS-M: Originating sales document
176 POSNV JHTFP POSNV   ISMPOSNV IS-M: Originating item
177 VKBUR JHTFP VKBUR   VKBUR Sales office
178 VKGRP JHTFP VKGRP   VKGRP Sales group
179 VRKME JHTFP VRKME   VRKME Sales unit
180 WERKS JHTFP WERKS   WERKS_D Plant
181 POSAR JHTFP POSAR   AVMPOS_ART IS-M: Order-Publishing-Media - Item Type
182 PRODH JHTFP PRODH   J_PRODH IS-M/AM: Product Hierarchy
183 PSTYV JHTFP PSTYV   PSTYV_PAM IS-M: Item Category for Sales Document
184 TAXM1 JHTFP TAXM1   TAXM1 Tax classification material
185 TAXM2 JHTFP TAXM2   TAXM2 Tax classification material
186 TAXM3 JHTFP TAXM3   TAXM3 Tax classification material
187 TAXM4 JHTFP TAXM4   TAXM4 Tax Classification 4 Material
188 TAXM5 JHTFP TAXM5   TAXM5 Tax classification 5 for material
189 TAXM6 JHTFP TAXM6   TAXM6 Tax classification 6 for material
190 TAXM7 JHTFP TAXM7   TAXM7 Tax classification 7 for material
191 TAXM8 JHTFP TAXM8   TAXM8 Tax Classification 8 Material
192 TAXM9 JHTFP TAXM9   TAXM9 Tax Classification 9 Material
193 GSBER JHTFP GSBER   GSBER Business Area
194 AUFNR JHTFP AUFNR   AUFNR Order Number
195 KOSTL JHTFP KOSTL   KOSTL Cost Center
196 PRCTR JHTFP PRCTR   PRCTR Profit Center
197 RK_AUFNR JHTFP RK_AUFNR   J_RK_AUFNR Order Number of RK Order for Account Assignment
198 RK_POSNR JHTFP RK_POSNR   J_RK_POSNR Item Number of RK Order for Account Assignment
199 KOSTL_R2 JHTFP KOSTL_R2   KOSTL_R2 Cost center in R/2
200 STGRB JHTFP STGRB   BEGRP_STAT IS-M: BU Grouping for Statistics
201 SKTOF JHTFP SKTOF   SKTOF Cash discount indicator
202 RRREL JHTFP RRREL   ISMRR_RELTYP IS-M/AM: Revenue Recognition Category
203 - JHTFP RRSTA    
204 CAMPAIGN JHTFP CAMPAIGN   ISM_MARKETING_CAMPAIGN IS-M: Marketing Campaign
205 KUNAG JHTFP KUNAG   GPAG Business Partner: Sold-to Party
206 ELAND JHTFP ELAND   LLAND Destination Country
207 POSPA JHTFP POSPA   POSPA Item number in the partner segment
208 PLTYP_AUFT JHTFP PLTYP_AUFT   PLTYP_AUFT Price list type of sales order
209 MPROK JHTFP MPROK   MPROK Status manual price change
210 KOWRR JHTFP KOWRR   KOWRR Statistical values
211 BONBA JHTFP BONBA   BONBA Rebate basis 1
212 KZWI1 JHTFP KZWI1   KZWI1 Subtotal 1 from pricing procedure for condition
213 KZWI2 JHTFP KZWI2   KZWI2 Subtotal 2 from pricing procedure for condition
214 KZWI3 JHTFP KZWI3   KZWI3 Subtotal 3 from pricing procedure for condition
215 KZWI4 JHTFP KZWI4   KZWI4 Subtotal 4 from pricing procedure for condition
216 KZWI5 JHTFP KZWI5   KZWI5 Subtotal 5 from pricing procedure for condition
217 KZWI6 JHTFP KZWI6   KZWI6 Subtotal 6 from pricing procedure for condition
218 WAVWR JHTFP WAVWR   WAVWR Cost in document currency
219 SKFBP JHTFP SKFBP   SKFBP Amount eligible for cash discount in document currency
220 BRTWP JHTFP BRTWP   JHBRTWRP IS-M: Gross Value in Document Currency (Item)
221 NETWP JHTFP NETWP   NETWR_FP Net value of the billing item in document currency
222 MWSBP JHTFP MWSBP   MWSBP Tax amount in document currency
223 - JHTFP CMPRE    
224 CMPRE_FLT JHTFP CMPRE_FLT   CMPRE_FLT Item credit price
225 UVPRS JHTFP UVPRS   ISM_UVPRS Incomplete with Regard to Pricing
226 UVALL JHTFP UVALL   JHUVALL IS-M: Generally incomplete
227 XERLV JHTFP XERLV   JHXERLV IS-M: Revenue Distribution Status
228 XPEAB JHTFP XPEAB   JHXPEAB IS-M: Period end accrual performed indicator
229 UMVKZ JHTFP UMVKZ   UMVKZ Numerator (factor) for conversion of sales quantity into SKU
230 UMVKN JHTFP UMVKN   UMVKN Denominator (divisor) for conversion of sales qty. into SKU
231 STCUR JHTFP STCUR   STCUR_AP Exchange rate for statistics (Exch.rate at time of creation)
232 PAOBJNR JHTFP PAOBJNR   RKEOBJNR Profitability Segment Number (CO-PA)
233 KOKRS JHTFP KOKRS   KOKRS Controlling Area
234 KOUPD JHTFP KOUPD   KOUPD Condition update
235 XCNCL JHTFP XCNCL   JH_XCNCL IS-M/AM: Reversal Indicator for Billing Item
236 BEDNR JHTFP BEDNR   VM_BEDNR IS-M: Number of Media Sales Agent Contract Requirement
237 PROVTYP JHTFP PROVTYP   PROVTYP IS-M/AM: Commission Category
238 VZUONR JHTFP VZUONR   JH_VZUONR IS-M/AM: Sales Agent Assignment Number (Corrections)
239 BERART JHTFP BERART   JBERART IS-M/AM: Calculation Type for Media Sales Agent Commission
240 PBSCHL JHTFP PBSCHL   JPROVSCHL IS-M/AM: Commission Key for Media Sales Agent
241 SCBAS JHTFP SCBAS   JHSCBAS IS-M/AM: Scale Base Value for Commission Key
242 VERMART JHTFP VERMART   JVERMART IS-M: Media Sales Agent Type: General/City/Special Agent
243 PR_BETRAG JHTFP PR_BETRAG   VPROZP IS-M: Sales Agent Share of Commission (in %)
244 PBBASIS JHTFP PBBASIS   JPBBASIS IS-M/AM: Commission/Bonus Basis Amount (Percentage Calc.)
245 ISPBEDART JHTFP ISPBEDART   VMBEDART IS-M/AM: Requirement Type in Media Sales Agent Contract
246 ALAND JHTFP ALAND   ALAND Departure country (country from which the goods are sent)
247 XSTEIG JHTFP XSTEIG   XJSTEIG IS-M: Can be Incremented Indicator
248 VKORG_AUFT JHTFP VKORG_AUFT   JHVKORGAUF IS-M: Sales Organization for Customer Order
249 EPROZ JHTFP EPROZ   ISPPROZERL IS-M: Percentage rate from rev.distributed billing item
250 NETWPV JHTFP NETWPV   NETWR_FP Net value of the billing item in document currency
251 KTGRP JHTFP KTGRP   JPVAKNTGRP Account assignment grouping for edition
252 FP_STAFO JHTFP STAFO   JHSTAFO IS-M: Update group for statistics update
253 FP_ERFUSER JHTFP ERFUSER   ERFUSER Created By
254 FP_ERFDATE JHTFP ERFDATE   ERFDATE Created On
255 FP_ERFTIME JHTFP ERFTIME   ERFTIME Time Created
256 FP_AENUSER JHTFP AENUSER   AENUSER Last Changed By
257 FP_AENDATE JHTFP AENDATE   AENDATE Date of Last Change
258 FP_AENTIME JHTFP AENTIME   AENTIME Time of Last Change
259 FP_TXJCD JHTFP TXJCD   TXJCD Tax Jurisdiction
260 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  20130529 
SAP Release Created in 464