P_MFGORDERCOMPASSEMBLYAGGRGN3
Assembly Qty at SFI@OA per RESB, Matl, SerialNr and Batch
P_MFGORDERCOMPASSEMBLYAGGRGN3 is a CDS View in S/4HANA. Assembly Qty at SFI@OA per RESB, Matl, SerialNr and Batch. It contains 43 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_MfgOrderCompAssemblyAggrgn | view | from | CONSUMPTION | Assembled Qts for OA |
Fields (43)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AssemblyShopFloorItem | AssemblyShopFloorItem | 1 |
| KEY | Batch | Batch | 1 |
| KEY | Material | Material | 1 |
| KEY | OpActyNtwkElement | OpActyNtwkElement | 1 |
| KEY | OpActyNtwkInstance | OpActyNtwkInstance | 1 |
| KEY | OriglDgtlMockUpCharcsUUID | OriglDgtlMockUpCharcsUUID | 1 |
| KEY | Plant | Plant | 1 |
| KEY | RecordType | RecordType | 1 |
| KEY | Reservation | Reservation | 1 |
| KEY | ReservationItem | ReservationItem | 1 |
| KEY | ShopFloorItem | ShopFloorItem | 1 |
| _Material | _Material | 1 | |
| _MaterialBaseUnit | _MaterialBaseUnit | 1 | |
| _OpActyNtwkInstance | _OpActyNtwkInstance | 1 | |
| _OperationActivityInstance | _OperationActivityInstance | 1 | |
| _ParentShopFloorItem | _ParentShopFloorItem | 1 | |
| _Plant | _Plant | 1 | |
| _Reservation | _Reservation | 1 | |
| _ShopFloorItem | _ShopFloorItem | 1 | |
| BatchBySupplier | BatchBySupplier | 1 | |
| DebitCreditCode | DebitCreditCode | 1 | |
| DgtlMockUpCharcsUUID | DgtlMockUpCharcsUUID | 1 | |
| EntryUnit | EntryUnit | 1 | |
| FormulaKey | FormulaKey | 1 | |
| ManufacturerSerialNumber | ManufacturerSerialNumber | 1 | |
| MaterialBaseUnit | MaterialBaseUnit | 1 | |
| MaterialComponentQuantity | MaterialComponentQuantity | 1 | |
| MfgRefStrucBOMLeafAssgmtUUID | MfgRefStrucBOMLeafAssgmtUUID | 1 | |
| MfgRefStrucItmDetIsContextual | MfgRefStrucItmDetIsContextual | 1 | |
| MfgRefStrucItmRefDesignator | MfgRefStrucItmRefDesignator | 1 | |
| MfgRefStrucItmRefDsgntrDesc | MfgRefStrucItmRefDsgntrDesc | 1 | |
| MfgRefStrucItmRefDsgntrName | MfgRefStrucItmRefDsgntrName | 1 | |
| MfgRefStructureItemDetailUUID | MfgRefStructureItemDetailUUID | 1 | |
| QuantityInEntryUnit | QuantityInEntryUnit | 1 | |
| ReferenceDesignatorName | ReferenceDesignatorName | 1 | |
| ReferenceDesignatorValue | ReferenceDesignatorValue | 1 | |
| RequiredQuantity | RequiredQuantity | 1 | |
| VariableSizeComponentQuantity | VariableSizeComponentQuantity | 1 | |
| VariableSizeComponentUnit | VariableSizeComponentUnit | 1 | |
| VariableSizeDimension1 | VariableSizeDimension1 | 1 | |
| VariableSizeDimension2 | VariableSizeDimension2 | 1 | |
| VariableSizeDimension3 | VariableSizeDimension3 | 1 | |
| VariableSizeDimensionUnit | VariableSizeDimensionUnit | 1 |
@AbapCatalog.sqlViewName: 'PMPECOMPASMAGG3'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view P_MfgOrderCompAssemblyAggrgn3
as select from P_MfgOrderCompAssemblyAggrgn2 as MfgOrderCompAssemblyAggrgn
{
key MfgOrderCompAssemblyAggrgn.Reservation,
key MfgOrderCompAssemblyAggrgn.ReservationItem,
key MfgOrderCompAssemblyAggrgn.RecordType,
key MfgOrderCompAssemblyAggrgn.OpActyNtwkInstance,
key MfgOrderCompAssemblyAggrgn.OpActyNtwkElement,
key MfgOrderCompAssemblyAggrgn.AssemblyShopFloorItem,
key MfgOrderCompAssemblyAggrgn.ShopFloorItem,
key MfgOrderCompAssemblyAggrgn.Batch,
key MfgOrderCompAssemblyAggrgn.Material,
key MfgOrderCompAssemblyAggrgn.Plant,
key MfgOrderCompAssemblyAggrgn.OriglDgtlMockUpCharcsUUID,
MfgOrderCompAssemblyAggrgn.MfgRefStrucBOMLeafAssgmtUUID,
MfgOrderCompAssemblyAggrgn.MfgRefStructureItemDetailUUID,
MfgOrderCompAssemblyAggrgn.MfgRefStrucItmDetIsContextual,
MfgOrderCompAssemblyAggrgn.DgtlMockUpCharcsUUID,
MfgOrderCompAssemblyAggrgn.ReferenceDesignatorValue,
cast(case
when ( MfgOrderCompAssemblyAggrgn.MfgRefStrucItmRefDsgntrName is null
or MfgOrderCompAssemblyAggrgn.MfgRefStrucItmRefDsgntrName = '' )
and ( MfgOrderCompAssemblyAggrgn.ReferenceDesignatorValue is null
or MfgOrderCompAssemblyAggrgn.ReferenceDesignatorValue = '' )
-- If no RefDes exists, use GUID as Fallback (instead of having empty RefDes)
then bintohex( MfgOrderCompAssemblyAggrgn.OriglDgtlMockUpCharcsUUID )
when MfgOrderCompAssemblyAggrgn.MfgRefStrucItmRefDsgntrName is null
or MfgOrderCompAssemblyAggrgn.MfgRefStrucItmRefDsgntrName = ''
then MfgOrderCompAssemblyAggrgn.ReferenceDesignatorValue
else MfgOrderCompAssemblyAggrgn.MfgRefStrucItmRefDsgntrName
end as vmp_ref_des preserving type) as ReferenceDesignatorName,
MfgOrderCompAssemblyAggrgn.MaterialComponentQuantity,
@Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
cast(
case MfgOrderCompAssemblyAggrgn.AssemblyShopFloorItem
-- Non-serialized: Quantity-based calculation of RequiredQuantity
when 0 then MfgOrderCompAssemblyAggrgn.ResvnItmRequiredQtyInBaseUnit *
round(fltp_to_dec( MfgOrderCompAssemblyAggrgn.RequiredQuantityFactor as abap.dec(13,4) ), 3)
-- Serialized: MfgOrderComponentUsageNetQty defines RequiredQuantity
else round(fltp_to_dec( MfgOrderCompAssemblyAggrgn.MfgOrderComponentUsageNetQty as abap.dec(13,4) ), 3)
end as bdmng) as RequiredQuantity,
MfgOrderCompAssemblyAggrgn.MaterialBaseUnit,
MfgOrderCompAssemblyAggrgn.QuantityInEntryUnit,
MfgOrderCompAssemblyAggrgn.EntryUnit,
MfgOrderCompAssemblyAggrgn.DebitCreditCode,
MfgOrderCompAssemblyAggrgn.AssembledSerialNumber,
MfgOrderCompAssemblyAggrgn.ManufacturerSerialNumber,
MfgOrderCompAssemblyAggrgn.BatchBySupplier,
MfgOrderCompAssemblyAggrgn.MfgRefStrucItmRefDesignator,
MfgOrderCompAssemblyAggrgn.MfgRefStrucItmRefDsgntrDesc,
MfgOrderCompAssemblyAggrgn.MfgRefStrucItmRefDsgntrName,
MfgOrderCompAssemblyAggrgn.MaterialCompIsVariableSized,
MfgOrderCompAssemblyAggrgn.FormulaKey,
MfgOrderCompAssemblyAggrgn.VariableSizeDimension1,
MfgOrderCompAssemblyAggrgn.VariableSizeDimension2,
MfgOrderCompAssemblyAggrgn.VariableSizeDimension3,
MfgOrderCompAssemblyAggrgn.VariableSizeDimensionUnit,
MfgOrderCompAssemblyAggrgn.VariableSizeComponentQuantity,
MfgOrderCompAssemblyAggrgn.VariableSizeComponentUnit,
/* Associations */
MfgOrderCompAssemblyAggrgn._Material,
MfgOrderCompAssemblyAggrgn._MaterialBaseUnit,
MfgOrderCompAssemblyAggrgn._OpActyNtwkInstance,
MfgOrderCompAssemblyAggrgn._OperationActivityInstance,
MfgOrderCompAssemblyAggrgn._ParentShopFloorItem,
MfgOrderCompAssemblyAggrgn._Plant,
MfgOrderCompAssemblyAggrgn._Reservation,
MfgOrderCompAssemblyAggrgn._ReservationItem,
MfgOrderCompAssemblyAggrgn._ShopFloorItem
}