SAP ABAP Table PICRL (Parts Interchangeability Relation (Plant/MRP Area))
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 TRANSP    Transparent table 
Transparent table PICRL   Table Relationship Diagram
Short Description Parts Interchangeability Relation (Plant/MRP Area)    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
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 PICKEY PIC_PICKEY SYSUUID RAW 16   0   Part Interchangeability Object Key (GUID) PICHD
3 PICPOS PIC_PICPOS NUMC4 NUMC 4   0   Item Number of Parts Interchangeability Member PICPS
4 PICGID PIC_PICGID NUMC8 NUMC 8   0   Generic Identifier for Plant/MRP Area (Parts Interchang.)  
5 COUNTER PIC_COUNTER NUMC8 NUMC 8   0   Parts Interchangeability Counter (ECM)  
6 WERKS WERKA WERKS CHAR 4   0   Plant T001W
7 BERID BERID BERID CHAR 10   0   MRP Area MDLV
8 MRPGR PIC_MRPGR PIC_MRPGR CHAR 10   0   Parts interchangeability MPN-MRP set  
9 LMATN PIC_LMATN MATNR CHAR 18   0   Leading part number for MRP set MARA
10 DATFR PIC_DATFR DATUM DATS 8   0   Valid from date of an interchangeable part  
11 SPERKZ PIC_SPERKZ PIC_SPERKZ CHAR 1   0   Block Indicator for Parts Interchangeability  
12 ERDAT PIC_ERDAT DATUM DATS 8   0   Date on Which Record Was Created  
13 ERNAM PIC_ERNAM USNAM CHAR 12   0   Name of person who created the object  
14 AEDAT PIC_AEDAT DATUM DATS 8   0   Last Changed On  
15 AENAM PIC_AENAM USNAM CHAR 12   0   Name of person who changed object  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 PICRL BERID MDLV BERID KEY    
2 PICRL LMATN MARA MATNR KEY    
3 PICRL MANDT T000 MANDT KEY    
4 PICRL PICKEY PICHD PICKEY 1 CN
5 PICRL PICPOS PICPS PICPOS KEY 1 N
6 PICRL WERKS T001W WERKS REF 1 CN
History
Last changed by/on SAP  20050301 
SAP Release Created in