MM extraction

[Former Member]

Hellow Experts,

Hope all are fine with BW.....

Plz....Any body explain MM extraction step by step I unable to extract the data like SD

I think it is little bit tough....Please give me the steps for Inventory and Purchasing

If possible give me threads on PPT's

Thanks in Advance........

[Former Member]

Hi,

let us know where u strucked ? what probs ur facing while doing MM extraction..

From SDn

MM extraction will be LO cockpit Extraction..

Please find the procedure and important links for LO extraction..

LO'S Procedure:

Go to transaction code RSA3 and see if any data is available related to your DataSource. If data is there in RSA3 then go to transaction code LBWG (Delete Setup data) and delete the data by entering the application name.

Go to transaction SBIW --> Settings for Application Specific Datasource --> Logistics --> Managing extract structures --> Initialization --> Filling the Setup table --> Application specific setup of statistical data --> perform setup (relevant application)

In OLI*** (for example OLI7BW for Statistical setup for old documents : Orders) give the name of the run and execute. Now all the available records from R/3 will be loaded to setup tables.

Go to transaction RSA3 and check the data.

Go to transaction LBWE and make sure the update mode for the corresponding DataSource is serialized V3 update.

Go to BW system and create infopackage and under the update tab select the initialize delta process. And schedule the package. Now all the data available in the setup tables are now loaded into the data target.

Now for the delta records go to LBWE in R/3 and change the update mode for the corresponding DataSource to Direct/Queue delta. By doing this record will bypass SM13 and directly go to RSA7. Go to transaction code RSA7 there you can see green light # Once the new records are added immediately you can see the record in RSA7.

Go to BW system and create a new infopackage for delta loads. Double click on new infopackage. Under update tab you can see the delta update radio button.

Now you can go to your data target and see the delta record.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/f83be790-0201-0010-4fb0-98b...

Also Refer this link:

http://www.sap-img.com/business/lo-cockpit-step-by-step.htm

Inventory.. dwload go thru it

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/f83be790-0201-0010-4fb0-98b...

Thanks

[Former Member]

Hi,

MM Extraction..

goto rsa5

select MM application

Here i'm given sd flow

salesorder:

VBRK - header

VBAP - item

VBEP - scheduling

delivery:

LIKP - header

LIPS - item

billing:

VBRK - header

VBRP - item

shipement

VTTK - header

VTTP - item

customer data

SD links FI table

salesarea data general data companycode data

knvp kna1 knb1

material master data

SD link to MM table

salesdata Basic data salestext data

MARC MARA STXH(Textfile header)

MVKE MAKT STXL

process:

1.sales reresntive enter sales order in R/3 system, it sotres the transaction into three

SD tables.

2.delivery due list is executed for all sales orders and delivers are created in table LIKP, LIPS.

A goodsissue updating MKPF & MSEG.

3.invoice due list is then executed for all deliviers. after an invoice is created, which creates an acct.doc ( BKPF & BSEG, FI TABLES) and set up the receivalbe in table BSID (open tem).

4.The receivalbe is cleared when paymen check is required. anoher acct.doc is created ( BKPF & BSEG) the open receivable is cleared and table BSAD (closed line item) is updated

First u select application component.. SD,MM,FI,PM

then got to rsa5.. u can install data source...

after next step RSA6-Display data sources

Then select our ds which we need to enhance then click on the

append structure (application tool bar)

u can see start with ZAGTFIGL_4 ( fi example)

u given component name and component type ( here given to existing

data element)

save + activate....

then go to the t code CMOD...>there select the project

name--> go to the exit in RSAP0001->

or also u can goto tcode se37 fuction module.. EXIT_SAPLRSAP_001

transactional data

click on display...

then u can see INCLUDE ZXRSAU01( program ) double click it.....

then u can change option click it.