Skip to Content
0

Difference between M and P tables of Master Data

Jan 11, 2017 at 08:52 AM

717

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Shanthi Bhaskar Jan 11, 2017 at 03:52 PM
1
Please check in web or SDN before posting any questions.
Share
10 |10000 characters needed characters left characters exceeded
Koen Hesters Jan 11, 2017 at 09:48 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Koen Hesters Jan 11, 2017 at 08:58 AM
0
Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0