Skip to Content
0

No data was selected with the selection criteria entered while doing CNS0

Jun 07, 2017 at 03:31 PM

410

avatar image

Hello friends,

I am not able to do delivery from project through CNS0 transaction.

I am getting message "No data was selected with the selection criteria entered" although finished goods is already there in project finished goods stock.

Process in brief: I am manufacturing die for aluminum components, production is processed using PS. I create BOM wherein there are finished good having few main assemblies in it. I assigned all material to Project using CN33 transaction (finished goods gets assigned to activity with -ve qty) and run project MRP MD51. PR is created for raw material and production order is created in-house manufacturing material. All manufacturing is done in using production order account assigned WBS element. I also create production order for finished goods as it has final assembly operation. As soon as I confirm last operation of finished goods production order. FG material gets into stock. I created "Delivery Information" in activity to which finished goods is assigned. Now when I am doing CNS0 I am getting above message.

Can you tell me what and where I am missing?

Deepak

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Sunil Yadav Jun 08, 2017 at 05:35 AM
0

Hi Deepak,

there are various things to be checked:

Check if activity to which FG is produced is Confirmed.

assign same FG material with +ve Quantity to same or other activity so this will consume and available for delivery via CNS0.

check the "Selection Cretiria"--- With Production Order... or "Third Party Order"

also check below SAP Notes if related:

1) Note 62369 - LDB PSJ: WBS elements level 1 are not found

2) Note 153245 - Deleting versions (CJ02, CN22): OK021

3) Note 311441 - CN33: Message OK600 after Note 138248

thanks

Sunil

Share
10 |10000 characters needed characters left characters exceeded
Deepak Pitale Jun 08, 2017 at 06:56 AM
0

Thanks Sunil for your reply.

I did confirmed activity in which FG was assigned (-ve qty), but material was back flushed :-(. I have some questions:

1) Does that mean PGI is done and because of that I am getting this message? I could see posting document created wherein material move happened. Stock Spec.Stock Q Project stock to E Orders on hand, i.e. from WBS element to SO. Movement type 413 Q - TF project to slsOrd.

2) Is it necessary to assign FG with +ve qty to activity to consume in CNS0?

3) Do I have to check the "Selection Cretiria"--- With Production Order... or "Third Party Order" always though my FG gets into stock through Production Order?

4) I am working on HANA S4 platform does above SAP Notes valid?

It will great if you can reply me back at the earliest.

Thank you again in advance,

Deepak M Pitale

Share
10 |10000 characters needed characters left characters exceeded
Sunil Yadav Jun 08, 2017 at 08:25 AM
0

Deepak,

If you add any material with -ve quantity means you are producing by activity confirmation and that material would be in Project Stock. in your case you have already consumed material reservation while doing this and now you have FG in Project Stock. Now if you want to deliver this material then you need to generate reservation for this which would be in +ve quantity, by creating delivery system will reduce project stock and create delivery.

1) Does that mean PGI is done and because of that I am getting this message? I could see posting document created wherein material move happened. Stock Spec.Stock Q Project stock to E Orders on hand, i.e. from WBS element to SO. Movement type 413 Q - TF project to slsOrd.----regarding this you have already have setting where system automatically transfer FG to Sales order stock. in this case you need to create delivery using sales order instead of Project delivery.

2) Is it necessary to assign FG with +ve qty to activity to consume in CNS0?----Please check above answer

3) Do I have to check the "Selection Cretiria"--- With Production Order... or "Third Party Order" always though my FG gets into stock through Production Order?------according to process you need to check

4) I am working on HANA S4 platform does above SAP Notes valid?----you need to check whether these note are still applicable for S4 Platform. check fresh downloaded NOTE.

thanks

Sunil

Share
10 |10000 characters needed characters left characters exceeded
Deepak Pitale Jun 08, 2017 at 01:42 PM
0

Hello Sunil,

I checked SAP notes it seems they are not related to transaction CNS0

62369 - LDB PSJ: WBS elements level 1 are not found
The error only occurs if WBS elements were created with transaction CJ11 and then were no longer processed with transaction CJ02.
For release 3.0D note 45578 is required.

153245 - Deleting versions (CJ02, CN22): OK021
When you delete project versions from Transaction CJ02 or CN22, the system generates error message
OK021 "No data was selected with the selection criteria entered" although the version exists.

311441 - CN33: Message OK600 after Note 138248
You implemented Note 138248 as advance correction to be able to select in CN33 with a single
network.When you choose the execute function, the system displays message OK600 or OK021.
No objects are selected.

I am still facing the same issue...looks like I am doing something incorrect.

Deepak M Pitale

Share
10 |10000 characters needed characters left characters exceeded
Deepak Pitale Jun 09, 2017 at 05:41 AM
0

Hello Sunil,

Thanks for your support, Issue resolved.

I changed qty of FG material from 1- to +1 and saved the project.

I could create delivery from project, pick and do PGI.

Great it worked !!!!

Thanks for your support again.

Deepak M Pitale

Share
10 |10000 characters needed characters left characters exceeded