REgd How to find appropriate data sourses for given tables in Inve Mngt

[Former Member]

Experts!

M completely new to Inventory Mngt where i needto extract data from R/3,

they 've given me some tables, but i dont know how to find appropriate data

sourses for that tables

those are

MKPF,MSEG

EKKO,EKPO

EKBE,EKET

How to find right data sourses when table names given in any module??

pls guide me,

'll assign the points.

thanks

Srujan

[Former Member · Accepted solution]

Hi,

MKPF, MSEG are about material movements, the corresponding DSources are 2LIS_03_BF/BX/UM.

Purchasing Header/Item

EKKO, EKPO: 2LIS_02_HDR, 2LIS_02_ITM

Purchasing Schedule Lines

EKBE, EKET: 2LIS_02_SCL.

hope this helps...

Olivier.

[Former Member · Accepted solution]

thnx guys, i assigned the points..

but in inventory controlling , if i go for lbwe, there is only 2 datasourses available, there is no 2lis_03_bx,

so where do i get this one

[Former Member · Accepted solution]

Hi,

2LIS_03_BX is the initialization of your stocks; you'll need to perform the setup procedure for extracting this data.

Usually this DSource is used to bring the stocks positions at a given time; from this given time you'll then extract deltas from BF and UM so your stocks are always:

BX + BF(Delta) + UM(delta).

Hope this clears your doubts...

Olivier.

[Former Member · Accepted solution]

Hi,

u will not see 2lis_03_bx @ LBWE Cockpit..

U can find 2lis_03_bx @ RSA5 --> Acitvate it and Goto MCNB T-code --> Initialize the Opening Stock there

and Do the setup tables for BF and UM datasources

Thanks

[Former Member]

Hi Srujan,

Check this weblog:/people/sap.user72/blog/2005/09/05/sap-bw-and-business-content-datasources-in-pursuit-of-the-origins for finding any fields for a particular datasource.

Bye

Dinesh