P_SFOASSLDTRCBLCOMPBYLDNGRESVN

CDS View

SFI Assembled Component By Leading Reservation

P_SFOASSLDTRCBLCOMPBYLDNGRESVN is a CDS View in S/4HANA. SFI Assembled Component By Leading Reservation. It contains 19 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 19 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SFOTraceableAssldComp view_entity from CONSUMPTION SFO Assembled Traceable Component

Fields (19)

KeyField CDS FieldsUsed in Views
KEY Batch Batch 1
KEY DgtlMockUpCharcsUUID DgtlMockUpCharcsUUID 1
KEY MfgRefStrucBOMLeafAssgmtUUID MfgRefStrucBOMLeafAssgmtUUID 1
KEY MfgRefStrucItmDetIsContextual MfgRefStrucItmDetIsContextual 1
KEY MfgRefStructureItemDetailUUID MfgRefStructureItemDetailUUID 1
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OpActyNtwkInstance OpActyNtwkInstance 1
KEY Plant Plant 1
KEY RecordType RecordType 1
KEY Reservation Reservation 1
KEY ReservationItem ReservationItem 1
KEY ShopFloorItem ShopFloorItem 1
_ManufacturingOrder _ManufacturingOrder 1
_Material _Material 1
_Plant _Plant 1
_ProductPlantBasic _ProductPlantBasic 1
EntryUnit EntryUnit 1
ManufacturingOrder ManufacturingOrder 1
MaterialBaseUnit MaterialBaseUnit 1 
@AbapCatalog.sqlViewName: 'PMPESFOASLTRCBLR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view P_SFOAssldTrcblCompByLdngResvn
  as select from P_SFOAssldTrcblCompLdngResvn as SFOAssldTrcblCompLdngResvn
{
  key SFOAssldTrcblCompLdngResvn.Reservation,
  key SFOAssldTrcblCompLdngResvn.ReservationItem,
  key SFOAssldTrcblCompLdngResvn.RecordType,
  key SFOAssldTrcblCompLdngResvn.OpActyNtwkInstance,
  key SFOAssldTrcblCompLdngResvn.OpActyNtwkElement,
  key SFOAssldTrcblCompLdngResvn.ShopFloorItem,
  key SFOAssldTrcblCompLdngResvn.Batch,
  key SFOAssldTrcblCompLdngResvn.Material,
      @ObjectModel.foreignKey.association: '_Plant'
  key SFOAssldTrcblCompLdngResvn.Plant,
  key SFOAssldTrcblCompLdngResvn.DgtlMockUpCharcsUUID,
  key SFOAssldTrcblCompLdngResvn.MfgRefStrucBOMLeafAssgmtUUID,
  key SFOAssldTrcblCompLdngResvn.MfgRefStructureItemDetailUUID,
      SFOAssldTrcblCompLdngResvn.MfgRefStrucItmDetIsContextual,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      cast(sum(SFOAssldTrcblCompLdngResvn.MaterialComponentQuantity) as mpe_consumed_qty_in_base_unit preserving type) as MaterialComponentQuantity,
      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      cast(sum(SFOAssldTrcblCompLdngResvn.QuantityInEntryUnit) as erfmgv preserving type)                              as QuantityInEntryUnit,
      @Semantics.unitOfMeasure: true
      cast(max(SFOAssldTrcblCompLdngResvn.EntryUnit) as erfme preserving type )                                        as EntryUnit,
      @Semantics.unitOfMeasure: true
      cast(max(SFOAssldTrcblCompLdngResvn.MaterialBaseUnit) as meins preserving type )                                 as MaterialBaseUnit,
      cast(max(SFOAssldTrcblCompLdngResvn.DebitCreditCode) as shkzg preserving type )                                  as DebitCreditCode,
      SFOAssldTrcblCompLdngResvn.ManufacturingOrder,

      SFOAssldTrcblCompLdngResvn._Material,
      SFOAssldTrcblCompLdngResvn._Plant,
      SFOAssldTrcblCompLdngResvn._ProductPlantBasic,
      SFOAssldTrcblCompLdngResvn._ManufacturingOrder
}
group by
  SFOAssldTrcblCompLdngResvn.Reservation,
  SFOAssldTrcblCompLdngResvn.ReservationItem,
  SFOAssldTrcblCompLdngResvn.RecordType,
  SFOAssldTrcblCompLdngResvn.OpActyNtwkInstance,
  SFOAssldTrcblCompLdngResvn.OpActyNtwkElement,
  SFOAssldTrcblCompLdngResvn.ShopFloorItem,
  SFOAssldTrcblCompLdngResvn.Batch,
  SFOAssldTrcblCompLdngResvn.Material,
  SFOAssldTrcblCompLdngResvn.Plant,
  SFOAssldTrcblCompLdngResvn.DgtlMockUpCharcsUUID,
  SFOAssldTrcblCompLdngResvn.MfgRefStrucBOMLeafAssgmtUUID,
  SFOAssldTrcblCompLdngResvn.MfgRefStructureItemDetailUUID,
  SFOAssldTrcblCompLdngResvn.MfgRefStrucItmDetIsContextual,
  SFOAssldTrcblCompLdngResvn.ManufacturingOrder

Learn More