P_AFVG
P_AFVG is a CDS View in S/4HANA. It contains 303 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /MERP/PP_PO_OPERATION | view | from | Production Order Operation | |
| I_OrderOperation | view | from | BASIC | Order Operation |
| P_MfgOrderOperation | view | inner | BASIC |
Fields (303)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | aplzl | OrderIntBillOfOperationsItem,OrderOperationInternalID | 3 |
| KEY | aufpl | OrderInternalBillOfOperations,OrderInternalID | 3 |
| ablad | UnloadingPointName | 1 | |
| abrue | OpPlannedTeardownDurn | 1 | |
| aennr | ChangeNumber | 1 | |
| afnam | OperationRequisitionerName | 1 | |
| anfko | RequestingCostCenter | 1 | |
| anlzu | OperationSystemCondition | 1 | |
| anzma | NumberOfEmployees | 1 | |
| anzzl | NumberOfCapacities | 1 | |
| aplfl | ManufacturingOrderSequence,Sequence | 3 | |
| arbeh | OpWorkQuantityUnit | 1 | |
| arbei | OpPlannedWorkQuantity | 1 | |
| arbid | WorkCenterInternalID | 3 | |
| arbty | WorkCenterTypeCode | 2 | |
| arbty2 | WorkCenterTypeCode_2 | 1 | |
| aruze | OpPlannedTeardownDurnUnit | 1 | |
| asvrg | OpPlannedScrapQuantity | 1 | |
| aufak | OperationScrapPercent | 1 | |
| aufkt | NumberOfOperationExecutions | 1 | |
| banfn | PurchaseRequisition | 1 | |
| bearp | ForecastProcessingDuration | 1 | |
| bearz | OpPlannedProcessingDurn | 1 | |
| beaze | OpPlannedProcessingDurnUnit | 1 | |
| beazp | ForecastProcessingDurationUnit | 1 | |
| bedid | CapacityRequirement | 1 | |
| bednr | OperationTrackingNumber | 1 | |
| bedzl | CapacityRequirementItem | 1 | |
| bmsch | OperationReferenceQuantity | 1 | |
| bnfpo | PurchaseRequisitionItem | 1 | |
| bukrs | CompanyCode | 1 | |
| bzoffb | StartDateOffsetReferenceCode | 1 | |
| bzoffe | EndDateOffsetReferenceCode | 1 | |
| cuobj_arb | ProductConfiguration | 1 | |
| daume | MinimumDurationUnit | 1 | |
| daumi | MinimumDuration | 1 | |
| daune | OperationStandardDurationUnit | 1 | |
| dauno | OperationStandardDuration | 1 | |
| ebeln | PurchasingDocument | 1 | |
| ebelp | PurchasingDocumentItem | 1 | |
| ehoffb | StartDateOffsetDurationUnit | 1 | |
| ehoffe | EndDateOffsetDurationUnit | 1 | |
| einsa | ActyBscStartDateConstraintType | 1 | |
| einse | ActyBscEndDateConstraintType | 1 | |
| ekgrp | PurchasingGroup | 1 | |
| ekorg | PurchasingOrganization | 1 | |
| epanf | OpDispatchedExecStartDate | 1 | |
| epanz | OpDispatchedExecStartTime | 1 | |
| epend | OpDispatchedExecEndDate | 1 | |
| epenz | OpDispatchedExecEndTime | 1 | |
| equnr | Equipment | 1 | |
| esokz | PurchasingInfoRecordCategory | 1 | |
| evgew | ProgressAnlysAggregationWeight | 1 | |
| ewdam | ForecastedMinimumDuration | 1 | |
| ewdan | ForecastedStandardDuration | 1 | |
| ewdme | ForecastedMinimumDurationUnit | 1 | |
| ewdne | FcstdStandardDurationUnit | 1 | |
| ewend | ForecastedEndDate | 1 | |
| ewenz | ForecastedEndTime | 1 | |
| ewsta | ActyFcstStartDteConstraintType | 1 | |
| ewstd | ForecastedStartDate | 1 | |
| ewste | ActyFcstEndDateConstraintType | 1 | |
| ewstz | ForecastedStartTime | 1 | |
| flies | OperationsIsAlwaysOverlapping | 1 | |
| fpavd | SchedldFcstdEarliestStartDate | 1 | |
| fpavz | SchedldFcstdEarliestStartTime | 1 | |
| fpedd | SchedldFcstdEarliestEndDate | 1 | |
| fpedz | SchedldFcstdEarliestEndTime | 1 | |
| fplnr | BillingPlan | 1 | |
| frdlb | ExtProcgOperationHasSubcontrg | 1 | |
| fsavd | OpErlstSchedldExecStrtDte | 2 | |
| fsavz | OpErlstSchedldExecStrtTme | 1 | |
| fsedd | OpErlstSchedldExecEndDte | 2 | |
| fsedz | OpErlstSchedldExecEndTme | 1 | |
| fseld | EarliestScheduledWaitEndDate | 1 | |
| fselz | EarliestScheduledWaitEndTime | 1 | |
| fssad | OpErlstSchedldTrdwnStrtDte | 1 | |
| fssaz | OpErlstSchedldTrdwnStrtTme | 1 | |
| fssbd | OpErlstSchedldProcgStrtDte | 1 | |
| fssbz | OpErlstSchedldProcgStrtTme | 1 | |
| fssld | EarliestScheduledWaitStartDate | 1 | |
| fsslz | EarliestScheduledWaitStartTime | 1 | |
| func_area | FunctionalArea | 1 | |
| gmnga | OpTotConfdYieldQtyInOrdQtyUnit | 1 | |
| gsber | BusinessArea | 1 | |
| ieavd | OperationConfirmedEndDate | 1 | |
| iebd | OpActualProcessingEndDate | 1 | |
| iebz | OpActualProcessingEndTime | 1 | |
| iedd | OpActualExecutionEndDate | 3 | |
| iedz | OpActualExecutionEndTime | 3 | |
| ierd | OpActualSetupEndDate | 1 | |
| ierz | OpActualSetupEndTime | 1 | |
| ile01 | OpWorkQuantityUnit1 | 1 | |
| ile02 | OpWorkQuantityUnit2 | 1 | |
| ile03 | OpWorkQuantityUnit3 | 1 | |
| ile04 | OpWorkQuantityUnit4 | 1 | |
| ile05 | OpWorkQuantityUnit5 | 1 | |
| ile06 | OpWorkQuantityUnit6 | 1 | |
| indet | OperationCalculationControl | 1 | |
| infnr | PurchasingInfoRecord | 1 | |
| ipre1 | BusinessProcessEntryUnit | 1 | |
| iprk1 | NoFurtherBusinessProcQtyIsExpd | 1 | |
| iprz1 | BusinessProcessConfirmedQty | 1 | |
| isad | OpActualTeardownStartDate | 1 | |
| isavd | OperationConfirmedStartDate | 1 | |
| isaz | OpActualTeardownStartTme | 1 | |
| isbd | OpActualProcessingStartDate | 1 | |
| isbz | OpActualProcessingStartTime | 1 | |
| isdd | OpActualExecutionStartDate | 3 | |
| isdz | OpActualExecutionStartTime | 3 | |
| iserh | ConfirmedBreakDuration | 1 | |
| ism02 | OpConfirmedWorkQuantity2 | 1 | |
| ism03 | OpConfirmedWorkQuantity3 | 1 | |
| ism04 | OpConfirmedWorkQuantity4 | 1 | |
| ism05 | OpConfirmedWorkQuantity5 | 1 | |
| ism06 | OpConfirmedWorkQuantity6 | 1 | |
| ismnw | ActualWorkQuantity | 1 | |
| istkn | BillOfMaterialItemNodeNumber | 1 | |
| istnr | BillOfMaterialInternalID | 1 | |
| istpo | BOMItemNodeCount | 1 | |
| istru | Assembly | 1 | |
| istty | BillOfMaterialCategory | 1 | |
| kalid | FactoryCalendar | 2 | |
| kalnr | CostEstimate | 1 | |
| kalsm | CostingSheet | 1 | |
| klvar | CostingVariant | 1 | |
| knobj | DependencyObjectNumber | 1 | |
| ktsch | StandardTextInternalID | 1 | |
| kzfix | PurgInfoRecdDataIsFixed | 1 | |
| lar01 | CostCtrActivityType1 | 1 | |
| lar02 | CostCtrActivityType2 | 1 | |
| lar03 | CostCtrActivityType3 | 1 | |
| lar04 | CostCtrActivityType4 | 1 | |
| lar05 | CostCtrActivityType5 | 1 | |
| lar06 | CostCtrActivityType6 | 1 | |
| larnt | CostCtrActivityType | 1 | |
| lek02 | NoFurtherOpWorkQuantity2IsExpd | 1 | |
| lek03 | NoFurtherOpWorkQuantity3IsExpd | 1 | |
| lek04 | NoFurtherOpWorkQuantity4IsExpd | 1 | |
| lek05 | NoFurtherOpWorkQuantity5IsExpd | 1 | |
| lek06 | NoFurtherOpWorkQuantity6IsExpd | 1 | |
| leknw | NoFurtherWorkQuantityIsExpd | 1 | |
| liegz | ScheduledWaitDuration | 1 | |
| lifnr | Supplier | 1 | |
| ligze | ScheduledWaitDurationUnit | 1 | |
| lmnga | OpTotalConfirmedYieldQty | 2 | |
| loanz | NumberOfTimeTickets | 1 | |
| loart | EmployeeWageType | 1 | |
| loekz | OperationIsToBeDeleted | 1 | |
| logrp | EmployeeWageGroup | 1 | |
| ltxa1 | OperationText | 2 | |
| maintordopprocessphasecode | MaintOrdOpProcessPhaseCode | 1 | |
| maintordopprocesssubphasecode | MaintOrdOpProcessSubPhaseCode | 1 | |
| matkl | MaterialGroup | 1 | |
| meinh | OperationUnit | 2 | |
| mgvrg | OpPlannedTotalQuantity | 2 | |
| mlstn | UsageCode | 1 | |
| no_disp | MaterialPlanningRelevance | 1 | |
| nprio | OperationImportance | 1 | |
| ntanf | ConstraintDateForBscStartDate | 1 | |
| ntanz | ConstraintTimeForBscStartTime | 1 | |
| oan_inst_id_produce | ProduceOpActyNtwkInstance | 1 | |
| oan_inst_id_setup | SetupOpActyNtwkInstance | 1 | |
| oan_inst_id_teardown | TeardownOpActyNtwkInstance | 1 | |
| objektid | LineHierarchyInternalID | 1 | |
| objnr | ObjectInternalID | 2 | |
| offstb | StartDateOffsetDuration | 1 | |
| offste | EndDateOffsetDuration | 1 | |
| ofm02 | ForecastWorkQuantity2 | 1 | |
| ofm03 | ForecastWorkQuantity3 | 1 | |
| ofm04 | ForecastWorkQuantity4 | 1 | |
| ofm05 | ForecastWorkQuantity5 | 1 | |
| ofm06 | ForecastWorkQuantity6 | 1 | |
| ofmnw | ForecastWorkQuantity | 1 | |
| opre1 | BusinessProcRemainingQtyUnit | 1 | |
| oprz1 | BusinessProcessRemainingQty | 1 | |
| packno | ServicePackage | 1 | |
| pdae | ActualForecastDurationUnit | 1 | |
| pdau | ActualForecastDuration | 1 | |
| pedd | ActualForecastEndDate | 1 | |
| pedz | ActualForecastEndTime | 1 | |
| peinh | OpExternalProcessingPriceUnit | 1 | |
| pernr | OperationPersonResponsible,Personnel | 1 | |
| phflg | MfgOrderOperationIsPhase | 1 | |
| phseq | ControlRecipeDestination | 1 | |
| plifz | PlannedDeliveryDuration | 1 | |
| plnal | BillOfOperationsVariant | 1 | |
| plnfl | BillOfOperationsSequence | 1 | |
| plnkn | BOOOperationInternalID | 1 | |
| plnnr | BillOfOperationsGroup | 1 | |
| plnty | BillOfOperationsType | 1 | |
| pprio | NetworkActivityPriority | 1 | |
| prctr | ProfitCenter | 1 | |
| preis | OpExternalProcessingPrice | 1 | |
| prkst | NetworkActivityCost | 1 | |
| prz01 | BusinessProcess | 1 | |
| prznt | OperationWorkPercent | 1 | |
| puffp | ForecastedDatesFreeFloat | 1 | |
| puffr | BasicDatesFreeFloat | 1 | |
| pufgp | TotalFloatForForecastedDates | 1 | |
| pufgs | TotalFloatForBasicDates | 1 | |
| qpart | InspectionLotType | 1 | |
| qualf | EmployeeSuitability | 1 | |
| rasch | OperationSetupType | 1 | |
| rfgrp | OperationSetupGroupCategory | 1 | |
| rfpnt | ReferencePoint | 1 | |
| rfsch | OperationSetupGroup | 1 | |
| rmnga | OperationConfirmedReworkQty | 1 | |
| rmzhl | NumberOfOperationConfirmations | 1 | |
| rsanz | NumberOfConfirmationSlips | 1 | |
| rstra | LeadTimeReductionStrategy | 1 | |
| rstuf | OpSchedldReductionLevel | 1 | |
| rstze | OpPlannedSetupDurnUnit | 1 | |
| rueck | OperationConfirmation | 1 | |
| ruest | OpPlannedSetupDurn | 1 | |
| sakto | CostElement | 1 | |
| scope | ControllingObjectClass | 1 | |
| selkz | OperationCostingRelevancyType | 1 | |
| slwid | FreeDefinedTableFieldSemantic | 1 | |
| sortl | OperationPurgInfoRecdSearchTxt | 1 | |
| spanz | ActualNumberOfSplits | 1 | |
| spavd | LatestSchedldFcstdStartDate | 1 | |
| spavz | SchedldFcstdLatestStartTime | 1 | |
| spedd | LatestSchedldFcstdEndDate | 1 | |
| spedz | SchedldFcstdLatestEndTime | 1 | |
| splim | MaximumNumberOfSplits | 1 | |
| spmus | OperationSplitIsRequired | 1 | |
| ssavd | OpLtstSchedldExecStrtDte | 3 | |
| ssavz | OpLtstSchedldExecStrtTme | 3 | |
| ssedd | OpLtstSchedldExecEndDte | 3 | |
| ssedz | OpLtstSchedldExecEndTme | 3 | |
| sseld | LatestScheduledWaitEndDate | 1 | |
| sselz | LatestScheduledWaitEndTime | 1 | |
| sssad | OpLtstSchedldTrdwnStrtDte | 1 | |
| sssaz | OpLtstSchedldTrdwnStrtTme | 1 | |
| sssbd | OpLtstSchedldProcgStrtDte | 1 | |
| sssbz | OpLtstSchedldProcgStrtTme | 1 | |
| sssld | LatestScheduledWaitStartDate | 1 | |
| ssslz | LatestScheduledWaitStartTime | 1 | |
| steus | OperationControlProfile | 1 | |
| subsys | InspectionSubSystem | 1 | |
| sumnr | SuperiorOperationInternalID | 1 | |
| tl_versn | BillOfOperationsVersion | 1 | |
| tranz | ScheduledMoveDuration | 1 | |
| traze | ScheduledMoveDurationUnit | 1 | |
| txjcd | TaxJurisdiction | 1 | |
| txtsp | Language | 2 | |
| uekan | OperationOverlappingIsPossible | 1 | |
| uemus | OperationOverlappingIsRequired | 1 | |
| umren | OpQtyToBaseQtyDnmntr | 1 | |
| umrez | OpQtyToBaseQtyNmrtr | 1 | |
| use04 | FreeDefinedQuantity1Unit | 1 | |
| use05 | FreeDefinedQuantity2Unit | 1 | |
| use06 | FreeDefinedAmount1Currency | 1 | |
| use07 | FreeDefinedAmount2Currency | 1 | |
| usr00 | FreeDefinedAttribute01 | 1 | |
| usr01 | FreeDefinedAttribute02 | 1 | |
| usr02 | FreeDefinedAttribute03 | 1 | |
| usr03 | FreeDefinedAttribute04 | 1 | |
| usr04 | FreeDefinedQuantity1 | 1 | |
| usr05 | FreeDefinedQuantity2 | 1 | |
| usr06 | FreeDefinedAmount1 | 1 | |
| usr07 | FreeDefinedAmount2 | 1 | |
| usr08 | FreeDefinedDate1 | 1 | |
| usr09 | FreeDefinedDate2 | 1 | |
| usr10 | FreeDefinedIndicator1 | 1 | |
| usr11 | FreeDefinedIndicator2 | 1 | |
| vge02 | WorkCenterStandardWorkQtyUnit2 | 1 | |
| vge03 | WorkCenterStandardWorkQtyUnit3 | 1 | |
| vge04 | WorkCenterStandardWorkQtyUnit4 | 1 | |
| vge05 | WorkCenterStandardWorkQtyUnit5 | 1 | |
| vge06 | WorkCenterStandardWorkQtyUnit6 | 1 | |
| vgw02 | WorkCenterStandardWorkQty2 | 1 | |
| vgw03 | WorkCenterStandardWorkQty3 | 1 | |
| vgw04 | WorkCenterStandardWorkQty4 | 1 | |
| vgw05 | WorkCenterStandardWorkQty5 | 1 | |
| vgw06 | WorkCenterStandardWorkQty6 | 1 | |
| vgwts | StandardWorkFormulaParamGroup | 1 | |
| vornr | Operation | 2 | |
| waers | Currency | 1 | |
| wartz | ScheduledQueueDuration | 1 | |
| wempf | GoodsRecipientName | 1 | |
| werks | Plant,ProductionPlant | 3 | |
| wkurs | ExchangeRate | 1 | |
| wrtze | ScheduledQueueDurationUnit | 1 | |
| xmnga | OpTotalConfirmedScrapQty | 1 | |
| zeier | BreakDurationUnit | 1 | |
| zeilm | MaximumWaitDurationUnit | 1 | |
| zeilp | MinimumWaitDurationUnit | 1 | |
| zeimu | OverlapMinimumDurationUnit | 1 | |
| zeitm | MinimumMoveDurationUnit | 1 | |
| zeitn | StandardMoveDurationUnit | 1 | |
| zeiwm | MinimumQueueDurationUnit | 1 | |
| zeiwn | StandardQueueDurationUnit | 1 | |
| zlmax | MaximumWaitDuration | 1 | |
| zlpro | MinimumWaitDuration | 1 | |
| zmerh | PlannedBreakDuration | 1 | |
| zminu | OverlapMinimumDuration | 1 | |
| zschl | OverheadCode | 1 | |
| ztmin | MinimumMoveDuration | 1 | |
| ztnor | StandardMoveDuration | 1 | |
| zwmin | MinimumQueueDuration | 1 | |
| zwnor | StandardQueueDuration | 1 |
@AbapCatalog.sqlViewName: 'PPPAFVG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #BASIC
@VDM.private: true
// basic view to join the three data base tables for operations / activities
// it can be used as basis for PP, PM, PS, or QM order views
define view P_AFVG
as select from ( afvc as afvc
inner join afvv as afvv on afvc.aufpl = afvv.aufpl
and afvc.aplzl = afvv.aplzl
left outer to one join afvu as afvu on afvc.aufpl = afvu.aufpl
and afvc.aplzl = afvu.aplzl )
{
// key AFVC, AFVV, AFVU
key afvc.aufpl,
key afvc.aplzl,
// AFVC data
afvc.aplfl,
afvc.plnfl,
afvc.plnty,
afvc.plnnr,
afvc.plnal,
afvc.plnkn,
afvc.vornr,
afvc.sumnr,
afvc.steus,
afvc.arbid,
'A' as arbty,
'A ' as arbty2,
afvc.werks,
afvc.kalid,
afvc.bedid,
afvc.bedzl,
afvc.loekz,
afvc.ktsch,
afvc.ltxa1,
afvc.txtsp,
afvc.vplty,
afvc.vplnr,
afvc.vplal,
afvc.vplfl,
afvc.vgwts,
afvc.lar01,
afvc.lar02,
afvc.lar03,
afvc.lar04,
afvc.lar05,
afvc.lar06,
afvc.loanz,
afvc.loart,
afvc.logrp,
afvc.rsanz,
afvc.qualf,
afvc.anzma,
afvc.rfgrp,
afvc.rfsch,
afvc.rasch,
afvc.aufak,
afvc.uemus,
afvc.uekan,
afvc.flies,
afvc.spmus,
afvc.splim,
afvc.rstra,
afvc.sortl,
afvc.lifnr,
afvc.preis,
afvc.peinh,
afvc.waers,
afvc.sakto,
afvc.infnr,
afvc.esokz,
afvc.ekorg,
afvc.ekgrp,
afvc.kzlgf,
afvc.kzwrtf,
afvc.matkl,
afvc.ddehn,
afvc.anzzl,
afvc.prznt,
afvc.mlstn,
afvc.pprio,
afvc.bukrs,
afvc.gsber,
afvc.prctr,
afvc.klvar,
afvc.kalnr,
afvc.anfko,
afvc.anfkokrs,
afvc.indet,
afvc.larnt,
afvc.prkst,
afvc.rueck,
afvc.rmzhl,
afvc.projn,
afvc.objnr,
afvc.spanz,
afvc.banfn,
afvc.bnfpo,
afvc.ebeln,
afvc.ebelp,
afvc.wempf,
afvc.ablad,
afvc.clasf,
afvc.frunv,
afvc.zschl,
afvc.kalsm,
afvc.equnr,
afvc.tplnr,
afvc.lek01,
afvc.lek02,
afvc.lek03,
afvc.lek04,
afvc.lek05,
afvc.lek06,
afvc.selkz,
afvc.stdkn,
afvc.anlzu,
afvc.istru,
afvc.istty,
afvc.istnr,
afvc.istkn,
afvc.istpo,
afvc.iupoz,
afvc.ebort,
afvc.vertl,
afvc.leknw,
afvc.nprio,
afvc.pvzkn,
afvc.phflg,
afvc.phseq,
afvc.knobj,
afvc.otype,
afvc.objektid,
afvc.qlkapar,
afvc.rstuf,
afvc.subsys,
afvc.packno,
afvc.txjcd,
cast(afvc.scope as pph_scope preserving type) as scope, // due to ATC error CNVX
afvc.no_disp,
afvc.arbii,
afvc.werki,
afvc.qkzprzeit,
afvc.qkzztmg1,
afvc.qkzprmeng,
afvc.qkzprfrei,
afvc.qkztlsbest,
afvc.kzfeat,
afvc.aennr,
afvc.cuobj_arb,
afvc.evgew,
afvc.netzkont,
afvc.owaer,
afvc.afnam,
afvc.bednr,
afvc.kzfix,
afvc.pernr,
afvc.frdlb,
afvc.qpart,
afvc.wkurs,
afvc.prod_act,
afvc.fplnr,
afvc.objtype,
afvc.ch_proc,
afvc.fordn,
afvc.fordp,
afvc.mat_prkst,
afvc.prz01,
afvc.rfpnt,
afvc.func_area,
afvc.techs,
afvc.adpsp,
afvc.rfippnt,
afvc.mes_operid,
afvc.mes_stepid,
afvc.cy_seqnrv,
afvc.kapt_puffr,
afvc.oan_inst_id_setup,
afvc.oan_inst_id_produce,
afvc.oan_inst_id_teardown,
afvc.tl_versn,
afvc.maintopexecutionphasecode,
afvc.maintordopprocessphasecode,
afvc.maintordopprocesssubphasecode,
// AFVV data
afvv.meinh,
afvv.bmsch,
afvv.umren,
afvv.umrez,
afvv.zmerh,
afvv.zeier,
afvv.vgw01,
afvv.vgw02,
afvv.vgw03,
afvv.vgw04,
afvv.vgw05,
afvv.vgw06,
afvv.vge01,
afvv.vge02,
afvv.vge03,
afvv.vge04,
afvv.vge05,
afvv.vge06,
afvv.ile01,
afvv.ile02,
afvv.ile03,
afvv.ile04,
afvv.ile05,
afvv.ile06,
afvv.ism01,
afvv.ism02,
afvv.ism03,
afvv.ism04,
afvv.ism05,
afvv.ism06,
afvv.ismnw,
afvv.zeimu,
afvv.zminu,
afvv.zeilm,
afvv.zlmax,
afvv.zeilp,
afvv.zlpro,
afvv.zeiwn,
afvv.zwnor,
afvv.zeiwm,
afvv.zwmin,
afvv.zeitn,
afvv.ztnor,
afvv.zeitm,
afvv.ztmin,
afvv.plifz,
afvv.dauno,
afvv.daune,
afvv.daumi,
afvv.daume,
afvv.einsa,
afvv.einse,
afvv.arbei,
afvv.arbeh,
afvv.mgvrg,
afvv.asvrg,
afvv.lmnga,
afvv.xmnga,
afvv.gmnga,
afvv.rmnga,
afvv.fsavd,
afvv.fsavz,
afvv.fssbd,
afvv.fssbz,
afvv.fssad,
afvv.fssaz,
afvv.fsedd,
afvv.fsedz,
afvv.fssld,
afvv.fsslz,
afvv.fseld,
afvv.fselz,
afvv.ssavd,
afvv.ssavz,
afvv.sssbd,
afvv.sssbz,
afvv.sssad,
afvv.sssaz,
afvv.ssedd,
afvv.ssedz,
afvv.sssld,
afvv.ssslz,
afvv.sseld,
afvv.sselz,
afvv.isavd,
afvv.ieavd,
afvv.isdd,
afvv.isdz,
afvv.ierd,
afvv.ierz,
afvv.isbd,
afvv.isbz,
afvv.iebd,
afvv.iebz,
afvv.isad,
afvv.isaz,
afvv.iedd,
afvv.iedz,
afvv.pedd,
afvv.pedz,
afvv.puffr,
afvv.pufgs,
afvv.ntanf,
afvv.ntanz,
afvv.ntend,
afvv.ntenz,
afvv.ewstd,
afvv.ewstz,
afvv.ewend,
afvv.ewenz,
afvv.ewdan,
afvv.ewdne,
afvv.ewdam,
afvv.ewdme,
afvv.ewste,
afvv.ewsta,
afvv.wartz,
afvv.wrtze,
afvv.ruest,
afvv.rstze,
afvv.bearz,
afvv.beaze,
afvv.abrue,
afvv.aruze,
afvv.liegz,
afvv.ligze,
afvv.tranz,
afvv.traze,
afvv.iserh,
afvv.ofm01,
afvv.ofm02,
afvv.ofm03,
afvv.ofm04,
afvv.ofm05,
afvv.ofm06,
afvv.ofmnw,
afvv.bzoffb,
afvv.ehoffb,
afvv.offstb,
afvv.offste,
afvv.bzoffe,
afvv.ehoffe,
afvv.fpavd,
afvv.fpavz,
afvv.fpedd,
afvv.fpedz,
afvv.spavd,
afvv.spavz,
afvv.spedd,
afvv.spedz,
afvv.beazp,
afvv.pufgp,
afvv.puffp,
afvv.bearp,
afvv.epanf,
afvv.epanz,
afvv.epend,
afvv.epenz,
afvv.pdau,
afvv.pdae,
afvv.knote,
afvv.vstzw,
afvv.vstga,
afvv.aufkt,
afvv.rwfak,
afvv.iprz1,
afvv.ipre1,
afvv.iprk1,
afvv.oprz1,
afvv.opre1,
afvv.takt,
// AFVU data
afvu.slwid,
afvu.usr00,
afvu.usr01,
afvu.usr02,
afvu.usr03,
afvu.usr04,
afvu.use04,
afvu.usr05,
afvu.use05,
afvu.usr06,
afvu.use06,
afvu.usr07,
afvu.use07,
afvu.usr08,
afvu.usr09,
afvu.usr10,
afvu.usr11
}
where ( afvc.plnty <> 'R'
and afvc.plnty <> '3' );
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AFVC",
"AFVU",
"AFVV"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/