Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

relation between tables

Former Member

‎05-26-2006 8:53 AM

0 Kudos

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

4 REPLIES 4

Former Member

‎05-26-2006 8:55 AM

0 Kudos

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

Former Member

‎05-26-2006 8:56 AM

0 Kudos

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
Active Contributor

‎05-26-2006 9:10 AM

0 Kudos

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

‎05-26-2006 10:09 AM

0 Kudos

HI

GOOD

THESE ARE ALL CLIENT DEPENDENT TABLES.

THEY ARE HAVING A COMMON FIELD MANDT

THANKS

MRUTYUN