relation between tables

[Former Member]

is there any relationship for ausp table with s110,s120,mara

[Former Member]

go to sq02 and check by graphical view what is the relation b/w thwm..

[Former Member]

Hi,

S110 and S120 are the LIS tables where detailed sales information and receipts info is stored. All I can see is the MATNR field in S120 which can be related to MARA table.

Regards,

Ravi

Note : Please mark the helpful answers

[hymavathi_oruganti]

Addit. structures

S110 INNER JOIN INNER JOIN S120

Conditions

S110-MATKL = S120-MATKL

S110-WERKS = S120-WERKS

S110-SPBUP = S120-SPBUP

S110-SPMON = S120-SPMON

S110-SPTAG = S120-SPTAG

S110-SPWOC = S120-SPWOC

S110-SSOUR = S120-SSOUR

S110-VKORG = S120-VKORG

S110-VRSIO = S120-VRSIO

S110-VTWEG = S120-VTWEG

S110 INNER JOIN INNER JOIN MARA

Conditions

S110-MATKL = MARA-MATKL

S110-PLGTP = MARA-PLGTP

S110-SAISO = MARA-SAISO

S110-SPTAG = MARA-ERSDA

S110 INNER JOIN INNER JOIN MARA INNER JOIN S120

Conditions

MARA-MATNR = S120-MATNR

S110-MATKL = MARA-MATKL

S110-PLGTP = MARA-PLGTP

S110-SAISO = MARA-SAISO

S110-SPTAG = MARA-ERSDA

Message was edited by: Hymavathi Oruganti

[Former Member]

HI

GOOD

THESE ARE ALL CLIENT DEPENDENT TABLES.

THEY ARE HAVING A COMMON FIELD MANDT

THANKS

MRUTYUN