Skip to Content
avatar image
Former Member

Purchase GR Quantity values

Hi All,

I am using the standard purchasing Data Infocube for the Purchase variance report, now i actually want to know how Actual GR Qty is calculated because the GR Qty values in my Infocube do not match the R/3 GR Qty , can someone help me out as i tried really hard but couldnt and also how will i know how data is passing from the Datasource to the Infocube...

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Sep 22, 2010 at 08:00 AM

    HI ,

    Actually in the update rules of the cube , the qunatity is being converted from PO Units to Base units , you should consider that while validating the data

    And the Actual GR quantity is derived based on the below condition

    COMM_STRUCTURE-PROCESSKEY = '002' or

    COMM_STRUCTURE-PROCESSKEY = '012' or

    COMM_STRUCTURE-PROCESSKEY = '022'

    AND COMM_STRUCTURE-BWAPPLNM EQ 'MM'

    AND COMM_STRUCTURE-CPQUAOU <> 0.

    BWMNG --> 0CPQUAOU (Gross purchase order value )

    BWVORG --> 0PROCESSKEY ( you can find the below info in help.sap )

    BWVORG u2013 Transaction Key SAP BW

    This field identifies the event that is based on the information in the DataSource. The contents of this field determines the importance and the behavior of other fields in the DataSource. The field ALIEF (Number of Deliveries) is, for example, only filled if the event is a goods receipt.

    For more information, see SAP Note 684465: BWVORG for Purchasing Data

    Hope this is usefull ,

    Sathya

    Add comment
    10|10000 characters needed characters exceeded