How to create Actual Sales and plan Sales at query level

[Former Member]

Hi..All,

I need to create Sales report. for this I am  using 0SD_C03  cube . at report level  customer wants see COST of SALES , Actual Sales and Plan Sales .

for this requirement i identified character objects are VALUE TYPE and VALUE VERSION. please let me know what is the Key figure for to restrict    this objects .its very help full to me   

[former_member186399 · Accepted solution]

Hello Surya,

clarify whether  by plan you mean the sales order booking value and by actual is the billing.

if yes then the standard LOs can get you the data. For plan use 2lis_11_Vaitm and for actual use 2lis_13_vditm

Regards

Gajesh

[Former Member]

Hi..Friends,

In my company they are not provide any FS and TS for all reports .plz kindly help me on this.