on 02-23-2007 4:34 AM
Hi frnds,
I Hav a functioanl issue plzz help me in understanding this issue.
" to read the bill of materials and their components if any of them are delivery blocks "
wht is the functional need of this. plzz explain.
thnking u all.
regards,
satya
hi
first u check your ( Wich type schedule line category ) schedule line category, one delivry block is there in <b>VOV6</b>
and then check your item categoty detetmination.<b> VOV4.</b>
Rewards point it helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Any help frnds.
regards,
satya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
<b>wht is use of deletion flag</b> - Delete the particular records for customer master data
.<b>difference between deletion flag and delivery block.</b>
<b>deletion flag</b> : Delete the particular records for customer master data.again we can not use it.
<b>delivery block</b> : Temparory blocking,again we can use it..
Rewards point it helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
LAKSHMANAN.
thank u for ur reply.
Actually deletion flag is stored in the database tables as a value or what.
Is that higighted part u mean to say we do.
TABLES:
mara, "Material Master Table
mast, "Material to BOM Link
mvke, "Sales Data fr Material
stko, "BOM Header
stpo, "BOM Item
tvmst. "Materials:SD Status
************************************************************************
*SELECT-OPTIONS declarations
************************************************************************
SELECT-OPTIONS: s_plant FOR mast-werks, "Plant Number
s_sorg FOR mvke-vkorg, "Sales Organization
s_dchan FOR mvke-vtweg. "Distribution Channel
************************************************************************
*Internal Table Declarations
************************************************************************
*Itab to hold data from MVKE table
DATA: BEGIN OF itab OCCURS 0,
matnr LIKE mara-matnr,
vkorg LIKE mvke-vkorg,
vtweg LIKE mvke-vtweg,
vmsta LIKE mvke-vmsta,
vmstb LIKE tvmst-vmstb,
END OF itab.
*Itab to hold Material No,BOM Header
DATA: BEGIN OF itab2 OCCURS 0,
matnr LIKE mara-matnr,
stlnr LIKE mast-stlnr,
END OF itab2.
*Itab to hold BOM header & BOM Component
DATA: BEGIN OF itab3 OCCURS 0,
stlnr LIKE mast-stlnr,
idnrk LIKE stpo-idnrk,
END OF itab3.
*Itab to hold Material No & It's Component
DATA: BEGIN OF itab4 OCCURS 0,
matnr LIKE mara-matnr,
idnrk LIKE stpo-idnrk,
END OF itab4.
*Itab to hold Status and its Description
DATA: BEGIN OF itab5 OCCURS 0,
vmsta LIKE mvke-vmsta,
vmstb LIKE tvmst-vmstb,
END OF itab5.
*Final Itab used to output list
DATA: BEGIN OF ftab OCCURS 0,
matnr LIKE mara-matnr,
idnrk LIKE stpo-idnrk,
vkorg LIKE mvke-vkorg,
vtweg LIKE mvke-vtweg,
vmsta LIKE mvke-vmsta,
vmstb LIKE tvmst-vmstb,
END OF ftab.
*Workarea Declaration
DATA: wa LIKE LINE OF ftab,
wa_plant LIKE marc-werks,
wa_org LIKE mvke-vkorg,
wa_chan LIKE mvke-vtweg,
flag type i
.
************************************************************************
*Initialization event
************************************************************************
INITIALIZATION.
************************************************************************
*At-selection-screen event
************************************************************************
AT SELECTION-SCREEN.
SELECT SINGLE werks FROM marc INTO wa_plant WHERE werks IN s_plant.
IF sy-subrc <> 0.
MESSAGE e051.
ENDIF.
SELECT SINGLE vkorg FROM mvke INTO wa_org WHERE vkorg IN s_sorg.
IF sy-subrc <> 0.
MESSAGE e052.
ENDIF.
SELECT SINGLE vtweg FROM mvke INTO wa_chan WHERE vtweg IN s_dchan.
IF sy-subrc <> 0.
MESSAGE e053.
ENDIF.
***********************************************************************
*START-OF-SELECTION EVENT
***********************************************************************
START-OF-SELECTION.
PERFORM get_data.
************************************************************************
*END-OF-SELECTION EVENT
************************************************************************
END-OF-SELECTION.
*To output List
if flag <> 1.
WRITE:/ 'BOM-Header'(001),20 'BOM-Item'(002),42 'SalesOrg.'(003),
54 'DC'(004),58 'Status'(005),68 'description'(006).
ULINE.
endif.
LOOP AT ftab.
wa = ftab.
AT NEW matnr.
WRITE:/ wa-matnr.
ENDAT.
WRITE:/20 ftab-idnrk,44 ftab-vkorg,54 ftab-vtweg
,60 ftab-vmsta,64 ftab-vmstb.
AT END OF matnr.
ULINE.
ENDAT.
ENDLOOP.
----
Form get_data
*----
To fetch data from Database into InternalTables
----
FORM get_data.
*To get data from MVKE into table ITAB
SELECT matnr vkorg vtweg vmsta FROM mvke INTO TABLE itab
WHERE vkorg IN s_sorg AND vtweg IN s_dchan
AND vmsta <> 99.
PERFORM check.
*To get Material and BOM from MAST into ITAB2
IF NOT itab[] IS INITIAL.
SELECT matnr stlnr FROM mast INTO TABLE itab2
FOR ALL ENTRIES IN itab
WHERE matnr = itab-matnr
AND werks IN s_plant.
PERFORM check.
ELSE.
WRITE:/ 'No Data'.
flag = 1.
STOP.
ENDIF.
*To get BOM and BOM component into ITAB3
IF NOT itab2[] IS INITIAL.
SELECT stlnr idnrk FROM stpo INTO TABLE itab3
FOR ALL ENTRIES IN itab2
WHERE stlnr = itab2-stlnr
AND stlty = 'M'.
PERFORM check.
ELSE.
WRITE:/ 'No Data'.
flag = 1.
STOP.
ENDIF.
*To join ITAB2 and ITAB3 into ITAB4
LOOP AT itab2.
itab4-matnr = itab2-matnr.
LOOP AT itab3 WHERE stlnr = itab2-stlnr.
itab4-idnrk = itab3-idnrk.
APPEND itab4.
CLEAR:itab3,itab4-idnrk.
ENDLOOP.
CLEAR:itab2,itab4.
ENDLOOP."
*To delete adjacent duplicates from ITAB4
SORT itab4 BY matnr idnrk.
<b>
DELETE ADJACENT DUPLICATES FROM itab4.</b>
*To get Status and it's Description into ITAB5
SELECT vmsta vmstb FROM tvmst INTO TABLE itab5
WHERE spras = 'E'.
PERFORM check.
*To add Description to ITAB status
LOOP AT itab.
READ TABLE itab5 WITH KEY vmsta = itab-vmsta.
IF sy-subrc = 0.
itab-vmstb = itab5-vmstb.
ENDIF.
MODIFY itab TRANSPORTING vmstb.
ENDLOOP.
*To join ITAB and ITAB4 into final table FTAB
LOOP AT itab.
MOVE-CORRESPONDING itab TO ftab.
LOOP AT itab4 WHERE matnr = itab-matnr.
ftab-idnrk = itab4-idnrk.
APPEND ftab.
CLEAR: itab4,ftab-idnrk.
ENDLOOP.
CLEAR: itab,ftab.
ENDLOOP.
ENDFORM. " get_data
----
FORM check *
----
To check SY-SUBRC after Select Statement
----
FORM check.
IF sy-subrc <> 0.
WRITE:/ 'No Data'.
flag = 1.
STOP.
ENDIF.
ENDFORM.
regards,
satya
Hi All,
Thanks for Replying me.
Actually i m using tables for this functionality is
mara, "Material Master Table
mast, "Material to BOM Link
mvke, "Sales Data fr Material
stko, "BOM Header
stpo, "BOM Item
tvmst. "Materials:SD Status
Frnds can any help how to check delivery block in this.
looking for ur help.
thank u all.
regards,
satya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
All the tables you have referred here are: sort of master data tables. They can have deletion flags attached to it rather than delivery block.
Pls verify whether you need to be checking delivery block or deletion flag. Especially, for BOM - header - STKO table has deletion flag field.
Hope, this helps!
Thanks
Siva
HI TO ALL
i want functional spec wich was already used actually i want the format of the functional speck and send me one speck and hw can i give he functional speck to the technical people give me a breif and wt is functional speck
send to my id srinivaskadali2007@rediff.com
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Satya,
Bill of Material is nothing but Structured group of material required to make a complete Product.
We create BOM in Tcoe. CS01. But we use BOm which we created in CS01 for creating sales orders using some document type, and we need to find out if any of these materials/items have a delivery block, reason could be anything like Credit block etc.And this block as I understand from you posting as not a header block.
And this can be done using VBEP- LIFSP. This is delievry block at schedule lines. Credit Block will be a Header block VBRK-LIFSK (HEADER BLOCK- due to credit block).
It would be more appropriate if you mention as to what you really want when you mean by functionality with regards to SD-BOM.
REWARD POINTS IF IT HELPS
Regards
Srini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
first u check your schedule line category, one delivry block is there.
and then check your item categoty detetmination. VOV4.
Rewards point it helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.