SAP ABAP Table PICST005 (Structure Based on V_PICPSR (Changed Field Sequence))

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	INTTAB	Structure
Structure	PICST005	Table Relationship Diagram
Short Description	Structure Based on V_PICPSR (Changed Field Sequence)

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	PICCAT	☐	PIC_PICCAT	PIC_PICCAT	CHAR	2	0	Interchangeable parts category
3	PICKEY	☐	PIC_PICKEY	SYSUUID	RAW	16	0	Part Interchangeability Object Key (GUID)
4	PICNUM	☐	PIC_PICNUM	PIC_PICNUM	CHAR	18	0	Parts Interchangeability Group Number
5	WERKS	☐	WERKA	WERKS	CHAR	4	0	Plant	*
6	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	*
7	MRPGR	☐	PIC_MRPGR	PIC_MRPGR	CHAR	10	0	Parts interchangeability MPN-MRP set
8	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
9	ERNAM	☐	PIC_ERNAM	USNAM	CHAR	12	0	Name of person who created the object
10	AEDAT	☐	PIC_AEDAT	DATUM	DATS	8	0	Last Changed On
11	AENAM	☐	PIC_AENAM	USNAM	CHAR	12	0	Name of person who changed object
12	PICPOS	☐	PIC_PICPOS	NUMC4	NUMC	4	0	Item Number of Parts Interchangeability Member
13	COUNTER	☐	PIC_COUNTER	NUMC8	NUMC	8	0	Parts Interchangeability Counter (ECM)
14	LOEKZ	☐	PIC_LOEKZ	XFELD	CHAR	1	0	Parts Interchangeability Member Marked for Deletion
15	SEQNR	☐	PIC_SEQNR	NUMC4	NUMC	4	0	Sequence number of interchangeable part
16	DATFR	☐	PIC_DATFR	DATUM	DATS	8	0	Valid from date of an interchangeable part
17	INTTYPE	☐	PIC_INTTYPE	PIC_INTTYPE	CHAR	1	0	Replacement Type
18	PICCODE	☐	PIC_PICCODE	PIC_PICCODE	CHAR	4	0	Cause of part exchange	PICIC
19	DERDAT	☐	PIC_ERDAT	DATUM	DATS	8	0	Date on Which Record Was Created
20	DERNAM	☐	PIC_ERNAM	USNAM	CHAR	12	0	Name of person who created the object
21	DAEDAT	☐	PIC_AEDAT	DATUM	DATS	8	0	Last Changed On
22	DAENAM	☐	PIC_AENAM	USNAM	CHAR	12	0	Name of person who changed object
23	PICGID	☐	PIC_PICGID	NUMC8	NUMC	8	0	Generic Identifier for Plant/MRP Area (Parts Interchang.)
24	LMATN	☐	PIC_LMATN	MATNR	CHAR	18	0	Leading part number for MRP set	*
25	RDATFR	☐	PIC_DATFR	DATUM	DATS	8	0	Valid from date of an interchangeable part
26	SPERKZ	☐	PIC_SPERKZ	PIC_SPERKZ	CHAR	1	0	Block Indicator for Parts Interchangeability
27	RERDAT	☐	PIC_ERDAT	DATUM	DATS	8	0	Date on Which Record Was Created
28	RERNAM	☐	PIC_ERNAM	USNAM	CHAR	12	0	Name of person who created the object
29	RAEDAT	☐	PIC_AEDAT	DATUM	DATS	8	0	Last Changed On
30	RAENAM	☐	PIC_AENAM	USNAM	CHAR	12	0	Name of person who changed object
31	MATNR_EXT	☐	MATNR_EXT	MATNR_EXT	CHAR	40	0	External Long Material Number
32	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	PICST005	MANDT	T000	MANDT	KEY
2	PICST005	MATNR	MARA	MATNR		1	CN
3	PICST005	PICCODE	PICIC	PICCODE	KEY	1	CN

History

Last changed by/on	SAP	20050301
SAP Release Created in