C_MaintOrderOpComponentTP

DDL: C_MAINTORDEROPCOMPONENTTP Type: view_entity CONSUMPTION
97 Fields 1 Data Sources 2 Associations

Maint Order Oper Component

C_MaintOrderOpComponentTP is a Consumption CDS View that provides data about "Maint Order Oper Component" in SAP S/4HANA. It reads from 1 data source (R_MaintOrderOpComponentTP_2) and exposes 97 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation, MaintOrderComponentInternalID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_MaintOrderOpComponentTP_2 R_MaintOrderOpComponentTP_2 projection

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_MaintOrdRsceAvailyStatus _MaintOrdAvailabilityStatus _MaintOrdAvailabilityStatus.MaintenanceOrder = R_MaintOrderOpComponentTP_2.MaintenanceOrder and _MaintOrdAvailabilityStatus.MaintOrdProcurementDocument = R_MaintOrderOpComponentTP_2.MaintOrderComponentInternalID
[0..*] C_MaintOrdPurOrderItem _PurchaseOrder $projection.PurchaseRequisition = _PurchaseOrder.PurchaseRequisition and $projection.PurchaseRequisitionItem = _PurchaseOrder.PurchaseRequisitionItem and _PurchaseOrder.PurchaseRequisition is not initial

Annotations (9)

NameValueLevelField
EndUserText.label Maint Order Oper Component view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view

