C_MaintJobWorkItemUnplndCompTP

DDL: C_MAINTJOBWORKITEMUNPLNDCOMPTP Type: view_entity CONSUMPTION Package: VDM_EAM_MAINTJOB_MNG_CMP_UNPLN
27 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

Consumption layer unplanned components

C_MaintJobWorkItemUnplndCompTP is a Consumption CDS View that provides data about "Consumption layer unplanned components" in SAP S/4HANA. It reads from 1 data source (R_MaintJobWorkItemUnplndCompTP) and exposes 27 fields with key fields MaintenanceOrder, MaterialDocument, MaterialDocumentItem, MaterialDocumentYear. It is exposed through 1 OData service (UI_MAINTENANCEJOB_MANAGE). It is used in 1 Fiori application: Perform Maintenance Jobs. Part of development package VDM_EAM_MAINTJOB_MNG_CMP_UNPLN.

Data Sources (1)

SourceAliasJoin Type
R_MaintJobWorkItemUnplndCompTP R_MaintJobWorkItemUnplndCompTP from

Annotations (8)

NameValueLevelField
EndUserText.label Consumption layer unplanned components view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
ObjectModel.updateEnabled true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_MAINTENANCEJOB_MANAGE UI_MAINTENANCEJOB_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5104A Perform Maintenance Jobs Transactional Perform Maintenance Jobs app will help Maintenance Technician to see the list with all work items assigned to the him/her or to his/her team, several features like Assignment of an operation, Time recording for the Operations, create partial or final confirmations and the ability to display and change the malfunction information are possible with the app. The maintenance technician can post and return the planned components and can also record the measurement document.

Perform Maintenance Jobs

Business Role: Maintenance Technician

Technician records actual work, remaining work, confirmation text, and final confirmation for self as well as for team members working on the job.

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder Order
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
Material Material Vehicle Model
MaterialName MaterialName Material Description
Product Product Product Sold
Plant Plant Valuation Area
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
StorageLocation StorageLocation StorageLocation
MaterialBaseUnit MaterialBaseUnit Valuation Unit
QuantityInBaseUnit QuantityInBaseUnit Quantity
ValuationType ValuationType Valuation Type
SerialNumber SerialNumber Serial Number
Reservation Reservation Reservation
SerialNumberProcedure SerialNumberProcedure
SerialNumberProfile SerialNumberProfile SerialNoProfile
SerialNumberUsageInAssignment SerialNumberUsageInAssignment
InventoryValuationCategory InventoryValuationCategory
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
TechnicalObject TechnicalObject Technical Object
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
MaintenanceOrderType MaintenanceOrderType Order Type
MaterialDocumentItemText MaterialDocumentItemText Text
GoodsMovementType GoodsMovementType Movement Type
GoodsMovementTypeName GoodsMovementTypeName
ProductType ProductType Product Type Group

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_MaintJobWorkItemUnplndCompTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_MaintJobWorkItemUnplndCompTP AS
SELECT
  MaintenanceOrder,
  MaterialDocument,
  MaterialDocumentItem,
  MaterialDocumentYear,
  Material,
  MaterialName,
  Product,
  Plant,
  MaintenancePlanningPlant,
  StorageLocation,
  MaterialBaseUnit,
  QuantityInBaseUnit,
  ValuationType,
  SerialNumber,
  Reservation,
  SerialNumberProcedure,
  SerialNumberProfile,
  SerialNumberUsageInAssignment,
  InventoryValuationCategory,
  IsMarkedForDeletion,
  TechnicalObject,
  TechObjIsEquipOrFuncnlLoc,
  MaintenanceOrderType,
  MaterialDocumentItemText,
  GoodsMovementType,
  GoodsMovementTypeName,
  ProductType
FROM R_MaintJobWorkItemUnplndCompTP
;

Learn More