Production Work order general WO structure WO post calculation Export to Crystal - robinfeng/beashelp GitHub Wiki
导出至水晶报表
Navigation: Production > Work order general > WO structure > WO post-calculation: Export to Crystal No contents entries on this page Contents No Crystal report is supplied as standard for the structure view of the product costing analysis, as beas offers the standard export functions using Excel.
The structure view of the product costing analysis is not saved, so direct output via Crystal is not possible. However it is possible to cache the contents of a table and then print these out with Crystal.
With the command object=ue_fert_naka=export_naka_soll_ist can be used to export the current structure view. This is then available in the table beas_reportauswertung . As a parameter, the following variable can used :"id". The export function can also be abused in order to use the result in other ways. Important: The table beas_reportauswertung is only temporary. The entries are promptly removed automatically. Only a limited selection of fields are exported.
The following columns are available:
Column Description id ID No. Serial number, sort order Item type of entry 2 = Overhead (lower total) 50 = Item line 52 = Routing position, parallel routing position 100 = Time report 101 = Material posting Doc. no. id Document No Doc pos Assembly position pos_id Bill of materials / routing position itemcode Item itemname Item Description Drw.No. Drawing Number quantity_consumption_is Reported quantity quantity_consumption_planned planned quantity costs_actual_oh Individual costs at marginal costs costs_actual_sp Individual costs at full costs costs_planned_oh Planned individual costs at marginal costs costs_planned_sp Planned individual costs at full costs materialcosts_actual_oh Material costs at marginal costs materialcosts_actual_fc Material costs at full costs materialcost_planned_oh Planned material costs at marginal costs materialcosts_planned_fc Planned material costs at full costs productioncosts_actual_mc Production costs at marginal costs productioncosts_actual_fc Production at full costs productioncosts_planned_mc Planned production costs at marginal costs productioncosts_planned_fc Planned production at full costs productioncosts_actual_mc Production costs at marginal costs productioncosts_actual_fc Production costs at full costs productionscosts_planned_tc Planned production costs at marginal costs productioncosts_planned_fc Planned production costs at full costs op_id Operation ID aplatz_id Resource ID Description Description of routing position Number Work steps Use Utility factor time_actual Previously required time in minutes time planned planned time Empl ID Personnel number for reported time pers_name Name of personnel overheadtext Text for overhead overheadinfo_tc Overhead - surcharge information at marginal costs overheadinfor_fc Overhead - surcharge information at full costs
返回 主页