C_MaintJobWorkItemService

DDL: C_MAINTJOBWORKITEMSERVICE Type: view_entity CONSUMPTION
21 Fields 1 Data Sources

Planned service in work item

C_MaintJobWorkItemService is a Consumption CDS View that provides data about "Planned service in work item" in SAP S/4HANA. It reads from 1 data source (R_MaintJobWorkItemService) and exposes 21 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation, MaintOrderComponentInternalID.

Data Sources (1)

SourceAliasJoin Type
R_MaintJobWorkItemService R_MaintJobWorkItemService from

Annotations (8)

NameValueLevelField
EndUserText.label Planned service in work item view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder Order
KEY MaintenanceOrderOperation MaintenanceOrderOperation Suboperation
KEY MaintenanceOrderSubOperation MaintenanceOrderSubOperation Suboperation
KEY MaintOrderComponentInternalID MaintOrderComponentInternalID Object number
Material Material Vehicle Model
MaterialName MaterialName Material Description
RequirementQuantityInBaseUnit RequirementQuantityInBaseUnit
BaseUnit BaseUnit Unit of Measure
PerformancePeriodStartDateTime PerformancePeriodStartDateTime Time Stamp
PerformancePeriodEndDateTime PerformancePeriodEndDateTime Time Stamp
LeanServiceDuration LeanServiceDuration Service Duration
LeanServiceDurationUnit LeanServiceDurationUnit Serv. Dur. Unit
Supplier Supplier Supplier
OverallLimitAmount OverallLimitAmount Overall Limit
ExpectedOverallLimitAmount ExpectedOverallLimitAmount Expected Value
MaintOrdOpComponentCurrency MaintOrdOpComponentCurrency Currency
MaintenanceOrderComponent MaintenanceOrderComponent BOM item
ReservationIsFinallyIssued ReservationIsFinallyIssued Res Final Issue
WithdrawnQuantity WithdrawnQuantity Withdrawn Quantity
MaintOrderOpComponentPrice MaintOrderOpComponentPrice Price/currency
MaintOrdOpCompPriceUnitQty MaintOrdOpCompPriceUnitQty Price unit

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_MaintJobWorkItemService.
-- 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_MaintJobWorkItemService AS
SELECT
  MaintenanceOrder,
  MaintenanceOrderOperation,
  MaintenanceOrderSubOperation,
  MaintOrderComponentInternalID,
  Material,
  MaterialName,
  RequirementQuantityInBaseUnit,
  BaseUnit,
  PerformancePeriodStartDateTime,
  PerformancePeriodEndDateTime,
  LeanServiceDuration,
  LeanServiceDurationUnit,
  Supplier,
  OverallLimitAmount,
  ExpectedOverallLimitAmount,
  MaintOrdOpComponentCurrency,
  MaintenanceOrderComponent,
  ReservationIsFinallyIssued,
  WithdrawnQuantity,
  MaintOrderOpComponentPrice,
  MaintOrdOpCompPriceUnitQty
FROM R_MaintJobWorkItemService
;

Learn More