table names

[Former Member]

hi,

can any body tell me the combination of tables having the fields kunnr,werks, spart,vtweg and sales org other than vbrk and vbrp

marks will be rewarded

[Former Member]

Hi Phani,

Use this link for table relations

http://www.abap.es/Descargas/TAB%20-%20Relacion%20de%20las%20tablas%20por%20modulos.PDF

Reward if this helps,

Satish

[former_member195698]

Try KNVV for kunnr, sales org, distribution channel and division. For Plant/Sales org use the table TVKWZ.

[Former Member]

KUNNR - KNA1

WERKS - T001W

SPART - TSPA / TSPAT

VTWEG - TVTW / TVTWT

SALES ORG - TVKO / TVKOT

Also check VBAP, VBAK, LIPS, LIKP etc.

[Former Member]

kna1-kunnr

vbak-kunnr,sales org,werks.........