Relation between FI and CO document number

[Former Member]

Hi

I have Fi document number from BSIS.

Now i need to get the corresponding CO document number from COEP.

I used to get the currency dates from COEP by passing OBjnr from PRPS and KOKRS.

But the performance is very bad since the key field CO document number is empty.

Please let me know how to get the CO document number from FI document number

Thanks

[Former Member]

Hi

I have Fi document number from BSIS.

Now i need to get the corresponding CO document number from COEP.

I used to get the currency dates from COEP by passing OBjnr from PRPS and KOKRS.

But the performance is very bad since the key field CO document number is empty.

Please let me know how to get the CO document number from FI document number

Thanks

[kesavadas_thekkillath]

Check with function CO_DOCUMENT_RECORD. Cross check the documents available in table T_DOCUMENTS. For the oother way from CO document to Fi document try with FI_DOCUMENT_RECORD.

[ThomasZloch]

You can find out how the SAP standard does it by SQL-tracing the FB03 FI document display and then "environment -> document environment -> accounting documents".

Please share your result.

Thomas

[Former Member]

Hi All,

To find link between FI and CO documents:

1) Go to "BKPF-AWKEY" in table BKPF ( FI document header   -> Reference key and AUAK )

     From here you get a reference document number.

2) Now for field name "REFBN" in table "COBK" you will get the CO document number in field   

    "COBK-BELNR"

<Reward request removed by moderator>

Thanks

Mahendra Joshi

Message was edited by: Vinod Kumar