Uline statement in report

[Former Member]

Hi guyz

I m back here

therz again sm problem in the same program thatz sapbc405_ldbs_2

actually i coded the program in the similar way as that of std program except that i have first included INCLUDE statement in the program and than by double clicking on it navigated to include program..so this is the only difference betn two programs

Now the problem is here

i kept uline stmt in gate late sflight and uline. new page. in gate late spfli,

but these horizontal lines are going beyond page width that i already set using line size stmt

Also list heading and column headings are going beyond the page length,,

can anybody tell the reason for this??

Thanks in advance.

[Former Member]

Rashmi,

I don't think you are in the right direction. Logical Database are more or less outdated except for HR ones. I suggest that you pick up other examples.

And more over I don't see that program in my system.

Regards,

Ravi

[Former Member]

Hey Ravi

u said LDBs are outdated

can u plz tell me than what approach usually consultants follow for reading data from multiple tables..

or whatz the replacement for LDB's??

actually what m thinking is first get thorogh with the basic things those mentioned in certificaiton books..

can u plz tell me on which topics should i concentrate more or that are actually used in industry??

can u plz give me right approach to hav a mastery over this ??

Thanks in advance

[Former Member]

Rashmi,

Instead of LDB's, we can directly write our own SELECT statements against the tables. The problem with LDB's was the performance issues.

Take a look at this link .. you will get a basic idea.

http://www.sap-img.com/abap/

Regards,

Ravi

Note : Please mark all the helpful answers

[Former Member]

Try to format list report.

example:

REPORT rep_name LINE-SIZE 120 LINE-COUNT 90 .

BR, Jacek

[Former Member]

Hi,

how much you gave line-size ?

and it should be<b> LINE-SIZE 83</b> , in the program which you mentioned.

please show your code...

it depends up on your coding..

Regards

vijay

[Former Member]

INCLUDE BC405_LDBS_2TOP.

*&---------------------------------------------------------------------*
*&   Event GET SPFLI
*&---------------------------------------------------------------------*
GET SPFLI.
* Data output SPFLI
  FORMAT COLOR COL_HEADING INTENSIFIED OFF.
  WRITE:  / SY-VLINE, SPFLI-CARRID,
            SPFLI-CONNID,
            SPFLI-CITYFROM,
            SPFLI-AIRPFROM,
            SPFLI-CITYTO,
            SPFLI-AIRPTO,
            AT <b>LINE_SIZE</b> SY-VLINE.


*&---------------------------------------------------------------------*
*&   Event GET SFLIGHT
*&---------------------------------------------------------------------*
GET SFLIGHT.
* Calculate free seats
  FREE_SEATS = SFLIGHT-SEATSMAX - SFLIGHT-SEATSOCC.

* Data output SFLIGHT
  FORMAT COLOR COL_NORMAL INTENSIFIED ON.
  WRITE: / SY-VLINE, SFLIGHT-FLDATE,
           SFLIGHT-PRICE CURRENCY SFLIGHT-CURRENCY,
           SFLIGHT-CURRENCY,
           SFLIGHT-PLANETYPE,
           SFLIGHT-SEATSMAX,
           SFLIGHT-SEATSOCC,
           FREE_SEATS,
           AT <b>LINE_SIZE</b> SY-VLINE.

*&---------------------------------------------------------------------*
*&   Event GET SBOOK
*&---------------------------------------------------------------------*
GET SBOOK.

* Check select-option
  CHECK SO_CUST.

  FORMAT COLOR COL_NORMAL INTENSIFIED OFF.
  WRITE: / SY-VLINE, SBOOK-BOOKID,
           SBOOK-CUSTOMID,
           SBOOK-SMOKER,
           SBOOK-LUGGWEIGHT UNIT SBOOK-WUNIT,
           SBOOK-WUNIT,
           SBOOK-ORDER_DATE,
           AT <b>LINE_SIZE</b> SY-VLINE.

*&---------------------------------------------------------------------*
*&   Event GET SPFLI LATE
*&---------------------------------------------------------------------*
GET SPFLI LATE.
  ULINE.
  NEW-PAGE.
*&---------------------------------------------------------------------*
*&   Event GET SFLIGHT LATE
*&---------------------------------------------------------------------*
GET SFLIGHT LATE.
  ULINE.

the code in the include is

REPORT   SAPBC405_LDBS_2 <b>LINE-SIZE 83</b>.

* Used nodes of the structure of the logical database F1S
NODES: SPFLI, SFLIGHT, SBOOK.

* Additional selections
SELECTION-SCREEN BEGIN OF BLOCK ORDER WITH FRAME.
SELECT-OPTIONS: SO_CUST FOR SBOOK-CUSTOMID.
SELECTION-SCREEN END OF BLOCK ORDER.

* Variables
DATA: FREE_SEATS LIKE SFLIGHT-SEATSOCC.

* Constants
CONSTANTS: <b>LINE_SIZE</b> LIKE SY-LINSZ VALUE <b>83</b>.

concentrate on Bold codes, since you have changed line-size definitely every thing going to change , try to check properly and adjust the line-size to get proper output..

regards

vijay

[Former Member]

No Vijay

I have given same line size thaz 83

[Former Member]

Hi,

LDB's are not outdated...

and did you change the full report, if so show your code, ..

since you changed your code the format is going to change , and then according to your output fields length you need to set the line size, can you show the code, so that it is easy to tell what should be the line-size ?

Regards

vijay

[Former Member]

No Vijay

I din change the complete report

the difference between the two programs i already mentioned as (actually i coded the program in the similar way as that of std program except that i have first included INCLUDE statement in the program and than by double clicking on it navigated to include program..so this is the only difference betn two programs

Now the problem is here)

Thanks

[Former Member]

Hi Rashmi,

there also they have include inside it.

if you can show that report it is easy to identify.

Regards

vijay

[Former Member]

Hi Vijay

In the demo program ,first statment is Include and in Include program therz Report statement while in my program Report statement is in Main program ..this is the only difference.

I hope u got the point.

And one more thing.. I got the desired o/p in my program by using uline at 1(83) statement but din get why Uline not working and why its exceeding line_size thatz 83.

Thanks

[Former Member]

Ok, did you use the same include as it is.

if so what did you mentioned

here

REPORT ZREPORT LINE-SIZE <b>83.</b> <<<--what is your value

and in the include also there is another same statement.

REPORT ZREPORT LINE-SIZE 83 <<<-- this is there...

if they mismatch then it is a problem..

yes you get the proper output since previously they used LINESIZE one constant here this constant is not 83 that is the reason you got different format, now you are using 1(83).

Regards

vijay

[Former Member]

Hey Vijay

i got it

i did very silly mistake

forgot to mention line-size with report statement

now its working fine

thanks for ur reply