topic ldb in Application Development and Automation Discussions

ldb

Former Member — Fri, 30 Mar 2007 06:54:39 GMT

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.

Re: ldb

Former Member — Fri, 30 Mar 2007 07:01:15 GMT

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

Re: ldb

Former Member — Fri, 30 Mar 2007 07:07:37 GMT

client independent

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.

number of primary keys

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