I_MaintOrderOpComponentTP_2

DDL: I_MAINTORDEROPCOMPONENTTP_2 Type: view_entity TRANSACTIONAL
96 Fields 1 Data Sources

Maint Order Component Projection - TP

I_MaintOrderOpComponentTP_2 is a Transactional CDS View that provides data about "Maint Order Component Projection - TP" in SAP S/4HANA. It reads from 1 data source (R_MaintOrderOpComponentTP_2) and exposes 96 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation, MaintOrderComponentInternalID.

Data Sources (1)

SourceAliasJoin Type
R_MaintOrderOpComponentTP_2 R_MaintOrderOpComponentTP_2 projection

Annotations (10)

NameValueLevelField
EndUserText.label Maint Order Component Projection - TP view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (96)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder Order
KEY MaintenanceOrderOperation MaintenanceOrderOperation Suboperation
KEY MaintenanceOrderSubOperation MaintenanceOrderSubOperation Suboperation
KEY MaintOrderComponentInternalID MaintOrderComponentInternalID Object number
MaintenanceOrderComponent MaintenanceOrderComponent BOM item
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
ReservationType ReservationType Record type
ReservationIsFinallyIssued ReservationIsFinallyIssued Res Final Issue
Product Product Product Sold
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
MaintComponentItemCategory MaintOrdOpCompItemCategory Item Category
MaintOrdOperationComponentText MaintOrdOperationComponentText Item Text
MaintOrdOpCompRequisitioner MaintOrdOpCompRequisitioner Requisitioner
MaterialGroup MaterialGroup Product Group
Supplier Supplier Supplier
MaintOrdOpCompRequiredQuantity MaintOrdOpCompRequiredQuantity Requirement qty
BaseUnit BaseUnit Unit of Measure
QuantityInUnitOfEntry QuantityInUnitOfEntry Quantity in UnE
UnitOfEntry UnitOfEntry Unit of Entry
MaintOrderCompDebitCreditCode MaintOrderCompDebitCreditCode Debit/Credit
PurReqnOrResvnGeneration PurReqnOrResvnGeneration Purchase Reqn. / Resvn. Generation
MaterialCompIsProcuredDirectly MaterialCompIsProcuredDirectly Checkbox
RequirementDate RequirementDate Requirement Date
RequirementTime RequirementTime Time qty req'd
RequirementDateTime RequirementDateTime Time Stamp
ProductTypeCode ProductTypeCode Product Type Group
ServicePerformer ServicePerformer Service Performer
PerformancePeriodStartDateTime PerformancePeriodStartDateTime Time Stamp
PerformancePeriodEndDateTime PerformancePeriodEndDateTime Time Stamp
PerformancePeriodStartDate PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate PerformancePeriodEndDate End of Performance Period
PerformancePeriodStartTime PerformancePeriodStartTime Start Time
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
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
MaintOrderRoutingNumber MaintOrderRoutingNumber Plan No.f.Oper.
MaintOrderOperationCounter MaintOrderOperationCounter Counter
GoodsMovementType GoodsMovementType Movement Type
GoodsMovementIsAllowed GoodsMovementIsAllowed Mvt Allowed
MaintenanceOrderComponentBatch MaintenanceOrderComponentBatch Batch
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
MaintOrderOpComponentPrice MaintOrderOpComponentPrice Price/currency
WBSElement WBSElement WBS Internal ID
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
ResponsiblePurchaseOrg ResponsiblePurchaseOrg Purchasing Org.
MaintOrdCompPurOutlineAgrmtItm MaintOrdCompPurOutlineAgrmtItm Item
IsDeleted IsDeleted TRUE
ControllingArea ControllingArea Controlling Area
OverallLimitAmount OverallLimitAmount Overall Limit
ExpectedOverallLimitAmount ExpectedOverallLimitAmount Expected Value
QuantityIsFixed QuantityIsFixed Qty. is fixed
MaintOrdOpComponentCurrency MaintOrdOpComponentCurrency Currency
MaintOrdOpCompProcmtTrckgNmbr MaintOrdOpCompProcmtTrckgNmbr Tracking Number
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.
MaintOrdOpCompProcmtCatalog MaintOrdOpCompProcmtCatalog Catalog ID
MaintOrdOpCompProcmtCatalogItm MaintOrdOpCompProcmtCatalogItm Product ID
QuantityWithdrawnInBaseUnit QuantityWithdrawnInBaseUnit Withdrawal Qty
ConfirmedAvailableQuantity ConfirmedAvailableQuantity Available Quantity
RecipientLocationCode RecipientLocationCode Recipient Loc.
_UnitOfMeasure _UnitOfMeasure
_UnitOfMeasureEntry _UnitOfMeasureEntry
_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 I_MaintOrderOpComponentTP_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 I_MaintOrderOpComponentTP_2 AS
SELECT
  MaintenanceOrder,
  MaintenanceOrderOperation,
  MaintenanceOrderSubOperation,
  MaintOrderComponentInternalID,
  MaintenanceOrderComponent,
  Reservation,
  ReservationItem,
  ReservationType,
  ReservationIsFinallyIssued,
  Product,
  Plant,
  StorageLocation,
  MaintOrdOpCompItemCategory AS MaintComponentItemCategory,
  MaintOrdOperationComponentText,
  MaintOrdOpCompRequisitioner,
  MaterialGroup,
  Supplier,
  MaintOrdOpCompRequiredQuantity,
  BaseUnit,
  QuantityInUnitOfEntry,
  UnitOfEntry,
  MaintOrderCompDebitCreditCode,
  PurReqnOrResvnGeneration,
  MaterialCompIsProcuredDirectly,
  RequirementDate,
  RequirementTime,
  RequirementDateTime,
  ProductTypeCode,
  ServicePerformer,
  PerformancePeriodStartDateTime,
  PerformancePeriodEndDateTime,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  PerformancePeriodStartTime,
  PerformancePeriodEndTime,
  LeanServiceDuration,
  LeanServiceDurationUnit,
  DistributionFunction,
  MaintOrdCompDeliveryDateAdjmt,
  SrvcSchedgIsAlignedWthOpWrkCtr,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  MaintOrderRoutingNumber,
  MaintOrderOperationCounter,
  GoodsMovementType,
  GoodsMovementIsAllowed,
  MaintenanceOrderComponentBatch,
  MaintOrdOpComponentGLAccount,
  MaintOrdOpCompCostingRelevancy,
  MaintCompAltvProdUsgeRateInPct,
  MaintOrderOpComponentSortText,
  MaintOrdOpCompIsBulkProduct,
  MaterialProvisionType,
  MaintOrdOpCompAssgdWBSElmntInt,
  MaintOrderOpComponentPrice,
  WBSElement,
  MaintOrdOpCompPriceUnitQty,
  MatlCompIsMarkedForBackflush,
  PurchasingGroup,
  DeliveryTimeInDays,
  MaintOrdOpCompGdsRecipientName,
  MaintOrdOpCompUnloadingPtTxt,
  GoodsReceiptDurationInWorkDays,
  PurchasingInfoRecord,
  OperationLeadTimeOffset,
  OpsLeadTimeOffsetUnit,
  ResponsiblePurchaseOrg,
  MaintOrdCompPurOutlineAgrmtItm,
  IsDeleted,
  ControllingArea,
  OverallLimitAmount,
  ExpectedOverallLimitAmount,
  QuantityIsFixed,
  MaintOrdOpComponentCurrency,
  MaintOrdOpCompProcmtTrckgNmbr,
  MaintOrdOpCompSpecialStockType,
  VariableSizeDimension1,
  VariableSizeDimensionUnit,
  VariableSizeCompFormulaKey,
  VariableSizeDimension2,
  NumberOfVariableSizeItem,
  VariableSizeDimension3,
  VariableSizeItemQuantity,
  VariableSizeComponentUnit,
  RqmtDateIsEnteredManually,
  SupplierProduct,
  MaintOrdCompCmtdQtyIsKept,
  MaintOrdOpCompPurOutlineAgrmt,
  MaintOrdOpCompProcmtCatalog,
  MaintOrdOpCompProcmtCatalogItm,
  QuantityWithdrawnInBaseUnit,
  ConfirmedAvailableQuantity,
  RecipientLocationCode
FROM R_MaintOrderOpComponentTP_2
;

Learn More