cancel
Showing results for 
Search instead for 
Did you mean: 

Account based COPA datasource does not have Document Number

Former Member
0 Kudos

Hi,

I am creating Account based COPA datasource using the tcode KEB0, but there is no field available for Document Number.

Can Account based COPA datasoucre provide Document Level details. Please let me know is this is possible.

I am able to create the datasource and load the data to BI but it does not contain Document Number.

Regards,

Sandeep

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

I know its long time since this question is post. can someone answer it.

We are also facing same issue.

User wants all the fields from Ke24 in account based extractor.

but account based copa is not having line tem details.

How to process this query?

Thanks,

Ankie

sbsharma
Explorer
0 Kudos

Hi Ankie,

Standard COPA Extraction process (using KEB0) only allows to select the fields that are part of COPA Segment (CE4**** table).

You will not be able to add any other fields outside this table.

Regards,

Sandeep

Former Member
0 Kudos

Hi Sandeep,

Thanks for your reply.

Then is there any alternative solutions to fetch all KE24 fields to BW with COPA account based?

Thanks,

Ankie

sbsharma
Explorer
0 Kudos

Hi Ankie,

You can'y add fields to the SAP generated datasource (1_CO_PA****).

You will need to build a custom extractor.

Regards,

Sandeep

Former Member
0 Kudos

HI Sandeep,

can't we enhance this data source 1_CO_PA_**** with the fields I required like account document number in RSA6?

is it possible?

Thanks

Ankie

sbsharma
Explorer
0 Kudos

Changes are not possible to the 1_CO_PA datasource.

Regards,
Sandeep

Former Member
0 Kudos

Hi Sandeep,

Just one doubt , I went to RSA6 and selected my COPA data source and when I click the option enhance extract structure it asked me to enter the append structure. name.

Is it not possible to enhance the COPA account based like this and add the field BELNR ?

Thanks for all the help so far!

Regards,

Ankie

Former Member
0 Kudos

adding to my last reply, I mean through CMOD.

Regards,

Ankie

sbsharma
Explorer
0 Kudos

As far as I know, you can't make any changes to 1_CO_PA by any means RSA6/ CMOD.

You can go ahead and try.

Regards,

Sandeep

Former Member
0 Kudos

Hi Sandeep,

Thanks for your help so far!

I decided to create a custom extractor and will take Ce4XXXX table for all the required fields and will take COEP table for document number but the problem is based on what fields I should join both tables and create a view.

Could you please let me know if you have any insight on this.

Regards,

Ankie