Skip to Content
0
Former Member
Dec 01, 2006 at 03:05 PM

How to load sales invoiced data based on sales order type ?

63 Views

Dear Gurus,

I'd like to load the sales invoiced quantity/amount based on sales order type , could you pls give some guide.

0doc_type is added into our InfoCube copeied from 0sd_c03, our Cube is updated from Order( 2LIS_11_VAHDR, 2LIS_11_VAITM), Delivery( 2LIS_12_VCHDR, 2LIS_12_VCITM) and Billing ( 2LIS_13_VDHDR , 2LIS_13_VDITM). I find only Order DS ( 2LIS_11_VAITM and 2LIS_11_VAHDR) has field AUART

--- 0doc_type for sales order type, this makes me to concern how I can get the billing data based on sales order type since there is no link between 0doc_type with Billing Key Figure from 2LIS_13_VDHDR , 2LIS_13_VDITM .

Do I need enhance filed AUART to DS 2LIS_13_VDHDR , 2LIS_13_VDITM ?

Your kind help will be highly appreciated.

Thanks !