SAP ABAP View /ISDFPS/V_BI_MPO (Extraction View for the MPO)

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS (Application Component) Defense Forces and Public Security
     ⤷ /ISDFPS/BI_CONTENT (Package) BI Content Defense (Extractors And So On)

Basic Data

View Type	D	Database View
Database View	/ISDFPS/V_BI_MPO
Short Description	Extraction View for the MPO
Root table	/ISDFPS/PNMPO	Application-Specific MPO Attributes

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	/ISDFPS/PNMPO	/ISDFPS/PNMPO
2	PNODID
3	MARA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	/ISDFPS/PNMPO	MANDT	JL	EQ				0	0
2	PNODID	MANDT	JR	EQ			AND	0	0
3	/ISDFPS/PNMPO	PNGUID	JL	EQ				0	0
4	PNODID	PNGUID	JR	EQ			AND	0	0
5	/ISDFPS/PNMPO	MANDT	JL	EQ				0	0
6	MARA	MANDT	JR	EQ			AND	0	0
7	/ISDFPS/PNMPO	MPO_MATNR	JL	EQ				0	0
8	MARA	MATNR	JR	EQ			AND	0	0
9	/ISDFPS/PNMPO	MPO_MATNR		NE	''			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	PNODID	MANDT		☐	MANDT	☐	Client
2	MPO	PNODID	PNGUID		☐	PVS_PNGUID	☐	Internal Number of iPPE Node
3	TIMSTMP	PNODID	TIMSTMP		☐	PVS_TIMSTMP	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun)
4	CREADAT	PNODID	CREADAT		☐	PVS_ANDAT	☐	Date of Application
5	CREABY	PNODID	CREABY		☐	PVS_ANNAM	☐	User who created record
6	CHNGDAT	PNODID	CHNGDAT		☐	PVS_AEDAT	☐	Date of Last Change
7	CHNGBY	PNODID	CHNGBY		☐	PVS_AENAM	☐	Name of Person Who Changed Object
8	LOGSYS	PNODID	LOGSYS		☐	LOGSYS	☐	Logical system
9	PNCNT	/ISDFPS/PNMPO	PNCNT		☐	PVS_COUNT	☐	Internal Counter for iPPE Objects
10	MDM_PLVAR	/ISDFPS/PNMPO	MDM_PLVAR		☐	/ISDFPS/MDM_PLVAR	☐	Plan Version
11	MDM_OTYPE	/ISDFPS/PNMPO	MDM_OTYPE		☐	/ISDFPS/MDM_OTYPE	☐	Object Type of Material Owner
12	MDM_OBJID	/ISDFPS/PNMPO	MDM_OBJID		☐	/ISDFPS/MDM_OBJID	☐	Object ID for Material Owner
13	SER_FLAG	/ISDFPS/PNMPO	SER_FLAG		☐	/ISDFPS/SER_FLAG	☐	Level of Detail
14	TRANSPORT	/ISDFPS/PNMPO	TRANSPORT		☐	/ISDFPS/TRANSPORT	☐	Relocation-Relevant
15	RIC	/ISDFPS/PNMPO	RIC		☐	/ISDFPS/RICODE	☐	Reportable Item Code
16	OBJNR	/ISDFPS/PNMPO	OBJNR		☐	J_OBJNR	☐	Object number
17	STAT	/ISDFPS/PNMPO	STAT		☐	/ISDFPS/STATUS	☐	Object Status
18	MPO_MATNR	/ISDFPS/PNMPO	MPO_MATNR		☐	MATNR	☐	Material Number
19	MTART	MARA	MTART		☐	MTART	☐	Material type
20	MATKL	MARA	MATKL		☐	MATKL	☐	Material Group
21	BRGEW	MARA	BRGEW		☐	BRGEW	☐	Gross weight
22	NTGEW	MARA	NTGEW		☐	NTGEW	☐	Net weight
23	GEWEI	MARA	GEWEI		☐	GEWEI	☐	Weight Unit
24	VOLUM	MARA	VOLUM		☐	VOLUM	☐	Volume
25	VOLEH	MARA	VOLEH		☐	VOLEH	☐	Volume unit
26	STOFF	MARA	STOFF		☐	STOFF	☐	Hazardous material number
27	LAENG	MARA	LAENG		☐	LAENG	☐	Length
28	BREIT	MARA	BREIT		☐	BREIT	☐	Width
29	HOEHE	MARA	HOEHE		☐	HOEHE	☐	Height
30	MEABM	MARA	MEABM		☐	MEABM	☐	Unit of Dimension for Length/Width/Height
31	ATTYP	MARA	ATTYP		☐	ATTYP	☐	Material Category
32	MFRPN	MARA	MFRPN		☐	MFRPN	☐	Manufacturer Part Number
33	PROFL	MARA	PROFL		☐	ADGE_PROFL	☐	Dangerous goods indicator profile
34	MCOND	MARA	MCOND		☐	DFPS_MCOND	☐	Material Condition Management
35	RETDELC	MARA	RETDELC		☐	DFPS_RETDELC	☐	Return Code
36	LOGLEV_RETO	MARA	LOGLEV_RETO		☐	DFPS_LOGLEV_RETO	☐	Return to Logistics Level
37	NSNID	MARA	NSNID		☐	DFPS_NSNID	☐	NATO Stock Number
38	GROES	MARA	GROES		☐	GROES	☐	Size/dimensions

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20140121
SAP Release Created in	470