How will i get Netorder value against contract

[Former Member]

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.

[Former Member]

Hi,

For the above requirment I have coded a program in Endroutine but it is not populating cummulative Order value against Contract.

DATA:

WA_ty_t_TG_1 TYPE tys_TG_1.

data: netsum type char15.

types:begin of ty_net,

netsum type /BI0/OINET_PO_VAL,

V_EBELN TYPE /BI0/OIOI_EBELN,

end of ty_net.

data:t_net type standard table of ty_net .

data:wa_net type ty_net.

SORT RESULT_PACKAGE BY CONTRACT.

<b>loop at RESULT_PACKAGE INTO WA_ty_t_TG_1.</b>

WA_NET-V_EBELN = <RESULT_FIELDS>-CONTRACT.

AT END OF CONTRACT.

netsum = WA_ty_t_TG_1-NET_PO_VAL + NETSUM.

ENDAT.

WA_NET-netsum = NETSUM.

APPEND WA_NET TO T_NET.

CLEAR:T_NET,NETSUM.

ENDLOOP.

loop at RESULT_PACKAGE assigning <RESULT_FIELDS> .

READ TABLE T_NET INTO WA_NET WITH KEY

V_EBELN = <RESULT_FIELDS>-CONTRACT

.

<RESULT_FIELDS>-/BIC/YNET_VAL = NETSUM.

CLEAR: WA_NET-NETSUM.

endloop.

<RESULT_FIELDS>-/BIC/YNET_VAL = netsum.

CLEAR:NETSUM,<RESULT_FIELDS>-/BIC/YNET_VAL.

ENDLOOP.

I have coded above one..let me know what mistake I have done.in the bolded loop I have given INTO instead of Assigning, because I need all records which assigns to WorkArea, but while executing DTP its leading to shortdump.if I replace Assigning statement,its working fine. but zero values in output( I think wrong in logic part)

Let me know the brief coding part if I am wrongly coded.

Thanks in Advance

sudhir.

[Former Member]

The field NETWR is not getting filled. Check the value for the field NETWR in the source system, check the corresponding field in the BW and compare. Also, check take a contrcat and go to RSA3 in SAP and check the value of the field NETWR and compare this to the value in BW and you will know what you miss.

Check the update rules and transfer rules and mapping for the field NETWR.

Ravi Thothadri

[Former Member]

Hi

Please check whether your contract field is mapped or not in update rules for this key figure(net order value) and also check any start routines exist in update rules to delete order type = 'wk'..

Hope it helps

Thanks

Teja