SAP ABAP View MACKU (Material Valuation View for 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	MACKU
Short Description	Material Valuation View for Costing
Root table	MARA	General Material Data

Table

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

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	MBEW	MANDT	JR	EQ			AND	0	0
3	MARA	MATNR	JL	EQ				0	0
4	MBEW	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	BWKEY	MBEW	BWKEY		☐	BWKEY	☐	Valuation area
4	BWTAR	MBEW	BWTAR		☐	BWTAR_D	☐	Valuation type
5	MTART	MARA	MTART		☐	MTART	☐	Material type
6	MATKL	MARA	MATKL		☐	MATKL	☐	Material Group
7	KZKFG	MARA	KZKFG		☐	KZKFG	☐	Configurable Material
8	VPRSV	MBEW	VPRSV		☐	VPRSV	☐	Price control indicator
9	VERPR	MBEW	VERPR		☐	VERPR	☐	Moving Average Price/Periodic Unit Price
10	STPRS	MBEW	STPRS		☐	STPRS	☐	Standard price
11	PEINH	MBEW	PEINH		☐	PEINH	☐	Price unit
12	BKLAS	MBEW	BKLAS		☐	BKLAS	☐	Valuation Class
13	BWTTY	MBEW	BWTTY		☐	BWTTY_D	☐	Valuation Category
14	ZKPRS	MBEW	ZKPRS		☐	DZKPRS	☐	Future price
15	ZKDAT	MBEW	ZKDAT		☐	DZKDAT	☐	Date as of which the price is valid
16	BWPRS	MBEW	BWPRS		☐	BWPRS	☐	Valuation price based on tax law: level 1
17	BWPRH	MBEW	BWPRH		☐	BWPRH	☐	Valuation price based on commercial law: level 1
18	BWPS1	MBEW	BWPS1		☐	BWPS1	☐	Valuation price based on tax law: level 2
19	BWPH1	MBEW	BWPH1		☐	BWPH1	☐	Valuation price based on commercial law: level 2
20	VJBWS	MBEW	VJBWS		☐	VJBWS	☐	Valuation price based on tax law: level 3
21	VJBWH	MBEW	VJBWH		☐	VJBWH	☐	Valuation price based on commercial law: level 3
22	ZPLP1	MBEW	ZPLP1		☐	DZPLP1	☐	Future Planned Price 1
23	ZPLP2	MBEW	ZPLP2		☐	DZPLP2	☐	Future Planned Price 2
24	ZPLP3	MBEW	ZPLP3		☐	DZPLP3	☐	Future Planned Price 3
25	ZPLD1	MBEW	ZPLD1		☐	DZPLD1	☐	Date from Which Future Planned Price 1 Is Valid
26	ZPLD2	MBEW	ZPLD2		☐	DZPLD2	☐	Date from Which Future Planned Price 2 Is Valid
27	ZPLD3	MBEW	ZPLD3		☐	DZPLD3	☐	Date from Which Future Planned Price 3 Is Valid
28	KALNR	MBEW	KALNR		☐	CK_KALNR	☐	Cost Estimate Number for Cost Est. w/o Qty Structure
29	KALN1	MBEW	KALN1		☐	CK_KALNR1	☐	Cost Estimate Number - Product Costing
30	VMSTP	MBEW	VMSTP		☐	VMSTP	☐	Standard price in the previous period
31	VMPEI	MBEW	VMPEI		☐	VMPEI	☐	Price unit of previous period
32	HRKFT	MBEW	HRKFT		☐	HRKFT	☐	Origin Group as Subdivision of Cost Element
33	EKALR	MBEW	EKALR		☐	CK_EKALREL	☐	Material Is Costed with Quantity Structure
34	ZPLPR	MBEW	ZPLPR		☐	DZPLPR	☐	Future planned price
35	HKMAT	MBEW	HKMAT		☐	HKMAT	☐	Material-related origin
36	BWPEI	MBEW	BWPEI		☐	BWPEI	☐	Price unit for valuation prices based on tax/commercial law

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