Transportation lane KEY not getting generated in the table

[Private_Member_738444]

Transportation lane KEY not getting generated in the table

Hi folks,

The issue is like this :

We have a weekly workorders upload program from legacy systems to SAP-APO. The legacy planners send a .CSV file containing material-wise workroders. A customised zee program picks these quantities & writes them in Prod.planned keyfigures in SNP planning book. This process is done for the manufacturing locations only.

Lately workorders for two particular material M1 & M2 had failed to get upload. It gives the error 'NO VALID SOURCE OF SUPPLY COULD BE FOUND' in its Job log. We did some debugging & found that for successful materials the TRPID is getting generated in the table /SAPAPO/V_TRPROD whereas this TRPID is missing for M1 & M2. Why this is happening is our main concern. We tried deleting the PPM & creating this again, assuming that the PPMID is the precursor for generating this TRPID, but this yielded no results.

____ for successful upload______________

se16 --> /SAPAPO/V_TRPROD

Version = 000

LOCTO = LOCID KEY for manufacturing location

MATID = MATID KEY of successfully loaded workorder

Enter

This gives the following results

TRPID = TRPID KEY

LOCFR = LOCID KEY for manufacturing location

LOCTO = LOCID KEY for manufacturing location

MATID = MATID KEY for successfully loaded workorder

( This seems a self-lane, i.e both TO & FROM location are same)

____ for unsuccessful upload________

se16 --> /SAPAPO/V_TRPROD

Version = 000

LOCTO = LOCID KEY for manufacturing location

MATID = MATID KEY for unsuccessfully loaded workorder

Enter

This gives the following results

Error = No Table entries found for specified KEYS

We are perplexed why this TRPID is not getting generated for these two particular material M1 & M2?

We have deleted their PPM & re-created them to cross-check if the PPMID KEY is the trigger for generating the TRPID key. This didn't work!

Please let us know in case someone faced a similar issue.

Many Thanks.

Kumar

Edited by: Blue Lotus on Jun 9, 2011 2:44 PM

[Former Member]

Seems like something wrong in the PPM. Did you do a check on the PPM? When you save, it should create the TRPID for the PPM.

[Private_Member_738444]

Yes Anand.

We deleted the PPM & created it again, which didn't work.

Later on we deleted the product itself from APO & re-CIFed it from R3 & then re-created the PPM.

The PPMID which was missing earlier is now getting created! However no luck with the TRPID.

Why this TRPID is not getting generated in our only concern

Regards

Kumar

[Former Member]

Please check Transportation lane and PPM both for the Material at location and see if they both are valid for the date order is created.

[Private_Member_738444]

This problem got solved automatically.

Seems once the servers/systems reeboted, all inconsistencies were removed.

Thanks neverthless.

Kumar