Skip to Content
avatar image
Former Member

Difference between M and P tables of Master Data

Hi,

What is the difference between M and P tables of any master data. As I see M is view table but what is the significance of this table and where/ which scenario this will be useful?

Also, I need to know from performance point of view if we use M table instead of P in any lookup code in routines, will the read performance increase/ decrease?

Regards,

Ravi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 11, 2017 at 03:52 PM
    Please check in web or SDN before posting any questions.
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11, 2017 at 09:48 AM

    Hi,

    the document states:

    /BI*/M<INFOOBJECTNAME>

    • A Database View defined as the Union of Time Dependant and Time Independent Master Data Attributes

    /BI*/P<INFOOBJECTNAME>

    • Stores values of Time Independent Attributes
    • exists, if the flag ‚With master data‘ in RSD1 is switched on, even if the characteristic does not have attributes

    Meaning, M includes time dependant attributes, P is not.

    So If you want to do a select / read table on M or P, you first have to know if you want to fetch time dependant data.

    In most cases P will suite you well.

    Kind regards,

    Koen

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11, 2017 at 08:58 AM
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Koen,

      I went through the link but unfortunately does not answer my queries. Please check the questions once and let me know if you can help.

      Regards,

      Ravi