SAP ABAP Table V_JSBW_INVOICE (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_JSBW_INVOICE   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 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 KONDA KONDA KONDA CHAR 2   0   Price Group (Customer) T188
12 KDGRP KDGRP KDGRP CHAR 2   0   Customer group T151
13 PLTYP PLTYP PLTYP CHAR 2   0   Price list type T189
14 ZLSCH SCHZW_BSEG ZLSCH CHAR 1   0   Payment Method  
15 KTGRD KTGRD KTGRD CHAR 2   0   Account assignment group for this customer TVKT
16 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County)  
17 COUNC COUNC COUNC CHAR 3   0   County Code  
18 CITYC CITYC CITYC CHAR 4   0   City Code  
19 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
20 KUNRG KUNRG KUNNR CHAR 10   0   Payer KNA1
21 KUNAG KUNAG KUNNR CHAR 10   0   Sold-to party KNA1
22 ISPSHKZGK SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
23 ISPSTOGRD JSTOGRDF JSTOGRDF CHAR 3   0   IS-M: Billing Document Reversal Reason TJF27
24 ISPXINK XKINKASSO XFELD CHAR 1   0   IS-M: Payment by field collector  
25 ISPXWBZABO XWBZABO XFELD CHAR 1   0   IS-M: WBZ subscription  
26 ISPINKVSG ISPINKVSG KUNNR CHAR 10   0   IS-M: Field Collector is Service Company  
27 ISPINKGP ISPINKGP KUNNR CHAR 10   0   IS-M: Field Collector is Employee  
28 ISPXVDICHT XFKVDICHT XFELD CHAR 1   0   IS-M: Summarize deliveries according to billing item  
29 XRENEWAL XRENEWAL XFELD CHAR 1   0   IS-M/SD: Order extended by renewal offer  
30 POSNR ISPPOSNR ISPPOSNR NUMC 6   0   IS-M: Billing Item  
31 FKIMG FKIMG MENG13 QUAN 13   3   Actual billed quantity  
32 VRKME VRKME MEINS UNIT 3   0   Sales unit T006
33 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure T006
34 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
35 FBUDA FBUDA DATUM DATS 8   0   Date When Services Rendered  
36 NETWR NETWR_FP WERTV8 CURR 15   2   Net value of the billing item in document currency  
37 MATKL MATKL MATKL CHAR 9   0   Material Group T023
38 SPART SPART SPART CHAR 2   0   Division TSPA
39 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
40 ALAND ALAND LAND1 CHAR 3   0   Departure country (country from which the goods are sent) T005
41 WKREG WKREG REGIO CHAR 3   0   Region in which plant is located T005S
42 WKCOU WKCOU CHAR3 CHAR 3   0   County in which plant is located  
43 WKCTY WKCTY CHAR4 CHAR 4   0   City in which plant is located  
44 SKFBP SKFBP WERTV7 CURR 13   2   Amount eligible for cash discount in document currency  
45 SPARA SPART_AK SPART CHAR 2   0   Division for order header TSPA
46 SHKZG SHKZG_VA XFELD CHAR 1   0   Returns Item  
47 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
48 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
49 ERZET ERZET UZEIT TIMS 6   0   Entry time  
50 STAFO STAFO STAFO CHAR 6   0   Update group for statistics update  
51 WAVWR WAVWR WERTV7 CURR 13   2   Cost in document currency  
52 ISPAUART AUART_ISP AUART_ISP CHAR 4   0   IS-M/SD: Sales Document Types TJAK
53 ISPAUAGRP ISPAUAGRP JAUARTGRP CHAR 1   0   IS-M: Sales Document Type Grouping for Sales Order  
54 ISPKOSTL_L ISPKOSTL_L KOSTL CHAR 10   0   IS-M: Cost Center to be Charged  
55 ISPDRERZ DRERZ DRERZ CHAR 8   0   Publication JDTDRER
56 ISPPVA PVA PVA CHAR 8   0   Edition JDTPVA
57 ISPBEZ BEZUGSTYP_JE_PVA BEZUGSTYP_JE_PVA CHAR 2   0   Mix Type JDTBEZTYP
58 ISPLIFART LIEFERART LIEFERART CHAR 2   0   Delivery Type TJV01
59 ISPPOSEX POSEX_ISP POSEX_ISP NUMC 6   0   External Item Number (Purchase Order Item)  
60 ISPVBELN AVNR AVNR CHAR 10   0   IS-M/SD: Publishing Sales Order JKAK
61 ISPPOSNR APNR APNR NUMC 6   0   Sales Order Item JKAP
62 ISPETENR JAENR AENR NUMC 4   0   Sales Order Schedule Line JKEP
63 ISPETEEX ETEEX_ISP ETEEX NUMC 6   0   IS-M: External Schedule Line Number  
64 ISPETART ETART_ISP ETART_ISP CHAR 2   0   Schedule Line Type for Internal Sales Order Schedule Line TJEP
65 ISPETMENGE ETMENGE MENGGPOS QUAN 10   0   IS-M: Sales Order Schedule Line Quantity  
66 ISPETMEINS ETMEINS MEINS UNIT 3   0   IS-M: Sales Unit for Sales Order T006
67 ISPETVOR ISPETVOR VORZEI CHAR 1   0   IS-M: Plus/Minus Sign for Sch. Line Quantity in Sales Order  
68 ISPANZET ISPANZET ANZET DEC 5   0   IS-M: Number of Publication Dates  
69 ISPERSDAT ERSCHDAT DATUM DATS 8   0   Publication Date  
70 ISPWRBAKT WERBEAKT WERBEAKT CHAR 8   0   Sales Promotion TJWAK
71 ISPFAKVON FAKVON DATUM DATS 8   0   IS-M: Billing Period From  
72 ISPFAKBIS FAKBIS DATUM DATS 8   0   IS-M: Billing Period To  
73 ISPKONDA KONDA KONDA CHAR 2   0   Price Group (Customer) T188
74 ISPKDGRP KDGRP KDGRP CHAR 2   0   Customer group T151
75 ISPPOART POART_ISP POART_ISP CHAR 2   0   Internal Item Type for Sales Order TJAP
76 ISPBRTWR_P ISPBRTWR WERTV8 CURR 15   2   IS-M: Gross Value in Document Currency  
77 ISPVERSDAT VRSNDDATUM DATUM DATS 8   0   IS-M: Shipping Date  
78 ISPLANDE LANDE_ISP LAND1 CHAR 3   0   Current country being supplied  
79 ISPVAUSGB VAUSGB VAUSGB CHAR 10   0   Issue JDTVAUSGB
80 ISPVKBURZU VKBURZUS VKBUR CHAR 4   0   Sales office responsible  
81 ISPXFKRUEK XFKRUECK XFELD CHAR 1   0   IS-M: Retroactive Billing of Period Already Billed  
82 ISPIVWKN IVWKN IVWKN CHAR 8   0   Circulation Audit Report Category ID  
83 ISPXIVW XIVW XFELD CHAR 1   0   Indicator: Relevant for audit report  
84 XNEGOPTION XNEGOPTION XFELD CHAR 1   0   IS-M: Item with Automatic Transformation to Chargeable  
85 IVWDATUM IVWDATUM DATUM DATS 8   0   Date of Audit Report for Returns  
86 CAMPAIGN ISM_MARKETING_CAMPAIGN ISM_MARKETING_CAMPAIGN RAW 16   0   IS-M: Marketing Campaign  
87 FKPERVON FKPERVON DATUM DATS 8   0   IS-M: Initial Date of Full Billing Period  
88 FKPERBIS FKPERBIS DATUM DATS 8   0   IS-M: Closing Date of Full Billing Period  
89 ISPZSKLS JZSKLS JZSKLS CHAR 1   0   Time slice classification for sales order  
90 ISPWRBART WERBEART WERBEART CHAR 4   0   Sales Source TJWAR
91 POSNR_UR APNR_UR APNR NUMC 6   0   Original Item in Publishing Sales Order  
92 CYCLENR CYCLENR CYCLENR NUMC 3   0   IS-M/SD: Billing Cycle Number  
93 FAKNRRUECK ISPFAKNRRUECK ISPVBELN CHAR 10   0   IS-M: Recalculated Billing Document  
94 XAUTO_REN XAUTO_REN XFELD CHAR 1   0   IS-M/SD: Customer Requests Automatic Renewal  
95 X_MONTAG X_MONTAG XFELD CHAR 1   0   IS-M: Monday  
96 X_DIENSTAG X_DIENSTAG XFELD CHAR 1   0   IS-M: Tuesday  
97 X_MITTWOCH X_MITTWOCH XFELD CHAR 1   0   IS-M: Wednesday  
98 X_DONNETAG X_DONNETAG XFELD CHAR 1   0   IS-M: Thursday  
99 X_FREITAG X_FREITAG XFELD CHAR 1   0   IS-M: Friday  
100 X_SAMSTAG X_SAMSTAG XFELD CHAR 1   0   IS-M: Saturday  
101 X_SONNTAG X_SONNTAG XFELD CHAR 1   0   IS-M: Sunday  
102 VBELN_FROM AVNR AVNR CHAR 10   0   IS-M/SD: Publishing Sales Order  
103 POSNR_UR_FROM APNR APNR NUMC 6   0   Sales Order Item  
104 CYCLENR_FROM CYCLENR CYCLENR NUMC 3   0   IS-M/SD: Billing Cycle Number  
105 PARVW PARVW PARVW CHAR 2   0   Partner Role TPAR
106 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number KNA1
107 ADRNR ADRNR ADRNR CHAR 10   0   Address  
108 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
109 ISPADRNR JADRNR JADRNR CHAR 10   0   IS-M: Address Number  
110 ISPADRVAR ADRESSVAR ERSTADR CHAR 1   0   IS-M: Address Variant  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_JSBW_INVOICE ALAND T005 LAND1 REF 1 CN
2 V_JSBW_INVOICE BUKRS T001 BUKRS REF 1 CN
3 V_JSBW_INVOICE FKART TJFK FKART REF 1 CN
4 V_JSBW_INVOICE GSBER TGSB GSBER REF C CN
5 V_JSBW_INVOICE ISPAUART TJAK AUART KEY 1 CN
6 V_JSBW_INVOICE ISPBEZ JDTBEZTYP BEZTYP    
7 V_JSBW_INVOICE ISPDRERZ JDTDRER DRERZ    
8 V_JSBW_INVOICE ISPETART TJEP ETART KEY 1 CN
9 V_JSBW_INVOICE ISPETENR JKEP ETENR KEY 1 CN
10 V_JSBW_INVOICE ISPETMEINS T006 MSEHI    
11 V_JSBW_INVOICE ISPKDGRP T151 KDGRP    
12 V_JSBW_INVOICE ISPKONDA T188 KONDA    
13 V_JSBW_INVOICE ISPLIFART TJV01 LIEFERART    
14 V_JSBW_INVOICE ISPPOART TJAP POART    
15 V_JSBW_INVOICE ISPPOSNR JKAP POSNR KEY 1 CN
16 V_JSBW_INVOICE ISPPVA JDTPVA PVA    
17 V_JSBW_INVOICE ISPSTOGRD TJF27 STOGRD    
18 V_JSBW_INVOICE ISPVAUSGB JDTVAUSGB VAUSGB    
19 V_JSBW_INVOICE ISPVBELN JKAK VBELN KEY 1 CN
20 V_JSBW_INVOICE ISPWRBAKT TJWAK WERBEAKT    
21 V_JSBW_INVOICE ISPWRBART TJWAR WERBEART KEY C CN
22 V_JSBW_INVOICE KALSM T683 KALSM REF 1 CN
23 V_JSBW_INVOICE KDGRP T151 KDGRP REF C CN
24 V_JSBW_INVOICE KONDA T188 KONDA REF C CN
25 V_JSBW_INVOICE KTGRD TVKT KTGRD REF C CN
26 V_JSBW_INVOICE KUNAG KNA1 KUNNR REF 1 CN
27 V_JSBW_INVOICE KUNNR KNA1 KUNNR REF C CN
28 V_JSBW_INVOICE KUNRG KNA1 KUNNR REF 1 CN
29 V_JSBW_INVOICE LAND1 T005 LAND1 REF C CN
30 V_JSBW_INVOICE MANDT T000 MANDT KEY 1 CN
31 V_JSBW_INVOICE MATKL T023 MATKL REF C CN
32 V_JSBW_INVOICE MEINS T006 MSEHI REF C CN
33 V_JSBW_INVOICE PARVW TPAR PARVW KEY 1 CN
34 V_JSBW_INVOICE PLTYP T189 PLTYP REF C CN
35 V_JSBW_INVOICE SPARA TSPA SPART REF C CN
36 V_JSBW_INVOICE SPART TSPA SPART REF C CN
37 V_JSBW_INVOICE VKORG TVKO VKORG REF C CN
38 V_JSBW_INVOICE VRKME T006 MSEHI REF C CN
39 V_JSBW_INVOICE VTWEG TVTW VTWEG REF C CN
40 V_JSBW_INVOICE WAERK TCURC WAERS REF 1 CN
41 V_JSBW_INVOICE WERKS T001W WERKS REF C CN
42 V_JSBW_INVOICE WKREG T005S BLAND REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in