I_PROJSCHEDMAINTORDERDATA
Project Schedule Data for Work Order
I_PROJSCHEDMAINTORDERDATA is a CDS View in S/4HANA. Project Schedule Data for Work Order. It contains 32 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ProjectShedMaintOrderGraph | view | from | CONSUMPTION | Maintanence Order Graph Overview |
| I_ProjectObjectHierarchySource | view | union_all | COMPOSITE | Project Hierarchy Source |
| P_ProjSchedMaintOrderAttrib | view | from | COMPOSITE | Work Order Attributes |
Fields (32)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | MaintenanceOrder | ProjectNetwork | 1 |
| ActualEndDate | ActualEndDate | 1 | |
| ActualStartDate | ActualStartDate | 1 | |
| BasicSchedulingType | BasicSchedulingType | 1 | |
| BusinessArea | BusinessArea | 1 | |
| CompanyCode | CompanyCode | 2 | |
| ControllingArea | ControllingArea | 1 | |
| CostCenter | CostCenter | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 1 | |
| ForecastedEndDate | ForecastedEndDate | 1 | |
| ForecastedStartDate | ForecastedStartDate | 1 | |
| IsMarkedForDeletion | IsMarkedForDeletion | 1 | |
| LastChangeDate | LastChangeDate | 1 | |
| MainWorkCenter | WorkCenter | 1 | |
| MainWorkCenterPlant | MainWorkCenterPlant | 1 | |
| MRPController | MRPController | 2 | |
| ObjectInternalID | ProjectNetworkObject,ProjectObjectParentNode | 3 | |
| OrderCategory | OrderCategory | 1 | |
| OrderDescription | MaintenanceOrderDesc,ProjectNetworkDescription | 2 | |
| OrderInternalBillOfOperations | ProjectNetworkInternalID | 1 | |
| OrderType | OrderType | 1 | |
| PlannedEndDate | PlannedEndDate | 1 | |
| PlannedStartDate | PlannedStartDate | 1 | |
| Plant | Plant | 2 | |
| PriorityCode | PriorityCode | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ResponsibleCostCenter | ResponsibleCostCenter | 1 | |
| ScheduledBasicEndDate | ScheduledBasicEndDate | 1 | |
| ScheduledBasicStartDate | ScheduledBasicStartDate | 1 | |
| ScheduledForecastedEndDate | ScheduledForecastedEndDate | 1 | |
| ScheduledForecastedStartDate | ScheduledForecastedStartDate | 1 |
@AbapCatalog.sqlViewName: 'IPRSCMAINTORD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@EndUserText.label: 'Project Schedule Data for Work Order'
define view I_ProjSchedMaintOrderData
as select from afko
inner join aufk on afko.aufnr = aufk.aufnr
association [0..1] to I_OrderType as _OrderType on $projection.OrderType = _OrderType.OrderType
association [0..1] to I_ProjectBasicData as _Project on $projection.ProjectInternalID = _Project.ProjectInternalID
association [1..1] to I_NetworkActivityByInternalKey as _NetworkActivityByInternalKey on $projection.SuperiorProjectNetworkIntID = _NetworkActivityByInternalKey.ProjectNetworkInternalID
and $projection.SuperiorNtwkActivityInternalID = _NetworkActivityByInternalKey.NetworkActivityInternalID
association [1..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant
association [0..1] to I_Prioritycode as _PriorityCode on $projection.PriorityCode = _PriorityCode.PriorityCode
association [0..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea
association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..1] to I_BusinessArea as _BusinessArea on $projection.BusinessArea = _BusinessArea.BusinessArea
association [0..*] to I_ProfitCenter as _ProfitCenter on $projection.ControllingArea = _ProfitCenter.ControllingArea
and $projection.ProfitCenter = _ProfitCenter.ProfitCenter
association [0..*] to I_CostCenterText as _ResponsibleCostCenterText on $projection.ControllingArea = _ResponsibleCostCenterText.ControllingArea
and $projection.ResponsibleCostCenter = _ResponsibleCostCenterText.CostCenter
and _ResponsibleCostCenterText.ValidityStartDate <= $session.system_date
and _ResponsibleCostCenterText.ValidityEndDate >= $session.system_date
// association [0..1] to I_MaintenanceOrder as _MaintenanceOrder on $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
association [0..1] to I_WBSElementData_2 as _WBSElementData on _WBSElementData.WBSElementInternalID = $projection.WBSElementInternalID
association [0..*] to I_SchedulingTypeText as _SchedulingTypeText on _SchedulingTypeText.SchedulingType = $projection.BasicSchedulingType
{
key afko.aufnr as MaintenanceOrder,
afko.aufpl as OrderInternalBillOfOperations,
afko.plart as ProdAvailyCheckPlanningType,
cast( afko.pronr as ps_pspnr ) as ProjectInternalID,
aufk.autyp as OrderCategory,
aufk.kokrs as ControllingArea,
aufk.auart as OrderType,
cast(aufk.ktext as pph_auftext preserving type) as OrderDescription,
afko.aufnt as SuperiorProjectNetwork,
afko.aufpt as SuperiorProjectNetworkIntID,
afko.aplzt as SuperiorNtwkActivityInternalID,
aufk.vaplz as MainWorkCenter,
aufk.kdauf as SalesOrder,
aufk.kdpos as SalesOrderItem,
aufk.bukrs as CompanyCode,
aufk.gsber as BusinessArea,
cast(aufk.pspel as ps_s4_pspnr preserving type ) as WBSElementInternalID,
aufk.objnr as ObjectInternalID,
aufk.prctr as ProfitCenter,
afko.gstrp as PlannedStartDate,
afko.gltrp as PlannedEndDate,
afko.gstrs as ScheduledBasicStartDate,
afko.gltrs as ScheduledBasicEndDate,
afko.gstri as ActualStartDate,
afko.getri as ActualEndDate,
afko.aprio as PriorityCode,
aufk.loekz as IsMarkedForDeletion,
afko.gstpp as ForecastedStartDate,
afko.gltpp as ForecastedEndDate,
afko.gstps as ScheduledForecastedStartDate,
afko.gltps as ScheduledForecastedEndDate,
aufk.erdat as CreationDate,
aufk.ernam as CreatedByUser,
aufk.aedat as LastChangeDate,
aufk.kostl as CostCenter,
aufk.kostv as ResponsibleCostCenter,
afko.terkz as BasicSchedulingType,
aufk.wawrk as MainWorkCenterPlant,
//Add Properties for DCL
aufk.werks as Plant,
afko.dispo as MRPController,
_OrderType,
_Project,
_NetworkActivityByInternalKey,
_Plant,
_PriorityCode,
_ControllingArea,
_CompanyCode,
_BusinessArea,
_ProfitCenter,
_ResponsibleCostCenterText,
_WBSElementData,
_SchedulingTypeText
// _MaintenanceOrder
}
where
aufk.autyp = '30'