Skip to Content
avatar image
Former Member

BEX Query - Need to Count no of days between Last billing date to current Billing date.

Below result need as highlighted field.

Bill No Cust ID Billing Date No of days 1 C001 2 C001 3 C002 4 C001 5 C002

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 12, 2017 at 12:16 PM

    hi

    create 1 keyfigures in your BW dataflow:

    -last billing date = billing date (exception aggregation= last value)I

    when it is not possible to do this on BW level you can create a formula variable on billing date and set there as well tj exception aggregation on last value

    for current billing dat I assume you want today/sy-date, so you can use a SAP standard formula variable TODAY.Use them both in a calculated key figure to get your nr of days in between.

    grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded