SAP Table JFRP

IS-M/SD: Billing Document - Item Data

JFRP (IS-M/SD: Billing Document - Item Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link JFRP to other SAP tables.

Source: JFRP (IS-M/SD: Billing Document - Item Data)

JFRP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VBELN IS-M/SD: Billing Document ISPVBELN JFRK CHAR 10 0
POSNR IS-M: Billing Item ISPPOSNR NUMC 6 0
FKIMG Actual Invoiced Quantity FKIMG QUAN 13 3
VRKME Sales unit VRKME T006 UNIT 3 0
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
GSBER Business Area GSBER TGSB CHAR 4 0
PRSDT Date for pricing and exchange rate PRSDT DATS 8 0
FBUDA Date on which services rendered FBUDA DATS 8 0
KURSK Exchange Rate for Price Determination KURSK DEC 9 5
NETWR Net value of the billing item in document currency NETWR_FP CURR 15 2
MATKL Material Group MATKL T023 CHAR 9 0
SPART Division SPART TSPA CHAR 2 0
POSPA IS-M: Item Number of Partner Segment ISPPOSPA JFRP NUMC 6 0
WERKS Plant WERKS_D T001W CHAR 4 0
ALAND Departure country (country from which the goods are sent) ALAND T005 CHAR 3 0
WKREG Region in which plant is located WKREG T005S CHAR 3 0
WKCOU County in which plant is located WKCOU CHAR 3 0
WKCTY City in which plant is located WKCTY CHAR 4 0
TAXM1 Tax classification material TAXM1 CHAR 1 0
TAXM2 Tax classification 2 for material TAXM2 CHAR 1 0
TAXM3 Tax classification 3 for material TAXM3 CHAR 1 0
TAXM4 Tax Classification 4 Material TAXM4 CHAR 1 0
TAXM5 Tax classification 5 for material TAXM5 CHAR 1 0
TAXM6 Tax classification 6 for material TAXM6 CHAR 1 0
TAXM7 Tax classification 7 for material TAXM7 CHAR 1 0
TAXM8 Tax Classification 8 Material TAXM8 CHAR 1 0
TAXM9 Tax Classification 9 Material TAXM9 CHAR 1 0
SKTOF Cash discount indicator SKTOF CHAR 1 0
X Yes
NULL No
SKFBP Amount eligible for cash discount in document currency SKFBP CURR 13 2
SPARA Division for order header SPART_AK TSPA CHAR 2 0
SHKZG Returns Item SHKZG_VA CHAR 1 0
X Yes
NULL No
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZET Entry time ERZET TIMS 6 0
STAFO Update group for statistics update STAFO CHAR 6 0
WAVWR Cost in document currency WAVWR CURR 13 2
KZWI1 Subtotal 1 from pricing procedure for condition KZWI1 CURR 13 2
KZWI2 Subtotal 2 from pricing procedure for condition KZWI2 CURR 13 2
KZWI3 Subtotal 3 from pricing procedure for condition KZWI3 CURR 13 2
KZWI4 Subtotal 4 from pricing procedure for condition KZWI4 CURR 13 2
KZWI5 Subtotal 5 from pricing procedure for condition KZWI5 CURR 13 2
KZWI6 Subtotal 6 from pricing procedure for condition KZWI6 CURR 13 2
STCUR Exchange rate for statistics (Exch.rate at time of creation) STCUR_AP DEC 9 5
UVPRS Incomplete with respect to pricing UVPRS CHAR 1 0
X Yes
NULL No
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
ISPAUART IS-M/SD: Sales Document Types AUART_ISP TJAK CHAR 4 0
ISPAUAGRP IS-M: Sales Document Type Grouping for Sales Order ISPAUAGRP CHAR 1 0
1 Subscription Order
2 Single Unit Sales Order
3 Reserve Order
4 Free Copy Delivery Order
5 Return Notification
6 Credit/Debit Memo Requirements
7 Charitable Transfer
8 Ad Pre-Print Order
9 Coupon Order
B Voucher Copy Order
C Coupon Confirmation
ISPKOSTL_L IS-M: Cost Center to be Charged ISPKOSTL_L CHAR 10 0
ISPDRERZ Publication DRERZ JDTDRER CHAR 8 0
ISPPVA Edition PVA JDTPVA CHAR 8 0
ISPBEZ Mix Type BEZUGSTYP_JE_PVA JDTBEZTYP CHAR 2 0
ISPLIFART Delivery Type LIEFERART TJV01 CHAR 2 0
ISPDRUCK IS-M: Plant (Printing Works) ISPDRUCK T001W CHAR 4 0
ISPGUTSCH IS-M: Coupon Number ISPGUTSCH NUMC 8 0
ISPXLOGO Print Logo XLOGO CHAR 1 0
X Yes
NULL No
ISPPVAKNTG IS-M: Account Assignment Grouping for Edition ISPPVAKNTG TVKM CHAR 2 0
ISPPVAKONG IS-M: Edition Condition Grouping ISPPVAKONG T178 CHAR 2 0
ISPPVABONG IS-M: Bonus Grouping for Edition ISPPVABONG TVBO CHAR 2 0
ISPFKPER Billing Frequency FKPER TJK01 CHAR 2 0
ISPPERFK Invoice dates (calendar identification) PERFK TFACD CHAR 2 0
ISPZAHLW Billing method JZAHLW CHAR 1 0
0 In advance
1 Subsequent
ISPPOSEX External Item Number (Purchase Order Item) POSEX_ISP NUMC 6 0
ISPJPERIOD IS-M: Periodic settlement JPERIOD CHAR 1 0
X Yes
NULL No
ISPVBELN IS-M/SD: Publishing Sales Order AVNR JKAK CHAR 10 0
ISPPOSNR Sales Order Item APNR JKAP NUMC 6 0
ISPETENR Sales Order Schedule Line JAENR JKEP NUMC 4 0
ISPETEEX IS-M: External Schedule Line Number ETEEX_ISP NUMC 6 0
ISPETART Schedule Line Type for Internal Sales Order Schedule Line ETART_ISP TJEP CHAR 2 0
ISPETMENGE IS-M: Sales Order Schedule Line Quantity ETMENGE QUAN 10 0
ISPETMEINS IS-M: Sales Unit for Sales Order ETMEINS T006 UNIT 3 0
ISPETVOR IS-M: Plus/Minus Sign for Sch. Line Quantity in Sales Order ISPETVOR CHAR 1 0
+ positive
- negative
ISPKPOSN Condition item number KPOSN NUMC 6 0
ISPPRBAS IS-M: Price Basis ISPPRBAS CHAR 1 0
0 Unit price
1 Period price
ISPPRSPER IS-M: Price Frequency ISPPRSPER TJK03 CHAR 2 0
ISPBZPERF IS-M: Service Type for Billing ISPBZPERF TJD09 CHAR 5 0
ISPPRSMLT IS-M: Numerator in Conversion Factor for Frequencies ISPPRSMLT DEC 5 0
ISPPRSDIV IS-M: Denominator for Frequency Conversion Factor ISPPRSDIV DEC 5 0
ISPAEART IS-M: Order Change Type ISPAEART CHAR 1 0
NULL No change
+ additive change
= change
ISPANZET IS-M: Number of Publication Dates ISPANZET DEC 5 0
ISPERSDAT Publication Date ERSCHDAT DATS 8 0
ISPWRBAKT Sales Promotion WERBEAKT TJWAK CHAR 8 0
ISPFAKVON IS-M: Billing Period From FAKVON DATS 8 0
ISPFAKBIS IS-M: Billing Period To FAKBIS DATS 8 0
ISPKONDA Price group (customer) KONDA T188 CHAR 2 0
ISPKDGRP Customer group KDGRP T151 CHAR 2 0
ISPPOART Internal Item Type for Sales Order POART_ISP TJAP CHAR 2 0
ISPPRSANTZ IS-M: Numerator for proportional prices PRSANTZ DEC 8 0
ISPPRSANTN IS-M: Denominator for proportional prices PRSANTN DEC 8 0
ISPPRSANZP IS-M: Number of periods in billing period PRSANZP DEC 8 0
ISPBRTWR_P IS-M: Gross Value in Document Currency ISPBRTWR CURR 15 2
ISPPRBAS_V Price Basis for Shipping Costs PRBAS_VK CHAR 1 0
0 Unit price
1 Period price
ISPLAGRP_V Country grouping for shipping costs LANDGRP_VK TJG92 CHAR 2 0
ISPXFKKOMP Indicator: Perform Billing in Full for Billing Period XFKKOMP CHAR 1 0
X Yes
NULL No
ISPXFKENDE Indicator: Billing at end of calculation XFKENDE CHAR 1 0
X Yes
NULL No
ISPSFPOS Separate billing document for order item XSEPFKPOS CHAR 1 0
X Yes
NULL No
ISPXKOMPP IS-M: Full period (billing) XKOMPP CHAR 1 0
X Yes
NULL No
ISPVERSDAT IS-M: Shipping Date VRSNDDATUM DATS 8 0
ISPLANDE Current country being supplied LANDE_ISP CHAR 3 0
ISPRKAUFNR Order Number of RK Order for Account Assignment J_RK_AUFNR CHAR 8 0
ISPRKPOSNR Item Number of RK Order for Account Assignment J_RK_POSNR NUMC 2 0
ISPCOAUFNR Order number of internal CO order for account assignment J_CO_AUFNR AUFK CHAR 12 0
ISPVAUSGB Issue VAUSGB JDTVAUSGB CHAR 10 0
ISPXFKBALF IS-M: Billing based on delivery XFKBASLIEF CHAR 1 0
X Yes
NULL No
ISPXFKBAAU IS-M: Billing based on order XFKBASAUFT CHAR 1 0
X Yes
NULL No
ISPVKBURZU Sales office responsible VKBURZUS CHAR 4 0
ISPXSTABGR VAT to be accrued proportionally for payment in billing JXMWSTABGR CHAR 1 0
X Yes
NULL No
ISPXIMMAT Indicator: Proof of matriculation provided XIMMATRIK CHAR 1 0
X Yes
NULL No
ISPIMMATD Matriculation Certificate Valid To IMMATDAT DATS 8 0
ISPXFKRUEK IS-M: Retroactive Billing of Period Already Billed XFKRUECK CHAR 1 0
X Yes
NULL No
ISPIVWKN Circulation Audit Report Category ID IVWKN CHAR 8 0
ISPXIVW Indicator: Relevant for audit report XIVW CHAR 1 0
X Yes
NULL No
ISPJKPAVRG Normal Start of Address Validity for Retro.Order Items JKPAVONREG DATS 8 0
ISPJKPABRG End of Address Validity if End of Billing Delayed JKPABISREG DATS 8 0
XNEGOPTION IS-M: Item with Automatic Transformation to Chargeable XNEGOPTION CHAR 1 0
X Yes
NULL No
IVWDATUM Date of Audit Report for Returns IVWDATUM DATS 8 0
CAMPAIGN IS-M: Marketing Campaign ISM_MARKETING_CAMPAIGN RAW 16 0
ISPBDPER IS-M: Basic Date for Billing Frequency BDPER DATS 8 0
FKPERVON IS-M: Initial Date of Full Billing Period FKPERVON DATS 8 0
FKPERBIS IS-M: Closing Date of Full Billing Period FKPERBIS DATS 8 0
ISPZSKLS Time slice classification for sales order JZSKLS CHAR 1 0
N Time slice - normal
U Time slice - unlimited planned change
B Time slice - limited planned change
ISPWRBART Sales Source WERBEART TJWAR CHAR 4 0
POSNR_UR Original Item in Publishing Sales Order APNR_UR NUMC 6 0
CYCLENR IS-M/SD: Billing Cycle Number CYCLENR NUMC 3 0
FAKNRRUECK IS-M: Recalculated Billing Document ISPFAKNRRUECK CHAR 10 0
XFIXED Indicator: Billing Index Fixed and Cannot be Deleted XINDEXFIXED CHAR 1 0
X Yes
NULL No
RCODE IS-M/SD: Rate Code RATE_CODE CHAR 4 0
XAUTO_REN IS-M/SD: Customer Requests Automatic Renewal XAUTO_REN CHAR 1 0
X Yes
NULL No
STBFREI Type of Tax Exemption JSTBFREI TJFSB CHAR 2 0
XNFAK IS-M: Indicator - Repeat Billing After Reversal ISPXNFAK CHAR 1 0
X Yes
NULL No
DELIVSPLIT IS-M/SD: Alternating Address Element DELIVSPLIT TJD23 CHAR 8 0
DELIVSPLITGRP IS-M/SD: Address Alternation Group DELIVSPLITGRP TJD63 CHAR 10 0
POSNR_MAIN IS-M/SD: Main Item in Sales Order APNR_MAIN JKAP NUMC 6 0
POSNR_SUB IS-M/SD: Sub-Item in Sales Order APNR_SUB JKAP NUMC 6 0
X_MONTAG IS-M: Monday X_MONTAG CHAR 1 0
X Yes
NULL No
X_DIENSTAG IS-M: Tuesday X_DIENSTAG CHAR 1 0
X Yes
NULL No
X_MITTWOCH IS-M: Wednesday X_MITTWOCH CHAR 1 0
X Yes
NULL No
X_DONNETAG IS-M: Thursday X_DONNETAG CHAR 1 0
X Yes
NULL No
X_FREITAG IS-M: Friday X_FREITAG CHAR 1 0
X Yes
NULL No
X_SAMSTAG IS-M: Saturday X_SAMSTAG CHAR 1 0
X Yes
NULL No
X_SONNTAG IS-M: Sunday X_SONNTAG CHAR 1 0
X Yes
NULL No
VBELN_FROM IS-M/SD: Publishing Sales Order AVNR CHAR 10 0
POSNR_UR_FROM Sales Order Item APNR NUMC 6 0
CYCLENR_FROM IS-M/SD: Billing Cycle Number CYCLENR NUMC 3 0
XPRICEALTER Indicator: Generated Index for Price Change XPRICEALTERNATION CHAR 1 0
X Yes
NULL No
REFUNDTYPE IS-M/SD: Refund Type REFUNDTYPE TJK19 CHAR 2 0
XAUTO_ACCEPT IS-M/SD: Indicator - Accept Cycle Without Payment XAUTO_ACCEPT CHAR 1 0
X Yes
NULL No
BONUSTYPE IS-M/SD: Bonus Type JBONUSTYPE CHAR 2 0
01 Bonus Day
02 Up-Give

JFRP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JFRP ALAND JFRP MANDT T005 Countries MANDT
JFRP ALAND JFRP ALAND T005 Countries LAND1
JFRP DELIVSPLIT JFRP DELIVSPLIT TJD23 IS-M/SD: Alternating Address Elements DELIVSPLIT
JFRP DELIVSPLIT JFRP MANDT TJD23 IS-M/SD: Alternating Address Elements MANDT
JFRP DELIVSPLITGRP JFRP DELIVSPLITGRP TJD63 IS-M/SD: Address Alternation Groups DELIVSPLITGRP
JFRP DELIVSPLITGRP JFRP MANDT TJD63 IS-M/SD: Address Alternation Groups MANDT
JFRP GSBER JFRP MANDT TGSB Business Areas MANDT
JFRP GSBER JFRP GSBER TGSB Business Areas GSBER
JFRP ISPAUART JFRP ISPAUART TJAK IS-M/SD: Sales Document Type AUART
JFRP ISPAUART * TJAK IS-M/SD: Sales Document Type MANDT
JFRP ISPBEZ * JDTBEZTYP IS-M: Mix Types (per Edition) MANDT
JFRP ISPBEZ JFRP ISPDRERZ JDTBEZTYP IS-M: Mix Types (per Edition) DRERTR
JFRP ISPBEZ JFRP ISPPVA JDTBEZTYP IS-M: Mix Types (per Edition) PVATRA
JFRP ISPBEZ JFRP ISPBEZ JDTBEZTYP IS-M: Mix Types (per Edition) BEZTYP
JFRP ISPBZPERF * TJD09 IS-M/SD: Service Type MANDT
JFRP ISPBZPERF JFRP ISPBZPERF TJD09 IS-M/SD: Service Type BEZPER
JFRP ISPCOAUFNR JFRP ISPCOAUFNR AUFK Order master data AUFNR
JFRP ISPCOAUFNR * AUFK Order master data MANDT
JFRP ISPDRERZ JFRP ISPDRERZ JDTDRER IS-M/SD: Publications DRERZ
JFRP ISPDRERZ * JDTDRER IS-M/SD: Publications MANDT
JFRP ISPDRUCK * T001W Plants/Branches MANDT
JFRP ISPDRUCK JFRP ISPDRUCK T001W Plants/Branches WERKS
JFRP ISPETART JFRP ISPETART TJEP Sales Order: Schedule Line Types ETART
JFRP ISPETART * TJEP Sales Order: Schedule Line Types MANDT
JFRP ISPETENR JFRP ISPPOSNR JKEP Sales Order: Schedule Line Data POSNR
JFRP ISPETENR * JKEP Sales Order: Schedule Line Data MANDT
JFRP ISPETENR JFRP ISPVBELN JKEP Sales Order: Schedule Line Data VBELN
JFRP ISPETENR JFRP ISPETENR JKEP Sales Order: Schedule Line Data ETENR
JFRP ISPETMEINS * T006 Units of Measurement MANDT
JFRP ISPETMEINS JFRP ISPETMEINS T006 Units of Measurement MSEHI
JFRP ISPFKPER JFRP ISPFKPER TJK01 IS-M/SD: Billing Frequency FKPER
JFRP ISPFKPER * TJK01 IS-M/SD: Billing Frequency MANDT
JFRP ISPKDGRP JFRP ISPKDGRP T151 Customers: Customer Groups KDGRP
JFRP ISPKDGRP * T151 Customers: Customer Groups MANDT
JFRP ISPKONDA * T188 Conditions: Groups for Customer Classifications MANDT
JFRP ISPKONDA JFRP ISPKONDA T188 Conditions: Groups for Customer Classifications KONDA
JFRP ISPLAGRP_V * TJG92 IS-M/SD: Country Grouping for Shipping Costs MANDT
JFRP ISPLAGRP_V JFRP ISPLAGRP_V TJG92 IS-M/SD: Country Grouping for Shipping Costs LANDGRP_VK
JFRP ISPLIFART JFRP ISPLIFART TJV01 Delivery type for issue LIEFERART
JFRP ISPLIFART * TJV01 Delivery type for issue MANDT
JFRP ISPPERFK JFRP ISPPERFK TFACD Factory calendar definition IDENT
JFRP ISPPOART * TJAP Sales Order: Item Types MANDT
JFRP ISPPOART JFRP ISPPOART TJAP Sales Order: Item Types POART
JFRP ISPPOSNR * JKAP Sales Order - Item Data MANDT
JFRP ISPPOSNR JFRP ISPVBELN JKAP Sales Order - Item Data VBELN
JFRP ISPPOSNR JFRP ISPPOSNR JKAP Sales Order - Item Data POSNR
JFRP ISPPRSPER JFRP ISPPRSPER TJK03 IS-M/SD: Price Frequency PRSPER
JFRP ISPPRSPER * TJK03 IS-M/SD: Price Frequency MANDT
JFRP ISPPVA JFRP ISPPVA JDTPVA IS-M/SD: Editions PVA
JFRP ISPPVA JFRP ISPDRERZ JDTPVA IS-M/SD: Editions DRERZ
JFRP ISPPVA * JDTPVA IS-M/SD: Editions MANDT
JFRP ISPPVABONG JFRP ISPPVABONG TVBO Sales Rebate Groups BONUS
JFRP ISPPVABONG * TVBO Sales Rebate Groups MANDT
JFRP ISPPVAKNTG JFRP ISPPVAKNTG TVKM Materials: Account Assignment Groups KTGRM
JFRP ISPPVAKNTG * TVKM Materials: Account Assignment Groups MANDT
JFRP ISPPVAKONG JFRP ISPPVAKONG T178 Conditions: Groups for Materials KONDM
JFRP ISPPVAKONG * T178 Conditions: Groups for Materials MANDT
JFRP ISPVAUSGB JFRP ISPVAUSGB JDTVAUSGB IS-M/SD: Issues VAUSGB
JFRP ISPVAUSGB * JDTVAUSGB IS-M/SD: Issues MANDT
JFRP ISPVBELN JFRP ISPVBELN JKAK Sales Order Header Data VBELN
JFRP ISPVBELN * JKAK Sales Order Header Data MANDT
JFRP ISPWRBAKT JFRP ISPWRBAKT TJWAK IS-M/SD: Sales Promotion WERBEAKT
JFRP ISPWRBAKT * TJWAK IS-M/SD: Sales Promotion MANDT
JFRP ISPWRBART JFRP MANDT TJWAR IS-M/SD: Sales Source MANDT
JFRP ISPWRBART JFRP ISPWRBART TJWAR IS-M/SD: Sales Source WERBEART
JFRP MANDT JFRP MANDT T000 Clients MANDT
JFRP MATKL JFRP MANDT T023 Material Groups MANDT
JFRP MATKL JFRP MATKL T023 Material Groups MATKL
JFRP MEINS JFRP MANDT T006 Units of Measurement MANDT
JFRP MEINS JFRP MEINS T006 Units of Measurement MSEHI
JFRP POSNR_MAIN JFRP POSNR_MAIN JKAP Sales Order - Item Data POSNR
JFRP POSNR_MAIN JFRP ISPVBELN JKAP Sales Order - Item Data VBELN
JFRP POSNR_MAIN JFRP MANDT JKAP Sales Order - Item Data MANDT
JFRP POSNR_SUB JFRP ISPVBELN JKAP Sales Order - Item Data VBELN
JFRP POSNR_SUB JFRP POSNR_SUB JKAP Sales Order - Item Data POSNR
JFRP POSNR_SUB JFRP MANDT JKAP Sales Order - Item Data MANDT
JFRP POSPA JFRP POSPA JFRP IS-M/SD: Billing Document - Item Data POSNR
JFRP POSPA JFRP VBELN JFRP IS-M/SD: Billing Document - Item Data VBELN
JFRP POSPA JFRP MANDT JFRP IS-M/SD: Billing Document - Item Data MANDT
JFRP REFUNDTYPE JFRP MANDT TJK19 IS-M/SD: Refund Type MANDT
JFRP REFUNDTYPE JFRP REFUNDTYPE TJK19 IS-M/SD: Refund Type REFUNDTYPE
JFRP SPARA JFRP MANDT TSPA Organizational Unit: Sales Divisions MANDT
JFRP SPARA JFRP SPARA TSPA Organizational Unit: Sales Divisions SPART
JFRP SPART JFRP MANDT TSPA Organizational Unit: Sales Divisions MANDT
JFRP SPART JFRP SPART TSPA Organizational Unit: Sales Divisions SPART
JFRP STBFREI JFRP MANDT TJFSB IS-M/SD: Type of Tax Exemption MANDT
JFRP STBFREI JFRP STBFREI TJFSB IS-M/SD: Type of Tax Exemption STBFREI
JFRP VBELN JFRP VBELN JFRK IS-M/SD: Billing - Header Data VBELN
JFRP VBELN JFRP MANDT JFRK IS-M/SD: Billing - Header Data MANDT
JFRP VRKME JFRP MANDT T006 Units of Measurement MANDT
JFRP VRKME JFRP VRKME T006 Units of Measurement MSEHI
JFRP WERKS JFRP WERKS T001W Plants/Branches WERKS
JFRP WERKS JFRP MANDT T001W Plants/Branches MANDT
JFRP WKREG JFRP MANDT T005S Taxes: Region (Province) Key MANDT
JFRP WKREG JFRP ALAND T005S Taxes: Region (Province) Key LAND1
JFRP WKREG JFRP WKREG T005S Taxes: Region (Province) Key BLAND