on 09-14-2014 10:42 PM
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.
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./
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello experts - thanks quick replies.how do I assign points.i do not know since they changed everythin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.