MACKU SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




ABAP Code to SELECT data from MACKU
Related tables to MACKU
Access table MACKU




Table View field list including key, data, relationships and ABAP select examples

MACKU is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The MACKU table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include MATNR (Material Number), BWKEY (Valuation Area), BWTAR (Valuation Type), MTART (Material Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP MACKU table view fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
MATNRMaterial Number MATNRCHAR18MATN1MATNRMATS_MAT1
BWKEYValuation Area BWKEYCHAR4T001KBWKEYBWK
BWTARValuation Type BWTAR_DCHAR10BWTARBWT
MTARTMaterial Type MTARTCHAR4T134MTARTMTA
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
KZKFGConfigurable Material KZKFGCHAR1XFELD
VPRSVPrice control indicator VPRSVCHAR1VPRSV
VERPRMoving Average Price/Periodic Unit Price VERPRCURR11(2) WERT11V
STPRSStandard price STPRSCURR11(2) WERT11V
PEINHPrice Unit PEINHDEC5PACK3
BKLASValuation Class BKLASCHAR4T025BKLAS
BWTTYValuation Category BWTTY_DCHAR1T149BWTTY
ZKPRSFuture price DZKPRSCURR11(2) WERT11
ZKDATDate as of which the price is valid DZKDATDATS8DATUM
BWPRSValuation price based on tax law: level 1 BWPRSCURR11(2) WERT11
BWPRHValuation price based on commercial law: level 1 BWPRHCURR11(2) WERT11
BWPS1Valuation price based on tax law: level 2 BWPS1CURR11(2) WERT11
BWPH1Valuation price based on commercial law: level 2 BWPH1CURR11(2) WERT11
VJBWSValuation price based on tax law: level 3 VJBWSCURR11(2) WERT11
VJBWHValuation price based on commercial law: level 3 VJBWHCURR11(2) WERT11
ZPLP1Future Planned Price 1 DZPLP1CURR11(2) WERT11
ZPLP2Future Planned Price 2 DZPLP2CURR11(2) WERT11
ZPLP3Future Planned Price 3 DZPLP3CURR11(2) WERT11
ZPLD1Date from Which Future Planned Price 1 Is Valid DZPLD1DATS8DATUM
ZPLD2Date from Which Future Planned Price 2 Is Valid DZPLD2DATS8DATUM
ZPLD3Date from Which Future Planned Price 3 Is Valid DZPLD3DATS8DATUM
KALNRCost Estimate Number for Cost Est. w/o Qty Structure CK_KALNRNUMC12CK_KALNRKNR
KALN1Cost Estimate Number - Product Costing CK_KALNR1NUMC12CK_KALNRKNE
VMSTPStandard price in the previous period VMSTPCURR11(2) WERT11V
VMPEIPrice unit of previous period VMPEIDEC5PACK3
HRKFTOrigin Group as Subdivision of Cost Element HRKFTCHAR4TKKH1HRKFT
EKALRMaterial Is Costed with Quantity Structure CK_EKALRELCHAR1XFELD
ZPLPRFuture planned price DZPLPRCURR11(2) WERT11
HKMATMaterial-related origin HKMATCHAR1HKMAT
BWPEIPrice unit for valuation prices based on tax/commercial law BWPEIDEC5PACK3

Key field Non-key field



How do I retrieve data from SAP table MACKU using ABAP code

The following ABAP code Example will allow you to do a basic selection on MACKU to SELECT all data from the table
DATA: WA_MACKU TYPE MACKU.

SELECT SINGLE *
FROM MACKU
INTO CORRESPONDING FIELDS OF WA_MACKU
WHERE...

How to access SAP table MACKU

Within an ECC or HANA version of SAP you can also view further information about MACKU and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!