topic Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text in Application Development and Automation Discussions

BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

Former Member — Thu, 29 Mar 2012 10:34:06 GMT

Dear Friends,

i am uploading some details along with item text using bapi_salesorder_createfromdat2.

all the data is uploaded perfetly except the item long text.

my code snipped for uploading long text is..

   *Item Long Text
          WA_TEXT-ITM_NUMBER = ITEM_NUM.
          WA_TEXT-TEXT_ID     = 'Z001'.
          WA_TEXT-LANGU       = 'E'.
          WA_TEXT-TEXT_LINE   = WA_SUB-LONG_TEXT.
          APPEND WA_TEXT TO IT_TEXT.
          CLEAR WA_TEXT.

can'T anyone help me plz......?

Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

nabheetscn — Thu, 29 Mar 2012 10:36:20 GMT

For long text you can use SAVE_TEXT separately. Where are you passing text object in above case.

Nabheet

Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

Former Member — Thu, 29 Mar 2012 10:37:48 GMT

when do i call save_text.. after bapi commit ?

can u please explain elobarately.

Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

nabheetscn — Thu, 29 Mar 2012 10:40:41 GMT

Once the sales order is created.

Thanks

Nabheet

Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

Former Member — Thu, 29 Mar 2012 10:49:30 GMT

so i have to call save_text first and then bapi_trasaction_commit. ?

Actually i am getting the data from excel sheet. From file i am moving that data in one internal table.

i have the text item wise. How do i pass the text per each item in one header data.

Do i need to pass the data for long text to bapi also...?

can anyone help me plz.

Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

Former Member — Thu, 29 Mar 2012 12:25:49 GMT

can u plz help me

Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

Private_Member_49934 — Thu, 29 Mar 2012 12:55:46 GMT

You will have to call the save_text after each line item. I am assuming the bapi is getting called in a loop. After bapi call and before end of loop, you should loop at each line item and call the FM SAVE_TEXT.

Note : for each line item you need to create one long text

The Data you need to pass to SAVE_TEXT should be similar to the below screen shot

Text Name = concatenation of sales order and sales order item

text id = 00001 ( I am assuming your updating the sales text given on the texts tab of the item display)

rest details same as above.

The text you need to update must be passed to LINES table of the FM interface. AND Yes you need a commit work to save the long text

Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

Former Member — Fri, 30 Mar 2012 05:01:32 GMT

Dear Kumar,

i Tried what u said.. still it is not updating..

heer my code...

loop at it_main into wa_main.

---

loop at it_sub into wa_sub where contrno = wa_main-contrno.

--------

endloop. "for it_sub

call function 'BAPI_SALESORDER_CREATEFROMDAT2'

-----------------------------------

          CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
          EXPORTING
            WAIT = 'X'.

**Upload Item Long Text
        clear wa_sub.
        LOOP AT IT_SUB INTO WA_SUB WHERE CONTRNO = WA_MAIN-CONTRNO.

          DATA THEADER LIKE THEAD.
          data nheader like thead.
          DATA : t_TEXT LIKE TABLE OF TLINE,
                 w_text like line of t_text.
         data : function(3) type c.

          DATA : ITEM_NUM1 TYPE VBAP-POSNR.
          ITEM_NUM1 = 10 * SY-TABIX.

          CONCATENATE WA_VBELN ITEM_NUM1 INTO THEADER-TDNAME.
          THEADER-TDOBJECT = 'VBBP'.
          THEADER-TDID     = 'Z001'.
          THEADER-TDSPRAS = SY-LANGU. "'EN'.

          w_text-tdline = wa_sub-long_text.
         append w_text to t_text.

                CALL FUNCTION 'SAVE_TEXT'
                EXPORTING
                  CLIENT                = SY-MANDT
                  HEADER                = theader
                  INSERT                = 'X'
*                 SAVEMODE_DIRECT       = ' '
*                 OWNER_SPECIFIED       = ' '
*                 LOCAL_CAT             = ' '
               IMPORTING
                 FUNCTION              = function
                 NEWHEADER             = nheader
                TABLES
                  LINES                 = t_TEXT
               EXCEPTIONS
                 ID                    = 1
                 LANGUAGE              = 2
                 NAME                  = 3
                 OBJECT                = 4
                 OTHERS                = 5
                        .
              IF SY-SUBRC = 0.
        CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
          EXPORTING
            WAIT = 'X'.

endif.
ENDLOOP.

*** Kindly help me.

Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

former_member222709 — Fri, 30 Mar 2012 05:19:33 GMT

Hi Anurag,

As directed by Nabheet & Kumar you've done it right, just forgot to add theader-tdname = Sales Order Number from the BAPI to SAVE_TEXT.

Regards,

Pranav.

Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

Former Member — Fri, 30 Mar 2012 05:24:08 GMT

Dear Pranav,

I passed that valuea also.. but it is not getting updated.

as suggested by kumar... i passed so num & item no to theader-tdname.

concatenate wa_vbeln item_num1 into theader-tdname.

Thanks,

Anurag,

Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

Private_Member_49934 — Fri, 30 Mar 2012 05:25:56 GMT

After calling the bapi get the sales document from export parameter say (l_v_vbeln)

Loop at table which you have passed ORDER_ITEMS_IN parameter of the BAPI and get the text name. properly.check the bold text. TDID shoud be 0001

clear wa_sub.
        LOOP AT IT_ORDER_ITEMS_IN INTO WA_ ORDER_ITEMS_IN .
          DATA THEADER LIKE THEAD.
          data nheader like thead.
          DATA : t_TEXT LIKE TABLE OF TLINE,
                 w_text like line of t_text.
         data : function(3) type c.
          DATA : ITEM_NUM1 TYPE VBAP-POSNR.
      
          CONCATENATE l_v_vbeln WA_ ORDER_ITEMS_IN-ITM_NUMBER  INTO THEADER-TDNAME.
          THEADER-TDOBJECT =  'VBBP'.
          THEADER-TDID     = '0001'.
          THEADER-TDSPRAS  = SY-LANGU. "'EN'.
          w_text-TDFORMAT  = '*'.
