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.
Martin Maruskin replied
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.