how do i link an sap table with a different date field with my calendar

[fashid]

Hi everybody,

I have a table MSEG from SAP which i need to include in my current data model .

I have a master calendar created on the transaction table VEKP.

The MSEG table has a field posting_date.

I am failing to understand how do i connect it with my current data model .

I have tried to link it with material code but the master calendar does not work .

I have attached a screenshot of the data model for reference.

Please help

Regards,

Nadeem shaikh

[SergeyMak]

Hi,

Could you explain your business requirements.

It looks like you need to concatenate two data tables... but everything depends on your requirements..

Regards,

Sergey

[fashid]

Hi,

I need to calculate this formula which is based on the MSEG table

=sum({<Material_Code={600327,600329,600373,607369},[MSEG.Movement Type_BWART]={'261','262','701','702'}>}MSEG.Quantity)/(Sum({<[MARA.Material Type_MTART]={'FERT'}>}[VEKP.Loading weight_NTGEW]/1000)) .

I have already built the formula but the dates do no effect the chart that i have created using the above formula .

[SergeyMak]

So. I don't know why did you connect your calendar to VEKP and GLASS_MELT,

but because as I see it's a Material Management you probably need it.

So, as a solution you can create another calendar and connect it to Posting Date.MSEG

Regards,

Sergey

P.S. AS I remember in one of the MM apps I had around 5 calendars. It's not bad, if you need it.

[fashid]

Hi,

I am sorry for the late reply ,was travelling .

I connected the master calendar because the VEKP was the main transaction table.

With reference to your reply I have question if you could please clarify, you mean to say for this particular KPI i will have to use a completely different master calendar which will have to stay away from the dashboard on a different sheet and that calendar will used only for that particular report??? .

Regards,

Nadeem

[SergeyMak · Accepted solution]

I don't call it like MASTER calendar, just another calendar table.

Why not? and you can show this calendar as Year, Month etc on the particular tab only.

Regrades.

Sergey

[Peter_Cammaert]

IMHO you'll have to find a connection between VEKP (Sales/delivery doc headers) and MSEG (Movements) first. Otherwise you'll be dividing unrelated things in your formula. I'm guessing that MATNR will not be enough.

A connection between MSEG and VEPO (SD items) will probably be easier to find, after which you can JOIN in the headers from VEKP