I_AssldReltdSerialNumberBatch

DDL: I_ASSLDRELTDSERIALNUMBERBATCH SQL: IMPEASSRLTDSRNB Type: view COMPOSITE

Assembled Related Serial Number and/or Batch

I_AssldReltdSerialNumberBatch is a Composite CDS View that provides data about "Assembled Related Serial Number and/or Batch" in SAP S/4HANA. It reads from 1 data source (P_AssldReltdSerialNumberBatch) and exposes 23 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
P_AssldReltdSerialNumberBatch AssldReltdSerialNumberBatch from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMPEASSRLTDSRNB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
EndUserText.label Assembled Related Serial Number and/or Batch view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY Reservation P_AssldReltdSerialNumberBatch Reservation
KEY ReservationItem P_AssldReltdSerialNumberBatch ReservationItem
KEY RecordType P_AssldReltdSerialNumberBatch RecordType
KEY OpActyNtwkInstance P_AssldReltdSerialNumberBatch OpActyNtwkInstance
KEY OpActyNtwkElement P_AssldReltdSerialNumberBatch OpActyNtwkElement
KEY AssemblyShopFloorItem P_AssldReltdSerialNumberBatch AssemblyShopFloorItem
KEY ShopFloorItem P_AssldReltdSerialNumberBatch ShopFloorItem
KEY Batch P_AssldReltdSerialNumberBatch Batch
KEY Material P_AssldReltdSerialNumberBatch Material
KEY Plant P_AssldReltdSerialNumberBatch Plant
SerialNumber
ManufacturerSerialNumber
BatchBySupplier
MaterialName
MaterialComponentQuantity P_AssldReltdSerialNumberBatch MaterialComponentQuantity
MaterialBaseUnit P_AssldReltdSerialNumberBatch MaterialBaseUnit
_OpActyNtwkInstance P_AssldReltdSerialNumberBatch _OpActyNtwkInstance
_OperationActivityInstance P_AssldReltdSerialNumberBatch _OperationActivityInstance
_ReservationHeader P_AssldReltdSerialNumberBatch _ReservationHeader
_ShopFloorItem P_AssldReltdSerialNumberBatch _ShopFloorItem
_ParentShopFloorItem P_AssldReltdSerialNumberBatch _ParentShopFloorItem
_Material P_AssldReltdSerialNumberBatch _Material
_Plant P_AssldReltdSerialNumberBatch _Plant 
@AbapCatalog.sqlViewName: 'IMPEASSRLTDSRNB'
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #L, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Assembled Related Serial Number and/or Batch'
define view I_AssldReltdSerialNumberBatch
  as select from           P_AssldReltdSerialNumberBatch as AssldReltdSerialNumberBatch
    left outer to one join I_OrderComponent              as OrderComponent on  OrderComponent.Reservation     = AssldReltdSerialNumberBatch.Reservation
                                                                           and OrderComponent.ReservationItem = AssldReltdSerialNumberBatch.ReservationItem
                                                                           and OrderComponent.RecordType      = AssldReltdSerialNumberBatch.RecordType

{
  key AssldReltdSerialNumberBatch.Reservation,
  key AssldReltdSerialNumberBatch.ReservationItem,
  key AssldReltdSerialNumberBatch.RecordType,
  key AssldReltdSerialNumberBatch.OpActyNtwkInstance,
  key AssldReltdSerialNumberBatch.OpActyNtwkElement,
  key AssldReltdSerialNumberBatch.AssemblyShopFloorItem,
  key AssldReltdSerialNumberBatch.ShopFloorItem,
  key AssldReltdSerialNumberBatch.Batch,
      @ObjectModel.text.element: 'MaterialName'
  key AssldReltdSerialNumberBatch.Material,
  key AssldReltdSerialNumberBatch.Plant,
      AssldReltdSerialNumberBatch._ShopFloorItem.SerialNumber,
      AssldReltdSerialNumberBatch._ShopFloorItem._Equipment.ManufacturerSerialNumber,
      AssldReltdSerialNumberBatch._BatchDistinct.BatchBySupplier,
      @Semantics.text: true
      AssldReltdSerialNumberBatch._Material._Text[1: Language=$session.system_language].MaterialName,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      AssldReltdSerialNumberBatch.MaterialComponentQuantity,
      @Semantics.unitOfMeasure: true
      AssldReltdSerialNumberBatch.MaterialBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      cast(case OrderComponent.MaterialCompIsVariableSized
          when 'X' then AssldReltdSerialNumberBatch.QuantityInEntryUnit
          else AssldReltdSerialNumberBatch.MaterialComponentQuantity
      end as erfmgv preserving type) as QuantityInEntryUnit,
      @Semantics.unitOfMeasure: true
      cast(case OrderComponent.MaterialCompIsVariableSized
          when 'X' then AssldReltdSerialNumberBatch.EntryUnit
          else AssldReltdSerialNumberBatch.MaterialBaseUnit
      end as erfme preserving type)  as EntryUnit,

      AssldReltdSerialNumberBatch._OpActyNtwkInstance,
      AssldReltdSerialNumberBatch._OperationActivityInstance,
      AssldReltdSerialNumberBatch._ReservationHeader,
      AssldReltdSerialNumberBatch._ShopFloorItem,
      AssldReltdSerialNumberBatch._ParentShopFloorItem,
      AssldReltdSerialNumberBatch._Material,
      AssldReltdSerialNumberBatch._Plant
}
where
  AssldReltdSerialNumberBatch.MaterialComponentQuantity <> 0

Learn More