Skip to Content
author's profile photo Former Member
Former Member

How will i get Netorder value against contract

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2007 at 09:19 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2007 at 12:48 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 27, 2007 at 04:58 AM

    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
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.