topic Re: relation between tables in Application Development and Automation Discussions

relation between tables

Former Member — Fri, 26 May 2006 07:53:31 GMT

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

Re: relation between tables

Former Member — Fri, 26 May 2006 07:55:47 GMT

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

Re: relation between tables

Former Member — Fri, 26 May 2006 07:56:59 GMT

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

Re: relation between tables

hymavathi_oruganti — Fri, 26 May 2006 08:10:26 GMT

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

Re: relation between tables

Former Member — Fri, 26 May 2006 09:09:24 GMT

GOOD

THESE ARE ALL CLIENT DEPENDENT TABLES.

THEY ARE HAVING A COMMON FIELD MANDT

THANKS

MRUTYUN