topic reg: data dictionary? in Application Development and Automation Discussions

reg: data dictionary?

Former Member — Fri, 28 Jul 2006 07:03:39 GMT

hello everybody,

how many indexes can be created for a table?

can you create a table with out a data element?

can you create a field with out a data element?

Give few names of cluster tables in sap?

Give few names of pooled tables in sap?

give few names of transparent tables?

what is table maintenance generator and how to create

that? What is the transaction code?

How to add new fields to a standard sap table ?

selva

Re: reg: data dictionary?

Former Member — Fri, 28 Jul 2006 07:07:46 GMT

Hi,

how many indexes can be created for a table?

--- No limitations

can you create a table with out a data element?

---Yes u can by using data types directly while filed creation

can you create a field with out a data element?

--Yes u can by using data types directly

Give few names of cluster tables in sap?

Give few names of pooled tables in sap?

BSEG,BKPF etc...

give few names of transparent tables?

VBAK,VBAP,EKKO,EKPO...etc..

what is table maintenance generator and how to create

that? What is the transaction code?

--BY SM30 u can create table maintainence, it is used to enter data into custom created tables via screens

How to add new fields to a standard sap table ?

craete a Z structure with zfields and include that in SAP table uing APPEND STRUCTURE..

Sreedhar

Re: reg: data dictionary?

dani_mn — Fri, 28 Jul 2006 07:08:49 GMT

HI,

<b>1. as many you want. there is always a primary index for every table which consists of key fields.

2. yes.

3. yes you can.

4. BSEG

6. BKPF, FMFCTR, BSIS, BSAS, BPJA,

7. 'SE56' is the transaction.

Table Maintenance used for insertion, modification, updation in tables.

8. Enhancements available then there is a include in which you can add your new fields, otherwise you have to modify table.</b>

Regards,

Wasim Ahmed

Message was edited by: Wasim Ahmed

Re: reg: data dictionary?

Former Member — Fri, 28 Jul 2006 07:09:18 GMT

Hi selva,

1. how many indexes can be created for a table?

It depends upon the database limit.

can you create a table with out a data element

Yes, we can create.

can you create a field with out a data element

Yes

4. Give few names of cluster tables in sap?

BSEC One-Time Account Data Document Segment

BSED Bill of Exchange Fields Document Segment

BSEG Accounting Document Segment

BSES Document Control Data

BSET Tax Data Document Segment

CDPOS Change document items

Give few names of pooled tables in sap?

A012 Additional Selling Plant/Material Group

A015 Not Used in Standard

A016 Contract Item

A017 Material Info Record (Plant-Specific)

A018 Material Info Record

A019 Contract Header

give few names of transparent tables?

MKPF

T001

T000 Clients

T000ATP Basic Settings for Availability Check

T000CM Client-specific FI-AR-CR settings

T000F Cross-Client FI Settings

T000G Cross-Client FI-SL Postings

T000GL Flexible general ledger: Customizing check

T000K Group

T000MD MRP at MRP Area Level

what is table maintenance generator and how to create

that? What is the transaction code?

We can create using se11 also,

but directly, we can create using se54 also.

It facilitates data entry into the table,

by automatically generating the screens and

the code behind it.

8. How to add new fields to a standard sap table

By using an append structure.

regards,

amit m.

Re: reg: data dictionary?

Former Member — Fri, 28 Jul 2006 07:10:43 GMT

can you create a table with out a data element? - Yes

can you create a field with out a data element? - Yes

what is table maintenance generator and how to create

that? What is the transaction code?

- SM30 - table maintenance

to generator that - in se11, go to utilities>table maintenance generator

How to add new fields to a standard sap table ? - Append structure

Re: reg: data dictionary?

Shivaji16 — Fri, 28 Jul 2006 07:12:37 GMT

CDPOS - change document tables

is one of the clusture tables

Go to transaction se11.

see the table DD02l..

check the table entries with TABCLASS field which determines the type of table...

give CLUSTURE and see the entries for clustured tables,

POOL to see the entries for pool tables, etc..

Re: reg: data dictionary?

Former Member — Fri, 28 Jul 2006 11:37:04 GMT

hi,

there are 3 types of tables

1. transparent table

2. clustered table

3. pooled table

examples of transparent tables

1.sflight,sbook,spfli

2.mara,marc,mard,makt

3.vbak,vbap

4.likp,lips

5.lfa1,lfb1

6.kna1,knb1

table will have fields

fields can be eithe key-field or non-key-field

in SAP,

a key-field must have a data element & domain,

but for a non-key-field having data element & domain is optional,

got it,

just read 'ABAP/4 in 21 days',

best of luck,

regards,

kcc