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
Showing results for 
Search instead for 
Did you mean: 

Create view table for MARD and MKOL

Former Member
0 Kudos
425

Hi guys,

Need your help to create a view table that will combine all data from MARD and MKOL .

I need to use 4 tables, MARA, MARC, MARD, MKOL.

I tried to use MARD as my base table, but its fetching too many data.

But if i use MKOL as my base table, then i only get those entries from MKOL.

Can pls help me how to do this.

4 REPLIES 4

Former Member
0 Kudos
93

Hi,

Use MARA as your base table, and the other three as secoondary tables and create your view. If you are using it in a report try using a select statement using an inner join rather than creating a view.

Nayan

Former Member
0 Kudos
93

hi,

select the table fields properly.some where u may select entire data. select the selected fields only.and activate properly.

thanks

abdul

former_member181995
Active Contributor
0 Kudos
93

Take MARA as base table rest all are as secondary table and dont forget to maintain joins between field.

Amit.

Former Member
0 Kudos
93

Hi Guys,

I tried using Mara as my based table, still im not getting the correct output...

My Mard = 236 entries and Mkol = 3 entries.. all in all i should get 239 entries from this view..

but im only getting 6 entries..

Below were my joint conditions

Join conditions

Table Fieldname = Table Fieldname

MARC MANDT = MARA MANDT

MARC MATNR = MARA MATNR

MARD MANDT = MARA MANDT

MARD MATNR = MARA MATNR

MKOL MANDT = MARA MANDT

MKOL MATNR = MARA MATNR

These are my entries from view table and mard, mkol

VIEW Table output

MATNR WERKS LGORT CHARG SOBKZ LIFNR LABST SLABS

R002-0001X SCM F101 TEST K 11583 39,956.00 10,000.00

R002-0001X SCM F101 TEST03 K 11583 39,956.00 10,000.00

R002-0001X SCM M200 TEST K 11583 20,000.00 10,000.00

R002-0001X SCM M200 TEST03 K 11583 20,000.00 10,000.00

R002-1262X SCS A100 G001 K A123 0 10

R002-1262X SCS P200 G001 K A123 20,768.00 10

MARD

MATNR WERKS LGORT PSTAT LVORM LFGJA LFMON LABST

R002-0001X SCM F101 DL 2007 12 39,956.00 39,956.00

R002-0001X SCM M200 DL 2007 12 20,000.00 20,000.00

MKOL

MATNR WERKS LGORT CHARG SOBKZ LIFNR LVORM SLABS

R002-0001X SCM M200 TEST K 11583 04.04.2008 10,000.00

R002-0001X SCM M200 TEST03 K 11583 04.04.2008 10,000.00