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.
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
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.
Add a comment