As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.
Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.
Read-Only TopicGo
Search
Notify
Admin
New PM!
Platinum Member posted September 18, 2014 04:10 PM
I got this error and VIAUFKST_GSTRS is the date field. Anybody has this issue before and how did you solve it?
(FOC1426) DATA ELEMENT VALUE TOO BIG FOR SEGMENT/FIELD :
VIAUFKST/VIAUFKST_GSTRS
This message has been edited. Last edited by: <Kathryn Henning>, October 08, 2014 12:45 PM WebFOCUS 7.7.03 Windows, All Outputs
Virtuoso More information please, this error can have multiple resolutions.
What is causing this error? Please provide the mfd. This will aid people on the Forum to help you.
Alan. WF 7.705/8.007
Posts: 1451 | Location: Portugal | Registered: February 07, 2007
IP
Platinum Member Alan, this is the mas file:
FILENAME=VIAUFKS, SUFFIX=SQLSAP ,
REMARKS='Generated Table for View VIAUFKS', $
SEGMENT=VIAUFKS, SEGTYPE=S0, $
FIELDNAME=VIAUFKS_MANDT, ALIAS=MANDT, USAGE=A3, ACTUAL=A3,
TITLE='Client', DESCRIPTION='Client', $
FIELDNAME=VIAUFKS_AUFNR, ALIAS=AUFNR, USAGE=A12, ACTUAL=A12,
TITLE='Order', DESCRIPTION='Order Number', $
FIELDNAME=VIAUFKS_PRIOK, ALIAS=PRIOK, USAGE=A1, ACTUAL=A1,
TITLE='Priority', DESCRIPTION='Priority', $
FIELDNAME=VIAUFKS_EQUNR, ALIAS=EQUNR, USAGE=A18, ACTUAL=A18,
TITLE='Equipment', DESCRIPTION='Equipment number', $
FIELDNAME=VIAUFKS_BAUTL, ALIAS=BAUTL, USAGE=A18, ACTUAL=A18,
TITLE='Assembly', DESCRIPTION='Assembly', $
FIELDNAME=VIAUFKS_ANLZU, ALIAS=ANLZU, USAGE=A1, ACTUAL=A1,
TITLE='SystCond.', DESCRIPTION='System condition', $
FIELDNAME=VIAUFKS_IWERK, ALIAS=IWERK, USAGE=A4, ACTUAL=A4,
TITLE='Plng plant', DESCRIPTION='Maintenance Planning Plant', $
FIELDNAME=VIAUFKS_INGPR, ALIAS=INGPR, USAGE=A3, ACTUAL=A3,
TITLE='PlannerGrp', DESCRIPTION='Planner Group for Customer Service and Plant Maintenance', $
FIELDNAME=VIAUFKS_APGRP, ALIAS=APGRP, USAGE=A3, ACTUAL=A3,
TITLE='PlannerGrp', DESCRIPTION='Responsible planner group/department', $
FIELDNAME=VIAUFKS_GEWRK, ALIAS=GEWRK, USAGE=A8, ACTUAL=A8,
TITLE='Work ctr', DESCRIPTION='Object ID of the Work Center', $
FIELDNAME=VIAUFKS_KUNUM, ALIAS=KUNUM, USAGE=A10, ACTUAL=A10,
TITLE='Customer', DESCRIPTION='Customer Number', $
FIELDNAME=VIAUFKS_ANING, ALIAS=ANING, USAGE=A12, ACTUAL=A12,
TITLE='Pers.resp.', DESCRIPTION='Name of Person Reponsible for System', $
FIELDNAME=VIAUFKS_GAUEH, ALIAS=GAUEH, USAGE=A3, ACTUAL=A3,
TITLE='Unit', DESCRIPTION='Unit for Breakdown Duration', $
FIELDNAME=VIAUFKS_GAUZT, ALIAS=GAUZT, USAGE=D21.15E, ACTUAL=D8,
TITLE='Downtime/h', DESCRIPTION='Planned downtime in hours', $
FIELDNAME=VIAUFKS_ANLBD, ALIAS=ANLBD, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Avail. to', DESCRIPTION='Date until which the system is available', $
FIELDNAME=VIAUFKS_ANLVD, ALIAS=ANLVD, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Avail.from', DESCRIPTION='Date from which the system is available', $
FIELDNAME=VIAUFKS_ANLBZ, ALIAS=ANLBZ, USAGE=A6, ACTUAL=A6,
TITLE='Time', DESCRIPTION='Time until which the system is available', $
FIELDNAME=VIAUFKS_ANLVZ, ALIAS=ANLVZ, USAGE=A6, ACTUAL=A6,
TITLE='Time from', DESCRIPTION='Time from Which System is Available', $
FIELDNAME=VIAUFKS_WARPL, ALIAS=WARPL, USAGE=A12, ACTUAL=A12,
TITLE='MntPlan', DESCRIPTION='Maintenance plan', $
FIELDNAME=VIAUFKS_WAPOS, ALIAS=WAPOS, USAGE=A16, ACTUAL=A16,
TITLE='MntItem', DESCRIPTION='Maintenance item', $
FIELDNAME=VIAUFKS_REVNR, ALIAS=REVNR, USAGE=A8, ACTUAL=A8,
TITLE='Revision', DESCRIPTION='Revision for Plant Maintenance and Customer Service', $
FIELDNAME=VIAUFKS_ARTPR, ALIAS=ARTPR, USAGE=A2, ACTUAL=A2,
TITLE='PrioType', DESCRIPTION='Priority Type', $
FIELDNAME=VIAUFKS_ILOAN, ALIAS=ILOAN, USAGE=A12, ACTUAL=A12,
TITLE='Loc/Acc.', DESCRIPTION='Location and account assignment for technical object', $
FIELDNAME=VIAUFKS_ILOAI, ALIAS=ILOAI, USAGE=A1, ACTUAL=A1,
TITLE='ILOA ind.', DESCRIPTION='ILOA Individual', $
FIELDNAME=VIAUFKS_PM_OBJTY, ALIAS=PM_OBJTY, USAGE=A2, ACTUAL=A2,
TITLE='Type', DESCRIPTION='Object Type of CIM Resources for Work Center', $
FIELDNAME=VIAUFKS_INSPK, ALIAS=INSPK, USAGE=A12, ACTUAL=A12,
TITLE='TInspec by', DESCRIPTION='Name of Person Responsible for Technical Inspection', $
FIELDNAME=VIAUFKS_DATAN, ALIAS=DATAN, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='TInspec on', DESCRIPTION='Date of Technical Inspection', $
FIELDNAME=VIAUFKS_ABNUM, ALIAS=ABNUM, USAGE=I10, ACTUAL=I4,
TITLE='Call no.', DESCRIPTION='Maintenance plan call number', $
FIELDNAME=VIAUFKS_LAUFN, ALIAS=LAUFN, USAGE=A12, ACTUAL=A12,
TITLE='Last ord.', DESCRIPTION='Order number', $
FIELDNAME=VIAUFKS_OBKNR, ALIAS=OBKNR, USAGE=I10, ACTUAL=I4,
TITLE='ObListNo.', DESCRIPTION='Object list number', $
FIELDNAME=VIAUFKS_AUART, ALIAS=AUART, USAGE=A4, ACTUAL=A4,
TITLE='Order type', DESCRIPTION='Order type', $
FIELDNAME=VIAUFKS_AUTYP, ALIAS=AUTYP, USAGE=A2, ACTUAL=A2,
TITLE='Order catg', DESCRIPTION='Order category', $
FIELDNAME=VIAUFKS_ERNAM, ALIAS=ERNAM, USAGE=A12, ACTUAL=A12,
TITLE='Entered by', DESCRIPTION='Entered by', $
FIELDNAME=VIAUFKS_ERDAT, ALIAS=ERDAT, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='on', DESCRIPTION='Created on', $
FIELDNAME=VIAUFKS_AENAM, ALIAS=AENAM, USAGE=A12, ACTUAL=A12,
TITLE='Changed by', DESCRIPTION='User ID of person who made the last change', $
FIELDNAME=VIAUFKS_AEDAT, ALIAS=AEDAT, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Changed on', DESCRIPTION='Change date for Order Master', $
FIELDNAME=VIAUFKS_KTEXT, ALIAS=KTEXT, USAGE=A40, ACTUAL=A40,
TITLE='Short text', DESCRIPTION='Short text', $
FIELDNAME=VIAUFKS_LTEXT, ALIAS=LTEXT, USAGE=A1, ACTUAL=A1,
TITLE='Long text', DESCRIPTION='Indicator: "Long Text Exists"', $
FIELDNAME=VIAUFKS_BUKRS, ALIAS=BUKRS, USAGE=A4, ACTUAL=A4,
TITLE='CoCode', DESCRIPTION='Company Code', $
FIELDNAME=VIAUFKS_WERKS, ALIAS=WERKS, USAGE=A4, ACTUAL=A4,
TITLE='Plant', DESCRIPTION='Plant', $
FIELDNAME=VIAUFKS_GSBER, ALIAS=GSBER, USAGE=A4, ACTUAL=A4,
TITLE='Bus. area', DESCRIPTION='Business Area', $
FIELDNAME=VIAUFKS_KOKRS, ALIAS=KOKRS, USAGE=A4, ACTUAL=A4,
TITLE='CO area', DESCRIPTION='Controlling Area', $
FIELDNAME=VIAUFKS_CCKEY, ALIAS=CCKEY, USAGE=A23, ACTUAL=A23,
TITLE='Key', DESCRIPTION='Cost collector key', $
FIELDNAME=VIAUFKS_KOSTV, ALIAS=KOSTV, USAGE=A10, ACTUAL=A10,
TITLE='Resp. CCtr', DESCRIPTION='Responsible cost center', $
FIELDNAME=VIAUFKS_STORT, ALIAS=STORT, USAGE=A10, ACTUAL=A10,
TITLE='Location', DESCRIPTION='Location', $
FIELDNAME=VIAUFKS_SOWRK, ALIAS=SOWRK, USAGE=A4, ACTUAL=A4,
TITLE='Plant', DESCRIPTION='Location plant', $
FIELDNAME=VIAUFKS_ASTKZ, ALIAS=ASTKZ, USAGE=A1, ACTUAL=A1,
TITLE='Statist.', DESCRIPTION='Identifier for statistical order', $
FIELDNAME=VIAUFKS_WAERS, ALIAS=WAERS, USAGE=A5, ACTUAL=A5,
TITLE='Currency', DESCRIPTION='Order Currency', $
FIELDNAME=VIAUFKS_ASTNR, ALIAS=ASTNR, USAGE=A2, ACTUAL=A2,
TITLE='Status', DESCRIPTION='Order status', $
FIELDNAME=VIAUFKS_STDAT, ALIAS=STDAT, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Status chg', DESCRIPTION='Date of last status change', $
FIELDNAME=VIAUFKS_ESTNR, ALIAS=ESTNR, USAGE=A2, ACTUAL=A2,
TITLE='ReachdStat', DESCRIPTION='Status reached so far', $
FIELDNAME=VIAUFKS_PDAT1, ALIAS=PDAT1, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='PlnRelease', DESCRIPTION='Planned release date', $
FIELDNAME=VIAUFKS_PDAT2, ALIAS=PDAT2, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='PlnCompltn', DESCRIPTION='Planned completion date', $
FIELDNAME=VIAUFKS_PDAT3, ALIAS=PDAT3, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Pl.clo.dat', DESCRIPTION='Planned closing date', $
FIELDNAME=VIAUFKS_IDAT1, ALIAS=IDAT1, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Release', DESCRIPTION='Release date', $
FIELDNAME=VIAUFKS_IDAT2, ALIAS=IDAT2, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='TechCompl.', DESCRIPTION='Technical completion date', $
FIELDNAME=VIAUFKS_IDAT3, ALIAS=IDAT3, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Close', DESCRIPTION='Close date', $
FIELDNAME=VIAUFKS_OBJID, ALIAS=OBJID, USAGE=A1, ACTUAL=A1,
TITLE='Object ID', DESCRIPTION='Object ID', $
FIELDNAME=VIAUFKS_VOGRP, ALIAS=VOGRP, USAGE=A4, ACTUAL=A4,
TITLE='DisTranGrp', DESCRIPTION='Group of disallowed transactions', $
FIELDNAME=VIAUFKS_LOEKZ, ALIAS=LOEKZ, USAGE=A1, ACTUAL=A1,
TITLE='Del. flag', DESCRIPTION='Deletion flag', $
FIELDNAME=VIAUFKS_PLGKZ, ALIAS=PLGKZ, USAGE=A1, ACTUAL=A1,
TITLE='Plan LI', DESCRIPTION='Identifier for planning with line items', $
FIELDNAME=VIAUFKS_KVEWE, ALIAS=KVEWE, USAGE=A1, ACTUAL=A1,
TITLE='Usage', DESCRIPTION='Usage of the condition table', $
FIELDNAME=VIAUFKS_KAPPL, ALIAS=KAPPL, USAGE=A2, ACTUAL=A2,
TITLE='Applicat.', DESCRIPTION='Application', $
FIELDNAME=VIAUFKS_KALSM, ALIAS=KALSM, USAGE=A6, ACTUAL=A6,
TITLE='Cost.Sheet', DESCRIPTION='Costing sheet', $
FIELDNAME=VIAUFKS_ZSCHL, ALIAS=ZSCHL, USAGE=A6, ACTUAL=A6,
TITLE='OH key', DESCRIPTION='Overhead key', $
FIELDNAME=VIAUFKS_ABKRS, ALIAS=ABKRS, USAGE=A2, ACTUAL=A2,
TITLE='Proc. grp', DESCRIPTION='Processing group', $
FIELDNAME=VIAUFKS_KSTAR, ALIAS=KSTAR, USAGE=A10, ACTUAL=A10,
TITLE='SettleCE', DESCRIPTION='Settlement cost element', $
FIELDNAME=VIAUFKS_KOSTL, ALIAS=KOSTL, USAGE=A10, ACTUAL=A10,
TITLE='Cost ctr', DESCRIPTION='Cost Center', $
FIELDNAME=VIAUFKS_SAKNR, ALIAS=SAKNR, USAGE=A10, ACTUAL=A10,
TITLE='G/L acct', DESCRIPTION='G/L account for basic settlement', $
FIELDNAME=VIAUFKS_SETNM, ALIAS=SETNM, USAGE=A12, ACTUAL=A12,
TITLE='AllocSet', DESCRIPTION='Allocation set', $
FIELDNAME=VIAUFKS_CYCLE, ALIAS=CYCLE, USAGE=A10, ACTUAL=A10,
TITLE='CCtr post.', DESCRIPTION='Cost center to which costs are actually posted', $
FIELDNAME=VIAUFKS_SDATE, ALIAS=SDATE, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='From', DESCRIPTION='Starting date', $
FIELDNAME=VIAUFKS_SEQNR, ALIAS=SEQNR, USAGE=A4, ACTUAL=A4,
TITLE='SequenceNo', DESCRIPTION='Sequence number', $
FIELDNAME=VIAUFKS_OBJNR, ALIAS=OBJNR, USAGE=A22, ACTUAL=A22,
TITLE='Obj. no.', DESCRIPTION='Object number', $
FIELDNAME=VIAUFKS_PRCTR, ALIAS=PRCTR, USAGE=A10, ACTUAL=A10,
TITLE='Profit ctr', DESCRIPTION='Profit center', $
FIELDNAME=VIAUFKS_VNAME, ALIAS=VNAME, USAGE=A6, ACTUAL=A6,
TITLE='Venture', DESCRIPTION='Joint venture', $
FIELDNAME=VIAUFKS_RECID, ALIAS=RECID, USAGE=A2, ACTUAL=A2,
TITLE='Rec.indic.', DESCRIPTION='Recovery indicator', $
FIELDNAME=VIAUFKS_ETYPE, ALIAS=ETYPE, USAGE=A3, ACTUAL=A3,
TITLE='Equity Ty.', DESCRIPTION='Equity type', $
FIELDNAME=VIAUFKS_PSPEL, ALIAS=PSPEL, USAGE=A8, ACTUAL=A8,
TITLE='WBS elem.', DESCRIPTION='Work breakdown structure element (WBS element)', $
FIELDNAME=VIAUFKS_AWSLS, ALIAS=AWSLS, USAGE=A6, ACTUAL=A6,
TITLE='Var. key', DESCRIPTION='Variance key', $
FIELDNAME=VIAUFKS_ABGSL, ALIAS=ABGSL, USAGE=A6, ACTUAL=A6,
TITLE='RA key', DESCRIPTION='Results Analysis Key', $
FIELDNAME=VIAUFKS_TPLNR, ALIAS=TPLNR, USAGE=A30, ACTUAL=A30,
TITLE='FunctLoc.', DESCRIPTION='Functional location', $
FIELDNAME=VIAUFKS_ABCKZ, ALIAS=ABCKZ, USAGE=A1, ACTUAL=A1,
TITLE='ABC ind.', DESCRIPTION='ABC indicator for technical object', $
FIELDNAME=VIAUFKS_EQFNR, ALIAS=EQFNR, USAGE=A30, ACTUAL=A30,
TITLE='Sort fld', DESCRIPTION='Sort field', $
FIELDNAME=VIAUFKS_SWERK, ALIAS=SWERK, USAGE=A4, ACTUAL=A4,
TITLE='MntPlant', DESCRIPTION='Maintenance plant', $
FIELDNAME=VIAUFKS_STORT_ILOA, ALIAS=STORT_ILOA, USAGE=A10, ACTUAL=A10,
TITLE='Location', DESCRIPTION='Location of maintenance object', $
FIELDNAME=VIAUFKS_MSGRP, ALIAS=MSGRP, USAGE=A8, ACTUAL=A8,
TITLE='Room', DESCRIPTION='Room', $
FIELDNAME=VIAUFKS_BEBER, ALIAS=BEBER, USAGE=A3, ACTUAL=A3,
TITLE='PlSectn', DESCRIPTION='Plant section', $
FIELDNAME=VIAUFKS_CR_OBJTY, ALIAS=CR_OBJTY, USAGE=A2, ACTUAL=A2,
TITLE='Type', DESCRIPTION='Object types of the CIM resource', $
FIELDNAME=VIAUFKS_PPSID, ALIAS=PPSID, USAGE=A8, ACTUAL=A8,
TITLE='PP WkCtr', DESCRIPTION='Object ID of PP work center', $
FIELDNAME=VIAUFKS_GSBER_ILOA, ALIAS=GSBER_ILOA, USAGE=A4, ACTUAL=A4,
TITLE='Bus. area', DESCRIPTION='Business Area', $
FIELDNAME=VIAUFKS_KOKRS_ILOA, ALIAS=KOKRS_ILOA, USAGE=A4, ACTUAL=A4,
TITLE='CO area', DESCRIPTION='Controlling Area', $
FIELDNAME=VIAUFKS_PROID, ALIAS=PROID, USAGE=A8, ACTUAL=A8,
TITLE='WBS elem.', DESCRIPTION='Work breakdown structure element (WBS element)', $
FIELDNAME=VIAUFKS_BUKRS_ILOA, ALIAS=BUKRS_ILOA, USAGE=A4, ACTUAL=A4,
TITLE='CoCode', DESCRIPTION='Company Code', $
FIELDNAME=VIAUFKS_ANLNR, ALIAS=ANLNR, USAGE=A12, ACTUAL=A12,
TITLE='Asset', DESCRIPTION='Main asset number', $
FIELDNAME=VIAUFKS_ANLUN, ALIAS=ANLUN, USAGE=A4, ACTUAL=A4,
TITLE='Sub-number', DESCRIPTION='Asset sub-number', $
FIELDNAME=VIAUFKS_DAUFN, ALIAS=DAUFN, USAGE=A12, ACTUAL=A12,
TITLE='StdgOrd.', DESCRIPTION='Standing order number', $
FIELDNAME=VIAUFKS_AUFNR_ILOA, ALIAS=AUFNR_ILOA, USAGE=A12, ACTUAL=A12,
TITLE='StlmtOrder', DESCRIPTION='Settlement order', $
FIELDNAME=VIAUFKS_GLTRP, ALIAS=GLTRP, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Basic fin.', DESCRIPTION='Basic finish date', $
FIELDNAME=VIAUFKS_GSTRP, ALIAS=GSTRP, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Bas. start', DESCRIPTION='Basic start date', $
FIELDNAME=VIAUFKS_FTRMS, ALIAS=FTRMS, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Release', DESCRIPTION='Scheduled release date', $
FIELDNAME=VIAUFKS_GLTRS, ALIAS=GLTRS, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Sched.Fin.', DESCRIPTION='Scheduled finish', $
FIELDNAME=VIAUFKS_GSTRS, ALIAS=GSTRS, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='SchedStart', DESCRIPTION='Scheduled start', $
FIELDNAME=VIAUFKS_GSTRI, ALIAS=GSTRI, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Act. start', DESCRIPTION='Actual start date', $
FIELDNAME=VIAUFKS_GETRI, ALIAS=GETRI, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Act.finish', DESCRIPTION='Confirmed order finish date', $
FIELDNAME=VIAUFKS_GLTRI, ALIAS=GLTRI, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Act.finish', DESCRIPTION='Actual finish date', $
FIELDNAME=VIAUFKS_FTRMI, ALIAS=FTRMI, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Release', DESCRIPTION='Actual release date', $
FIELDNAME=VIAUFKS_FTRMP, ALIAS=FTRMP, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Plan. rel.', DESCRIPTION='Planned release date', $
FIELDNAME=VIAUFKS_RSNUM, ALIAS=RSNUM, USAGE=A10, ACTUAL=A10,
TITLE='Reserv.no.', DESCRIPTION='Number of reservation/dependent requirements', $
FIELDNAME=VIAUFKS_GASMG, ALIAS=GASMG, USAGE=P15.3, ACTUAL=P7,
TITLE='Scrap', DESCRIPTION='Total scrap quantity in the order', $
FIELDNAME=VIAUFKS_GAMNG, ALIAS=GAMNG, USAGE=P15.3, ACTUAL=P7,
TITLE='Target qty', DESCRIPTION='Total order quantity', $
FIELDNAME=VIAUFKS_GMEIN, ALIAS=GMEIN, USAGE=A3, ACTUAL=A3,
TITLE='Unit', DESCRIPTION='Base unit of measure', $
FIELDNAME=VIAUFKS_PLNBEZ, ALIAS=PLNBEZ, USAGE=A18, ACTUAL=A18,
TITLE='Material', DESCRIPTION='Material number', $
FIELDNAME=VIAUFKS_PLNTY, ALIAS=PLNTY, USAGE=A1, ACTUAL=A1,
TITLE='Type', DESCRIPTION='Task list type', $
FIELDNAME=VIAUFKS_PLNNR, ALIAS=PLNNR, USAGE=A8, ACTUAL=A8,
TITLE='Group', DESCRIPTION='Key for task list group', $
FIELDNAME=VIAUFKS_PLNAW, ALIAS=PLNAW, USAGE=A1, ACTUAL=A1,
TITLE='Applicatn', DESCRIPTION='Application of the task list', $
FIELDNAME=VIAUFKS_PLNAL, ALIAS=PLNAL, USAGE=A2, ACTUAL=A2,
TITLE='Grp. ct.', DESCRIPTION='Group counter', $
FIELDNAME=VIAUFKS_PVERW, ALIAS=PVERW, USAGE=A3, ACTUAL=A3,
TITLE='Usage', DESCRIPTION='Task list usage', $
FIELDNAME=VIAUFKS_PLAUF, ALIAS=PLAUF, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='RtgTransf.', DESCRIPTION='Date for routing transfer', $
FIELDNAME=VIAUFKS_PLSVB, ALIAS=PLSVB, USAGE=P15.3, ACTUAL=P7,
TITLE='To LotSize', DESCRIPTION='To lot size', $
FIELDNAME=VIAUFKS_PLNME, ALIAS=PLNME, USAGE=A3, ACTUAL=A3,
TITLE='TskL unit', DESCRIPTION='Task list unit of measure', $
FIELDNAME=VIAUFKS_PLSVN, ALIAS=PLSVN, USAGE=P15.3, ACTUAL=P7,
TITLE='FrmLotSize', DESCRIPTION='From lot size', $
FIELDNAME=VIAUFKS_PDATV, ALIAS=PDATV, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Valid from', DESCRIPTION='Valid-from date', $
FIELDNAME=VIAUFKS_PAENR, ALIAS=PAENR, USAGE=A12, ACTUAL=A12,
TITLE='Change no.', DESCRIPTION='Change number', $
FIELDNAME=VIAUFKS_PLGRP, ALIAS=PLGRP, USAGE=A3, ACTUAL=A3,
TITLE='PlannerGrp', DESCRIPTION='Responsible planner group/department', $
FIELDNAME=VIAUFKS_LODIV, ALIAS=LODIV, USAGE=P15.3, ACTUAL=P7,
TITLE='LotSzeDiv', DESCRIPTION='Lot size divisor', $
FIELDNAME=VIAUFKS_STLTY, ALIAS=STLTY, USAGE=A1, ACTUAL=A1,
TITLE='BOM cat', DESCRIPTION='BOM category', $
FIELDNAME=VIAUFKS_STLBEZ, ALIAS=STLBEZ, USAGE=A18, ACTUAL=A18,
TITLE='Material', DESCRIPTION='Material number', $
FIELDNAME=VIAUFKS_STLST, ALIAS=STLST, USAGE=A2, ACTUAL=A2,
TITLE='BOM status', DESCRIPTION='BOM status', $
FIELDNAME=VIAUFKS_STLNR, ALIAS=STLNR, USAGE=A8, ACTUAL=A8,
TITLE='BOM', DESCRIPTION='Bill of material', $
FIELDNAME=VIAUFKS_SDATV, ALIAS=SDATV, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Valid from', DESCRIPTION='Valid-from date', $
FIELDNAME=VIAUFKS_SBMNG, ALIAS=SBMNG, USAGE=P15.3, ACTUAL=P7,
TITLE='Base qty', DESCRIPTION='Base quantity', $
FIELDNAME=VIAUFKS_SBMEH, ALIAS=SBMEH, USAGE=A3, ACTUAL=A3,
TITLE='Unit', DESCRIPTION='Base unit of measure', $
FIELDNAME=VIAUFKS_SAENR, ALIAS=SAENR, USAGE=A12, ACTUAL=A12,
TITLE='Change no.', DESCRIPTION='Change number', $
FIELDNAME=VIAUFKS_STLAL, ALIAS=STLAL, USAGE=A2, ACTUAL=A2,
TITLE='Alt. BOM', DESCRIPTION='Alternative BOM', $
FIELDNAME=VIAUFKS_STLAN, ALIAS=STLAN, USAGE=A1, ACTUAL=A1,
TITLE='BOM usage', DESCRIPTION='BOM usage', $
FIELDNAME=VIAUFKS_SLSVN, ALIAS=SLSVN, USAGE=P15.3, ACTUAL=P7,
TITLE='Frm lot sz', DESCRIPTION='From lot size', $
FIELDNAME=VIAUFKS_SLSBS, ALIAS=SLSBS, USAGE=P15.3, ACTUAL=P7,
TITLE='to', DESCRIPTION='To lot size', $
FIELDNAME=VIAUFKS_AUFLD, ALIAS=AUFLD, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Expl. date', DESCRIPTION='Date of BOM explosion/routing transfer', $
FIELDNAME=VIAUFKS_DISPO, ALIAS=DISPO, USAGE=A3, ACTUAL=A3,
TITLE='MRP ctrlr', DESCRIPTION='MRP controller for the order', $
FIELDNAME=VIAUFKS_AUFPL, ALIAS=AUFPL, USAGE=A10, ACTUAL=A10,
TITLE='Routing no', DESCRIPTION='Routing number for operations in the order', $
FIELDNAME=VIAUFKS_FEVOR, ALIAS=FEVOR, USAGE=A3, ACTUAL=A3,
TITLE='ProdSched.', DESCRIPTION='Production scheduler', $
FIELDNAME=VIAUFKS_FHORI, ALIAS=FHORI, USAGE=A3, ACTUAL=A3,
TITLE='SM key', DESCRIPTION='Scheduling Margin Key for Floats', $
FIELDNAME=VIAUFKS_TERKZ, ALIAS=TERKZ, USAGE=A1, ACTUAL=A1,
TITLE='SchedType', DESCRIPTION='Scheduling type', $
FIELDNAME=VIAUFKS_REDKZ, ALIAS=REDKZ, USAGE=A1, ACTUAL=A1,
TITLE='RedInd', DESCRIPTION='Reduction indicator for scheduling', $
FIELDNAME=VIAUFKS_APRIO, ALIAS=APRIO, USAGE=A1, ACTUAL=A1,
TITLE='Priority', DESCRIPTION='Order priority', $
FIELDNAME=VIAUFKS_AUFNT, ALIAS=AUFNT, USAGE=A12, ACTUAL=A12,
TITLE='Subntwk of', DESCRIPTION='Number of superior network', $
FIELDNAME=VIAUFKS_AUFPT, ALIAS=AUFPT, USAGE=A10, ACTUAL=A10,
TITLE='Routing no', DESCRIPTION='Routing number for operations in the order', $
FIELDNAME=VIAUFKS_APLZT, ALIAS=APLZT, USAGE=A8, ACTUAL=A8,
TITLE='Counter', DESCRIPTION='General counter for order', $
FIELDNAME=VIAUFKS_PROFID, ALIAS=PROFID, USAGE=A7, ACTUAL=A7,
TITLE='Profile', DESCRIPTION='Network profile', $
FIELDNAME=VIAUFKS_VORGZ, ALIAS=VORGZ, USAGE=A3, ACTUAL=A3,
TITLE='FlBefProd.', DESCRIPTION='Float before production (in days)', $
FIELDNAME=VIAUFKS_SICHZ, ALIAS=SICHZ, USAGE=A3, ACTUAL=A3,
TITLE='FlAftProd.', DESCRIPTION='Float after production (in days)', $
FIELDNAME=VIAUFKS_FREIZ, ALIAS=FREIZ, USAGE=A3, ACTUAL=A3,
TITLE='ReleasPer.', DESCRIPTION='Release period (in days)', $
FIELDNAME=VIAUFKS_UPTER, ALIAS=UPTER, USAGE=A1, ACTUAL=A1,
TITLE='Dates chgd', DESCRIPTION='Indicator: Scheduled dates changed', $
FIELDNAME=VIAUFKS_BEDID, ALIAS=BEDID, USAGE=A12, ACTUAL=A12,
TITLE='ID no.', DESCRIPTION='ID of the capacity requirements record', $
FIELDNAME=VIAUFKS_PRONR, ALIAS=PRONR, USAGE=A8, ACTUAL=A8,
TITLE='Proj.def.', DESCRIPTION='Project definition', $
FIELDNAME=VIAUFKS_ZAEHL, ALIAS=ZAEHL, USAGE=A8, ACTUAL=A8,
TITLE='Counter', DESCRIPTION='Internal counter', $
FIELDNAME=VIAUFKS_MZAEHL, ALIAS=MZAEHL, USAGE=A8, ACTUAL=A8,
TITLE='Counter', DESCRIPTION='Internal counter', $
FIELDNAME=VIAUFKS_ZKRIZ, ALIAS=ZKRIZ, USAGE=A7, ACTUAL=A7,
TITLE='AddCritCt', DESCRIPTION='Counter for additional criteria', $
FIELDNAME=VIAUFKS_PRUEFLOS, ALIAS=PRUEFLOS, USAGE=A12, ACTUAL=A12,
TITLE='Insp. lot', DESCRIPTION='Inspection Lot Number', $
FIELDNAME=VIAUFKS_KLVARP, ALIAS=KLVARP, USAGE=A4, ACTUAL=A4,
TITLE='CstgVarPln', DESCRIPTION='Costing variant for planned costs', $
FIELDNAME=VIAUFKS_KLVARI, ALIAS=KLVARI, USAGE=A4, ACTUAL=A4,
TITLE='CstgVarAct', DESCRIPTION='Costing variant for actual costs', $
FIELDNAME=VIAUFKS_RGEKZ, ALIAS=RGEKZ, USAGE=A1, ACTUAL=A1,
TITLE='Backflush', DESCRIPTION='Indicator: Backflushing for order', $
FIELDNAME=VIAUFKS_PLART, ALIAS=PLART, USAGE=A1, ACTUAL=A1,
TITLE='SchedBasis', DESCRIPTION='Basis for scheduling', $
FIELDNAME=VIAUFKS_ADDAT, ALIAS=ADDAT, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='RefDate', DESCRIPTION='PM Order: Reference Date', $
FIELDNAME=VIAUFKS_ADUHR, ALIAS=ADUHR, USAGE=A6, ACTUAL=A6,
TITLE='Ref. time', DESCRIPTION='Time of Reference Date', $
FIELDNAME=VIAUFKS_IPHAS, ALIAS=IPHAS, USAGE=A1, ACTUAL=A1,
TITLE='Stage', DESCRIPTION='Maintenance processing stage', $
FIELDNAME=VIAUFKS_ILART, ALIAS=ILART, USAGE=A3, ACTUAL=A3,
TITLE='PMActType', DESCRIPTION='Maintenance activity type', $
FIELDNAME=VIAUFKS_QMNUM, ALIAS=QMNUM, USAGE=A12, ACTUAL=A12,
TITLE='Notifctn', DESCRIPTION='Notification Number', $
FIELDNAME=VIAUFKS_FLG_AOB, ALIAS=FLG_AOB, USAGE=A1, ACTUAL=A1,
TITLE='Ind:Relshp', DESCRIPTION='Indicator: relationships', $
FIELDNAME=VIAUFKS_FLG_ARBEI, ALIAS=FLG_ARBEI, USAGE=A1, ACTUAL=A1,
TITLE='Ind.work', DESCRIPTION='Indicator: Default value work is relevant', $
FIELDNAME=VIAUFKS_GLTPP, ALIAS=GLTPP, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Finish', DESCRIPTION='Finish date (forecast)', $
FIELDNAME=VIAUFKS_GSTPP, ALIAS=GSTPP, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Start', DESCRIPTION='Forecast start date', $
FIELDNAME=VIAUFKS_GLTPS, ALIAS=GLTPS, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Finish', DESCRIPTION='Scheduled forecast finish', $
FIELDNAME=VIAUFKS_GSTPS, ALIAS=GSTPS, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Start', DESCRIPTION='Scheduled forecast start', $
FIELDNAME=VIAUFKS_FTRPS, ALIAS=FTRPS, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Release', DESCRIPTION='Scheduled release date (forecast)', $
FIELDNAME=VIAUFKS_RDKZP, ALIAS=RDKZP, USAGE=A1, ACTUAL=A1,
TITLE='RedInd', DESCRIPTION='Reduction indicator for scheduling (forecast)', $
FIELDNAME=VIAUFKS_TRKZP, ALIAS=TRKZP, USAGE=A1, ACTUAL=A1,
TITLE='Sched.type', DESCRIPTION='Scheduling type (forecast)', $
FIELDNAME=VIAUFKS_VKORG, ALIAS=VKORG, USAGE=A4, ACTUAL=A4,
TITLE='Sales org.', DESCRIPTION='Sales organization', $
FIELDNAME=VIAUFKS_VTWEG, ALIAS=VTWEG, USAGE=A2, ACTUAL=A2,
TITLE='Distr. chl', DESCRIPTION='Distribution channel', $
FIELDNAME=VIAUFKS_SPART, ALIAS=SPART, USAGE=A2, ACTUAL=A2,
TITLE='Division', DESCRIPTION='Division', $
FIELDNAME=VIAUFKS_ADRNR_ILOA, ALIAS=ADRNR_ILOA, USAGE=A10, ACTUAL=A10,
TITLE='Addr. no.', DESCRIPTION='Address number', $
FIELDNAME=VIAUFKS_KDAUF, ALIAS=KDAUF, USAGE=A10, ACTUAL=A10,
TITLE='Sales ord.', DESCRIPTION='Sales Order Number', $
FIELDNAME=VIAUFKS_KDPOS, ALIAS=KDPOS, USAGE=A6, ACTUAL=A6,
TITLE='SO item', DESCRIPTION='Item number in Sales Order', $
FIELDNAME=VIAUFKS_GLUZP, ALIAS=GLUZP, USAGE=A6, ACTUAL=A6,
TITLE='Basic fin.', DESCRIPTION='Basic finish (time)', $
FIELDNAME=VIAUFKS_GSUZP, ALIAS=GSUZP, USAGE=A6, ACTUAL=A6,
TITLE='BasicStart', DESCRIPTION='Basic start time', $
FIELDNAME=VIAUFKS_GLUZS, ALIAS=GLUZS, USAGE=A6, ACTUAL=A6,
TITLE='Finish tme', DESCRIPTION='Scheduled finish time', $
FIELDNAME=VIAUFKS_GSUZS, ALIAS=GSUZS, USAGE=A6, ACTUAL=A6,
TITLE='BasicStart', DESCRIPTION='Scheduled start time', $
FIELDNAME=VIAUFKS_MAUFNR, ALIAS=MAUFNR, USAGE=A12, ACTUAL=A12,
TITLE='SuperOrder', DESCRIPTION='Number of superior order', $
FIELDNAME=VIAUFKS_LEAD_AUFNR, ALIAS=LEAD_AUFNR, USAGE=A12, ACTUAL=A12,
TITLE='LeadgOrder', DESCRIPTION='Leading order in current processing', $
FIELDNAME=VIAUFKS_GEUZI, ALIAS=GEUZI, USAGE=A6, ACTUAL=A6,
TITLE='Act.finish', DESCRIPTION='Confirmed order finish (time)', $
FIELDNAME=VIAUFKS_GSUZI, ALIAS=GSUZI, USAGE=A6, ACTUAL=A6,
TITLE='ActStart', DESCRIPTION='Actual start time', $
FIELDNAME=VIAUFKS_OWNER, ALIAS=OWNER, USAGE=A1, ACTUAL=A1,
TITLE='Object ref', DESCRIPTION='Object reference indicator', $
FIELDNAME=VIAUFKS_PLKNZ, ALIAS=PLKNZ, USAGE=A1, ACTUAL=A1,
TITLE='OrdPlanInd', DESCRIPTION='Maintenance order planning indicator', $
FIELDNAME=VIAUFKS_USER4, ALIAS=USER4, USAGE=P13.2, ACTUAL=P6,
TITLE='Costs', DESCRIPTION='Estimated total costs of order', $
FIELDNAME=VIAUFKS_RSORD, ALIAS=RSORD, USAGE=A1, ACTUAL=A1,
TITLE='Refbshmnt', DESCRIPTION='Refurbishment order indicator (PM)', $
FIELDNAME=VIAUFKS_BEMOT, ALIAS=BEMOT, USAGE=A2, ACTUAL=A2,
TITLE='AcctIndic', DESCRIPTION='Accounting indicator', $
FIELDNAME=VIAUFKS_SERMAT, ALIAS=SERMAT, USAGE=A18, ACTUAL=A18,
TITLE='Material', DESCRIPTION='Material number', $
FIELDNAME=VIAUFKS_SERIALNR, ALIAS=SERIALNR, USAGE=A18, ACTUAL=A18,
TITLE='Serial no.', DESCRIPTION='Serial number', $
FIELDNAME=VIAUFKS_DEVICEID, ALIAS=DEVICEID, USAGE=A40, ACTUAL=A40,
TITLE='DeviceData', DESCRIPTION='Additional Device Data', $
FIELDNAME=VIAUFKS_ADRNRA, ALIAS=ADRNRA, USAGE=A10, ACTUAL=A10,
TITLE='Addr. no.', DESCRIPTION='Address number', $
WebFOCUS 7.7.03 Windows, All Outputs
Virtuoso The field
VIAUFKST _GSTRS doesn't exist in the MFD, only :
FIELDNAME=
VIAUFKS _GSTRS, ALIAS=GSTRS, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
Have you provided the proper MFD ?
Have you done a Check on your MFD ? (right click on the .mas file and select Check)
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDFIn Focus since 2007
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013
IP
Platinum Member My bad, I sent the wrong file, below is the correct one:
FILENAME=VIAUFKST, SUFFIX=SQLSAP ,
REMARKS='Generated Table for View VIAUFKST', $
SEGMENT=VIAUFKST, SEGTYPE=S0, $
FIELDNAME=VIAUFKST_MANDT, ALIAS=MANDT, USAGE=A3, ACTUAL=A3,
TITLE='Client', DESCRIPTION='Client', $
FIELDNAME=VIAUFKST_AUFNR, ALIAS=AUFNR, USAGE=A12, ACTUAL=A12,
TITLE='Order', DESCRIPTION='Order Number', $
FIELDNAME=VIAUFKST_ARTPR, ALIAS=ARTPR, USAGE=A2, ACTUAL=A2,
TITLE='PrioType', DESCRIPTION='Priority Type', $
FIELDNAME=VIAUFKST_PRIOK, ALIAS=PRIOK, USAGE=A1, ACTUAL=A1,
TITLE='Priority', DESCRIPTION='Priority', $
FIELDNAME=VIAUFKST_EQUNR, ALIAS=EQUNR, USAGE=A18, ACTUAL=A18,
TITLE='Equipment', DESCRIPTION='Equipment number', $
FIELDNAME=VIAUFKST_BAUTL, ALIAS=BAUTL, USAGE=A18, ACTUAL=A18,
TITLE='Assembly', DESCRIPTION='Assembly', $
FIELDNAME=VIAUFKST_ILOAN, ALIAS=ILOAN, USAGE=A12, ACTUAL=A12,
TITLE='Loc/Acc.', DESCRIPTION='Location and account assignment for technical object', $
FIELDNAME=VIAUFKST_ILOAI, ALIAS=ILOAI, USAGE=A1, ACTUAL=A1,
TITLE='ILOA ind.', DESCRIPTION='ILOA Individual', $
FIELDNAME=VIAUFKST_ANLZU, ALIAS=ANLZU, USAGE=A1, ACTUAL=A1,
TITLE='SystCond.', DESCRIPTION='System condition', $
FIELDNAME=VIAUFKST_IWERK, ALIAS=IWERK, USAGE=A4, ACTUAL=A4,
TITLE='Plng plant', DESCRIPTION='Maintenance Planning Plant', $
FIELDNAME=VIAUFKST_INGPR, ALIAS=INGPR, USAGE=A3, ACTUAL=A3,
TITLE='PlannerGrp', DESCRIPTION='Planner Group for Customer Service and Plant Maintenance', $
FIELDNAME=VIAUFKST_APGRP, ALIAS=APGRP, USAGE=A3, ACTUAL=A3,
TITLE='PlannerGrp', DESCRIPTION='Responsible planner group/department', $
FIELDNAME=VIAUFKST_PM_OBJTY, ALIAS=PM_OBJTY, USAGE=A2, ACTUAL=A2,
TITLE='Type', DESCRIPTION='Object Type of CIM Resources for Work Center', $
FIELDNAME=VIAUFKST_GEWRK, ALIAS=GEWRK, USAGE=A8, ACTUAL=A8,
TITLE='Work ctr', DESCRIPTION='Object ID of the Work Center', $
FIELDNAME=VIAUFKST_KUNUM, ALIAS=KUNUM, USAGE=A10, ACTUAL=A10,
TITLE='Customer', DESCRIPTION='Customer Number', $
FIELDNAME=VIAUFKST_ANING, ALIAS=ANING, USAGE=A12, ACTUAL=A12,
TITLE='Pers.resp.', DESCRIPTION='Name of Person Reponsible for System', $
FIELDNAME=VIAUFKST_GAUZT, ALIAS=GAUZT, USAGE=D21.15E, ACTUAL=D8,
TITLE='Downtime/h', DESCRIPTION='Planned downtime in hours', $
FIELDNAME=VIAUFKST_GAUEH, ALIAS=GAUEH, USAGE=A3, ACTUAL=A3,
TITLE='Unit', DESCRIPTION='Unit for Breakdown Duration', $
FIELDNAME=VIAUFKST_ANLBD, ALIAS=ANLBD, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Avail. to', DESCRIPTION='Date until which the system is available', $
FIELDNAME=VIAUFKST_ANLVD, ALIAS=ANLVD, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Avail.from', DESCRIPTION='Date from which the system is available', $
FIELDNAME=VIAUFKST_ANLBZ, ALIAS=ANLBZ, USAGE=A6, ACTUAL=A6,
TITLE='Time', DESCRIPTION='Time until which the system is available', $
FIELDNAME=VIAUFKST_ANLVZ, ALIAS=ANLVZ, USAGE=A6, ACTUAL=A6,
TITLE='Time from', DESCRIPTION='Time from Which System is Available', $
FIELDNAME=VIAUFKST_INSPK, ALIAS=INSPK, USAGE=A12, ACTUAL=A12,
TITLE='TInspec by', DESCRIPTION='Name of Person Responsible for Technical Inspection', $
FIELDNAME=VIAUFKST_DATAN, ALIAS=DATAN, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='TInspec on', DESCRIPTION='Date of Technical Inspection', $
FIELDNAME=VIAUFKST_WARPL, ALIAS=WARPL, USAGE=A12, ACTUAL=A12,
TITLE='MntPlan', DESCRIPTION='Maintenance plan', $
FIELDNAME=VIAUFKST_ABNUM, ALIAS=ABNUM, USAGE=I10, ACTUAL=I4,
TITLE='Call no.', DESCRIPTION='Maintenance plan call number', $
FIELDNAME=VIAUFKST_WAPOS, ALIAS=WAPOS, USAGE=A16, ACTUAL=A16,
TITLE='MntItem', DESCRIPTION='Maintenance item', $
FIELDNAME=VIAUFKST_LAUFN, ALIAS=LAUFN, USAGE=A12, ACTUAL=A12,
TITLE='Last ord.', DESCRIPTION='Order number', $
FIELDNAME=VIAUFKST_OBKNR, ALIAS=OBKNR, USAGE=I10, ACTUAL=I4,
TITLE='ObListNo.', DESCRIPTION='Object list number', $
FIELDNAME=VIAUFKST_REVNR, ALIAS=REVNR, USAGE=A8, ACTUAL=A8,
TITLE='Revision', DESCRIPTION='Revision for Plant Maintenance and Customer Service', $
FIELDNAME=VIAUFKST_ADDAT, ALIAS=ADDAT, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='RefDate', DESCRIPTION='PM Order: Reference Date', $
FIELDNAME=VIAUFKST_ADUHR, ALIAS=ADUHR, USAGE=A6, ACTUAL=A6,
TITLE='Ref. time', DESCRIPTION='Time of Reference Date', $
FIELDNAME=VIAUFKST_IPHAS, ALIAS=IPHAS, USAGE=A1, ACTUAL=A1,
TITLE='Stage', DESCRIPTION='Maintenance processing stage', $
FIELDNAME=VIAUFKST_ILART, ALIAS=ILART, USAGE=A3, ACTUAL=A3,
TITLE='PMActType', DESCRIPTION='Maintenance activity type', $
FIELDNAME=VIAUFKST_QMNUM, ALIAS=QMNUM, USAGE=A12, ACTUAL=A12,
TITLE='Notifctn', DESCRIPTION='Notification Number', $
FIELDNAME=VIAUFKST_HISDA, ALIAS=HISDA, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Hist.fr.', DESCRIPTION='PM request: History date', $
FIELDNAME=VIAUFKST_AKKNZ, ALIAS=AKKNZ, USAGE=A1, ACTUAL=A1,
TITLE='Cat.', DESCRIPTION='Order Category Indicator Plant Maintenance', $
FIELDNAME=VIAUFKST_PLKNZ, ALIAS=PLKNZ, USAGE=A1, ACTUAL=A1,
TITLE='OrdPlanInd', DESCRIPTION='Maintenance order planning indicator', $
FIELDNAME=VIAUFKST_SERIALNR, ALIAS=SERIALNR, USAGE=A18, ACTUAL=A18,
TITLE='Serial no.', DESCRIPTION='Serial number', $
FIELDNAME=VIAUFKST_SERMAT, ALIAS=SERMAT, USAGE=A18, ACTUAL=A18,
TITLE='Material', DESCRIPTION='Material number', $
FIELDNAME=VIAUFKST_DEVICEID, ALIAS=DEVICEID, USAGE=A40, ACTUAL=A40,
TITLE='DeviceData', DESCRIPTION='Additional Device Data', $
FIELDNAME=VIAUFKST_SCREENTY, ALIAS=SCREENTY, USAGE=A4, ACTUAL=A4,
TITLE='Scenario', DESCRIPTION='Scenario or Subscreen Category', $
FIELDNAME=VIAUFKST_AUART, ALIAS=AUART, USAGE=A4, ACTUAL=A4,
TITLE='Order type', DESCRIPTION='Order type', $
FIELDNAME=VIAUFKST_AUTYP, ALIAS=AUTYP, USAGE=A2, ACTUAL=A2,
TITLE='Order catg', DESCRIPTION='Order category', $
FIELDNAME=VIAUFKST_REFNR, ALIAS=REFNR, USAGE=A12, ACTUAL=A12,
TITLE='Order', DESCRIPTION='Reference order number', $
FIELDNAME=VIAUFKST_ERNAM, ALIAS=ERNAM, USAGE=A12, ACTUAL=A12,
TITLE='Entered by', DESCRIPTION='Entered by', $
FIELDNAME=VIAUFKST_ERDAT, ALIAS=ERDAT, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='on', DESCRIPTION='Created on', $
FIELDNAME=VIAUFKST_AENAM, ALIAS=AENAM, USAGE=A12, ACTUAL=A12,
TITLE='Changed by', DESCRIPTION='User ID of person who made the last change', $
FIELDNAME=VIAUFKST_AEDAT, ALIAS=AEDAT, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Changed on', DESCRIPTION='Change date for Order Master', $
FIELDNAME=VIAUFKST_KTEXT, ALIAS=KTEXT, USAGE=A40, ACTUAL=A40,
TITLE='Short text', DESCRIPTION='Short text', $
FIELDNAME=VIAUFKST_LTEXT, ALIAS=LTEXT, USAGE=A1, ACTUAL=A1,
TITLE='Long text', DESCRIPTION='Indicator: "Long Text Exists"', $
FIELDNAME=VIAUFKST_BUKRS, ALIAS=BUKRS, USAGE=A4, ACTUAL=A4,
TITLE='CoCode', DESCRIPTION='Company Code', $
FIELDNAME=VIAUFKST_WERKS, ALIAS=WERKS, USAGE=A4, ACTUAL=A4,
TITLE='Plant', DESCRIPTION='Plant', $
FIELDNAME=VIAUFKST_GSBER, ALIAS=GSBER, USAGE=A4, ACTUAL=A4,
TITLE='Bus. area', DESCRIPTION='Business Area', $
FIELDNAME=VIAUFKST_KOKRS, ALIAS=KOKRS, USAGE=A4, ACTUAL=A4,
TITLE='CO area', DESCRIPTION='Controlling Area', $
FIELDNAME=VIAUFKST_CCKEY, ALIAS=CCKEY, USAGE=A23, ACTUAL=A23,
TITLE='Key', DESCRIPTION='Cost collector key', $
FIELDNAME=VIAUFKST_KOSTV, ALIAS=KOSTV, USAGE=A10, ACTUAL=A10,
TITLE='Resp. CCtr', DESCRIPTION='Responsible cost center', $
FIELDNAME=VIAUFKST_SOWRK, ALIAS=SOWRK, USAGE=A4, ACTUAL=A4,
TITLE='Plant', DESCRIPTION='Location plant', $
FIELDNAME=VIAUFKST_ASTKZ, ALIAS=ASTKZ, USAGE=A1, ACTUAL=A1,
TITLE='Statist.', DESCRIPTION='Identifier for statistical order', $
FIELDNAME=VIAUFKST_WAERS, ALIAS=WAERS, USAGE=A5, ACTUAL=A5,
TITLE='Currency', DESCRIPTION='Order Currency', $
FIELDNAME=VIAUFKST_ASTNR, ALIAS=ASTNR, USAGE=A2, ACTUAL=A2,
TITLE='Status', DESCRIPTION='Order status', $
FIELDNAME=VIAUFKST_STDAT, ALIAS=STDAT, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Status chg', DESCRIPTION='Date of last status change', $
FIELDNAME=VIAUFKST_ESTNR, ALIAS=ESTNR, USAGE=A2, ACTUAL=A2,
TITLE='ReachdStat', DESCRIPTION='Status reached so far', $
FIELDNAME=VIAUFKST_PDAT1, ALIAS=PDAT1, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='PlnRelease', DESCRIPTION='Planned release date', $
FIELDNAME=VIAUFKST_PDAT2, ALIAS=PDAT2, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='PlnCompltn', DESCRIPTION='Planned completion date', $
FIELDNAME=VIAUFKST_PDAT3, ALIAS=PDAT3, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Pl.clo.dat', DESCRIPTION='Planned closing date', $
FIELDNAME=VIAUFKST_IDAT1, ALIAS=IDAT1, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Release', DESCRIPTION='Release date', $
FIELDNAME=VIAUFKST_IDAT2, ALIAS=IDAT2, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='TechCompl.', DESCRIPTION='Technical completion date', $
FIELDNAME=VIAUFKST_IDAT3, ALIAS=IDAT3, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Close', DESCRIPTION='Close date', $
FIELDNAME=VIAUFKST_OBJID, ALIAS=OBJID, USAGE=A1, ACTUAL=A1,
TITLE='Object ID', DESCRIPTION='Object ID', $
FIELDNAME=VIAUFKST_VOGRP, ALIAS=VOGRP, USAGE=A4, ACTUAL=A4,
TITLE='DisTranGrp', DESCRIPTION='Group of disallowed transactions', $
FIELDNAME=VIAUFKST_LOEKZ, ALIAS=LOEKZ, USAGE=A1, ACTUAL=A1,
TITLE='Del. flag', DESCRIPTION='Deletion flag', $
FIELDNAME=VIAUFKST_PLGKZ, ALIAS=PLGKZ, USAGE=A1, ACTUAL=A1,
TITLE='Plan LI', DESCRIPTION='Identifier for planning with line items', $
FIELDNAME=VIAUFKST_KVEWE, ALIAS=KVEWE, USAGE=A1, ACTUAL=A1,
TITLE='Usage', DESCRIPTION='Usage of the condition table', $
FIELDNAME=VIAUFKST_KAPPL, ALIAS=KAPPL, USAGE=A2, ACTUAL=A2,
TITLE='Applicat.', DESCRIPTION='Application', $
FIELDNAME=VIAUFKST_KALSM, ALIAS=KALSM, USAGE=A6, ACTUAL=A6,
TITLE='Cost.Sheet', DESCRIPTION='Costing sheet', $
FIELDNAME=VIAUFKST_ZSCHL, ALIAS=ZSCHL, USAGE=A6, ACTUAL=A6,
TITLE='OH key', DESCRIPTION='Overhead key', $
FIELDNAME=VIAUFKST_ABKRS, ALIAS=ABKRS, USAGE=A2, ACTUAL=A2,
TITLE='Proc. grp', DESCRIPTION='Processing group', $
FIELDNAME=VIAUFKST_KSTAR, ALIAS=KSTAR, USAGE=A10, ACTUAL=A10,
TITLE='SettleCE', DESCRIPTION='Settlement cost element', $
FIELDNAME=VIAUFKST_SAKNR, ALIAS=SAKNR, USAGE=A10, ACTUAL=A10,
TITLE='G/L acct', DESCRIPTION='G/L account for basic settlement', $
FIELDNAME=VIAUFKST_SETNM, ALIAS=SETNM, USAGE=A12, ACTUAL=A12,
TITLE='AllocSet', DESCRIPTION='Allocation set', $
FIELDNAME=VIAUFKST_CYCLE, ALIAS=CYCLE, USAGE=A10, ACTUAL=A10,
TITLE='CCtr post.', DESCRIPTION='Cost center to which costs are actually posted', $
FIELDNAME=VIAUFKST_SDATE, ALIAS=SDATE, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='From', DESCRIPTION='Starting date', $
FIELDNAME=VIAUFKST_SEQNR, ALIAS=SEQNR, USAGE=A4, ACTUAL=A4,
TITLE='SequenceNo', DESCRIPTION='Sequence number', $
FIELDNAME=VIAUFKST_USER2, ALIAS=USER2, USAGE=A20, ACTUAL=A20,
TITLE='Pers.resp.', DESCRIPTION='Person responsible', $
FIELDNAME=VIAUFKST_USER4, ALIAS=USER4, USAGE=P13.2, ACTUAL=P6,
TITLE='Costs', DESCRIPTION='Estimated total costs of order', $
FIELDNAME=VIAUFKST_OBJNR, ALIAS=OBJNR, USAGE=A22, ACTUAL=A22,
TITLE='Obj. no.', DESCRIPTION='Object number', $
FIELDNAME=VIAUFKST_PRCTR, ALIAS=PRCTR, USAGE=A10, ACTUAL=A10,
TITLE='Profit ctr', DESCRIPTION='Profit center', $
FIELDNAME=VIAUFKST_PSPEL, ALIAS=PSPEL, USAGE=A8, ACTUAL=A8,
TITLE='WBS elem.', DESCRIPTION='Work breakdown structure element (WBS element)', $
FIELDNAME=VIAUFKST_AWSLS, ALIAS=AWSLS, USAGE=A6, ACTUAL=A6,
TITLE='Var. key', DESCRIPTION='Variance key', $
FIELDNAME=VIAUFKST_ABGSL, ALIAS=ABGSL, USAGE=A6, ACTUAL=A6,
TITLE='RA key', DESCRIPTION='Results Analysis Key', $
FIELDNAME=VIAUFKST_KDAUF, ALIAS=KDAUF, USAGE=A10, ACTUAL=A10,
TITLE='Sales ord.', DESCRIPTION='Sales Order Number', $
FIELDNAME=VIAUFKST_KDPOS, ALIAS=KDPOS, USAGE=A6, ACTUAL=A6,
TITLE='SO item', DESCRIPTION='Item number in Sales Order', $
FIELDNAME=VIAUFKST_RSORD, ALIAS=RSORD, USAGE=A1, ACTUAL=A1,
TITLE='Refbshmnt', DESCRIPTION='Refurbishment order indicator (PM)', $
FIELDNAME=VIAUFKST_BEMOT, ALIAS=BEMOT, USAGE=A2, ACTUAL=A2,
TITLE='AcctIndic', DESCRIPTION='Accounting indicator', $
FIELDNAME=VIAUFKST_ADRNRA, ALIAS=ADRNRA, USAGE=A10, ACTUAL=A10,
TITLE='Addr. no.', DESCRIPTION='Address number', $
FIELDNAME=VIAUFKST_ERFZEIT, ALIAS=ERFZEIT, USAGE=A6, ACTUAL=A6,
TITLE='TimCreated', DESCRIPTION='Time created', $
FIELDNAME=VIAUFKST_AEZEIT, ALIAS=AEZEIT, USAGE=A6, ACTUAL=A6,
TITLE='Changed at', DESCRIPTION='Changed at', $
FIELDNAME=VIAUFKST_CSTG_VRNT, ALIAS=CSTG_VRNT, USAGE=A4, ACTUAL=A4,
TITLE='Cstg vrnt', DESCRIPTION='Costing Variant', $
FIELDNAME=VIAUFKST_COSTESTNR, ALIAS=COSTESTNR, USAGE=A12, ACTUAL=A12,
TITLE='Cost est.', DESCRIPTION='Cost est number for cost est w/o qty structure', $
FIELDNAME=VIAUFKST_VNAME, ALIAS=VNAME, USAGE=A6, ACTUAL=A6,
TITLE='Venture', DESCRIPTION='Joint venture', $
FIELDNAME=VIAUFKST_RECID, ALIAS=RECID, USAGE=A2, ACTUAL=A2,
TITLE='Rec.indic.', DESCRIPTION='Recovery indicator', $
FIELDNAME=VIAUFKST_ETYPE, ALIAS=ETYPE, USAGE=A3, ACTUAL=A3,
TITLE='Equity Ty.', DESCRIPTION='Equity type', $
FIELDNAME=VIAUFKST_OTYPE, ALIAS=OTYPE, USAGE=A4, ACTUAL=A4,
TITLE='JV_objtyp', DESCRIPTION='Joint Venture object type', $
FIELDNAME=VIAUFKST_JV_JIBCL, ALIAS=JV_JIBCL, USAGE=A3, ACTUAL=A3,
TITLE='Class', DESCRIPTION='JIB/JIBE Class', $
FIELDNAME=VIAUFKST_JV_JIBSA, ALIAS=JV_JIBSA, USAGE=A5, ACTUAL=A5,
TITLE='Subclass A', DESCRIPTION='JIB/JIBE Subclass A', $
FIELDNAME=VIAUFKST_JV_OCO, ALIAS=JV_OCO, USAGE=A1, ACTUAL=A1,
TITLE='Or CO', DESCRIPTION='JV original cost object', $
FIELDNAME=VIAUFKST_OIHANTYP, ALIAS=OIHANTYP, USAGE=A2, ACTUAL=A2,
TITLE='Handl.type', DESCRIPTION='Excise duty handling type (denotes use of material)', $
FIELDNAME=VIAUFKST_STORT, ALIAS=STORT, USAGE=A10, ACTUAL=A10,
TITLE='Location', DESCRIPTION='Location of maintenance object', $
FIELDNAME=VIAUFKST_KOSTL, ALIAS=KOSTL, USAGE=A10, ACTUAL=A10,
TITLE='Cost ctr', DESCRIPTION='Cost Center', $
FIELDNAME=VIAUFKST_TPLNR, ALIAS=TPLNR, USAGE=A30, ACTUAL=A30,
TITLE='FunctLoc.', DESCRIPTION='Functional location', $
FIELDNAME=VIAUFKST_ABCKZ, ALIAS=ABCKZ, USAGE=A1, ACTUAL=A1,
TITLE='ABC ind.', DESCRIPTION='ABC indicator for technical object', $
FIELDNAME=VIAUFKST_EQFNR, ALIAS=EQFNR, USAGE=A30, ACTUAL=A30,
TITLE='Sort fld', DESCRIPTION='Sort field', $
FIELDNAME=VIAUFKST_SWERK, ALIAS=SWERK, USAGE=A4, ACTUAL=A4,
TITLE='MntPlant', DESCRIPTION='Maintenance plant', $
FIELDNAME=VIAUFKST_MSGRP, ALIAS=MSGRP, USAGE=A8, ACTUAL=A8,
TITLE='Room', DESCRIPTION='Room', $
FIELDNAME=VIAUFKST_BEBER, ALIAS=BEBER, USAGE=A3, ACTUAL=A3,
TITLE='PlSectn', DESCRIPTION='Plant section', $
FIELDNAME=VIAUFKST_CR_OBJTY, ALIAS=CR_OBJTY, USAGE=A2, ACTUAL=A2,
TITLE='Type', DESCRIPTION='Object types of the CIM resource', $
FIELDNAME=VIAUFKST_PPSID, ALIAS=PPSID, USAGE=A8, ACTUAL=A8,
TITLE='PP WkCtr', DESCRIPTION='Object ID of PP work center', $
FIELDNAME=VIAUFKST_PROID, ALIAS=PROID, USAGE=A8, ACTUAL=A8,
TITLE='WBS elem.', DESCRIPTION='Work breakdown structure element (WBS element)', $
FIELDNAME=VIAUFKST_ANLNR, ALIAS=ANLNR, USAGE=A12, ACTUAL=A12,
TITLE='Asset', DESCRIPTION='Main asset number', $
FIELDNAME=VIAUFKST_ANLUN, ALIAS=ANLUN, USAGE=A4, ACTUAL=A4,
TITLE='Sub-number', DESCRIPTION='Asset sub-number', $
FIELDNAME=VIAUFKST_DAUFN, ALIAS=DAUFN, USAGE=A12, ACTUAL=A12,
TITLE='StdgOrd.', DESCRIPTION='Standing order number', $
FIELDNAME=VIAUFKST_GLTRP, ALIAS=GLTRP, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Basic fin.', DESCRIPTION='Basic finish date', $
FIELDNAME=VIAUFKST_GSTRP, ALIAS=GSTRP, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Bas. start', DESCRIPTION='Basic start date', $
FIELDNAME=VIAUFKST_FTRMS, ALIAS=FTRMS, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Release', DESCRIPTION='Scheduled release date', $
FIELDNAME=VIAUFKST_GLTRS, ALIAS=GLTRS, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Sched.Fin.', DESCRIPTION='Scheduled finish', $
FIELDNAME=VIAUFKST_GSTRS, ALIAS=GSTRS, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='SchedStart', DESCRIPTION='Scheduled start', $
FIELDNAME=VIAUFKST_GSTRI, ALIAS=GSTRI, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Act. start', DESCRIPTION='Actual start date', $
FIELDNAME=VIAUFKST_GETRI, ALIAS=GETRI, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Act.finish', DESCRIPTION='Confirmed order finish date', $
FIELDNAME=VIAUFKST_GLTRI, ALIAS=GLTRI, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Act.finish', DESCRIPTION='Actual finish date', $
FIELDNAME=VIAUFKST_FTRMI, ALIAS=FTRMI, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Release', DESCRIPTION='Actual release date', $
FIELDNAME=VIAUFKST_FTRMP, ALIAS=FTRMP, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Plan. rel.', DESCRIPTION='Planned release date', $
FIELDNAME=VIAUFKST_RSNUM, ALIAS=RSNUM, USAGE=A10, ACTUAL=A10,
TITLE='Reserv.no.', DESCRIPTION='Number of reservation/dependent requirements', $
FIELDNAME=VIAUFKST_GASMG, ALIAS=GASMG, USAGE=P15.3, ACTUAL=P7,
TITLE='Scrap', DESCRIPTION='Total scrap quantity in the order', $
FIELDNAME=VIAUFKST_GAMNG, ALIAS=GAMNG, USAGE=P15.3, ACTUAL=P7,
TITLE='Target qty', DESCRIPTION='Total order quantity', $
FIELDNAME=VIAUFKST_GMEIN, ALIAS=GMEIN, USAGE=A3, ACTUAL=A3,
TITLE='Unit', DESCRIPTION='Base unit of measure', $
FIELDNAME=VIAUFKST_PLNBEZ, ALIAS=PLNBEZ, USAGE=A18, ACTUAL=A18,
TITLE='Material', DESCRIPTION='Material number', $
FIELDNAME=VIAUFKST_PLNTY, ALIAS=PLNTY, USAGE=A1, ACTUAL=A1,
TITLE='Type', DESCRIPTION='Task list type', $
FIELDNAME=VIAUFKST_PLNNR, ALIAS=PLNNR, USAGE=A8, ACTUAL=A8,
TITLE='Group', DESCRIPTION='Key for task list group', $
FIELDNAME=VIAUFKST_PLNAW, ALIAS=PLNAW, USAGE=A1, ACTUAL=A1,
TITLE='Applicatn', DESCRIPTION='Application of the task list', $
FIELDNAME=VIAUFKST_PLNAL, ALIAS=PLNAL, USAGE=A2, ACTUAL=A2,
TITLE='Grp. ct.', DESCRIPTION='Group counter', $
FIELDNAME=VIAUFKST_PVERW, ALIAS=PVERW, USAGE=A3, ACTUAL=A3,
TITLE='Usage', DESCRIPTION='Task list usage', $
FIELDNAME=VIAUFKST_PLAUF, ALIAS=PLAUF, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='RtgTransf.', DESCRIPTION='Date for routing transfer', $
FIELDNAME=VIAUFKST_PLSVB, ALIAS=PLSVB, USAGE=P15.3, ACTUAL=P7,
TITLE='To LotSize', DESCRIPTION='To lot size', $
FIELDNAME=VIAUFKST_PLNME, ALIAS=PLNME, USAGE=A3, ACTUAL=A3,
TITLE='TskL unit', DESCRIPTION='Task list unit of measure', $
FIELDNAME=VIAUFKST_PLSVN, ALIAS=PLSVN, USAGE=P15.3, ACTUAL=P7,
TITLE='FrmLotSize', DESCRIPTION='From lot size', $
FIELDNAME=VIAUFKST_PDATV, ALIAS=PDATV, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Valid from', DESCRIPTION='Valid-from date', $
FIELDNAME=VIAUFKST_PAENR, ALIAS=PAENR, USAGE=A12, ACTUAL=A12,
TITLE='Change no.', DESCRIPTION='Change number', $
FIELDNAME=VIAUFKST_PLGRP, ALIAS=PLGRP, USAGE=A3, ACTUAL=A3,
TITLE='PlannerGrp', DESCRIPTION='Responsible planner group/department', $
FIELDNAME=VIAUFKST_LODIV, ALIAS=LODIV, USAGE=P15.3, ACTUAL=P7,
TITLE='LotSzeDiv', DESCRIPTION='Lot size divisor', $
FIELDNAME=VIAUFKST_STLTY, ALIAS=STLTY, USAGE=A1, ACTUAL=A1,
TITLE='BOM cat', DESCRIPTION='BOM category', $
FIELDNAME=VIAUFKST_STLBEZ, ALIAS=STLBEZ, USAGE=A18, ACTUAL=A18,
TITLE='Material', DESCRIPTION='Material number', $
FIELDNAME=VIAUFKST_STLST, ALIAS=STLST, USAGE=A2, ACTUAL=A2,
TITLE='BOM status', DESCRIPTION='BOM status', $
FIELDNAME=VIAUFKST_STLNR, ALIAS=STLNR, USAGE=A8, ACTUAL=A8,
TITLE='BOM', DESCRIPTION='Bill of material', $
FIELDNAME=VIAUFKST_SDATV, ALIAS=SDATV, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Valid from', DESCRIPTION='Valid-from date', $
FIELDNAME=VIAUFKST_SBMNG, ALIAS=SBMNG, USAGE=P15.3, ACTUAL=P7,
TITLE='Base qty', DESCRIPTION='Base quantity', $
FIELDNAME=VIAUFKST_SBMEH, ALIAS=SBMEH, USAGE=A3, ACTUAL=A3,
TITLE='Unit', DESCRIPTION='Base unit of measure', $
FIELDNAME=VIAUFKST_SAENR, ALIAS=SAENR, USAGE=A12, ACTUAL=A12,
TITLE='Change no.', DESCRIPTION='Change number', $
FIELDNAME=VIAUFKST_STLAL, ALIAS=STLAL, USAGE=A2, ACTUAL=A2,
TITLE='Alt. BOM', DESCRIPTION='Alternative BOM', $
FIELDNAME=VIAUFKST_STLAN, ALIAS=STLAN, USAGE=A1, ACTUAL=A1,
TITLE='BOM usage', DESCRIPTION='BOM usage', $
FIELDNAME=VIAUFKST_SLSVN, ALIAS=SLSVN, USAGE=P15.3, ACTUAL=P7,
TITLE='Frm lot sz', DESCRIPTION='From lot size', $
FIELDNAME=VIAUFKST_SLSBS, ALIAS=SLSBS, USAGE=P15.3, ACTUAL=P7,
TITLE='to', DESCRIPTION='To lot size', $
FIELDNAME=VIAUFKST_AUFLD, ALIAS=AUFLD, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Expl. date', DESCRIPTION='Date of BOM explosion/routing transfer', $
FIELDNAME=VIAUFKST_DISPO, ALIAS=DISPO, USAGE=A3, ACTUAL=A3,
TITLE='MRP ctrlr', DESCRIPTION='MRP controller for the order', $
FIELDNAME=VIAUFKST_AUFPL, ALIAS=AUFPL, USAGE=A10, ACTUAL=A10,
TITLE='Routing no', DESCRIPTION='Routing number for operations in the order', $
FIELDNAME=VIAUFKST_FEVOR, ALIAS=FEVOR, USAGE=A3, ACTUAL=A3,
TITLE='ProdSched.', DESCRIPTION='Production scheduler', $
FIELDNAME=VIAUFKST_FHORI, ALIAS=FHORI, USAGE=A3, ACTUAL=A3,
TITLE='SM key', DESCRIPTION='Scheduling Margin Key for Floats', $
FIELDNAME=VIAUFKST_TERKZ, ALIAS=TERKZ, USAGE=A1, ACTUAL=A1,
TITLE='SchedType', DESCRIPTION='Scheduling type', $
FIELDNAME=VIAUFKST_REDKZ, ALIAS=REDKZ, USAGE=A1, ACTUAL=A1,
TITLE='RedInd', DESCRIPTION='Reduction indicator for scheduling', $
FIELDNAME=VIAUFKST_APRIO, ALIAS=APRIO, USAGE=A1, ACTUAL=A1,
TITLE='Priority', DESCRIPTION='Order priority', $
FIELDNAME=VIAUFKST_AUFNT, ALIAS=AUFNT, USAGE=A12, ACTUAL=A12,
TITLE='Subntwk of', DESCRIPTION='Number of superior network', $
FIELDNAME=VIAUFKST_AUFPT, ALIAS=AUFPT, USAGE=A10, ACTUAL=A10,
TITLE='Routing no', DESCRIPTION='Routing number for operations in the order', $
FIELDNAME=VIAUFKST_APLZT, ALIAS=APLZT, USAGE=A8, ACTUAL=A8,
TITLE='Counter', DESCRIPTION='General counter for order', $
FIELDNAME=VIAUFKST_PROFID, ALIAS=PROFID, USAGE=A7, ACTUAL=A7,
TITLE='Profile', DESCRIPTION='Network profile', $
FIELDNAME=VIAUFKST_VORGZ, ALIAS=VORGZ, USAGE=A3, ACTUAL=A3,
TITLE='FlBefProd.', DESCRIPTION='Float before production (in days)', $
FIELDNAME=VIAUFKST_SICHZ, ALIAS=SICHZ, USAGE=A3, ACTUAL=A3,
TITLE='FlAftProd.', DESCRIPTION='Float after production (in days)', $
FIELDNAME=VIAUFKST_FREIZ, ALIAS=FREIZ, USAGE=A3, ACTUAL=A3,
TITLE='ReleasPer.', DESCRIPTION='Release period (in days)', $
FIELDNAME=VIAUFKST_UPTER, ALIAS=UPTER, USAGE=A1, ACTUAL=A1,
TITLE='Dates chgd', DESCRIPTION='Indicator: Scheduled dates changed', $
FIELDNAME=VIAUFKST_BEDID, ALIAS=BEDID, USAGE=A12, ACTUAL=A12,
TITLE='ID no.', DESCRIPTION='ID of the capacity requirements record', $
FIELDNAME=VIAUFKST_PRONR, ALIAS=PRONR, USAGE=A8, ACTUAL=A8,
TITLE='Proj.def.', DESCRIPTION='Project definition', $
FIELDNAME=VIAUFKST_ZAEHL, ALIAS=ZAEHL, USAGE=A8, ACTUAL=A8,
TITLE='Counter', DESCRIPTION='Internal counter', $
FIELDNAME=VIAUFKST_MZAEHL, ALIAS=MZAEHL, USAGE=A8, ACTUAL=A8,
TITLE='Counter', DESCRIPTION='Internal counter', $
FIELDNAME=VIAUFKST_ZKRIZ, ALIAS=ZKRIZ, USAGE=A7, ACTUAL=A7,
TITLE='AddCritCt', DESCRIPTION='Counter for additional criteria', $
FIELDNAME=VIAUFKST_PRUEFLOS, ALIAS=PRUEFLOS, USAGE=A12, ACTUAL=A12,
TITLE='Insp. lot', DESCRIPTION='Inspection Lot Number', $
FIELDNAME=VIAUFKST_KLVARP, ALIAS=KLVARP, USAGE=A4, ACTUAL=A4,
TITLE='CstgVarPln', DESCRIPTION='Costing variant for planned costs', $
FIELDNAME=VIAUFKST_KLVARI, ALIAS=KLVARI, USAGE=A4, ACTUAL=A4,
TITLE='CstgVarAct', DESCRIPTION='Costing variant for actual costs', $
FIELDNAME=VIAUFKST_RGEKZ, ALIAS=RGEKZ, USAGE=A1, ACTUAL=A1,
TITLE='Backflush', DESCRIPTION='Indicator: Backflushing for order', $
FIELDNAME=VIAUFKST_PLART, ALIAS=PLART, USAGE=A1, ACTUAL=A1,
TITLE='SchedBasis', DESCRIPTION='Basis for scheduling', $
FIELDNAME=VIAUFKST_MAUFNR, ALIAS=MAUFNR, USAGE=A12, ACTUAL=A12,
TITLE='SuperOrder', DESCRIPTION='Number of superior order', $
FIELDNAME=VIAUFKST_LEAD_AUFNR, ALIAS=LEAD_AUFNR, USAGE=A12, ACTUAL=A12,
TITLE='LeadgOrder', DESCRIPTION='Leading order in current processing', $
FIELDNAME=VIAUFKST_OWNER, ALIAS=OWNER, USAGE=A1, ACTUAL=A1,
TITLE='Object ref', DESCRIPTION='Object reference indicator', $
FIELDNAME=VIAUFKST_VKORG, ALIAS=VKORG, USAGE=A4, ACTUAL=A4,
TITLE='Sales org.', DESCRIPTION='Sales organization', $
FIELDNAME=VIAUFKST_VTWEG, ALIAS=VTWEG, USAGE=A2, ACTUAL=A2,
TITLE='Distr. chl', DESCRIPTION='Distribution channel', $
FIELDNAME=VIAUFKST_SPART, ALIAS=SPART, USAGE=A2, ACTUAL=A2,
TITLE='Division', DESCRIPTION='Division', $
FIELDNAME=VIAUFKST_GLUZP, ALIAS=GLUZP, USAGE=A6, ACTUAL=A6,
TITLE='Basic fin.', DESCRIPTION='Basic finish (time)', $
FIELDNAME=VIAUFKST_GSUZP, ALIAS=GSUZP, USAGE=A6, ACTUAL=A6,
TITLE='BasicStart', DESCRIPTION='Basic start time', $
FIELDNAME=VIAUFKST_GLUZS, ALIAS=GLUZS, USAGE=A6, ACTUAL=A6,
TITLE='Finish tme', DESCRIPTION='Scheduled finish time', $
FIELDNAME=VIAUFKST_GSUZS, ALIAS=GSUZS, USAGE=A6, ACTUAL=A6,
TITLE='BasicStart', DESCRIPTION='Scheduled start time', $
FIELDNAME=VIAUFKST_GEUZI, ALIAS=GEUZI, USAGE=A6, ACTUAL=A6,
TITLE='Act.finish', DESCRIPTION='Confirmed order finish (time)', $
FIELDNAME=VIAUFKST_GSUZI, ALIAS=GSUZI, USAGE=A6, ACTUAL=A6,
TITLE='ActStart', DESCRIPTION='Actual start time', $
FIELDNAME=VIAUFKST_ADRNR_ILOA, ALIAS=ADRNR_ILOA, USAGE=A10, ACTUAL=A10,
TITLE='Addr. no.', DESCRIPTION='Address number', $
FIELDNAME=VIAUFKST_NO_DISP, ALIAS=NO_DISP, USAGE=A1, ACTUAL=A1,
TITLE='Eff.MatPlg', DESCRIPTION='Effective for Materials Planning', $
When I select Check, it returned:
0 NUMBER OF ERRORS= 0
NUMBER OF SEGMENTS= 1 ( REAL= 1 VIRTUAL= 0 )
NUMBER OF FIELDS= 202 INDEXES= 0 FILES= 1
TOTAL LENGTH OF ALL FIELDS= 1321
WebFOCUS 7.7.03 Windows, All Outputs
Guru quote:
VIAUFKST_GSTRS
Can you please post the segment of code that is causing this error?
WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit
Platinum Member This is the code:
JOIN
LEFT_OUTER SAP_VIAUFKST.VIAUFKST.VIAUFKST_EQUNR IN SAP_VIAUFKST TO UNIQUE
SAP_EQUI.EQUI.EQUI_EQUNR IN SAP_EQUI TAG J0 AS J0
END
JOIN
LEFT_OUTER SAP_VIAUFKST.VIAUFKST.VIAUFKST_WERKS
AND SAP_VIAUFKST.VIAUFKST.VIAUFKST_OBJNR IN SAP_VIAUFKST TO UNIQUE
SAP_CRHD.CRHD.CRHD_WERKS AND SAP_CRHD.CRHD.CRHD_OBJID IN SAP_CRHD TAG J1 AS J1
END
JOIN
LEFT_OUTER SAP_VIAUFKST.VIAUFKST.VIAUFKST_AUFPL IN SAP_VIAUFKST TO UNIQUE
SAP_VIAFVC.VIAFVC.VIAFVC_AUFPL IN SAP_VIAFVC TAG J2 AS J2
END
JOIN
LEFT_OUTER SAP_VIAUFKST.VIAUFKST.VIAUFKST_AUFNR IN SAP_VIAUFKST TO UNIQUE
SAP_RESB.RESB.RESB_AUFNR IN SAP_RESB TAG J3 AS J3
END
JOIN
LEFT_OUTER SAP_VIAUFKST.VIAUFKST.VIAUFKST_OBJNR IN SAP_VIAUFKST TO UNIQUE
SAP_JEST.JEST.JEST_OBJNR IN SAP_JEST TAG J4 AS J4
END
JOIN
LEFT_OUTER SAP_VIAUFKST.VIAUFKST.VIAUFKST_EQUNR IN SAP_VIAUFKST TO UNIQUE
SAP_V_EQUI.V_EQUI.V_EQUI_EQUNR IN SAP_V_EQUI TAG J5 AS J5
END
DEFINE FILE SAP_VIAUFKST
ST/A4=
IF J4.JEST.JEST_STAT EQ 'I0001' THEN 'CRTD'
ELSE IF J4.JEST.JEST_STAT EQ 'I0002' THEN 'REL'
ELSE IF J4.JEST.JEST_STAT EQ 'I0045' THEN 'TECO'
ELSE 'CLSD';
END
TABLE FILE SAP_VIAUFKST
PRINT
J5.V_EQUI.V_EQUI_TIDNR AS 'Technical ID'
SAP_VIAUFKST.VIAUFKST.VIAUFKST_AUFNR AS 'Work Order'
SAP_VIAUFKST.VIAUFKST.VIAUFKST_GSTRS AS 'Schedule Start'
J4.JEST.ST
SAP_VIAUFKST.VIAUFKST.VIAUFKST_PRIOK
SAP_VIAUFKST.VIAUFKST.VIAUFKST_TPLNR AS 'Functional Location'
SAP_VIAUFKST.VIAUFKST.VIAUFKST_KTEXT AS 'Description'
J1.CRHD.CRHD_ARBPL AS 'Work Center Skill '
J3.RESB.RESB_ERFMG AS 'Work (Req Q)'
J3.RESB.RESB_ENMNG AS 'No (GR/GI)'
J3.RESB.RESB_ENMNG AS 'Dur (UnrUse)'
J3.RESB.RESB_BDMNG AS 'Actl (Res)'
ON TABLE SUBHEAD
"PM WORK ORDER REPORT"
"PLANT <SAP_VIAUFKST.VIAUFKST.VIAUFKST_WERKS "
"BREAKING ON No Grouping"
WHERE J4.JEST.JEST_STAT EQ '&JEST_STAT.(<Outstanding,I0001>,<In Process,I0002>,<Completed,I0045>,<Closed,I0046>).JEST_STAT.';
WHERE ( SAP_VIAUFKST.VIAUFKST.VIAUFKST_WERKS EQ &VIAUFKST_WERKS.(OR(<ALL,_FOC_NULL>,<0015,0015>,<0016,0016>,<0173,0173>,<0195,0195>,<4147,4147>,<4237,4237>,<4259,4259>,<4832,4832>,<6280,6280>,<8005,8005>,<8202,8202>)).VIAUFKST_WERKS. ) AND ( SAP_VIAUFKST.VIAUFKST.VIAUFKST_TPLNR CONTAINS '&VIAUFKST_TPLNR' ) AND ( SAP_VIAUFKST.VIAUFKST.VIAUFKST_REVNR CONTAINS '&VIAUFKST_REVNR' ) AND ( J1.CRHD.CRHD_ARBPL CONTAINS '&CRHD_ARBPL' ) AND ( SAP_VIAUFKST.VIAUFKST.VIAUFKST_INGPR CONTAINS '&VIAUFKST_INGPR' ) AND ( SAP_VIAUFKST.VIAUFKST.VIAUFKST_GSTRS GE '&VIAUFKST_GSTRS' ) AND ( SAP_VIAUFKST.VIAUFKST.VIAUFKST_GSTRS LE '&VIAUFKST_GSTRS_TO' );
WHERE ( SAP_VIAUFKST.VIAUFKST.VIAUFKST_AUFNR CONTAINS '&VIAUFKST_AUFNR' ) AND ( SAP_VIAUFKST.VIAUFKST.VIAUFKST_AUART EQ &VIAUFKST_AUART.(OR(<ALL,_FOC_NULL>,<0010,0010>,<0020,0020>,<0030,0030>,<0040,0040>,<0060,0060>,<0100,0100>,<0110,0110>,<0120,0120>,<0150,0150>)).VIAUFKST_AUART. ) AND ( SAP_VIAUFKST.VIAUFKST.VIAUFKST_PRIOK CONTAINS '&VIAUFKST_PRIOK' ) AND ( SAP_VIAUFKST.VIAUFKST.VIAUFKST_PLKNZ CONTAINS '&VIAUFKST_PLKNZ' ) AND ( J0.EQUI.EQUI_EQART CONTAINS '&EQUI_EQART' ) AND ( SAP_VIAUFKST.VIAUFKST.VIAUFKST_PSPEL CONTAINS '&VIAUFKST_PSPEL' );
WHERE ( J2.VIAFVC.VIAFVC_VORNR EQ '&VIAFVC_VORNR' ) AND ( J2.VIAFVC.VIAFVC_FSAVD GE '&VIAFVC_FSAVD' ) AND ( SAP_VIAUFKST.VIAUFKST.VIAUFKST_ANLZU EQ '&VIAUFKST_ANLZU' ) AND ( J1.CRHD.CRHD_STEUS EQ '&CRHD_STEUS' ) AND ( J2.VIAFVC.VIAFVC_FSAVD LE '&VIAFVC_FSAVD_TO' );
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT &WFFMT.(<HTML,HTML>,<PDF,PDF>,<Excel 2000,EXL2K>,<Excel Formula,EXL2K FORMULA>,<HTML Active Report,AHTML>,<Active Report for Adobe Flash Player,FLEX>,<Active Report for PDF,APDF>,<PowerPoint,PPT>).Select type of display output.
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=REPORT,
GRAPHCOLOR='GREEN',
$
ENDSTYLE
END
WebFOCUS 7.7.03 Windows, All Outputs
Guru what are the values in
'&VIAUFKST_GSTRS' AND
'&VIAUFKST_GSTRS_TO' ?
WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit
Platinum Member I put '2014/09/01' and '2014/09/19'.
WebFOCUS 7.7.03 Windows, All Outputs
Guru Are you comparing a literal to a system date?
Try using the DT function in your date compare
SAP_VIAUFKST.VIAUFKST.VIAUFKST_GSTRS GE DT(&VIAUFKST_GSTRS 00:00:00:000)
WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit
Member Sometimes I get this when the data in the database table does not match the MFD format.
Sometimes its corrupted data in the table sometimes its just a mis-match between MFD's and what is actually in the table itself.
The wizard will best guess the format of the field .. typically when you make MFD against a database view. Check you data in that column in that table verify none of the value are outside the MFD's format for that field
WebFOCUS 7.6 Windows, All Outputs
Virtuoso My view would be incorrect data format, as gfink01 stated. This can, and does, happen within SAP. Just a full data check by changing MFD field from DATE to alpha.
Alan. WF 7.705/8.007
Posts: 1451 | Location: Portugal | Registered: February 07, 2007
IP
Platinum Member RSquared, I tried your suggestion but I got this error :
(FOC006) THE FORMAT OF THE TEST VALUE IS INCONSISTENT WITH FIELD FORMAT: 2014/01/01 00:00:00:000
WebFOCUS 7.7.03 Windows, All Outputs
Guru try it without the seconds (00:00:00:000). our format for Dates includes milliseconds.
WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit
Platinum Member Without the seconds (00:00:00:000), it works but I can get error: (FOC1426) DATA ELEMENT VALUE TOO BIG FOR SEGMENT/FIELD :VIAUFKST/VIAUFKST_GSTRS
WebFOCUS 7.7.03 Windows, All Outputs
Please Wait. Your request is being processed...
Read-Only TopicCopyright © 1996-2020 Information Builders