SAP ABAP Table V_PICMRL (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | V_PICMRL |
Table Relationship Diagram 
|
| Short Description | Generated Table for View |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
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 | PICNUM |
PIC_PICNUM | PIC_PICNUM | CHAR | 18 | 0 | Parts Interchangeability Group Number | ||
| 3 | PICKEY |
PIC_PICKEY | SYSUUID | RAW | 16 | 0 | Part Interchangeability Object Key (GUID) | PICHD | |
| 4 | PICPOS |
PIC_PICPOS | NUMC4 | NUMC | 4 | 0 | Item Number of Parts Interchangeability Member | PICPS | |
| 5 | PICGID |
PIC_PICGID | NUMC8 | NUMC | 8 | 0 | Generic Identifier for Plant/MRP Area (Parts Interchang.) | ||
| 6 | COUNTER |
PIC_COUNTER | NUMC8 | NUMC | 8 | 0 | Parts Interchangeability Counter (ECM) | ||
| 7 | WERKS |
WERKA | WERKS | CHAR | 4 | 0 | Plant | T001W | |
| 8 | BERID |
BERID | BERID | CHAR | 10 | 0 | MRP Area | MDLV | |
| 9 | MRPGR |
PIC_MRPGR | PIC_MRPGR | CHAR | 10 | 0 | Parts interchangeability MPN-MRP set | ||
| 10 | MATNR |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
| 11 | LMATN |
PIC_LMATN | MATNR | CHAR | 18 | 0 | Leading part number for MRP set | MARA | |
| 12 | MAKTX |
MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
| 13 | SPERKZ |
PIC_SPERKZ | PIC_SPERKZ | CHAR | 1 | 0 | Block Indicator for Parts Interchangeability | ||
| 14 | ERDAT |
PIC_ERDAT | DATUM | DATS | 8 | 0 | Date on Which Record Was Created | ||
| 15 | ERNAM |
PIC_ERNAM | USNAM | CHAR | 12 | 0 | Name of person who created the object | ||
| 16 | AEDAT |
PIC_AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
| 17 | 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 | V_PICMRL | BERID |  MDLV |
BERID |
KEY | ||
| 2 | V_PICMRL | LMATN | MARA |
MATNR |
KEY | ||
| 3 | V_PICMRL | MANDT | T000 |
MANDT |
KEY | ||
| 4 | V_PICMRL | MATNR | MARA |
MATNR |
1 | CN | |
| 5 | V_PICMRL | PICKEY | PICHD |
PICKEY |
1 | CN | |
| 6 | V_PICMRL | PICPOS | PICPS |
PICPOS |
KEY | 1 | N |
| 7 | V_PICMRL | WERKS | T001W |
WERKS |
REF | 1 | CN |
History
| Last changed by/on | SAP | 20140121 |
| SAP Release Created in |
