SAP ABAP View V_PKSS (PKPS Selection with PKHD and PVBE)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MD05 (Package) Development class KANBAN

Basic Data

View Type	D	Database View
Database View	V_PKSS
Short Description	PKPS Selection with PKHD and PVBE
Root table	PKPS	Control Cycle Item / Kanban

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	PKPS	PKPS
2	PKHD
3	PVBE

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	PKHD	MANDT	JL	EQ				0	0
2	PKPS	MANDT	JR	EQ			AND	0	0
3	PKHD	PKNUM	JL	EQ				0	0
4	PKPS	PKNUM	JR	EQ			AND	0	0
5	PVBE	MANDT	JL	EQ				0	0
6	PKHD	MANDT	JR	EQ			AND	0	0
7	PVBE	WERKS	JL	EQ				0	0
8	PKHD	WERKS	JR	EQ			AND	0	0
9	PVBE	PRVBE	JL	EQ				0	0
10	PKHD	PRVBE	JR	EQ			AND	0	0
11	PKPS	PKLKZ		NE	'X'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	PKPS	*		☐		☐
2	MANDT	PKPS	MANDT		☐	MANDT	☐	Client
3	PKKEY	PKPS	PKKEY		☐	PKKEY	☐	Identification Number
4	PKNUM	PKPS	PKNUM		☐	PKNUM	☐	Control cycle number
5	PKPOS	PKPS	PKPOS		☐	PKPOS	☐	Kanban item number / control cycle item
6	PKBST	PKPS	PKBST		☐	PKBST	☐	Kanban status
7	PKIMG	PKPS	PKIMG		☐	PKIMG	☐	Actual quantity
8	SAEDT	PKPS	SAEDT		☐	SAEDT	☐	Date of last change
9	SAEUZ	PKPS	SAEUZ		☐	SAEUZ	☐	Time of the last status change
10	SADT2	PKPS	SADT2		☐	SAEDT	☐	Date of last change
11	SAUZ2	PKPS	SAUZ2		☐	SAEUZ	☐	Time of the last status change
12	PLNUM	PKPS	PLNUM		☐	PLNUM	☐	Planned order number
13	AUFNR	PKPS	AUFNR		☐	AUFNR	☐	Order Number
14	POSNR	PKPS	POSNR		☐	CO_POSNR	☐	Order item number
15	EBELN	PKPS	EBELN		☐	EBELN	☐	Purchasing Document Number
16	EBELP	PKPS	EBELP		☐	EBELP	☐	Item Number of Purchasing Document
17	ETENR	PKPS	ETENR		☐	EETEN	☐	Delivery Schedule Line Counter
18	RSNUM	PKPS	RSNUM		☐	RSNUM	☐	Number of reservation/dependent requirements
19	RSPOS	PKPS	RSPOS		☐	RSPOS	☐	Item Number of Reservation / Dependent Requirements
20	TBNUM	PKPS	TBNUM		☐	TBNUM	☐	Transfer Requirement Number
21	TBPOS	PKPS	TBPOS		☐	TBPOS	☐	Transfer Requirement Item
22	SPKKZ	PKPS	SPKKZ		☐	SPKKZ	☐	Blocking indicator for kanban container
23	MBLNR	PKPS	MBLNR		☐	MBLNR	☐	Number of Material Document
24	MBLPO	PKPS	MBLPO		☐	MBLPO	☐	Item in material document
25	PKLKZ	PKPS	PKLKZ		☐	PKLKZ	☐	Deletion Indicator for a Kanban
26	PKBMG	PKPS	PKBMG		☐	PKBMG	☐	Quantity requested
27	PKBSA	PKPS	PKBSA		☐	PKBSA	☐	Previous kanban status
28	PABNUM	PKPS	PABNUM		☐	PABNUM	☐	JIT Call Number
29	PABPOS	PKPS	PABPOS		☐	PABPOS	☐	JIT call item
30	PKGPZG	PKPS	PKGPZG		☐	PKGPZG	☐	Planned Receipt
31	HDFLG	PKPS	HDFLG		☐	HDFLG	☐	Indicator: Changed Control Cycle Data Available for Kanban
32	ETENS	PKPS	ETENS		☐	ETENS	☐	Sequential Number of Vendor Confirmation
33	ZPUNKT	PKPS	ZPUNKT		☐	SA_ZPUNKT	☐	Reporting Point
34	PRTNR	PKPS	PRTNR		☐	PRTNR	☐	Confirmation number
35	VBELN	PKPS	VBELN		☐	VBELN	☐	Sales and Distribution Document Number
36	VBELP	PKPS	VBELP		☐	POSNR	☐	Item number of the SD document
37	MATNR	PKHD	MATNR		☐	MATNR	☐	Material Number
38	LGORT	PVBE	LGORT		☐	LGORT_D	☐	Storage location

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	600