Skip to Content
author's profile photo Former Member
Former Member

how to enhance (add) D.Source (masterdata)

Posted on Aug 01, 2006 at 03:22 PM 12 Views

hi, gurus,

i have requirement that i have to add the social security number to the data sourse 0PERSON_ATTR,

can any one help me the enhancement of D.S

advance thanks

ram

BW (SAP Business Warehouse)
Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 03:25 PM

    Here you can find all the details:

    Master data enhancement

    Regards

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Aug 01, 2006 at 03:31 PM

      Hi Ramanathan,

      User Exit Examples - Sample Code

      1. Extending Business Content - EXIT_SAPLRSAP_001

      data: l_s_icctrcst like icctrcst,

      l_s_icctract like icctract,

      l_s_icctrsta like icctrsta,

      l_tabix like sy-tabix.

      case i_isource.

      when '0CO_OM_CCA_1'.

      loop at c_t_data into l_s_icctrcst.

      l_tabix = sy-tabix.

      select single * from z0001 where kokrs = l_s_icctrcst-kokrs

      and kostl = l_s_icctrcst-kostl.

      if sy-subrc = 0.

      l_s_icctrcst-zfield1 = z0001-zfield1.

      l_s_icctrcst-zfield2 = z0001-zfield2.

      modify c_t_data from l_s_icctrcst index l_tabix.

      endif.

      endloop.

      when '0CO_OM_CCA_2'.

      ...

      when '0CO_OM_CCA_3'.

      ...

      when others.

      exit.

      endcase.

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 04:42 PM

    Hi ramanathan,

    here i am giving the steps to enhance the datasource.

    1. go to-> RSA6 selece ur datasource & click on the push button enhance extract structure

    2. the system will propose a extract structure name which will prifix with ZA accept it

    3. in the next screen enter the field name & componant type, make sure that the field name will start with ZZ.

    4. save the structure & activate it.

    5. now again go to RSA6

    6. select the data source & say change. scroll to the bottom thr u will find ur field, by default hide option is selected, remove it flag the appropreate option & save it.

    Up to here we added the field successfully.

    Now we need to populate the field with data.

    this needs the ABAP programme.

    Sap provides sap enhancement RSAP0001.

    You need to provide following information to ur ABAP colegue.

    Datasource name

    Extractstructure name

    field name

    table name

    Infosource name.

    He will write the functionmodule.

    in ur case the exit is Exit_SAPLRSAP_002.

    Hope this helps.

    Shaik

    Add comment
    10|10000 characters needed characters exceeded