P_OPERATIONACTIVITYPLNDMATLRET
Operation Activity Planned Material Return
P_OPERATIONACTIVITYPLNDMATLRET is a CDS View in S/4HANA. Operation Activity Planned Material Return. It contains 48 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_OperationActivityPlndMatlRet | view | from | CONSUMPTION | Operation Activity Component |
Fields (48)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | OpActyNtwkInstance | OpActyNtwkInstance | 1 |
| _StorageLocation | _StorageLocation | 1 | |
| Assembly | Assembly | 1 | |
| AssemblySequenceNumber | AssemblySequenceNumber | 1 | |
| BaseUnit | BaseUnit | 1 | |
| BillOfMaterialInternalID | BillOfMaterialInternalID | 1 | |
| BillOfMaterialVariant | BillOfMaterialVariant | 1 | |
| BillOfMaterialVersion | BillOfMaterialVersion | 1 | |
| BOMItem | BOMItem | 1 | |
| BOMItemCategory | BOMItemCategory | 1 | |
| BOMItemInternalChangeCount | BOMItemInternalChangeCount | 1 | |
| BOOOpBOMItemInternalID | BOOOpBOMItemInternalID | 1 | |
| CompDisassemblyPermanence | CompDisassemblyPermanence | 1 | |
| EffectivityParameterVariant | EffectivityParameterVariant | 1 | |
| FormulaKey | FormulaKey | 1 | |
| GoodsMovementIsAllowed | GoodsMovementIsAllowed | 1 | |
| InheritedBOMItemNode | InheritedBOMItemNode | 1 | |
| IsBatchManagementRequired | IsBatchManagementRequired | 1 | |
| IsBulkMaterialComponent | IsBulkMaterialComponent | 1 | |
| LeadingOpActyNtwkElement | LeadingOpActyNtwkElement | 1 | |
| LeadingOpActyNtwkInstance | LeadingOpActyNtwkInstance | 1 | |
| LeadingReservation | LeadingReservation | 1 | |
| LeadingReservationItem | LeadingReservationItem | 1 | |
| LeadingReservationRecordType | LeadingReservationRecordType | 1 | |
| LogicalComponent | LogicalComponent | 1 | |
| MatlCompAssembleControl | MatlCompAssembleControl | 1 | |
| MatlCompDiscontinuationType | MatlCompDiscontinuationType | 1 | |
| MatlCompInstceAssyIsRequired | MatlCompInstceAssyIsRequired | 1 | |
| MfgOrderComponentUsageQuantity | MfgOrderComponentUsageQuantity | 1 | |
| MfgRefStrucBOMLeafAssgmtUUID | MfgRefStrucBOMLeafAssgmtUUID | 1 | |
| MfgRefStrucItmDetIsContextual | MfgRefStrucItmDetIsContextual | 1 | |
| MfgRefStructureItemDetailUUID | MfgRefStructureItemDetailUUID | 1 | |
| PlannedInventoryUsabilityCode | PlannedInventoryUsabilityCode | 1 | |
| ProductionPlant | ProductionPlant | 1 | |
| RelatedOpActyNtwkElement | RelatedOpActyNtwkElement | 1 | |
| RelatedOpActyNtwkInstance | RelatedOpActyNtwkInstance | 1 | |
| RelatedRecordType | RelatedRecordType | 1 | |
| RelatedReservationItem | RelatedReservationItem | 1 | |
| RequiredQuantity | RequiredQuantity | 1 | |
| SerialNumberProfile | SerialNumberProfile | 1 | |
| StockCheckMessageType | StockCheckMessageType | 1 | |
| StorageLocation | StorageLocation | 1 | |
| VariableSizeComponentQuantity | VariableSizeComponentQuantity | 1 | |
| VariableSizeComponentUnit | VariableSizeComponentUnit | 1 | |
| VariableSizeDimension1 | VariableSizeDimension1 | 1 | |
| VariableSizeDimension2 | VariableSizeDimension2 | 1 | |
| VariableSizeDimension3 | VariableSizeDimension3 | 1 | |
| VariableSizeDimensionUnit | VariableSizeDimensionUnit | 1 |
@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
}