Link beween SAP Invoice Number and IDCP Invoice Number

[jayeshgala83]

Hello All

We have a plant in Mexico where we are using IDCP to generate internal invoice number. This is the requirement from Mexico Govt.

We are using SAP Invoice numbers in IDCP transaction to generate the internal invoice number.

I am trying to find the relation between IDCP generated Invoice number and normal SAP invoice number.

Is there any table where I can find the link between these 2 numbers?

As all our invoices from Mexico have this number, we are looking the way to track back using this invoice number and find corresponding SAP Invoice number and other documents.

Please let me know if anyone has come across the similar situation.

Thanks

Jayesh

[sez41 · Accepted solution]

Hi,

Check if IDCP no is written to Ref. number field in invoice header or not (VBRK-XBLNR).

[jayeshgala83 · Accepted solution]

Thanks Kıvanç Bilgin

Yes, I have found it in VBRK table as you suggested.

[siva_vasireddy2]

hi,

confirm if the SAP invoice number is refered while creating IDCP invoice number

[jayeshgala83]

Hi Shiva

We use SAP Invoice number to create IDCP invoice number.

[siva_vasireddy2]

Hi,

Then you need to check the Tables of IDCP to find the Reference number

based on the above a link may be found

[jayeshgala83]

Hello Shiva

It was my original question.

i did ask if there is any table to find the link between IDCP and SAP Invoice number.

[siva_vasireddy2]

Hi,

are you creating IDCP invoice in external system through interface?

[jayeshgala83]

They use another system which is connected to the Mexican Govt system.

They use SAP transaction IDCP, enter the Invoice numbers there and then PDF invoice is generated.

[siva_vasireddy2]

Hi,

If subsequent document created with reference to Actual invoice you can check in VBFA Table

but i feel there is no seperate document created in the system IDCP is just a prenumbered output form which refers the Actual invoice document