SAP ABAP Table V_PICPSRL (Generated Table for View V_PICPSRL)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_PICPSRL	Table Relationship Diagram
Short Description	Generated Table for View V_PICPSRL

Delivery and Maintenance

Pool/cluster
Delivery Class
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)
3	PICCAT	☑	PIC_PICCAT	PIC_PICCAT	CHAR	2	0	Interchangeable parts category
4	PICNUM	☑	PIC_PICNUM	PIC_PICNUM	CHAR	18	0	Parts Interchangeability Group Number
5	ERDAT	☑	PIC_ERDAT	DATUM	DATS	8	0	Date on Which Record Was Created
6	ERNAM	☑	PIC_ERNAM	USNAM	CHAR	12	0	Name of person who created the object
7	AEDAT	☑	PIC_AEDAT	DATUM	DATS	8	0	Last Changed On
8	AENAM	☑	PIC_AENAM	USNAM	CHAR	12	0	Name of person who changed object
9	PICPOS	☑	PIC_PICPOS	NUMC4	NUMC	4	0	Item Number of Parts Interchangeability Member
10	COUNTER	☑	PIC_COUNTER	NUMC8	NUMC	8	0	Parts Interchangeability Counter (ECM)
11	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
12	LOEKZ	☑	PIC_LOEKZ	XFELD	CHAR	1	0	Parts Interchangeability Member Marked for Deletion
13	SEQNR	☑	PIC_SEQNR	NUMC4	NUMC	4	0	Sequence number of interchangeable part
14	DATFR	☑	PIC_DATFR	DATUM	DATS	8	0	Valid from date of an interchangeable part
15	INTTYPE	☑	PIC_INTTYPE	PIC_INTTYPE	CHAR	1	0	Replacement Type
16	PICCODE	☑	PIC_PICCODE	PIC_PICCODE	CHAR	4	0	Cause of part exchange	PICIC
17	DERDAT	☑	PIC_ERDAT	DATUM	DATS	8	0	Date on Which Record Was Created
18	DERNAM	☑	PIC_ERNAM	USNAM	CHAR	12	0	Name of person who created the object
19	DAEDAT	☑	PIC_AEDAT	DATUM	DATS	8	0	Last Changed On
20	DAENAM	☑	PIC_AENAM	USNAM	CHAR	12	0	Name of person who changed object
21	PICGID	☑	PIC_PICGID	NUMC8	NUMC	8	0	Generic Identifier for Plant/MRP Area (Parts Interchang.)
22	WERKS	☐	WERKA	WERKS	CHAR	4	0	Plant	T001W
23	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	MDLV
24	MRPGR	☐	PIC_MRPGR	PIC_MRPGR	CHAR	10	0	Parts interchangeability MPN-MRP set
25	LMATN	☐	PIC_LMATN	MATNR	CHAR	18	0	Leading part number for MRP set	MARA
26	RDATFR	☐	PIC_DATFR	DATUM	DATS	8	0	Valid from date of an interchangeable part
27	SPERKZ	☐	PIC_SPERKZ	PIC_SPERKZ	CHAR	1	0	Block Indicator for Parts Interchangeability
28	RERDAT	☐	PIC_ERDAT	DATUM	DATS	8	0	Date on Which Record Was Created
29	RERNAM	☐	PIC_ERNAM	USNAM	CHAR	12	0	Name of person who created the object
30	RAEDAT	☐	PIC_AEDAT	DATUM	DATS	8	0	Last Changed On
31	RAENAM	☐	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_PICPSRL	BERID	MDLV	BERID	KEY
2	V_PICPSRL	LMATN	MARA	MATNR	KEY
3	V_PICPSRL	MANDT	T000	MANDT	KEY
4	V_PICPSRL	MATNR	MARA	MATNR		1	CN
5	V_PICPSRL	PICCODE	PICIC	PICCODE	REF	C	CN
6	V_PICPSRL	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20050301
SAP Release Created in