Difference between M and P tables of Master Data

[former_member212011]

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

[kohesco]

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

[shanthi_bhaskar]

Please check in web or SDN before posting any questions.

[kohesco]

Hi,

check link:

https://wiki.scn.sap.com/wiki/display/BI/Master+Data+Tables

Grtz

Koen

[former_member212011]

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