RFC FM for get the Material Master in ECC

[Former Member]

Hi,

I have requirement like below.

The identification for creating Consignment Orders is Special Procurement Type = 10 (Consignment) for the materials in ECC. An RFC call to get the Material Master information is necessary. The Special Procurement Type field is available on the MRP2 view of Material Master.

The resulting PO document type = u2018GPu2019 and Item Category = u2018Ku2019.

The number range of Purchase Order to be created in is u201C70u2026u2026u201D. The number range in the ECC is u2018GPu2019, which is 7010000000 to 7099999999.

My questions:

Please let me know the RFC name and let me know how to mantain the number range in BADI implementation of BBP_SC_TRANSFER_BE to set the number range for the Consignment Order.

Regards,

Venkat

[laurent_burtaire · Accepted solution]

Hello Venkat,

For your RFC call to get R/3 Material Master data, you can use SRM function module META_READ_TABLE.

MDMA R/3 table is for MRP Area for Material: as we do not use MRP, i don't if this is that table which is used in MRP view for material.

If not, look for by yourself.

You will find below an ABAP code sample:

CONCATENATE 'MATNR =' '''xyz'''
                     INTO ls_options separated BY SPACE.

REPLACE 'xyz' WITH (your material number) INTO ls_options.

APPEND ls_options TO lt_options.

REFRESH lt_fields.

CLEAR ls_field.
ls_field-fieldname  = 'DISPR'.
APPEND ls_field TO lt_fields.

CALL FUNCTION 'META_READ_TABLE'
  EXPORTING
  query_table    = 'MDMA'
    logical_system = w_logsys
  TABLES
    options        = lt_options       "/ 'where' clause
    fields         = lt_fields        "/ fieldnames input and output
    data           = lt_datas_mdma    "/ output data
    control_record = lt_control_record.

Then, read table lt_datas_mdma to get field value.

In lt_fields put all fields you need.

Regards.

Laurent.

[Former Member · Accepted solution]

Hi Laurent,

Please let me know how to the BADI implementation of BBP_SC_TRANSFER_BE to set the number range for the consignment order.

Regards,

Venkat

[former_member183819 · Accepted solution]

Hi venkat

Hope you might be in classic. you have to determine what document type must be createdfor this SRM shopping card data .

The end user determines what type of docuemnt must be created in the back end since consignment order is not created SAP SRM standard configurations.

if the desired document type is created in ECC and it is directly linked with no range .

hope you understand.

[laurent_burtaire]

Hello Venkat,

Special procurement type is field SOBSL from table MARC.

Regards.

Laurent.

[Former Member]

Hi Laurent,

Please let me know the RFC FM name to get the Material master details from ECC.

Regards,

Venkat

[laurent_burtaire]

Hi,

I wrote it.

Regards.

Lauent.

[Former Member]

sorry

[laurent_burtaire]

Hello Venkat,

Just one precision for table MARC used with the function module.

As MARC has two table keys, for lt_options concatenation, you have to add WERKS:

CONCATENATE 'MATNR =' '''xyz''' 'AND' 'WERKS =' '''abc'''
                     INTO ls_options separated BY SPACE.

Then, replace 'abc' with your plant value.

Regards.

Laurent.