Skip to Content
avatar image
Former Member

Count sales orderitem

hello gurus,

i am counting sales order item

when i count order items from billing document they r giving wrong values b'coz here some materials are repeated in the billing doucment so i just want to count the items with different material in a billing document.

when i put sales org, billing doc number, sales order doc number, material and sales order item iam getting values correct but i just want to place sales org in drill down

can any one solve my problem

maximum points will be given

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Aug 16, 2007 at 11:17 AM


    this link exactly deals with your requirement that is the item and there respective materials.

    have a look on that.


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Ajeet,

      This how to document pertains to version less than BW 3.X - and with BW 3.X and higher you can use exception aggregation with counting all values..

      Do you see any scenario why would not be using exc aggr?

      Thanks in advance


  • avatar image
    Former Member
    Aug 19, 2007 at 08:19 PM

    Hi Dear

    I got your Point. Follow the below steps

    1. Create a CKF name Count.

    2. Restrict it on a variable ( create a formula variable)

    3. Processing type as replacement path

    4. select a reference characteristic based on whiich you want to count the records, take max granularity.

    5. Select "attribute value " in Replace variable with option

    6. Assign this variable to CKF created in starting and multiply it by 1. Because system don't allow a KF to have only variable as restriction so just multiply by 1 or add 0.

    7.Last step is to select Time of calculation as "after aggregation" in CKF property.

    Include this CKF in your report it will display the result which you want.

    Assign points if it help you.


    Tripple k

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Tripple K,

      Iam getting counts as 2 for some sales doc and getting 1 for some sales doc

      which is its getting double for some docs

      could u plz help me out with this problem

      i will surely assign points if u could so