‎2007 Mar 30 7:54 AM
HI,
wt is the diff between get and get late?
how many primary keys we can create for a table?
pls give me example of client independent field?
thanx in adv.
‎2007 Mar 30 8:01 AM
Hi,
GET will fetch the table data immediately
GET LATE
In the LDB when you define the table structure in hierarchy, first it will fetch the higher node data and then all the below node tables data and comes to a second record in the top node table. for this GET Late is used.
You can create any number of primary keys in a table
Script forms (developed in SE71) are client dependent and the programs developed in SE38 are client independent.
reward if useful
regards,
Anji
‎2007 Mar 30 8:01 AM
Hi,
GET will fetch the table data immediately
GET LATE
In the LDB when you define the table structure in hierarchy, first it will fetch the higher node data and then all the below node tables data and comes to a second record in the top node table. for this GET Late is used.
You can create any number of primary keys in a table
Script forms (developed in SE71) are client dependent and the programs developed in SE38 are client independent.
reward if useful
regards,
Anji
‎2007 Mar 30 8:07 AM
<u><i><b>client independent</b></i></u>
Dont give MANDT field in table. Then it becomes client indepentent .
the structure of the table is not client-dependent - only the content of the table
records at the table whose first field is MANDT with type MANDT, are client depemdents.
THESE ARE SOME CHARACTERISTICS OF CLIENT DEPENDENT AND CROSS CLIENT TABLES.
Client-Dependent Tables
Class A and C: Data is only imported into client 000. Existing data records are overwritten.
Class E, S and W: Data is imported into all clients. Existing data records are overwritten.
Class G: Existing data records are overwritten in client 000. In all other clients, new data records are inserted, but existing data records are not overwritten.
Class L: No data is imported.
Cross-Client Tables
Classes A, L and C: No data is imported.
Classes E, S, and W: Data is imported. Existing data records with the same key are overwritten.
Class G: Non-existent data records are inserted, but no existing data records are overwritten.
<u><i><b>number of primary keys</b></i></u>
Many Primary Keys = Composite Key.
i.e some set of columns will enable you to identify a unique row from a set of rows in the table.
This can be achieved by checking the primary key check box in se11.
number is restricted by ur need or the numbers of colums in the table
Hope it helps.
reward accordingly
navjot