CDS标准视图:维修工单工艺数据 I_MAINTORDEROPERATIONDATA
1.CDS标准视图:日期迁移视图 I_ShiftedCalendarDate2.CDS标准视图:设备 I_Equipment3.CDS标准视图:功能位置 I_FunctionalLocation4.CDS标准视图:设备功能位置变更历史 I_EQUIPINSTALLATIONHISTORYC5.CDS标准视图:设备描述 I_EquipmentText6.CDS标准视图:设备信息 I_EquipmentData7.CDS标准视图:维护活动类型 I_MaintenanceActivityType8.CDS标准视图:PM通知单 I_LocationAnalysisCube9.CDS标准视图:ABC标识文本 I_ABCIndicatorText10.CDS标准视图:技术对象类别文本 I_TechnicalObjectTypeText11.CDS标准视图:功能位置可用标签 I_FUNCNLLOCALTERNATIVELABEL12.CDS标准视图:功能位置种类描述 I_FlocCategoryText13.CDS标准视图:功能位置描述 I_FunctionalLocationText14.CDS标准视图:功能位置信息 I_FunctionalLocationData
15.CDS标准视图:维修工单工艺数据 I_MAINTORDEROPERATIONDATA
16.CDS标准视图:有技术对象的维修工单 I_MAINTORDERTECHOBJCUBE17.CDS标准视图:维护通知任务数据 I_MaintNotificationTaskData18.CDS标准视图:维护通知原因数据 I_MaintNotificationCauseData19.CDS标准视图:维护通知活动信息 I_MaintNotificationActyData20.CDS标准视图:维护计划数据 C_MaintenancePlanDEX21.CDS标准视图:维护计划 I_MaintenancePlanBasic22.CDS标准视图:维护项目数据 C_MaintenanceItemDEX23.CDS标准视图:维护活动类型描述 I_MaintenanceActivityTypeText24.CDS标准视图:技术对象检验级别 I_TechObjInspectionLevelCode25.CDS标准视图:技术对象检验级别描述 I_TechObjInspectionLevelText26.CDS标准视图:维护通知数据 I_PMNotifMaintenanceData27.CDS标准视图:维修工单实际成本数据 I_MaintOrderActualCostDataCube28.CDS标准视图:维护任务清单数据 I_MaintenanceTaskListData29.CDS标准视图:维护计划员组 I_MAINTENANCEPLANNERGROUP30.CDS标准视图:分配到任务清单的维护包数据 I_PckgTaskListOpalLocData31.CDS标准视图:维护包描述 I_MaintPackageTextData32.CDS标准视图:维护包数据 I_MaintenancePackageData33.CDS标准视图:优先级描述数据 I_GenericPriorityTextData34.CDS标准视图:优先级数据 I_GenericPriorityData35.CDS标准视图:测量文档数据 I_MeasurementDocumentData36.CDS标准视图:测量点数据 I_MeasuringPointData37.CDS标准视图:维护策略描述 I_MaintStrategyTextData38.CDS标准视图:维护策略数据 I_MaintenanceStrategyData39.CDS标准视图:安排维护计划的调用 I_MAINTENANCEPLANSCHEDULE40.CDS标准视图:付款锁定原因 I_PaymentBlockingReason41.CDS标准视图:付款锁定原因描述 I_PaymentBlockingReasonText42.CDS标准视图:会计员 I_AccountingClerk43.CDS标准视图:银行对账单抬头 I_BankStatement44.CDS标准视图:银行对账单行项目 I_BankStatementItem45.CDS标准视图:催款范围 I_DunningArea46.CDS标准视图:催款范围描述 I_DunningAreaText47.CDS标准视图:催款冻结 I_DunningBlockingReasonCode48.CDS标准视图:催款冻结描述 I_DunningBlockingReasonText49.CDS标准视图:催款代码 I_DunningKey50.CDS标准视图:催款级别分配 I_DunningLevelDistribution51.CDS标准视图:预期应收 I_FutureAccountsReceivables52.CDS标准视图:总计应收款 I_TotalAccountsReceivables53.CDS标准视图:销售变现天数 I_DaysSalesOutstanding54.CDS标准视图:应收账龄表 I_ARJrnlEntrItmAgingGrid55.CDS标准视图:一次性账户的客户行项目 I_ONETIMEACCOUNTCUSTOMER- 视图名称:维修工单工艺数据 I_MAINTORDEROPERATIONDATA
- 视图类型:基础
- 视图代码:
点击查看代码
@EndUserText.label: 'Maintenance Order Operation Data'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.sqlViewName: 'IPMORDOPERDATA'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'I_MaintOrderOperation_DEX'
@Analytics: {
dataCategory: #FACT,
dataExtraction: {
enabled: true,
delta.changeDataCapture: {
mapping:[
{
table: 'afvc', role: #MAIN,
viewElement: [ 'MaintOrderRoutingNumber', 'MaintOrderOperationCounter'],
tableElement: ['aufpl', 'aplzl']
}
,
{
table: 'afko', role: #LEFT_OUTER_TO_ONE_JOIN,
viewElement: ['MaintenanceOrder'],
tableElement: ['aufnr']}
]
}
}
}
@ObjectModel: {
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #C,
sizeCategory: #XL
}
}
@ObjectModel.supportedCapabilities: [ #EXTRACTION_DATA_SOURCE ]
@Metadata.ignorePropagatedAnnotations: true
// A more comprehensive view for order (sub)operation data, created as a replacement for BW extractor 2LIS_17_I3OPER
define view I_MaintOrderOperationData
as select from I_MaintOrderOperAndSubOper
association [0..1] to I_LogisticsOrder as _Order on _Order.OrderID = $projection.MaintenanceOrder // AUFK (Order master data) and AFKO (Order Header data )
association [0..1] to I_LocationAccountAssignment as _LocationAccountAssignment on $projection.maintobjectlocacctassgmtnmbr = _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr
association [0..1] to I_Equipment as _Equipment on $projection.equipment = _Equipment.Equipment
{
key MaintenanceOrder,
key cast( MaintOrderOperationCounter as operationinternalid preserving type ) as MaintOrderOperationCounter,
// Order Header:
MaintOrderRoutingNumber,
_MaintenanceOrder._LocationAccountAssignment.FunctionalLocation,
_MaintenanceOrder.Equipment,
_MaintenanceOrder.Assembly,
_MaintenanceOrder.MaintenanceActivityType,
_MaintenanceOrder.MaintenancePlannerGroup,
_MaintenanceOrder.MaintenancePlanningPlant,
_MaintenanceOrder.MaintenanceOrderType,
_MaintenanceOrder.MaintenancePlant,
_MaintenanceOrder.MaintObjectLocAcctAssgmtNmbr,
// Order Operation (MCVGIH)
MaintenanceOrderOperation,
MaintenanceOrderSubOperation,
OperationPersonResponsible,
OperationControlKey,
OperationDescription,
_WorkCenter.WorkCenter,
// note 3197880: WorkCenterPlant get it from operation (in case work center initial)
// _WorkCenter.Plant as WorkCenterPlant,
Plant as WorkCenterPlant,
@Semantics.quantity.unitOfMeasure: 'OperationPlannedWorkUnit'
_OperationPlanningValues.OperationPlannedWork,
@ObjectModel.foreignKey.association: '_PlannedWorkUnitOfMeasure'
@Semantics.unitOfMeasure:true
_OperationPlanningValues.OperationPlannedWorkUnit,
@Semantics.quantity.unitOfMeasure: 'OperationPlannedWorkUnit'
_OperationPlanningValues.ConfirmationTotalQuantity,
@Semantics.quantity.unitOfMeasure: 'OperationQuantityUnit'
_OperationPlanningValues.OperationQuantity,
@ObjectModel.foreignKey.association: '_OperationQtyUnitOfMeasure'
@Semantics.unitOfMeasure: true
_OperationPlanningValues.OperationQuantityUnit,
Assembly as OperationAssembly,
CostCtrActivityType,
CostElement,
MaterialGroup,
OperationUnloadingPointName,
PurchaseRequisition,
cast( case when _StatusObjectActiveStatus[ StatusCode = 'I0013' ].StatusCode is not null then 'X' else ' ' end as eam_is_deleted preserving type ) as IsDeleted,
@Semantics.systemDate.createdAt: true
_MaintenanceOrder._Order.CreationDate,
@Semantics.systemDateTime.lastChangedAt: true
_MaintenanceOrder.LastChangeDateTime,
MaintOrderConfirmation,
MaintOrderOperationInternalID,
SuperiorOperationInternalID,
OperationWorkCenterInternalID,
OperationWorkCenterTypeCode,
/* Associations */
//I_MaintOrderOperPlanningValues
_OperationPlanningValues._PlannedWorkUnitOfMeasure,
_OperationPlanningValues._OperationQtyUnitOfMeasure,
// For DCL:
_MaintenanceOrder,
_PersonResponsible,
_Order,
_Equipment,
_LocationAccountAssignment
}
-
事务代码:IW33/IW49
短描述、创建日期、技术对象、删除标记、完成确认编码、计划数据、工作中心、采购和会计数据 -
视图结构:
字段名称 | 技术名称 |
---|---|
订单 | MAINTENANCEORDER |
工序内部标识 | MAINTORDEROPERATIONCOUNTER |
计划工艺路线号 | MAINTORDERROUTINGNUMBER |
功能位置 | FUNCTIONALLOCATION |
设备 | EQUIPMENT |
装配 | ASSEMBLY |
活动类型 | MAINTENANCEACTIVITYTYPE |
计划人员组 | MAINTENANCEPLANNERGROUP |
计划工厂 | MAINTENANCEPLANNINGPLANT |
订单类型 | MAINTENANCEORDERTYPE |
工厂 | MAINTENANCEPLANT |
位置/科目分配 | MAINTOBJECTLOCACCTASSGMTNMBR |
MAINTENANCEORDEROPERATION | |
子工序 | MAINTENANCEORDERSUBOPERATION |
人员编号 | OPERATIONPERSONRESPONSIBLE |
控制码 | OPERATIONCONTROLKEY |
工序短文本 | OPERATIONDESCRIPTION |
工作中心 | WORKCENTER |
工厂 | WORKCENTERPLANT |
工作 | OPERATIONPLANNEDWORK |
工作单位 | OPERATIONPLANNEDWORKUNIT |
实际的工作 | CONFIRMATIONTOTALQUANTITY |
工序数量 | OPERATIONQUANTITY |
基本单位 | OPERATIONQUANTITYUNIT |
装配 | OPERATIONASSEMBLY |
活动类型 | COSTCTRACTIVITYTYPE |
成本要素 | COSTELEMENT |
物料组 | MATERIALGROUP |
卸货点 | OPERATIONUNLOADINGPOINTNAME |
请购单 | PURCHASEREQUISITION |
已删除 | ISDELETED |
创建日期 | CREATIONDATE |
时戳 | LASTCHANGEDATETIME |
确认 | MAINTORDERCONFIRMATION |
对象编号 | MAINTORDEROPERATIONINTERNALID |
上级工序结点 | SUPERIOROPERATIONINTERNALID |
对象标识 | OPERATIONWORKCENTERINTERNALID |
OPERATIONWORKCENTERTYPECODE |
作者:观兴
出处:https://www.cnblogs.com/guanxing/p/18657317
版权:本作品采用「署名-非商业性使用-相同方式共享 4.0 国际」许可协议进行许可。
转载需本人同意,未经同意转载视同接受稿费2元/字
本文来自博客园,作者:观兴,转载请注明原文链接:https://www.cnblogs.com/guanxing/p/18657317
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· DeepSeek “源神”启动!「GitHub 热点速览」
· 我与微信审核的“相爱相杀”看个人小程序副业
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库
· 上周热点回顾(2.17-2.23)