SAP ABAP Table JPVIM_BW_B (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure JPVIM_BW_B   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  
2 POSNR IMA_POSNR IMA_POSNR CHAR 12   0   Internal number for appropriation request  
3 IVART IMA_IVART IMA_IVART CHAR 2   0   Appropriation request type TAIF1
4 POSID IMA_POSID IMA_POSID CHAR 24   0   Appropriation Request Number (Formatted for Coding Mask)  
5 OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number ONR00
6 VKOKRS IMA_VKOKRS CACCD CHAR 4   0   Responsible controlling area TKA01
7 VBUKRS IMA_VBUKRS BUKRS CHAR 4   0   Responsible company code T001
8 WERKS_IM WERKS_D WERKS CHAR 4   0   Plant T001W
9 VGSBER IMA_VGSBER GSBER CHAR 4   0   Responsible business area TGSB
10 PSPNR_IM IMA_PSPNR PS_PSPNR NUMC 8   0   Internal sequence number of project for approp. request PROJ
11 GDATU IMA_GDATU DATUM DATS 8   0   Planned approval date for appropriation request  
12 GJAHR IMA_GJAHR GJAHR NUMC 4   0   Approval year for appropriation request  
13 OBJNR_IM J_OBJNR J_OBJNR CHAR 22   0   Object number ONR00
14 USR01 IMA_USR01 USRCHAR20 CHAR 20   0   User field 2 (20 characters)  
15 USR02 IMA_USR02 IMA_USRCHAR10 CHAR 10   0   User field 3 (10 characters) TAIF9
16 USR03 IMA_USR03 IMA_USRCHAR10 CHAR 10   0   User field 4 (10 characters) TAIF9
17 USR04 IMA_USR04 USRQUAN13 QUAN 13   3   User field 5 for quantity - IM  
18 USE04 IMA_USE04 MEINS UNIT 3   0   User field 5 for unit for quantity field 5 - IM T006
19 USR05 IMA_USR05 USRQUAN13 QUAN 13   3   User field 6 for quantity - IM  
20 USE05 IMA_USE05 MEINS UNIT 3   0   User field 6 for unit of quantity field 6 -IM- T006
21 USR06 IMA_USR06 USRCURR13 CURR 13   3   User field 7 for values - IM  
22 USE06 IMA_USE06 WAERS CUKY 5   0   User field 7 for currency for user field 7 TCURC
23 USR07 IMA_USR07 USRCURR13 CURR 13   3   User field 8 for values - IM  
24 USE07 IMA_USE07 WAERS CUKY 5   0   User field 8 for currency for user field 8 TCURC
25 USR08 IMA_USR08 USRDATE DATS 8   0   User field 9 as date for IM  
26 USR09 IMA_USR09 USRDATE DATS 8   0   User field 10 as date for IM  
27 USR10 IMA_USR10 XFELD CHAR 1   0   User field 11 as indicator for IM reports  
28 USR11 IMA_USR11 XFELD CHAR 1   0   User field 12 as indicator for IM reports  
29 USR12 IMA_USR12 USRPER ACCP 6   0   User field 13 for period and fiscal year  
30 USR13 IMA_USR13 USRPER ACCP 6   0   User field 14 for period and fiscal year  
31 VARNT IMA_VARNT IMA_VARNT CHAR 4   0   Variant of Appropriation Request  
32 FDATU IMA_FDATU DATUM DATS 8   0   Desired completion date  
33 COPRZ IMA_COPRZ DEC03 DEC 3   0   Part of Plan Values Transferred to Measures  
34 LEDNR LEDNR LEDNR CHAR 2   0   Ledger for Controlling objects  
35 BZOBJ CK_OBJ CK_OBJ CHAR 1   0   Reference Object  
36 KALNR CK_KALNR CK_KALNR NUMC 12   0   Cost Estimate Number for Cost Est. w/o Qty Structure  
37 KALKA CK_KALKA CK_KALKA CHAR 2   0   Costing Type  
38 KADKY CK_KADKY CK_KADAT DATS 8   0   Costing Date (Key)  
39 TVERS CK_TVERS CK_VERSION NUMC 2   0   Costing Version  
40 BWVAR CK_BWVAR CK_BWVAR CHAR 3   0   Valuation Variant in Costing  
41 KKZMA CK_KKZMA XFELD CHAR 1   0   Costs Entered Manually in Additive or Automatic Cost Est.  
42 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
43 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
44 KALSM AUFKALSM KALSM CHAR 6   0   Costing Sheet  
45 TEMPLATE ABC_TEMPL ABC_TEMPL CHAR 10   0   Template  
46 CKCM CK_COSTMODEL ABC_TEMPL CHAR 10   0   Costing Model CKCM
47 CKCMV CKI_MODELINSTANCE CKI_MODELINSTANCE NUMC 15   0   Costing Model: Model Instance CKCMV
48 STATP STATP_D STATE CHAR 4   0   Item Status  
49 TYPPS TYPPS TYPPS CHAR 1   0   Item Category  
50 KSTAR KSTAR KSTAR CHAR 10   0   Cost Element  
51 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
52 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
53 PSCHL PSCHL CHAR18 CHAR 18   0   Pricing Key  
54 KOKRS_HRK KOKRS_HRK CACCD CHAR 4   0   Origin Controlling Area Item TKA01
55 MENGE MENGE_POS CQUA8 QUAN 15   3   Quantity  
56 MEEHT MEINS MEINS UNIT 3   0   Base Unit of Measure T006
57 VTKNZ VTKNZ YNFLG CHAR 1   0   Distribution Indicator  
58 LSTAR LSTAR LSTAR CHAR 6   0   Activity Type  
59 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center  
60 INFNR INFNR INFNR CHAR 10   0   Number of purchasing info record EINA
61 EKORG EKORG EKORG CHAR 4   0   Purchasing organization  
62 ESOKZ ESOKZ ESOKZ CHAR 1   0   Purchasing info record category  
63 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor  
64 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number  
65 EBELP EBELP EBELP NUMC 5   0   Item Number of Purchasing Document  
66 STEAS CK_STEAS CK_DATUM DATS 8   0   Target start date of the operation  
67 SSEDD SSEDD DATUM DATS 8   0   Latest scheduled finish: Execution (date)  
68 FEHLKZ CK_FEHLKZ XFELD CHAR 1   0   Error Indicator  
69 UKALN CK_UKALN CK_KALNR NUMC 12   0   Cost Estimate Number of Transferred Cost Estimate  
70 UKALKA CK_UKALKA CK_KALKA CHAR 2   0   Costing Type of Transferred Cost Estimate  
71 UKADKY CK_UKADKY CK_KADAT DATS 8   0   Date of Transferred Cost Estimate  
72 UTVERS CK_UTVERS CK_VERSION NUMC 2   0   Costing Version for Transfer  
73 UBWVAR CK_UBWVAR CK_BWVAR CHAR 3   0   Valuation Variant of Transferred Cost Estimate  
74 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center  
75 GSBER GSBER GSBER CHAR 4   0   Business Area  
76 POSNR_ECP CK_POSNR CK_POSNR NUMC 5   0   Unit Costing Line Item Number  
77 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
78 PSPNR WB_POSNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS element)  
79 PAROB PAROB J_OBJNR CHAR 22   0   Partner Object  
80 WERTB CK_KWT WERTV8 CURR 15   2   Value in Controlling Area Currency  
81 WRTFW_KPF CK_OWT WERTV8 CURR 15   2   Value in Object Currency  
82 WRTFW_POS CK_TWT WERTV8 CURR 15   2   Value in Transaction Currency  
83 HWAER HWAER WAERS CUKY 5   0   Local Currency TCURC
84 FWAER CK_TWAER WAERS CUKY 5   0   Transaction Currency TCURC
85 FWAER_KPF FWAER WAERS CUKY 5   0   Foreign Currency in Header TCURC
86 OBJNR_ECP J_OBJNR J_OBJNR CHAR 22   0   Object number ONR00
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 JPVIM_BW_B AUFNR AUFK AUFNR REF 1 CN
2 JPVIM_BW_B BUKRS T001 BUKRS REF 1 CN
3 JPVIM_BW_B CKCM CKCM MODEL    
4 JPVIM_BW_B CKCMV CKCMV MODEL_VAL    
5 JPVIM_BW_B FWAER TCURC WAERS REF 1 CN
6 JPVIM_BW_B FWAER_KPF TCURC WAERS REF 1 CN
7 JPVIM_BW_B HWAER TCURC WAERS REF 1 CN
8 JPVIM_BW_B INFNR EINA INFNR REF 1 CN
9 JPVIM_BW_B IVART TAIF1 IVART REF 1 N
10 JPVIM_BW_B KOKRS TKA01 KOKRS REF 1 CN
11 JPVIM_BW_B KOKRS_HRK TKA01 KOKRS REF 1 CN
12 JPVIM_BW_B MATNR MARA MATNR REF 1 CN
13 JPVIM_BW_B MEEHT T006 MSEHI REF 1 CN
14 JPVIM_BW_B OBJNR ONR00 OBJNR KEY 1 1
15 JPVIM_BW_B OBJNR_ECP ONR00 OBJNR REF 1 CN
16 JPVIM_BW_B OBJNR_IM ONR00 OBJNR REF 1 1
17 JPVIM_BW_B PSPNR_IM PROJ PSPNR REF 1 C
18 JPVIM_BW_B USE04 T006 MSEHI REF 1 CN
19 JPVIM_BW_B USE05 T006 MSEHI REF 1 CN
20 JPVIM_BW_B USE06 TCURC WAERS REF 1 CN
21 JPVIM_BW_B USE07 TCURC WAERS REF 1 CN
22 JPVIM_BW_B USR02 TAIF9 USR02 REF 1 CN
23 JPVIM_BW_B USR03 TAIF9 USR02 REF 1 CN
24 JPVIM_BW_B VBUKRS T001 BUKRS REF 1 CN
25 JPVIM_BW_B VGSBER TGSB GSBER REF 1 CN
26 JPVIM_BW_B VKOKRS TKA01 KOKRS REF 1 CN
27 JPVIM_BW_B WERKS T001W WERKS REF 1 CN
28 JPVIM_BW_B WERKS_IM T001W WERKS REF 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in