use of standard data source 2LIS_05_QVUDN and it's associated tables

[Former Member]

Hi,

     There is an infocube in SAP BW, which is developed through the standard datasource 2LIS_05_QVUDN.  The standard datasource is extracted through the function module(standard) MCEX_BW_LO_API.  I've to find out the logic of this function module and it's associated tables. 

I've searched through many forums in SDN but I'm not getting the tables which being used in this standard datasource.

Can you please suggest that what are all the tables associated with the function module MCEX_BW_LO_API?

with Regards,

Antony Jerald.

[RamanKorrapati · Accepted solution]

hi antony,

For LO Data sources to find associated tables very easy. Go to T code LBWE, expand the respective application,data source, click on maintenance hyper link, its pop with extract str feilds(left side) and reserved pools (in right side).

Thanks

[Former Member · Accepted solution]

Hi,

     I'll have to understand the usage of Datasource 2LIS_05_QVUDN.  But the function module through which the Datasource is extracted is complicated to get through.  Is there any specific document showing the use of standard datasources?

with Regards,

Antony Jerald.

[RamanKorrapati · Accepted solution]

hi antony,

below links may be useful to understand function module based extrcation.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0f46157-e1c4-2910-27aa-e3f4a9c8d...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c062a3a8-f44c-2c10-ccb8-9b88fbdcb...

http://scn.sap.com/message/9644462

Thanks

[Former Member · Accepted solution]

Hi,

     Thanks for your document help.  There are some Z fields(for, ZHLQALS, ZHLQAVE_REJ) in the datasource.  But those associated fields are not available in the tables QALS and QAVE.  I've checked it's enhancement too.  But there I got one Z field. 

     Similarly there are some Z fields which is available in datasource are not in those specified tables.  Can you help me how to identify those Z fields and they are from which table?

with Regards,

Antony Jerald.

[RamanKorrapati · Accepted solution]

Hi Antony,

Z fields may be appended to data source as business needs by enhancement method.

So go to ECC side, t code in CMOD, enter project which is created in your system, go to enhancement component RSAP0001, go to exit EXIT_SAPLRSAP_001, include program, double click on it.

search code related to ur data source, like WHEN "2LIS_05_QVUDN"...

Take with abap expert help, you will understand how/from where zfields are populating.

Thanks

[former_member182516 · Accepted solution]

Hi Antony,

You can check for the source for this tables in CMOD - logic.

follow the steps :

Se38 : Enter program "ZXRSAU01" --> display

Search for your data source 2LIS_05_QVUDN. Here you will find your code that was implemented to enhance the data source.

your data source enhamcenet will start like below

WHEN '2LIS_05_QVUDN'.

Here below this When statement you will find a SELECT statement where you can find the source table of the enhanced fields.

Example:

SELECT loekz

        FROM ekkn

        INTO (l_t_poacc-zzloekz)

        WHERE ebeln = l_t_poacc-ebeln

        AND ebelp = l_t_poacc-ebelp

        AND zekkn = l_t_poacc-zekkn.

Here source table is EKKN and feild we had extracted as part of enhancement os LOEKZ .

Hope this helps ....

Cheers

KP

[Former Member · Accepted solution]

Hi Prashant,

     Thanks for your reply.  As mentioned in my above reply, I checked CMOD from where the enhancement of this particular datasource has been done with.  But from this enhancement, I can locate only one field(for ZWIPREJ)

     But there are some other Z fields(for, ZHLQALS, ZHLQAVE_REJ) which I'm either not able to locate them from enhancement of CMOD nor in tables QAVE, QALS.

     Can you please help me how to proceed further regarding this?

with Regards,

Antony Jerald.

[former_member182516 · Accepted solution]

Hi Antony,

Good ...

Can you post the CMOD logic that you had used to enhance the data source?

Antony --> the above 2 fields ZHLQAS( Lots) and ZHLQAVE_REJ ( Rejected lots) are not enhanced fields. these are standard fields which are part of the standard extractor.

These fields are populated with the help of extractor logic....which will be defined in the MCEX_BW_LO_API.

check for the same in LBWE -->

Hope this helps

http://help.sap.com/saphelp_nw04/helpdata/en/a6/32893a9b323778e10000000a11402f/frameset.htm

KP

[RamanKorrapati · Accepted solution]

Hi Antony,

Can you check strcture which you passed in Function module.

How to find Str name:

ECC side Go to t code SE37, Give the function module name: MCEX_BW_LO_API,(display mode)

Enter, go to the tab Tables,there is a paramenter Name E_T_DATA--->Associated Type(Zstructure).

Ex: E_T_DATA    LIKE        ZYYYYYY(custom define str).

Copy tht name and see the structure fields at SE11,

Thanks

[Former Member · Accepted solution]

Hi Ram,

     I've checked it's function module and from CMOD enhancement, I could get logic of some Z fields.  Though those Z fields(ZHLQALS, ZHLQAVE_REJ)are being used, I'm not able to get it's logic regarding how they are extracted and from which table they are refering and how they are calculated.

Need to explain it to end users.

Please suggest..

with Regards,

Antony Jerald.

[RamanKorrapati · Accepted solution]

Hi Antony,

As said by Mr prasanth, these field are part of data source and pulled by extrcator logic thru FM.

Better to take ABAP Expert help and dig deeper at Function modulu logic. you will know.

http://www.consolut.com/en/s/sap-ides-access/d/s/doc/U-MCQALS_KFG

http://www.consolut.com/en/s/sap-ides-access/d/s/doc/U-MC05QV0UDN

Thanks

[Former Member · Accepted solution]

Hi,

     I just need to find out how the fields ZHLQALS, ZHLQAVE_REJ are related with tables QALS and QAVE.

with Regards,

Antony Jerald.

[former_member182516]

Hi Antony,

Source tables associated with the data source

QALS  - Inspection lot record

QAVE - Inspection processing: Usage decision

Regards

KP

[Former Member]

Hi,

     Thanks for your prompt reply.  Can you tell me the function module contains many methods and classes, also various function modules are being used with in a module.  It's something hard to find out table names.  Can u suggest is there a way to find out such a table from a function module of standard datasource?

with Regards,

Antony Jerald.