cancel
Showing results for 
Search instead for 
Did you mean: 

Opening stock for newly created Plants-Urgent please

Former Member
0 Kudos

Hi,

Any suggetsions will be awarded with points..for sure.

How to handel Inventory KFs for newly created Plants.

At the time of 2LIS_03_BX load these plants were not present.

Hence non-cumulative KF for these plants are coming as Blank.

Though these plants are captured in 2lIS_03_BF Delta load.

Plesae help.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

You are correct in that the BF delta will pick up transactions once the plant is activated. These transactions are not the non-cummulative KF though.

Remember - the non-cumm KF is the ending inventory balance determined at query execution by taking the reference point value and adjusting forward for all uncompressed data packages, and then adjusting backwards to the date of the ending balance. Without a reference point value, in this case it should be zero, the compuation would be incorrect.

The How To document exlains this very well - https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f83be790-0201-0010-4fb0-98bd7c01...

Also, please see OSS note - 655798, which explains the issue going on here.

Regards,

John

former_member195940
Active Contributor
0 Kudos

Thanks John for the explanation.

At my client, we have a "modify validity" program which runs on the cube everyday, which basically sets the reference point to the system date everyday.

Now do you think we can add plants some time later and get the new changes in delta records and by making use of this program which will set the reference pointer daily

Thanks

Kalyan

Former Member
0 Kudos

Hi John and Kalyan,

Thanks for response.

Another problem came up -

I am facing a problem, in displaying "Total stock qty" in Bex query. If I display qty Date wise, it should show me "Last value" for the current day (if there is no transaction for a Plant material combination).

I try to elaborate more my issue -

(1) Did stock Initialization in R3 ( on 29 Jan 08), with zero stock transfered ticked.

(2) Filled setup table for 03.

(3) Loaded BX with "Marker update".

(4) Did INIT without "Marker update".

(5) Did Delta with "Marker update". Latest delta is on 30 th Jan.

(6) Executed bex query.

There are few Plant Material combinations, for which I get "Total stock qty" value only till 29 Jan 08.

I am using this Bex query as Snap-shot purpose. It should show me value till the current date.

If there is no transaction for any Plant Material combo, it should show me the Last value.

I am following "How to .." pdf, but results are weired. It is Production issue. I don't know which step I am missing.

Please help.

Former Member
0 Kudos

Since these were in included in your BX load, you are probably missing the reference point markers for the material numbers in the plant. Trying running SAP_REFPOINT_COMPLETE from SA38. If you check the box for Insert Missing FRecords, any refernce points that are missing will be created. If you do not check the box, the program will look for missing reference points and give a re[port of those that are missing.

former_member195940
Active Contributor
0 Kudos

John and Suvrab

I have a question!

when you are getting the records from BF(delta loads)... why do you need to run this program!

My understanding is if some plants/sto loc gets added at a later stage (after BX load)... BF delta's will pick those plants and stoc loc.

The reason i am telling delta's will pick them is based on the assumption that till now the material movements and stcoks for these plants were not maintained in R/3 and hence can be captured in the delta's of BF.

Correct me if i am wrong!!

Thanks

Kalyan