Export to Crystal

Production > Work order general > WO structure > WO post-calculation > Export to Crystal

Top  Previous  Next

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 print them with Crystal.

 

With the command

object=ue_fert_naka=export_naka_soll_ist

you can 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.

 

Available columns:

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


Help URL: https://help.beascloud.com/beas202402/index.html?export_in_crystal.htm