i am creating multiprovider using Copa cubes ,sales open order cube ,sales deleveries cube.in this cubes material,ship to,customer,customer hierarchy ,product ,sales organization are characteristics using.
Now business want Batch code to be included from MCHA-CHARG.i have tracked CHARG field is coming in 2LIS_11_VAITM.
how do I know this field is coming from MCHA table.
please advice how can I add this field into multiprovider???
Gajesh Nagesh replied
1) The batch number CHARG if maintained in the sale order line item will be available in 2LIS_11_VAITM. You can see this in the Sales A view in the sale order line item. If business is asking you to bring in batch then I suppose they are referring to this field.
2) You will have to bring this in your sales cube first and then to multiprovider.
Please let me know your feedback