topic Re: FINDING THE BOM PARENT NODE in Application Development and Automation Discussions

FINDING THE BOM PARENT NODE

Former Member — Fri, 25 May 2007 08:40:24 GMT

HAI ALL,

For the sub-level or line item, I want to find the root node or header item in BOM.

IS there any FM or By linking any tables can do that . Its very urgent.

Thanks in Advance.

senthil

Re: FINDING THE BOM PARENT NODE

Former Member — Fri, 25 May 2007 08:54:43 GMT

no , u cannt fine in this way bcos

say RM1.

FG 1

RM1

RM2

RM3.

FG2

RM4

Rm1.

so in this case u will get 2 header Materials for one RM1, if its ok , then check MAST+STPO on IDNRK.

Regards

Peram

Re: FINDING THE BOM PARENT NODE

Former Member — Fri, 25 May 2007 08:59:31 GMT

Check the fun module

OLR3_DMS_RFC_GET_PARENT_BOMS

or use the tables MAST,STKO and STPO.

Reward points if useful

Regards

Anji

Re: FINDING THE BOM PARENT NODE

Former Member — Fri, 25 May 2007 09:01:16 GMT

YOU CAN USE FM CS_WHERE_USED_MAT.

REGARDS

SHIBA DUTTA

Re: FINDING THE BOM PARENT NODE

sreeramkumar_madisetty — Fri, 25 May 2007 09:01:34 GMT

Try the FM:

<b>PLM_FUNCLOCAT_GET_BOMS</b>

Regards,

Sreeram

Re: FINDING THE BOM PARENT NODE

Former Member — Fri, 01 Jun 2007 05:44:09 GMT

HAI,

THANK YOU FOR YOUR HELP.

PL. TELL ME THAT WHAT ARE THE VALUES TO BE SUPPLIED TO THE FM PARAMETERS. FROM WHICH TABLE I CAN GET FOR MY SEMIFINISHED ITEM OR LINE ITEM.

OR TELL ME EXACT SOLUTION FOR MY PROBLEM. ITS URGENT.

THANKS IN ADVANCE.

SENTHIL.S

Re: FINDING THE BOM PARENT NODE

Former Member — Fri, 01 Jun 2007 05:44:41 GMT

HAI,

THANK YOU FOR YOUR HELP.

PL. TELL ME THAT WHAT ARE THE VALUES TO BE SUPPLIED TO THE FM PARAMETERS. FROM WHICH TABLE I CAN GET FOR MY SEMIFINISHED ITEM OR LINE ITEM.

OR TELL ME EXACT SOLUTION FOR MY PROBLEM. ITS URGENT.

THANKS IN ADVANCE.

SENTHIL.S

Re: FINDING THE BOM PARENT NODE

Former Member — Fri, 01 Jun 2007 05:45:50 GMT

HAI,

THANK YOU FOR YOUR HELP.

PL. TELL ME THAT WHAT ARE THE VALUES TO BE SUPPLIED TO THE FM PARAMETERS. FROM WHICH TABLE I CAN GET FOR MY SEMIFINISHED ITEM OR LINE ITEM.

OR TELL ME EXACT SOLUTION FOR MY PROBLEM. ITS URGENT.

THANKS IN ADVANCE.

SENTHIL.S

Re: FINDING THE BOM PARENT NODE

Former Member — Fri, 01 Jun 2007 06:05:09 GMT


DATA : IWULTB LIKE STPOV OCCURS 0 WITH HEADER LINE,
       IEQUICAT LIKE CSCEQUI OCCURS 0 WITH HEADER LINE,
       IKNDCAT  LIKE CSCKND OCCURS 0 WITH HEADER LINE,
       IMATCAT LIKE CSCMAT OCCURS 0 WITH HEADER LINE,
       ISTDCAT LIKE CSCSTD OCCURS 0 WITH HEADER LINE,
       ITPLCAT LIKE CSCTPL OCCURS 0 WITH HEADER LINE.
CALL FUNCTION 'CS_WHERE_USED_MAT'
  EXPORTING
    DATUB                            = SY-DATUM
    DATUV                            = SY-DATUM
    MATNR                            = P_MATNR  "MATERIAL NO
*   POSTP                            = ' '
*   RETCODE_ONLY                     = ' '
*   STLAN                            = ' '
   WERKS                            = '1000'
*   MCLMT                            = ' '
*   MNSTL                            = ' '
*   MXSTL                            = ' '
*   STLTP                            = ' '
*   NEWSI                            = ' '
* IMPORTING
*   TOPMAT                           =
  TABLES
    WULTB                            = IWULTB
    EQUICAT                          = IEQUICAT 
    KNDCAT                           = IKNDCAT
    MATCAT                           = IMATCAT
    STDCAT                           = ISTDCAT
    TPLCAT                           = ITPLCAT
*   PRJCAT                           =
* EXCEPTIONS
*   CALL_INVALID                     = 1
*   MATERIAL_NOT_FOUND               = 2
*   NO_WHERE_USED_REC_FOUND          = 3
*   NO_WHERE_USED_REC_SELECTED       = 4
*   NO_WHERE_USED_REC_VALID          = 5
*   OTHERS                           = 6
          .
IF SY-SUBRC <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

HERE CHECK THE TABLES IWULTB AND IMATCAT BY LOOPING.

REGARDS

SHIBA DUTTA

Re: FINDING THE BOM PARENT NODE

Former Member — Fri, 01 Jun 2007 10:05:11 GMT

HAI,

THANK YOU FOR UR REPLY. UR FM RETURNS THE NEXT LEVEL HEADER ITEM FOR THE LINE ITEM. I DON'T WANT THIS RESULT.

MY SCENARIO.

SAY, HEADER ITEM IS HEAD,

SUB ITEMS ARE S1, S2, S3, S4, S5.

IF I GIVE THE INPUT ANY ONE OF THE SUB ITEM, FM SHOULD BRING THE HEADER ITEM (THAT MEANS, HEAD).

SHOULD NOT USE LOOP. BECAUSE I GOT THE ANSWER USING LOOP WITHOUT USING FM.

THANKS IN ADVANCE.

SENTHIL.S