SAP ABAP Table JKVFKDICHT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JKVFKDICHT	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	AVNR_V	☑	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
3	APNR_V	☑	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
4	AENR_V	☑	JAENR	AENR	NUMC	4	0	Sales Order Schedule Line
5	FKNR_N	☑	ISPVBELN	ISPVBELN	CHAR	10	0	IS-M/SD: Billing Document	JFRK
6	FPNR_N	☑	ISPPOSNR	ISPPOSNR	NUMC	6	0	IS-M: Billing Item	JFRP
7	FKART	☐	JFKART	JFKART	CHAR	4	0	IS-M: Billing/Settlement Type	TJFK
8	ISPJSTORN	☐	JSTORN	JVBELN	CHAR	10	0	IS-M: Reversal Number
9	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
10	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
11	ISPBRTWR	☐	ISPBRTWR	WERTV8	CURR	15	2	IS-M: Gross Value in Document Currency
12	ISPFAKVON	☐	FAKVON	DATUM	DATS	8	0	IS-M: Billing Period From
13	ISPFAKBIS	☐	FAKBIS	DATUM	DATS	8	0	IS-M: Billing Period To
14	ISPSHKZG	☐	SHKZG_VA	XFELD	CHAR	1	0	Returns Item
15	ISPSFAKT	☐	ISPSFAKT	VBELN	CHAR	10	0	IS-M: Number of Billing Document Reversed
16	ISPPRSANTZ	☐	PRSANTZ	ISPWERT8	DEC	8	0	IS-M: Numerator for proportional prices
17	ISPPRSANTN	☐	PRSANTN	ISPWERT8	DEC	8	0	IS-M: Denominator for proportional prices
18	ISPERSDAT	☐	ERSCHDAT	DATUM	DATS	8	0	Publication Date
19	ISPPOART	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	TJAP
20	ISPBRTWR_P	☐	ISPBRTWR	WERTV8	CURR	15	2	IS-M: Gross Value in Document Currency
21	ISPXFKRUEK	☐	XFKRUECK	XFELD	CHAR	1	0	IS-M: Retroactive Billing of Period Already Billed
22	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
23	AEART	☐	ISPAEART	AEART_JSDK	CHAR	1	0	IS-M: Order Change Type
24	ISPXJSIND	☐	XJSIND	XFELD	CHAR	1	0	Repeat Billing After Reversal
25	POSNR_UR	☐	APNR_UR	APNR	NUMC	6	0	Original Item in Publishing Sales Order	JKAP
26	POSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
27	CYCLENR	☐	CYCLENR	CYCLENR	NUMC	3	0	IS-M/SD: Billing Cycle Number
28	FAKNRRUECK	☐	ISPFAKNRRUECK	ISPVBELN	CHAR	10	0	IS-M: Recalculated Billing Document
29	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
30	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
31	DELIVSPLIT	☐	DELIVSPLIT	DELIVSPLIT	CHAR	8	0	IS-M/SD: Alternating Address Element	TJD23
32	RFBSK	☐	JFRFBSK	JFRFBSK	CHAR	1	0	IS-M/SD: Status for transfer to Accounting
33	XPRICEALTER	☐	XPRICEALTERNATION	XFELD	CHAR	1	0	Indicator: Generated Index for Price Change
34	ISPBDPER	☐	BDPER	DATUM	DATS	8	0	IS-M: Basic Date for Billing Frequency
35	FKPERVON	☐	FKPERVON	DATUM	DATS	8	0	IS-M: Initial Date of Full Billing Period
36	FKPERBIS	☐	FKPERBIS	DATUM	DATS	8	0	IS-M: Closing Date of Full Billing Period
37	ISPPRSANZP	☐	PRSANZP	ISPWERT8	DEC	8	0	IS-M: Number of periods in billing period

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JKVFKDICHT	APNR_V	JKAP	POSNR	KEY	1	CN
2	JKVFKDICHT	AVNR_V	JKAK	VBELN	KEY	1	CN
3	JKVFKDICHT	DELIVSPLIT	TJD23	DELIVSPLIT	REF	C	CN
4	JKVFKDICHT	FKART	TJFK	FKART	REF	1	CN
5	JKVFKDICHT	FKNR_N	JFRK	VBELN	KEY	1	CN
6	JKVFKDICHT	FPNR_N	JFRP	POSNR	KEY	1	CN
7	JKVFKDICHT	ISPPOART	TJAP	POART
8	JKVFKDICHT	MANDT	T000	MANDT	KEY	1	CN
9	JKVFKDICHT	POSNR_UR	JKAP	POSNR	REF	1	CN
10	JKVFKDICHT	WAERK	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in