Skip to Content
avatar image
Former Member

Steps to build an extractor of material ersales text (FM READ_TEXT)

Hello,

Could you please help me with the steps to build an extractor for BI 7.0 to get the the sales text of the material that is in R3 transaction MM03?

Thanks & Regards,

Adriana Oliveira

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 01, 2008 at 04:57 PM

    Adriana,

    if you need to use a function module to read the values which you need (rather than values being easily available in a table) then I think the simplest method to get the data is to create a function module based data.

    Steps:

    1) Create a structure in transaction SE11 which contains fields:

    - Material

    - Sales Organisation

    - Distribution Channel

    - Sales Text (first 60 chars?)

    2) Identify the parameter with which to call read text to obtain the text you need

    3) Create a new function module group

    4) Copy an existing ATTR Datasource which is based on a function module - use table Roosource to identify a datasource with

    Datasource Type = ATTR

    Extraction Method = F2 (Function Module)

    use you new function module group

    5) Change your new function module to read a table containing one material master record for each material, sales org and distribution channel (MVKE - Sales Data for Material) and for each entry call read text to obtain the sales text

    Mark

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Robert,

      I am used with standard extractors and it is difficult for me to make this function module READ_TEXT become the extractor of sales text. I am getting the following error message:

      INCLUDES LZZSALES_TXTTOP

      REPORT/PROGRAM statement missing, or program type is I (INCLUDE).

      I went to RSO2 and created a master data datasource with this FM. But this FM is still with error.

      When I go to SE37, I have in the tab source code the following:FUNCTION ZBW_SALES_TXT.

      DATA: g_objname LIKE makt-MAKTG.

      refresh git_mat_text1.

      call function 'READ_TEXT'

      exporting

      id = '0001'

      language = 'P'

      name = g_objname

      object = 'MVKE'

      tables

      lines = git_mat_text1

      exceptions

      id = 1

      language = 2

      name = 3

      not_found = 4

      object = 5

      reference_check = 6

      wrong_access_to_archive = 7

      others = 8.

      ENDFUNCTION.

      In the main program or global data I left only what is automatically done.

      In tha tab IMPORT I have

      CLIENT LIKE SY-MANDT

      ID LIKE THEAD-TDID

      LANGUAGE LIKE THEAD-TDSPRAS NAME LIKE THEAD-TDNAME OBJECT LIKE THEAD-TDOBJECT ARCHIVE_HANDLE LIKE SY-TABIX 0

      LOCAL_CAT

      SPACE

      I_DSOURCE TYPE ZZSALES_TEXTMASTER

      Thanks & Regards,

      Adriana Oliveira

  • avatar image
    Former Member
    Feb 15, 2009 at 08:53 PM

    Z extractor using ABAP to read sales text

    Add comment
    10|10000 characters needed characters exceeded