query regd. an FM

[Former Member]

Hi,

Is anyone aware of an FM that takes in the sales document number as input and gives as output the header and item level details into an internal table, or only the item level details...into an internal table

[Former Member · Accepted solution]

Hi,

BAPISDORDER_GETDETAILEDLIST

Regards,

Maxim.

[Former Member · Accepted solution]

Hi Maxim,

Thanks for the FM...any help on how exactly to use it..

I mean the interface has something like I_BAPI_VIEW and I_MEMORY_READ...what do I pass on to these variables so that I can read the header and item of a document number.

Thanks for the help in advance

Regards,

Vijay

[Former Member · Accepted solution]

hi,

try with this

item_data_order_view LIKE order_view,

item_data_order_view-header = 'X'.

item_data_order_view-item = 'X'.

item_data_order_view-partner = 'X'.

item_data_order_view-status_h = 'X'.

item_data_order_view-text = 'X'.

MOVE 'ordernumber' TO item_data-vbeln

CALL FUNCTION 'BAPISDORDER_GETDETAILEDLIST'

EXPORTING

i_bapi_view = item_data_order_view

i_memory_read = ' '

TABLES

sales_documents = item_data

order_headers_out = item_data_bapisdhd

order_items_out = item_data_bapisdit[]

order_partners_out = item_data_bapisdpart[]

order_statusheaders_out = item_data_bapisdhdst[]

order_textheaders_out = item_data_bapisdtehd[]

order_textlines_out = item_data_bapitextli[].

chers,

sasi

[Former Member · Accepted solution]

vijay,

I_BAPI_VIEW is used to specify target attributes you have to recieve from FM. I_MEMORY_READ should be empty for FM to request data base.

So to get sales order header and items details proceed as follows:

DATA:

it_sales_document TYPE STANDARD TABLE OF sales_key,

wa_sales_document LIKE LINE OF it_sales_document,

it_order_headers TYPE STANDARD TABLE OF bapisdhd,

it_order_items TYPE STANDARD TABLE OF bapisdit,

wa_bapi_view TYPE order_view.

wa_bapi_view-header = 'X'.

wa_bapi_view-item = 'X'.

wa_sales_document-vbeln = 'ORDER NUMBER'.

APPEND wa_sales_document TO it_sales_document.

CALL FUNCTION 'BAPISDORDER_GETDETAILEDLIST'

EXPORTING

i_bapi_view = wa_bapi_view

• I_MEMORY_READ =

TABLES

sales_documents = it_sales_document

order_headers_out = it_order_headers

order_items_out = it_order_items

• ORDER_SCHEDULES_OUT =

• ORDER_BUSINESS_OUT =

• ORDER_PARTNERS_OUT =

• ORDER_ADDRESS_OUT =

• ORDER_STATUSHEADERS_OUT =

• ORDER_STATUSITEMS_OUT =

• ORDER_CONDITIONS_OUT =

• ORDER_COND_HEAD =

• ORDER_COND_ITEM =

• ORDER_COND_QTY_SCALE =

• ORDER_COND_VAL_SCALE =

• ORDER_CONTRACTS_OUT =

• ORDER_TEXTHEADERS_OUT =

• ORDER_TEXTLINES_OUT =

• ORDER_FLOWS_OUT =

• ORDER_CFGS_CUREFS_OUT =

• ORDER_CFGS_CUCFGS_OUT =

• ORDER_CFGS_CUINS_OUT =

• ORDER_CFGS_CUPRTS_OUT =

• ORDER_CFGS_CUVALS_OUT =

• ORDER_CFGS_CUBLBS_OUT =

• ORDER_CFGS_CUVKS_OUT =

• ORDER_BILLINGPLANS_OUT =

• ORDER_BILLINGDATES_OUT =

• ORDER_CREDITCARDS_OUT =

• EXTENSIONOUT =

.

it_order_headers contains sales order header data.

it_order_items contains sales order items data.

Regards,

Maxim.

[Former Member]

anyone...

[Former Member]

I didnt get ur question.

Do u mean the header texts and item texts.

Binoo