topic Re: Get Material Determination in Application Development and Automation Discussions

Get Material Determination

Former Member — Fri, 02 Nov 2007 18:36:02 GMT

Hi experts,

Does anyone know a FM or BAPI to get the material determination? for instance, I have a GENERIC BOM Material but I need to retrieve its component material level.

1000000401 - GENERIC BOM

-> 1000000560 - Component Level Material.

Thanks in advance,

Carlos

Re: Get Material Determination

Former Member — Fri, 02 Nov 2007 18:39:54 GMT

Use the Tables

<b>MAST,STKO and STPO</b> and write the code to retrive all BOM items

Regards

Anji

Re: Get Material Determination

Former Member — Fri, 02 Nov 2007 18:40:18 GMT

Hi,

Please check FM CS_WHERE_USED_MAT.

Regards,

Ferry Lianto

Re: Get Material Determination

Former Member — Fri, 02 Nov 2007 19:06:07 GMT

BAPI_MATERIAL_GET_DETAIL

EPORT Z_BIT400_SRFC.

PARAMETERS: L_ID(18) DEFAULT 'p-100',

PA_DEST TYPE RFCDES-RFCDEST.

DATA: L_MAT_GEN_DATA TYPE BAPIMATDOA, MESS_TEXT(200).

INITIALIZATION.

Set Destination group specific

DATA H_FDPOS LIKE SY-FDPOS.

IF SY-UNAME CA '-'.

H_FDPOS = SY-FDPOS + 1.

CONCATENATE 'BIT400DEST' SY-UNAME+H_FDPOS(2) INTO PA_DEST.

ELSE.

PA_DEST = 'BIT400XX'.

ENDIF.

START-OF-SELECTION.

CALL FUNCTION 'BAPI_MATERIAL_GET_DETAIL'

DESTINATION PA_DEST

EXPORTING

MATERIAL = L_ID

IMPORTING

MATERIAL_GENERAL_DATA = L_MAT_GEN_DATA

EXCEPTIONS

SYSTEM_FAILURE = 2 MESSAGE MESS_TEXT

COMMUNICATION_FAILURE = 3 MESSAGE MESS_TEXT

OTHERS = 4.

CASE SY-SUBRC.

WHEN 0.

WRITE: / L_MAT_GEN_DATA-MATL_DESC,

L_MAT_GEN_DATA-MATL_TYPE,

L_MAT_GEN_DATA-IND_SECTOR,

L_MAT_GEN_DATA-MATL_GROUP,

L_MAT_GEN_DATA-IND_SECTOR,

L_MAT_GEN_DATA-UNIT_OF_WT.

WHEN 2. WRITE: 'System failure: ' COLOR 6, MESS_TEXT.

WHEN 3. WRITE: 'Communication-failure: ' COLOR 6, MESS_TEXT.

WHEN 4. WRITE: 'Error Others' COLOR 6.

ENDCASE.

reward points if helpful

Re: Get Material Determination

Former Member — Fri, 02 Nov 2007 19:19:01 GMT

suguna, your BAPI_MATERIAL_GET_DETAIL only fetch the detail but it does not fetch the BOM explosion

Re: Get Material Determination

Former Member — Fri, 02 Nov 2007 19:21:18 GMT

Hi,

Please try FM CS_BOM_EXPL_MAT_V2.

Regards,

Ferry Lianto