searching for some database table fields relating to SD

[former_member190312]

Hi all,

i would be appreciated if anyone could provide information for the following :

1) ship-date

in which table and what field-name can I find the information?

2) Customer’s banker info (i.e. name & address info)

In which table and what field-name can I find the information?

3) Sales organisation’s banker info (i.e. name & address info)

In which table and what field-name can I find the information?

4) Also, in goods issue or stock picking, in which table does it deduct the quantity of issue-stock from?

Thanks

pabitra

[Former Member]

SD tables for Shipping Information:

VTTK - Shipping Header

VTTP - Shipping Item

VTFA - Shipping Doc. Flow

VEPO - Shipping Item Content

VEKP - Shipping Unit Header

Customer Info:

Take KUNNR from KNA1 table and join KNA1-ADRRN and ADR6-ADDRNUMBER

Check this link for more info on sd tables and their relationships.

http://www.erpgenie.com/abap/tables_sd.htm

Note: For any address information u need to access address tables like ADRC, ADR6. There might be some function modules also which do the task.

Thanks,

SKJ

[Former Member]

for sales related check VB*

for customer related KN*

Regards

Prabhu