I_EquipMatlLastSerialNumber

DDL: I_EQUIPMATLLASTSERIALNUMBER Type: view_entity BASIC

Last Serial Number for Material

I_EquipMatlLastSerialNumber is a Basic CDS View that provides data about "Last Serial Number for Material" in SAP S/4HANA. It reads from 1 data source (mase) and exposes 2 fields with key field Material.

Data Sources (1)

SourceAliasJoin Type
mase mase from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
EndUserText.label Last Serial Number for Material view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY Material matnr
EquipMaterialLastSerialNumber lsernr
@AccessControl: { authorizationCheck: #NOT_REQUIRED,
                  personalData.blocking: #NOT_REQUIRED }

@VDM.viewType: #BASIC

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
                usageType: {
                            serviceQuality: #A,
                            sizeCategory:   #L,
                            dataClass:      #TRANSACTIONAL
                           },
                 supportedCapabilities: [
                            #SQL_DATA_SOURCE,
                            #CDS_MODELING_DATA_SOURCE,
                            #CDS_MODELING_ASSOCIATION_TARGET
                                        ],
                 modelingPattern: #ANALYTICAL_DIMENSION                                  
              }

@EndUserText.label: 'Last Serial Number for Material'
define view entity I_EquipMatlLastSerialNumber
  as select from mase
{
  key matnr  as Material,
      lsernr as EquipMaterialLastSerialNumber
}