CDS标准视图:维护项目数据 C_MaintenanceItemDEX
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_FunctionalLocationData15.CDS标准视图:维修工单工艺数据 I_MAINTORDEROPERATIONDATA16.CDS标准视图:有技术对象的维修工单 I_MAINTORDERTECHOBJCUBE17.CDS标准视图:维护通知任务数据 I_MaintNotificationTaskData18.CDS标准视图:维护通知原因数据 I_MaintNotificationCauseData19.CDS标准视图:维护通知活动信息 I_MaintNotificationActyData20.CDS标准视图:维护计划数据 C_MaintenancePlanDEX21.CDS标准视图:维护计划 I_MaintenancePlanBasic
22.CDS标准视图:维护项目数据 C_MaintenanceItemDEX
23.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- 视图名称:维护项目数据 C_MaintenanceItemDEX
- 视图类型:基础
- 视图代码:
点击查看代码
@AbapCatalog.sqlViewName: 'CMAINTITEMDEX'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Item Data Extractor'
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.privilegedAssociations: ['_LocationAccountAssignment','_Location' ]
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions:true
@Analytics: {
dataCategory: #DIMENSION,
dataExtraction: {
enabled: true,
delta.byElement: {
name: 'LastChangeDateTime'
}
}
}
@Analytics.internalName:#LOCAL
@AbapCatalog.preserveKey:true
@ObjectModel: {
usageType.serviceQuality: #D,
usageType.sizeCategory: #XL,
usageType.dataClass: #MIXED
}
@ObjectModel.representativeKey: 'MaintenanceItem'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.modelingPattern: #EXTRACTION_DATA_SOURCE
@ObjectModel.supportedCapabilities: [ #EXTRACTION_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #ANALYTICAL_DIMENSION ]
define view C_MaintenanceItemDEX
as select from I_MaintenanceItemTechObj
association [0..*] to I_EquipmentData as _EquipmentData on $projection.Equipment = _EquipmentData.Equipment
association [0..1] to I_FunctionalLocationData as _FunctionalLocationData on $projection.FunctionalLocation = _FunctionalLocationData.FunctionalLocation
association [0..1] to I_Plant as _WorkCenterPlant on $projection.WorkCenterPlant = _WorkCenterPlant.Plant
association [0..1] to I_WorkCenter as _WorkCenter on $projection.workcenterinternalid = _WorkCenter.WorkCenterInternalID
and _WorkCenter.WorkCenterTypeCode = 'A'
association [0..1] to I_WorkCenterBySemanticKey as _MainWorkCenterBySemanticKey on $projection.MainWorkCenter = _MainWorkCenterBySemanticKey.WorkCenter
and $projection.MainWorkCenterPlant = _MainWorkCenterBySemanticKey.Plant //Item tab in SAPGUI
association [0..1] to I_WorkCenterBySemanticKey as _WorkCenterBySemanticKey on $projection.workcenter = _WorkCenterBySemanticKey.WorkCenter
and $projection.WorkCenterPlant = _WorkCenterBySemanticKey.Plant //Item location tab in SAPGUI
association [0..1] to I_MaintenancePlanPlant as _MaintenancePlanPlant on $projection.MaintenancePlanningPlant = _MaintenancePlanPlant.MaintenancePlanningPlant
-- Extensions, do not expose as association:
association [0..1] to E_MaintenanceItemBasic as _MaintenanceItemExtension on _MaintenanceItemExtension.MaintenanceItem = $projection.MaintenanceItem
{
@ObjectModel.text.element: ['MaintenanceItemDescription']
key MaintenanceItem,
@ObjectModel.foreignKey.association: '_LocationAccountAssignment'
MaintObjectLocAcctAssgmtNmbr,
@ObjectModel.foreignKey.association: '_MaintenancePlannerGroup'
MaintenancePlannerGroup,
@ObjectModel.foreignKey.association: '_MaintenancePlanPlant'
MaintenancePlanningPlant, //Item tab in SAPGUI
BusinessArea,
@ObjectModel.foreignKey.association: '_MainWorkCenter'
MainWorkCenterInternalID,
@ObjectModel.foreignKey.association: '_WorkCenterType'
WorkCenterTypeCode,
@ObjectModel.foreignKey.association: '_MainWorkCenterBySemanticKey'
cast( _MainWorkCenter.WorkCenter as gewrk preserving type ) as MainWorkCenter, //Item tab in SAPGUI
@ObjectModel.foreignKey.association: '_Plant'
_MainWorkCenter.Plant as MainWorkCenterPlant, //Item tab in SAPGUI
@ObjectModel.foreignKey.association: '_TaskListType'
TaskListType,
@ObjectModel.foreignKey.association: '_TaskListGroup'
TaskListGroup,
@ObjectModel.foreignKey.association: '_TaskListGroupCounter'
TaskListGroupCounter,
@ObjectModel.foreignKey.association: '_EquipmentData'
Equipment,
Assembly,
@Semantics.systemDate.createdAt: true
CreationDate,
@Semantics.user.createdBy: true
CreatedByUser,
@Semantics.systemDate.lastChangedAt: true
LastChangeDate,
@Semantics.user.lastChangedBy: true
LastChangedByUser,
@Semantics.text: true
MaintenanceItemDescription,
@ObjectModel.foreignKey.association: '_MaintenancePlan'
MaintenancePlan,
MaintenancePlanItemPosition,
@ObjectModel.foreignKey.association: '_MaintenanceStrategy'
MaintenanceStrategy,
@ObjectModel.foreignKey.association: '_MaintenancePlanCatParam'
MaintenancePlanCategory,
NotificationType,
@ObjectModel.foreignKey.association: '_MaintenanceNotification'
MaintenanceNotification,
@ObjectModel.foreignKey.association: '_PMNotificationPriorityType'
MaintPriorityType,
@ObjectModel.foreignKey.association: '_PMNotificationPriority'
MaintPriority,
@ObjectModel.foreignKey.association: '_MaintenanceOrder'
MaintenanceOrder,
@ObjectModel.foreignKey.association: '_MaintenanceActivityType'
MaintenanceActivityType,
@ObjectModel.foreignKey.association: '_MaintenanceOrderType'
MaintenanceOrderType,
//cast (SerialNumber as eam_serialnumber preserving type ) as SerialNumber,
SerialNumber,
@ObjectModel.foreignKey.association: '_Material'
Material,
@ObjectModel.foreignKey.association: '_MaintOperationSystCondition'
OperationSystemCondition,
NumberOfTaskListExecutions,
MaintenanceItemIsInactive,
ObjectInternalID,
MaintObjectCategory as MaintenanceItemCategoryCode,
@ObjectModel.foreignKey.association: '_SalesDocument'
SalesDocument,
@ObjectModel.foreignKey.association: '_PurchaseOrder'
PurchaseOrder,
@ObjectModel.foreignKey.association: '_PurchaseOrderItem'
PurchaseOrderItem,
@ObjectModel.foreignKey.association: '_SettlementOrdForServiceProcmt'
SettlementOrder as SettlementOrdForServiceProcmt,
@Semantics.systemDateTime.lastChangedAt: true
MaintPlanLastChangeDateTime as LastChangeDateTime,
//LastChangeDateTime,
ImmediateReleaseIsBlocked,
CycleSetSequence,
@ObjectModel.foreignKey.association: '_PMReferenceElement'
ReferenceElement,
@ObjectModel.foreignKey.association: '_WorkCenter'
_LocationAccountAssignment.WorkCenterInternalID,
@ObjectModel.foreignKey.association: '_WorkCenterBySemanticKey'
_LocationAccountAssignment._WorkCenter.WorkCenter, //Item location tab in SAPGUI
@ObjectModel.foreignKey.association: '_WorkCenterPlant'
_LocationAccountAssignment._WorkCenter.Plant as WorkCenterPlant,
@ObjectModel.foreignKey.association: '_ABCIndicator'
_LocationAccountAssignment.ABCIndicator as ABCIndicator,
@ObjectModel.foreignKey.association: '_SettlementOrder'
_LocationAccountAssignment.SettlementOrder as SettlementOrder,
@ObjectModel.foreignKey.association: '_PlantSection'
_LocationAccountAssignment.PlantSection as PlantSection,
@ObjectModel.foreignKey.association: '_CompanyCode'
_LocationAccountAssignment.CompanyCode as CompanyCode,
@ObjectModel.foreignKey.association: '_ControllingArea'
_LocationAccountAssignment.ControllingArea as ControllingArea,
@ObjectModel.foreignKey.association: '_CostCenter'
_LocationAccountAssignment.CostCenter as CostCenter,
_LocationAccountAssignment.AssetRoom as AssetRoom,
@ObjectModel.foreignKey.association: '_WBSElementBasicData'
cast( _LocationAccountAssignment.WBSElementInternalID as ps_s4_pspnr preserving type ) as WBSElementInternalID,
//cast( _LocationAccountAssignment._WBSElementBasicData.WBSElement as ps_posid preserving type ) as WBSElement,
@ObjectModel.foreignKey.association: '_Location'
_LocationAccountAssignment.AssetLocation as AssetLocation,
@ObjectModel.foreignKey.association: '_MaintenancePlant'
_LocationAccountAssignment.MaintenancePlant as MaintenancePlant, //Item location tab in SAPGUI
@ObjectModel.foreignKey.association: '_FunctionalLocationData'
cast(_LocationAccountAssignment.FunctionalLocation as functionallocation preserving type) as FunctionalLocation,
// Make associations public
// I_MaintenanceItemTechObj
_MaintenancePlannerGroup,
_MaintenancePlanningPlant,
_MaintenancePlan, //Item location tab in SAPGUI
_MaintenanceStrategy,
_MaintenancePlanCatParam,
_PMNotificationPriority,
_Equipment,
_EquipmentData,
@ObjectModel.association.boundFields.dataMatchesSourceAndTargetTypes: true
_FunctionalLocationData,
_MaintenanceNotification,
_MaintenanceOrder,
_MaintenanceTaskList,
_TaskListType,
_TaskListGroup_2 as _TaskListGroup,
_TaskListGroupCounter_2 as _TaskListGroupCounter,
_MaintenanceActivityType,
_MaintenanceOrderType,
_MainWorkCenter, //Item tab in SAPGUI
_MainWorkCenter._Plant,
_WorkCenterPlant,
_MainWorkCenterBySemanticKey,
_WorkCenterBySemanticKey,
_WorkCenter,
_WorkCenterType,
_Assembly,
_PMNotificationType,
_Material,
_SalesDocument,
_PurchaseOrder,
_PurchaseOrderItem,
_SettlementOrder as _SettlementOrdForServiceProcmt,
_MaintOperationSystCondition,
_PMReferenceElement,
_MaintenancePlanPlant,
// I_LocationAccountAssignment
_LocationAccountAssignment,
_LocationAccountAssignment._ABCIndicator,
_LocationAccountAssignment._SettlementOrder,
_LocationAccountAssignment._PlantSection,
_LocationAccountAssignment._CompanyCode,
_LocationAccountAssignment._ControllingArea,
_LocationAccountAssignment._CostCenter,
_LocationAccountAssignment._WBSElementBasicData,
_LocationAccountAssignment._Location,
_LocationAccountAssignment._MaintenancePlant,
_LocationAccountAssignment._FunctionalLocation,
_PMNotificationPriorityType
}
-
事务代码:IP06
-
视图结构:
字段名称 | 设备名称 |
---|---|
维护项目 | MAINTENANCEITEM |
位置/科目分配 | MAINTOBJECTLOCACCTASSGMTNMBR |
计划人员组 | MAINTENANCEPLANNERGROUP |
计划工厂 | MAINTENANCEPLANNINGPLANT |
业务范围 | BUSINESSAREA |
工作中心 | MAINWORKCENTERINTERNALID |
对象类型 | WORKCENTERTYPECODE |
主工作中心 | MAINWORKCENTER |
工厂 | MAINWORKCENTERPLANT |
任务清单类型 | TASKLISTTYPE |
组 | TASKLISTGROUP |
组计数器 | TASKLISTGROUPCOUNTER |
设备 | EQUIPMENT |
装配 | ASSEMBLY |
创建日期 | CREATIONDATE |
创建人 | CREATEDBYUSER |
更改日期 | LASTCHANGEDATE |
更改人 | LASTCHANGEDBYUSER |
维护项目文本 | MAINTENANCEITEMDESCRIPTION |
维护计划 | MAINTENANCEPLAN |
项目编号 | MAINTENANCEPLANITEMPOSITION |
策略 | MAINTENANCESTRATEGY |
维护计划类型 | MAINTENANCEPLANCATEGORY |
通知类型 | NOTIFICATIONTYPE |
通知 | MAINTENANCENOTIFICATION |
优先级类型 | MAINTPRIORITYTYPE |
优先级 | MAINTPRIORITY |
上一订单 | MAINTENANCEORDER |
维护作业类型 | MAINTENANCEACTIVITYTYPE |
订单类型 | MAINTENANCEORDERTYPE |
序列号 | SERIALNUMBER |
物料 | MATERIAL |
系统条件 | OPERATIONSYSTEMCONDITION |
任务清单因子 | NUMBEROFTASKLISTEXECUTIONS |
未激活 | MAINTENANCEITEMISINACTIVE |
对象编号 | OBJECTINTERNALID |
维护项目类别 | MAINTENANCEITEMCATEGORYCODE |
销售凭证 | SALESDOCUMENT |
采购订单 | PURCHASEORDER |
项目 | PURCHASEORDERITEM |
结算订单 | SETTLEMENTORDFORSERVICEPROCMT |
时戳 | LASTCHANGEDATETIME |
请勿释放 | IMMEDIATERELEASEISBLOCKED |
循环集顺序 | CYCLESETSEQUENCE |
参考元素 PM/PS | REFERENCEELEMENT |
PP工作中心 | WORKCENTERINTERNALID |
工作中心 | WORKCENTER |
工厂 | WORKCENTERPLANT |
ABC 标识 | ABCINDICATOR |
结算订单 | SETTLEMENTORDER |
厂区 | PLANTSECTION |
公司代码 | COMPANYCODE |
成本控制范围 | CONTROLLINGAREA |
成本中心 | COSTCENTER |
房间 | ASSETROOM |
WBS 内部标识 | WBSELEMENTINTERNALID |
位置 | ASSETLOCATION |
维护工厂 | MAINTENANCEPLANT |
功能位置 | FUNCTIONALLOCATION |
作者:观兴
出处:https://www.cnblogs.com/guanxing/p/18640926
版权:本作品采用「署名-非商业性使用-相同方式共享 4.0 国际」许可协议进行许可。
转载需本人同意,未经同意转载视同接受稿费2元/字
本文来自博客园,作者:观兴,转载请注明原文链接:https://www.cnblogs.com/guanxing/p/18640926
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· DeepSeek “源神”启动!「GitHub 热点速览」
· 我与微信审核的“相爱相杀”看个人小程序副业
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库
· 上周热点回顾(2.17-2.23)