SAP ABAP Table JKVFAKT (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure JKVFAKT   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 VBELN AVNR AVNR CHAR 10   0   IS-M/SD: Publishing Sales Order  
3 POSNR APNR APNR NUMC 6   0   Sales Order Item  
4 ETENR JAENR AENR NUMC 4   0   Sales Order Schedule Line  
5 VBTYP VBTYP_ISP VBTYP_ISP CHAR 1   0   Sales document category, IS-M  
6 AUART AUART_ISP AUART_ISP CHAR 4   0   IS-M/SD: Sales Document Types TJAK
7 AUARTGRP JAUARTGRP JAUARTGRP CHAR 1   0   IS-M/SD: Sales document type grouping  
8 WAERK WAERK WAERS CUKY 5   0   SD document currency TCURC
9 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
10 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVKOV
11 SPART_KO SPART_AK SPART CHAR 2   0   Division for order header TVTA
12 KNUMV KNUMV KNUMV CHAR 10   0   Number of the document condition  
13 FAKSP_KO FAKTSPERRE FAKSP CHAR 2   0   Billing Block TVFS
14 KALSM KALSMASD KALSM CHAR 6   0   Sales and Distribution: Pricing Procedure in Pricing T683
15 KURST_KO KURST KURST CHAR 4   0   Exchange Rate Type TCURV
16 XSEPFKKOPF XSEPFKKOPF XFELD CHAR 1   0   Separate billing document for sales order  
17 GPAG GPAG GPNR CHAR 10   0   Business Partner: Sold-to Party JGTGPNR
18 XFKBASAUFT XFKBASAUFT XFELD CHAR 1   0   IS-M: Billing based on order  
19 XFKBASLIEF XFKBASLIEF XFELD CHAR 1   0   IS-M: Billing based on delivery  
20 XIMMATRIK XIMMATRIK XFELD CHAR 1   0   Indicator: Proof of matriculation provided  
21 IMMATDAT IMMATDAT DATUM DATS 8   0   Matriculation Certificate Valid To  
22 POART POART_ISP POART_ISP CHAR 2   0   Internal Item Type for Sales Order TJAP
23 AEART AEART_JSDK AEART_JSDK CHAR 1   0   Order Change Type  
24 POSEX POSEX_ISP POSEX_ISP NUMC 6   0   External Item Number (Purchase Order Item)  
25 ZSKLS JZSKLS JZSKLS CHAR 1   0   Time slice classification for sales order  
26 DRERZ DRERZ DRERZ CHAR 8   0   Publication JDTDRER
27 PVA PVA PVA CHAR 8   0   Edition JDTPVA
28 BEZUGSTYP BEZUGSTYP_JE_PVA BEZUGSTYP_JE_PVA CHAR 2   0   Mix Type JDTBEZTYP
29 SPART_PO SPARTDRERZ SPART CHAR 2   0   Division for publication TSPA
30 TAXM1 TAXMT TAXKD CHAR 1   0   Tax classification material  
31 TAXM2 TAXMT TAXKD CHAR 1   0   Tax classification material  
32 TAXM3 TAXMT TAXKD CHAR 1   0   Tax classification material  
33 TAXM4 TAXMT TAXKD CHAR 1   0   Tax classification material  
34 TAXM5 TAXMT TAXKD CHAR 1   0   Tax classification material  
35 TAXM6 TAXMT TAXKD CHAR 1   0   Tax classification material  
36 TAXM7 TAXMT TAXKD CHAR 1   0   Tax classification material  
37 TAXM8 TAXMT TAXKD CHAR 1   0   Tax classification material  
38 TAXM9 TAXMT TAXKD CHAR 1   0   Tax classification material  
39 LIEFERART LIEFERART LIEFERART CHAR 2   0   Delivery Type TJV01
40 DRUCKEREI JWERK WERKS CHAR 4   0   Plant T001W
41 XLOGO XLOGO XFELD CHAR 1   0   Print Logo  
42 FAKSP_PO FAKTSPERRE FAKSP CHAR 2   0   Billing Block TVFS
43 XFAKTSPERR XFAKTSPERR XFELD CHAR 1   0   IS-M: Billing block set  
44 PVAKNTGRP PVAKNTGRP KTGRM CHAR 2   0   Account Assignment Grouping for Edition TVKM
45 PVAKONGRP PVAKONGRP JKONDM CHAR 2   0   Condition Grouping for Edition TJD47
46 PVABONGRP PVABONGRP JBONUS CHAR 2   0   Edition bonus grouping TJD49
47 STAFO_PO STAFO STAFO CHAR 6   0   Update group for statistics update  
48 STCUR_PO STCUR_AP KURRF DEC 9   5   Exchange rate for statistics (Exch.rate at time of creation)  
49 KUNWE GPNR_WE GPNR CHAR 10   0   IS-M: Business Partner Ship-to Party JGTGPNR
50 LANDE LANDE_ISP LAND1 CHAR 3   0   Current country being supplied T005
51 LAND1 LAND1_ISP LAND1 CHAR 3   0   Normal delivery country T005
52 RECHBEGINN RECHBEGINN DATUM DATS 8   0   Billing From  
53 RECHENDE RECHENDE DATUM DATS 8   0   Billing To  
54 POSNR_UR APNR_UR APNR NUMC 6   0   Original Item in Publishing Sales Order JKAP
55 SHKZG SHKZG_ISP XFELD CHAR 1   0   IS-M: Debit indicator for schedule line  
56 JKEPVON JKEPVON DATUM DATS 8   0   Date from Which Schedule Line in Sales Order is Valid  
57 JKEPBIS JKEPBIS DATUM DATS 8   0   Date to Which Schedule Line in Sales Order is Valid  
58 ETART ETART_ISP ETART_ISP CHAR 2   0   Schedule Line Type for Internal Sales Order Schedule Line TJEP
59 ETEEX ETEEX_ISP ETEEX NUMC 6   0   IS-M: External Schedule Line Number  
60 BEZPER BEZPER BEZPER CHAR 5   0   Service Type TJD09
61 ETMENGE ETMENGE MENGGPOS QUAN 10   0   IS-M: Sales Order Schedule Line Quantity  
62 ETMEINS ETMEINS MEINS UNIT 3   0   IS-M: Sales Unit for Sales Order T006
63 ETVORZEI ETVORZEI VORZEI CHAR 1   0   Plus/Minus Sign for Schedule Line Quantity in Sales Order  
64 UNTMENGE UNTMENGE MENGGPOS QUAN 10   0   IS-M: Suspension quantity  
65 RKMENGE RKMENGE MENGGPOS QUAN 10   0   Number of complaint copies  
66 NLMENGE NLMENGE MENGGPOS QUAN 10   0   Number of Copies for Subsequent Delivery  
67 KPOSN KPOSN_ISP NUM6 NUMC 6   0   Condition item number  
68 NETWR NETWR_ISP WERTV8 CURR 15   2   IS-M: Net price in document currency  
69 MWSBP MWSBP WERTV7 CURR 13   2   Tax amount in document currency  
70 NETPR NETPR WERTV6 CURR 11   2   Net price  
71 KPEIN KPEIN KPEIN DEC 5   0   Condition pricing unit  
72 KMEIN KMEIN MEINS UNIT 3   0   Condition Unit T006
73 SKTOF SKTOF XFELD CHAR 1   0   Cash discount indicator  
74 PRSOK PRSOK XFELD CHAR 1   0   Pricing is OK  
75 PRSBINDDAT PRSBINDDAT DATUM DATS 8   0   To-date for price fixing  
76 PRSDT PRSDT DATUM DATS 8   0   Date for pricing and exchange rate  
77 PRBAS PRBAS_ISP PRBAS_ISP CHAR 1   0   Price Basis  
78 PRSPER PRSPER PRSPER CHAR 2   0   IS-M: Price Frequency TJK03
79 BZPERF BEZPERFAKT BEZPER CHAR 5   0   IS-M: Service Type for Billing TJD09
80 PRSMLT PRSMLT PRSMLT DEC 5   0   IS-M: Numerator in conversion factor for frequencies  
81 PRSDIV PRSDIV PRSDIV DEC 5   0   IS-M: Denominator for frequency conversion factor  
82 PLTYP PLTYP PLTYP CHAR 2   0   Price list type T189
83 KONDA KONDA KONDA CHAR 2   0   Price Group (Customer) T188
84 KDGRP KDGRP KDGRP CHAR 2   0   Customer group T151
85 INCO1 INCO1 INCO1 CHAR 3   0   Incoterms (part 1) TINC
86 INCO2 INCO2 INCO2 CHAR 28   0   Incoterms (part 2)  
87 PERFK PERFK WFCID CHAR 2   0   Invoice dates (calendar identification) TJG61
88 PERRL PERRL WFCID CHAR 2   0   Invoice list schedule (calendar identification) TJG61
89 MRNKZ MRNKZ XFELD CHAR 1   0   Manual invoice maintenance  
90 KURRF KURRF KURRF DEC 9   5   Exchange rate for FI postings  
91 VALTG VALTG TAGE2 NUMC 2   0   Additional value days  
92 VALDT VALDT DATUM DATS 8   0   Fixed value date  
93 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
94 KTGRD KTGRD KTGRD CHAR 2   0   Account assignment group for this customer TVKT
95 KURSK_KD KURSK KURRF DEC 9   5   Exchange Rate for Pricing and Statistics  
96 STCUR_KD STCUR KURRF DEC 9   5   Exchange rate for statistics  
97 FKPER FKPER FKPER CHAR 2   0   Billing Frequency TJK01
98 ZAHLW JZAHLW JZAHLW CHAR 1   0   Billing method  
99 FBUDA FBUDA DATUM DATS 8   0   Date When Services Rendered  
100 POPER POPER POPER NUMC 3   0   Posting period  
101 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
102 XSEPFKPOS XSEPFKPOS XFELD CHAR 1   0   Separate billing document for order item  
103 PRBAS_VK PRBAS_VK PRBAS_ISP CHAR 1   0   Price Basis for Shipping Costs  
104 XKINKASSO XKINKASSO XFELD CHAR 1   0   IS-M: Payment by field collector  
105 XFKKOMP XFKKOMP XFELD CHAR 1   0   Indicator: Perform Billing in Full for Billing Period  
106 XFKENDE XFKENDE XFELD CHAR 1   0   Indicator: Billing at end of calculation  
107 JUEBART JUEBART JUEBART CHAR 1   0   IS-M: Transfer Type  
108 XRECHDRUCK XRECHDRUCK XFELD CHAR 1   0   IS-M: Print Invoice  
109 JKPAVON JKPAVON DATUM DATS 8   0   Date from Which Partner Data in Sales Order is Valid  
110 JKPABIS JKPABIS DATUM DATS 8   0   Date to Which Partner Data in Sales Order is Valid  
111 ADRNR JADRNR JADRNR CHAR 10   0   IS-M: Address Number JGTSADR
112 ADRESSVAR ADRESSVAR ERSTADR CHAR 1   0   IS-M: Address Variant  
113 POSNR_VG APNR_VG APNR NUMC 6   0   Preceding Item in Publishing Sales Order JKAP
114 TRVOG TRVOG_ISP TRVOG_ISP CHAR 1   0   Transaction Group for IS-M Order Processing  
115 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVBVK
116 VKBUR JVKBUR VKBUR CHAR 4   0   IS-M/SD: Receiving Sales Office TVKBZ
117 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
118 VKBURZUS VKBURZUS VKBUR CHAR 4   0   Sales office responsible TVBUR
119 XWBZABO XWBZABO XFELD CHAR 1   0   IS-M: WBZ subscription  
120 IVWKN IVWKN IVWKN CHAR 8   0   Circulation Audit Report Category ID TJI01
121 XIVW XIVW XFELD CHAR 1   0   Indicator: Relevant for audit report  
122 VAUSGB VAUSGB VAUSGB CHAR 10   0   Issue JDTVAUSGB
123 XFKVDICHT XFKVDICHT XFELD CHAR 1   0   IS-M: Summarize deliveries according to billing item  
124 AENDATE AENDATE DATUM DATS 8   0   Date of Last Change  
125 AENTIME AENTIME UZEIT TIMS 6   0   Time of Last Change  
126 JPARVWGPAG JPARVWGPAG JPARVWGPAG CHAR 1   0   IS-M: Partner usage of sold-to party  
127 ETAEART AEART_JSDK AEART_JSDK CHAR 1   0   Order Change Type  
128 ETENR_VG AENR_VG AENR NUMC 4   0   Preceding Schedule Line JKEP
129 XRENEWAL XRENEWAL XFELD CHAR 1   0   IS-M/SD: Order extended by renewal offer  
130 AMORTN AMORTN AMORTN CHAR 1   0   IS-M/SD: Use of Liability Account in Order  
131 RCODE RATE_CODE RATE_CODE CHAR 4   0   IS-M/SD: Rate Code TJKRRC
132 XAUTO_REN XAUTO_REN XFELD CHAR 1   0   IS-M/SD: Customer Requests Automatic Renewal  
133 STCEG_L LAND1TX LAND1 CHAR 3   0   Tax Destination Country T005
134 STBFREI JSTBFREI JSTBFREI CHAR 2   0   Type of Tax Exemption TJFSB
135 XNEGOPTION XNEGOPTION XFELD CHAR 1   0   IS-M: Item with Automatic Transformation to Chargeable  
136 IVWDATUM IVWDATUM DATUM DATS 8   0   Date of Audit Report for Returns  
137 VKONT VKONT_KK VKONT_KK CHAR 12   0   Contract Account Number  
138 DELIVSPLITGRP DELIVSPLITGRP DELIVSPLITGRP CHAR 10   0   IS-M/SD: Address Alternation Group TJD63
139 DELIVSPLIT DELIVSPLIT DELIVSPLIT CHAR 8   0   IS-M/SD: Alternating Address Element TJD23
140 X_MONTAG X_MONTAG XFELD CHAR 1   0   IS-M: Monday  
141 X_DIENSTAG X_DIENSTAG XFELD CHAR 1   0   IS-M: Tuesday  
142 X_MITTWOCH X_MITTWOCH XFELD CHAR 1   0   IS-M: Wednesday  
143 X_DONNETAG X_DONNETAG XFELD CHAR 1   0   IS-M: Thursday  
144 X_FREITAG X_FREITAG XFELD CHAR 1   0   IS-M: Friday  
145 X_SAMSTAG X_SAMSTAG XFELD CHAR 1   0   IS-M: Saturday  
146 X_SONNTAG X_SONNTAG XFELD CHAR 1   0   IS-M: Sunday  
147 POSNR_MAIN APNR_MAIN APNR NUMC 6   0   IS-M/SD: Main Item in Sales Order JKAP
148 POSNR_SUB APNR_SUB APNR NUMC 6   0   IS-M/SD: Sub-Item in Sales Order JKAP
149 CAMPAIGN ISM_MARKETING_CAMPAIGN ISM_MARKETING_CAMPAIGN RAW 16   0   IS-M: Marketing Campaign  
150 XPAYMODE_FIX XPAYMODE_FIX XFELD CHAR 1   0   IS-M/SD: Payment Arrangement in Order Fixed  
151 BONUSTYPE JBONUSTYPE JBONUSTYPE CHAR 2   0   IS-M/SD: Bonus Type  
152 XAMOCREDIT XAMOCREDIT XFELD CHAR 1   0   Complaint order - amount credited to liability account  
153 XRUECKABO XRUECKABO XFELD CHAR 1   0   IS-M: Backdated subscription created  
154 MNDID SEPA_MNDID ID035 CHAR 35   0   Unique Referene to Mandate per Payment Recipient  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 JKVFAKT ADRNR JGTSADR ADRNR REF C CN
2 JKVFAKT AUART TJAK AUART REF 1 CN
3 JKVFAKT BEZPER TJD09 BEZPER REF 1 CN
4 JKVFAKT BEZUGSTYP JDTBEZTYP BEZTYP REF 1 CN
5 JKVFAKT BZPERF TJD09 BEZPER REF C CN
6 JKVFAKT DELIVSPLIT TJD23 DELIVSPLIT REF C CN
7 JKVFAKT DELIVSPLITGRP TJD63 DELIVSPLITGRP REF C CN
8 JKVFAKT DRERZ JDTDRER DRERZ REF C CN
9 JKVFAKT DRUCKEREI T001W WERKS REF C CN
10 JKVFAKT ETART TJEP ETART REF 1 CN
11 JKVFAKT ETENR_VG JKEP ETENR REF 1 CN
12 JKVFAKT ETMEINS T006 MSEHI REF C CN
13 JKVFAKT FAKSP_KO TVFS FAKSP REF C CN
14 JKVFAKT FAKSP_PO TVFS FAKSP REF C CN
15 JKVFAKT FKPER TJK01 FKPER REF C CN
16 JKVFAKT GPAG JGTGPNR GPNR KEY 1 CN
17 JKVFAKT GSBER TGSB GSBER REF C CN
18 JKVFAKT INCO1 TINC INCO1 REF C CN
19 JKVFAKT IVWKN TJI01 IVWKN REF C CN
20 JKVFAKT KALSM T683 KALSM REF C CN
21 JKVFAKT KDGRP T151 KDGRP REF C CN
22 JKVFAKT KMEIN T006 MSEHI REF C CN
23 JKVFAKT KONDA T188 KONDA REF C CN
24 JKVFAKT KTGRD TVKT KTGRD REF C CN
25 JKVFAKT KUNWE JGTGPNR GPNR REF C CN
26 JKVFAKT KURST_KO TCURV KURST REF C CN
27 JKVFAKT LAND1 T005 LAND1 REF C CN
28 JKVFAKT LANDE T005 LAND1 REF C CN
29 JKVFAKT LIEFERART TJV01 LIEFERART REF C CN
30 JKVFAKT MANDT T000 MANDT KEY 1 CN
31 JKVFAKT PERFK TJG61 IDENT REF C CN
32 JKVFAKT PERRL TJG61 IDENT REF C CN
33 JKVFAKT PLTYP T189 PLTYP REF C CN
34 JKVFAKT POART TJAP POART REF 1 CN
35 JKVFAKT POSNR_MAIN JKAP POSNR REF C CN
36 JKVFAKT POSNR_SUB JKAP POSNR REF C CN
37 JKVFAKT POSNR_UR JKAP POSNR REF 1 CN
38 JKVFAKT POSNR_VG JKAP POSNR REF 1 CN
39 JKVFAKT PRSPER TJK03 PRSPER REF 1 CN
40 JKVFAKT PVA JDTPVA PVA REF C CN
41 JKVFAKT PVABONGRP TJD49 PVABONGRP REF C CN
42 JKVFAKT PVAKNTGRP TVKM KTGRM REF C CN
43 JKVFAKT PVAKONGRP TJD47 PVAKONGRP REF C CN
44 JKVFAKT RCODE TJKRRC RCODE REF C CN
45 JKVFAKT SPART_KO TVTA SPART KEY 1 CN
46 JKVFAKT SPART_PO TSPA SPART REF C CN
47 JKVFAKT STBFREI TJFSB STBFREI REF C CN
48 JKVFAKT STCEG_L T005 LAND1 REF C CN
49 JKVFAKT VAUSGB JDTVAUSGB VAUSGB REF 1 CN
50 JKVFAKT VKBUR TVKBZ VKBUR REF C CN
51 JKVFAKT VKBURZUS TVBUR VKBUR REF C CN
52 JKVFAKT VKGRP TVBVK VKGRP REF C CN
53 JKVFAKT VKORG TVKO VKORG KEY 1 CN
54 JKVFAKT VTWEG TVKOV VTWEG KEY 1 CN
55 JKVFAKT WAERK TCURC WAERS REF 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in