Question about table COEP

[former_member462798]

Hi SAP Expert and Guru,

Currently I am gathering the Invoice Document Number from Project ID and below is my table flow.

Project ID/ WBS is being inserted to table PRPS-PSPHI,

Then the Object Number from PRPS-OBJNR is being captured and being used in table COEP-OBJNR to derive the value in COEP-BELNR.

Later the value in COEP-BELNR is being used in table COBK-BELNR to derive the invoice number in COBK-REFBN.

My question now is, is there any other table that we can use to replace table COEP, in order to get the Object Number OBJNR linked up with the Document Number BELNR which can be used in table COBK to derive the Invoice Number.

Kindly Advise and consult.

Thank you

Regards

Leonard Tan

[Former Member]

Why dont you try to use the OBJNR from PRPS and use it in the COFP table?

I think you should be able to get the details you are looking for.

Let us know if it helps.

[former_member462798]

Nope its not working, the object number from PRPS cannot be found in COFP. Thank you

[sanjeevc]

Hi Jian,

may be the those object number doesn't containing any record so.

other wise once you pick object number COFP table then passing it to PRPS so definitely there would be record will you find. if is it then logic is correct, test it and let me know...

Regards,

Sanjeev