COPA Extractor-How to make fields available for selection in the DataSource

[former_member356964]

Hi All,

I am looking to extend our COPA extractor to include the field Reference Procedure (CE11000-COPA_AWTYP) so that we can see where the documents originated from to help aid reconciliation cross the various data flows into COPA.

Using transaction KEB0 to definite the COPA DataSource in R3 this field is not listed for selection. What I would like to know is, can I just enhance the extraction structure in RSA6; or as this is COPA (which appears to be treated differently to other modules) is there another transaction that I need to use to make this field available for selection?

I have read the usual COPA Extractor How To docs posted on the net and there doesn't appear to be anything in them for this.

Thanks

Neil.

[former_member356964]

Hi,

Thanks for the reply; it doesn't add anything as RSA6 was one of the options I listed and this was my fall back option if there was no other special treatment for the COPA datasources.

I have found out why this, and other fields, are not available in KEB0. The program uses a Function called KERA_COPA_METADATA_INTERFACE within which there is a section that selects the COPA fields:

***** 1. RULES (choice/class)

* set rules for fixed fields
  PERFORM COPA_SET_RULES_FIXED_FIELDS USING I_ACCTCOST
                                      CHANGING E_T_RULES[].

When you look at this code section there is a hard coded list of fields to exclude:

  MRULE 'MANDT     ' NEVER FORGET_IT NEVER FORGET_IT.
  MRULE 'PAOBJNR   ' NEVER FORGET_IT NEVER FORGET_IT.
  MRULE 'PASUBNR   ' NEVER FORGET_IT NEVER FORGET_IT.
  MRULE 'PAPAOBJNR ' NEVER FORGET_IT NEVER FORGET_IT.
  MRULE 'PAPASUBNR ' NEVER FORGET_IT NEVER FORGET_IT.
  MRULE 'HRKFT     ' NEVER FORGET_IT NEVER FORGET_IT.
  MRULE 'HZDAT     ' NEVER FORGET_IT NEVER FORGET_IT.
  MRULE 'USNAM     ' NEVER FORGET_IT NEVER FORGET_IT.
  MRULE 'RKESTATU  ' NEVER FORGET_IT NEVER FORGET_IT.
  MRULE 'TIMESTMP  ' NEVER FORGET_IT NEVER FORGET_IT.

  MRULE 'PERDE     ' NEVER FORGET_IT NEVER FORGET_IT.
  MRULE 'PERIO     ' OBLIGATORY CHAR_CE3 OBLIGATORY CHAR_CE3.

  MRULE 'COPA_AWTYP' NEVER FORGET_IT NEVER FORGET_IT.
  MRULE 'COPA_AWORG' NEVER FORGET_IT NEVER FORGET_IT.

As this is a standard delivered SAP function I do not recommend that you change this code as you will invalid your SAP support and upgrade paths.

Thanks

Neil

[vyellamelli]

Hi Neil,

Enhancement of CO-PA extractor is similar to other extractors.

Enhance the existing COPA datasource by appending the required fields in RSA6 and selecting append structure and write the logic in the Include program (ZXRSAU01) in SE38 as like our normal datasource enhancement.check the data in RSA3 .

Let me know if you have any issues

Refer to SAP note Note 312711 - Enhancing CO-PA DataSources if necessary

Prasad

Edited by: PRASAD on Feb 3, 2010 5:19 PM

[Former Member]

Hi Prasad ,

I have one question. I have a customer which has added the COPA with additional fields and now they want to get it in BW as well. So I have created a new COPA datasource and also selected these additional fields (these fields were visible for selection).Now after following further steps like replicating the new datasource in Bw and also exceuting Infopackage, I found that the data is not filled for these additional fields. I then chekced the COPA tables like CE1**** for particular order no...I saw that these addtional fields are filled with Data in CO-PA tables.

Now the question is that if I need to write a exit for these additional fields in SMOD ? I guess it is not needed as my COPA tables are filled with needed data for the additional fields required , so the extractor should extract it by itself without any exit.

What do you think...I tried it without exit ..but fields are empty?? Do I write the exit ??

Your suggestion is welcomed.

Thanks

Atul

[former_member356964]

Hi Atul,

If the fields are available for selection via KEB0 (CO-PA SAPBW Datasources) then there should be no need to write any user exits in SMOD.

Have you tried running the extractor via the Extractor checker (RSA3) in R3? Does this return any data for your new fields? If not then the issue is in R3 not BW.

One thing you can try is take a look at your datasource in RSA6 (in R3), the hierarchy path should be something like SAP > SAP-R/3 > CO > CO-PA. Double click on your new datasource and in the Customer version Display check the new fields to see if they have either the 'Hide field' or 'Field only' enabled. If they are ticked for your new fields you will need to disable then (you will probably have to go back to the datasources hierarchy, switch to change mode, and reselect your datasource) .

Regards

Neil