Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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..



Message was edited by:


Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question