CDS标准视图:安排维护计划的调用 I_MAINTENANCEPLANSCHEDULE
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_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_MaintenanceStrategyData
39.CDS标准视图:安排维护计划的调用 I_MAINTENANCEPLANSCHEDULE
40.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_MAINTENANCEPLANSCHEDULE#
视图类型:#
视图代码:#
点击查看代码
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'IMPLASCHED'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Scheduled calls for Maintenance Plan'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
modelingPattern: #NONE,
supportedCapabilities: [#CDS_MODELING_DATA_SOURCE],
semanticKey: [ 'MaintenancePlan','MaintenancePlanCallNumber' ],
usageType: {
dataClass: #MASTER,
serviceQuality: #C,
sizeCategory: #M
}
}
@VDM.viewType: #COMPOSITE
@AbapCatalog.preserveKey: true
define view I_MaintenancePlanSchedule
as select from I_MaintPlanCallHistory
association [0..1] to I_MaintCallSchedulingType as _SchedulingType on _SchedulingType.SchedulingType = $projection.SchedulingType
association [0..1] to P_MaintenanceSingleCycle as _MaintenanceSingleCycle on _MaintenanceSingleCycle.MaintenancePlan = $projection.MaintenancePlan
association [0..1] to I_UnitOfMeasure as _MaintTaskPerformanceUnit on _MaintTaskPerformanceUnit.UnitOfMeasure = $projection.MaintenanceTaskPerformanceUnit
association [0..1] to P_MaintCallCompltnDateTime as _MaintCallCompltnDateTime on _MaintCallCompltnDateTime.MaintenancePlan = $projection.MaintenancePlan
and _MaintCallCompltnDateTime.MaintenanceCall = $projection.MaintenancePlanCallNumber
association [1..1] to I_MaintenancePlanBasic as _MaintenancePlan on _MaintenancePlan.MaintenancePlan = $projection.MaintenancePlan
association [1..*] to I_MaintPlanCallHrznCalcTypeTxt as _CallHrznCalcTypeTxt on _CallHrznCalcTypeTxt.MaintenanceCallHorizonCalcType = $projection.MaintenanceCallHorizonCalcType
{
@ObjectModel.foreignKey.association: '_MaintenancePlan'
key MaintenancePlan,
key MaintenancePlanCallNumber,
key MaintenancePackage,
MaintenanceStrategy as MaintenanceStrategy,
@ObjectModel.foreignKey.association: '_SchedulingType'
SchedulingType as SchedulingType,
SchedulingStatus as SchedulingStatus,
_MaintenanceSingleCycle.MeasuringPoint as MeasuringPoint,
@ObjectModel.foreignKey.association: '_MaintTaskPerformanceUnit'
case _MaintenanceSingleCycle.MaintenanceTaskPerformanceUnit
when '' then _MaintenancePackage.MaintenanceTaskPerformanceUnit
else _MaintenanceSingleCycle.MaintenanceTaskPerformanceUnit
end as MaintenanceTaskPerformanceUnit,
MaintenanceCallNextPlannedDate as MaintenanceCallNextPlannedDate,
MaintenanceCallDate as MaintenanceCallDate,
case CompletionDate
when '00000000' then _MaintCallCompltnDateTime.CompletionDate
else CompletionDate
end as CompletionDate,
_MaintCallCompltnDateTime.CompletionTime as CompletionTime,
CycleSetSequence as CycleSetSequence,
MaintCallCompltnCntrRdng as MaintCallCompltnCntrRdng,
@Semantics.quantity.unitOfMeasure: 'MaintenanceTaskPerformanceUnit'
MaintCallNextPlndCntrRdng as MaintCallNextPlndCntrRdng,
MaintenanceCallIsOutstanding as MaintenanceCallIsOutstanding,
MaintCallIsInvokedOnPlndDate as MaintCallIsInvokedOnPlndDate,
MaintCallHorizonIsNotReached as MaintCallHorizonIsNotReached,
MaintPlanLastScheduledDate as MaintPlanLastScheduledDate,
ReleasedByUserName,
cast ('' as abap.char(256) ) as MaintPlnCnctntdDuePackagesTxt,
_MaintenancePlan.MaintenanceCallHorizonCalcType as MaintenanceCallHorizonCalcType,
MaintPlanPrdcssrCallCompltnDte,
MaintenancePlanManualCallDate,
/* Associations - locally defined */
_MaintenancePlan,
_SchedulingType,
_MaintTaskPerformanceUnit,
_ReleasedByUserName,
_CallHrznCalcTypeTxt,
_MaintenancePackage
}
事务代码:#
视图结构:#
字段名称 | 技术名称 |
---|---|
维护计划 | MAINTENANCEPLAN |
调用号 | MAINTENANCEPLANCALLNUMBER |
维护包 | MAINTENANCEPACKAGE |
策略 | MAINTENANCESTRATEGY |
计划类型 | SCHEDULINGTYPE |
计划状态 | SCHEDULINGSTATUS |
测量点 | MEASURINGPOINT |
单位 | MAINTENANCETASKPERFORMANCEUNIT |
计划日期 | MAINTENANCECALLNEXTPLANNEDDATE |
调用日期 | MAINTENANCECALLDATE |
最后完成 | COMPLETIONDATE |
COMPLETIONTIME | |
循环集顺序 | CYCLESETSEQUENCE |
公司确认的读数 | MAINTCALLCOMPLTNCNTRRDNG |
TL 计数器 | MAINTCALLNEXTPLNDCNTRRDNG |
计划状态 | MAINTENANCECALLISOUTSTANDING |
计划状态 | MAINTCALLISINVOKEDONPLNDDATE |
计划状态 | MAINTCALLHORIZONISNOTREACHED |
调用日期 | MAINTPLANLASTSCHEDULEDDATE |
名称 | RELEASEDBYUSERNAME |
MAINTPLNCNCTNTDDUEPACKAGESTXT | |
计算类型 | MAINTENANCECALLHORIZONCALCTYPE |
前趋完成 | MAINTPLANPRDCSSRCALLCOMPLTNDTE |
手工调用 | MAINTENANCEPLANMANUALCALLDATE |
作者:观兴
出处:https://www.cnblogs.com/guanxing/p/18659214
版权:本作品采用「署名-非商业性使用-相同方式共享 4.0 国际」许可协议进行许可。
转载需本人同意,未经同意转载视同接受稿费2元/字
本文来自博客园,作者:观兴,转载请注明原文链接:https://www.cnblogs.com/guanxing/p/18659214
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· DeepSeek “源神”启动!「GitHub 热点速览」
· 我与微信审核的“相爱相杀”看个人小程序副业
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库
· 上周热点回顾(2.17-2.23)