SAP ABAP Table JFRKVB (Reference Structure for XJFRK/YJFRP)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	INTTAB	Structure
Structure	JFRKVB	Table Relationship Diagram
Short Description	Reference Structure for XJFRK/YJFRP

Delivery and Maintenance

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JFRKVB	BUKRS	T001	BUKRS	REF	1	CN
2	JFRKVB	CITYC	T005G	CITYC	REF	C	CN
3	JFRKVB	COUNC	T005E	COUNC	REF	C	CN
4	JFRKVB	FKART	TJFK	FKART	REF	1	CN
5	JFRKVB	ISPSTOGRD	TJF27	STOGRD
6	JFRKVB	ISPUMSKZ	T074U	UMSKZ
7	JFRKVB	KALSM	T683	KALSM	REF	1	CN
8	JFRKVB	KDGRP	T151	KDGRP	REF	C	CN
9	JFRKVB	KONDA	T188	KONDA	REF	C	CN
10	JFRKVB	KTGRD	TVKT	KTGRD	REF	C	CN
11	JFRKVB	KUNAG	KNA1	KUNNR	REF	1	CN
12	JFRKVB	KUNRG	KNA1	KUNNR	REF	1	CN
13	JFRKVB	KURST	TCURV	KURST	REF	C	CN
14	JFRKVB	LAND1	T005	LAND1	REF	C	CN
15	JFRKVB	MABER	T047M	MABER	REF	C	CN
16	JFRKVB	MANDT	T000	MANDT	KEY	1	CN
17	JFRKVB	PLTYP	T189	PLTYP	REF	C	CN
18	JFRKVB	REGIO	T005S	BLAND	REF	C	CN
19	JFRKVB	SAMMG	JFSK	SAMMG	REF	1	CN
20	JFRKVB	SPART	TSPA	SPART	REF	C	CN
21	JFRKVB	STWAE	TCURC	WAERS	REF	C	CN
22	JFRKVB	VKORG	TVKO	VKORG	REF	C	CN
23	JFRKVB	VTWEG	TVTW	VTWEG	REF	C	CN
24	JFRKVB	WAERK	TCURC	WAERS	REF	1	CN
25	JFRKVB	ZLSCH	T042Z	ZLSCH	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in