Extraction of DATA to BI

[Former Member]

Hi Experts

I need to extract the data from ECC to APO BI.

I need to transfer data , only materials for Material type X0 in Marc Table and sales docuent type OR and KB in the VBAK Table.

Following fields need to be extracted fro ECC:

*FIELDS TABLE*

KUNNR VBAK

MATNR VBAP

WERKS VBAP

KOSCH VBAP

BMENG VBEP

EDATU VBEP

KDGRP KNVV

VKORG KNVV

VTWEG KNVV

What are steps taken to extract in ECC ?

Is there any standard Data source available for all above Fields with filter criteria for materials is MRP Type XO and filter criteria for Sales Orders which has OR & KB order Types.

Whether i need to go for FM Extraction?

Please give your valuable inputs

Regards

Rave

[Former Member]

Hello Rave,

Look for datasource available else you can create a generic datasource using function Module and can extract fields

*FIELDS TABLE*

KUNNR VBAK

MATNR VBAP

WERKS VBAP

KOSCH VBAP

BMENG VBEP

EDATU VBEP

KDGRP KNVV

VKORG KNVV

VTWEG KNVV

In the Function Module we can verywell define the filter criteria - filter criteria for materials is MRP Type XO and filter criteria for Sales Orders which has OR & KB order Types.

But make sure this criteria will not change in future also else we need to define the criteria at the DTP level in START Routine when we are passing data from Datasource to DSO/Infocube.

Assign marks is the best way to appreciate efforts.

Thanks,

Rahul Rai

[m_verbaan2]

Hi Rave,

I would opt for the standard extractors 2LIS_11_VAITM (which can also extract Sales order Header data) and 0CUST_SALES_ATTR.

For the Sales data see if you can make field AUART available for selection (RSA6). For the Master data you can either filter out your data in a user-exit on ECC side or when loading into DSO (filter in DTP, using 0MATERIAL attribute for type).

Hope this helps.

Grtx

Marco