Skip to Content
avatar image
Former Member

Equivalent tables for MARA, MAKT and MCH1 in the EWM system

Hi,

I would like to construct a report using the existing tables in EWM. But it turns out that it's somewhat different from the ECC system.

The material tables, MARA and MAKT and the batch table, MCH1 table are not there. I need the material number( like MARA-MATNR), material description/name(MAKT-MAKTX), the division ( MARA-SPART) and the batch number(MCH1-CHARG) and expiration date(MCH1-VFDAT).

Could someone provide the EWM equivalent for these tables and fields?

Thank you.

Best Regards,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jul 02, 2014 at 03:15 PM

    Hi Raphael,

    In EWM the closest thing to MARA i would say is /SAPAPO/MATKEY.  Description can be found in /SAPAPO/MATTXT.  I doubt there is any table that has division to product in EWM.  EWM is a delivery processing system and division is irrelevant to it.  Batch number and SLED can be found in /SCWM/AQUA.

    Hope this helps.

    Faical

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 02, 2014 at 03:32 PM

    Hello,

    /SCWM/BATCH_MANAGEMENT         Batch Management

    /SAPAPO/APNTYPE APN Type

    /SAPAPO/APNTYPET Alternative Product Number Type

    /SAPAPO/CD_PPRFL Customizing: Change Documents: Product Profiles

    /SAPAPO/CD_PRDHD Customizing: Change Documents: Product

    /SAPAPO/CD_PRDLC Customizing: Change Documents: Location Product

    /SAPAPO/CD_PRDLW Customizing: Change Documents: Storage Type Product

    /SAPAPO/CD_PRDWH Customizing: Change Documents: Storage Type Product

    /SAPAPO/DEMCL Requirements types

    /SAPAPO/DEP_LR Customizing table: Deployment Lock Reason

    /SAPAPO/DEP_LR_T Customizing table texts: Deployment Lock Reason

    /SAPAPO/DPLCDET Deployment Characteristics Profile Details

    /SAPAPO/DPLCHEAD Deployment Characteristics Profile Header

    /SAPAPO/DRP_LR Customizing table: DRP Lock Reason

    /SAPAPO/DRP_LR_T Customizing table texts: DRP Lock Reason

    /SAPAPO/DTQPROF Profile for maximum delivery time quotas (product master)

    /SAPAPO/GRPTYPE Product Group Types

    /SAPAPO/GRPTYPET Description of Product Grouping

    /SAPAPO/MARM Units of Measure

    /SAPAPO/MATAPN Alternative Product Number

    /SAPAPO/MATBOD Product BOD Assignment

    /SAPAPO/MATEXEC Product: Execution Data

    /SAPAPO/MATGPVAL Product Group Values

    /SAPAPO/MATGROUP Product Grouping

    /SAPAPO/MATINFO Product Information

    /SAPAPO/MATKEY Product

    /SAPAPO/MATLOC Location Product

    /SAPAPO/MATLOCTD Time-Dependent Location Product Fields

    /SAPAPO/MATLOTSZ Lot Sizes & Days' Supplies for Material Master

    /SAPAPO/MATLPL Location Product Planner (with Planner Type)

    /SAPAPO/MATLSIM Location Product with Planning Version

    /SAPAPO/MATLSINH Location Product with Inheritance

    /SAPAPO/MATLSPP SPP Relevant Location Product Attributes

    /SAPAPO/MATLWH Location Product for Location Warehouse

    /SAPAPO/MATLWHST Location Product for Location Whse and Subloc. Storage Type

    /SAPAPO/MATMAP Mapping Table for Products

    /SAPAPO/MATMOD Model assignment of location product

    /SAPAPO/MATPACK Product: Packing/Packaging Data

    /SAPAPO/MATPRIO Product Priority Time & Version-Dependent

    /SAPAPO/MATRELH Product-Relevant Hierarchies and Hierarchy Structures

    /SAPAPO/MATREPC Replenishment Control

    /SAPAPO/MATREPCT Replenishment Control

    /SAPAPO/MATRGPT Product Regional Pattern Assignment

    /SAPAPO/MATRQ Requirement Profile in Material Master

    /SAPAPO/MATSBOD Product BOD Assignment with Planning Version

    /SAPAPO/MATTXT Material Descriptions

    /SAPAPO/MLREFLOC Cross-Product Location Data for Inheritance

    /SAPAPO/SNP01 SNP: Demand Profile

    /SAPAPO/SNP02 SNP: Supply profile

    /SAPAPO/SNP04 Profile of Priorities Classes for Customer Demand

    /SAPAPO/SNP04_TD Time-Based Cost Profilees in Material Master

    /SAPAPO/SNP11 SNP: Deployment Profile

    /SAPAPO/SNPGRP Penalty Cost Groups

    /SAPAPO/SNPGRPT Description of Penalty Cost Groups

    /SAPAPO/SNPQUAN Customizing table for Quantity Based Penalties# values

    /SAPAPO/SNPQUANH Header table for Quantity Based Penalty

    /SAPAPO/SNPQUAT Description of Quantity Based Penalty Profile

    Add comment
    10|10000 characters needed characters exceeded

    • Table Name                     Short text

      /SAPAPO/MAT_MTRX               Matrices for Rules of Matrix Generation

      /SAPAPO/MAT_RULE               Rules for Setup Matrix Generation

      /SAPAPO/MATAPN                 Alternative Product Number

      /SAPAPO/MATBOD                 Product BOD Assignment

      /SAPAPO/MATEXEC                Product: Execution Data

      /SAPAPO/MATGPVAL               Product Group Values

      /SAPAPO/MATGROUP               Product Grouping

      /SAPAPO/MATINFO                Product Information

      /SAPAPO/MATKEY                 Product

      /SAPAPO/MATLANE                TS: Master Data Table Product/Lane

      /SAPAPO/MATLARES               TS: Master Data Table Product/Lane/Resourc

      /SAPAPO/MATLCP                 Materials Lifecycle Stages

      /SAPAPO/MATLOC                 Location Product

      /SAPAPO/MATLOCPR               Partner-Dependent Location Product Attribu

      /SAPAPO/MATLOCTD               Time-Dependent Location Product Fields

      /SAPAPO/MATLORES               TS: Master Data Table Product/Location/Res

      /SAPAPO/MATLOTSZ               Lot Sizes & Days' Supplies for Material Ma

      /SAPAPO/MATLPL                 Location Product Planner (with Planner Typ

      /SAPAPO/MATLSIM                Location Product with Planning Version

      /SAPAPO/MATLSINH               Location Product with Inheritance

      /SAPAPO/MATLSPP                SPP Relevant Location Product Attributes

      /SAPAPO/MATLWH                 Location Product for Location Warehouse

      /SAPAPO/MATLWHST               Location Product for Location Whse and Sub

      /SAPAPO/MATMAP                 Mapping Table for Products

      /SAPAPO/MATMOD                 Model assignment of location product

      /SAPAPO/MATNR_V                MATNR for Foreign Key Checks

      /SAPAPO/MATPACK                Product: Packing/Packaging Data

      /SAPAPO/MATPPM                 TS: Master Data Table Product/PPM

      /SAPAPO/MATPRIO                Product Priority Time & Version-Dependent

      /SAPAPO/MATPRMRM               Alternative units of measure for partner p

      /SAPAPO/MATPRT                 Partner Product Master Data

      /SAPAPO/MATPRTXT               Partner product description

      /SAPAPO/MATRELH                Product-Relevant Hierarchies and Hierarchy

      /SAPAPO/MATREPC                Replenishment Control

      /SAPAPO/MATREPCT               Replenishment Control

      /SAPAPO/MATRES                 TS: Master Data Table Location/Resource

      /SAPAPO/MATRGPT                Product Regional Pattern Assignment

      /SAPAPO/MATRQ                  Requirement Profile in Material Master

      /SAPAPO/MATRULET               Text Table of Rules for Setup Matrix Gener

      /SAPAPO/MATSBOD                Product BOD Assignment with Planning Versi

      /SAPAPO/MATSTOCK               Stock Information

      /SAPAPO/MATTXT                 Material Descriptions

  • avatar image
    Former Member
    Jul 03, 2014 at 07:32 PM

    I would not advice you to get your data from tables. EWM design is not same as simple as ECC design.

    Warehouse  monitor is one of the best thing provided by SAP  in EWM system.  You can create your custom monitor as well. 

    Regards

    Tushar

    Add comment
    10|10000 characters needed characters exceeded