Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Feb 03, 2010 at 04:08 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Feb 05, 2010 at 03:08 PM

    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

    Add comment
    10|10000 characters needed characters exceeded