SAP ABAP View JPVPS_BW_B (IS-M/PLM: BW PS 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	JPVPS_BW_B
Short Description	IS-M/PLM: BW PS Transaction Data
Root table	PRPS	WBS (Work Breakdown Structure) Element Master Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	PRPS	PRPS
2	CKHS
3	CKIS

Join Conditions

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	PSPNR_PS	PRPS	PSPNR		☐	PS_POSNR	☐	WBS Element
2	OBJNR	PRPS	OBJNR		☐	J_OBJNR	☐	Object number
3	USR00	PRPS	USR00		☐	USR00PRPS	☐	1st user field for 20 characters - WBS element-
4	USR01	PRPS	USR01		☐	USR01PRPS	☐	2nd user field 20 digits - WBS element
5	USR02	PRPS	USR02		☐	USR02PRPS	☐	3rd user-defined field 10 digits -WBS element
6	USR03	PRPS	USR03		☐	USR03PRPS	☐	4th user-defined field 10 digits -WBS element
7	USR04	PRPS	USR04		☐	USR04PRPS	☐	1st user-defined field for quantity(length 10,3) WBS element
8	USE04	PRPS	USE04		☐	USE04PRPS	☐	1st user defined field for quantity field unit - WBS element
9	USR05	PRPS	USR05		☐	USR05PRPS	☐	2nd use field for quantity (length 10,3) WBS element
10	USE05	PRPS	USE05		☐	USE05PRPS	☐	2nd user defined field for quantity field unit - WBS element
11	USR06	PRPS	USR06		☐	USR06PRPS	☐	1st user field for values (length 10,3) WBS element
12	USE06	PRPS	USE06		☐	USE06PRPS	☐	1st user defined field for value field unit - WBS element
13	USR07	PRPS	USR07		☐	USR07PRPS	☐	2nd user field for values (length 10,3) -WBS element
14	USE07	PRPS	USE07		☐	USE07PRPS	☐	2nd user defined field for value field unit - WBS element
15	USR08	PRPS	USR08		☐	USR08PRPS	☐	1st user field for date -WBS element
16	USR09	PRPS	USR09		☐	USR09PRPS	☐	2nd user field for date -WBS element
17	USR10	PRPS	USR10		☐	USR10PRPS	☐	1st user field for 'Ind. for evaluations' WBS elem.
18	USR11	PRPS	USR11		☐	USR11PRPS	☐	2nd user field for 'Indicator for eval.s' WBS elemnt
19	LEDNR	CKHS	LEDNR		☐	LEDNR	☐	Ledger for Controlling objects
20	BZOBJ	CKHS	BZOBJ		☐	CK_OBJ	☐	Reference Object
21	KALNR	CKHS	KALNR		☐	CK_KALNR	☐	Cost Estimate Number for Cost Est. w/o Qty Structure
22	KALKA	CKHS	KALKA		☐	CK_KALKA	☐	Costing Type
23	KADKY	CKHS	KADKY		☐	CK_KADKY	☐	Costing Date (Key)
24	TVERS	CKHS	TVERS		☐	CK_TVERS	☐	Costing Version
25	BWVAR	CKHS	BWVAR		☐	CK_BWVAR	☐	Valuation Variant in Costing
26	KKZMA	CKHS	KKZMA		☐	CK_KKZMA	☐	Costs Entered Manually in Additive or Automatic Cost Est.
27	KOKRS	CKHS	KOKRS		☐	KOKRS	☐	Controlling Area
28	AUFNR	CKHS	AUFNR		☐	AUFNR	☐	Order Number
29	KALSM	CKHS	KALSM		☐	AUFKALSM	☐	Costing Sheet
30	TEMPLATE	CKHS	TEMPLATE		☐	ABC_TEMPL	☐	Template
31	CKCM	CKHS	CKCM		☐	CK_COSTMODEL	☐	Costing Model
32	CKCMV	CKHS	CKCMV		☐	CKI_MODELINSTANCE	☐	Costing Model: Model Instance
33	POSNR	CKIS	POSNR		☐	CK_POSNR	☐	Unit Costing Line Item Number
34	STATP	CKIS	STATP		☐	STATP_D	☐	Item Status
35	TYPPS	CKIS	TYPPS		☐	TYPPS	☐	Item Category
36	KSTAR	CKIS	KSTAR		☐	KSTAR	☐	Cost Element
37	BUKRS	CKIS	BUKRS		☐	BUKRS	☐	Company Code
38	MATNR	CKIS	MATNR		☐	MATNR	☐	Material Number
39	PSCHL	CKIS	PSCHL		☐	PSCHL	☐	Pricing Key
40	KOKRS_HRK	CKIS	KOKRS_HRK		☐	KOKRS_HRK	☐	Origin Controlling Area Item
41	MENGE	CKIS	MENGE		☐	MENGE_POS	☐	Quantity
42	MEEHT	CKIS	MEEHT		☐	MEINS	☐	Base Unit of Measure
43	VTKNZ	CKIS	VTKNZ		☐	VTKNZ	☐	Distribution Indicator
44	LSTAR	CKIS	LSTAR		☐	LSTAR	☐	Activity Type
45	KOSTL	CKIS	KOSTL		☐	KOSTL	☐	Cost Center
46	INFNR	CKIS	INFNR		☐	INFNR	☐	Number of purchasing info record
47	EKORG	CKIS	EKORG		☐	EKORG	☐	Purchasing organization
48	LIFNR	CKIS	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
49	EBELN	CKIS	EBELN		☐	EBELN	☐	Purchasing Document Number
50	EBELP	CKIS	EBELP		☐	EBELP	☐	Item Number of Purchasing Document
51	STEAS	CKIS	STEAS		☐	CK_STEAS	☐	Target start date of the operation
52	SSEDD	CKIS	SSEDD		☐	SSEDD	☐	Latest scheduled finish: Execution (date)
53	FEHLKZ	CKIS	FEHLKZ		☐	CK_FEHLKZ	☐	Error Indicator
54	UKALN	CKIS	UKALN		☐	CK_UKALN	☐	Cost Estimate Number of Transferred Cost Estimate
55	UKALKA	CKIS	UKALKA		☐	CK_UKALKA	☐	Costing Type of Transferred Cost Estimate
56	UKADKY	CKIS	UKADKY		☐	CK_UKADKY	☐	Date of Transferred Cost Estimate
57	UTVERS	CKIS	UTVERS		☐	CK_UTVERS	☐	Costing Version for Transfer
58	UBWVAR	CKIS	UBWVAR		☐	CK_UBWVAR	☐	Valuation Variant of Transferred Cost Estimate
59	GSBER	CKIS	GSBER		☐	GSBER	☐	Business Area
60	PAROB	CKIS	PAROB		☐	PAROB	☐	Partner Object
61	PSPHI	PRPS	PSPHI		☐	PS_PSPHI	☐	Current number of the appropriate project
62	POSNR_ECP	CKIS	POSNR		☐	CK_POSNR	☐	Unit Costing Line Item Number
63	WERKS	CKIS	WERKS		☐	WERKS_D	☐	Plant
64	PRCTR	CKIS	PRCTR		☐	PRCTR	☐	Profit Center
65	PSPNR	CKIS	PSPNR		☐	WB_POSNR	☐	Work Breakdown Structure Element (WBS element)
66	WERTB	CKIS	WERTB		☐	CK_KWT	☐	Value in Controlling Area Currency
67	WRTFW_KPF	CKIS	WRTFW_KPF		☐	CK_OWT	☐	Value in Object Currency
68	WRTFW_POS	CKIS	WRTFW_POS		☐	CK_TWT	☐	Value in Transaction Currency
69	HWAER	CKHS	HWAER		☐	HWAER	☐	Local Currency
70	FWAER	CKIS	FWAER		☐	CK_TWAER	☐	Transaction Currency
71	FWAER_KPF	CKHS	FWAER		☐	FWAER	☐	Foreign Currency in Header
72	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	20130529
SAP Release Created in	471