@AbapCatalog.sqlViewName: 'PMPEOAPLNDMATRET'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #CUSTOMIZING}
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view P_OperationActivityPlndMatlRet
as select from P_OperationActyPlndMatlRetQts as OperationActyPlndMatlRetQts
left outer to one join I_DstctReltdOpActyCompAssgmt as DstctReltdOpActyCompAssgmt on DstctReltdOpActyCompAssgmt.RelatedOpActyNtwkInstance = OperationActyPlndMatlRetQts.OpActyNtwkInstance
and DstctReltdOpActyCompAssgmt.RelatedOpActyNtwkElement = OperationActyPlndMatlRetQts.OpActyNtwkElement
and DstctReltdOpActyCompAssgmt.RelatedReservation = OperationActyPlndMatlRetQts.Reservation
and DstctReltdOpActyCompAssgmt.RelatedReservationItem = OperationActyPlndMatlRetQts.ReservationItem
and DstctReltdOpActyCompAssgmt.RelatedRecordType = OperationActyPlndMatlRetQts.RecordType
association [0..1] to I_StorageLocation as _StorageLocation on $projection.Plant = _StorageLocation.Plant
and $projection.StorageLocation = _StorageLocation.StorageLocation
association [1..1] to I_MatlCompAssembleControl as _MatlCompAssembleControl on $projection.MatlCompAssembleControl = _MatlCompAssembleControl.MatlCompAssembleControl
association [1..1] to I_CompDisassemblyPermanence as _CompDisassemblyPermanence on $projection.CompDisassemblyPermanence = _CompDisassemblyPermanence.CompDisassemblyPermanence
{
key OperationActyPlndMatlRetQts.OpActyNtwkInstance,
key OperationActyPlndMatlRetQts.OpActyNtwkElement,
key OperationActyPlndMatlRetQts.Reservation,
key OperationActyPlndMatlRetQts.ReservationItem,
key OperationActyPlndMatlRetQts.RecordType,
key cast(OperationActyPlndMatlRetQts.Material as mpe_component_matnr preserving type ) as Material,
key OperationActyPlndMatlRetQts.Plant,
OperationActyPlndMatlRetQts.StorageLocation,
OperationActyPlndMatlRetQts.ProductionPlant,
OperationActyPlndMatlRetQts.ManufacturingOrder,
OperationActyPlndMatlRetQts.MaterialIsCoProduct,
OperationActyPlndMatlRetQts.ManufacturingOrderItem,
OperationActyPlndMatlRetQts.AssemblySequenceNumber,
OperationActyPlndMatlRetQts.BaseUnit,
@Semantics.quantity.unitOfMeasure: 'EntryUnit'
cast(round(fltp_to_dec( OperationActyPlndMatlRetQts.MfgOrderComponentUsageQuantity as abap.dec(13,4) ), 3)
as mpe_usage_qty ) as MfgOrderComponentUsageQuantity,
@Semantics.quantity.unitOfMeasure: 'EntryUnit'
cast(round(fltp_to_dec( OperationActyPlndMatlRetQts.RequiredQuantity as abap.dec(13,4) ), 3)
as co_menge ) as RequiredQuantity,
@Semantics.quantity.unitOfMeasure: 'EntryUnit'
cast(OperationActyPlndMatlRetQts.MaterialComponentQuantity as returned_quantity preserving type ) as MaterialComponentQuantity, --Returned Quantity
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
cast(OperationActyPlndMatlRetQts.MaterialComponentQuantity as mpe_returned_qty_in_base_unit preserving type) as ResvnItmWithdrawnQtyInBaseUnit,
@Semantics.quantity.unitOfMeasure: 'EntryUnit'
OperationActyPlndMatlRetQts.QuantityInEntryUnit,
OperationActyPlndMatlRetQts.EntryUnit,
OperationActyPlndMatlRetQts.MatlCompIsMarkedForBackflush,
OperationActyPlndMatlRetQts.GoodsMovementIsAllowed,
OperationActyPlndMatlRetQts.MatlCompDiscontinuationType,
-- Variable-Size Item Fields
OperationActyPlndMatlRetQts.MaterialCompIsVariableSized,
OperationActyPlndMatlRetQts.VariableSizeItemUnit,
OperationActyPlndMatlRetQts.FormulaKey,
OperationActyPlndMatlRetQts.VariableSizeDimension1,
OperationActyPlndMatlRetQts.VariableSizeDimension2,
OperationActyPlndMatlRetQts.VariableSizeDimension3,
OperationActyPlndMatlRetQts.VariableSizeDimensionUnit,
OperationActyPlndMatlRetQts.VariableSizeComponentQuantity,
OperationActyPlndMatlRetQts.VariableSizeComponentUnit,
-- Related / Leading Reservations
OperationActyPlndMatlRetQts.RelatedReservation,
OperationActyPlndMatlRetQts.RelatedReservationItem,
OperationActyPlndMatlRetQts.RelatedRecordType,
OperationActyPlndMatlRetQts.RelatedOpActyNtwkInstance,
OperationActyPlndMatlRetQts.RelatedOpActyNtwkElement,
OperationActyPlndMatlRetQts.LeadingReservation,
OperationActyPlndMatlRetQts.LeadingReservationItem,
OperationActyPlndMatlRetQts.LeadingReservationRecordType,
OperationActyPlndMatlRetQts.LeadingOpActyNtwkInstance,
OperationActyPlndMatlRetQts.LeadingOpActyNtwkElement,
-- Additional data needed for corresponding association
OperationActyPlndMatlRetQts.BillOfMaterialCategory,
-- ReservationItem.stlnr2 as BillOfMaterial,
OperationActyPlndMatlRetQts.BillOfMaterial,
OperationActyPlndMatlRetQts.BOMItem,
OperationActyPlndMatlRetQts.BillOfMaterialVersion,
cast (OperationActyPlndMatlRetQts.BillOfMaterialInternalID as mpe_exec_stnum preserving type ) as BillOfMaterialInternalID,
OperationActyPlndMatlRetQts.BillOfMaterialVariant,
OperationActyPlndMatlRetQts.InheritedBOMItemNode,
OperationActyPlndMatlRetQts.BOMItemCategory,
OperationActyPlndMatlRetQts.BOMItemInternalChangeCount,
OperationActyPlndMatlRetQts.BOOOpBOMItemInternalID,
OperationActyPlndMatlRetQts.LogicalComponent,
OperationActyPlndMatlRetQts.MfgRefStrucBOMLeafAssgmtUUID,
OperationActyPlndMatlRetQts.MfgRefStructureItemDetailUUID,
OperationActyPlndMatlRetQts.MfgRefStrucItmDetIsContextual,
OperationActyPlndMatlRetQts.MatlCompInstceAssyIsRequired,
OperationActyPlndMatlRetQts.PlannedInventoryUsabilityCode,
OperationActyPlndMatlRetQts.SerialNumberProfile,
OperationActyPlndMatlRetQts.SerialNumberIsRqdForAssembly,
OperationActyPlndMatlRetQts.StockCheckMessageType,
OperationActyPlndMatlRetQts.IsBatchManagementRequired,
OperationActyPlndMatlRetQts.MatlCompAssembleControl,
OperationActyPlndMatlRetQts.IsBulkMaterialComponent,
OperationActyPlndMatlRetQts.EffectivityParameterVariant,
OperationActyPlndMatlRetQts.Assembly,
cast(case
when DstctReltdOpActyCompAssgmt.RelatedReservation is null then ''
else 'X'
end as mpe_disassembly_permanence preserving type ) as CompDisassemblyPermanence,
OperationActyPlndMatlRetQts._OpActyNtwkInstance,
OperationActyPlndMatlRetQts._OpActyNtwkInstanceBasic,
OperationActyPlndMatlRetQts._OperationActivityInstance,
OperationActyPlndMatlRetQts._ReservationHeader,
OperationActyPlndMatlRetQts._BOMItemCategory,
OperationActyPlndMatlRetQts._BOMItmMfgRefStrucItmAssgmt,
OperationActyPlndMatlRetQts._MfgRefStrucItemWithDetails,
OperationActyPlndMatlRetQts._MfgRefHierItemWithDetails,
OperationActyPlndMatlRetQts._MfgOrder,
_StorageLocation,
_MatlCompAssembleControl,
_CompDisassemblyPermanence
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DSTCTRELTDOPACTYCOMPASSGMT",
"P_OPERATIONACTYPLNDMATLRETQTS"
],
"ASSOCIATED":
[
"I_BILLOFMATERIALITEMCATEGORY",
"I_BOMITMMFGREFSTRUCITMASSGMT",
"I_COMPDISASSEMBLYPERMANENCE",
"I_MATLCOMPASSEMBLECONTROL",
"I_MFGORDER",
"I_MFGREFHIERITEMWITHDETAILS",
"I_MFGREFSTRUCITEMWITHDETAILS",
"I_OPACTYNTWKINSTANCE",
"I_OPACTYNTWKINSTANCEBASIC",
"I_OPERATIONACTIVITYINSTANCE",
"I_RESERVATIONDOCUMENTHEADER",
"I_STORAGELOCATION"
],
"BASE":
[
"P_OPERATIONACTYPLNDMATLRETQTS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/