w_text-tdline = wa_sub-long_text.
         append w_text to t_text.
                CALL FUNCTION 'SAVE_TEXT'
                EXPORTING
                  CLIENT                = SY-MANDT
                  HEADER                = theader
                  INSERT                = 'X'
*                 SAVEMODE_DIRECT       = ' '
*                 OWNER_SPECIFIED       = ' '
*                 LOCAL_CAT             = ' '
               IMPORTING
                 FUNCTION              = function
                 NEWHEADER             = nheader
                TABLES
                  LINES                 = t_TEXT
               EXCEPTIONS
                 ID                    = 1
                 LANGUAGE              = 2
                 NAME                  = 3
                 OBJECT                = 4
                 OTHERS                = 5
                        .
              IF SY-SUBRC <> 0.
        CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
          EXPORTING
            WAIT = 'X'.
          endif.
        ENDLOOP.

Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

Former Member — Fri, 30 Mar 2012 05:29:17 GMT

Hi Anurag,

Why are we not using the text parameter order_text present in BAPI BAPI_SALESORDER_CREATEFROMDAT2 instead of SAVE_TEXT? you are bringing in unnecessary code and complexity by using separate code for saving the text which could be done usinG BAPI.; I would say this is not a right approach unless we got a right reason for that. also, you need not worry about passing the value to SAVE_TEXT for using BAPI to do this. Please post the code used to pass the text in BAPI which did not work for you in the initial case, let us see and find out and troubleshoot the issue.

Regards,

Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

Former Member — Fri, 30 Mar 2012 05:37:28 GMT

Dear Jagadeesh,

I also tried alot to upload long text using bapi... but failed

Plz find my code snippet....

but as suggested by nahbeet and kumar.. u can't update long text using bapi.

kindly suggest me the best way to update lont text..

*Item Long Text
          WA_TEXT-ITM_NUMBER = ITEM_NUM.
          WA_TEXT-TEXT_ID     = 'Z001'.
          WA_TEXT-LANGU       = 'EN'.
          WA_TEXT-TEXT_LINE   = WA_SUB-LONG_TEXT. " type 132 charcters
          WA_TEXT-LANGU_ISO   = 'EN'.
          WA_TEXT-FUNCTION    = '009'.
*          wa_text-format_col = '*'.
          APPEND WA_TEXT TO IT_TEXT.
          CLEAR WA_TEXT..

Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

Former Member — Fri, 30 Mar 2012 06:22:04 GMT

Dear Kumar,

I have passed the item data (it_sub) which has long text and here item num is created internally.

so thats why i am passing the value by declaring variable(item_num/ item_num1).

and here TDID is Z001(fuctional people created this for special purpose).

even though i tried to update using tdid - 0001 .. it is not updating with this value.

if it is needed i will post the total code.

Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

Former Member — Fri, 30 Mar 2012 06:26:39 GMT

Hi Anurag,

Can you remove function parameter from passing to the BAPI parameter? keep it blank and test.And langu should be E. try the below code for BAPI

*Item Long Text

WA_TEXT-ITM_NUMBER = ITEM_NUM.

WA_TEXT-TEXT_ID = 'Z001'.

WA_TEXT-LANGU = 'E'.

WA_TEXT-TEXT_LINE = WA_SUB-LONG_TEXT. " type 132 charcters

wa_text-format_col = '*'.

APPEND WA_TEXT TO IT_TEXT.

CLEAR WA_TEXT.

Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

Former Member — Fri, 30 Mar 2012 06:33:10 GMT

Dear Prasanna,

I tried with your code.. still it is not updating.

i tried with all the scenarios.. but not succeed.

plz help me.

Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

Former Member — Fri, 30 Mar 2012 06:36:14 GMT

can you create a salesorder with this text manually in the system? I think there is a config issue, try to do it manually and find out you can successfully do that. Wrong config could potentially cause such issue, example TEXT ID not assigned to a language could be one of the reason.. Hope this helps.. keep me posted.

Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

former_member222709 — Fri, 30 Mar 2012 06:39:38 GMT

Hi Anurag,

You are right in passing the Item Text Code as defined by the FC in the config - 'Z001'.

Also, better to pass item text directly to the BAPI, but still just try this.

Manually call the FM 'SAVE_TEXT' from SE37 in sequence with 'BAPI_TRANSACTION_COMMIT'.

Pass:

1. Header-tdobject = 'VBBP'

2. Header-tdname = (Concatenate 10 digit Sales Order Number with 6 digit item number) Please ensure this is a 16 digit number with pre-fixed zeroes if needed - 0010001234000010

3. Header-tdid = 'Z001'

4. Header-tdspras = sy-langu

5. lines-tdline = 'Hi'.

If this works, you'll get your solution.

I've referred this link of Thomas: http://scn.sap.com/thread/1061094

Regards,

Pranav.

Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

former_member222709 — Fri, 30 Mar 2012 06:42:13 GMT

Also a quick check for any exceptions raised by the FM 'SAVE_TEXT' or by the BAPI for the Salesorder Item Text or Header Text as applicable.

Regards,

Pranav.

Re: BAPI_SALESORDER_CREATEFROMDAT2 - Item long text

Private_Member_49934 — Fri, 30 Mar 2012 07:06:33 GMT

Try doing the below things for sales order item things and let me know what are you getting in the desired text header. Are you passing the same information in SAVE_TEXT ?please check in debug mode and post