‎2007 May 25 9:40 AM
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
‎2007 May 25 9:54 AM
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
‎2007 May 25 9:54 AM
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
‎2007 May 25 9:59 AM
Hi
Check the fun module
OLR3_DMS_RFC_GET_PARENT_BOMS
or use the tables MAST,STKO and STPO.
Reward points if useful
Regards
Anji
‎2007 Jun 01 6:44 AM
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
‎2007 May 25 10:01 AM
‎2007 Jun 01 6:45 AM
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
‎2007 May 25 10:01 AM
‎2007 Jun 01 6:44 AM
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
‎2007 Jun 01 7:05 AM
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
‎2007 Jun 01 11:05 AM
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