P_MFGORDERCOMPASSEMBLYAGGRGN3

CDS View

P_MFGORDERCOMPASSEMBLYAGGRGN3 is a CDS View in S/4HANA. It contains 43 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 43 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_MfgOrderCompAssemblyAggrgn view from CONSUMPTION

Fields (43)

KeyField CDS FieldsUsed 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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_MFGORDERCOMPASSEMBLYAGGRGN2"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_OPACTYNTWKINSTANCE",
"I_OPERATIONACTIVITYINSTANCE",
"I_PLANT",
"I_RESERVATIONDOCUMENTHEADER",
"I_RESERVATIONITEM",
"I_SHOPFLOORITEM",
"I_UNITOFMEASURE"
],
"BASE":
[
"P_MFGORDERCOMPASSEMBLYAGGRGN2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More