A_SerialNmbrDelivery

DDL: A_SERIALNMBRDELIVERY SQL: ASERNODLV Type: view BASIC

CDS view for API exposure

A_SerialNmbrDelivery is a Basic CDS View that provides data about "CDS view for API exposure" 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_OutbDeliveryItem _DeliveryDocumentItem $projection.DeliveryDocument = _DeliveryDocumentItem.DeliveryDocument and $projection.DeliveryDocumentItem = _DeliveryDocumentItem.DeliveryDocumentItem
[1..*] A_MaintenanceItemObj _MaintenanceItemObject _MaintenanceItemObject.MaintenanceItemObjectList = $projection.MaintenanceItemObjectList
[1..1] A_OutbDeliveryHeader _DeliveryDocumentHeader $projection.DeliveryDocument = _DeliveryDocumentHeader.DeliveryDocument

Annotations (12)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ASERNODLV view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label CDS view for API exposure view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC 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: 'ASERNODLV'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API

@EndUserText.label: 'CDS view for API exposure'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
  usageType.dataClass: #TRANSACTIONAL,
  usageType.serviceQuality: #A,
  usageType.sizeCategory: #L
}
@VDM.viewType: #BASIC
define view A_SerialNmbrDelivery
  as select from I_SerialNmbrDelivery
  
  association [1..1] to A_OutbDeliveryItem as _DeliveryDocumentItem on      $projection.DeliveryDocument        = _DeliveryDocumentItem.DeliveryDocument
                                                                        and $projection.DeliveryDocumentItem    = _DeliveryDocumentItem.DeliveryDocumentItem
  association [1..*] to A_MaintenanceItemObj  as _MaintenanceItemObject on _MaintenanceItemObject.MaintenanceItemObjectList = $projection.MaintenanceItemObjectList
  association [1..1] to A_OutbDeliveryHeader 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_MAINTENANCEITEMOBJ",
"A_OUTBDELIVERYHEADER",
"A_OUTBDELIVERYITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More