Modifying MP

[former_member820887]

Hello experts,

we have MP contains FICO data , sales data.customer wants material batch code from MCHA-CHARG field . Sales extractor has VBAP-CHARG but not all data  coming in.which MCHA-CHARG has.please advice ? How can I add this field into Multiprovider and into report ?

THanks in advance.

[MartinMaruskin · Accepted solution]

Hi Bond,

if material batch data is not coming from datasources involved in FI-CO/sales cube they you need to enhance the cube (or even underlying DSO if there is any) for this field. Once you have it in the cube/DSO you can look up material batch from other datasources (typically 0BATCH here it is coming form MCHA-CHARG).

The lookup key will be material and batch no. By this your cube will contain material batch at transactional level.

cheers

m./

[former_member820887]

Hello experts - thanks quick replies.how do I assign points.i do not know since they changed everythin

[chanda]

Hi ,

Have you checked if there is any filter in the query?

Try running your query only only sales cube and see if it fetches all the records. You can do this by selecting only sales cube ( under Dimension Data Package - info provider--> restrict to only sales  ).

Lets see how it goes from here.

Regards,

Sudhir