Tables

[Former Member]

Hi,

As a SD consultant what all we should know about tables and field names, how it will be helpful for sd role

[Former Member · Accepted solution]

Hi Kedar,

You should know the basic tables names like for customer, order, billing , delivery etc. Also you should be able to remember their technical names, which you are going to use oftenly in your life span.

With Regards

Arun Kumar

<b>Rewards Points if it helps</b>

[Former Member]

Hi,

Being the SD consultant, You should aware of basic tables and important fields used in

customer master

Material master

SO

O/B

Billing

Shipping

Criedt mgmt

This will be useful at the time of

1) code walk through\

2) Debugging

3) SAP query

4) Mass upload

etc..

These are the list of tables

KNVV

KNA1

KNB1

VBAK

VBAP

VBEP

VBKD

VBFA

VBUK

VBRK

VBRP

VBUK

VBUP

VEKP

VEPO

LIKP

LIPS

MARA

MARC

MARD

MBEW

MVKE

CDPOS

CDHDR

T014 -- Defien credit control area

T001-- Define Company code

T001W - Define plant

TSPA - Defien Division

TVKO-- Define S.org

TVTW -- Define Dist.chann

TVST - Define Shipping condition

To know the list of important field go to se16 - enter the table name and identifiy by the primary key fields.

Hope it will help you.. reward if so

Laxman

[Former Member]

Hi As a SD Consultnat u must know some table like where the sales order header . and item details go and store and in the same way where does the delivery and billing document data goes and store .tables are required for us not field names .

It will be easy when u give some requirement to the ABAP u can directly tell them that this field is there in this table . so on so that will be made easy to the ABAP and u can also save the time ......insted of ABAP go and search from where this data is comming .....if u directly give him tables it will be easy for him and u can also make ur work fast.

[Former Member]

Reward points if helpfull.