Datasource 2LIS_17_I0NOTIF & 2LIS_17_I0CAUSE table

[Former Member]

Dear experts,

Do experts know table of origin or table structure in SAP ECC 6.0 for datasource 2LIS_17_I0NOTIF and 2LIS_17_I0CAUSE?

We need to see the data inside the table.

Besides is there a way we can know any datasource in SAP BW extract records from which table of origin in SAP ECC 6.0?

[former_member182196 · Accepted solution]

Hi,

For any data source you can check base table in LBEW  tcode > maintenance > Expand all.

you will get this screen remove MC and check data in SE11 for table.

Note : Some time in data source or table field will be available but field respective data not there then you have to check

          with functional team where you can get data for respective fields.   

Regards,

SM

[Former Member]

Thanks a lot experts

[Former Member]

Hi,

LO Datasources tables can be checked using the way Satyendra told with snapshot.

And in cast of other application datasources, you might need to check with functional team or can google it out as well.

Br,

Arpit

[RamanKorrapati]

hi Azhar,

If you execute data source at RSA3 with Debug mode you will know from which table its pulls data.

clude Mfor LO relate data sources bases tables we can find at LBWE, click on maintenance, check right side reserved pool list as shown by satendra mishra.

Thanks

[Former Member]

Hi,

As our dears suggested above you can find out the base tables for any LO (Logistics Applications) Data Source..

You can see the same in the above screen shot (Attached by Satendra)...

If it is related any Other Non LO (Logistics) data sources or FI data sources, you can take the help from respective functional team members to find out the relevant source/base tables..Thanks.

Regards,
Venu

[ravi_chandra3]

Hi

Pls refer the below link

http://help.sap.com/saphelp_tm80/helpdata/en/3b/469426ef434c0d99301a4c3d42245d/content.htm

http://help.sap.com/saphelp_tm80/helpdata/en/f1/a54e38d46c4bf68b9ecf1d41cb6bcc/content.htm

[former_member182470]

Notification Base table is QMEL

Cause Base Table is QMUR

[anshu_lilhori]

Hi,

For LO related datasources you can follow this approach.

Go to LBWE--find that datasource against application 17--then click on maintenance --continue--MCQMEL.

So the base table for this is QMEL..

Hope this helps.

Regards,

AL