topic Re: logical database in Application Development and Automation Discussions

logical database

Former Member — Tue, 11 Apr 2006 14:02:43 GMT

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

Re: logical database

suresh_datti — Tue, 11 Apr 2006 14:05:35 GMT

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

Re: logical database

ferry_lianto — Tue, 11 Apr 2006 14:09:04 GMT

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

Re: logical database

Former Member — Tue, 11 Apr 2006 14:10:39 GMT

Thanks Suresh for your reply

but what should be the sequence

is it the same as that of GET events

Re: logical database

Former Member — Tue, 11 Apr 2006 14:13:05 GMT

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

Re: logical database

Former Member — Tue, 11 Apr 2006 14:17:18 GMT

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

Re: logical database

Former Member — Tue, 11 Apr 2006 14:29:13 GMT

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

Re: logical database

Former Member — Tue, 11 Apr 2006 14:38:26 GMT

Check out with the position of the uline from where it is getting started.

Thanks

Mrutyunjaya Tripathy