SAP ABAP View JPVIM_BW_B (IS-M/PLM: BW IM Transaction Data)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JMM (Package) IS-M(edia) Development - Product Master Data

Basic Data

View Type	D	Database View
Database View	JPVIM_BW_B
Short Description	IS-M/PLM: BW IM Transaction Data
Root table	IMAK	Appropriation requests - general data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	IMAK	IMAK
2	IMAV
3	CKIS
4	CKHS

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	IMAK	MANDT	JL	EQ				0	0
2	IMAV	MANDT	JR	EQ			AND	0	0
3	IMAK	POSNR	JL	EQ				0	0
4	IMAV	POSNR	JR	EQ			AND	0	0
5	IMAV	MANDT	JL	EQ				0	0
6	CKHS	MANDT	JR	EQ			AND	0	0
7	IMAV	KALNR	JL	EQ				0	0
8	CKHS	KALNR	JR	EQ			AND	0	0
9	CKHS	MANDT	JL	EQ				0	0
10	CKIS	MANDT	JR	EQ			AND	0	0
11	CKHS	KALNR	JL	EQ				0	0
12	CKIS	KALNR	JR	EQ			AND	0	0
13	CKIS	BZOBJ		EQ	'I'		AND	0	0
14	CKIS	TYPPS		NE	'S'		AND	0	0
15	CKIS	TYPPS		NE	'U'		AND	0	0
16	CKIS	VTKNZ		NE	'X'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	IMAK	MANDT		☐	MANDT	☐	Client
2	POSNR	IMAK	POSNR		☐	IMA_POSNR	☐	Internal number for appropriation request
3	IVART	IMAK	IVART		☐	IMA_IVART	☐	Appropriation request type
4	POSID	IMAK	POSID		☐	IMA_POSID	☐	Appropriation Request Number (Formatted for Coding Mask)
5	OBJNR	IMAK	OBJNR		☐	J_OBJNR	☐	Object number
6	VKOKRS	IMAK	VKOKRS		☐	IMA_VKOKRS	☐	Responsible controlling area
7	VBUKRS	IMAK	VBUKRS		☐	IMA_VBUKRS	☐	Responsible company code
8	WERKS_IM	IMAK	WERKS		☐	WERKS_D	☐	Plant
9	VGSBER	IMAK	VGSBER		☐	IMA_VGSBER	☐	Responsible business area
10	PSPNR_IM	IMAK	PSPNR		☐	IMA_PSPNR	☐	Internal sequence number of project for approp. request
11	GDATU	IMAK	GDATU		☐	IMA_GDATU	☐	Planned approval date for appropriation request
12	GJAHR	IMAK	GJAHR		☐	IMA_GJAHR	☐	Approval year for appropriation request
13	OBJNR_IM	IMAV	OBJNR		☐	J_OBJNR	☐	Object number
14	USR01	IMAK	USR01		☐	IMA_USR01	☐	User field 2 (20 characters)
15	USR02	IMAK	USR02		☐	IMA_USR02	☐	User field 3 (10 characters)
16	USR03	IMAK	USR03		☐	IMA_USR03	☐	User field 4 (10 characters)
17	USR04	IMAK	USR04		☐	IMA_USR04	☐	User field 5 for quantity - IM
18	USE04	IMAK	USE04		☐	IMA_USE04	☐	User field 5 for unit for quantity field 5 - IM
19	USR05	IMAK	USR05		☐	IMA_USR05	☐	User field 6 for quantity - IM
20	USE05	IMAK	USE05		☐	IMA_USE05	☐	User field 6 for unit of quantity field 6 -IM-
21	USR06	IMAK	USR06		☐	IMA_USR06	☐	User field 7 for values - IM
22	USE06	IMAK	USE06		☐	IMA_USE06	☐	User field 7 for currency for user field 7
23	USR07	IMAK	USR07		☐	IMA_USR07	☐	User field 8 for values - IM
24	USE07	IMAK	USE07		☐	IMA_USE07	☐	User field 8 for currency for user field 8
25	USR08	IMAK	USR08		☐	IMA_USR08	☐	User field 9 as date for IM
26	USR09	IMAK	USR09		☐	IMA_USR09	☐	User field 10 as date for IM
27	USR10	IMAK	USR10		☐	IMA_USR10	☐	User field 11 as indicator for IM reports
28	USR11	IMAK	USR11		☐	IMA_USR11	☐	User field 12 as indicator for IM reports
29	USR12	IMAK	USR12		☐	IMA_USR12	☐	User field 13 for period and fiscal year
30	USR13	IMAK	USR13		☐	IMA_USR13	☐	User field 14 for period and fiscal year
31	VARNT	IMAV	VARNT		☐	IMA_VARNT	☐	Variant of Appropriation Request
32	FDATU	IMAV	FDATU		☐	IMA_FDATU	☐	Desired completion date
33	COPRZ	IMAV	COPRZ		☐	IMA_COPRZ	☐	Part of Plan Values Transferred to Measures
34	LEDNR	CKHS	LEDNR		☐	LEDNR	☐	Ledger for Controlling objects
35	BZOBJ	CKHS	BZOBJ		☐	CK_OBJ	☐	Reference Object
36	KALNR	CKHS	KALNR		☐	CK_KALNR	☐	Cost Estimate Number for Cost Est. w/o Qty Structure
37	KALKA	CKHS	KALKA		☐	CK_KALKA	☐	Costing Type
38	KADKY	CKHS	KADKY		☐	CK_KADKY	☐	Costing Date (Key)
39	TVERS	CKHS	TVERS		☐	CK_TVERS	☐	Costing Version
40	BWVAR	CKHS	BWVAR		☐	CK_BWVAR	☐	Valuation Variant in Costing
41	KKZMA	CKHS	KKZMA		☐	CK_KKZMA	☐	Costs Entered Manually in Additive or Automatic Cost Est.
42	KOKRS	CKHS	KOKRS		☐	KOKRS	☐	Controlling Area
43	AUFNR	CKHS	AUFNR		☐	AUFNR	☐	Order Number
44	KALSM	CKHS	KALSM		☐	AUFKALSM	☐	Costing Sheet
45	TEMPLATE	CKHS	TEMPLATE		☐	ABC_TEMPL	☐	Template
46	CKCM	CKHS	CKCM		☐	CK_COSTMODEL	☐	Costing Model
47	CKCMV	CKHS	CKCMV		☐	CKI_MODELINSTANCE	☐	Costing Model: Model Instance
48	STATP	CKIS	STATP		☐	STATP_D	☐	Item Status
49	TYPPS	CKIS	TYPPS		☐	TYPPS	☐	Item Category
50	KSTAR	CKIS	KSTAR		☐	KSTAR	☐	Cost Element
51	BUKRS	CKIS	BUKRS		☐	BUKRS	☐	Company Code
52	MATNR	CKIS	MATNR		☐	MATNR	☐	Material Number
53	PSCHL	CKIS	PSCHL		☐	PSCHL	☐	Pricing Key
54	KOKRS_HRK	CKIS	KOKRS_HRK		☐	KOKRS_HRK	☐	Origin Controlling Area Item
55	MENGE	CKIS	MENGE		☐	MENGE_POS	☐	Quantity
56	MEEHT	CKIS	MEEHT		☐	MEINS	☐	Base Unit of Measure
57	VTKNZ	CKIS	VTKNZ		☐	VTKNZ	☐	Distribution Indicator
58	LSTAR	CKIS	LSTAR		☐	LSTAR	☐	Activity Type
59	KOSTL	CKIS	KOSTL		☐	KOSTL	☐	Cost Center
60	INFNR	CKIS	INFNR		☐	INFNR	☐	Number of purchasing info record
61	EKORG	CKIS	EKORG		☐	EKORG	☐	Purchasing organization
62	ESOKZ	CKIS	ESOKZ		☐	ESOKZ	☐	Purchasing info record category
63	LIFNR	CKIS	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
64	EBELN	CKIS	EBELN		☐	EBELN	☐	Purchasing Document Number
65	EBELP	CKIS	EBELP		☐	EBELP	☐	Item Number of Purchasing Document
66	STEAS	CKIS	STEAS		☐	CK_STEAS	☐	Target start date of the operation
67	SSEDD	CKIS	SSEDD		☐	SSEDD	☐	Latest scheduled finish: Execution (date)
68	FEHLKZ	CKIS	FEHLKZ		☐	CK_FEHLKZ	☐	Error Indicator
69	UKALN	CKIS	UKALN		☐	CK_UKALN	☐	Cost Estimate Number of Transferred Cost Estimate
70	UKALKA	CKIS	UKALKA		☐	CK_UKALKA	☐	Costing Type of Transferred Cost Estimate
71	UKADKY	CKIS	UKADKY		☐	CK_UKADKY	☐	Date of Transferred Cost Estimate
72	UTVERS	CKIS	UTVERS		☐	CK_UTVERS	☐	Costing Version for Transfer
73	UBWVAR	CKIS	UBWVAR		☐	CK_UBWVAR	☐	Valuation Variant of Transferred Cost Estimate
74	PRCTR	CKIS	PRCTR		☐	PRCTR	☐	Profit Center
75	GSBER	CKIS	GSBER		☐	GSBER	☐	Business Area
76	POSNR_ECP	CKIS	POSNR		☐	CK_POSNR	☐	Unit Costing Line Item Number
77	WERKS	CKIS	WERKS		☐	WERKS_D	☐	Plant
78	PSPNR	CKIS	PSPNR		☐	WB_POSNR	☐	Work Breakdown Structure Element (WBS element)
79	PAROB	CKIS	PAROB		☐	PAROB	☐	Partner Object
80	WERTB	CKIS	WERTB		☐	CK_KWT	☐	Value in Controlling Area Currency
81	WRTFW_KPF	CKIS	WRTFW_KPF		☐	CK_OWT	☐	Value in Object Currency
82	WRTFW_POS	CKIS	WRTFW_POS		☐	CK_TWT	☐	Value in Transaction Currency
83	HWAER	CKHS	HWAER		☐	HWAER	☐	Local Currency
84	FWAER	CKIS	FWAER		☐	CK_TWAER	☐	Transaction Currency
85	FWAER_KPF	CKHS	FWAER		☐	FWAER	☐	Foreign Currency in Header
86	OBJNR_ECP	CKHS	OBJNR		☐	J_OBJNR	☐	Object number

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20110901
SAP Release Created in	471