SAP ABAP View MFAUF (Material Plant View on Production Order)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MG (Package) Application development R/3 material master prior to 3.0

Basic Data

View Type	D	Database View
Database View	MFAUF
Short Description	Material Plant View on Production Order
Root table	MARA	General Material Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MARA	MARA
2	MARC
3	MBEW

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MARC	MANDT	JL	EQ				0	0
2	MARA	MANDT	JR	EQ			AND	0	0
3	MARC	MATNR	JL	EQ				0	0
4	MARA	MATNR	JR	EQ			AND	0	0
5	MBEW	MANDT	JL	EQ				0	0
6	MARA	MANDT	JR	EQ			AND	0	0
7	MBEW	MATNR	JL	EQ				0	0
8	MARA	MATNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	MARA	MANDT		☐	MANDT	☐	Client
2	MATNR	MARA	MATNR		☐	MATNR	☐	Material Number
3	WERKS	MARC	WERKS		☐	WERKS_D	☐	Plant
4	MTART	MARA	MTART		☐	MTART	☐	Material type
5	MATKL	MARA	MATKL		☐	MATKL	☐	Material Group
6	MEINS	MARA	MEINS		☐	MEINS	☐	Base Unit of Measure
7	FERTH	MARA	FERTH		☐	FERTH	☐	Production/inspection memo
8	FORMT	MARA	FORMT		☐	FORMT	☐	Page Format of Production Memo
9	DISST	MARA	DISST		☐	DISST	☐	Low-level code
10	SPART	MARA	SPART		☐	SPART	☐	Division
11	KZREV	MARA	KZREV		☐	KZREV	☐	Indicator: revision level has been assigned to the material
12	KZKFG	MARA	KZKFG		☐	KZKFG	☐	Configurable Material
13	MBRSH	MARA	MBRSH		☐	MBRSH	☐	Industry sector
14	VPSTA	MARA	VPSTA		☐	VPSTA	☐	Maintenance status of complete material
15	BWTTY	MARC	BWTTY		☐	BWTTY_D	☐	Valuation Category
16	XCHAR	MARC	XCHAR		☐	XCHAR	☐	Batch management indicator (internal)
17	MMSTA	MARC	MMSTA		☐	MMSTA	☐	Plant-Specific Material Status
18	MMSTD	MARC	MMSTD		☐	MMSTD	☐	Date from which the plant-specific material status is valid
19	EKGRP	MARC	EKGRP		☐	EKGRP	☐	Purchasing group
20	AUSME	MARC	AUSME		☐	AUSME	☐	Unit of issue
21	DISMM	MARC	DISMM		☐	DISMM	☐	MRP Type
22	DISPO	MARC	DISPO		☐	DISPO	☐	MRP controller
23	PLIFZ	MARC	PLIFZ		☐	PLIFZ	☐	Planned delivery time in days
24	WEBAZ	MARC	WEBAZ		☐	WEBAZ	☐	Goods receipt processing time in days
25	AUSSS	MARC	AUSSS		☐	AUSSS	☐	Assembly scrap in percent
26	BESKZ	MARC	BESKZ		☐	BESKZ	☐	Procurement Type
27	SOBSL	MARC	SOBSL		☐	SOBSL	☐	Special procurement type
28	EISBE	MARC	EISBE		☐	EISBE	☐	Safety stock
29	BSTFE	MARC	BSTFE		☐	BSTFE	☐	Fixed lot size
30	BSTRF	MARC	BSTRF		☐	BSTRF	☐	Rounding value for purchase order quantity
31	SBDKZ	MARC	SBDKZ		☐	SBDKZ	☐	Dependent requirements ind. for individual and coll. reqmts
32	ALTSL	MARC	ALTSL		☐	ALTSL	☐	Method for Selecting Alternative Bills of Material
33	KZAUS	MARC	KZAUS		☐	KZAUS	☐	Discontinuation indicator
34	AUSDT	MARC	AUSDT		☐	AUSDT	☐	Effective-out date
35	NFMAT	MARC	NFMAT		☐	NFMAT	☐	Follow-up material
36	KZBED	MARC	KZBED		☐	KZBED	☐	Indicator for Requirements Grouping
37	MISKZ	MARC	MISKZ		☐	MISKZ	☐	Mixed MRP indicator
38	FHORI	MARC	FHORI		☐	FHORI	☐	Scheduling Margin Key for Floats
39	FFREI	MARC	FFREI		☐	FFREI	☐	Release indicator for production orders
40	RGEKZ	MARC	RGEKZ		☐	RGEKM	☐	Indicator: Backflush
41	FEVOR	MARC	FEVOR		☐	FEVOR	☐	Production Supervisor
42	BEARZ	MARC	BEARZ		☐	BEARZ	☐	Processing time
43	RUEZT	MARC	RUEZT		☐	RUEZT	☐	Setup and teardown time
44	TRANZ	MARC	TRANZ		☐	TRANZ	☐	Interoperation time
45	BASMG	MARC	BASMG		☐	BASMG	☐	Base quantity
46	DZEIT	MARC	DZEIT		☐	DZEIT	☐	In-house production time
47	KZPRO	MARC	KZPRO		☐	KZPRO	☐	Indicator: withdrawal of stock from production bin
48	UEETO	MARC	UEETO		☐	UEETO	☐	Overdelivery tolerance limit
49	UEETK	MARC	UEETK		☐	UEETK	☐	Indicator: Unlimited overdelivery allowed
50	UNETO	MARC	UNETO		☐	UNETO	☐	Underdelivery tolerance limit
51	WZEIT	MARC	WZEIT		☐	WZEIT	☐	Total replenishment lead time (in workdays)
52	INSMK	MARC	INSMK		☐	INSMK_MAT	☐	Post to Inspection Stock
53	KZDKZ	MARC	KZDKZ		☐	KZDKZ	☐	Documentation required indicator
54	UMLMC	MARC	UMLMC		☐	UMLME	☐	Stock in transfer (plant to plant)
55	XCHPF	MARC	XCHPF		☐	XCHPF	☐	Batch management requirement indicator
56	USEQU	MARC	USEQU		☐	USEQU	☐	Quota arrangement usage
57	MTVFP	MARC	MTVFP		☐	MTVFP	☐	Checking Group for Availability Check
58	PRCTR	MARC	PRCTR		☐	PRCTR	☐	Profit Center
59	SAUFT	MARC	SAUFT		☐	SA_SAUFT	☐	Ind.: Repetitive mfg allowed
60	VERKZ	MARC	VERKZ		☐	CK_VERK1	☐	Version indicator
61	FRTME	MARC	FRTME		☐	FRTME	☐	Production unit
62	LGPRO	MARC	LGPRO		☐	LGPRO	☐	Issue storage location
63	AWSLS	MARC	AWSLS		☐	AWSLS	☐	Variance Key
64	CUOBJ	MARC	CUOBJ		☐	CUOBM	☐	Internal object number
65	SFEPR	MARC	SFEPR		☐	SFEPR	☐	Repetitive manufacturing profile
66	LVORM	MARC	LVORM		☐	LVOWK	☐	Flag Material for Deletion at Plant Level
67	KAUSF	MARC	KAUSF		☐	KAUSF	☐	Component scrap in percent
68	STDPD	MARC	STDPD		☐	STDPD	☐	Configurable material
69	SOBSK	MARC	SOBSK		☐	CK_SOBSL	☐	Special Procurement Type for Costing
70	PSTAT	MARC	PSTAT		☐	PSTAT_D	☐	Maintenance status
71	SCHGT	MARC	SCHGT		☐	SCHGT	☐	Indicator: bulk material
72	DISGR	MARC	DISGR		☐	DISGR	☐	MRP Group
73	SFCPF	MARC	SFCPF		☐	CO_PRODPRF	☐	Production Scheduling Profile
74	EPRIO	MARC	EPRIO		☐	BF_GROUP	☐	Stock determination group
75	KZECH	MARC	KZECH		☐	KZECH	☐	Determination of batch entry in the production/process order
76	SERNP	MARC	SERNP		☐	SERAIL	☐	Serial Number Profile
77	QMATV	MARC	QMATV		☐	QMATV	☐	Inspection Setup Exists for Material/Plant
78	STRGR	MARC	STRGR		☐	STRGR	☐	Planning strategy group
79	CUOBF	MARA	CUOBF		☐	CUOBM	☐	Internal object number
80	SERLV	MARA	SERLV		☐	SERLV	☐	Level of Explicitness for Serial Number
81	KZWSM	MARA	KZWSM		☐	KZWSO	☐	Units of measure usage
82	MSTAE	MARA	MSTAE		☐	MSTAE	☐	Cross-Plant Material Status
83	FXPRU	MARC	FXPRU		☐	CK_FIXPRKU	☐	Fixed-Price Co-Product
84	OCMPF	MARC	OCMPF		☐	OCM_GPROFILE	☐	Overall profile for order change management
85	VSPVB	MARC	VSPVB		☐	VSPVB	☐	Proposed Supply Area in Material Master Record
86	KZEFF	MARA	KZEFF		☐	CC_MTEFF	☐	Assign effectivity parameter values/ override change numbers
87	UCHKZ	MARC	UCHKZ		☐	UCHKZ	☐	Indicator for Original Batch Management
88	HKMAT	MBEW	HKMAT		☐	HKMAT	☐	Material-related origin

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