SAP ABAP View MACKW (Material Plant View on Costing)

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	MACKW
Short Description	Material Plant View on Costing
Root table	MARA	General Material Data

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MARA	MANDT	JL	EQ				0	0
2	MARC	MANDT	JR	EQ			AND	0	0
3	MARA	MATNR	JL	EQ				0	0
4	MARC	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	MEINS	MARA	MEINS		☐	MEINS	☐	Base Unit of Measure
5	DISST	MARA	DISST		☐	DISST	☐	Low-level code
6	LABOR	MARA	LABOR		☐	LABOR	☐	Laboratory/design office
7	AEKLK	MARA	AEKLK		☐	CK_AEKLK	☐	Stock transfer net change costing
8	PSTAT	MARC	PSTAT		☐	PSTAT_D	☐	Maintenance status
9	SOBSL	MARC	SOBSL		☐	SOBSL	☐	Special procurement type
10	BSTFE	MARC	BSTFE		☐	BSTFE	☐	Fixed lot size
11	EKGRP	MARC	EKGRP		☐	EKGRP	☐	Purchasing group
12	DISPO	MARC	DISPO		☐	DISPO	☐	MRP controller
13	FEVOR	MARC	FEVOR		☐	FEVOR	☐	Production Supervisor
14	STLAL	MARC	STLAL		☐	STALT	☐	Alternative BOM
15	STLAN	MARC	STLAN		☐	STLAN	☐	BOM Usage
16	PLNNR	MARC	PLNNR		☐	PLNNR	☐	Key for Task List Group
17	APLAL	MARC	APLAL		☐	PLNAL	☐	Group Counter
18	LOSGR	MARC	LOSGR		☐	CK_LOSGR	☐	Costing lot size
19	SOBSK	MARC	SOBSK		☐	CK_SOBSL	☐	Special Procurement Type for Costing
20	VERKZ	MARC	VERKZ		☐	CK_VERK1	☐	Version indicator
21	AUSSS	MARC	AUSSS		☐	AUSSS	☐	Assembly scrap in percent
22	SAUFT	MARC	SAUFT		☐	SA_SAUFT	☐	Ind.: Repetitive mfg allowed
23	KZKFG	MARA	KZKFG		☐	KZKFG	☐	Configurable Material
24	STDPD	MARC	STDPD		☐	STDPD	☐	Configurable material
25	CUOBJ	MARC	CUOBJ		☐	CUOBM	☐	Internal object number
26	MTART	MARA	MTART		☐	MTART	☐	Material type
27	LVORA	MARA	LVORM		☐	LVOMA	☐	Flag Material for Deletion at Client Level
28	LVORC	MARC	LVORM		☐	LVOWK	☐	Flag Material for Deletion at Plant Level
29	ALTSL	MARC	ALTSL		☐	ALTSL	☐	Method for Selecting Alternative Bills of Material
30	SFEPR	MARC	SFEPR		☐	SFEPR	☐	Repetitive manufacturing profile
31	MSTAE	MARA	MSTAE		☐	MSTAE	☐	Cross-Plant Material Status
32	MSTDE	MARA	MSTDE		☐	MSTDE	☐	Date from which the cross-plant material status is valid
33	MMSTA	MARC	MMSTA		☐	MMSTA	☐	Plant-Specific Material Status
34	MMSTD	MARC	MMSTD		☐	MMSTD	☐	Date from which the plant-specific material status is valid
35	KZKUP	MARC	KZKUP		☐	KZKUPMAT	☐	Indicator: Material can be co-product
36	PLNTY	MARC	PLNTY		☐	PLNTY	☐	Task List Type
37	SBDKZ	MARC	SBDKZ		☐	SBDKZ	☐	Dependent requirements ind. for individual and coll. reqmts
38	BESKZ	MARC	BESKZ		☐	BESKZ	☐	Procurement Type
39	PRCTR	MARC	PRCTR		☐	PRCTR	☐	Profit Center
40	FVIDK	MARC	FVIDK		☐	CK_VERID	☐	Production version to be costed
41	FXPRU	MARC	FXPRU		☐	CK_FIXPRKU	☐	Fixed-Price Co-Product
42	SPART	MARA	SPART		☐	SPART	☐	Division
43	KZEFF	MARA	KZEFF		☐	CC_MTEFF	☐	Assign effectivity parameter values/ override change numbers
44	AHDIS	MARC	AHDIS		☐	AHDIS	☐	MRP relevancy for dependent requirements
45	NCOST	MARC	NCOST		☐	CK_NO_COSTING	☐	Do Not Cost
46	USEQU	MARC	USEQU		☐	USEQU	☐	Quota arrangement usage

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