CDS标准视图:维护计划数据 C_MaintenancePlanDEX
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_MaintNotificationActyData
20.CDS标准视图:维护计划数据 C_MaintenancePlanDEX
21.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- 视图名称:维护计划数据 C_MaintenancePlanDEX
- 视图类型:基础
- 视图代码:
点击查看代码
@AbapCatalog.sqlViewName: 'CMAINTPLANDEX'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Plan Data Extractor'
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'MaintenancePlanCycle'
@ObjectModel.semanticKey: [ 'MaintenancePlan','MaintenancePlanCycle' ]
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions: true
@Analytics: {
dataCategory: #DIMENSION,
dataExtraction: {
enabled: true,
delta.byElement: {
name: 'LastChangeDateTime'
}
}
}
@Analytics.internalName:#LOCAL
@ObjectModel: {
usageType: {
dataClass: #MASTER,
serviceQuality: #C,
sizeCategory: #S
}
}
@AbapCatalog.preserveKey:true
@ObjectModel.modelingPattern: #EXTRACTION_DATA_SOURCE
@ObjectModel.supportedCapabilities: [ #EXTRACTION_DATA_SOURCE ]
define view C_MaintenancePlanDEX
as select from I_MaintenancePlanCycle
association [1..1] to I_MaintenancePlanBasic as _MaintenancePlan on $projection.MaintenancePlan = _MaintenancePlan.MaintenancePlan
// and $projection.MaintenancePlanCycle = MaintenancePlanCycle
-- Extensions, do not expose as association:
association [0..1] to E_MaintenancePlan as _MaintenancePlanExtension on $projection.MaintenancePlan = _MaintenancePlanExtension.MaintenancePlan
{
@ObjectModel.text.element: 'MaintenancePlanDesc'
@ObjectModel.foreignKey.association: '_MaintenancePlan'
key I_MaintenancePlanCycle.MaintenancePlan as MaintenancePlan,
// @Analytics.internalName: #LOCAL
//@ObjectModel.foreignKey.association: '_MaintenancePlanCycle'
key I_MaintenancePlanCycle.MaintenancePlanCycle as MaintenancePlanCycle,
@Semantics.text: true
_MaintenancePlan.MaintenancePlanDesc,
@Semantics.systemDate.createdAt: true
_MaintenancePlan.CreationDate,
@Semantics.user.createdBy: true
_MaintenancePlan.CreatedByUser,
@Semantics.systemDate.lastChangedAt: true
_MaintenancePlan.LastChangeDate,
@Semantics.user.lastChangedBy: true
_MaintenancePlan.LastChangedByUser,
_MaintenancePlan.MaintenanceStrategy,
_MaintenancePlan.SchedulingDuration,
_MaintenancePlan.MaintPlanIsLockedAgainstCalls,
_MaintenancePlan.NumberOfMaintenanceItems,
_MaintenancePlan.MaintenanceCall,
_MaintenancePlan.LateCompletionShiftInPercent,
_MaintenancePlan.EarlyCompletionShiftInPercent,
_MaintenancePlan.LateCompletionTolerancePercent,
_MaintenancePlan.EarlyCompletionTolerancePct,
_MaintenancePlan.CycleModificationRatio,
_MaintenancePlan.MaintPlanSchedgIndicator,
cast( _MaintenancePlan.CallHorizonPercent as callhorizonpercent preserving type) as CallHorizonPercent,
cast( _MaintenancePlan.CallHorizonInDays as callhorizonindays preserving type) as CallHorizonInDays,
_MaintenancePlan.MaintenanceCallHorizonCalcType,
_MaintenancePlan.MaintPlanLogicalOperatorCode,
_MaintenancePlan.AuthorizationGroup,
@ObjectModel.foreignKey.association: '_MaintenancePlanCatParam'
_MaintenancePlan.MaintenancePlanCategory,
_MaintenancePlan.SchedulingDurationUnit,
_MaintenancePlan.BasicStartDate,
// @Semantics.quantity.unitOfMeasure: 'MaintSchedgStartCounterUnit'
_MaintenancePlan.MaintPlanStartCntrReadingValue,
// @ObjectModel.foreignKey.association: '_MeasuringPoint._UnitOfMeasure'
// _MeasuringPoint.MeasurementRangeUnit as MaintSchedgStartCounterUnit,
@Semantics.booleanIndicator
_MaintenancePlan.PrdcssrCallObjCompltnIsRqd,
_MaintenancePlan.MaintPlanFreeDefinedAttrib,
_MaintenancePlan.FactoryCalendar,
_MaintenancePlan.MaintenanceLeadFloatInDays,
_MaintenancePlan.SchedulingStartDate,
_MaintenancePlan.SchedulingStartTime,
_MaintenancePlan.MultipleCounterPlanShiftFactor,
// @Semantics.quantity.unitOfMeasure: 'MaintSchedgEndCounterUnit'
_MaintenancePlan.MaintPlanEndCntrReadingValue,
// @ObjectModel.foreignKey.association: '_MeasuringPoint._UnitOfMeasure'
// _MeasuringPoint.MeasurementRangeUnit as MaintSchedgEndCounterUnit,
_MaintenancePlan.SchedulingEndDate,
@Semantics.systemDateTime.lastChangedAt: true
_MaintenancePlan.LastChangeDateTime,
ComparisonOperator,
@Semantics.quantity.unitOfMeasure: 'MaintPlanCycRcrrcIntervalUnit'
MaintPlanCycRcrrcIntervalQty as MaintPlanCycRcrrcIntervalQty,
// @ObjectModel.foreignKey.association: '_UnitOfMeasure'
// @ObjectModel.foreignKey.association: '_UnitOfMeasure'
MaintPlanCycRcrrcIntervalUnit as MaintPlanCycRcrrcIntervalUnit,
MaintPlanCycleDesc,
@ObjectModel.foreignKey.association: '_Language'
Language,
// @ObjectModel.foreignKey.association: '_MeasuringPoint'
MeasuringPoint,
MaintPlanCycleStartOffsetValue,
@Semantics.booleanIndicator:true
MaintenancePlanCycleIsInactive,
CycleSetSequence,
CycleSetSequenceRepeatFactor,
/* Associations */
_MaintenancePlan._MaintenancePlanCatParam,
_UnitOfMeasure,
_Language,
_MeasuringPoint,
_MaintenancePlan
}
-
事务代码:IP03
-
视图结构:
字段名称 | 设备名称 |
---|---|
维护计划 | MAINTENANCEPLAN |
计数器 | MAINTENANCEPLANCYCLE |
维护计划文本 | MAINTENANCEPLANDESC |
创建日期 | CREATIONDATE |
创建人 | CREATEDBYUSER |
更改日期 | LASTCHANGEDATE |
更改人 | LASTCHANGEDBYUSER |
策略 | MAINTENANCESTRATEGY |
计划期间 | SCHEDULINGDURATION |
已锁定 | MAINTPLANISLOCKEDAGAINSTCALLS |
项目号 | NUMBEROFMAINTENANCEITEMS |
调用号 | MAINTENANCECALL |
晚期完全 | LATECOMPLETIONSHIFTINPERCENT |
早期完全 | EARLYCOMPLETIONSHIFTINPERCENT |
允差(+) | LATECOMPLETIONTOLERANCEPERCENT |
允差(-) | EARLYCOMPLETIONTOLERANCEPCT |
周期修改系数 | CYCLEMODIFICATIONRATIO |
计划标识 | MAINTPLANSCHEDGINDICATOR |
维护计划调用的调用区间(百分比) | CALLHORIZONPERCENT |
维护计划调用的调用区间(天) | CALLHORIZONINDAYS |
计算类型 | MAINTENANCECALLHORIZONCALCTYPE |
工序类型 | MAINTPLANLOGICALOPERATORCODE |
授权组 | AUTHORIZATIONGROUP |
维护计划类型 | MAINTENANCEPLANCATEGORY |
计划间隔的单位 | SCHEDULINGDURATIONUNIT |
周期起始 | BASICSTARTDATE |
结构计数器读数 | MAINTPLANSTARTCNTRREADINGVALUE |
完成要求 | PRDCSSRCALLOBJCOMPLTNISRQD |
分类字段 | MAINTPLANFREEDEFINEDATTRIB |
工厂日历 | FACTORYCALENDAR |
提前缓冲 | MAINTENANCELEADFLOATINDAYS |
开始日期 | SCHEDULINGSTARTDATE |
开始时间 | SCHEDULINGSTARTTIME |
班次因子 MCP | MULTIPLECOUNTERPLANSHIFTFACTOR |
结束计数器 | MAINTPLANENDCNTRREADINGVALUE |
计划结束日期 | SCHEDULINGENDDATE |
时戳 | LASTCHANGEDATETIME |
关系运算符 | COMPARISONOPERATOR |
维护包周期 | MAINTPLANCYCRCRRCINTERVALQTY |
单位 | MAINTPLANCYCRCRRCINTERVALUNIT |
周期正文 | MAINTPLANCYCLEDESC |
主要语言 | LANGUAGE |
测量点 | MEASURINGPOINT |
时间偏置 | MAINTPLANCYCLESTARTOFFSETVALUE |
未激活 | MAINTENANCEPLANCYCLEISINACTIVE |
循环集顺序 | CYCLESETSEQUENCE |
重复因子集 | CYCLESETSEQUENCEREPEATFACTOR |
作者:观兴
出处:https://www.cnblogs.com/guanxing/p/18641261
版权:本作品采用「署名-非商业性使用-相同方式共享 4.0 国际」许可协议进行许可。
转载需本人同意,未经同意转载视同接受稿费2元/字
本文来自博客园,作者:观兴,转载请注明原文链接:https://www.cnblogs.com/guanxing/p/18641261
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 清华大学推出第四讲使用 DeepSeek + DeepResearch 让科研像聊天一样简单!
· 推荐几款开源且免费的 .NET MAUI 组件库
· 实操Deepseek接入个人知识库
· 易语言 —— 开山篇
· 一个费力不讨好的项目,让我损失了近一半的绩效!