Skip to Content
0
Jun 09, 2011 at 12:32 PM

Transportation lane KEY not getting generated in the table

71 Views

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