SAP ABAP Table V_JSBW_ACCOUNT (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_JSBW_ACCOUNT   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 VBTYP VBTYP_ISP VBTYP_ISP CHAR 1   0   Sales document category, IS-M  
4 TRVOG TRVOG_ISP TRVOG_ISP CHAR 1   0   Transaction Group for IS-M Order Processing  
5 AUART AUART_ISP AUART_ISP CHAR 4   0   IS-M/SD: Sales Document Types TJAK
6 AUARTGRP JAUARTGRP JAUARTGRP CHAR 1   0   IS-M/SD: Sales document type grouping  
7 XFKVDICHT XFKVDICHT XFELD CHAR 1   0   IS-M: Summarize deliveries according to billing item  
8 XRENEWAL XRENEWAL XFELD CHAR 1   0   IS-M/SD: Order extended by renewal offer  
9 POSNR APNR APNR NUMC 6   0   Sales Order Item  
10 GUELTIGVON JKAPVON DATUM DATS 8   0   Valid-From Date of Sales Order Item  
11 GUELTIGBIS JKAPBIS DATUM DATS 8   0   Date to which Sales Order Item is Valid  
12 POART POART_ISP POART_ISP CHAR 2   0   Internal Item Type for Sales Order TJAP
13 POSEX POSEX_ISP POSEX_ISP NUMC 6   0   External Item Number (Purchase Order Item)  
14 DRERZ DRERZ DRERZ CHAR 8   0   Publication JDTDRER
15 PVA PVA PVA CHAR 8   0   Edition JDTPVA
16 BEZUGSTYP BEZUGSTYP_JE_PVA BEZUGSTYP_JE_PVA CHAR 2   0   Mix Type JDTBEZTYP
17 LIEFERART LIEFERART LIEFERART CHAR 2   0   Delivery Type TJV01
18 UNTBRGRD UNTBRGRD UNTBRGRD CHAR 3   0   Reason for Suspension TJK85
19 XURPOS XURPOS XFELD CHAR 1   0   Original item in publishing sales order  
20 POSNR_UR APNR_UR APNR NUMC 6   0   Original Item in Publishing Sales Order JKAP
21 POSNR_VG APNR_VG APNR NUMC 6   0   Preceding Item in Publishing Sales Order JKAP
22 VBELN_VL AVNR_VL AVNR CHAR 10   0   Reference Document JKAK
23 POSNR_VL APNR_VL APNR NUMC 6   0   Reference Document Item JKAP
24 XSTORNO XJSTORNO XFELD CHAR 1   0   Indicator: Reversed  
25 STORNOGRD STORNOGRD STORNOGRD CHAR 3   0   Reversal Reason TJK91
26 POSNR_MAIN APNR_MAIN APNR NUMC 6   0   IS-M/SD: Main Item in Sales Order JKAP
27 POSNR_SUB APNR_SUB APNR NUMC 6   0   IS-M/SD: Sub-Item in Sales Order JKAP
28 XMAINSPLIT XMAINSPLIT XFELD CHAR 1   0   Item for this Alternating Add. Element is a Main Sub-Item  
29 X_MONTAG X_MONTAG XFELD CHAR 1   0   IS-M: Monday  
30 X_DIENSTAG X_DIENSTAG XFELD CHAR 1   0   IS-M: Tuesday  
31 X_MITTWOCH X_MITTWOCH XFELD CHAR 1   0   IS-M: Wednesday  
32 X_DONNETAG X_DONNETAG XFELD CHAR 1   0   IS-M: Thursday  
33 X_FREITAG X_FREITAG XFELD CHAR 1   0   IS-M: Friday  
34 X_SAMSTAG X_SAMSTAG XFELD CHAR 1   0   IS-M: Saturday  
35 X_SONNTAG X_SONNTAG XFELD CHAR 1   0   IS-M: Sunday  
36 CAMPAIGN ISM_MARKETING_CAMPAIGN ISM_MARKETING_CAMPAIGN RAW 16   0   IS-M: Marketing Campaign  
37 CYCLENR CYCLENR CYCLENR NUMC 3   0   IS-M/SD: Billing Cycle Number  
38 ZBETR BETRZ WERT7 CURR 13   2   IS-M/SD: Payment Amount in Local Currency  
39 AMOBETR AMOBETR AMOBETR CURR 13   2   IS-M/SD: Amortization Amount  
40 VAUSGB_F VAUSGB_F VAUSGB CHAR 10   0   IS-M/SD: First Issue Delivered in Billing Cycle JDTVAUSGB
41 VAUSGB_L VAUSGB_L VAUSGB CHAR 10   0   IS-M/SD: Last Issue Delivered in Billing Cycle JDTVAUSGB
42 VAUSGB_LBI VAUSGB_LBI VAUSGB CHAR 10   0   IS-M/SD: Last issue delivered before billing doc.transfer JDTVAUSGB
43 XCYCLE_FIN XCYCLE_FIN XFELD CHAR 1   0   IS-M/SD: Amortization Complete for Liability Account  
44 EXPDATE EXP_DATE DATUM DATS 8   0   IS-M/SD: Expiration Date of Subscription  
45 DELIV_BILL DELIV_BILL JZFAKTOR NUMC 3   0   Number of Deliveries Billed in Billing Cycle  
46 DELIV_AMO DELIV_AMO JZFAKTOR NUMC 3   0   Number of Amortized Deliveries in Billing Cycle  
47 TFBETR TFBETR WERTV7 CURR 13   2   IS-M/SD: Transfer amount  
48 WAERK WAERK WAERS CUKY 5   0   SD document currency TCURC
49 KURST KURST KURST CHAR 4   0   Exchange Rate Type TCURV
50 TRANS_DATE WWERT_D DATUM DATS 8   0   Translation date  
51 UKURS UKURS_CURR UKURS DEC 9   5   Exchange Rate  
52 XINVOICE XINVOICE XFELD CHAR 1   0   IS-M/SD: Billing and Transfer Performed for Cycle  
53 XGOLIVE XGOLIVE XFLAG CHAR 1   0   IS-M/SD: Cycle from Data Transfer  
54 XFKRUECK XFKRUECK XFELD CHAR 1   0   IS-M: Retroactive Billing of Period Already Billed  
55 POSNR_NP_LAST POSNR_NP_LAST_AMO APNR NUMC 6   0   Standard Item Last Amortized Within Original Item  
56 XADVANCE_BILL XADVANCE_BILL XFELD CHAR 1   0   IS-M/SD: Perform Billing in Advance  
57 XAMO_ARCHIVED XAMO_ARCHIVED XFELD CHAR 1   0   IS-M/SD: Amortization Data on Cycle Activated  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_JSBW_ACCOUNT AUART TJAK AUART REF 1 CN
2 V_JSBW_ACCOUNT BEZUGSTYP JDTBEZTYP BEZTYP REF 1 CN
3 V_JSBW_ACCOUNT DRERZ JDTDRER DRERZ REF C CN
4 V_JSBW_ACCOUNT KURST TCURV KURST REF    
5 V_JSBW_ACCOUNT LIEFERART TJV01 LIEFERART REF C CN
6 V_JSBW_ACCOUNT MANDT T000 MANDT KEY 1 CN
7 V_JSBW_ACCOUNT POART TJAP POART REF 1 CN
8 V_JSBW_ACCOUNT POSNR_MAIN JKAP POSNR REF C CN
9 V_JSBW_ACCOUNT POSNR_SUB JKAP POSNR REF C CN
10 V_JSBW_ACCOUNT POSNR_UR JKAP POSNR REF 1 CN
11 V_JSBW_ACCOUNT POSNR_VG JKAP POSNR REF 1 CN
12 V_JSBW_ACCOUNT POSNR_VL JKAP POSNR REF C CN
13 V_JSBW_ACCOUNT PVA JDTPVA PVA REF C CN
14 V_JSBW_ACCOUNT STORNOGRD TJK91 STORNOGRD REF C CN
15 V_JSBW_ACCOUNT UNTBRGRD TJK85 UNTBRGRD REF C CN
16 V_JSBW_ACCOUNT VAUSGB_F JDTVAUSGB VAUSGB REF C CN
17 V_JSBW_ACCOUNT VAUSGB_L JDTVAUSGB VAUSGB REF C CN
18 V_JSBW_ACCOUNT VAUSGB_LBI JDTVAUSGB VAUSGB REF C CN
19 V_JSBW_ACCOUNT VBELN_VL JKAK VBELN REF C CN
20 V_JSBW_ACCOUNT WAERK TCURC WAERS REF 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in