I_MaintOrdOpRqmtAssgmtCurUsr

DDL: I_MAINTORDOPRQMTASSGMTCURUSR Type: view_entity COMPOSITE
20 Fields 2 Data Sources

Maint Ord Oper Rqmt Assgmt Cur User

I_MaintOrdOpRqmtAssgmtCurUsr is a Composite CDS View that provides data about "Maint Ord Oper Rqmt Assgmt Cur User" in SAP S/4HANA. It reads from 2 data sources (I_MaintOrderOpRqmtAssgmt, I_PersWrkAgrmtSrchHelp) and exposes 20 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation, MaintenanceOrderOperationSplit.

Data Sources (2)

SourceAliasJoin Type
I_MaintOrderOpRqmtAssgmt _MaintOrderOpRqmtAssgmt from
I_PersWrkAgrmtSrchHelp _PersWrkAgrmtSrchHelp inner

Annotations (6)

NameValueLevelField
EndUserText.label Maint Ord Oper Rqmt Assgmt Cur User view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder I_MaintOrderOpRqmtAssgmt MaintenanceOrder Order
KEY MaintenanceOrderOperation I_MaintOrderOpRqmtAssgmt MaintenanceOrderOperation Suboperation
KEY MaintenanceOrderSubOperation I_MaintOrderOpRqmtAssgmt MaintenanceOrderSubOperation Suboperation
KEY MaintenanceOrderOperationSplit I_MaintOrderOpRqmtAssgmt MaintenanceOrderOperationSplit Splitting
CapacityRequirement I_MaintOrderOpRqmtAssgmt CapacityRequirement Id number
CapacityRequirementItem I_MaintOrderOpRqmtAssgmt CapacityRequirementItem Counter
CapacityRqmtItemCapacity I_MaintOrderOpRqmtAssgmt CapacityRqmtItemCapacity Wrk ctr cap no
MaintOrderRoutingNumber I_MaintOrderOpRqmtAssgmt MaintOrderRoutingNumber Plan No.f.Oper.
MaintOrderOperationCounter I_MaintOrderOpRqmtAssgmt MaintOrderOperationCounter Counter
MaintWorkCenterPersonID I_MaintOrderOpRqmtAssgmt MaintWorkCenterPersonID Personnel no.
OperationEarliestStartDate I_MaintOrderOpRqmtAssgmt OperationEarliestStartDate Erlst Strt Date
OperationEarliestStartTime I_MaintOrderOpRqmtAssgmt OperationEarliestStartTime Erlst Strt Time
OperationEarliestEndDate I_MaintOrderOpRqmtAssgmt OperationEarliestEndDate Erlst End Date
OperationEarliestEndTime I_MaintOrderOpRqmtAssgmt OperationEarliestEndTime Erlst End Time
AssignedMaintOpStartDateTime I_MaintOrderOpRqmtAssgmt AssignedMaintOpStartDateTime
AssignedMaintOpEndDateTime I_MaintOrderOpRqmtAssgmt AssignedMaintOpEndDateTime
AssignedMaintOpWork I_MaintOrderOpRqmtAssgmt AssignedMaintOpWork Work
AssignedMaintOpWorkUnit I_MaintOrderOpRqmtAssgmt AssignedMaintOpWorkUnit Unit for work
AssignedMaintOpDuration I_MaintOrderOpRqmtAssgmt AssignedMaintOpDuration Normal duration
AssignedMaintOpDurationUnit I_MaintOrderOpRqmtAssgmt AssignedMaintOpDurationUnit Norm.duratn un.

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 I_MaintOrdOpRqmtAssgmtCurUsr.
-- 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 I_MaintOrdOpRqmtAssgmtCurUsr AS
SELECT
  _MaintOrderOpRqmtAssgmt.MaintenanceOrder AS MaintenanceOrder,
  _MaintOrderOpRqmtAssgmt.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  _MaintOrderOpRqmtAssgmt.MaintenanceOrderSubOperation AS MaintenanceOrderSubOperation,
  _MaintOrderOpRqmtAssgmt.MaintenanceOrderOperationSplit AS MaintenanceOrderOperationSplit,
  _MaintOrderOpRqmtAssgmt.CapacityRequirement AS CapacityRequirement,
  _MaintOrderOpRqmtAssgmt.CapacityRequirementItem AS CapacityRequirementItem,
  _MaintOrderOpRqmtAssgmt.CapacityRqmtItemCapacity AS CapacityRqmtItemCapacity,
  _MaintOrderOpRqmtAssgmt.MaintOrderRoutingNumber AS MaintOrderRoutingNumber,
  _MaintOrderOpRqmtAssgmt.MaintOrderOperationCounter AS MaintOrderOperationCounter,
  _MaintOrderOpRqmtAssgmt.MaintWorkCenterPersonID AS MaintWorkCenterPersonID,
  _MaintOrderOpRqmtAssgmt.OperationEarliestStartDate AS OperationEarliestStartDate,
  _MaintOrderOpRqmtAssgmt.OperationEarliestStartTime AS OperationEarliestStartTime,
  _MaintOrderOpRqmtAssgmt.OperationEarliestEndDate AS OperationEarliestEndDate,
  _MaintOrderOpRqmtAssgmt.OperationEarliestEndTime AS OperationEarliestEndTime,
  _MaintOrderOpRqmtAssgmt.AssignedMaintOpStartDateTime AS AssignedMaintOpStartDateTime,
  _MaintOrderOpRqmtAssgmt.AssignedMaintOpEndDateTime AS AssignedMaintOpEndDateTime,
  _MaintOrderOpRqmtAssgmt.AssignedMaintOpWork AS AssignedMaintOpWork,
  _MaintOrderOpRqmtAssgmt.AssignedMaintOpWorkUnit AS AssignedMaintOpWorkUnit,
  _MaintOrderOpRqmtAssgmt.AssignedMaintOpDuration AS AssignedMaintOpDuration,
  _MaintOrderOpRqmtAssgmt.AssignedMaintOpDurationUnit AS AssignedMaintOpDurationUnit
FROM I_MaintOrderOpRqmtAssgmt AS _MaintOrderOpRqmtAssgmt
INNER JOIN I_PersWrkAgrmtSrchHelp AS _PersWrkAgrmtSrchHelp ON /* join condition not captured in parsed metadata */
;

Learn More