04-11-2006 3:02 PM
Hi Everybody
can anybody plz tell me the differnece between GET and GET LATE events along with pracitcal exs,, that funda is not getting cleared to me
Thanks in advance
04-11-2006 3:05 PM
HI,
Its pretty straight forward..GET LATE gets triggered after all other GET events are triggered.. ie right before END-OF-selection. PL take a look at DEMO_PROGRAM_GET_LATE.
Regards,
Sureshj Datti
04-11-2006 3:09 PM
Hi Nikita,
<b>GET</b>:
Returns after getting the single node in the workarea.
<b>GET LATE</b>:
Returns after getting all the records.
Please check this link for more information.
http://help.sap.com/saphelp_46c/helpdata/en/9f/db9abd35c111d1829f0000e829fbfe/frameset.htm
Here is sample program.
REPORT EVENT_DEMO.
NODES: SPFLI, SFLIGHT, SBOOK.
DATA WEIGHT TYPE I VALUE 0.
START-OF-SELECTION.
WRITE 'Test Program for GET <table> LATE'.
GET SPFLI.
SKIP.
WRITE: / 'Carrid:', SPFLI-CARRID,
'Connid:', SPFLI-CONNID,
/ 'From: ', SPFLI-CITYFROM,
'To: ', SPFLI-CITYTO.
ULINE.
GET SFLIGHT.
SKIP.
WRITE: / 'Date:', SFLIGHT-FLDATE.
GET SBOOK.
WEIGHT = WEIGHT + SBOOK-LUGGWEIGHT.
GET SFLIGHT LATE.
WRITE: / 'Total luggage weight =', WEIGHT.
ULINE.
WEIGHT = 0.
The total luggage weight is calculated for each flight in the event GET SBOOK, and then displayed in the list and reset in the event GET SFLIGHT LATE.
Hope this will help.
Regards,
Ferry Lianto
04-11-2006 3:10 PM
Thanks Suresh for your reply
but what should be the sequence
is it the same as that of GET events
04-11-2006 3:13 PM
Hi
GET
Basic form 1
GET dbtab.
Additions
1. ... LATE
2. ... FIELDS f1 ... fn
Effect
Processing event.
Gets the table dbtab for processing while the logical database is running. You can address all the fields from dbtab in the subsequent processing. You can also refer to fields from tables in the logical database on the access path to the table dbtab .
Note
You can use the event " GET dbtab. " only once in the report.
Example
The program uses the logical database F1S which has a structure where the table BOOKING appears below the table FLIGHT .
TABLES: SFLIGHT, SBOOK.
GET SFLIGHT.
WRITE: SFLIGHT-CARRID,
SFLIGHT-CONNID,
SLFIGHT-FLDATE,
SFLIGHT-PLANETYPE.
GET SBOOK.
WRITE: SBOOK-BOOKID,
SBOOK-CUSTOMID,
SBOOK-ORDER_DATE.
Addition 1
... LATE.
Effect
Executes the code following " GET dbtab LATE. " only when all the subordinate tables have been read and processed.
Example
Count the smokers among the bookings already made.
TABLES: SFLIGHT, SBOOK.
DATA SMOKERS TYPE I.
GET SFLIGHT.
ULINE.
WRITE: / SFLIGHT-SEATSMAX,
SFLIGHT-SEATSOCC.
SMOKERS = 0.
GET SBOOK.
CHECK SBOOK-SMOKER <> SPACE.
ADD 1 TO SMOKERS.
GET FLIGHT LATE.
WRITE SMOKERS.
Addition 2
... FIELDS f1 ... fn
Effect
Performance option. Addresses only the fields f1, ..., fn of the tabelle dbtab (also possible with a dynamic ASSIGN ). Since only these fields have to be assigned values by the logical database, this can improve performance considerably.
Examples
Specify the necessary fields under GET . Both SFLIGHT and SBOOK must be defined for field selection.
TABLES: SFLIGHT, SBOOK.
GET SFLIGHT FIELDS CARRID CONNID FLDATE PLANETYPE.
WRITE: SFLIGHT-CARRID,
SFLIGHT-CONNID,
SFLIGHT-FLDATE,
SFLIGHT-PLANETYPE.
GET SBOOK FIELDS BOOKID CUSTOMID ORDER_DATE.
WRITE: SBOOK-BOOKID,
SBOOK-CUSTOMID,
SBOOK-ORDER_DATE.
Addition 1
... LATE.
Effect
Executes the code following " GET dbtab LATE. " only when all the subordinate tables have been read and processed.
Example
Count the smokers among the bookings already made.
TABLES: SFLIGHT, SBOOK.
DATA SMOKERS TYPE I.
GET SFLIGHT.
ULINE.
WRITE: / SFLIGHT-SEATSMAX,
SFLIGHT-SEATSOCC.
SMOKERS = 0.
GET SBOOK.
CHECK SBOOK-SMOKER <> SPACE.
ADD 1 TO SMOKERS.
GET FLIGHT LATE.
WRITE SMOKERS.
Note
You can use the event " GET dbtab. " only once in the report.
Example
The program uses the logical database F1S which has a structure where the table BOOKING appears below the table FLIGHT .
TABLES: SFLIGHT, SBOOK.
GET SFLIGHT.
WRITE: SFLIGHT-CARRID,
SFLIGHT-CONNID,
SLFIGHT-FLDATE,
SFLIGHT-PLANETYPE.
GET SBOOK.
WRITE: SBOOK-BOOKID,
SBOOK-CUSTOMID,
SBOOK-ORDER_DATE.
Thanks
Mrutyunjaya Tripathy
04-11-2006 3:17 PM
actully i used uline statement in get late event
but the line is going beyond the page width
so can anybody plz tell me why its happening and whats the solution for it
04-11-2006 3:29 PM
hey nikita
u can check these fallowing links these may be helpful for u
http://help.sap.com/saphelp_46c/helpdata/en/9f/db9abd35c111d1829f0000e829fbfe/frameset.htm
http://help.sap.com/saphelp_erp2005/helpdata/en/d2/cb4538455611d189710000e8322d00/frameset.htm
GET PERNR event initiates the data extraction for a pernr.
GTE PERNR LATE event is triggered after all the other events are triggered and right before the end-of-selection.
You can run this report EXAMPLE_PNP_GET_PAYROLL in debug mode & see for yourself, when each event is triggered..
Regards
naveen
04-11-2006 3:38 PM
Hi
Check out with the position of the uline from where it is getting started.
Thanks
Mrutyunjaya Tripathy