cancel
Showing results for 
Search instead for 
Did you mean: 

Upload result from Excel sheet and Collective UD

Former Member
0 Kudos

Dear All,

We have a following requirement. Reuqest you all to help.

1. We want to upload QA result from excel file.

2. In connective UD We want to do UD on same date. But in QA16 system not allowing to enter "SLED/BBD Date" i.e. Shelf Life Expiration or Best-Before Date.

Thanks in advance,

Nirav

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

.

Former Member
0 Kudos

If you do not enter "SLED/BBD Date during G/R you have to enter during the UD.As this Date derived from manufacturing date this has be to correct otherwise system does throw error

Former Member
0 Kudos

Thanks for your reply Sujit.

We want to do this because :

We are generating inspection lots in last day of every month for closing stock (Z8 inspection type) of in-process material.

Now user enters result manuly for each inspection lots. But his requirement is for UD of all the inspection lot in one strock. He is entering "SLED/BBD Date" as last day of respective month.

Regards,

Nirav

Former Member
0 Kudos

Nirav,

For SLED calculation -

You can use automatic SLED calculation functionality.

Maintain total shelf life in the material master record, SAP automatically calculates the SLED based on GR date. For additional info refer to

http://help.sap.com/saphelp_45b/helpdata/en/a7/e58464dd9511d185170000e82013e8/frameset.htm

In config - Verify that expiration date check is set for plant and movement types used.

Menu path Logistics general -->batch management > SLED> set expiration date check

In material master maintain shelf life in Plant / Stor1 View.

For Uploading results from ECXEL - you need programming. You can use LSMW or BDC program.

AKM.

Former Member
0 Kudos

What error message you are getting?

vishal

Former Member
0 Kudos

Thanks for your reply.

I am not getting error. This is our requirement.

Regards,

Nirav