SAP Table PICRL
Parts Interchangeability Relation (Plant/MRP Area)
PICRL (Parts Interchangeability Relation (Plant/MRP Area)) 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 PICRL to other SAP tables.
PICRL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| PICKEY | Part Interchangeability Object Key (GUID) | PIC_PICKEY | PICHD | RAW | 16 | 0 | ||
| PICPOS | Item Number of Parts Interchangeability Member | PIC_PICPOS | PICPS | NUMC | 4 | 0 | ||
| PICGID | Generic Identifier for Plant/MRP Area (Parts Interchang.) | PIC_PICGID | NUMC | 8 | 0 | |||
| COUNTER | Parts Interchangeability Counter (ECM) | PIC_COUNTER | 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 | ||
| DATFR | Valid from date of an interchangeable part | PIC_DATFR | DATS | 8 | 0 | |||
| SPERKZ | Block Indicator for Parts Interchangeability | PIC_SPERKZ | CHAR | 1 | 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 | |||
PICRL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| PICRL | BERID | PICRL | MANDT | MDLV | Customizing MRP Area | MANDT |
| PICRL | BERID | PICRL | BERID | MDLV | Customizing MRP Area | BERID |
| PICRL | LMATN | PICRL | MANDT | MARA | General Material Data | MANDT |
| PICRL | LMATN | PICRL | LMATN | MARA | General Material Data | MATNR |
| PICRL | MANDT | PICRL | MANDT | T000 | Clients | MANDT |
| PICRL | PICKEY | PICRL | MANDT | PICHD | Parts Interchangeability Header Data (Sus+MPN) | MANDT |
| PICRL | PICKEY | PICRL | PICKEY | PICHD | Parts Interchangeability Header Data (Sus+MPN) | PICKEY |
| PICRL | PICPOS | PICRL | MANDT | PICPS | Parts Interchangeability Item (SuS+MPN) | MANDT |
| PICRL | PICPOS | PICRL | PICKEY | PICPS | Parts Interchangeability Item (SuS+MPN) | PICKEY |
| PICRL | PICPOS | PICRL | PICPOS | PICPS | Parts Interchangeability Item (SuS+MPN) | PICPOS |
| PICRL | PICPOS | PICRL | COUNTER | PICPS | Parts Interchangeability Item (SuS+MPN) | COUNTER |
| PICRL | WERKS | PICRL | MANDT | T001W | Plants/Branches | MANDT |
| PICRL | WERKS | PICRL | WERKS | T001W | Plants/Branches | WERKS |
