Question:
Dear All
We are facing one problem. For a Purchasing document called "CONTRACT" we have validity period i.e valid from and valid to also we have a document date. We would like to count valid contract in a month. I will give an example
Contract No Valid From Valid To Create Date
1 01.01.2004 31.01.2004 01.01.2004
2 01.01.2004 29.02.2004 01.01.2004
3 01.01.2004 31.03.2004 01.01.2004
Now we want the result as follows
period Count of Valid Contracts Count of Created Contracts
( Valid from & Valid To ) ( Create Date )
01.2004 3 3
02.2004 2 0
03.2004 1 0
We want these results in infocube or in ODS.
Regards
Rakesh
Answer:
we had done a slight variation of this earlier. We had a 'counter' KF inserted in the infocube and then created CKF on it in BeX.
Maybe you should look at "How to count occurences" on SAP service.
Hope that helps.
Answer:
Hi,
thats for 2.1c and you can find the same option in 3.0b BEx.
cheers
martin
Answer:
Thanks , I will try and have look on sap service