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

Regarding BDC and SM30

Hello ,

1) In using BDC using Call transaction.....

How to use Delimter "#" inbetween the filed data

2) If file is uploaded from Application server for BDC program (Call transaction)....How to do this...

3)what is the use of SM30 ...where we use it

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 04:44 AM

    Hi Sunil,

    welcome to sdn.

    Let me tell u one thing as a end user you should not have authorization of

    SM30. it is very critical T-Code. Apart from Basis or if any required

    Functional person should have this authorization. With the help of this

    T-Code you can give value to field or in other words you can enter data in

    that maintained table

    see this link

    http://www.youtube.com/watch?v=wS-kIr5iUWE

    your second question was not clear.pls ask once.

    DELIMITER '<delimiter>'

    < delimiter > ::= <character>

    delimiter: character used to delimit data in selections when the CSV format is used (delimiter dispay), default value: double quotations marks (u201C)

    You can specify exactly one character that originates from the 7 bit ASCII character set (only 1 byte long) or no character (no delimiter).

    thanks

    karthik

    reward me if useull

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 04:49 AM

    Hi,

    1)How to use Delimter "#" inbetween the filed data?

    A) you can put # between fields data with ut any sapce in the flatfile.

    2) If file is uploaded from Application server for BDC program (Call transaction)....How to do this...?

    A)Use OPEN DATASET, READ DATASET....

    3)what is the use of SM30 ...where we use it?

    A) SM30 is used for Table view maintainance generator..

    if you want to modify your table data or add any additional records into that table..you can useit.

    Regards,

    Venkat N

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 05:05 AM

    hi,

    for uploading the data from the appilication server

    first open the dataset

    example:

    OPEN DATASET P_P_SRFILE FOR INPUT IN TEXT MODE ENCODING DEFAULT.

    READ DATASET P_P_SRFILE INTO W_MARA.

    IF SY-SUBRC NE 0.

    EXIT.

    ENDIF.

    SPLIT W_MARA AT ',' INTO W_MARA-MATNR W_MARA-MBRSH W_MARA-MTART W_MARA-WERKS

    W_MARA-MAKTX W_MARA-MEINS W_MARA-MATKL.

    APPEND W_MARA TO T_MARA.

    CLEAR W_MARA.

    ENDDO.

    CLOSE DATASET P_P_SRFILE.

    then populate the data.

    LOOP AT T_MARA INTO W_MARA.

    PERFORM BDC_DYNPRO USING 'SAPLMGMM' '0060'.

    ................................................................

    call transaction syntax.

    endloop.

    sm30 is used for table maintainence.

    maintain the table views.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.