on 09-19-2007 1:04 PM
i have a SD report where i have to restrict my op based on product hierachy entered in th selection screen,however my selection flow is as follows .I first select all t materials from mara and for the sales org and distribution channel . I also check for the billing date..if i give equal to the product hierachy then i get t right op however if i give a greater than equal to or less than equal to my op does nt come right.If u chk mara table u ll see that product hier is maintained in diff levels .The kind of logic used in mara is wat i want to implement in code...How do i do it? Pls suggest...
I would like to clarify that if i enter greater than some product hierachy say HM then i shud be getting the value of HM and HMTGT HMIPS as maintained for the material for the salesorg and distribution channel.How do i write this as code?If u click on the PRDHA field of mara and give an F4 you ll understand as to how the next levels are given.Pls analyze
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I would put it this way for better understandig.If i enter greater than or equal to HM in product hierachy in the selection screen it should display me the next levels of HM ie HMHGT ,HMGTIPS and so on as maintained for the material.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I think you are using select-option for selection screen right.
if so why should you use equal or less or greater .
what i mean is use for eg:
select * from mara where <field> in <select-option>
thanks
Arun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
product hierarchy is from VBAP-PRODH,
get it based on vbeln
Regards
Shiva
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
103 | |
12 | |
11 | |
6 | |
5 | |
4 | |
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.