SAP ABAP Table MGV_V_PICPS (Generated Table for View MGV_V_PICPS)

Basic Data

Table Category	VIEW	General view structure
General view structure	MGV_V_PICPS	Table Relationship Diagram
Short Description	Generated Table for View MGV_V_PICPS

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	PICNUM	☑	PIC_PICNUM	PIC_PICNUM	CHAR	18	0	Parts Interchangeability Group Number
3	PICKEY	☑	PIC_PICKEY	SYSUUID	RAW	16	0	Part Interchangeability Object Key (GUID)
4	PICCAT	☑	PIC_PICCAT	PIC_PICCAT	CHAR	2	0	Interchangeable parts category
5	PICPOS	☑	PIC_PICPOS	NUMC4	NUMC	4	0	Item Number of Parts Interchangeability Member
6	COUNTER	☑	PIC_COUNTER	NUMC8	NUMC	8	0	Parts Interchangeability Counter (ECM)
7	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
8	LOEKZ	☐	PIC_LOEKZ	XFELD	CHAR	1	0	Parts Interchangeability Member Marked for Deletion
9	SEQNR	☐	PIC_SEQNR	NUMC4	NUMC	4	0	Sequence number of interchangeable part
10	DATFR	☐	PIC_DATFR	DATUM	DATS	8	0	Valid from date of an interchangeable part
11	INTTYPE	☐	PIC_INTTYPE	PIC_INTTYPE	CHAR	1	0	Replacement Type
12	PICCODE	☐	PIC_PICCODE	PIC_PICCODE	CHAR	4	0	Cause of part exchange	PICIC
13	HERDAT	☐	PIC_ERDAT	DATUM	DATS	8	0	Date on Which Record Was Created
14	HERNAM	☐	PIC_ERNAM	USNAM	CHAR	12	0	Name of person who created the object
15	HAEDAT	☐	PIC_AEDAT	DATUM	DATS	8	0	Last Changed On
16	HAENAM	☐	PIC_AENAM	USNAM	CHAR	12	0	Name of person who changed object
17	ERDAT	☐	PIC_ERDAT	DATUM	DATS	8	0	Date on Which Record Was Created
18	ERNAM	☐	PIC_ERNAM	USNAM	CHAR	12	0	Name of person who created the object
19	AEDAT	☐	PIC_AEDAT	DATUM	DATS	8	0	Last Changed On
20	AENAM	☐	PIC_AENAM	USNAM	CHAR	12	0	Name of person who changed object
21	MATNR_EXT	☐	MATNR_EXT	MATNR_EXT	CHAR	40	0	External Long Material Number
22	MATNR_VERS	☐	MATNR_VERS	MATNR_VERS	CHAR	10	0	Material Version Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MGV_V_PICPS	MANDT	T000	MANDT	KEY
2	MGV_V_PICPS	MATNR	MARA	MATNR		1	CN
3	MGV_V_PICPS	PICCODE	PICIC	PICCODE	REF	C	CN

History

Last changed by/on	SAP	20070918
SAP Release Created in