I_SUPLRINVCSELDINBDELIVERYNOTE

CDS View

SI Entered Delivery Notes

I_SUPLRINVCSELDINBDELIVERYNOTE is a CDS View in S/4HANA. SI Entered Delivery Notes. It contains 3 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 3 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_SuplrInvcSeldInbDeliveryNote view from CONSUMPTION SI Entered Delivery Notes
I_SuplrInvcSeldDelivNoteAPI01 view from BASIC Delivery Note Ref for Supplier Invoice

Fields (3)

KeyField CDS FieldsUsed in Views
KEY FiscalYear FiscalYear 1
KEY InboundDeliveryNote InboundDeliveryNote 1
KEY SupplierInvoice SupplierInvoice 1 
@EndUserText.label: 'SI Entered Delivery Notes'
@VDM.viewType : #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API 
@AbapCatalog.sqlViewName: 'ISISELDELNOT'
@AccessControl.authorizationCheck: #MANDATORY
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.personalData.blocking:#REQUIRED 
@AbapCatalog.preserveKey:true 
@AbapCatalog.compiler.compareFilter:true

define view I_SuplrInvcSeldInbDeliveryNote
  as select from rbsellifs

  //Inner join against header not required as references can only exist for real invoices (i.e. not for

  //account maintenance documents)


  association [1..1] to I_SupplierInvoice as _SupplierInvoice on  $projection.SupplierInvoice = _SupplierInvoice.SupplierInvoice
                                                              and $projection.FiscalYear      = _SupplierInvoice.FiscalYear
{
  key belnr                           as SupplierInvoice,
  key gjahr                           as FiscalYear,
  key lfsnr                           as InboundDeliveryNote,
      /* Associations */
      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
      _SupplierInvoice
}

Learn More