JHTFP SAP (IS-M/AM: Billing/Settlement Documents - Item) Table details
Dictionary Type: Table
Description: IS-M/AM: Billing/Settlement Documents - Item
Description: IS-M/AM: Billing/Settlement Documents - Item
Table field list including key, data, relationships and ABAP select examples
JHTFP is a standard SAP Table which is used to store IS-M/AM: Billing/Settlement Documents - Item data and is available within R/3 SAP systems depending on the version and release level.
The JHTFP table consists of various fields, each holding specific information or linking keys about IS-M/AM: Billing/Settlement Documents - Item data available in SAP. These include VBELN (IS-M/AM: Billing Document), POSNR (IS-M/AM: Item (number) in settlement document), VTWEG (Distribution Channel), SPART (Division).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP JHTFP table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VBELN | IS-M/AM: Billing Document | JJBELNR | CHAR | 10 | JHTFK | ALPHA | JJBELNR | JHB | MJHF |
POSNR | IS-M/AM: Item (number) in settlement document | JJPOSNR | NUMC | 6 | JJPOSNR | ||||
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
KDGRP | Customer group | KDGRP | CHAR | 2 | T151 | KDGRP | VKD | ||
KONDA | Price group (customer) | KONDA | CHAR | 2 | T188 | KONDA | VKA | ||
KAPPL | Application | KAPPL | CHAR | 2 | T681A | KAPPL | KAP | ||
KALSM | Sales and Distribution: Pricing Procedure in Pricing | KALSMASD | CHAR | 6 | T683 | KALSM | |||
ARKTX | IS-M: Short Text for Document Item (Billing Doc.,Settlement) | ISM_ARKTX | CHAR | 40 | TEXT40 | ||||
AUBEL | IS-M/AM: Sales Document Number | AVM_NR | CHAR | 10 | JHAK | ALPHA | AVM_NR | JHA | MJHA |
AUPOS | IS-M: Order Item Number | POS_NR | NUMC | 3 | JHAP | AVM_PNR | |||
AUGRP | IS-M/AM: Billing Dataset | GRUPPABRNR | NUMC | 3 | JHAGA | GRUPPABR | |||
AUETE | IS-M: Schedule Line | EIN_NR | NUMC | 6 | JHAE | AVMENR | |||
AVMAUART | IS-M: Sales Document Type | AUART_PAM | CHAR | 4 | TJHAK | AUART_PAM | JHR | MJHAUART_PAM | |
AUREF | Sales document was created from reference | AUREF | CHAR | 1 | XFELD | ||||
BEINH | IS-M/AM: Booking Unit | BELEGEINH | CHAR | 10 | JJTBE | ALPHA | BELEINH | JBE | MJJ1 |
BEINH_BAS | IS-M: Basic Booking Unit | BE_BASIS | CHAR | 10 | JJTBE | ALPHA | BELEINH | JBE | |
DRERZ | IS-M: Publication | JHDRERZ | CHAR | 8 | JDTDRER | ALPHA | DRERZ | JD1 | |
PVA | Edition | PVA | CHAR | 8 | JDTPVA | ALPHA | PVA | JD2 | |
IHKOMP | IS-M: Content component for pricing call | IKO_PREIS | CHAR | 8 | JJTIKO | ALPHA | INHALTSKOM | ||
INHK_KFM | IS-M: Business Content Component | INHK_KFM | CHAR | 8 | JJTIKO | ALPHA | INHALTSKOM | JJ1 | |
INHK_TECH2 | IS-M: Special Publication Content Component | INHK_SOVER | CHAR | 8 | JJTIKO | ALPHA | INHALTSKOM | JJ1 | |
AZAFOV | IS-M/AM: Fixed Format Proposal /Ad Dimensions | AZART_AREA | CHAR | 4 | TJJ13 | ALPHA | AZART_AREA | MJHAZART_AREA | |
AZAFO | IS-M: Shape Ad Type | AZART_FORM | CHAR | 4 | TJJ17 | ALPHA | AZART_FORM | ||
AZAFA | IS-M: Color Scheme Ad Type | AZART_FARB | CHAR | 4 | TJJ11 | ALPHA | AZART_FARB | JHF | |
AZAGST | IS-M: Design Ad Type | AZART_GEST | CHAR | 4 | TJJ19 | ALPHA | AZART_GEST | JH4 | |
TERMINSPEZ | IS-M/AM: Specify Dates for Date Combinations | TERMINSPEZ | CHAR | 6 | Assigned to domain | ALPHA | TERMINSPEZ | ||
VAVTYP | Issue Variant Type | VAVARTYP | CHAR | 2 | TJD05 | VAVARTYP | |||
CHIFFRE | IS-M: Box Number Indicator | CHIFFRE_KZ | CHAR | 1 | TJH59 | CHIFFRE_KZ | |||
ABSRB | IS-M: Current Valid Contract Discount Rate | AB_RABATT | DEC | 5(2) | RABATT | ||||
ABSBO | IS-M/AM: Current Valid Contract Bonus | AKTBONUS | DEC | 5(2) | RABATT | ||||
ABSFMPR | IS-M: Current Valid Price from Contract | AB_PREIS | CURR | 15(2) | WERTV8 | ||||
GO_PREIS | IS-M: Basic/Local Price | GO_PREIS | CHAR | 1 | GO_PREIS | ||||
INSERENT | IS-M: Advertiser | INSERENT | CHAR | 10 | JJVDB_MK_FK | ALPHA | GPNR | JGP | MJG0M |
STICHW | IS-M: Keyword | STICHW | CHAR | 40 | TEXT40 | ||||
DIENSTL | IS-M: Service material number | MATNR_DIEN | CHAR | 18 | JJTDIEN | ALPHA | MATNR_DIEN | JJD | |
DITYP | IS-M: Service Type | DIENTYP | CHAR | 4 | TJH71 | DIENTYP | |||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | EAN11 | EAN11 | EAN | ||
FBUDA | Date on which services rendered | FBUDA | DATS | 8 | DATUM | ||||
FSART | IS-M/AM: Billing Method | ISP_FSART | CHAR | 1 | ISP_FSART | ||||
KTGRM | Account assignment group for this material | KTGRM | CHAR | 2 | TVKM | KTGRM | |||
KTGRB | IS-M: Booking Unit Account Assignment Group | KTGRB | CHAR | 2 | TJJ39 | KTGRB | |||
PRSFD | Carry out pricing | PRSFD | CHAR | 1 | PRSFD | ||||
KURSK | Exchange Rate for Price Determination | KURSK | DEC | 9(5) | EXCRT | KURRF | |||
PRSDT | Date for pricing and exchange rate | PRSDT | DATS | 8 | DATUM | ||||
SHKZG | IS-M: Debit/Credit indicator | JHSHKZG | CHAR | 1 | JHSHKZG | ||||
SMENG | Scale quantity in base unit of measure | SMENG | QUAN | 13(3) | MENG13 | ||||
FKIMG | Actual Invoiced Quantity | FKIMG | QUAN | 13(3) | MENG13 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
BRGEW | Gross Weight | BRGEW | QUAN | 13(3) | MENG13 | ||||
NTGEW | Net Weight | NTGEW | QUAN | 13(3) | MENG13 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
VGBEL | IS-M: Document Number of Template Document | JHVGBEL | CHAR | 10 | Assigned to domain | ALPHA | JHVGBEL | ||
VGPOS | IS-M: Item Number of the Template Business Item | JHVGPOS | NUMC | 6 | JHVGPOS | ||||
VGETE | IS-M: Group/Settlement Number of Template Document | GRABR_VG | NUMC | 3 | Assigned to domain | GRUPPABR | |||
VGTYP | IS-M: Preceding Sales Document Category | ISPVBTYP_V | CHAR | 1 | ISPVBTYP | ||||
VGOBJ | IS-M: Preceding object type | JHOBJAR_V | CHAR | 2 | TJH97 | JHOBJKT | |||
VGFKTYP | IS-M: Billing Category for Preceding Billing Document | JHVGFKTYP | CHAR | 1 | TJH19 | JHFKTYP | |||
VBELV | IS-M: Originating sales document | ISMVBELV | CHAR | 10 | ALPHA | ISMVBELV | |||
POSNV | IS-M: Originating item | ISMPOSNV | NUMC | 6 | ISMPOSNR | ||||
VKBUR | Sales Office | VKBUR | CHAR | 4 | TVBUR | VKBUR | VKB | ||
VKGRP | Sales Group | VKGRP | CHAR | 3 | TVKGR | VKGRP | VKG | ||
VRKME | Sales unit | VRKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
POSAR | IS-M: Order-Publishing-Media - Item Type | AVMPOS_ART | CHAR | 2 | TJH17 | AVMPOS_ART | |||
PRODH | IS-M/AM: Product Hierarchy | J_PRODH | CHAR | 18 | JJT179 | J_PRODH | |||
PSTYV | IS-M: Item Category for Sales Document | PSTYV_PAM | CHAR | 4 | TJHAP | PSTYV_PAM | |||
TAXM1 | Tax classification material | TAXM1 | CHAR | 1 | Assigned to domain | TAXKM | |||
TAXM2 | Tax classification 2 for material | TAXM2 | CHAR | 1 | Assigned to domain | TAXKM | |||
TAXM3 | Tax classification 3 for material | TAXM3 | CHAR | 1 | Assigned to domain | TAXKM | |||
TAXM4 | Tax Classification 4 Material | TAXM4 | CHAR | 1 | Assigned to domain | TAXKM | |||
TAXM5 | Tax classification 5 for material | TAXM5 | CHAR | 1 | Assigned to domain | TAXKM | |||
TAXM6 | Tax classification 6 for material | TAXM6 | CHAR | 1 | Assigned to domain | TAXKM | |||
TAXM7 | Tax classification 7 for material | TAXM7 | CHAR | 1 | Assigned to domain | TAXKM | |||
TAXM8 | Tax Classification 8 Material | TAXM8 | CHAR | 1 | Assigned to domain | TAXKM | |||
TAXM9 | Tax Classification 9 Material | TAXM9 | CHAR | 1 | Assigned to domain | TAXKM | |||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
RK_AUFNR | Order Number of RK Order for Account Assignment | J_RK_AUFNR | CHAR | 8 | ALPHA | J_RK_AUFNR | |||
RK_POSNR | Item Number of RK Order for Account Assignment | J_RK_POSNR | NUMC | 2 | ALPHA | J_RK_POSNR | |||
KOSTL_R2 | Cost center in R/2 | KOSTL_R2 | CHAR | 8 | ALPHA | KOSTL_R2 | |||
STGRB | IS-M: BU Grouping for Statistics | BEGRP_STAT | CHAR | 4 | TJJ67 | BEGRP_STAT | |||
STAFO | IS-M: Update group for statistics update | JHSTAFO | CHAR | 6 | TMCB | ALPHA | STAFO | MCF | |
SKTOF | Cash discount indicator | SKTOF | CHAR | 1 | XFELD | ||||
RRREL | IS-M/AM: Revenue Recognition Category | ISMRR_RELTYP | CHAR | 1 | ISMRR_RELTYP | ||||
RRSTA | Not Used | 0 | |||||||
CAMPAIGN | IS-M: Marketing Campaign | ISM_MARKETING_CAMPAIGN | RAW | 16 | MCAMP | ISM_MARKETING_CAMPAIGN | PRPM_CGPL_K | ||
PACKAGE_ID | Package | ISM_PACKAGE_ID | CHAR | 10 | JJTPC | ALPHA | ISM_PACKAGE_ID | ||
PK_REF_AVM_NR | Order Number for Package Reference Order | ISM_PK_REF_AVM_NR | CHAR | 10 | Assigned to domain | ALPHA | AVM_NR | ||
PK_REF_POS_NR | Item Number of Package Item to be Referenced | ISM_PK_REF_POS_NR | NUMC | 3 | Assigned to domain | AVM_PNR | |||
ERFUSER | Created By | ERFUSER | CHAR | 12 | USNAM | ||||
ERFDATE | Created On | ERFDATE | DATS | 8 | DATUM | ||||
ERFTIME | Time Created | ERFTIME | TIMS | 6 | UZEIT | ||||
AENUSER | Last Changed By | AENUSER | CHAR | 12 | USNAM | ||||
AENDATE | Date of Last Change | AENDATE | DATS | 8 | DATUM | ||||
AENTIME | Time of Last Change | AENTIME | TIMS | 6 | UZEIT | ||||
KUNAG | Business Partner: Sold-to Party | GPAG | CHAR | 10 | JGTGPNR | ALPHA | GPNR | ||
ELAND | Country of Destination | LLAND | CHAR | 3 | T005 | LAND1 | VLL | ||
POSPA | Item number in the partner segment | POSPA | NUMC | 6 | Assigned to domain | POSNR | |||
PLTYP_AUFT | Price list type of sales order | PLTYP_AUFT | CHAR | 2 | Assigned to domain | PLTYP | VPL | ||
MPROK | Status manual price change | MPROK | CHAR | 1 | MPROK | ||||
KOWRR | Statistical values | KOWRR | CHAR | 1 | KOWRR | ||||
BONBA | Rebate basis 1 | BONBA | CURR | 13(2) | WERTV7 | ||||
KZWI1 | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13(2) | WERTV7 | ||||
KZWI2 | Subtotal 2 from pricing procedure for condition | KZWI2 | CURR | 13(2) | WERTV7 | ||||
KZWI3 | Subtotal 3 from pricing procedure for condition | KZWI3 | CURR | 13(2) | WERTV7 | ||||
KZWI4 | Subtotal 4 from pricing procedure for condition | KZWI4 | CURR | 13(2) | WERTV7 | ||||
KZWI5 | Subtotal 5 from pricing procedure for condition | KZWI5 | CURR | 13(2) | WERTV7 | ||||
KZWI6 | Subtotal 6 from pricing procedure for condition | KZWI6 | CURR | 13(2) | WERTV7 | ||||
WAVWR | Cost in document currency | WAVWR | CURR | 13(2) | WERTV7 | ||||
SKFBP | Amount eligible for cash discount in document currency | SKFBP | CURR | 13(2) | WERTV7 | ||||
BRTWP | IS-M: Gross Value in Document Currency (Item) | JHBRTWRP | CURR | 15(2) | WERTV8 | ||||
NETWP | Net value of the billing item in document currency | NETWR_FP | CURR | 15(2) | WERTV8 | ||||
MWSBP | Tax amount in document currency | MWSBP | CURR | 13(2) | WERTV7 | ||||
CMPRE | Field is no longer used | 0 | |||||||
CMPRE_FLT | Item credit price | CMPRE_FLT | FLTP | 16(16) | FLTP | ||||
UVPRS | Incomplete with Regard to Pricing | ISM_UVPRS | CHAR | 1 | XFELD | ||||
UVALL | IS-M: Generally incomplete | JHUVALL | CHAR | 1 | XFELD | ||||
XERLV | IS-M: Revenue Distribution Status | JHXERLV | CHAR | 1 | JHXERLV | ||||
XPEAB | IS-M: Period end accrual performed indicator | JHXPEAB | CHAR | 1 | XFELD | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | UMVKZ | DEC | 5 | UMBSZ | ||||
UMVKN | Denominator (Divisor) for Conversion of Sales Qty into SKU | UMVKN | DEC | 5 | UMBSN | ||||
STCUR | Exchange rate for statistics (Exch.rate at time of creation) | STCUR_AP | DEC | 9(5) | KURRF | ||||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
ZUONR | IS-M: Assignment number in FI document | JHZUONR | CHAR | 18 | ZUONR | ||||
KOUPD | Condition update | KOUPD | CHAR | 1 | XFELD | ||||
XCNCL | IS-M/AM: Reversal Indicator for Billing Item | JH_XCNCL | CHAR | 1 | XFELD | ||||
BEDNR | IS-M: Number of Media Sales Agent Contract Requirement | VM_BEDNR | NUMC | 6 | JJTVB | VM_BEDNR | |||
PROVTYP | IS-M/AM: Commission Category | PROVTYP | CHAR | 1 | PROVTYP | ||||
VZUONR | IS-M/AM: Sales Agent Assignment Number (Corrections) | JH_VZUONR | NUMC | 2 | Assigned to domain | JH_VZUONR | |||
BERART | IS-M/AM: Calculation Type for Media Sales Agent Commission | JBERART | CHAR | 1 | ALPHA | BERART | |||
PBSCHL | IS-M/AM: Commission Key for Media Sales Agent | JPROVSCHL | CHAR | 5 | TJH23 | PRSCHL | |||
SCBAS | IS-M/AM: Scale Base Value for Commission Key | JHSCBAS | CHAR | 1 | JHSCBAS | ||||
VERMART | IS-M: Media Sales Agent Type: General/City/Special Agent | JVERMART | CHAR | 2 | TJJ09 | JVERMART | |||
PR_BETRAG | IS-M: Sales Agent Share of Commission (in %) | VPROZP | DEC | 7(3) | DEC4_3 | ||||
PBBASIS | IS-M/AM: Commission/Bonus Basis Amount (Percentage Calc.) | JPBBASIS | CURR | 13(2) | WERTV7 | ||||
ISPBEDART | IS-M/AM: Requirement Type in Media Sales Agent Contract | VMBEDART | CHAR | 2 | Assigned to domain | ALPHA | JVMBEDART | ||
ALAND | Departure country (country from which the goods are sent) | ALAND | CHAR | 3 | T005 | LAND1 | VAL | ||
XSTEIG | IS-M: Can be Incremented Indicator | XJSTEIG | CHAR | 1 | XFELD | ||||
VKORG_AUFT | IS-M: Sales Organization for Customer Order | JHVKORGAUF | CHAR | 4 | TVKO | VKORG | VKO | ||
EPROZ | IS-M: Percentage rate from rev.distributed billing item | ISPPROZERL | DEC | 8(5) | ISPPROZERL | ||||
NETWPV | Net value of the billing item in document currency | NETWR_FP | CURR | 15(2) | WERTV8 | ||||
KTGRP | Account assignment grouping for edition | JPVAKNTGRP | CHAR | 2 | TVKM | KTGRM |
Key field | Non-key field |
How do I retrieve data from SAP table JHTFP using ABAP code
The following ABAP code Example will allow you to do a basic selection on JHTFP to SELECT all data from the tableDATA: WA_JHTFP TYPE JHTFP.
SELECT SINGLE *
FROM JHTFP
INTO CORRESPONDING FIELDS OF WA_JHTFP
WHERE...
How to access SAP table JHTFP
Within an ECC or HANA version of SAP you can also view further information about JHTFP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects