ProductionOrders
Arquivo SQL de origem - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - ProductionOrders
Visão geral
Esta visão é uma visão de relatórios para sistemas SAP que fornece informações detalhadas sobre ordens de produção e seus itens associados. Ela combina dados de várias tabelas SAP, incluindo AFKO, AFPO, AUFK, JEST e TJ02T, para fornecer uma visão abrangente dos dados relacionados à ordem.
Fontes de Dados
| Tabela/Visão | Descrição |
|---|---|
| AFKO | Dados de cabeçalho para ordens de produção, incluindo informações gerais, dados de programação e informações de status. |
| AFPO | Dados de item para ordens de produção, incluindo informações sobre itens de ordem individuais, como material, quantidade e datas de entrega. |
| AUFK | Dados de cabeçalho para ordens, incluindo informações gerais, informações de custo e informações de status. |
| JEST | Dados de status do objeto, incluindo informações sobre o status de um objeto e seu histórico de alterações. |
| TJ02T | Tabela de texto para status do objeto, fornecendo descrições curtas e longas dos status do objeto. |
Casos de Uso
- Esta visão pode ser usada para analisar dados de ordem de produção, como status da ordem, programação e informações de custo.
- Ela também pode ser usada para rastrear o progresso das ordens de produção e identificar quaisquer problemas ou atrasos potenciais.
- Além disso, esta visão pode ser usada para gerar relatórios sobre dados de ordem de produção para vários fins, como planejamento de produção, análise de custos e controle de qualidade.
Lógica da Query
A consulta combina dados das tabelas AFKO, AFPO, AUFK, JEST e TJ02T usando junções internas. As condições de junção garantem que os dados de cada tabela sejam vinculados adequadamente e que a visão resultante contenha apenas dados relevantes para ordens de produção.
Possível relação com transações SAP
| Código da Transação | Descrição da Transação |
|---|---|
| CO03 | Exibir Ordem de Produção |
| CO02 | Alterar Ordem de Produção |
| CO11N | Visão Geral da Ordem de Produção |
| CO15 | Manutenção em Massa da Ordem de Produção |
| CO41 | Confirmação da Ordem de Produção |
Linhagem de dados
Em desenvolvimento
Campos da Tabela/Visão
| Campo | Descrição do Campo | Descrição no Dicionário SAP (Em breve) |
|---|---|---|
| AFKO.MANDT | Client_MANDT | |
| AFKO.AUFNR | OrderNumber_AUFNR | |
| AFKO.GLTRP | BasicFinishDate_GLTRP | |
| AFKO.GSTRP | BasicStartDate_GSTRP | |
| AFKO.FTRMS | ScheduledReleaseDate_FTRMS | |
| AFKO.GLTRS | ScheduledFinish_GLTRS | |
| AFKO.GSTRS | ScheduledStart_GSTRS | |
| AFKO.GSTRI | ActualStartDate_GSTRI | |
| AFKO.GETRI | ConfirmedOrderFinishDate_GETRI | |
| AFKO.GLTRI | ActualFinishDate_GLTRI | |
| AFKO.FTRMI | ActualReleaseDate_FTRMI | |
| AFKO.FTRMP | PlannedReleaseDate_FTRMP | |
| AFKO.RSNUM | NumberOfReservationdependentRequirements_RSNUM | |
| AFKO.GASMG | TotalScrapQuantityInTheOrder_GASMG | |
| AFKO.GAMNG | TotalOrderQuantity_GAMNG | |
| AFKO.GMEIN | BaseUnitOfMeasure_GMEIN | |
| AFKO.PLNBEZ | MaterialNumber_PLNBEZ | |
| AFKO.PLNTY | TaskListType_PLNTY | |
| AFKO.PLNNR | KeyForTaskListGroup_PLNNR | |
| AFKO.PLNAW | ApplicationOfTheTaskList_PLNAW | |
| AFKO.PLNAL | GroupCounter_PLNAL | |
| AFKO.PVERW | TaskListUsage_PVERW | |
| AFKO.PLAUF | DateForRoutingExplosion_PLAUF | |
| AFKO.PLSVB | ToLotSize_PLSVB | |
| AFKO.PLNME | TaskListUnitOfMeasure_PLNME | |
| AFKO.PLSVN | FromLotSize_PLSVN | |
| AFKO.PDATV | ValidFromDate_PDATV | |
| AFKO.PAENR | ChangeNumber_PAENR | |
| AFKO.PLGRP | ResponsiblePlannerGroupdepartment_PLGRP | |
| AFKO.LODIV | LotSizeDivisor_LODIV | |
| AFKO.STLTY | BomCategory_STLTY | |
| AFKO.STLBEZ | MaterialNumber_STLBEZ | |
| AFKO.STLST | BomStatus_STLST | |
| AFKO.STLNR | BillOfMaterial_STLNR | |
| AFKO.SDATV | ValidFromDate_SDATV | |
| AFKO.SBMNG | BaseQuantity_SBMNG | |
| AFKO.SBMEH | BaseUnitOfMeasure_SBMEH | |
| AFKO.SAENR | ChangeNumber_SAENR | |
| AFKO.STLAL | AlternativeBom_STLAL | |
| AFKO.STLAN | BomUsage_STLAN | |
| AFKO.SLSVN | FromLotSize_SLSVN | |
| AFKO.SLSBS | ToLotSize_SLSBS | |
| AFKO.AUFLD | DateOfBomExplosionroutingTransfer_AUFLD | |
| AFKO.DISPO | MrpControllerForTheOrder_DISPO | |
| AFKO.AUFPL | RoutingNumberOfOperationsInTheOrder_AUFPL | |
| AFKO.FEVOR | ProductionSupervisor_FEVOR | |
| AFKO.FHORI | SchedulingMarginKeyForFloats_FHORI | |
| AFKO.TERKZ | SchedulingType_TERKZ | |
| AFKO.REDKZ | ReductionIndicatorForScheduling_REDKZ | |
| AFKO.APRIO | OrderPriority_APRIO | |
| AFKO.NTZUE | SuperiorNetworkNumber_NTZUE | |
| AFKO.VORUE | SuperiorActivity_VORUE | |
| AFKO.PROFID | NetworkProfile_PROFID | |
| AFKO.VORGZ | FloatBeforeProductionInDays_VORGZ | |
| AFKO.SICHZ | FloatAfterProductionInDays_SICHZ | |
| AFKO.FREIZ | ReleasePeriodInDays_FREIZ | |
| AFKO.UPTER | Indicator_ChangeToScheduledDates_UPTER | |
| AFKO.BEDID | IdOfTheCapacityRequirementsRecord_BEDID | |
| AFKO.PRONR | ProjectDefinition_PRONR | |
| AFKO.ZAEHL | InternalCounter_ZAEHL | |
| AFKO.MZAEHL | InternalCounter_MZAEHL | |
| AFKO.ZKRIZ | CounterForAdditionalCriteria_ZKRIZ | |
| AFKO.PRUEFLOS | InspectionLotNumber_PRUEFLOS | |
| AFKO.KLVARP | CostingVariantForPlannedCosts_KLVARP | |
| AFKO.KLVARI | CostingVariantForActualCosts_KLVARI | |
| AFKO.RGEKZ | Indicator_BackflushingForOrder_RGEKZ | |
| AFKO.PLART | BasisForScheduling_PLART | |
| AFKO.FLG_AOB | Indicator_Relationships_FLG_AOB | |
| AFKO.FLG_ARBEI | Indicator_DefaultValueWorkIsRelevant_FLG_ARBEI | |
| AFKO.GLTPP | FinishDate__forecast___GLTPP | |
| AFKO.GSTPP | ForecastStartDate_GSTPP | |
| AFKO.GLTPS | ScheduledForecastFinish_GLTPS | |
| AFKO.GSTPS | ScheduledForecastStart_GSTPS | |
| AFKO.FTRPS | ScheduledReleaseDate__forecast___FTRPS | |
| AFKO.RDKZP | ReductionIndicatorForScheduling__forecast___RDKZP | |
| AFKO.TRKZP | SchedulingType__forecast___TRKZP | |
| AFKO.RUECK | CompletionConfirmationNumberForTheOperation_RUECK | |
| AFKO.RMZHL | InternalCounter_RMZHL | |
| AFKO.IGMNG | YieldConfirmedFromOrderConfirmation_IGMNG | |
| AFKO.RATID | IdOfTheCapacityRequirementsRecord_RATID | |
| AFKO.GROID | IdOfTheCapacityRequirementsRecord_GROID | |
| AFKO.CUOBJ | Configuration__internalObjectNumber___CUOBJ | |
| AFKO.GLUZS | ScheduledFinish__time___GLUZS | |
| AFKO.GSUZS | ScheduledStart__time___GSUZS | |
| AFKO.REVLV | RevisionLevel_REVLV | |
| AFKO.RSHTY | ObjectTypesOfTheCimResource_RSHTY | |
| AFKO.RSHID | ObjectIdOfTheResource_RSHID | |
| AFKO.RSNTY | ObjectTypesOfTheCimResource_RSNTY | |
| AFKO.RSNID | ObjectIdOfTheResource_RSNID | |
| AFKO.NAUTERM | Indicator_DoNotScheduleAutomatically_NAUTERM | |
| AFKO.NAUCOST | Indicator_DoNotCostAutomatically_NAUCOST | |
| AFKO.STUFE | Level__inMultiLevelBomExplosions___STUFE | |
| AFKO.WEGXX | Path__forMultiLevelBomExplosions___WEGXX | |
| AFKO.VWEGX | Path__forMultiLevelBomExplosions___VWEGX | |
| AFKO.ARSNR | NumberOfReservationdependentRequirements_ARSNR | |
| AFKO.ARSPS | OrderItemNumber_ARSPS | |
| AFKO.MAUFNR | NumberOfSuperiorOrder_MAUFNR | |
| AFKO.LKNOT | LeftNodeInCollectiveOrder_LKNOT | |
| AFKO.RKNOT | RightNodeOfACollectiveOrder_RKNOT | |
| AFKO.PRODNET | Indicator_OrderIsPartOfCollectiveOrder_PRODNET | |
| AFKO.IASMG | ScrapConfirmedForOrder_IASMG | |
| AFKO.ABARB | Confirmation_DegreeOfProcessing_ABARB | |
| AFKO.AUFNT | NumberOfSuperiorNetwork_AUFNT | |
| AFKO.AUFPT | RoutingNumberOfOperationsInTheOrder_AUFPT | |
| AFKO.APLZT | GeneralCounterForOrder_APLZT | |
| AFKO.NO_DISP | EffectiveForMaterialsPlanning_NO_DISP | |
| AFKO.CSPLIT | ApportionmentStructure_CSPLIT | |
| AFKO.AENNR | ChangeNumber_AENNR | |
| AFKO.CY_SEQNR | SeqNumberOrder_CY_SEQNR | |
| AFKO.BREAKS | Indicator_SchedulingAllowingForBreaks_BREAKS | |
| AFKO.VORGZ_TRM | ScheduledFloatBeforeProductionInDays_VORGZ_TRM | |
| AFKO.SICHZ_TRM | ScheduledFloatAfterProductionInDays_SICHZ_TRM | |
| AFKO.TRMDT | DateOfTheLastScheduling_TRMDT | |
| AFKO.GLUZP | BasicFinish__time___GLUZP | |
| AFKO.GSUZP | BasicStart__time___GSUZP | |
| AFKO.GSUZI | ActualStartTime_GSUZI | |
| AFKO.GEUZI | ConfirmedOrderFinish__time___GEUZI | |
| AFKO.GLUPP | ForecastFinish__time___GLUPP | |
| AFKO.GSUPP | ForecastStart__time___GSUPP | |
| AFKO.GLUPS | ScheduledForecastFinishTime_GLUPS | |
| AFKO.GSUPS | ScheduledStartTime__forecast___GSUPS | |
| AFKO.CHSCH | SearchProcedureForBatchDetermination_CHSCH | |
| AFKO.KAPT_VORGZ | Float__befProduction__RemainingAfterFiniteScheduling_KAPT_VORGZ | |
| AFKO.KAPT_SICHZ | RemainingFloatAfterFiniteScheduling_KAPT_SICHZ | |
| AFKO.LEAD_AUFNR | LeadingOrderInCurrentProcessing_LEAD_AUFNR | |
| AFKO.PNETSTARTD | OutlineStartOfCollectiveOrder__date___PNETSTARTD | |
| AFKO.PNETSTARTT | OutlineStartOfCollectiveOrder__time___PNETSTARTT | |
| AFKO.PNETENDD | OutlineFinishOfCollectiveOrder__date___PNETENDD | |
| AFKO.PNETENDT | OutlineFinishOfCollectiveOrder__time___PNETENDT | |
| AFKO.KBED | Ind_DoNotCreateCapacityRequirements_KBED | |
| AFKO.KKALKR | Indicator_ComponentsWillNotBeCosted_KKALKR | |
| AFKO.SFCPF | ProductionSchedulingProfile_SFCPF | |
| AFKO.RMNGA | TotalConfirmedReworkQuantity_RMNGA | |
| AFKO.GSBTR | OverallCommitmentDate_GSBTR | |
| AFKO.VFMNG | CommittedQuantityForOrderAfterAtpCheckComponents_VFMNG | |
| AFKO.NOPCOST | DoNotCalculatePlannedCostsForOrder_NOPCOST | |
| AFKO.NETZKONT | IndicatorForTheAccountAssignmentOfANetwork__hdract___NETZKONT | |
| AFKO.ATRKZ | RequestId_ATRKZ | |
| AFKO.OBJTYPE | ChangeIndicator_OBJTYPE | |
| AFKO.CH_PROC | ProcessThatHasLeadToTheChangeOfAnObject_CH_PROC | |
| AFKO.KAPVERSA | VersionOfAvailableCapacity_KAPVERSA | |
| AFKO.COLORDPROC | CollectiveOrderWithwithoutAutomaticGoodsMovement_COLORDPROC | |
| AFKO.KZERB | Indicator_ProjectSummarizationViaMasterDataCharact_KZERB | |
| AFKO.CONF_KEY | IdenticalObject_CONF_KEY | |
| AFKO.ST_ARBID | ObjectId_ST_ARBID | |
| AFKO.VSNMR_V | SalesDocumentVersionNumber_VSNMR_V | |
| AFKO.TERHW | SchedulingNoteFromOrderScheduling_TERHW | |
| AFKO.SPLSTAT | StatusOfAnOrderInASplitHierarchy_SPLSTAT | |
| AFKO.COSTUPD | CostsAreUpdated_COSTUPD | |
| AFKO.MAX_GAMNG | MaximumValueOfTotalOrderQuantityAfterDistribution_MAX_GAMNG | |
| AFKO.MES_ROUTINGID | KeyOfARoutingFromAnMeSystem_MES_ROUTINGID | |
| AFKO.ADPSP | PmpsReferenceElement_ADPSP | |
| AFKO.RMANR | SalesAndDistributionDocumentNumber_RMANR | |
| AFKO.POSNR_RMA | ItemNumberOfTheSdDocument_POSNR_RMA | |
| AFKO.POSNV_RMA | ItemNumberOfTheSdDocument_POSNV_RMA | |
| AFKO.CFB_MAXLZ | MaximumStoragePeriod_CFB_MAXLZ | |
| AFKO.CFB_LZEIH | UnitForMaximumStoragePeriod_CFB_LZEIH | |
| AFKO.CFB_ADTDAYS | AdditionalDays_CFB_ADTDAYS | |
| AFKO.CFB_DATOFM | DateOfManufacture_CFB_DATOFM | |
| AFKO.CFB_BBDPI | BestBeforeDate__bbd__ShelfLifeExpirationDate__sled___CFB_BBDPI | |
| AFKO.OIHANTYP | ExciseDutyHandlingType_OIHANTYP | |
| AFKO.FSH_MPROD_ORD | MasterProductionOrderNumber_FSH_MPROD_ORD | |
| AFKO.FLG_BUNDLE | IndicatesBundleInformationMaintained_FLG_BUNDLE | |
| AFKO.MILL_RATIO | FactorForQuantityBasedSettlement_MILL_RATIO | |
| AFKO.BMEINS | BaseUnitOfMeasure_BMEINS | |
| AFKO.BMENGE | BaseQuantity_BMENGE | |
| AFKO.MILL_OC_ZUSKZ | CombinationIndicator_MILL_OC_ZUSKZ | |
| AFPO.MANDT | Client_MANDT | |
| AFPO.AUFNR | OrderNumber_AUFNR | |
| AFPO.POSNR | OrderItemNumber_POSNR | |
| AFPO.PSOBS | SpecialProcurementType_PSOBS | |
| AFPO.QUNUM | NumberOfQuotaArrangement_QUNUM | |
| AFPO.QUPOS | QuotaArrangementItem_QUPOS | |
| AFPO.PROJN | WorkBreakdownStructureElement__wbsElement___PROJN | |
| AFPO.PLNUM | PlannedOrderNumber_PLNUM | |
| AFPO.STRMP | StartDateOfPlannedOrder_STRMP | |
| AFPO.ETRMP | OpeningDateOfThePlannedOrder_ETRMP | |
| AFPO.KDAUF | SalesOrderNumber_KDAUF | |
| AFPO.KDPOS | SalesOrderItem_KDPOS | |
| AFPO.KDEIN | DeliveryScheduleForSalesOrder_KDEIN | |
| AFPO.BESKZ | ProcurementType_BESKZ | |
| AFPO.PSAMG | ScrapQuantityInItem_PSAMG | |
| AFPO.PSMNG | OrderItemQuantity_PSMNG | |
| AFPO.WEMNG | QuantityOfGoodsReceivedForTheOrderItem_WEMNG | |
| AFPO.IAMNG | ExpectedSurplusdeficitForGoodsReceipt_IAMNG | |
| AFPO.AMEIN | UnitOfMeasureForInHouseProduction_AMEIN | |
| AFPO.MEINS | BaseUnitOfMeasure_MEINS | |
| AFPO.MATNR | MaterialNumberForOrder_MATNR | |
| AFPO.PAMNG | FixedQuantityOfScrapFromProduction_PAMNG | |
| AFPO.PGMNG | TotalPlannedOrderQuantity_PGMNG | |
| AFPO.KNTTP | AccountAssignmentCategory_KNTTP | |
| AFPO.TPAUF | Indicator_PartialConversion_TPAUF | |
| AFPO.LTRMI | ActualDeliveryfinishDate_LTRMI | |
| AFPO.LTRMP | DelivDateFrPlannedOrd_LTRMP | |
| AFPO.KALNR | CostEstimateNumberForCostEstWoQtyStructure_KALNR | |
| AFPO.UEBTO | OverdeliveryToleranceLimit_UEBTO | |
| AFPO.UEBTK | Indicator_UnlimitedOverdeliveryAllowed_UEBTK | |
| AFPO.UNTTO | UnderdeliveryToleranceLimit_UNTTO | |
| AFPO.INSMK | StockType_INSMK | |
| AFPO.WEPOS | GoodsReceiptIndicator_WEPOS | |
| AFPO.BWTAR | ValuationType_BWTAR | |
| AFPO.BWTTY | ValuationCategory_BWTTY | |
| AFPO.PWERK | PlanningPlantForTheOrder_PWERK | |
| AFPO.LGORT | StorageLocation_LGORT | |
| AFPO.UMREZ | NumeratorForConversionToBaseUnitsOfMeasure_UMREZ | |
| AFPO.UMREN | DenominatorForConversionToBaseUnitsOfMeasure_UMREN | |
| AFPO.WEBAZ | GoodsReceiptProcessingTimeInDays_WEBAZ | |
| AFPO.ELIKZ | deliveryCompletedIndicator_ELIKZ | |
| AFPO.SAFNR | RunScheduleHeaderNumber_SAFNR | |
| AFPO.VERID | ProductionVersion_VERID | |
| AFPO.SERNR | BomExplosionNumber_SERNR | |
| AFPO.TECHS | ParameterVariantstandardVariant_TECHS | |
| AFPO.DWERK | Plant_DWERK | |
| AFPO.DAUTY | OrderCategory_DAUTY | |
| AFPO.DAUAT | OrderType_DAUAT | |
| AFPO.DGLTP | BasicFinishDate_DGLTP | |
| AFPO.DGLTS | ScheduledFinish_DGLTS | |
| AFPO.DFREI | Indicator_OrderReleasedpartiallyReleased__forMrp___DFREI | |
| AFPO.DNREL | Indicator_OrderItemNotRelevantForMrp_DNREL | |
| AFPO.VERTO | MrpDistributionKey_VERTO | |
| AFPO.SOBKZ | SpecialStockIndicator_SOBKZ | |
| AFPO.KZVBR | ConsumptionPosting_KZVBR | |
| AFPO.WEWRT | ValueOfGoodsReceivedInLocalCurrency_WEWRT | |
| AFPO.WEUNB | GoodsReceipt_NonValuated_WEUNB | |
| AFPO.ABLAD | UnloadingPoint_ABLAD | |
| AFPO.WEMPF | GoodsRecipient_WEMPF | |
| AFPO.CHARG | BatchNumber_CHARG | |
| AFPO.GSBER | BusinessArea_GSBER | |
| AFPO.WEAED | Indicator_GoodsReceiptIndicatorCanBeChanged_WEAED | |
| AFPO.CUOBJ | Configuration__internalObjectNumber___CUOBJ | |
| AFPO.KBNKZ | KanbanIndicator_KBNKZ | |
| AFPO.ARSNR | SettlementReservationNumber_ARSNR | |
| AFPO.ARSPS | ItemNumberOfTheSettlementReservation_ARSPS | |
| AFPO.KRSNR | NumberOfReservationdependentRequirements_KRSNR | |
| AFPO.KRSPS | ItemNumberOfReservationDependentRequirements_KRSPS | |
| AFPO.KCKEY | CostCollectorKey_KCKEY | |
| AFPO.RTP01 | CostCollectorForRepetitiveManufacturing_RTP01 | |
| AFPO.RTP02 | CostCollectorForKanban_RTP02 | |
| AFPO.RTP03 | CostCollectorForValuatedSalesOrderStock_RTP03 | |
| AFPO.RTP04 | CostCollectorForExternalPpc_RTP04 | |
| AFPO.KSVON | CostCollectorValidFrom_KSVON | |
| AFPO.KSBIS | CostCollectorValidTo_KSBIS | |
| AFPO.OBJNP | ObjectNumber_OBJNP | |
| AFPO.VFMNG | CommittedQuantityForOrderAfterAtpCheckComponents_VFMNG | |
| AFPO.GSBTR | OverallCommitmentDate_GSBTR | |
| AFPO.NDISR | Ind_MaterialInOrderItemIsNotRelevantForMrp_NDISR | |
| AFPO.KZAVC | IndicatorForTypeOfAvailabilityCheck_KZAVC | |
| AFPO.KZBWS | ValuationOfSpecialStock_KZBWS | |
| AFPO.XLOEK | DeletionFlag_XLOEK | |
| AFPO.SERNP | SerialNumberProfile_SERNP | |
| AFPO.ANZSN | NumberOfSerialNumbers_ANZSN | |
| AFPO.OBJTYPE | ChangeIndicator_OBJTYPE | |
| AFPO.CH_PROC | ProcessThatHasLeadToTheChangeOfAnObject_CH_PROC | |
| AFPO.FXPRU | FixedPriceCoProduct_FXPRU | |
| AFPO.CUOBJ_ROOT | Configuration__internalObjectNumber___CUOBJ_ROOT | |
| AFPO.BERID | MrpArea_BERID | |
| AFPO.TECHS_COPY | ParameterVariantstandardVariant_TECHS_COPY | |
| AFPO.SGT_SCAT | StockSegment_SGT_SCAT | |
| AFPO.KUNNR2 | CustomerNumber_KUNNR2 | |
| AFPO.FSH_SEASON_YEAR | SeasonYear_FSH_SEASON_YEAR | |
| AFPO.FSH_SEASON | Season_FSH_SEASON | |
| AFPO.FSH_COLLECTION | FashionCollection_FSH_COLLECTION | |
| AFPO.FSH_THEME | FashionTheme_FSH_THEME | |
| AFPO.FSH_SALLOC_QTY | AllocatedStockQuantity_FSH_SALLOC_QTY | |
| AFPO.MILL_OC_AUFNR_U | NumberOfOriginalOrder_MILL_OC_AUFNR_U | |
| AFPO.MILL_OC_RUMNG | ConfirmedQuantityForItem_MILL_OC_RUMNG | |
| AFPO.MILL_OC_SORT | ItemSequence_MILL_OC_SORT | |
| AUFK.MANDT | Client_MANDT | |
| AUFK.AUFNR | OrderNumber_AUFNR | |
| AUFK.AUART | OrderType_AUART | |
| AUFK.AUTYP | OrderCategory_AUTYP | |
| AUFK.REFNR | ReferenceOrderNumber_REFNR | |
| AUFK.ERNAM | EnteredBy_ERNAM | |
| AUFK.ERDAT | CreatedOn_ERDAT | |
| AUFK.AENAM | LastChangedBy_AENAM | |
| AUFK.AEDAT | ChangeDateForOrderMaster_AEDAT | |
| AUFK.KTEXT | Description_KTEXT | |
| AUFK.LTEXT | LongTextExists_LTEXT | |
| AUFK.BUKRS | CompanyCode_BUKRS | |
| AUFK.WERKS | Plant_WERKS | |
| AUFK.GSBER | BusinessArea_GSBER | |
| AUFK.KOKRS | ControllingArea_KOKRS | |
| AUFK.CCKEY | CostCollectorKey_CCKEY | |
| AUFK.KOSTV | ResponsibleCostCenter_KOSTV | |
| AUFK.STORT | Location_STORT | |
| AUFK.SOWRK | LocationPlant_SOWRK | |
| AUFK.ASTKZ | IdentifierForStatisticalOrder_ASTKZ | |
| AUFK.WAERS | OrderCurrency_WAERS | |
| AUFK.ASTNR | OrderStatus_ASTNR | |
| AUFK.STDAT | DateOfLastStatusChange_STDAT | |
| AUFK.ESTNR | StatusReachedSoFar_ESTNR | |
| AUFK.PHAS0 | PhaseorderCreated_PHAS0 | |
| AUFK.PHAS1 | PhaseorderReleased_PHAS1 | |
| AUFK.PHAS2 | PhaseorderCompleted_PHAS2 | |
| AUFK.PHAS3 | PhaseorderClosed_PHAS3 | |
| AUFK.PDAT1 | PlannedReleaseDate_PDAT1 | |
| AUFK.PDAT2 | PlannedCompletionDate_PDAT2 | |
| AUFK.PDAT3 | PlannedClosingDate_PDAT3 | |
| AUFK.IDAT1 | ReleaseDate_IDAT1 | |
| AUFK.IDAT2 | TechnicalCompletionDate_IDAT2 | |
| AUFK.IDAT3 | CloseDate_IDAT3 | |
| AUFK.OBJID | ObjectId_OBJID | |
| AUFK.VOGRP | GroupOfDisallowedTransactions_VOGRP | |
| AUFK.LOEKZ | DeletionFlag_LOEKZ | |
| AUFK.PLGKZ | IdentifierForPlanningWithLineItems_PLGKZ | |
| AUFK.KVEWE | UsageOfTheConditionTable_KVEWE | |
| AUFK.KAPPL | Application_KAPPL | |
| AUFK.KALSM | CostingSheet_KALSM | |
| AUFK.ZSCHL | OverheadKey_ZSCHL | |
| AUFK.ABKRS | ProcessingGroup_ABKRS | |
| AUFK.KSTAR | SettlementCostElement_KSTAR | |
| AUFK.KOSTL | CostCenterForBasicSettlement_KOSTL | |
| AUFK.SAKNR | GlAccountForBasicSettlement_SAKNR | |
| AUFK.SETNM | AllocationSet_SETNM | |
| AUFK.CYCLE | CostCenterToWhichCostsAreActuallyPosted_CYCLE | |
| AUFK.SDATE | StartDate_SDATE | |
| AUFK.SEQNR | SequenceNumber_SEQNR | |
| AUFK.USER0 | Applicant_USER0 | |
| AUFK.USER1 | ApplicantsTelephoneNumber_USER1 | |
| AUFK.USER2 | PersonResponsible_USER2 | |
| AUFK.USER3 | TelephoneNumberOfPersonInCharge_USER3 | |
| AUFK.USER4 | EstimatedTotalCostsOfOrder_USER4 | |
| AUFK.USER5 | ApplicationDate_USER5 | |
| AUFK.USER6 | Department_USER6 | |
| AUFK.USER7 | WorkStart_USER7 | |
| AUFK.USER8 | EndOfWork_USER8 | |
| AUFK.USER9 | IdentifierForWorkPermitIssued_USER9 | |
| AUFK.OBJNR | ObjectNumber_OBJNR | |
| AUFK.PRCTR | ProfitCenter_PRCTR | |
| AUFK.PSPEL | WorkBreakdownStructureElement__wbsElement___PSPEL | |
| AUFK.AWSLS | VarianceKey_AWSLS | |
| AUFK.ABGSL | ResultsAnalysisKey_ABGSL | |
| AUFK.TXJCD | TaxJurisdiction_TXJCD | |
| AUFK.FUNC_AREA | FunctionalArea_FUNC_AREA | |
| AUFK.SCOPE | ObjectClass_SCOPE | |
| AUFK.PLINT | IndicatorForIntegratedPlanning_PLINT | |
| AUFK.KDAUF | SalesOrderNumber_KDAUF | |
| AUFK.KDPOS | ItemNumberInSalesOrder_KDPOS | |
| AUFK.AUFEX | ExternalOrderNumber_AUFEX | |
| AUFK.IVPRO | InvestmentMeasureProfile_IVPRO | |
| AUFK.LOGSYSTEM | LogicalSystem_LOGSYSTEM | |
| AUFK.FLG_MLTPS | OrderWithMultipleItems_FLG_MLTPS | |
| AUFK.ABUKR | RequestingCompanyCode_ABUKR | |
| AUFK.AKSTL | RequestingCostCenter_AKSTL | |
| AUFK.SIZECL | ScaleOfInvestmentObjects_SIZECL | |
| AUFK.IZWEK | ReasonForInvestment_IZWEK | |
| AUFK.UMWKZ | ReasonForEnvironmentalInvestment_UMWKZ | |
| AUFK.KSTEMPF | Indicator_DirectCostCollector_KSTEMPF | |
| AUFK.ZSCHM | InterestProfileForProjectorderInterestCalculation_ZSCHM | |
| AUFK.PKOSA | CostCollectorForProductionProcessProcnr_PKOSA | |
| AUFK.ANFAUFNR | RequestingOrder_ANFAUFNR | |
| AUFK.PROCNR | ProductionProcess_PROCNR | |
| AUFK.PROTY | ProcessCategory__procurementconsumption___PROTY | |
| AUFK.RSORD | RefurbishmentOrderIndicator__pm___RSORD | |
| AUFK.BEMOT | AccountingIndicator_BEMOT | |
| AUFK.ADRNRA | AddressNumber_ADRNRA | |
| AUFK.ERFZEIT | TimeCreated_ERFZEIT | |
| AUFK.AEZEIT | ChangedAt_AEZEIT | |
| AUFK.CSTG_VRNT | CostingVariant_CSTG_VRNT | |
| AUFK.COSTESTNR | CostEstimateNumberForCostEstWoQtyStructure_COSTESTNR | |
| AUFK.VERAA_USER | PersonResponsibleForCoInternalOrder_VERAA_USER | |
| AUFK.VNAME | JointVenture_VNAME | |
| AUFK.RECID | RecoveryIndicator_RECID | |
| AUFK.ETYPE | EquityType_ETYPE | |
| AUFK.OTYPE | JointVentureObjectType_OTYPE | |
| AUFK.JV_JIBCL | JibjibeClass_JV_JIBCL | |
| AUFK.JV_JIBSA | JibjibeSubclassA_JV_JIBSA | |
| AUFK.JV_OCO | JvOriginalCostObject_JV_OCO | |
| AUFK.CUM_INDCU | Cu_OrderIsUsedForCompatibleUnits_CUM_INDCU | |
| AUFK.CUM_CMNUM | Cu_ConstructionMeasureNumber_CUM_CMNUM | |
| AUFK.CUM_AUEST | Cu_AutomaticCopyOfEstimatedCosts_CUM_AUEST | |
| AUFK.CUM_DESNUM | Cu_DesignNumber_CUM_DESNUM | |
| AUFK.VAPLZ | MainWorkCenterForMaintenanceTasks_VAPLZ | |
| AUFK.WAWRK | PlantAssociatedWithMainWorkCenter_WAWRK | |
| AUFK.FERC_IND | RegulatoryIndicator_FERC_IND | |
| AUFK.CLAIM_CONTROL | ClaimCreationControlIndicator_CLAIM_CONTROL | |
| AUFK.UPDATE_NEEDED | ClaimInconsistencyWithOrderIndicator_UPDATE_NEEDED | |
| AUFK.UPDATE_CONTROL | ClaimUpdateTriggerPointFromServiceOrder_UPDATE_CONTROL | |
| JEST.MANDT | Client_MANDT | |
| JEST.OBJNR | ObjectNumber_OBJNR | |
| JEST.STAT | ObjectStatus_STAT | |
| JEST.INACT | Indicator_StatusIsInactive_INACT | |
| JEST.CHGNR | ChangeNumber_CHGNR | |
| JEST._DATAAGING | DataFilterValueForDataAging__DATAAGING | |
| TJ02T.ISTAT | SystemStatus_ISTAT | |
| TJ02T.SPRAS | LanguageKey_SPRAS | |
| TJ02T.TXT04 | IndividualStatusOfAnObject__shortForm___TXT04 | |
| TJ02T.TXT30 | ObjectStatus_TXT30 |