P_SFOASSLDCOMPBYLDNGRESVNNOIN

CDS View

P_SFOASSLDCOMPBYLDNGRESVNNOIN is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SFOTraceableAssldComp view_entity inner CONSUMPTION 
@AbapCatalog.sqlViewName: 'PMPESFOMLDNNI'
@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_SFOAssldCompByLdngResvnNoIn
  as select from P_SFOAssldTrcblCompLdngResvn as SFOAssldTrcblCompLdngResvn
{
  key SFOAssldTrcblCompLdngResvn.Reservation,
  key SFOAssldTrcblCompLdngResvn.ReservationItem,
  key SFOAssldTrcblCompLdngResvn.RecordType,
  key SFOAssldTrcblCompLdngResvn.OpActyNtwkInstance,
  key SFOAssldTrcblCompLdngResvn.OpActyNtwkElement,
  key SFOAssldTrcblCompLdngResvn.Batch,
  key SFOAssldTrcblCompLdngResvn.Material,
      @ObjectModel.foreignKey.association: '_Plant'
  key SFOAssldTrcblCompLdngResvn.Plant,
      @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.OriginalManufacturingOrder,
  SFOAssldTrcblCompLdngResvn.OpActyNtwkInstance,
  SFOAssldTrcblCompLdngResvn.OpActyNtwkElement,
  SFOAssldTrcblCompLdngResvn.Batch,
  SFOAssldTrcblCompLdngResvn.Material,
  SFOAssldTrcblCompLdngResvn.Plant,
  SFOAssldTrcblCompLdngResvn.ManufacturingOrder

Learn More