|
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
Default variablen: str_parm.s_parm1 = Artikelnummer
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
id
|
unique ID
|
nr
|
continuous number
|
art
|
row type 50=BOM
|
level
|
Structure level
|
pos
|
Bill of materials (BoM) position
|
baugruppe
|
Item number of assembly
|
itemcode
|
Item number of BoM position
|
itemname
|
Item description in BoM position
|
znr
|
Drawing number in BoM position
|
menge_verbrauch_soll
|
Requirement quantity per 1 assembly of the upper level in consumption units, without consideration of scrap
|
menge_verbrauch_ist
|
Single quantity in consumption units without consideration of scrap
|
oberbaugruppe
|
Item number for first level assembly (also: str_parm.s_parm1)
|
Routing
id
|
unique ID
|
nr
|
continuous number
|
art
|
row type 52=routing
|
level
|
Structure level
|
pos
|
routing position
|
baugruppe
|
Item number of assembly
|
zeit_tr
|
Setup time (BEAS_APL.TRAPLATZ)
|
zeit_te
|
Mach+Labor Time/unit (main work time from BEAS_APL.TEAPLATZ)
|
zeit_soll
|
Total time per 1 assembly of the upper level in consumption units, without consideration of scrap
|
nutzen
|
Use factor
|
anzhal
|
Number factor
|
ag_id
|
Catalog number
|
itemname
|
Activity (first 100 letters)
|
aplatz_id
|
Resource
|
agtyp
|
Operation type
|
oberbaugruppe
|
Item number assembly first level (str_parm.s_parm1)
|
back to APIs
Help URL: https://help.beascloud.com/beas202402/index.html?itemstruktur.htm
|