Skip to Content
0
Former Member
Sep 06, 2007 at 08:00 PM

Purchasing - Data Extraction

34 Views

Hello Everyone,

I am a new BW user and working on a Project on Purchasing. I have been searching net for quite sometime but couldn't get the answer I am looking for. I hope you guys would help me with my project.

Business needs to monitor the quantity received versus the quantity ordered, for orders considered completed. The report should be broken down by vendor, material(s) ordered from this vendor and only for the purchase orders marked as completed.

I found the data sources related to the purchasing areas and here is my finding

<b>InfoCube: 0PUR_C01</b>

DataSources: 2LIS_02_ITM

2LIS_02_SCL

InfoObjects: 0VENDOR

0MATERIAL

0CALDAY

0PO_QTY

0GR_QTY

This InfoCube does not have completion indicator so we thought of including ODS

<b>DSO: 0PUR_O01</b>

DataSources: 2LIS_02_ITM

2LIS_02_SGR

2LIS_02_CGR

2LIS_02_SCN

InfoObjects: 0COMPL_DEL (Delivery Indicator)

0PDLV_QTY (Actual Quantity Delivered)

As a new BW person, what do you think I would do

<b>1.</b> Do I need to load master data first as we have Vendor and Material.

<b>2.</b> Do I need to load the transaction data to ODS and InfoCube, then create a custom InfoCube (example: ZPUR_C01) and load the data to it finally?

<b>DataSources -> Transfer Rules -> InfoSources -> Update Rules -> ODS and CUBE -


> Cube (ZPUR_C01)</b>

<b>3.</b> The normal practice is I think is to load the data to ODS and then load it to InfoCube, if we consider this approach then we'll have to use another ODS with all the information we found in 0PUR_C01 and then load it to custom cube?

<b>DataSources -> Transfer Rules -> InfoSources -> Update Rules -> ODS -


> Cube (ZPUR_C01)</b>

I would appreciate any kind of help and will also help other new BW users.

Thanks.