Hello - within my current company's SAP-R3 environment, end-users are able to make changes directly to an already existing sales order line item, as opposed to creating a new sales order line item. For instance, on 2/27 a customer calls an end-user and books an order for 100 widgets... So, the end-user creates a sales order, with a sales order line item for 100 widgets (2/27 = Sales Order Line Item Create Date). Next, on 3/10, the customer calls up the end-user and wants to increase their order to 150 widgets. Subsequently, the end-user changes the quantity directly on the sales order line item, to 150 widgets. The problem: when SAP-BI extracts the data, it extracts the sales order line item data as 150 widgets booked on 2/27. However, the true booking value should be 100 widgets booked on 2/27, and then 50 widgets booked on 3/10. One obvious solution is for the end-user to simply create a new line item to reflect the customer activity properly. However, that is not an option (the end-users are not willing to change their business process for this type of scenario). Consequently, the standard SAP-BI extractors are not able to pull sales order line item details that properly reflect the sales activity... Does anyone have any suggestions on how SAP-BI can extract the sales order line items in so that they reflect the true booking value on 2/27 and 3/10?
Thank you in advance for any suggestions!