Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from Zeeccz on Mar 24 at 3:33 AM Sorry, I didn't understand your question clearly,
I think you can
loop at it_components1_temp.
select you require fields from stpo
appending to table it_stpo where your conditions.
do some logic here to achieve your requirement
endloop.
2013/3/22, suresh2989 email@removed:
>
>
> Thanks for your replies, i should have made my question clear, it is not a
> smartform issue anymore. developer who worked prior to me have used a table
> stpo which contains all the details and cross referenced it with a structure
> name Bapi_order_component ...which as the name suggests is sap std...and it
> does not contain field Menge which has the component quantity...
>
> if it_components1_temp is not initial.
> select stlty "BOM category
> stlnr "Bill of material
> stlkn "BOM item node number
> stpoz "Internal counter
> aedat "Changed On
> idnrk "BOM component
> posnr "BOM Item Number
> menge "Component quantity
> potx1 "BOM Item Text (Line 1)
> potx2 "BOM item text (line 2)
> from stpo
> into table it_stpo
> for all entries in it_components1_temp
> where stlty = 'M'
> and stlnr in r_stlnr[]
> and posnr = it_components1_temp-item_number.
> endif.
> endif.
>
> the internal table it_components1_temp is created by ref to
> bapi_order_component, but the requirement suggest that i remove the zeros
> that get printed because of menge values being '0'.
>
> ...what are my options
> 1.remove for all entries and use
> inner join?
> left outer join?
> but what are the prerequisites to use join condition?
>
> your inputs are highly valued, and i appreciate you parting with your
> valuable time to give solutions.
> Thank you.
>
| | | ---------------Original Message---------------
From: suresh2989
Sent: Friday, March 22, 2013 3:13 AM
Subject: Component Quantity Field While Printing (smartforms) fetches '0.00' Values
Thanks for your replies, i should have made my question clear, it is not a smartform issue anymore. developer who worked prior to me have used a table stpo which contains all the details and cross referenced it with a structure name Bapi_order_component ...which as the name suggests is sap std...and it does not contain field Menge which has the component quantity...
if it_components1_temp is not initial.
select stlty "BOM category
stlnr "Bill of material
stlkn "BOM item node number
stpoz "Internal counter
aedat "Changed On
idnrk "BOM component
posnr "BOM Item Number
menge "Component quantity
potx1 "BOM Item Text (Line 1)
potx2 "BOM item text (line 2)
from stpo
into table it_stpo
for all entries in it_components1_temp
where stlty = 'M'
and stlnr in r_stlnr[]
and posnr = it_components1_temp-item_number.
endif.
endif.
the internal table it_components1_temp is created by ref to bapi_order_component, but the requirement suggest that i remove the zeros that get printed because of menge values being '0'.
...what are my options
1.remove for all entries and use
inner join?
left outer join?
but what are the prerequisites to use join condition?
your inputs are highly valued, and i appreciate you parting with your valuable time to give solutions.
Thank you. |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
