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

BAPI to get the Sales order line item details

Hi,

My program gets Sale sorder and item as the input and I need to fetch all the item (Given item) details for this Sales Order from VBAP. Is there any BAPI to get the item details?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • Posted on Feb 18, 2009 at 09:11 AM

    Hi,

    Also BAPISDORDER_GETDETAILEDLIST should work.

    Bye,

    Flavio

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 18, 2009 at 08:47 AM

    Hi,

    Check this link

    [function-module-or-bapi-to-get-the-sales-order-det]

    Cheers,

    Surinder

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 18, 2009 at 08:48 AM

    Hi Priyankha,

    Use BAPI_SALESORDER_GETDETAILBOS to get item details.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 18, 2009 at 08:54 AM

    try function module

    SD_ORDER_GET_ITEM_DATA

    or

    SD_ORDER_GET_DATA

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 20, 2009 at 10:03 AM

    Hi Priyankha,

    Use BAPI_SALESORDER_GETDETAILBOS to get item details.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 18, 2009 at 08:47 AM
    -1

    Hi,

    BAPI_GET_SALES_ORDER_ITEM

    Regards,

    Sravan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 18, 2009 at 08:47 AM
    -1

    Hi,

    This is a sample code of BAPI.Try to map it to your requirement.This is not related to vendor.This is related to sales order.

    *----


    Constants

    *----


    CONSTANTS: c_contract LIKE vbak-vbeln VALUE '0020000720',

    c_item LIKE vbap-posnr VALUE '000010'.

    *----


    Structures

    *----


    Structure to hold BAPI Header

    DATA: st_bapisdhd1 LIKE bapisdhd1.

    *----


    Internal Tables

    *----


    Sales Order Create BAPI Return Messages

    DATA: tbl_return TYPE STANDARD TABLE OF bapiret2

    WITH HEADER LINE.

    Sales Order BAPI Line Item

    DATA: tbl_bapisditm TYPE STANDARD TABLE OF bapisditm

    WITH HEADER LINE.

    Sales Order BAPI Line Item

    DATA: tbl_bapisditmx TYPE STANDARD TABLE OF bapisditmx

    WITH HEADER LINE.

    Sales Order BAPI Pricing Conditions

    DATA: tbl_bapicond TYPE STANDARD TABLE OF bapicond

    WITH HEADER LINE.

    Sales Order BAPI Partner Functions

    DATA: tbl_bapiparnr TYPE STANDARD TABLE OF bapiparnr

    WITH HEADER LINE.

    Sales Order BAPI Schedule Lines

    DATA: tbl_bapischdl TYPE STANDARD TABLE OF bapischdl

    WITH HEADER LINE.

    Sales Order BAPI Schedule Lines

    DATA: tbl_bapischdlx TYPE STANDARD TABLE OF bapischdlx

    WITH HEADER LINE.

    Sales Order BAPI Pricing Conditions

    DATA: tbl_bapicondx TYPE STANDARD TABLE OF bapicondx

    WITH HEADER LINE.

    Customer Enhancement for VBAK, VBAP, VBEP

    DATA: tbl_bapiparex TYPE STANDARD TABLE OF bapiparex

    WITH HEADER LINE.

    Table to hold BAPI Detail Conditions

    DATA: tbl_bapisdcond TYPE STANDARD TABLE OF bapisdcond

    WITH HEADER LINE.

    Table to hold Return Messages from Sales Order Change BAPI

    DATA: tbl_return_chg TYPE STANDARD TABLE OF bapiret2

    WITH HEADER LINE.

    *----


    Variables

    *----


    DATA: g_vbeln_created LIKE vbak-vbeln,

    g_valid_contract TYPE c,

    g_cont_price_date TYPE d.

    *----


    Start of Selection

    *----


    START-OF-SELECTION.

    PERFORM validate_contract.

    PERFORM create_sales_ord.

    PERFORM update_sales_ord.

    *----


    End of Selection

    *----


    END-OF-SELECTION.

    PERFORM write_output_report.

    *----


    Subroutines

    *----


    &----


    *& Form create_sales_ord

    &----


    Create the Sales Order

    -


    FORM create_sales_ord .

    PERFORM populate_bapi_tables.

    PERFORM call_create_sales_ord_bapi.

    ENDFORM. " create_sales_ord

    &----


    *& Form populate_bapi_tables

    &----


    Fill up the BAPI Tables

    -


    FORM populate_bapi_tables .

    PERFORM populate_bapi_header.

    PERFORM build_bapi_partners.

    PERFORM build_bapi_items.

    PERFORM build_bapi_sched_lines.

    ENDFORM. " populate_bapi_tables

    &----


    *& Form populate_bapi_header

    &----


    Build BAPI Header Details

    -


    FORM populate_bapi_header .

    CLEAR st_bapisdhd1.

    st_bapisdhd1-doc_type = 'ZOC'. "Order type

    st_bapisdhd1-sales_org = '026'. "Sales Org

    st_bapisdhd1-distr_chan = '00'. "Dist Channel

    st_bapisdhd1-division = '00'. "Division

    st_bapisdhd1-purch_no_c = 'Cust Po No'. "Cust PO No

    st_bapisdhd1-name = 'Orderer'. "Name of Orderer

    st_bapisdhd1-ord_reason = ''. "Order Reason

    st_bapisdhd1-sales_off = '3001'. "Sales Office

    st_bapisdhd1-sales_grp = '301'. "Market Area

    IF g_valid_contract = 'X'.

    st_bapisdhd1-price_date = g_cont_price_date.

    ENDIF.

    ENDFORM. " populate_bapi_header

    &----


    *& Form build_bapi_partners

    &----


    Build BAPI Partner Functions

    -


    FORM build_bapi_partners .

    CLEAR tbl_bapiparnr.

    tbl_bapiparnr-partn_role = 'AG'.

    tbl_bapiparnr-partn_numb = '0000100750'.

    APPEND tbl_bapiparnr.

    CLEAR tbl_bapiparnr.

    tbl_bapiparnr-partn_role = 'WE'.

    tbl_bapiparnr-partn_numb = '0000504472'.

    APPEND tbl_bapiparnr.

    ENDFORM. " build_bapi_partners

    &----


    *& Form build_bapi_items

    &----


    Build The BAPI Line Items

    -


    FORM build_bapi_items .

    DATA: l_matnr LIKE mara-matnr.

    CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

    EXPORTING

    input = '10000072'

    IMPORTING

    output = l_matnr.

    CLEAR tbl_bapisditm.

    tbl_bapisditm-itm_number = c_item.

    IF g_valid_contract = 'X'.

    tbl_bapisditm-ref_doc = c_contract.

    tbl_bapisditm-ref_doc_it = c_item.

    tbl_bapisditm-ref_doc_ca = 'G'. "Contract

    ENDIF.

    tbl_bapisditm-material = l_matnr.

    tbl_bapisditm-plant = '3012'.

    tbl_bapisditm-target_qty = '5.000'.

    tbl_bapisditm-target_qu = 'M3'.

    tbl_bapisditm-item_categ = 'ZZOC'.

    tbl_bapisditm-sales_dist = '301'.

    tbl_bapisditm-dlv_prio = '02'.

    tbl_bapisditm-prc_group5 = '080'.

    tbl_bapisditm-cust_mat35 = 'kdmat'.

    tbl_bapisditm-route = 'TESYS'.

    tbl_bapisditm-usage_ind = 'CIV'.

    APPEND tbl_bapisditm.

    CLEAR tbl_bapisditmx.

    tbl_bapisditmx-itm_number = c_item.

    tbl_bapisditmx-ref_doc = 'X'.

    tbl_bapisditmx-ref_doc_it = 'X'.

    tbl_bapisditmx-ref_doc_ca = 'X'.

    tbl_bapisditmx-material = 'X'.

    tbl_bapisditmx-updateflag = 'I'.

    tbl_bapisditmx-plant = 'X'.

    tbl_bapisditmx-target_qty = 'X'.

    tbl_bapisditmx-target_qu = 'X'.

    tbl_bapisditmx-item_categ = 'X'.

    tbl_bapisditmx-sales_dist = 'X'.

    tbl_bapisditmx-dlv_prio = 'X'.

    tbl_bapisditmx-prc_group5 = 'X'.

    tbl_bapisditmx-cust_mat35 = 'X'.

    tbl_bapisditmx-usage_ind = 'X'.

    tbl_bapisditmx-route = 'X'.

    APPEND tbl_bapisditmx.

    ENDFORM. " build_bapi_items

    &----


    *& Form build_bapi_sched_lines

    &----


    Build the BAPI Schedule Lines

    -


    FORM build_bapi_sched_lines .

    CLEAR tbl_bapischdl.

    tbl_bapischdl-itm_number = c_item.

    tbl_bapischdl-req_qty = '1'.

    tbl_bapischdl-req_date = sy-datum.

    APPEND tbl_bapischdl.

    ENDFORM. " build_bapi_sched_lines

    &----


    *& Form build_bapi_conditions

    &----


    Pull the BAPI Pricing Conditions from the Contract

    -


    FORM build_bapi_conditions .

    LOOP AT tbl_bapisdcond.

    CLEAR tbl_bapicond.

    MOVE-CORRESPONDING tbl_bapisdcond TO tbl_bapicond.

    APPEND tbl_bapicond.

    CLEAR tbl_bapicondx.

    tbl_bapicondx-itm_number = tbl_bapicond-itm_number.

    tbl_bapicondx-cond_st_no = tbl_bapicond-cond_st_no.

    tbl_bapicondx-cond_count = tbl_bapicond-cond_count.

    tbl_bapicondx-cond_type = tbl_bapicond-cond_type.

    tbl_bapicondx-updateflag = 'I'.

    tbl_bapicondx-cond_value = 'X'.

    tbl_bapicondx-currency = 'X'.

    tbl_bapicondx-cond_unit = 'X'.

    tbl_bapicondx-cond_p_unt = 'X'.

    tbl_bapicondx-varcond = tbl_bapicond-varcond.

    APPEND tbl_bapicondx.

    ENDLOOP.

    ENDFORM. " build_bapi_conditions

    &----


    *& Form call_create_sales_ord_bapi

    &----


    Call the Sales Order Create BAPI

    -


    FORM call_create_sales_ord_bapi .

    CLEAR g_vbeln_created.

    CALL FUNCTION 'BAPI_SALESORDER_CREATEFROMDAT2'

    EXPORTING

    order_header_in = st_bapisdhd1

    IMPORTING

    salesdocument = g_vbeln_created

    TABLES

    return = tbl_return

    order_items_in = tbl_bapisditm

    order_items_inx = tbl_bapisditmx

    order_partners = tbl_bapiparnr

    order_schedules_in = tbl_bapischdl.

    CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

    EXPORTING

    wait = 'X'.

    ENDFORM. " call_create_sales_ord_bapi

    &----


    *& Form update_sales_ord

    &----


    Update the newly created Sales Order with the Pricing Conditions

    from the Contract

    -


    FORM update_sales_ord .

    CHECK g_valid_contract EQ 'X'.

    PERFORM get_contract_details.

    PERFORM build_bapi_conditions.

    PERFORM call_change_sales_ord_bapi.

    ENDFORM. " update_sales_ord

    &----


    *& Form get_contract_details

    &----


    Get Contract Details

    -


    FORM get_contract_details .

    Need to manually get the relevant Pricing Conditions as the BAPI

    BAPISDORDER_GETDETAILEDLIST causes problems when we call the BAPI

    BAPI_SALESORDER_CREATEFROMDAT2 and BAPI_SALESORDER_CHANGE (I think

    this is due to the fact that these BAPIs belong to the same Function

    Group and there must be some common structures that are not cleared

    causing us all sorts of grief when we try and call the next BAPI)

    DATA: tbl_konv TYPE STANDARD TABLE OF konv WITH HEADER LINE.

    DATA: tbl_komv TYPE STANDARD TABLE OF komv WITH HEADER LINE.

    DATA: tbl_vbak TYPE STANDARD TABLE OF vbak WITH HEADER LINE.

    Pricing Condition Master

    DATA: BEGIN OF tbl_t685a OCCURS 0,

    kschl LIKE t685a-kschl,

    kaend_wrt LIKE t685a-kaend_wrt,

    END OF tbl_t685a.

    SELECT *

    INTO TABLE tbl_vbak

    FROM vbak

    WHERE vbeln = c_contract.

    READ TABLE tbl_vbak INDEX 1.

    SELECT *

    INTO TABLE tbl_konv

    FROM konv

    WHERE knumv = tbl_vbak-knumv AND

    kposn = c_item.

    CHECK sy-subrc EQ 0.

    We now need to make sure we only bring across the Condition Types that

    are EDITABLE. If we bring across non editable conditions (such as

    'ZPR1') the Change Sales Order BAPI will fail

    SELECT kschl kaend_wrt

    INTO TABLE tbl_t685a

    FROM t685a

    FOR ALL ENTRIES IN tbl_konv

    WHERE kappl EQ 'V' AND "Sales

    kschl EQ tbl_konv-kschl AND

    kaend_wrt EQ 'X' AND "Value is Editable

    kmanu NE 'D'. "Process manually

    Prepare for Binary Search

    SORT tbl_t685a BY kschl.

    LOOP AT tbl_konv.

    READ TABLE tbl_t685a WITH KEY kschl = tbl_konv-kschl BINARY SEARCH.

    IF sy-subrc EQ 0.

    MOVE-CORRESPONDING tbl_konv TO tbl_komv.

    APPEND tbl_komv.

    ENDIF.

    ENDLOOP.

    CHECK NOT tbl_komv[] IS INITIAL.

    Map KOMV into the more BAPI friendly BAPISDCOND structure

    CALL FUNCTION 'MAP_INT_TO_EXT_STRUCTURE'

    TABLES

    fxvbak = tbl_vbak

    fxkomv = tbl_komv

    fxbapikomv = tbl_bapisdcond

    EXCEPTIONS

    entry_missing = 1

    OTHERS = 2.

    ENDFORM. " get_contract_details

    &----


    *& Form call_change_sales_ord_bapi

    &----


    Call the Change Sales Order BAPI

    -


    FORM call_change_sales_ord_bapi .

    DATA: st_head_chg LIKE bapisdh1x,

    st_logic_switch TYPE bapisdls.

    CHECK NOT g_vbeln_created IS INITIAL.

    CHECK g_valid_contract EQ 'X'.

    st_head_chg-updateflag = 'U'.

    st_logic_switch-cond_handl = 'X'.

    CALL FUNCTION 'BAPI_SALESORDER_CHANGE'

    EXPORTING

    salesdocument = g_vbeln_created

    order_header_inx = st_head_chg

    logic_switch = st_logic_switch

    TABLES

    return = tbl_return_chg

    conditions_in = tbl_bapicond

    conditions_inx = tbl_bapicondx.

    CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

    EXPORTING

    wait = 'X'.

    ENDFORM. " call_change_sales_ord_bapi

    &----


    *& Form write_output_report

    &----


    Produce Output Report

    -


    FORM write_output_report .

    IF NOT g_vbeln_created IS INITIAL.

    WRITE:/ 'Success! Sales Order', g_vbeln_created, 'was created!'.

    ELSE.

    WRITE:/ 'Failure! Sales Order was not created!'.

    ENDIF.

    SKIP.

    WRITE:/ 'Sales Order Create Log'.

    LOOP AT tbl_return.

    WRITE:/ tbl_return-type, tbl_return-id, tbl_return-number,

    tbl_return-message.

    ENDLOOP.

    SKIP.

    WRITE:/ 'Sales Order Change Log'.

    LOOP AT tbl_return_chg.

    WRITE:/ tbl_return_chg-type, tbl_return_chg-id,

    tbl_return_chg-number, tbl_return_chg-message.

    ENDLOOP.

    ENDFORM. " write_output_report

    &----


    *& Form validate_contract

    &----


    Make sure that the Contract is Valid

    -


    FORM validate_contract .

    DATA: l_gueen LIKE vbak-gueen,

    l_prsdt LIKE vbkd-prsdt.

    SELECT SINGLE vbakgueen vbkdprsdt

    INTO (l_gueen, l_prsdt)

    FROM vbak

    INNER JOIN vbkd

    ON vbakvbeln = vbkdvbeln

    WHERE vbak~vbeln = c_contract AND

    vbkd~posnr = '000000'.

    IF sy-datum LE l_gueen.

    Contract is valid! Set Order Price Date

    g_valid_contract = 'X'.

    g_cont_price_date = l_prsdt.

    ENDIF.

    ENDFORM. " validate_contract

    Regards

    Rajesh Kumar

    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.