1. Home
  2. Resources
  3. SAP Tables
  4. PICST004 - PIC Structure: IM-MPN MRP Set View with Comparison Flag

SAP Table PICST004

PIC Structure: IM-MPN MRP Set View with Comparison Flag

PICST004 (PIC Structure: IM-MPN MRP Set View with Comparison Flag) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link PICST004 to other SAP tables.

PICST004 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PICKEY Part Interchangeability Object Key (GUID) PIC_PICKEY RAW 16 0
PICCAT Interchangeable parts category PIC_PICCAT CHAR 2 0
01 Interchangeability for Supersession
02 Interchangeability for Inventory-Managed MPN
03 IM-MPN Restricted Interchangeability
99 Freely-Defined Interchangeability
98 Manually Defined Interchangeability
PICNUM Parts Interchangeability Group Number PIC_PICNUM CHAR 18 0
ERDAT Date on Which Record Was Created PIC_ERDAT DATS 8 0
ERNAM Name of person who created the object PIC_ERNAM CHAR 12 0
AEDAT Last Changed On PIC_AEDAT DATS 8 0
AENAM Name of person who changed object PIC_AENAM CHAR 12 0
PICPOS Item Number of Parts Interchangeability Member PIC_PICPOS NUMC 4 0
COUNTER Parts Interchangeability Counter (ECM) PIC_COUNTER NUMC 8 0
MATNR Material Number MATNR MARA CHAR 18 0
LOEKZ Parts Interchangeability Member Marked for Deletion PIC_LOEKZ CHAR 1 0
X Yes
NULL No
SEQNR Sequence number of interchangeable part PIC_SEQNR NUMC 4 0
DATFR Valid from date of an interchangeable part PIC_DATFR DATS 8 0
INTTYPE Replacement Type PIC_INTTYPE CHAR 1 0
F Forward
I Interchangeable
PICCODE Cause of part exchange PIC_PICCODE PICIC CHAR 4 0
DERDAT Date on Which Record Was Created PIC_ERDAT DATS 8 0
DERNAM Name of person who created the object PIC_ERNAM CHAR 12 0
DAEDAT Last Changed On PIC_AEDAT DATS 8 0
DAENAM Name of person who changed object PIC_AENAM CHAR 12 0
PICGID Generic Identifier for Plant/MRP Area (Parts Interchang.) PIC_PICGID NUMC 8 0
WERKS Plant WERKA T001W CHAR 4 0
BERID MRP Area BERID MDLV CHAR 10 0
MRPGR Parts interchangeability MPN-MRP set PIC_MRPGR CHAR 10 0
LMATN Leading part number for MRP set PIC_LMATN MARA CHAR 18 0
RDATFR Valid from date of an interchangeable part PIC_DATFR DATS 8 0
SPERKZ Block Indicator for Parts Interchangeability PIC_SPERKZ CHAR 1 0
RERDAT Date on Which Record Was Created PIC_ERDAT DATS 8 0
RERNAM Name of person who created the object PIC_ERNAM CHAR 12 0
RAEDAT Last Changed On PIC_AEDAT DATS 8 0
RAENAM Name of person who changed object PIC_AENAM CHAR 12 0
MRPSET Indicator: MRP set comparison MRPSET NUMC 1 0
1 Same MRP set
2 Alternative MRP set
3 No MRP set maintained
4 MRP set not determinable
5 MRP Set Is Not Unique
6 Locked in MRP Set

PICST004 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PICST004 BERID PICST004 MANDT MDLV Customizing MRP Area MANDT
PICST004 BERID PICST004 BERID MDLV Customizing MRP Area BERID
PICST004 LMATN PICST004 MANDT MARA General Material Data MANDT
PICST004 LMATN PICST004 LMATN MARA General Material Data MATNR
PICST004 MANDT PICST004 MANDT T000 Clients MANDT
PICST004 MATNR PICST004 MANDT MARA General Material Data MANDT
PICST004 MATNR PICST004 MATNR MARA General Material Data MATNR
PICST004 PICCODE PICST004 PICCODE PICIC Parts Interchangeability Code PICCODE
PICST004 PICCODE * PICIC Parts Interchangeability Code PICCAT
PICST004 PICCODE PICST004 MANDT PICIC Parts Interchangeability Code MANDT
PICST004 WERKS PICST004 MANDT T001W Plants/Branches MANDT
PICST004 WERKS PICST004 WERKS T001W Plants/Branches WERKS