BAPI required

[Former Member]

Hi,

Need a BAPI which returns

Qty Available

Part Number

Retail price

Item Weight

Cost.

Is there any standard BAPI which is close to it.

Please help and guide.

Thanx

Kamlesh

[Former Member]

Check the BAPI - BAPI_MATERIAL_AVAILABILITY

Thanks

Seshu

[Former Member]

Try this BAPI below

BAPI_MATERIAL_GET_DETAIL

[Former Member]

Using this function module, you can determine the receipt quantity still available for a particular material in a certain plant according to ATP logic (MRPII).

The availability check is carried out on transferring the material number, the plant and the input table (WMDVSX). The scope of the check, that is, which stocks, receipts and issues are to be included in the check is defined by the combination of checking group (material master) and cheking rule. In the function module, the system uses the checking rule defined in Sales & Distribution (A). You can overrule this checking rule by using an interface or a user-exit (exit_saplw61v_001). A similar procedure is also valid for the plant parameters. The customer number in the user-exit means that the plant selection can be controlled via the customer. If no plant parameters are given via the interface, the system uses the parameter ‘WRK’ saved in the user’s fixed values.

The results of the availability check are recorded in the output table (WMDVEX). This table contains dates and available receipt quantities (ATP quantities). The results of the check depends on the following entries:

If no date and no quantity is transferred, the system displays the ATP situation from today’s date into the future as the result.

If only a date and no quantity is transferred, the system displays the ATP situation from the corresponding date as the result.

If both a date and a quantity are transferred, the system calculates the availability situation for the quantity specified.

In the last two cases, the parameter ‘DIALOGFLAG‘ is supplied. This can result in the following:

‘ ‘ (blank) <=> quantity completely available

‘X’ <=> only partial quantity available or not available at all

‘N’ <=> Material not included in the availability check

(Material not relevant to the availability check)

The system also displays the end of the replenishment lead time (ENDLEADTME).

Call BAPI Material Availability

CALL FUNCTION 'BAPI_MATERIAL_AVAILABILITY'

EXPORTING

plant = ls_plant-werks

material = it_material-material

unit = it_material-unit

check_rule = it_material-check_rule

IMPORTING

return = ls_return

TABLES

wmdvsx = lt_req

wmdvex = lt_com.

Import Parameters:

PLANT: give a plant number

MATERIAL: give a material number

UNIT: unit of measure for the material

CHECK_RULE: give a check rule, value table is T441R (Values Table for Checking Rule). If you don’t give check_rule, the function module gets A (SD order).

Table parameter WMDVSX (Input table (date and quantity)):

REQ_DATE: Requirement date. If no date and no quantity is transferred, the system displays the ATP situation from today’s date into the future as the result.

REQ_QTY: Required quantity.

DELKZ: You can give MRP element indicator, it isn’t obligatory.

YLINE: You can give index number to each line for internal table processing.

Export Parameters:

RETURN: If something returns with this parameter, it shows something is wrong. After calling function module, firstly check this parameter. For example you can get a message like that: “Material MMM not maintained in plant”

Table parameter WMDVEX (Output table (date and ATP quantity)):

REQ_DATE: Requirement date from import table WMDVSX.

REQ_QTY: Required quantity from import table WMDVSX.

COM_DATE: Committed date. If there is available quantity for required quantity, it is same as REQ_DATE. It could be different than requirement date; it means there is no available quantity on required date, but it is available in the (near) future.

COM_QTY: Committed quantity. It must be same as required quantity.