Skip to Content
avatar image
Former Member

Mapping fiscal year/ period to 0BILL_DATE at query level

Hello Friends,

There are two existing reports which are based on two different infoproviders.

In one cube 0fiscper is mapped to 0BILL_DATE and another cube 0fiscper is mapped to 0CREATEDON.

Fiscalyear variant is : V3 ( Apr - Mar )

There is one debit memo request in R/3 , in which " Created on " date is 01.10.2007 comes in Fiscal year/period ( 007.2007 ) and " Billing date " field is 28.09.2007 comes in Fiscal year/period ( 006.2007 ).

when user execute these reports , obviously same information abt this document fall in different fiscal periods because of the mapping at cube level.

Users want me to change one report in which fiscal year ./ period should also refer to " Billing date " so both reports shows the doc information in same period.

If i change this at cube level will effect too many other queries depending on this cube.

How can i achieve this at query level?

please advise..

Regards,

SRIKANTH

Message was edited by:

KANTH SRI

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 10, 2007 at 12:22 PM

    Hi

    Create a variable with replacement path processing type where you take Bill_NUM for fiscal year period and this variable you can use only for this query....It could be a formula variable you are using only for this query

    Regards

    N Ganesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi anil garu,

      How to show billing date wise reporting in 0sd_c03.

      My client message "BW infocube to use invoice date to calculate the
      selection criteria rather than creation date"

      can you please explain where to add map 0bill_date in updaterules because only vdhdr and vditm datasources have 0bill_date field.All the other datasources including billing datasources are mapped currently nwith ERDAT creation date but my user wants billing date/invoice date.

      so please explain me ,if i change the erdat mapping with fkdat in header and item of billing will that meet my requirement.and it wont affect all other datasources and data in my cube.

      thanks in advance

  • avatar image
    Former Member
    Oct 10, 2007 at 11:40 AM

    Hi,

    This is possible only if bothe these infoproviders have Bill_Date. If it is present in on the infoprovider then create query based on this otherwise you have to add this infoobject in the other infoprovider.

    Regards

    SSS

    Add comment
    10|10000 characters needed characters exceeded