cancel
Showing results for 
Search instead for 
Did you mean: 

functionality

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (6)

Answers (6)

Former Member
0 Kudos

Any help frnds.

regards,

satya

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

HI Satya,

You are using all master tables and you can delivery blocks in transactional data also like in sales header and schedule lines Tables: VBAK & VBEP.

Reward if it helps

Regards

Srini

Former Member
0 Kudos

Hi frnds,

wht is use of deletion flag. Is there any difference between deletion flag and delivery block.

thanking u all.

regards,

satya

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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