A_InbDeliverySerialNmbr

DDL: A_INBDELIVERYSERIALNMBR SQL: AINBDLVSERNO Type: view BASIC

CDS View for Serial Numbers

A_InbDeliverySerialNmbr is a Basic CDS View that provides data about "CDS View for Serial Numbers" in SAP S/4HANA. It reads from 1 data source (I_SerialNmbrDelivery) and exposes 8 fields with key field MaintenanceItemObjectList. It has 3 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_SerialNmbrDelivery I_SerialNmbrDelivery from

Associations (3)

CardinalityTargetAliasCondition
[1..1] A_InbDeliveryItem _DeliveryDocumentItem $projection.DeliveryDocument = _DeliveryDocumentItem.DeliveryDocument and $projection.DeliveryDocumentItem = _DeliveryDocumentItem.DeliveryDocumentItem
[1..*] A_MaintenanceItemObjList _MaintenanceItemObject _MaintenanceItemObject.MaintenanceItemObjectList = $projection.MaintenanceItemObjectList
[1..1] A_InbDeliveryHeader _DeliveryDocumentHeader $projection.DeliveryDocument = _DeliveryDocumentHeader.DeliveryDocument

Annotations (11)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName AINBDLVSERNO view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label CDS View for Serial Numbers view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceItemObjectList
DeliveryDate DeliveryDate
DeliveryDocument DeliveryDocument
DeliveryDocumentItem DeliveryDocumentItem
SDDocumentCategory SDDocumentCategory
_DeliveryDocumentItem _DeliveryDocumentItem
_MaintenanceItemObject _MaintenanceItemObject
_DeliveryDocumentHeader _DeliveryDocumentHeader 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'AINBDLVSERNO'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'CDS View for Serial Numbers'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
  usageType.dataClass: #MASTER,
  usageType.serviceQuality: #A,
  usageType.sizeCategory: #L
}
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

define view A_InbDeliverySerialNmbr
  as select from I_SerialNmbrDelivery 
  
  association [1..1] to A_InbDeliveryItem as _DeliveryDocumentItem on      $projection.DeliveryDocument        = _DeliveryDocumentItem.DeliveryDocument
                                                                        and $projection.DeliveryDocumentItem    = _DeliveryDocumentItem.DeliveryDocumentItem
  association [1..*] to A_MaintenanceItemObjList  as _MaintenanceItemObject on _MaintenanceItemObject.MaintenanceItemObjectList = $projection.MaintenanceItemObjectList
  association [1..1] to A_InbDeliveryHeader as _DeliveryDocumentHeader on $projection.DeliveryDocument = _DeliveryDocumentHeader.DeliveryDocument           
{
      key cast ( MaintenanceItemObjectList as abap.int4 ) as MaintenanceItemObjectList,
      DeliveryDate,
      DeliveryDocument,
      DeliveryDocumentItem,
      SDDocumentCategory,
      
      @ObjectModel.association.type:  [#TO_COMPOSITION_PARENT]
      _DeliveryDocumentItem,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _MaintenanceItemObject,
      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _DeliveryDocumentHeader
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERIALNMBRDELIVERY"
],
"ASSOCIATED":
[
"A_INBDELIVERYHEADER",
"A_INBDELIVERYITEM",
"A_MAINTENANCEITEMOBJLIST"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More