SAP ABAP Table JFRK (IS-M/SD: Billing - Header Data)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M (Application Component) SAP Media
⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System
⤷ IS-M (Application Component) SAP Media
⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | JFRK | Table Relationship Diagram |
Short Description | IS-M/SD: Billing - Header Data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | VBELN | ISPVBELN | ISPVBELN | CHAR | 10 | 0 | IS-M/SD: Billing Document | ||
3 | FKART | JFKART | JFKART | CHAR | 4 | 0 | IS-M: Billing/Settlement Type | TJFK | |
4 | VBTYP | VBTYP | VBTYP | CHAR | 1 | 0 | SD document category | ||
5 | WAERK | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | TCURC | |
6 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
7 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
8 | KALSM | KALSMASD | KALSM | CHAR | 6 | 0 | Sales and Distribution: Pricing Procedure in Pricing | T683 | |
9 | KNUMV | KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
10 | FKDAT | FKDAT | DATUM | DATS | 8 | 0 | Billing date for billing index and printout | ||
11 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
12 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
13 | POPER | POPER | POPER | NUMC | 3 | 0 | Posting period | ||
14 | KONDA | KONDA | KONDA | CHAR | 2 | 0 | Price Group (Customer) | T188 | |
15 | KDGRP | KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | T151 | |
16 | PLTYP | PLTYP | PLTYP | CHAR | 2 | 0 | Price list type | T189 | |
17 | RFBSK | JFRFBSK | JFRFBSK | CHAR | 1 | 0 | IS-M/SD: Status for transfer to Accounting | ||
18 | KURRF | KURRF | KURRF | DEC | 9 | 5 | Exchange rate for FI postings | ||
19 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
20 | ZLSCH | SCHZW_BSEG | ZLSCH | CHAR | 1 | 0 | Payment Method | T042Z | |
21 | KTGRD | KTGRD | KTGRD | CHAR | 2 | 0 | Account assignment group for this customer | TVKT | |
22 | LAND1 | LLAND | LAND1 | CHAR | 3 | 0 | Destination Country | T005 | |
23 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
24 | COUNC | COUNC | COUNC | CHAR | 3 | 0 | County Code | T005E | |
25 | CITYC | CITYC | CITYC | CHAR | 4 | 0 | City Code | T005G | |
26 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
27 | TAXK1 | TAXK1 | TAXKD | CHAR | 1 | 0 | Tax classification 1 for customer | * | |
28 | TAXK2 | TAXK2 | TAXKD | CHAR | 1 | 0 | Tax classification 2 for customer | * | |
29 | TAXK3 | TAXK3 | TAXKD | CHAR | 1 | 0 | Tax classification 3 for customer | * | |
30 | TAXK4 | TAXK4 | TAXKD | CHAR | 1 | 0 | Tax classification 4 for customer | * | |
31 | TAXK5 | TAXK5 | TAXKD | CHAR | 1 | 0 | Tax classification 5 for customer | * | |
32 | TAXK6 | TAXK6 | TAXKD | CHAR | 1 | 0 | Tax classification 6 for customer | * | |
33 | TAXK7 | TAXK7 | TAXKD | CHAR | 1 | 0 | Tax classification 7 for customer | * | |
34 | TAXK8 | TAXK8 | TAXKD | CHAR | 1 | 0 | Tax classification 8 for customer | * | |
35 | TAXK9 | TAXK9 | TAXKD | CHAR | 1 | 0 | Tax classification 9 for customer | * | |
36 | NETWR | NETWR | WERTV8 | CURR | 15 | 2 | Net Value in Document Currency | ||
37 | ZUKRI | DZUKRI | CHAR40 | CHAR | 40 | 0 | Combination criteria in the billing document | ||
38 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
39 | ERZET | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
40 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
41 | STAFO | STAFO | STAFO | CHAR | 6 | 0 | Update group for statistics update | * | |
42 | KUNRG | KUNRG | KUNNR | CHAR | 10 | 0 | Payer | KNA1 | |
43 | KUNAG | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | KNA1 | |
44 | MABER | MABER | MABER | CHAR | 2 | 0 | Dunning Area | T047M | |
45 | STWAE | STWAE | WAERS | CUKY | 5 | 0 | Statistics currency | TCURC | |
46 | STCEG | STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
47 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
48 | KURST | KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | TCURV | |
49 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | TSPA | |
50 | STCEG_H | STCEG_H | STCEG_H | CHAR | 1 | 0 | Origin of sales tax ID number | ||
51 | STCEG_L | LAND1TX | LAND1 | CHAR | 3 | 0 | Tax Destination Country | * | |
52 | MWSBK | MWSBP | WERTV7 | CURR | 13 | 2 | Tax amount in document currency | ||
53 | SAMMG | ISPSAMMG | ISPSAMMG | CHAR | 10 | 0 | IS-M: Group Number | JFSK | |
54 | .INCLUDE | 0 | 0 | IS-PSD: Billing Document Header Data | |||||
55 | ISPOBJART | LABART | JOBJART | CHAR | 4 | 0 | IS-M: Object type for document flow | ||
56 | ISPBANKS | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
57 | ISPBANKL | BANKL | BANKL | CHAR | 15 | 0 | Bank number | ||
58 | ISPBANKN | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
59 | ISPBVTYP | BVTYP | BVTYP | CHAR | 4 | 0 | Partner bank type | ||
60 | ISPXEZER | XEZER | XFELD | CHAR | 1 | 0 | Indicator: Is there collection authorization ? | ||
61 | ISPBKONT | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
62 | ISPJAVNR | JAVNR | AVNR | CHAR | 10 | 0 | IS-M: Merge criterion for order | * | |
63 | ISPJAPNR | JAPNR | APNR | NUMC | 6 | 0 | IS-M: Merge criterion for sales order item | * | |
64 | ISPZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | * | |
65 | ISPSFAKT | ISPSFAKT | VBELN | CHAR | 10 | 0 | IS-M: Number of Billing Document Reversed | * | |
66 | ISPJSTORN | JSTORN | JVBELN | CHAR | 10 | 0 | IS-M: Reversal Number | * | |
67 | ISPJSNFAK | ISPSNFAK | JVBELN | CHAR | 10 | 0 | IS-M: Number of Reversal in Subsequent Document | * | |
68 | ISPBRTWR | ISPBRTWR | WERTV8 | CURR | 15 | 2 | IS-M: Gross Value in Document Currency | ||
69 | ISPSFKOPF | XSEPFKKOPF | XFELD | CHAR | 1 | 0 | Separate billing document for sales order | ||
70 | ISPJUEBART | JUEBART | JUEBART | CHAR | 1 | 0 | IS-M: Transfer Type | ||
71 | ISPXDRUCK | XRECHDRUCK | XFELD | CHAR | 1 | 0 | IS-M: Print Invoice | ||
72 | ISPANZFPOS | JANZFPOS | JANZFPOS | NUMC | 4 | 0 | IS-M: Number of billing items in billing document | ||
73 | ISPSHKZGK | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
74 | ISPBUPER | MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
75 | ISPUMSKZ | UMSKZ | UMSKZ | CHAR | 1 | 0 | Special G/L Indicator | T074U | |
76 | ISPSTOGRD | JSTOGRDF | JSTOGRDF | CHAR | 3 | 0 | IS-M: Billing Document Reversal Reason | TJF27 | |
77 | ISPXJSIND | XJSIND | XFELD | CHAR | 1 | 0 | Repeat Billing After Reversal | ||
78 | ISPUKONT | UKONT_042I | SAKNR | CHAR | 10 | 0 | G/L Account to be Posted to (Bank Subaccount) | * | |
79 | ISPUEBDAT | ISPUEBDAT | ISPUEBDAT | DATS | 8 | 0 | IS-M: Accrual Date | ||
80 | ISPUEBNR | ISPUEBNR | ISPUEBNR | CHAR | 10 | 0 | IS-M: Number of Transfer Run to FI | * | |
81 | ISPXINK | XKINKASSO | XFELD | CHAR | 1 | 0 | IS-M: Payment by field collector | ||
82 | ISPXUINK | XJUINK | CHAR1 | CHAR | 1 | 0 | IS-M: Collection billing doc.transferred to company code | ||
83 | ISPXWBZABO | XWBZABO | XFELD | CHAR | 1 | 0 | IS-M: WBZ subscription | ||
84 | ISPINKVSG | ISPINKVSG | KUNNR | CHAR | 10 | 0 | IS-M: Field Collector is Service Company | * | |
85 | ISPINKGP | ISPINKGP | KUNNR | CHAR | 10 | 0 | IS-M: Field Collector is Employee | * | |
86 | ISPXVDICHT | XFKVDICHT | XFELD | CHAR | 1 | 0 | IS-M: Summarize deliveries according to billing item | ||
87 | ISPJUEBARH | JUEBARTFKH | JUEBART | CHAR | 1 | 0 | IS-M: Transfer type at time of billing | ||
88 | ISPXNOMESS | XNOMESS | XFELD | CHAR | 1 | 0 | IS-M: Indicator - Do Not Perform Output Determination | ||
89 | MNDID | SEPA_MNDID | ID035 | CHAR | 35 | 0 | Unique Referene to Mandate per Payment Recipient | ||
90 | IBAN | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
91 | XRENEWAL | XRENEWAL | XFELD | CHAR | 1 | 0 | IS-M/SD: Order extended by renewal offer | ||
92 | AMORTN | AMORTN | AMORTN | CHAR | 1 | 0 | IS-M/SD: Use of Liability Account in Order | ||
93 | XINVAUTHOR | XINVAUTHOR | XFELD | CHAR | 1 | 0 | IS-M/SD: Billing document authorized | ||
94 | AWREF | AWREF | AWREF | CHAR | 10 | 0 | Reference document number | ||
95 | XTRANSFER | XTRANSFER_INV | XFELD | CHAR | 1 | 0 | IS-M/SD: Transfer billing document | ||
96 | JAVCYCLENR | JAVCYCLENR | CYCLENR | NUMC | 3 | 0 | IS-M: Merge Criterion for Order Billing Cycle | * | |
97 | VKONT | VKONT_KK | VKONT_KK | CHAR | 12 | 0 | Contract Account Number | * | |
98 | XPAYMODE_FIX | XPAYMODE_FIX | XFELD | CHAR | 1 | 0 | IS-M/SD: Payment Arrangement in Order Fixed | ||
99 | BELNR_FKK | OPBEL_KK | OPBEL_KK | CHAR | 12 | 0 | Number of Contract Accts Rec. & Payable Doc. | * | |
100 | NRZAS | NRZAS_KK | NRZAS_KK | CHAR | 12 | 0 | Payment Form Number |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | JFRK | BUKRS | T001 | BUKRS | REF | 1 | CN |
2 | JFRK | CITYC | T005G | CITYC | REF | C | CN |
3 | JFRK | COUNC | T005E | COUNC | REF | C | CN |
4 | JFRK | FKART | TJFK | FKART | REF | 1 | CN |
5 | JFRK | ISPSTOGRD | TJF27 | STOGRD | |||
6 | JFRK | ISPUMSKZ | T074U | UMSKZ | |||
7 | JFRK | KALSM | T683 | KALSM | REF | 1 | CN |
8 | JFRK | KDGRP | T151 | KDGRP | REF | C | CN |
9 | JFRK | KONDA | T188 | KONDA | REF | C | CN |
10 | JFRK | KTGRD | TVKT | KTGRD | REF | C | CN |
11 | JFRK | KUNAG | KNA1 | KUNNR | REF | 1 | CN |
12 | JFRK | KUNRG | KNA1 | KUNNR | REF | 1 | CN |
13 | JFRK | KURST | TCURV | KURST | REF | C | CN |
14 | JFRK | LAND1 | T005 | LAND1 | REF | C | CN |
15 | JFRK | MABER | T047M | MABER | REF | C | CN |
16 | JFRK | MANDT | T000 | MANDT | KEY | 1 | CN |
17 | JFRK | PLTYP | T189 | PLTYP | REF | C | CN |
18 | JFRK | REGIO | T005S | BLAND | REF | C | CN |
19 | JFRK | SAMMG | JFSK | SAMMG | REF | 1 | CN |
20 | JFRK | SPART | TSPA | SPART | REF | C | CN |
21 | JFRK | STWAE | TCURC | WAERS | REF | C | CN |
22 | JFRK | VKORG | TVKO | VKORG | REF | C | CN |
23 | JFRK | VTWEG | TVTW | VTWEG | REF | C | CN |
24 | JFRK | WAERK | TCURC | WAERS | REF | 1 | CN |
25 | JFRK | ZLSCH | T042Z | ZLSCH | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |