R_MaintOrderOpComponentDraft

DDL: R_MAINTORDEROPCOMPONENTDRAFT Type: view_entity BASIC Package: RAP_EAM_MAINTENANCEORDER
107 Fields 1 Data Sources 2 Associations

Maint Ord Oper Component Draft data

R_MaintOrderOpComponentDraft is a Basic CDS View that provides data about "Maint Ord Oper Component Draft data" in SAP S/4HANA. It reads from 1 data source (maintordopcomp_d) and exposes 107 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation, MaintenanceOrderComponent, DraftUUID. It has 2 associations to related views. Part of development package RAP_EAM_MAINTENANCEORDER.

Data Sources (1)

SourceAliasJoin Type
maintordopcomp_d maintordopcomp_d from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_MaintenanceOrder _MaintenanceOrder $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Maint Ord Oper Component Draft data view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (107)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder maintenanceorder Order
KEY MaintenanceOrderOperation maintenanceorderoperation Suboperation
KEY MaintenanceOrderSubOperation maintenanceordersuboperation Suboperation
KEY MaintenanceOrderComponent maintenanceordercomponent BOM item
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
MaintOrderOperationForEdit maintorderoperationforedit Operation
MaintOrderSubOperationForEdit maintordersuboperationforedit Suboperation
MaintOrderComponentForEdit maintordercomponentforedit BOM item
Reservation reservation Reservation
ReservationItem reservationitem Reservation Item
ReservationType reservationtype Record type
MaintOrderRoutingNumber maintorderroutingnumber Plan No.f.Oper.
MaintOrderOperationCounter maintorderoperationcounter Counter
Product product Product Sold
MaintOrdOperationComponentText maintordoperationcomponenttext Item Text
MaintOrdOpCompRequiredQuantity maintordopcomprequiredquantity Requirement qty
BaseUnit baseunit Unit of Measure
QuantityInUnitOfEntry quantityinunitofentry Quantity in UnE
UnitOfEntry unitofentry Unit of Entry
RequirementDate requirementdate Requirement Date
RequirementTime requirementtime Time qty req'd
RequirementDateTime requirementdatetime Time Stamp
Supplier supplier Supplier
Plant plant Valuation Area
StorageLocation storagelocation StorageLocation
MaintOrdOpCompItemCategory maintordopcompitemcategory Item Category
GoodsMovementType goodsmovementtype Movement Type
ReservationIsFinallyIssued reservationisfinallyissued Res Final Issue
MaterialGroup materialgroup Product Group
MaintOrdOpCompIsMRPRelevant maintordopcompismrprelevant Purchase Reqn. / Resvn. Generation
MaterialCompIsProcuredDirectly materialcompisprocureddirectly Checkbox
ProductTypeCode producttypecode Product Type Group
ServicePerformer serviceperformer Service Performer
PerformancePeriodStartDateTime performanceperiodstartdatetime Time Stamp
PerformancePeriodStartDate performanceperiodstartdate Start of Performance Period
PerformancePeriodStartTime performanceperiodstarttime Start Time
PerformancePeriodEndDateTime performanceperiodenddatetime Time Stamp
PerformancePeriodEndDate performanceperiodenddate End of Performance Period
PerformancePeriodEndTime performanceperiodendtime End Time
MaintOrdCompDeliveryDateAdjmt maintordcompdeliverydateadjmt Align Req. Date
LeanServiceDuration leanserviceduration Service Duration
LeanServiceDurationUnit leanservicedurationunit Serv. Dur. Unit
DistributionFunction distributionfunction Function
SrvcSchedgIsAlignedWthOpWrkCtr srvcschedgisalignedwthopwrkctr Align with Work Center
MaintOrderCompDebitCreditCode maintordercompdebitcreditcode Debit/Credit
GoodsMovementIsAllowed goodsmovementisallowed Mvt Allowed
MaintenanceOrderComponentBatch maintenanceordercomponentbatch Batch
MaintOrderComponentInternalID maintordercomponentinternalid Object number
QuantityIsFixed quantityisfixed Qty. is fixed
MaintOrdOpComponentCurrency maintordopcomponentcurrency Currency
MaintOrdOpComponentGLAccount maintordopcomponentglaccount G/L Account
MaintOrdOpCompCostingRelevancy maintordopcompcostingrelevancy CostingRelevncy
MaintCompAltvProdUsgeRateInPct maintcompaltvprodusgerateinpct Usage Prob.
MaintOrderOpComponentSortText maintorderopcomponentsorttext Sort String
MaintOrdOpCompIsBulkProduct maintordopcompisbulkproduct Bulk material
MaterialProvisionType materialprovisiontype Material Provision Type
MaintOrdOpCompAssgdWBSElmntInt maintordopcompassgdwbselmntint WBS Internal ID
WBSElement wbselement WBS Internal ID
MaintOrderOpComponentPrice maintorderopcomponentprice Price/currency
MaintOrdOpCompPriceUnitQty maintordopcomppriceunitqty Price unit
MatlCompIsMarkedForBackflush matlcompismarkedforbackflush Backflush
PurchasingGroup purchasinggroup Purchasing Group
DeliveryTimeInDays deliverytimeindays Delivery Time in Days
MaintOrdOpCompGdsRecipientName maintordopcompgdsrecipientname Recipient
MaintOrdOpCompUnloadingPtTxt maintordopcompunloadingpttxt Unloading Point
GoodsReceiptDurationInWorkDays goodsreceiptdurationinworkdays GR proc. time
PurchasingInfoRecord purchasinginforecord Info Record
OperationLeadTimeOffset operationleadtimeoffset Oper. LT offset
OpsLeadTimeOffsetUnit opsleadtimeoffsetunit Oper. LTO unit
MaintOrdOpCompRequisitioner maintordopcomprequisitioner Requisitioner
MaintOrdOpCompProcmtTrckgNmbr maintordopcompprocmttrckgnmbr Tracking Number
ResponsiblePurchaseOrg responsiblepurchaseorg Purchasing Org.
PurchaseRequisition purchaserequisition Requisition
PurchaseRequisitionItem purchaserequisitionitem Requisn. item
OverallLimitAmount overalllimitamount Overall Limit
ExpectedOverallLimitAmount expectedoveralllimitamount Expected Value
MaintOrdOpCompSpecialStockType maintordopcompspecialstocktype Special Stock
VariableSizeDimension1 variablesizedimension1 Size 1
VariableSizeDimensionUnit variablesizedimensionunit Size unit
VariableSizeCompFormulaKey variablesizecompformulakey VSI Formula
VariableSizeDimension2 variablesizedimension2 Size 2
NumberOfVariableSizeItem numberofvariablesizeitem Number Required
VariableSizeDimension3 variablesizedimension3 Size 3
VariableSizeItemQuantity variablesizeitemquantity VSI Quantity
VariableSizeComponentUnit variablesizecomponentunit VSI UoM
RqmtDateIsEnteredManually rqmtdateisenteredmanually Man. Reqmt Date
SupplierProduct supplierproduct Supp.Pro.No.
MaintOrdCompCmtdQtyIsKept maintordcompcmtdqtyiskept Keep Committed Qties
MaintOrdOpCompPurOutlineAgrmt maintordopcomppuroutlineagrmt Purchasing Doc.
MaintOrdCompPurOutlineAgrmtItm maintordcomppuroutlineagrmtitm Item
IsDeleted isdeleted TRUE
MaintOrdOpCompProcmtCatalog maintordopcompprocmtcatalog Catalog ID
MaintOrdOpCompProcmtCatalogItm maintordopcompprocmtcatalogitm Product ID
QuantityWithdrawnInBaseUnit quantitywithdrawninbaseunit Withdrawal Qty
ControllingArea controllingarea Controlling Area
MaintenanceOrderDraftUUID maintenanceorderdraftuuid Draft Document ID
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes
ConfirmedAvailableQuantity confirmedavailablequantity Available Quantity
RecipientLocationCode recipientlocationcode Recipient Loc.
_MaintenanceOrder _MaintenanceOrder
_Supplier _Supplier

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_MaintOrderOpComponentDraft.
-- 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_MaintOrderOpComponentDraft AS
SELECT
  MaintenanceOrder,
  MaintenanceOrderOperation,
  MaintenanceOrderSubOperation,
  MaintenanceOrderComponent,
  DraftUUID,
  ParentDraftUUID,
  MaintOrderOperationForEdit,
  MaintOrderSubOperationForEdit,
  MaintOrderComponentForEdit,
  Reservation,
  ReservationItem,
  ReservationType,
  MaintOrderRoutingNumber,
  MaintOrderOperationCounter,
  Product,
  MaintOrdOperationComponentText,
  MaintOrdOpCompRequiredQuantity,
  BaseUnit,
  QuantityInUnitOfEntry,
  UnitOfEntry,
  RequirementDate,
  RequirementTime,
  RequirementDateTime,
  Supplier,
  Plant,
  StorageLocation,
  MaintOrdOpCompItemCategory,
  GoodsMovementType,
  ReservationIsFinallyIssued,
  MaterialGroup,
  MaintOrdOpCompIsMRPRelevant,
  MaterialCompIsProcuredDirectly,
  ProductTypeCode,
  ServicePerformer,
  PerformancePeriodStartDateTime,
  PerformancePeriodStartDate,
  PerformancePeriodStartTime,
  PerformancePeriodEndDateTime,
  PerformancePeriodEndDate,
  PerformancePeriodEndTime,
  MaintOrdCompDeliveryDateAdjmt,
  LeanServiceDuration,
  LeanServiceDurationUnit,
  DistributionFunction,
  SrvcSchedgIsAlignedWthOpWrkCtr,
  MaintOrderCompDebitCreditCode,
  GoodsMovementIsAllowed,
  MaintenanceOrderComponentBatch,
  MaintOrderComponentInternalID,
  QuantityIsFixed,
  MaintOrdOpComponentCurrency,
  MaintOrdOpComponentGLAccount,
  MaintOrdOpCompCostingRelevancy,
  MaintCompAltvProdUsgeRateInPct,
  MaintOrderOpComponentSortText,
  MaintOrdOpCompIsBulkProduct,
  MaterialProvisionType,
  MaintOrdOpCompAssgdWBSElmntInt,
  WBSElement,
  MaintOrderOpComponentPrice,
  MaintOrdOpCompPriceUnitQty,
  MatlCompIsMarkedForBackflush,
  PurchasingGroup,
  DeliveryTimeInDays,
  MaintOrdOpCompGdsRecipientName,
  MaintOrdOpCompUnloadingPtTxt,
  GoodsReceiptDurationInWorkDays,
  PurchasingInfoRecord,
  OperationLeadTimeOffset,
  OpsLeadTimeOffsetUnit,
  MaintOrdOpCompRequisitioner,
  MaintOrdOpCompProcmtTrckgNmbr,
  ResponsiblePurchaseOrg,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  OverallLimitAmount,
  ExpectedOverallLimitAmount,
  MaintOrdOpCompSpecialStockType,
  VariableSizeDimension1,
  VariableSizeDimensionUnit,
  VariableSizeCompFormulaKey,
  VariableSizeDimension2,
  NumberOfVariableSizeItem,
  VariableSizeDimension3,
  VariableSizeItemQuantity,
  VariableSizeComponentUnit,
  RqmtDateIsEnteredManually,
  SupplierProduct,
  MaintOrdCompCmtdQtyIsKept,
  MaintOrdOpCompPurOutlineAgrmt,
  MaintOrdCompPurOutlineAgrmtItm,
  IsDeleted,
  MaintOrdOpCompProcmtCatalog,
  MaintOrdOpCompProcmtCatalogItm,
  QuantityWithdrawnInBaseUnit,
  ControllingArea,
  MaintenanceOrderDraftUUID,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges,
  ConfirmedAvailableQuantity,
  RecipientLocationCode
FROM maintordopcomp_d
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
;

Learn More