I_SERIALNMBRDELIVERY

CDS View

Serial number delivery

I_SERIALNMBRDELIVERY is a CDS View in S/4HANA. Serial number delivery. It contains 3 fields. 10 CDS views read from this table.

Used by 10 CDS view(s) 3 fields

CDS Views using this table (10)

ViewTypeJoinVDMDescription
A_InbDeliverySerialNmbr view from BASIC CDS View for Serial Numbers
A_InbDeliverySerialNmbr_1 view from BASIC CDS View for Serial Numbers
A_ReturnsDeliverySrlNmbr view from BASIC Returns Delivery Serial Number
A_ReturnsDeliverySrlNmbr_1 view from BASIC Returns Delivery Serial Number
A_SerialNmbrDelivery view from BASIC CDS view for API exposure
A_SerialNmbrDelivery_1 view from BASIC CDS view for API exposure
C_CustRetRefDocSrlNmbr view_entity inner CONSUMPTION Returns Order Reference Document Serial Number
C_PT_SAFTBillingItemSerialNmbr view inner CONSUMPTION SAF-T PT Item Serial Numbers
C_SerialNmbrEquipNmbrDelivery view from CONSUMPTION Serial and Equipment Numbers
P_SerialNmbrDelivery view from CONSUMPTION Serial number delivery consumption view

Fields (3)

KeyField CDS FieldsUsed in Views
KEY DeliveryDocument DeliveryDocument 7
KEY DeliveryDocumentItem DeliveryDocumentItem 1
KEY MaintenanceItemObjectList MaintenanceItemObjectList 1 
@AbapCatalog.sqlViewName: 'ISERNODLV'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY // never expose this view directly, only via associations

@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Serial number delivery'
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L

@VDM.viewType: #BASIC
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'I_MaintItmObjListDeliveryDoc'

define view I_SerialNmbrDelivery
  as select from ser01

  association [1..1] to I_DeliveryDocument     as _DeliveryDocument     on  $projection.DeliveryDocument = _DeliveryDocument.DeliveryDocument
  association [1..1] to I_DeliveryDocumentItem as _DeliveryDocumentItem on  $projection.DeliveryDocument     = _DeliveryDocumentItem.DeliveryDocument
                                                                        and $projection.DeliveryDocumentItem = _DeliveryDocumentItem.DeliveryDocumentItem
{
  key obknr   as MaintenanceItemObjectList,

      lief_nr as DeliveryDocument,
      posnr   as DeliveryDocumentItem,
      vbtyp   as SDDocumentCategory,
      datum   as DeliveryDate,

      _DeliveryDocument,
      _DeliveryDocumentItem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SER01"
],
"ASSOCIATED":
[
"I_DELIVERYDOCUMENT",
"I_DELIVERYDOCUMENTITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More