Administration System initialization Report settings APIs itemstructure - robinfeng/beashelp GitHub Wiki

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= 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"= and "ART"=50 order by "NR" lds=saveas=excel=c:\temp\myresult.xls destroy=lds sql=delete from "BEAS_REPORTAUSWERTUNG" where "ID"=

Result in tabel BEAS_REPORTAUSWERTUNG

BOM rows id unique ID nr continuous number art row type 50=BOM level Structure level pos BOM position baugruppe Item number of assembly itemcode Item number of BOM position itemname Item designation 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 Artikelnummer Baugruppe der ersten Stufe (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

返回 主页