topic searching for some database table fields relating to SD in Application Development and Automation Discussions

searching for some database table fields relating to SD

former_member190312 — Sun, 08 Apr 2007 14:44:23 GMT

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 — Sun, 08 Apr 2007 17:55:38 GMT

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.

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 — Mon, 09 Apr 2007 04:18:22 GMT

for sales related check VB*

for customer related KN*

Regards

Prabhu