Standard extractor

[Former Member]

Hi ,

I have a requirement where I have to pull data from below MM related tables:

1) EKBE

2)MARC

3)MAKT

4)LFA1

5)MBEW

6)EKPO

7)MARA

Is there any standard extractor which I can select and get my purpose served?

Best Regards,

Arvind

[Former Member]

Hi Arvind,

1) EKBE 6) EKPO

As per my knowledge there is no standard data source for EKBE or EKPO tables alone.

Please find the DS list below Data Sources and Tables used in Purchasing data source.

Check the below data sources which will suit your requirement.

2LIS_02_SCL EKKO, EKBE, T001, T001W, EKET, EKPA.

2LIS_02_HDR EKKO, EKBE, T001, EKPA.

2LIS_02_ITM EKKO, EKBE, T001, T001W, EKPO, TMCLVBW, T027C, ESSR, T147K, T147

2LIS_02_SCN EKET, EKES, EKPO.

2LIS_02_CGR EKBE, EKES, EKPO.

2LIS_02_SGR EKET, EKBE, KKPO

If at all the above data source doesn't fit your business requirement, then you can enhance the respective data source. if this is also not the case then you can create your own Generic extractor on this tables by creating view or FM.

2) MARC --> 0MAT_PLANT_ATTR

3) MAKT --> 0MATERIAL_TEXT

4) LFA1 --> 0VENDOR_ATTR

5) MBEW --> Check the inventory data source in LBWE.

7) MARA --> 0MATERIAL_ATTR

[former_member199945]

Follow above wiki , you will get all relevant tables information for all data sources especially SD,MM ,FI.

  EKBE and EKPO  :  2lis_02_itm and 2lis_02_sgr these 2 are available.

If yo want detail INFO relevant fields availble in these D.S just search in goole

as 2lis_02_itm datasource help.sap.com.

Here u will get details including tables and fields  involved including infoobjects/DSO's/Infocubes and either data source supports Full/Delta.

Regards,

Seshu.P

[RamanKorrapati]

Hi Aravind,

Check about purchasing/material(related) data sources will may suits your requirement. if needed  then think about enhancement.

MARC/MARA/MARK - Material related data sources,

MBEW - 0CO_PC_ACT_05

EKPO/EKBE - related to purchasing, try to check 2LIS_02*  Data sources

Thanks

[Former Member]

Hi Tiwari,

We can the check the required fields in the below purchasing data sources.

1) 2LIS_02_ITM

2) 2LIS_02_SCL

Regards,

Malli.

[former_member199945]

Hi,

Standard Extractor For above tables , it is very difficult to maintain in one data source

Form above listed tables how many fields needed for reporting ?  and based on  that need to go for custom data source or standard data source .

Follow below give detail infoprmation about data sourfces0

http://wiki.scn.sap.com/wiki/display/BI/BW+SD+MM+FI+DATASOURCES

Reagards
Seshu

[Former Member]

Even Maximum tables can be covered then also it should be fine...say EKBE and EKPO like that.