R_MaintOrderOpComponentDraft_2

DDL: R_MAINTORDEROPCOMPONENTDRAFT_2 Type: view_entity BASIC
106 Fields 1 Data Sources 1 Associations

Maint Ord Oper Component Draft data

R_MaintOrderOpComponentDraft_2 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 (maintordopcmp2_d) and exposes 106 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation, MaintOrderComponentInternalID, DraftUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
maintordopcmp2_d maintordopcmp2_d from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_MaintenanceOrderDraft _MaintenanceOrder $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder and $projection.MaintenanceOrderDraftUUID = _MaintenanceOrder.DraftUUID

Annotations (8)

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

Fields (106)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder maintenanceorder Order
KEY MaintenanceOrderOperation maintenanceorderoperation Suboperation
KEY MaintenanceOrderSubOperation maintenanceordersuboperation Suboperation
KEY MaintOrderComponentInternalID maintordercomponentinternalid Object number
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
MaintOrderOperationForEdit maintorderoperationforedit Operation
MaintOrderSubOperationForEdit maintordersuboperationforedit Suboperation
OperationDescription operationdescription Op. Short Text
Reservation reservation Reservation
ReservationItem reservationitem Reservation Item
ReservationType reservationtype Record type
MaintenanceOrderComponent maintenanceordercomponent BOM item
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
PurReqnOrResvnGeneration purreqnorresvngeneration 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
LeanServiceDuration leanserviceduration Service Duration
LeanServiceDurationUnit leanservicedurationunit Serv. Dur. Unit
DistributionFunction distributionfunction Function
MaintOrdCompDeliveryDateAdjmt maintordcompdeliverydateadjmt Align Req. Date
SrvcSchedgIsAlignedWthOpWrkCtr srvcschedgisalignedwthopwrkctr Align with Work Center
MaintOrderCompDebitCreditCode maintordercompdebitcreditcode Debit/Credit
GoodsMovementIsAllowed goodsmovementisallowed Mvt Allowed
MaintenanceOrderComponentBatch maintenanceordercomponentbatch Batch
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
ConfirmedAvailableQuantity confirmedavailablequantity Available Quantity
RecipientLocationCode recipientlocationcode Recipient Loc.
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
_MaintenanceOrder _MaintenanceOrder

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_2.
-- 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_2 AS
SELECT
  MaintenanceOrder,
  MaintenanceOrderOperation,
  MaintenanceOrderSubOperation,
  MaintOrderComponentInternalID,
  DraftUUID,
  ParentDraftUUID,
  MaintOrderOperationForEdit,
  MaintOrderSubOperationForEdit,
  OperationDescription,
  Reservation,
  ReservationItem,
  ReservationType,
  MaintenanceOrderComponent,
  MaintOrderRoutingNumber,
  MaintOrderOperationCounter,
  Product,
  MaintOrdOperationComponentText,
  MaintOrdOpCompRequiredQuantity,
  BaseUnit,
  QuantityInUnitOfEntry,
  UnitOfEntry,
  RequirementDate,
  RequirementTime,
  RequirementDateTime,
  Supplier,
  Plant,
  StorageLocation,
  MaintOrdOpCompItemCategory,
  GoodsMovementType,
  ReservationIsFinallyIssued,
  MaterialGroup,
  PurReqnOrResvnGeneration,
  MaterialCompIsProcuredDirectly,
  ProductTypeCode,
  ServicePerformer,
  PerformancePeriodStartDateTime,
  PerformancePeriodStartDate,
  PerformancePeriodStartTime,
  PerformancePeriodEndDateTime,
  PerformancePeriodEndDate,
  PerformancePeriodEndTime,
  LeanServiceDuration,
  LeanServiceDurationUnit,
  DistributionFunction,
  MaintOrdCompDeliveryDateAdjmt,
  SrvcSchedgIsAlignedWthOpWrkCtr,
  MaintOrderCompDebitCreditCode,
  GoodsMovementIsAllowed,
  MaintenanceOrderComponentBatch,
  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,
  ConfirmedAvailableQuantity,
  RecipientLocationCode,
  ControllingArea,
  MaintenanceOrderDraftUUID,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM maintordopcmp2_d
LEFT OUTER JOIN R_MaintenanceOrderDraft AS _MaintenanceOrder ON MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder AND MaintenanceOrderDraftUUID = _MaintenanceOrder.DraftUUID  -- association [1..1]
;

Learn More