I don´t regain the value of a field in Form of Article in new Field “ANCHO”
Answered
I create nine field in table OITM with Tools of Customizing:

This is my BeaSScript in artiket_edit.src:
windowevent postopen
//Datos Gaviplast
etab=addnewobject=stamm=object_name_t0=text=Datos Gaviplast=3500=10=350=56
dw_1.item.object_name_t0.bold=true
//1.Grosor
etab=addnewobject=stamm=object_name_t1=text=Grosor=3100=70=350=56
etab=addnewobject=stamm=object_name1=column=userfield1=3500=70=350=56
dw_1.item.object_name1.alignment=1
//etab=redraw
//2.Densidad
etab=addnewobject=stamm=object_name_t2=text=Densidad=3100=140=350=56
etab=addnewobject=stamm=object_name2=column=userfield2=3500=140=350=56
dw_1.item.object_name2.alignment=1
//3.Viscosidad
etab=addnewobject=stamm=object_name_t3=text=Viscosidad=3100=210=350=56
etab=addnewobject=stamm=object_name3=column=userfield3=3500=210=350=56
dw_1.item.object_name3.alignment=1
//4.Gr/m2 Adh
etab=addnewobject=stamm=object_name_t4=text=Gr_m2 Adh=3100=280=350=56
etab=addnewobject=stamm=object_name4=column=userfield4=3500=280=350=56
dw_1.item.object_name4.alignment=1
//5.Superficie - Campo Ancho de SAP (BWidth1)
etab=addnewobject=stamm=object_name_t5=text=Ancho=3100=350=350=56
etab=addnewobject=stamm=object_name5=column=userfield5=3500=350=350=56
dw_1.item.object_name5.alignment=1
//6.Superficie - Campo Alto de SAP (BLength1)
etab=addnewobject=stamm=object_name_t6=text=Alto=3100=420=350=56
etab=addnewobject=stamm=object_name6=column=userfield6=3500=420=350=56
dw_1.item.object_name6.alignment=1
//7.Superficie (Resultado de 5*6) si esta en blanco
etab=addnewobject=stamm=object_name_t7=text=Superficie=3100=490=350=56
etab=addnewobject=stamm=object_name7=column=userfield7=3500=490=350=56
dw_1.item.object_name7.alignment=1
//8.Ancho Bolsa
etab=addnewobject=stamm=object_name_t8=text=Ancho Bolsa=3100=560=350=56
etab=addnewobject=stamm=object_name8=column=userfield8=3500=560=350=56
dw_1.item.object_name8.alignment=1
//9.Alto Cliente
etab=addnewobject=stamm=object_name_t9=text=Alto Cliente=3100=630=350=56
etab=addnewobject=stamm=object_name9=column=userfield9=3500=630=350=56
dw_1.item.object_name9.alignment=1
//SQL
select "U_IFG_GPLASGROSOR","U_IFG_GPLASDENSIDAD","U_IFG_GPLASVISCOSIDA", &
"U_IFG_GPLASGRM2ADH","U_IFG_GPLASANCHO","U_IFG_GPLASALTO", &
"U_IFG_GPLASSUPERFICI","U_IFG_GPLASANCHOBOLS","U_IFG_GPLASALTOCLIEN" &
from "OITM" where "ItemCode"=N'<dw_1.item.itemcode.value>'
dw_1.item.object_name1.value=<wert1,#,##0.000>
dw_1.item.object_name2.value=<wert2,#,##0.000>
dw_1.item.object_name3.value=<wert3,#,##0.000>
dw_1.item.object_name4.value=<wert4,#,##0.000>
dw_1.item.object_name5.value=<wert5,#.##0.000>
dw_1.item.object_name6.value=<wert6,#,##0.000>
dw_1.item.object_name7.value=<wert7,#,##0.000>
dw_1.item.object_name8.value=<wert8,#,##0.000>
dw_1.item.object_name9.value=<wert9,#,##0.000>
dw_1.item.object_name1.tabsequence=521
dw_1.item.object_name2.tabsequence=522
dw_1.item.object_name3.tabsequence=523
dw_1.item.object_name4.tabsequence=524
dw_1.item.object_name5.tabsequence=525
dw_1.item.object_name6.tabsequence=526
dw_1.item.object_name7.tabsequence=527
dw_1.item.object_name8.tabsequence=528
dw_1.item.object_name9.tabsequence=529
end event
windowevent itemchange dw_1.item.object_name5
calculate()
end event
windowevent itemchange dw_1.item.object_name6
calculate()
end event
//--------------------------------------------------------------------------------------------------------------------
// ACTUALIZACION
//--------------------------------------------------------------------------------------------------------------------
windowevent update
//SQL Actualización Campos Cabecera
sql=update "OITM" &
set "U_IFG_GPLASGROSOR"=<dw_1.item.userfield1.value,dbnum>, &
"U_IFG_GPLASDENSIDAD"=<dw_1.item.userfield2.value,dbnum>, &
"U_IFG_GPLASVISCOSIDA"=<dw_1.item.userfield3.value,dbnum>, &
"U_IFG_GPLASGRM2ADH"=<dw_1.item.userfield4.value,dbnum>, &
"U_IFG_GPLASANCHO"=<dw_1.item.userfield5.value,dbnum>, &
"U_IFG_GPLASALTO"=<dw_1.item.userfield6.value,dbnum>, &
"U_IFG_GPLASSUPERFICI"=<dw_1.item.userfield7.value,dbnum>, &
"U_IFG_GPLASANCHOBOLS"=<dw_1.item.userfield8.value,dbnum>, &
"U_IFG_GPLASALTOCLIEN"=<dw_1.item.userfield9.value,dbnum> &
where "itemcode" = N'<dw_1.item.itemcode.value>'
end event
global function calculate
end global
// ---------------------------
The script write all values in the new fields of OITM but the script don´t Paint the values the field userfield5 (U_IFG_GPLASANCHO) in the form.
Can you help me?
Than you.
-
Official comment
Hello Salvador,
For more specific questions like this one, please contact you SAPB1 partner. They should analize the coding and provide you the best answer. Please consider that this kind of advanced questions involve time from our developers and is consider Premium Service. Thank you so much for your understanding.
Please sign in to leave a comment.
Comments
1 comment