what is the infrastructure of the table columns names

[Former Member]

Hi All,

Can someone tell me how to understand the meaning of the SAP table columns names? Say, we have MANDT stands for Client and WERKS stands for plant. but it seems not ab. of English words. Please can someone tell me what ab. is it, and how can we remember so many non-sense names to English speaker?

Thanks and regards,

Samson

[narayani_krishnamoorthy]

hi,

These column names are abbreviated German names.

With practice you will remember what each one means.

For e.g while coding when you use the same names as the column names you will get used to remembering these names.

You get all the meaning of these names in the table.

example :

BWART : movement type

VBELN : document number

ZEILE : item

VKORG : Sales Organisation

Regards,

Narayani

[SAPAI]

My dear friend use them in your coding and you will start remembering.

Practice makes a man perfect !!!

[Former Member]

Dear Samson,

Sorry to say it is not non-sense , it has sense if you Know German Language .

it shows that they Developed the SAP Product ...And while @ the time of Product developing stage they decided the database table and ther fields for better integration of the table's and there relations between the table's and also in the Report Retrivals , Screen Programmings... they decied to have there language 's that is why all fields are having meaning when you know GERMAN language .

but for the Text to appear they defined SAP SCRIPT where you can have your Own language for Display Purpose and based on the Log-in Language ....

Even if you log-in any of the Global language the table names and fields,dataelement ,etc names will be unique ....rather the text of there Objects will be displayed in the log-in language .

Example :

MANDT means Client is the meaning in german

KUNNR means Customer is the Meaning in german

LIFNR means Vendor is the Meaning in german

so finally

Reward Points if it is usefull.......

Girish