Copy Filter Table Uja_Filter

Hi Bpc Friends

I have created a filter in the EPM-add in and I have inserted in the selection of a data package.

I have copied this filter in the table in BW so another user can run the same package but he got an error message

WWW.SAP.COM/ABAPXML" VERSION="1.0"> PRESS_CONSOL M AXSTUART REPORTING TIME BUD_FCST_DRS TIME BUD_FCST_DRS I

EQ IN_BPF X 0000-00-00 0000-00-00
tdjxp.png (31.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Nov 30, 2016 at 01:30 PM

    Are you sure that you copied full text in CONTENT? How you perform copy?

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 30, 2016 at 02:01 PM

    Look on the sample CONTENT field in my system (I have split it into lines):

    <?xml version="1.0" encoding="utf-16"?>
    <asx:abap xmlns:asx="http://www.sap.com/abapxml" version="1.0">
    <asx:values>
    <ROOT>
    <APPSET_ID>SIM</APPSET_ID>
    <TYPE>M</TYPE>
    <USER_ID>V.KALININ</USER_ID>
    <APPLICATION_ID>ST123</APPLICATION_ID>
    <DATASET_ID>USER22</DATASET_ID>
    <NAME>ttt</NAME>
    <T_SEL_ATTR>
    <UJ0_S_SEL>
    <DIMENSION>USER22</DIMENSION>
    <ATTRIBUTE>CALC</ATTRIBUTE>
    <SIGN>I</SIGN>
    <OPTION>EQ</OPTION><LOW>Y</LOW><HIGH/>
    </UJ0_S_SEL>
    </T_SEL_ATTR>
    <T_SEL_ATTR_LONG/>
    <T_SEL_HIER/>
    <F_OR_MODE>X</F_OR_MODE>
    <DATEFROM>0000-00-00</DATEFROM><DATETO>0000-00-00</DATETO>
    </ROOT>
    </asx:values></asx:abap>

    User is also present here!

    Add comment
    10|10000 characters needed characters exceeded

    • I FOUND the problem, when I copy the filter even if the some part of the string is lowercase when I save it will be changed in upper case

      How could I fix that?

      WWW.SAP.COM/ABAPXML" VERSION="1.0"> PRESS_CONSOL M BPCSIT1 REPORTING TIME BUD_FCST_DRS TIME BUD_FCST_DRS I

      EQ IN_BPF X 0000-00-00 0000-00-00

      ?xml version="1.0" encoding="utf-16"?> http://www.sap.com/abapxml" version="1.0"> PRESS_CONSOL M MMEDAGLIA Reporting TIME BUD_FCST_DRS TIME BUD_FCST_DRS I

      EQ IN_BPF X 0000-00-00 0000-00-00
  • Dec 01, 2016 at 11:51 AM

    Sorry, but it's better to compare the same filters (same selection)!

    Add comment
    10|10000 characters needed characters exceeded

    • Sample of record copy with user name changed:

      DATA: wa TYPE uja_filter.
      " Select source record with user V.KALININ, filter name NODY etc...
      SELECT * FROM UJA_FILTER INTO CORRESPONDING FIELDS OF wa WHERE APPSET_ID = 'SIM' AND TYPE = 'M' AND USER_ID = 'V.KALININ' AND APPLICATION_ID = 'INFILE' AND DATASET_ID = 'PERIODS' AND NAME = 'NODY'.
      ENDSELECT.
      WRITE: / wa-mandt, wa-appset_id, wa-type, wa-user_id, wa-application_id, wa-dataset_id, wa-name, wa-content, wa-f_or_mode, wa-datefrom, wa-dateto.
      " Change user name in USER_ID and CONTENT to V.KRIGER
      wa-user_id = 'V.KRIGER'.
      REPLACE ALL OCCURRENCES OF 'V.KALININ' IN wa-content WITH 'V.KRIGER'.
      WRITE: / wa-mandt, wa-appset_id, wa-type, wa-user_id, wa-application_id, wa-dataset_id, wa-name, wa-content, wa-f_or_mode, wa-datefrom, wa-dateto.
      " Insert new record for V.KRIGER
      INSERT UJA_FILTER FROM wa.
      " Show result - all records
      CLEAR wa.
      SELECT * FROM UJA_FILTER INTO CORRESPONDING FIELDS OF wa.
        WRITE: / wa-mandt, wa-appset_id, wa-type, wa-user_id, wa-application_id, wa-dataset_id, wa-name, wa-content, wa-f_or_mode, wa-datefrom, wa-dateto.
      ENDSELECT.
Skip to Content