Load invoice number into Infocube: 0CCA_R40

[Former Member]

Hi everyone,

I have load data from datasource 0CO_OM_CCA_40 to Infocube: 0CCA_R40. this Info Cube contains Cost line item, which has field CO Document number. But my Department want to see the Finance Document number (may be invoice number), because they want to check the Invoice in R3.

So could you please help how to find the Finance Document number (invoice number) based on this CO Documen? i mean the Datasource for this Invoice number

Thankyou very much!

[Former Member · Accepted solution]

Dear,

Try to look in tables COVP, COEP and COBK. This data source is mainly based on these tables.

You need to sit with some FI functional source, have a sample set and try to find out where you can find out invoice number that business is asking.

I would rather sit with some business user and have him answer my query and show me the invoice number taking any CO document number. Through some transaction OR some table in ECC.

You might get that from already CO related data loaded in BW OR you might want to enhance then taking additional field for invoice number. Of course you will also want to load historical data to have invoice number added in that.

Thanks & Regards,

M

[bhavinvyas]

Check for the field REFBN - Reference Document Number in your datasource. Sometimes in ECC using copy control options they are passing invoice numbers so please confirm with your functional team whether they are passing invoice number in the reference document number if yes you can use this field as Invoice Number in BW but in ECC they have to make sure they will enter Invoice Number only.

Thanks,

Bhavin Vyas

[Former Member]

Thanks Bhavin,

What do     you mean by passing invoice number?

I have showed my department about the reference document number in the datasource.but they told me they dont need that number they need finance document number only

[bhavinvyas]

I believe its a free field in ECC while posting a document. By using copy control option in ecc system can pass invoice no, po no. etc. according to the settings made. In some cases user enters values in reference fields in ECC.

Thanks,

Bhavin VYAS

[Former Member]

Confirm with the business which field they want, get some help from the ECC functional if required, it may be available in your DS already or you may require an exit to pick up the correct field and map it into BW.