SAP ABAP Table V_JSBW_PROM (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_JSBW_PROM   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 POSNR APNR APNR NUMC 6   0   Sales Order Item  
8 POART POART_ISP POART_ISP CHAR 2   0   Internal Item Type for Sales Order TJAP
9 POSEX POSEX_ISP POSEX_ISP NUMC 6   0   External Item Number (Purchase Order Item)  
10 DRERZ DRERZ DRERZ CHAR 8   0   Publication JDTDRER
11 PVA PVA PVA CHAR 8   0   Edition JDTPVA
12 KUENDGRD KUENDGRD KUENDGRD CHAR 3   0   Reason for end of delivery TJK83
13 XURPOS XURPOS XFELD CHAR 1   0   Original item in publishing sales order  
14 POSNR_UR APNR_UR APNR NUMC 6   0   Original Item in Publishing Sales Order JKAP
15 POSNR_VG APNR_VG APNR NUMC 6   0   Preceding Item in Publishing Sales Order JKAP
16 VBELN_VL AVNR_VL AVNR CHAR 10   0   Reference Document JKAK
17 POSNR_VL APNR_VL APNR NUMC 6   0   Reference Document Item JKAP
18 POSNR_MAIN APNR_MAIN APNR NUMC 6   0   IS-M/SD: Main Item in Sales Order JKAP
19 POSNR_SUB APNR_SUB APNR NUMC 6   0   IS-M/SD: Sub-Item in Sales Order JKAP
20 XMAINSPLIT XMAINSPLIT XFELD CHAR 1   0   Item for this Alternating Add. Element is a Main Sub-Item  
21 X_MONTAG X_MONTAG XFELD CHAR 1   0   IS-M: Monday  
22 X_DIENSTAG X_DIENSTAG XFELD CHAR 1   0   IS-M: Tuesday  
23 X_MITTWOCH X_MITTWOCH XFELD CHAR 1   0   IS-M: Wednesday  
24 X_DONNETAG X_DONNETAG XFELD CHAR 1   0   IS-M: Thursday  
25 X_FREITAG X_FREITAG XFELD CHAR 1   0   IS-M: Friday  
26 X_SAMSTAG X_SAMSTAG XFELD CHAR 1   0   IS-M: Saturday  
27 X_SONNTAG X_SONNTAG XFELD CHAR 1   0   IS-M: Sunday  
28 CAMPAIGN ISM_MARKETING_CAMPAIGN ISM_MARKETING_CAMPAIGN RAW 16   0   IS-M: Marketing Campaign  
29 PROMNR JPROMNR JPROMNR NUMC 3   0   Sales order introduction  
30 WERBEART WERBEART WERBEART CHAR 4   0   Sales Source TJWAR
31 WERBEAKT WERBEAKT WERBEAKT CHAR 8   0   Sales Promotion TJWAK
32 GUELTIGVON WERBVONDT DATUM DATS 8   0   Start of Validity of Campaign Framework  
33 XAQUISITION XAQUISITION XFELD CHAR 1   0   IS-M/SD: Indicator - first introduction record  
34 WERBTRAEG WERBTRAEG WERBTRAEG CHAR 10   0   Advertising Medium  
35 MINDBEZUG MINDBEZUG ISPMNG2 QUAN 2   0   Minimum Length of Subscription  
36 MINDBEZEIN MINDBEZEIN MEINS UNIT 3   0   Time Unit for Minimum Length of Subscription T006
37 LIEFUNTMAX LIEFUNTMAX ISPMNG2 QUAN 2   0   Maximum Delivery Suspension  
38 LIEFUMXEIN LIEFUMXEIN MEINS UNIT 3   0   Time unit for maximum delivery suspension T006
39 GPRECH GPRECH GPNR CHAR 10   0   IS-M: Researcher JGTGPNR
40 VSGRCHEUR VSGRCHEUR GPNR CHAR 10   0   Researcher's Service Company JGTVSG
41 XRECHERZ XRECHERZ XFELD CHAR 1   0   IS-M: Research generated  
42 KONTAKTNR KONTAKTNR ERSATZNR CHAR 10   0   IS-M: Business Partner Sales Activity JWTWEKO
43 POSNR_BASE APNR APNR NUMC 6   0   Sales Order Item JKAP
44 CYCLENR_BASE CYCLENR CYCLENR NUMC 3   0   IS-M/SD: Billing Cycle Number JKACCOUNT
45 EVENT JK_EVENT JK_EVENT CHAR 4   0   IS-M/SD: Event in order processing TJKEVENT
46 ERFUSER ERFUSER USNAM CHAR 12   0   Created By  
47 ERFDATE ERFDATE DATUM DATS 8   0   Created On  
48 ERFTIME ERFTIME UZEIT TIMS 6   0   Time Created  
49 AENUSER AENUSER USNAM CHAR 12   0   Last Changed By  
50 AENDATE AENDATE DATUM DATS 8   0   Date of Last Change  
51 AENTIME AENTIME UZEIT TIMS 6   0   Time of Last Change  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_JSBW_PROM AUART TJAK AUART REF 1 CN
2 V_JSBW_PROM CYCLENR_BASE JKACCOUNT CYCLENR REF C CN
3 V_JSBW_PROM DRERZ JDTDRER DRERZ REF C CN
4 V_JSBW_PROM EVENT TJKEVENT EVENT REF C CN
5 V_JSBW_PROM GPRECH JGTGPNR GPNR REF C CN
6 V_JSBW_PROM KONTAKTNR JWTWEKO KONTAKTNR REF C CN
7 V_JSBW_PROM KUENDGRD TJK83 KUENDGRD REF C CN
8 V_JSBW_PROM LIEFUMXEIN T006 MSEHI REF C CN
9 V_JSBW_PROM MANDT T000 MANDT KEY 1 CN
10 V_JSBW_PROM MINDBEZEIN T006 MSEHI REF C CN
11 V_JSBW_PROM POART TJAP POART REF 1 CN
12 V_JSBW_PROM POSNR_BASE JKAP POSNR KEY 1 CN
13 V_JSBW_PROM POSNR_MAIN JKAP POSNR REF C CN
14 V_JSBW_PROM POSNR_SUB JKAP POSNR REF C CN
15 V_JSBW_PROM POSNR_UR JKAP POSNR REF 1 CN
16 V_JSBW_PROM POSNR_VG JKAP POSNR REF 1 CN
17 V_JSBW_PROM POSNR_VL JKAP POSNR REF C CN
18 V_JSBW_PROM PVA JDTPVA PVA REF C CN
19 V_JSBW_PROM VBELN_VL JKAK VBELN REF C CN
20 V_JSBW_PROM VSGRCHEUR JGTVSG VERSERVGES REF C CN
21 V_JSBW_PROM WERBEAKT TJWAK WERBEAKT REF C CN
22 V_JSBW_PROM WERBEART TJWAR WERBEART REF C CN
History
Last changed by/on SAP  20110901 
SAP Release Created in