SAP ABAP Table PICPS (Parts Interchangeability Item (SuS+MPN))

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-A-SUS (Application Component) Supersession Chains
     ⤷ ISAUTO_PIC (Package) Substitutions of Parts (Supersession and MPN)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PICPS	Table Relationship Diagram
Short Description	Parts Interchangeability Item (SuS+MPN)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	PICKEY	☑	PIC_PICKEY	SYSUUID	RAW	16	0	Part Interchangeability Object Key (GUID)	PICHD
3	PICPOS	☑	PIC_PICPOS	NUMC4	NUMC	4	0	Item Number of Parts Interchangeability Member
4	COUNTER	☑	PIC_COUNTER	NUMC8	NUMC	8	0	Parts Interchangeability Counter (ECM)
5	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
6	LOEKZ	☐	PIC_LOEKZ	XFELD	CHAR	1	0	Parts Interchangeability Member Marked for Deletion
7	SEQNR	☐	PIC_SEQNR	NUMC4	NUMC	4	0	Sequence number of interchangeable part
8	DATFR	☐	PIC_DATFR	DATUM	DATS	8	0	Valid from date of an interchangeable part
9	INTTYPE	☐	PIC_INTTYPE	PIC_INTTYPE	CHAR	1	0	Replacement Type
10	PICCODE	☐	PIC_PICCODE	PIC_PICCODE	CHAR	4	0	Cause of part exchange	PICIC
11	ERDAT	☐	PIC_ERDAT	DATUM	DATS	8	0	Date on Which Record Was Created
12	ERNAM	☐	PIC_ERNAM	USNAM	CHAR	12	0	Name of person who created the object
13	AEDAT	☐	PIC_AEDAT	DATUM	DATS	8	0	Last Changed On
14	AENAM	☐	PIC_AENAM	USNAM	CHAR	12	0	Name of person who changed object

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PICPS	MANDT	T000	MANDT	KEY
2	PICPS	MATNR	MARA	MATNR		1	CN
3	PICPS	PICCODE	PICIC	PICCODE	REF	C	CN
4	PICPS	PICKEY	PICHD	PICKEY	KEY	1	N

History

Last changed by/on	SAP	20050301
SAP Release Created in