Skip to Content
0
Former Member
Feb 26, 2007 at 04:30 AM

How will i get Netorder value against contract

34 Views

Hi,

I have loaded 2lis_02_hdr, itm, scl datasources in to customized cube which contains Purchasing document(EBELN), Item(EBELP), Doctype(BSART), Contract(KONNR), Item(KTPNR), Netordervalue(NETWR)

Here my requirment is I want to cummulate Netordervalue against Contract no.

In query level if I selected Purchasing doc with doctype=WK(it means it is value Contract), it is not showing any Ordervalue against Contract.

How will acheive this to get Cumulative order value against Contract.

Please share your suggestions to acheive this requirement.

For clarifications please revert back.

Thanks in Advance

sudhir.