SAP table PICPS (Parts Interchangeability Item (SuS+MPN))

SAP table PICPS has 4 primary key fields being MANDT,PICKEY,PICPOS,COUNTER.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PICKEY Part Interchangeability Object Key (GUID) RAW 16 0 PICHD PIC_PICKEY
PICPOS Item Number of Parts Interchangeability Member NUMC 4 0 PIC_PICPOS
COUNTER Parts Interchangeability Counter (ECM) NUMC 8 0 PIC_COUNTER
MATNR Material Number CHAR 40 0 MARA MATNR
LOEKZ Parts Interchangeability Member Marked for Deletion CHAR 1 0 PIC_LOEKZ
SEQNR Sequence number of interchangeable part NUMC 4 0 PIC_SEQNR
DATFR Valid from date of an interchangeable part DATS 8 0 PIC_DATFR
INTTYPE Replacement Type CHAR 1 0 PIC_INTTYPE
F Forward
I Interchangeable
PICCODE Cause of part exchange CHAR 4 0 PICIC PIC_PICCODE
ERDAT Date on Which Record Was Created DATS 8 0 PIC_ERDAT
ERNAM Name of person who created the object CHAR 12 0 PIC_ERNAM
AEDAT Last Changed On DATS 8 0 PIC_AEDAT
AENAM Name of person who changed object CHAR 12 0 PIC_AENAM

PICPS foreign key relationships

Table Field Check Table Check Field
0 PICPS MANDT T000 Clients MANDT
1 PICPS MATNR MARA General Material Data MANDT
1 PICPS MATNR MARA General Material Data MATNR
0 PICPS PICCODE PICIC Parts Interchangeability Code MANDT
0 PICPS PICCODE PICIC Parts Interchangeability Code PICCAT
1 PICPS PICKEY PICHD Parts Interchangeability Header Data (Sus+MPN) MANDT