itemstructureAdministration > System Initialization > Report settings > APIs > itemstructure |
Top
Previous
Next
|
This API is only available in "Lists master data" and generates a structure display of the selected item in the "BEAS_REPORTAUSWERTUNG"
It can be called up manually setstr=art_id=<itemcode> object=ue_artikelstamm=strukturexport
Parameters: no Output: Return Item structure in table BEAS_REPORTAUSWERTUNG Variable "id" referring to BEAS_REPORTAUSWERTUNG.ID
Example: Export item structure to Excel setstr=art_id=781-a object=ue_artikelstamm=strukturexport declare=lds=ue_datastorevalues lds=select "BAUGRUPPE"||'' as assembly,"POS","ItemCode","ItemName","LEVEL","MENGE_VERBRAUCH_SOLL"+0.0000 as quantity from "BEAS_REPORTAUSWERTUNG" where "ID"=<id> and "ART"=50 order by "NR" lds=saveas=excel=c:\temp\myresult.xls destroy=lds sql=delete from "BEAS_REPORTAUSWERTUNG" where "ID"=<id>
Result in table BEAS_REPORTAUSWERTUNG
BOM rows
Routing
back to APIs |