C_MfgOrderAssembledSerialVH

DDL: C_MFGORDERASSEMBLEDSERIALVH SQL: CMFGORDASSMBLSN Type: view CONSUMPTION

Serial Number

C_MfgOrderAssembledSerialVH is a Consumption CDS View that provides data about "Serial Number" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderCompAssemblyAggrgn) and exposes 24 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement.

1 data source(s) 24 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderCompAssemblyAggrgn I_MfgOrderCompAssemblyAggrgn from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CMFGORDASSMBLSN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
EndUserText.label Serial Number view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY Reservation Reservation
KEY ReservationItem ReservationItem
KEY RecordType RecordType
KEY OpActyNtwkInstance OpActyNtwkInstance
KEY OpActyNtwkElement OpActyNtwkElement
KEY AssemblyShopFloorItem AssemblyShopFloorItem
KEY ShopFloorItem ShopFloorItem
KEY Batch Batch
KEY Material Material
KEY Plant Plant
KEY OriglDgtlMockUpCharcsUUID OriglDgtlMockUpCharcsUUID
StorageLocation StorageLocation
DgtlMockUpCharcsUUID DgtlMockUpCharcsUUID
AssembledSerialNumber AssembledSerialNumber
ManufacturerSerialNumber ManufacturerSerialNumber
_Material _Material
_OpActyNtwkInstance _OpActyNtwkInstance
_OperationActivityInstance _OperationActivityInstance
_ParentShopFloorItem _ParentShopFloorItem
_Plant _Plant
_Reservation _Reservation
_ReservationItem _ReservationItem
_ShopFloorItem _ShopFloorItem
_StorageLocation _StorageLocation 
@AbapCatalog.sqlViewName: 'CMFGORDASSMBLSN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.supportedCapabilities: [ #VALUE_HELP_PROVIDER ]
@ObjectModel.dataCategory: #VALUE_HELP

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED

@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@EndUserText.label: 'Serial Number'
define view C_MfgOrderAssembledSerialVH
  as select from I_MfgOrderCompAssemblyAggrgn
{
      @UI.hidden: true
  key Reservation,
      @UI.hidden: true
  key ReservationItem,
      @UI.hidden: true
  key RecordType,
      @UI.hidden: true
  key OpActyNtwkInstance,
      @UI.hidden: true
  key OpActyNtwkElement,
      @UI.hidden: true
  key AssemblyShopFloorItem,
      @UI.hidden: true
  key ShopFloorItem,
      @UI.hidden: true
  key Batch,
      @Consumption.filter.hidden:true
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.7
  key Material,
      @UI.hidden: true
  key Plant,
      @UI.hidden: true
  key OriglDgtlMockUpCharcsUUID,
      @Consumption.hidden: true
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.7
      StorageLocation,
      @UI.hidden: true
      DgtlMockUpCharcsUUID,
      //ReferenceDesignatorValue,

      //MaterialComponentQuantity,

      //RequiredQuantity,

      //MaterialBaseUnit,

      //DebitCreditCode,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.7
      AssembledSerialNumber,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.7
      ManufacturerSerialNumber,
      //BatchBySupplier,

      /* Associations */
      _Material,
      //_MaterialBaseUnit,

      _OpActyNtwkInstance,
      _OperationActivityInstance,
      _ParentShopFloorItem,
      _Plant,
      _Reservation,
      _ReservationItem,
      _ShopFloorItem,
      _StorageLocation

}
where
  MaterialComponentQuantity > 0
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDERCOMPASSEMBLYAGGRGN"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_OPACTYNTWKINSTANCE",
"I_OPERATIONACTIVITYINSTANCE",
"I_PLANT",
"I_RESERVATIONDOCUMENTHEADER",
"I_RESERVATIONITEM",
"I_SHOPFLOORITEM",
"I_STORAGELOCATION"
],
"BASE":
[
"I_MFGORDERCOMPASSEMBLYAGGRGN"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More