R_MaintenanceOrderDraft

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 R_MaintenanceOrderDraft.
-- 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 R_MaintenanceOrderDraft AS
SELECT
  maintord_d.maintenanceorder AS MaintenanceOrder,
  maintord_d.draftuuid AS DraftUUID,
  maintord_d.maintorderroutingnumber AS MaintOrderRoutingNumber,
  maintord_d.maintenanceordertype AS MaintenanceOrderType,
  maintord_d.maintenanceorderdesc AS MaintenanceOrderDesc,
  maintord_d.maintordbasicstartdatetime AS MaintOrdBasicStartDateTime,
  maintord_d.maintordbasicenddatetime AS MaintOrdBasicEndDateTime,
  maintord_d.maintordbasicstartdate AS MaintOrdBasicStartDate,
  maintord_d.maintordbasicstarttime AS MaintOrdBasicStartTime,
  maintord_d.maintordbasicenddate AS MaintOrdBasicEndDate,
  maintord_d.maintordbasicendtime AS MaintOrdBasicEndTime,
  maintord_d.maintordschedldbscstrtdatetime AS MaintOrdSchedldBscStrtDateTime,
  maintord_d.maintordschedldbscenddatetime AS MaintOrdSchedldBscEndDateTime,
  maintord_d.scheduledbasicstartdate AS ScheduledBasicStartDate,
  maintord_d.scheduledbasicstarttime AS ScheduledBasicStartTime,
  maintord_d.scheduledbasicenddate AS ScheduledBasicEndDate,
  maintord_d.scheduledbasicendtime AS ScheduledBasicEndTime,
  maintord_d.maintorderreferencedatetime AS MaintOrderReferenceDateTime,
  maintord_d.maintorderreferencedate AS MaintOrderReferenceDate,
  maintord_d.maintorderreferencetime AS MaintOrderReferenceTime,
  maintord_d.mainworkcompleteddatetime AS MainWorkCompletedDateTime,
  maintord_d.maintenancenotification AS MaintenanceNotification,
  maintord_d.ordisnotschedldautomatically AS OrdIsNotSchedldAutomatically,
  maintord_d.mainworkcenterinternalid AS MainWorkCenterInternalID,
  maintord_d.mainworkcentertypecode AS MainWorkCenterTypeCode,
  maintord_d.mainworkcenter AS MainWorkCenter,
  maintord_d.mainworkcenterplant AS MainWorkCenterPlant,
  maintord_d.controllingarea AS ControllingArea,
  maintord_d.servicedocumenttype AS ServiceDocumentType,
  maintord_d.servicedocument AS ServiceDocument,
  maintord_d.servicedocumentitem AS ServiceDocumentItem,
  maintord_d.maintenanceplanningplant AS MaintenancePlanningPlant,
  maintord_d.assembly AS Assembly,
  maintord_d.maintordprocessphasecode AS MaintOrdProcessPhaseCode,
  maintord_d.maintordprocesssubphasecode AS MaintOrdProcessSubPhaseCode,
  maintord_d.companycode AS CompanyCode,
  maintord_d.businessarea AS BusinessArea,
  maintord_d.maintenanceorderuuid AS MaintenanceOrderUUID,
  maintord_d.referenceelement AS ReferenceElement,
  maintord_d.functionalarea AS FunctionalArea,
  maintord_d.additionaldevicedata AS AdditionalDeviceData,
  maintord_d.equipment AS Equipment,
  maintord_d.maintenanceorderplanningcode AS MaintenanceOrderPlanningCode,
  maintord_d.maintenanceplannergroup AS MaintenancePlannerGroup,
  maintord_d.maintenanceactivitytype AS MaintenanceActivityType,
  maintord_d.maintpriority AS MaintPriority,
  maintord_d.maintprioritytype AS MaintPriorityType,
  maintord_d.orderprocessinggroup AS OrderProcessingGroup,
  maintord_d.profitcenter AS ProfitCenter,
  maintord_d.responsiblecostcenter AS ResponsibleCostCenter,
  maintord_d.costingsheet AS CostingSheet,
  maintord_d.conditionusage AS ConditionUsage,
  maintord_d.conditionapplication AS ConditionApplication,
  maintord_d.currency AS Currency,
  maintord_d.maintenancerevision AS MaintenanceRevision,
  maintord_d.serialnumber AS SerialNumber,
  maintord_d.product AS Product,
  maintord_d.superiorprojectnetwork AS SuperiorProjectNetwork,
  maintord_d.operationsystemcondition AS OperationSystemCondition,
  maintord_d.wbselementinternalid AS WBSElementInternalID,
  maintord_d.projectinternalid AS ProjectInternalID,
  maintord_d.locacctassgmtwbselmntintid AS LocAcctAssgmtWBSElmntIntID,
  maintord_d.costcenter AS CostCenter,
  maintord_d.controllingobjectclass AS ControllingObjectClass,
  maintord_d.functionallocation AS FunctionalLocation,
  maintord_d.maintenanceplant AS MaintenancePlant,
  maintord_d.assetlocation AS AssetLocation,
  maintord_d.assetroom AS AssetRoom,
  maintord_d.plantsection AS PlantSection,
  maintord_d.abcindicator AS ABCIndicator,
  maintord_d.maintobjectfreedefinedattrib AS MaintObjectFreeDefinedAttrib,
  maintord_d.workcenterinternalid AS WorkCenterInternalID,
  maintord_d.workcentertypecode AS WorkCenterTypeCode,
  maintord_d.workcenter AS WorkCenter,
  maintord_d.locacctassgmtbusinessarea AS LocAcctAssgmtBusinessArea,
  maintord_d.settlementorder AS SettlementOrder,
  maintord_d.masterfixedasset AS MasterFixedAsset,
  maintord_d.fixedasset AS FixedAsset,
  maintord_d.standingordernumber AS StandingOrderNumber,
  maintord_d.salesorganization AS SalesOrganization,
  maintord_d.distributionchannel AS DistributionChannel,
  maintord_d.organizationdivision AS OrganizationDivision,
  maintord_d.locacctassgmtcontrollingarea AS LocAcctAssgmtControllingArea,
  maintord_d.locacctassgmtcompanycode AS LocAcctAssgmtCompanyCode,
  maintord_d.maintenanceorderinternalid AS MaintenanceOrderInternalID,
  maintord_d.maintenanceitemobjectlist AS MaintenanceItemObjectList,
  maintord_d.maintobjectlocacctassgmtnmbr AS MaintObjectLocAcctAssgmtNmbr,
  maintord_d.controllingsettlementprofile AS ControllingSettlementProfile,
  maintord_d.basicschedulingtype AS BasicSchedulingType,
  maintord_d.latestacceptablecompletiondate AS LatestAcceptableCompletionDate,
  maintord_d.maintordpersonresponsible AS MaintOrdPersonResponsible,
  maintord_d.lastchangebyuser AS LastChangeByUser,
  maintord_d.lastchangedatetime AS LastChangeDateTime,
  maintord_d.createdbyuser AS CreatedByUser,
  maintord_d.maintordercreationdatetime AS MaintOrderCreationDateTime,
  maintord_d.orderhaslongtext AS OrderHasLongText,
  maintord_d.maintorderprocessingcontext AS MaintOrderProcessingContext,
  maintord_d.maintenanceorderoverheadcode AS MaintenanceOrderOverheadCode,
  maintord_d.plannedcostscostingvariant AS PlannedCostsCostingVariant,
  maintord_d.actualcostscostingvariant AS ActualCostsCostingVariant,
  maintord_d.maintenanceplan AS MaintenancePlan,
  maintord_d.maintenancecall AS MaintenanceCall,
  maintord_d.maintenanceitem AS MaintenanceItem,
  maintord_d.leadingorder AS LeadingOrder,
  maintord_d.tasklisttype AS TaskListType,
  maintord_d.tasklistgroup AS TaskListGroup,
  maintord_d.tasklistgroupcounter AS TaskListGroupCounter,
  maintord_d.orderisrefurbishmentorder AS OrderIsRefurbishmentOrder,
  maintord_d.accountingindicatorcode AS AccountingIndicatorCode,
  maintord_d.maintenanceprocessingphase AS MaintenanceProcessingPhase,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM maintord_d
LEFT OUTER JOIN I_LocationAccountAssignment AS _LocationAccountAssignment ON MaintObjectLocAcctAssgmtNmbr = _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN E_MaintenanceOrderDraft AS _Extension ON MaintenanceOrder = _Extension.MaintenanceOrder AND DraftUUID = _Extension.DraftUUID  -- association [0..1]
;