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

urgent: regarding ALV report display problem

hi,

There are 3 problems:-

1.) I had made a ALV report in which i have to display 'POSTING DATE' (iseg-budat) when we execute the report i.e. it should be displayed as PERIOD :- _______ to _______ on alv report ..

2.)the 2nd problem is dat when i use the ' wa_fieldcat-no_zero = 'X'. It eliminates all the leading zeros which are present which is okay when i it displays material no.. but the problem is dat it also deletes the other fields where the values are to be zeros.

i had used this FM:-

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

EXPORTING

INPUT = ITS1-MATNR

IMPORTING

OUTPUT = ITS1-MATNR.

so that only matnr field are to be 0's.

3.) I want to delete the rows which use to contain the values 0's as there are no calculations are performing as these are displayed .

ANYbody having solution of this problem ,plzzzz provide the soluion of it as it is most urgent to me and dat person will definately rewarded.

regards,

ric.s

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Dec 01, 2007 at 10:05 AM

    Ric,

    For BUDAT displaying as per your requirements you can follow what I had given down here

    CONCATENATE S_BUDAT-LOW6(2) '.' S_BUDAT-LOW4(2) '.' S_BUDAT-LOW+0(4) INTO DATE1.

    CONCATENATE S_BUDAT-HIGH6(2) '.' S_BUDAT-HIGH4(2) '.' S_BUDAT-HIGH+0(4) INTO DATE2.

    And at the ALV events

    CONCATENATE STRING1 P_WERKS DATE1 'to' DATE2 INTO TITLE SEPARATED BY SPACE.

    WALISTHEADER-TYP = 'H'.

    WALISTHEADER-INFO = TITLE.

    APPEND WALISTHEADER TO ITLISTHEADER.

    This I am giving by assuming that you know how to get the top of page in ALV.

    2.The 2nd problem I guess can be solved if you can validate it with the column number,try doing that.

    3.The 3rd problem to delete all the entries where the currency values are zero you can use the below given logic.

    LOOP AT itfinal.

    IF NOT ( itfinal-witht = 'T1' OR itfinal-witht = 'T2' ) OR ( itfinal-wt_qsshh = '0.00' ).

    DELETE itfinal.

    ENDIF.

    ENDLOOP.

    If any doubts revert.

    K.Kiran.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Kiran K

      hi kiran,

      thanks for ur help it had completed my requirement somehow but i have to do changes in the format. can i have ur email id where i can send u the format of it,otherwise i am displaying it right here :-

      PHYSICAL INVENTORY REPORT

      PERIOD:- ___ TO ___ (ISEG-BUDAT)

      PLANT:-_________

      CONTROL NO. :- ______

      CONTROL DATE :- _____

      I AM ABLE TO DISPLAY THE PLANT FILED BUT I WANT TO DISPLAY THIS BUDAT FIELD.

      moreover how to perform the logic of deleting the deleted rows having zeros.

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.