tables and fields

[Former Member]

I want to know about sd tables and fields relevance.why should tables be linked with each other.

I understand that data which we enter is stored in tables and by linking fields from one table to another table, where a field is common.

so can someone give a example showing how to use this information ,not in theory, but practically ?

Please no 'help sap' links,but just a practical example showing why knowing different tables and field knowledge is useful.

my email is = mhbbkhtr@yahoo.co.in

[Former Member · Accepted solution]

For the sake of preventing data redundany tables are often split.

Consider a Sales Order. Header data is stored in VBAK and Item data in VBAP

The key linking these two tables is VBELN (Sales Order document number).

So if we know the order number from VBAK we can get all corresponding items that belong to a particular sales order in VBAP by simply quoting the Sales Order number VBELN.

This is similar in the case of Delivery documents, invoices, purchase orders, etc.

[ravi_kumar100]

Hi all,

Find SAP SD Tables:

Sales and Distribution (SD) :

VBFA Document flow (alg.)

VTFA Flow shipping documents

6.1 Sales order :

VBAK Header data

VBAP Item data

VBPA Partners in sales order

VBKD Sales district data

VBEP Data related to line items, delivery lines

<b>6.2 Billing document :

</b>VBRK header data

VBRP Item data

6.3 Shipping :

VTTK Shipment header

VTTP Shipment item

VTTS Stage in transport

VTSP Stage in transport per shipment item

VTPA Shipment partners

VEKP Handling Unit - Header Table

VEPO Packing: Handling Unit Item (Contents)

6.4 Delivery :

LIKP Delivery header

LIPS Delivery item

6.5 Pricing :

KONH Conditions header

KONP Conditions items

KONV Procedure ( billing doc or sales order)

KOND

6.6 contracts :

VEDA Contract data Very Happy

REgards,

Sarosh

[Former Member]

Hi

Mail Sent

[former_member183879]

Hi Mehboob

Say you want to find out all the condition types of a particular document.

Document details are available in VBAK

Item level details of documents are seen in VBAP

Condition types are seen in KONV

The common fields are VBAK-KNUMV = KONV-KNUMV

VBAP-POSNR = KONV-KPOSN

Now if you want to findout all the condition types relevant for a particular line item

1. Find out the VBAK-KNUMV and VBAK-POSNR for that line item

2. Go to KONV

3. Give KONV-KNUMV the value of VBAK-KNUMV

and KONV-KPOSN as the value of VBAP-POSNR

Now execute

You will get all condition types which are applicable for the line item in that document.

Now if you want to find like this for 100 documents, you can write a report using these tables and fields.

Hoep this clears ur doubt.

Reward if this helps.

[Former Member]

on the reply i have two questions

1) Can one populate the tables(from table view) ? If yes, How ? (simple way or is it via 'sql', simple way preferred)

and is it recommended,if not why ?

2)you mentioned " Now if you want to find like this for 100 documents, you can write a report using these tables and fields"

can you plz. elaborate, how can one create such a report involving these 100 documents.

[Former Member]

Hi,

SAP don't recommend any direct table / view updates. We should not do this unless there is a BAPI.

Infact, it wont be easy to connect from TOAD, SQL Plus to SAP Database. Basis team don't allow it.

Regarding reporting, you can write ABAP reports using ABAP language / SQL embededd.

Pl reward if helpful.

Thanks,

Ramesh

[Former Member]

Hi Akhtar,

<b>1) Can one populate the tables(from table view) ? If yes, How ? (simple way or is it via 'sql', simple way preferred)

and is it recommended,if not why ?</b>

We will generally populate tables from database tables or from views. We will query with SELECT statements and populate them into internal tables. The best practise is to get the required data into internal tables rather than querying the database tables many times in a report.

<b>2)you mentioned " Now if you want to find like this for 100 documents, you can write a report using these tables and fields"

can you plz. elaborate, how can one create such a report involving these 100 documents</b>.

To accept a wid range of doucments from user in the reports, tehcnical guys will use SELECT-OPTIONS/PARAMETERS in the seelction-screen of report. After accepting this input, they will query on database and get the data into internal tables and they will display the required data on to list by using populated internal tables. They will only query on time on database for 100 documents rather than 100 times.

Thanks,

Vinay

[Former Member]

Hello,

Please check your mail id.

Rewards points if helpful.

Thanks in advance.

Priyanka