SAP ABAP Table PICST004 (PIC Structure: IM-MPN MRP Set View with Comparison Flag)

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	PICST004	Table Relationship Diagram
Short Description	PIC Structure: IM-MPN MRP Set View with Comparison Flag

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PICST004	BERID	MDLV	BERID	KEY
2	PICST004	LMATN	MARA	MATNR	KEY
3	PICST004	MANDT	T000	MANDT	KEY
4	PICST004	MATNR	MARA	MATNR		1	CN
5	PICST004	PICCODE	PICIC	PICCODE	REF	C	CN
6	PICST004	WERKS	T001W	WERKS	KEY

History

Last changed by/on	SAP	20050301
SAP Release Created in