table to link Sales Org , mat, Plant, storagr loc,distribution channel

[Former Member]

Hi Frnds,

Can any one suggest table which is having all the fields Sales Org , mat, Plant, storagr loc,distribution channel.

thanks,

Y.Ravi Kumar

[former_member386202 · Accepted solution]

Hi,

Check these tables

vbak, "Sales Document: Header Data

tfacs, "Factory calendar (display)

vbpa, "Sales Document: Partner

lips, "SD doc: Delivery: Item data

mkpf, "Header: Material Document

mseg, "Document Segment: Material

konv. "Conditions (Trans Data)

Regards,

Prashant

[Former Member]

Hi Ravikumar !

There is no single database table which contains all the fields .

First get the data from MVKE Table by using material number,then do compare with MARC Table

MVKE - Matnr,VKORG,VTWEG

MARC - MATNR,WERKS

[former_member226365]

There is no link to plant

[kostas_tsioubris]

Hi,

you can check the table VAPMA if can fulfill your requirements.

Kostas

[Former Member]

KOTP210

t001

t001l

Message was edited by:

Karthikeyan Pandurangan