1. Home
  2. Resources
  3. SAP Tables
  4. JFRK - IS-M/SD: Billing - Header Data

SAP Table JFRK

IS-M/SD: Billing - Header Data

JFRK (IS-M/SD: Billing - Header 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 JFRK to other SAP tables.

Source: JFRK (IS-M/SD: Billing - Header Data)

JFRK table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VBELN IS-M/SD: Billing Document ISPVBELN CHAR 10 0
FKART IS-M: Billing/Settlement Type JFKART TJFK CHAR 4 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
WAERK SD Document Currency WAERK TCURC CUKY 5 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
KALSM Sales and Distribution: Pricing Procedure in Pricing KALSMASD T683 CHAR 6 0
KNUMV Number of the document condition KNUMV CHAR 10 0
FKDAT Billing date for billing index and printout FKDAT DATS 8 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
POPER Posting period POPER NUMC 3 0
KONDA Price group (customer) KONDA T188 CHAR 2 0
KDGRP Customer group KDGRP T151 CHAR 2 0
PLTYP Price list type PLTYP T189 CHAR 2 0
RFBSK IS-M/SD: Status for transfer to Accounting JFRFBSK CHAR 1 0
A Billing Document Blocked for Forwarding to FI
B Posting Document not Created (Account Determ.Error)
C Posting Document has been Created
D Billing Document is not Relevant for Accounting
E Billing Document Completed by Reversal
F Posting Document not Created (Pricing Error)
G Posting Document not Created (Export Data Missing)
H Posting Using Invoice List
I Posting Using Invoice List (Account Determination Error)
J Accounting Document Created, Accrual Still Incomplete
NULL Billing Document not yet Transferred to Accounting
KURRF Exchange rate for FI postings KURRF DEC 9 5
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ZLSCH Payment Method SCHZW_BSEG T042Z CHAR 1 0
KTGRD Account assignment group for this customer KTGRD TVKT CHAR 2 0
LAND1 Country of Destination LLAND T005 CHAR 3 0
REGIO Region (State, Province, County) REGIO T005S CHAR 3 0
COUNC County Code COUNC T005E CHAR 3 0
CITYC City Code CITYC T005G CHAR 4 0
BUKRS Company Code BUKRS T001 CHAR 4 0
TAXK1 Tax classification 1 for customer TAXK1 CHAR 1 0
TAXK2 Tax classification 2 for customer TAXK2 CHAR 1 0
TAXK3 Tax classification 3 for customer TAXK3 CHAR 1 0
TAXK4 Tax Classification 4 Customer TAXK4 CHAR 1 0
TAXK5 Tax classification 5 for customer TAXK5 CHAR 1 0
TAXK6 Tax classification 6 for customer TAXK6 CHAR 1 0
TAXK7 Tax classification 7 for customer TAXK7 CHAR 1 0
TAXK8 Tax classification 8 for customer TAXK8 CHAR 1 0
TAXK9 Tax classification 9 for customer TAXK9 CHAR 1 0
NETWR Net Value in Document Currency NETWR CURR 15 2
ZUKRI Combination criteria in the billing document DZUKRI CHAR 40 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERZET Entry time ERZET TIMS 6 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
STAFO Update group for statistics update STAFO CHAR 6 0
KUNRG Payer KUNRG KNA1 CHAR 10 0
KUNAG Sold-to party KUNAG KNA1 CHAR 10 0
MABER Dunning Area MABER T047M CHAR 2 0
STWAE Statistics currency STWAE TCURC CUKY 5 0
STCEG VAT Registration Number STCEG CHAR 20 0
AEDAT Changed On AEDAT DATS 8 0
KURST Exchange Rate Type KURST TCURV CHAR 4 0
SPART Division SPART TSPA CHAR 2 0
STCEG_H Origin of sales tax ID number STCEG_H CHAR 1 0
A Ship-to party
B Payer
C Sold-to party
D Payer (KNAS segment)
E Manually entered or changed
F Entered manually in order
G Own VAT reg. no. in dest. country
H Payer for tax receiving country from order
I Sold-to party for tax receiving country from order
J Sold to party (segment KNAS)
STCEG_L Tax Destination Country LAND1TX CHAR 3 0
MWSBK Tax amount in document currency MWSBP CURR 13 2
SAMMG IS-M: Group Number ISPSAMMG JFSK CHAR 10 0
ISPOBJART IS-M: Object type for document flow LABART CHAR 4 0
SZUS Reverse employee home delivery settlement
SZUV Reversal of SC Home Delivery Settlement
ZUST Employee home delivery settlement
ZUVS SC home deliv.settlement
PROV Commission settlement for commission recipient
PRVS SC commission settlement
SPRO Reverse commission settlement for commission recipient
SPRV Reverse commission calculation for SC
ISPBANKS Bank country key BANKS CHAR 3 0
ISPBANKL Bank number BANKL CHAR 15 0
ISPBANKN Bank account number BANKN CHAR 18 0
ISPBVTYP Partner Bank Type BVTYP CHAR 4 0
ISPXEZER Indicator: Is there collection authorization ? XEZER CHAR 1 0
X Yes
NULL No
ISPBKONT Bank Control Key BKONT CHAR 2 0
ISPJAVNR IS-M: Merge criterion for order JAVNR CHAR 10 0
ISPJAPNR IS-M: Merge criterion for sales order item JAPNR NUMC 6 0
ISPZLSCH Payment Method DZLSCH CHAR 1 0
ISPSFAKT IS-M: Number of Billing Document Reversed ISPSFAKT CHAR 10 0
ISPJSTORN IS-M: Reversal Number JSTORN CHAR 10 0
ISPJSNFAK IS-M: Number of Reversal in Subsequent Document ISPSNFAK CHAR 10 0
ISPBRTWR IS-M: Gross Value in Document Currency ISPBRTWR CURR 15 2
ISPSFKOPF Separate billing document for sales order XSEPFKKOPF CHAR 1 0
X Yes
NULL No
ISPJUEBART IS-M: Transfer Type JUEBART CHAR 1 0
1 Individual Transfer
2 Collective Transfer
3 Payment Card Transfer
5 POR Collective Transfer
6 Collection Transfer
7 Bank Returns - Customer Posting
8 SC Collection Transfer
9 Bank Returns - G/L Account Posting
H Transfer to Human Resources
ISPXDRUCK IS-M: Print Invoice XRECHDRUCK CHAR 1 0
X Yes
NULL No
ISPANZFPOS IS-M: Number of billing items in billing document JANZFPOS NUMC 4 0
ISPSHKZGK Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
ISPBUPER Fiscal Period MONAT NUMC 2 0
ISPUMSKZ Special G/L Indicator UMSKZ T074U CHAR 1 0
ISPSTOGRD IS-M: Billing Document Reversal Reason JSTOGRDF TJF27 CHAR 3 0
ISPXJSIND Repeat Billing After Reversal XJSIND CHAR 1 0
X Yes
NULL No
ISPUKONT G/L Account to be Posted to (Bank Subaccount) UKONT_042I CHAR 10 0
ISPUEBDAT IS-M: Accrual Date ISPUEBDAT DATS 8 0
ISPUEBNR IS-M: Number of Transfer Run to FI ISPUEBNR CHAR 10 0
ISPXINK IS-M: Payment by field collector XKINKASSO CHAR 1 0
X Yes
NULL No
ISPXUINK IS-M: Collection billing doc.transferred to company code XJUINK CHAR 1 0
ISPXWBZABO IS-M: WBZ subscription XWBZABO CHAR 1 0
X Yes
NULL No
ISPINKVSG IS-M: Field Collector is Service Company ISPINKVSG CHAR 10 0
ISPINKGP IS-M: Field Collector is Employee ISPINKGP CHAR 10 0
ISPXVDICHT IS-M: Summarize deliveries according to billing item XFKVDICHT CHAR 1 0
X Yes
NULL No
ISPJUEBARH IS-M: Transfer type at time of billing JUEBARTFKH CHAR 1 0
1 Individual Transfer
2 Collective Transfer
3 Payment Card Transfer
5 POR Collective Transfer
6 Collection Transfer
7 Bank Returns - Customer Posting
8 SC Collection Transfer
9 Bank Returns - G/L Account Posting
H Transfer to Human Resources
ISPXNOMESS IS-M: Indicator - Do Not Perform Output Determination XNOMESS CHAR 1 0
X Yes
NULL No
MNDID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35 0
IBAN IBAN (International Bank Account Number) IBAN CHAR 34 0
XRENEWAL IS-M/SD: Order extended by renewal offer XRENEWAL CHAR 1 0
X Yes
NULL No
AMORTN IS-M/SD: Use of Liability Account in Order AMORTN CHAR 1 0
NULL No liability account
A Manage liability account in money
B Manage liability account in deliveries
C Manage liability account in money w/o ref.to performance
XINVAUTHOR IS-M/SD: Billing document authorized XINVAUTHOR CHAR 1 0
X Yes
NULL No
AWREF Reference Document Number AWREF CHAR 10 0
XTRANSFER IS-M/SD: Transfer billing document XTRANSFER_INV CHAR 1 0
X Yes
NULL No
JAVCYCLENR IS-M: Merge Criterion for Order Billing Cycle JAVCYCLENR NUMC 3 0
VKONT Contract Account Number VKONT_KK CHAR 12 0
XPAYMODE_FIX IS-M/SD: Payment Arrangement in Order Fixed XPAYMODE_FIX CHAR 1 0
X Yes
NULL No
BELNR_FKK Number of Contract Accts Rec. & Payable Doc. OPBEL_KK CHAR 12 0
NRZAS Payment Form Number NRZAS_KK CHAR 12 0

JFRK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JFRK BUKRS JFRK MANDT T001 Company Codes MANDT
JFRK BUKRS JFRK BUKRS T001 Company Codes BUKRS
JFRK CITYC JFRK MANDT T005G City MANDT
JFRK CITYC JFRK LAND1 T005G City LAND1
JFRK CITYC JFRK REGIO T005G City REGIO
JFRK CITYC JFRK CITYC T005G City CITYC
JFRK COUNC JFRK COUNC T005E County COUNC
JFRK COUNC JFRK REGIO T005E County REGIO
JFRK COUNC JFRK LAND1 T005E County LAND1
JFRK COUNC JFRK MANDT T005E County MANDT
JFRK FKART JFRK MANDT TJFK IS-M/SD: Billing Document Types MANDT
JFRK FKART JFRK FKART TJFK IS-M/SD: Billing Document Types FKART
JFRK ISPSTOGRD JFRK ISPSTOGRD TJF27 IS-M/SD: Billing Document Reversal Reasons STOGRD
JFRK ISPSTOGRD VBRK MANDT TJF27 IS-M/SD: Billing Document Reversal Reasons MANDT
JFRK ISPUMSKZ VBRK MANDT T074U Special G/L Indicator Properties MANDT
JFRK ISPUMSKZ 'D' T074U Special G/L Indicator Properties KOART
JFRK ISPUMSKZ JFRK ISPUMSKZ T074U Special G/L Indicator Properties UMSKZ
JFRK KALSM JFRK KALSM T683 Pricing procedures KALSM
JFRK KALSM T681Z KAPPL T683 Pricing procedures KAPPL
JFRK KALSM T681Z KUEWE T683 Pricing procedures KVEWE
JFRK KALSM JFRK MANDT T683 Pricing procedures MANDT
JFRK KDGRP JFRK KDGRP T151 Customers: Customer Groups KDGRP
JFRK KDGRP JFRK MANDT T151 Customers: Customer Groups MANDT
JFRK KONDA JFRK KONDA T188 Conditions: Groups for Customer Classifications KONDA
JFRK KONDA JFRK MANDT T188 Conditions: Groups for Customer Classifications MANDT
JFRK KTGRD JFRK MANDT TVKT Customers: Account Assignment Groups MANDT
JFRK KTGRD JFRK KTGRD TVKT Customers: Account Assignment Groups KTGRD
JFRK KUNAG JFRK KUNAG KNA1 General Data in Customer Master KUNNR
JFRK KUNAG JFRK MANDT KNA1 General Data in Customer Master MANDT
JFRK KUNRG JFRK MANDT KNA1 General Data in Customer Master MANDT
JFRK KUNRG JFRK KUNRG KNA1 General Data in Customer Master KUNNR
JFRK KURST JFRK KURST TCURV Exchange rate types for currency translation KURST
JFRK KURST JFRK MANDT TCURV Exchange rate types for currency translation MANDT
JFRK LAND1 JFRK LAND1 T005 Countries LAND1
JFRK LAND1 JFRK MANDT T005 Countries MANDT
JFRK MABER JFRK MANDT T047M Dunning areas MANDT
JFRK MABER JFRK BUKRS T047M Dunning areas BUKRS
JFRK MABER JFRK MABER T047M Dunning areas MABER
JFRK MANDT JFRK MANDT T000 Clients MANDT
JFRK PLTYP JFRK MANDT T189 Conditions: Price List Categories MANDT
JFRK PLTYP JFRK PLTYP T189 Conditions: Price List Categories PLTYP
JFRK REGIO JFRK REGIO T005S Taxes: Region (Province) Key BLAND
JFRK REGIO JFRK LAND1 T005S Taxes: Region (Province) Key LAND1
JFRK REGIO JFRK MANDT T005S Taxes: Region (Province) Key MANDT
JFRK SAMMG JFRK MANDT JFSK IS-M/SD: Sales Document - Collective Processing for Header MANDT
JFRK SAMMG JFRK SAMMG JFSK IS-M/SD: Sales Document - Collective Processing for Header SAMMG
JFRK SPART JFRK SPART TSPA Organizational Unit: Sales Divisions SPART
JFRK SPART JFRK MANDT TSPA Organizational Unit: Sales Divisions MANDT
JFRK STWAE JFRK STWAE TCURC Currency Codes WAERS
JFRK STWAE JFRK MANDT TCURC Currency Codes MANDT
JFRK VKORG JFRK VKORG TVKO Organizational Unit: Sales Organizations VKORG
JFRK VKORG JFRK MANDT TVKO Organizational Unit: Sales Organizations MANDT
JFRK VTWEG JFRK VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
JFRK VTWEG JFRK MANDT TVTW Organizational Unit: Distribution Channels MANDT
JFRK WAERK JFRK WAERK TCURC Currency Codes WAERS
JFRK WAERK JFRK MANDT TCURC Currency Codes MANDT
JFRK ZLSCH JFRK MANDT T042Z Payment Methods for Automatic Payment MANDT
JFRK ZLSCH JFRK LAND1 T042Z Payment Methods for Automatic Payment LAND1
JFRK ZLSCH JFRK ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH