Question Re: Inventory extraction Logic in Technology Q&A

Inventory extraction Logic

Former Member — Thu, 04 Feb 2016 00:45:21 GMT

Hi All

I need to extract inventory quantities as below.

For a particular plant P01 i have to extract inventory quantities for for all material that belong to this plant.

Inventory will be extracted for various stock types.Another logic that needs to be incorporated is that for Non batch managed materials (MARC-XCHPF Not Es X) inventory quantity should be fetched from MARD for current period and year.

For non batch managed (MARC - XCHPF Eq X) quantity should be extracted from MCHB.Only below fields are required to be extracted

Product,Plant,Storage location, ,unit of measure, ,quantity.

My question is -2LIS_03 extractors are already up and running in our system and delta is flowing. I need to extract these 6 fields and load and OHD and then transmit this to a 3rd party system.

Should i go for a new FM based extractor for this explicitly or should i explore the available stock cubes in BW system and see if all required fields can be extracted from cube based on aforementioned logic.

Re: Inventory extraction Logic

Former Member — Thu, 04 Feb 2016 07:21:53 GMT

Explore the available stock cubes in BW system and see if all required fields can be extracted from cube based on aforementioned logic.

I think the stock for batch & non-batched will represent the mentioned source values

Re: Inventory extraction Logic

Former Member — Thu, 04 Feb 2016 07:45:35 GMT

Hi Tom

I think the stock for batch & non-batched will represent the mentioned source values- i didnt get this...can you pls elaborate for me

Re: Inventory extraction Logic

Former Member — Thu, 04 Feb 2016 07:51:25 GMT

I just meant that if you use the standard 2LIS_03* extractors already, that they should have for each material/plant values & quantities that are consistent with the values in MARD & MCHB

Re: Inventory extraction Logic

Former Member — Thu, 04 Feb 2016 08:02:21 GMT

Ok Tom . I will check this in inventory cube.

Another thing i need to check whether OHD is compatible with Non-cumulitive cubes..

Thanks

Re: Inventory extraction Logic

Former Member — Fri, 05 Feb 2016 17:34:15 GMT

Hi Nayab,

I dont think it should have any affect...but are you going to use Cube or Query ??

You can save it as Snapshot of the data and not Deltas !!

regards

SVU

Re: Inventory extraction Logic

Former Member — Sat, 06 Feb 2016 16:21:02 GMT

Hi SVU

I will use cube as source. And i need full inventory without any movement types.

So there is no constraint of delta.

Re: Inventory extraction Logic

Former Member — Mon, 08 Feb 2016 04:46:54 GMT

Hi Nayab,

Its Snap shot ,it will not work the way it works in BW...so the Key Fields will hold the Key to Delta to Target.

regards

SVU

Re: Inventory extraction Logic

Former Member — Tue, 09 Feb 2016 03:20:56 GMT

Ok. Then how should i do it? I want only stock quantity to be sent to Open Hub.

Re: Inventory extraction Logic

former_member244150 — Mon, 15 Feb 2016 19:56:46 GMT

Hello Nayab,

As you might aware that Total Stock Qty (0TOTALSTCK) will only available at report level on Inventory cube (eg. 0IC_C03) as difference between inflow (Receipt Qty) & outflow (Issue Qty) you can't directly use the cube as source for your OHD.

Take snapshot of inventory data using APD

0IC_C03 --> Query (source) --> APD --> Direct Update DSO (Target) --> OHD --> FTP to destination

Re: Inventory extraction Logic

Former Member — Tue, 16 Feb 2016 05:30:18 GMT

Hi Venkat

Can i take snapshot using DSO as a dource?

Re: Inventory extraction Logic

Former Member — Tue, 16 Feb 2016 10:32:40 GMT

Hi Nayab,

Assuming that you send it to Open Hub....how does the Data get Loaded from there on....The Keys of the table in Target system Matters...We should have a Date/Week/Month which will say that its the Stock as on that Date/week/Month.

regards

SVU

Re: Inventory extraction Logic

former_member244150 — Tue, 16 Feb 2016 20:32:08 GMT

Yes, you can use DSO as a source if you know how to calculated Inflow & Outflow based on Stock Type/Category/Transaction key etc.

Re: Inventory extraction Logic

Former Member — Wed, 17 Feb 2016 03:07:08 GMT

I will send full snapshot at mat,plant,sloc and batch level. There are no time dimensions to be used.

Re: Inventory extraction Logic

Former Member — Wed, 17 Feb 2016 04:57:00 GMT

Hi Nayab,

How about your Target Staging and reporting....??

How Much Data/records are you transferring....Will you not get Performance issues..as You dont have any of the Time Slices in Data...

regards

SVU

Re: Inventory extraction Logic

Former Member — Wed, 17 Feb 2016 05:55:41 GMT

Hi SVU,

Target reporting is not required. Basically i need to take snapshot from beginning of time and send to open hub.But i am worried whether APD will collapse in my current approach because of volume.

Do you suggest any other approach to achieve this?

Another design i thought was like below

1.Make a Overwrite DSO and load BF movements everyday Based on field SHKZG we will control issued and and received quantity (IF SHKZG = H then MENGE = MENGE*-1 else MENGE = MENGE).

2. Planning to create one more DSO with on summation mode which fed by above DSO.

3. Load DSO in step 2 with BX

Regards