Problem with consignment stock in 0IC_C03 report

[Former Member]

Hi All

I am creating a stock report which includes "unrestricted stock" "Subcon Stock" , "Stock in Transit" "consignment stock " ect...My BW report is based on CALDAY and has a breakdown on storage location. I am getting perfect QTY for all other stock status but "consignment stock " in BW is incorrect .

I am using a restricted key figure for consignment stock where I am restricting the valuated consignment stock QTY "0CNSSTCKQTY" with Stock category "K" and calday.

If I remove the storage location from row in BEX query , I get the correct QTY at plant level. Only the QTY at storage loacation level is incorrect .

MY question :-

1. Is it possible to get the conssignment stock QTY at storage location level .

2. If yes , Is it possible that I can conmbine that in inventory stock report with othere stock status.

It's really very urgent. It would be really great if you can help me out in this.

Regards,

Jagriti Jha

[Former Member]

Hi Jagriti

Consignment stock is non-cumulative and it is evaluated by using "Quantity Issued from consignment stock (0ISSCNSSTCK)" and "Quantity Received into consignment stock(0RECCNSSTCK)".

In the transformation start routine between 2LIS_03_BF--> Target Cube evaluate Issued consignment and received consignment by using a field routine. Calculation will be  based on Stock category values (BSTTYP) "K" and "Space". See sample calculation below for Issued Consignment Value . Below calculation is for the case when Reversal Indicator (ROCANCEL) is not equal to "X". For Reversal Indicator equal to X the calculation will be exactly opposite.

***only consignment stock is considered***

    CASE SOURCE_FIELDS-BSTTYP.

      WHEN 'K'.

        RESULT = SOURCE_FIELDS-BWMNG.

      WHEN space.

        IF SOURCE_FIELDS-BSTAUS CA 'KLM'.

          RESULT = SOURCE_FIELDS-BWMNG.

        ENDIF.

    ENDCASE.

Once you determine issued and received consignment in the transformation  you can  Create a selection and  Restrict " 0CNSSTCKQTY " with date range in the report. The date range should be "Start date" and "Finish Date". You can create two input variables on 0Calday and manually input the start and end dates.There are no other indicators required You can keep Storage location  in rows using aforementioned calculation.

Hope this helps

Thanks

Nayab

[Former Member]

Hi Nayab

Thanks for reply , but I already have  0ISSCNSSTCK and 0RECCNSSTCK key figures calculated through standard field routines . I can see the QTY of 0ISSCNSSTCK and 0RECCNSSTCK is correct in 0IC_C03 Cube.

My only problem is with BEX report . I am using Plant and Storage location in rows . I can see the overall result is perfectly correct for Consignment stock but consignment stock QTY at storage location level is just updating for few materials and  not updating for all the materials  in BEX report . I am just getting the overall result for the consignment stock which is correct .

It will be great if you can help.

Regards,

Jagriti Jha

[Former Member]

Hi

I can see the correct Consignment stock in report( in result column)  but consignment QTY is not  visible against material.

Regards,

Jagriti Jha

[KodandaPani_KV]

Hi,

my recommandation please check the below options

above screen shot KF always have disply mode.

or

check the those material don't hav any quantity.

while giving slection give only one material as seleciton run the report.

Thanks,

Phani.

[Former Member]

Hi Phani

Thanks a ton for the help . I checked and found out that those materials don't have any stock value and I am using a condition in query designer (Stock Qyt NOT EQUAL to 0) in condition tab . Which is why it was not coming in my BEX report .

I removed the condition and I found them all. But without and condition performance of the report is so bad.

is it possible if we can use OR condition in condition tab of Query designer . I want to use a condition like Stock QYT NOT EQUAL to 0 or 0CNSSTCKQTY not equal to 0 . so that I will get all my normal stock and consignment stock in my report .

Thanks again for the help!

regards,

Jagriti Jha

[KodandaPani_KV]

1. Is it possible to get the conssignment stock QTY at storage location level .

A. yes you will get conssigment stock qauantiy with stotage locaiton.

2. If yes , Is it possible that I can conmbine that in inventory stock report with othere stock status.

A.  yes you can combinewith other stok, how many stock staus are you getting.

, but use want see the sapareate consigment stock with stock status again it is problem.

let try the above otpions.

Thanks,

Phani.

[Former Member]

Hi Phani

Thanks a ton for the quick response.

I checked the PSA data , all looks good. Even the data in the cube is also perfect . My only problem is at report level . I am using valuated Stock QTY keyfigures in report . I am using restricted key figures for unrestricted - use stock and consignment stocks ect.

As I mentioned above I am restricting (0CNSSTCKQTY) consignment stock based on Stock Category "K" Where as for unrestricted stock I am restricting 0VALSTCKQTY  with stock type "A".

All the stock status which I am restricting with stock type ... I am getting correct value at storage location level.

But only the consignment stock is not correct .

Is it because I am restricting it at stock category level?

In standard report for consignment stock I can see , SAP is restricting at Stock Type level "K" "L" and "M". But we don't have these stock types in our BW cube . The only way I can identify the consignment stock is by stock cat "K".

Request you to share how u resolve you consignment stock problem. Are you restricting it based on stock type or stock cat.

Regards,

Jagriti Jha

[KodandaPani_KV]

Hi,

i had same issue  long time back and it is not matching with materail storage location.

can you check the any rotuine for the stotarge locaiton. and how you seen the PSA data.

check the few materail with requied quantity along with storage location.

check BW side storage location mapping have you written any routine or direct mapping.

Thanks,

Phani.