SAP ABAP View /ISDFPS/V_BI_IHM (Extraction View for Material Documents for Maintenance Order)

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_IHM
Short Description	Extraction View for Material Documents for Maintenance Order
Root table	MKPF	Header: Material Document

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MKPF	MKPF
2	AUFM
3	AFIH

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MKPF	MANDT	JL	EQ				0	0
2	AUFM	MANDT	JR	EQ			AND	0	0
3	MKPF	MBLNR	JL	EQ				0	0
4	AUFM	MBLNR	JR	EQ			AND	0	0
5	MKPF	MJAHR	JL	EQ				0	0
6	AUFM	MJAHR	JR	EQ			AND	0	0
7	AUFM	MANDT	JL	EQ				0	0
8	AFIH	MANDT	JR	EQ			AND	0	0
9	AUFM	AUFNR	JL	EQ				0	0
10	AFIH	AUFNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	MKPF	MANDT		☐	MANDT	☐	Client
2	MBLNR	MKPF	MBLNR		☐	MBLNR	☐	Number of Material Document
3	MJAHR	MKPF	MJAHR		☐	MJAHR	☐	Year of material document
4	CPUDT	MKPF	CPUDT		☐	CPUDT	☐	Accounting document entry date
5	BLDAT	AUFM	BLDAT		☐	BLDAT	☐	Document Date in Document
6	BUDAT	AUFM	BUDAT		☐	BUDAT	☐	Posting Date in the Document
7	BWART	AUFM	BWART		☐	BWART	☐	Movement type (inventory management)
8	MATNR	AUFM	MATNR		☐	MATNR	☐	Material Number
9	WERKS	AUFM	WERKS		☐	WERKS_D	☐	Plant
10	LGORT	AUFM	LGORT		☐	LGORT_D	☐	Storage location
11	CHARG	AUFM	CHARG		☐	CHARG_D	☐	Batch Number
12	SOBKZ	AUFM	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
13	MENGE	AUFM	MENGE		☐	MENGE_D	☐	Quantity
14	MEINS	AUFM	MEINS		☐	MEINS	☐	Base Unit of Measure
15	EBELN	AUFM	EBELN		☐	BSTNR	☐	Purchase order number
16	EBELP	AUFM	EBELP		☐	EBELP	☐	Item Number of Purchasing Document
17	ELIKZ	AUFM	ELIKZ		☐	ELIKZ	☐	"Delivery Completed" Indicator
18	WEMPF	AUFM	WEMPF		☐	WEMPF	☐	Goods recipient
19	AUFNR	AUFM	AUFNR		☐	AUFNR	☐	Order Number
20	RSNUM	AUFM	RSNUM		☐	RSNUM	☐	Number of reservation/dependent requirements
21	RSPOS	AUFM	RSPOS		☐	RSPOS	☐	Item Number of Reservation / Dependent Requirements
22	RSART	AUFM	RSART		☐	RSART	☐	Record type
23	KZEAR	AUFM	KZEAR		☐	KZEAR	☐	Final issue for this reservation
24	KZBEW	AUFM	KZBEW		☐	KZBEW	☐	Movement Indicator
25	PS_PSP_PNR	AUFM	PS_PSP_PNR		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
26	AUFPL	AUFM	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
27	APLZL	AUFM	APLZL		☐	CIM_COUNT	☐	Internal counter
28	EQUNR	AFIH	EQUNR		☐	EQUNR	☐	Equipment Number

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	20110901
SAP Release Created in	600