Fields (97)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder Order
KEY MaintenanceOrderOperation MaintenanceOrderOperation Suboperation
KEY MaintenanceOrderSubOperation MaintenanceOrderSubOperation Suboperation
KEY MaintOrderComponentInternalID MaintOrderComponentInternalID Object number
SAPObjectNodeType SAPObjectNodeType SONT Name
MaintOrdOpCompReuseObjLinkKey MaintOrdOpCompReuseObjLinkKey
MaintenanceOrderComponent MaintenanceOrderComponent BOM item
MaintOrderOperationForEdit MaintOrderOperationForEdit Operation
MaintOrderSubOperationForEdit MaintOrderSubOperationForEdit Suboperation
OperationDescription _MaintenanceOrderOperation OperationDescription Op. Short Text
Product Product Product Sold
MaintOrdOperationComponentText MaintOrdOperationComponentText Item Text
MaintOrdOpCompItemCategory MaintOrdOpCompItemCategory Item Category
QuantityInUnitOfEntry QuantityInUnitOfEntry Quantity in UnE
QuantityIsFixed QuantityIsFixed Qty. is fixed
UnitOfEntry UnitOfEntry Unit of Entry
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
RequirementDateTime RequirementDateTime Time Stamp
MaintOrdCompDeliveryDateAdjmt MaintOrdCompDeliveryDateAdjmt Align Req. Date
MaintOrdCompDelivDateAdjmtTextlocalized
StorageLocation StorageLocation StorageLocation
StorageLocationName _StorageLocation StorageLocationName Storage Loc. Name
MaintOrderOpComponentPrice MaintOrderOpComponentPrice Price/currency
MaintOrdOpCompPriceUnitQty MaintOrdOpCompPriceUnitQty Price unit
MaintOrdOpComponentCurrency MaintOrdOpComponentCurrency Currency
PurchasingOrganizationName _PurchasingOrganization PurchasingOrganizationName Purch. Org. Name
ResponsiblePurchaseOrg ResponsiblePurchaseOrg Purchasing Org.
PurchasingGroupName _PurchasingGroup PurchasingGroupName Purchasing Grp. Name
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingInfoRecord PurchasingInfoRecord Info Record
Supplier Supplier Supplier
SupplierName _Supplier SupplierName Supplier Name
SupplierProduct SupplierProduct Supp.Pro.No.
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
MaintOrdOpComponentGLAccount MaintOrdOpComponentGLAccount G/L Account
CostElementNamelocalized
PurReqnOrResvnGeneration PurReqnOrResvnGeneration Purchase Reqn. / Resvn. Generation
PurReqnOrResvnGenerationNamelocalized
MaterialGroupNamelocalized
MaterialGroup MaterialGroup Product Group
ServicePerformer ServicePerformer Service Performer
MatlCompIsMarkedForBackflush MatlCompIsMarkedForBackflush Backflush
MaintenanceOrderComponentBatch MaintenanceOrderComponentBatch Batch
MaintOrdOpCompIsBulkProduct MaintOrdOpCompIsBulkProduct Bulk material
MaintOrdOpCompProcmtCatalog MaintOrdOpCompProcmtCatalog Catalog ID
MaintOrdOpCompProcmtCatalogItm MaintOrdOpCompProcmtCatalogItm Product ID
ConfirmedAvailableQuantity ConfirmedAvailableQuantity Available Quantity
DeliveryTimeInDays DeliveryTimeInDays Delivery Time in Days
ReservationIsFinallyIssued ReservationIsFinallyIssued Res Final Issue
MaintOrdOpCompGdsRecipientName MaintOrdOpCompGdsRecipientName Recipient
MaintOrdOpCompUnloadingPtTxt MaintOrdOpCompUnloadingPtTxt Unloading Point
GoodsReceiptDurationInWorkDays GoodsReceiptDurationInWorkDays GR proc. time
ReservationItem ReservationItem Reservation Item
MaintOrdCompCmtdQtyIsKept MaintOrdCompCmtdQtyIsKept Keep Committed Qties
GoodsMovementType GoodsMovementType Movement Type
OperationLeadTimeOffset OperationLeadTimeOffset Oper. LT offset
LeanServiceDuration LeanServiceDuration Service Duration
LeanServiceDurationUnit LeanServiceDurationUnit Serv. Dur. Unit
SrvcSchedgIsAlignedWthOpWrkCtr SrvcSchedgIsAlignedWthOpWrkCtr Align with Work Center
OpsLeadTimeOffsetUnit OpsLeadTimeOffsetUnit Oper. LTO unit
PerformancePeriodStartDateTime PerformancePeriodStartDateTime Time Stamp
PerformancePeriodEndDateTime PerformancePeriodEndDateTime Time Stamp
OverallLimitAmount OverallLimitAmount Overall Limit
ExpectedOverallLimitAmount ExpectedOverallLimitAmount Expected Value
MaintOrdOpCompPurOutlineAgrmt MaintOrdOpCompPurOutlineAgrmt Purchasing Doc.
MaintOrdCompPurOutlineAgrmtItm MaintOrdCompPurOutlineAgrmtItm Item
QuantityWithdrawnInBaseUnit QuantityWithdrawnInBaseUnit Withdrawal Qty
RecipientLocationCode RecipientLocationCode Recipient Loc.
ReservationType ReservationType Record type
MaintOrdOpCompProcmtTrckgNmbr MaintOrdOpCompProcmtTrckgNmbr Tracking Number
MaintOrdOpCompRequisitioner MaintOrdOpCompRequisitioner Requisitioner
Reservation Reservation Reservation
MaintOrderOpComponentSortText MaintOrderOpComponentSortText Sort String
MaintOrdOpCompRequiredQuantity MaintOrdOpCompRequiredQuantity Requirement qty
BaseUnit BaseUnit Unit of Measure
UnitOfMeasureLongNamelocalized
ProductTypeCode ProductTypeCode Product Type Group
ReceivedQuantity _CompRcvdQuantity ReceivedQuantity Quantity Received
NetAmount _CompRcvdQuantity NetAmount Stated Amount
ConfirmedQuantity _CompRcvdQuantity ConfirmedQuantity Quantity in UnE
virtualResvnItmIsNotServiceabap_boolean
virtualResvnItmIsLeanServiceabap_boolean
char100
MaintOrdCompLongTextLanguage MaintOrdCompLongTextLanguage
MaintOrdCompCommentLanguage MaintOrdCompCommentLanguage
MaintOrdCompRemarkLanguage MaintOrdCompRemarkLanguage
MaintOrdComponentNoteLanguage MaintOrdComponentNoteLanguage
MaterialNamelocalized
BusinessPartnerName1 _Supplier BusinessPartnerName1 Name
BusinessPartnerName2 _Supplier BusinessPartnerName2 Name 2
MaintenanceOrderType MaintenanceOrderType Order Type
ComponentDescription ComponentDescription Item Text
_Supplier _Supplier
_MaintOrdAvailabilityStatus _MaintOrdAvailabilityStatus
_PurchaseOrder _PurchaseOrder

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_MaintOrderOpComponentTP.
-- 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_MaintOrderOpComponentTP AS
SELECT
  MaintenanceOrder,
  MaintenanceOrderOperation,
  MaintenanceOrderSubOperation,
  MaintOrderComponentInternalID,
  SAPObjectNodeType,
  MaintOrdOpCompReuseObjLinkKey,
  MaintenanceOrderComponent,
  MaintOrderOperationForEdit,
  MaintOrderSubOperationForEdit,
  _MaintenanceOrderOperation.OperationDescription AS OperationDescription,
  Product,
  MaintOrdOperationComponentText,
  MaintOrdOpCompItemCategory,
  QuantityInUnitOfEntry,
  QuantityIsFixed,
  UnitOfEntry,
  Plant,
  _Plant.PlantName AS PlantName,
  RequirementDateTime,
  MaintOrdCompDeliveryDateAdjmt,
  _MaintOrdCompDelivDateAdjmtT.MaintOrdCompDelivDateAdjmtText : localized AS MaintOrdCompDelivDateAdjmtTextlocalized,
  StorageLocation,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  MaintOrderOpComponentPrice,
  MaintOrdOpCompPriceUnitQty,
  MaintOrdOpComponentCurrency,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  ResponsiblePurchaseOrg,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  PurchasingGroup,
  PurchasingInfoRecord,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  SupplierProduct,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  MaintOrdOpComponentGLAccount,
  _CostElement._Text.CostElementName : localized AS CostElementNamelocalized,
  PurReqnOrResvnGeneration,
  _PurReqnOrResvnGenerationText.PurReqnOrResvnGenerationName : localized AS PurReqnOrResvnGenerationNamelocalized,
  _MaterialGroupText.MaterialGroupName : localized AS MaterialGroupNamelocalized,
  MaterialGroup,
  ServicePerformer,
  MatlCompIsMarkedForBackflush,
  MaintenanceOrderComponentBatch,
  MaintOrdOpCompIsBulkProduct,
  MaintOrdOpCompProcmtCatalog,
  MaintOrdOpCompProcmtCatalogItm,
  ConfirmedAvailableQuantity,
  DeliveryTimeInDays,
  ReservationIsFinallyIssued,
  MaintOrdOpCompGdsRecipientName,
  MaintOrdOpCompUnloadingPtTxt,
  GoodsReceiptDurationInWorkDays,
  ReservationItem,
  MaintOrdCompCmtdQtyIsKept,
  GoodsMovementType,
  OperationLeadTimeOffset,
  LeanServiceDuration,
  LeanServiceDurationUnit,
  SrvcSchedgIsAlignedWthOpWrkCtr,
  OpsLeadTimeOffsetUnit,
  PerformancePeriodStartDateTime,
  PerformancePeriodEndDateTime,
  OverallLimitAmount,
  ExpectedOverallLimitAmount,
  MaintOrdOpCompPurOutlineAgrmt,
  MaintOrdCompPurOutlineAgrmtItm,
  QuantityWithdrawnInBaseUnit,
  RecipientLocationCode,
  ReservationType,
  MaintOrdOpCompProcmtTrckgNmbr,
  MaintOrdOpCompRequisitioner,
  Reservation,
  MaintOrderOpComponentSortText,
  MaintOrdOpCompRequiredQuantity,
  BaseUnit,
  _UnitOfMeasureText.UnitOfMeasureLongName : localized AS UnitOfMeasureLongNamelocalized,
  ProductTypeCode,
  _CompRcvdQuantity.ReceivedQuantity AS ReceivedQuantity,
  _CompRcvdQuantity.NetAmount AS NetAmount,
  _CompRcvdQuantity.ConfirmedQuantity AS ConfirmedQuantity,
  virtual ResvnItmIsNotService : abap_boolean AS virtualResvnItmIsNotServiceabap_boolean,
  virtual ResvnItmIsLeanService : abap_boolean AS virtualResvnItmIsLeanServiceabap_boolean,
  virtual MaintOrdCompAvailyCritltyDesc : abap.char(100) AS char100,
  MaintOrdCompLongTextLanguage,
  MaintOrdCompCommentLanguage,
  MaintOrdCompRemarkLanguage,
  MaintOrdComponentNoteLanguage,
  _MaterialText.MaterialName : localized AS MaterialNamelocalized,
  _Supplier.BusinessPartnerName1 AS BusinessPartnerName1,
  _Supplier.BusinessPartnerName2 AS BusinessPartnerName2,
  MaintenanceOrderType,
  ComponentDescription
FROM R_MaintOrderOpComponentTP_2
LEFT OUTER JOIN C_MaintOrdRsceAvailyStatus AS _MaintOrdAvailabilityStatus ON _MaintOrdAvailabilityStatus.MaintenanceOrder = R_MaintOrderOpComponentTP_2.MaintenanceOrder AND _MaintOrdAvailabilityStatus.MaintOrdProcurementDocument = R_MaintOrderOpComponentTP_2.MaintOrderComponentInternalID  -- association [0..*]
LEFT OUTER JOIN C_MaintOrdPurOrderItem AS _PurchaseOrder ON PurchaseRequisition = _PurchaseOrder.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseOrder.PurchaseRequisitionItem AND _PurchaseOrder.PurchaseRequisition is not initial  -- association [0..*]
;

Learn More