Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from suresh2989 on Mar 22 at 3:13 AM 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: Tuesday, March 19, 2013 6:06 AM
Subject: Component Quantity Field While Printing (smartforms) fetches '0.00' Values
Component quantity field while printing (smartforms) keeps fetching "0.00" values for the same material number along with required values of the same material number.
The thing is I have two fields getting printed in print preview, both the fields belong to the same Material, one such value is needed value like "220 kg" ..it is immediately followed by
same material's null value, which according to the requirements is not needed.i narrowed down to the field and gave it as menge is not null in the where condition, but it ain't working, is there any easy way to do that by meddling with smartforms ....or is there any other way at all ...thanks all :-) |
| Reply to this email to post your response. __.____._ |   _.____.__ |
