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

  • Follow
  • 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