Description

[Former Member]

Hi,

Iam new to the ABAP.

Can any one tell me what is the need of maintaining separate table for desciptions in our standard SAP tables.

let us take an example of material number description, why can't we use maktx in MARA table itself. Why should we go for MAKT.

Thanks,

Radhika.

[Former Member]

Hi Radhika,

Its a 4th Generation language and 4th generation language means its build on the concepts of RDMBS which means relational database management systems.

SO it follows all the principals of RDBMS normalization and hence the tables are linked to each other and not maintained in one single table.

Cheers

VJ

[Former Member]

may be to maintain description in different languages , separate table is maintained

[Former Member]

Hi Radhika,

If you try to maintain the material master using MM02 or MM42, you will find that the description can be maintained in multiple languages.

As a part of one of the normalization rules (you must have read during your computer studies), we keep separate table rather than having redundant master data.

Hope this helps.

regards,

Satya

[Former Member]

Hi Radhika,

Very frequently do we get a requirement of getting the text for some object(material/vendor/customer) in our projects.If we query the main master data table just for a simple description(Which is having inofrmation about some many other things), the load on the main table will be very high.

To distribute the load on one single table, tables are maintained for texts.

And generally text fields are of more length, that make the table definition more cumbersome.

Regards,

ravi

[Former Member]

hai radhika!

well makt is a description table where

description of the materials will be maintained in all the languages.this is the purpose of MAKT table.

[athavanraja]

one reason i can think of is you can have text for the same material in different languages.

Raja

[abdul_hakim]

Hi Radhika,

there are lots of business reason behind maintaing the details in a separte tables.you can also ask question like why we need MARA,MARC,MAKT tables why don't we have all the details in a single table..The answer is there are certain restrictions and business reasons and hence SAP is having thousands of tables.As an ABAP Developer you don't need to bother about it..Ok..

Cheers,

Abdul

[Former Member]

Why Iam asking is just for single field(Description) why shud we go for another table. If we use the same in MARA table itself no need to query the other table while doing selection right. performance wise also comparatively better i guess.

[Former Member]

Radhika,

Like Vijay mentioned in his post, its the simple RDBMS rule.

When you can have multiple descriptions in multiple languages you cannot repeat the entire row of MARA for each description. So, you have a child table MAKT and have the descriptions in there.

The same logic applies to others as well.

Hope you get the point now.

Regards,

Ravi

Note : Please mark the helpful answers

[abdul_hakim]

If such is the case then you need maintain the master data in each language which will make your table more complex...As i told you before there is no use in arguing this factor since there are lots of business and technical reasons behind having the data spread across multiple tables......

Cheers,

Abdul Hakim

[Former Member]

Hai Radhika

go through the documents Normalization Technics or Read Codd's Rules

If you Include Maktx field in MARA Table .

I have a material Availavle in 10 Different Languages

then you have 10 records for the same material in Mara Table

when we retrive data from Mara table it is somemore difficulte

so they were maintain MASTER CHILD Tables

Both Tables having the same Primary Key

Thanks & Regards

Sreenivasulu P

[Former Member]

Hello Radhika,

<b>Why Iam asking is just for single field(Description) why shud we go for another table. If we use the same in MARA table itself no need to query the other table while doing selection right. performance wise also comparatively better i guess.</b>

What u say is very correct but since SAP is released inmultiple languages thereby if u want to maintain text for a material in English and German then u wold have to maintain same record for 2 language.

[Former Member]

Hi,

Dont think that Im arguing or doing something.

I have been asked in an interview like this..

[abdul_hakim]

hi radhika,

you can answer in such situation like there are lots of business and technical reason behind having data spread across multiple tables.i don't know why are asking this useless question..

Please close the thread if your question has been answered..

Cheers,

Abdul Hakim

[Former Member]

Hello Radhika,

For such thing u need to reply as based on the concepts of RDBMS and nomalisation the tables holding the text is separated out than master table. This avoids duplication of data.

[Former Member]

Hi Radhika,

To tell in in much simpler terms,

MARA- the key field is matnr

MAKT- the key field is matnr and spras.

So for the same material, you will not have same number of records in those tables(YOu will have unique description only if you specify the language).

This applies for all text tables(Not only makt).

all the text tables will have a language field.

We cannot include an adtional field (Language in the main table) just for this reason(all other info will remain same whatever the language may be).

Regards,

Ravi

[abdul_hakim]

hi

i have some useful interview questions with me.i will forward it to your email..ok..

All the best...

Cheers,

Abdul Hakim

[Former Member]

Thanks

[Former Member]

vf