I_SupDmndInboundDelivBasic

DDL: I_SUPDMNDINBOUNDDELIVBASIC Type: view BASIC

Basic View for Confirmations

I_SupDmndInboundDelivBasic is a Basic CDS View that provides data about "Basic View for Confirmations" in SAP S/4HANA. It reads from 1 data source (ekes) and exposes 9 fields with key fields PurchasingDocument, PurchasingDocumentItem, SequentialNmbrOfSuplrConf.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
ekes sched from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Basic View for Confirmations view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISUPDMNDIBD view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument ekes ebeln
KEY PurchasingDocumentItem ekes ebelp
KEY SequentialNmbrOfSuplrConf ekes etens
ScheduleLineOrderQuantity ekes menge
ScheduleLineDeliveryDate ekes eindt
RoughGoodsReceiptQty ekes dabmg
OpenSupplyQuantity
DeliveryDocument vbeln
StockSegment sgt_scat 
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Basic View for Confirmations'
@VDM: {
  viewType: #BASIC
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'ISUPDMNDIBD',
  compiler.compareFilter: true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #X,
     sizeCategory:   #XXL
   }
}
define view I_SupDmndInboundDelivBasic
  as select from ekes as sched
{

 key sched.ebeln                                                                                                      as  PurchasingDocument,
 key sched.ebelp                                                                                                      as  PurchasingDocumentItem,
 key sched.etens                                                                                                      as  SequentialNmbrOfSuplrConf ,
  sched.menge                                                                                                      as  ScheduleLineOrderQuantity,
  sched.eindt                                                                                                      as  ScheduleLineDeliveryDate,
  sched.dabmg                                                                                                      as  RoughGoodsReceiptQty,
  sched.menge - sched.dabmg                                                                                        as  OpenSupplyQuantity,
  vbeln                                                                                                            as  DeliveryDocument,
  sgt_scat                                                                                                         as  StockSegment
}
where sched.kzdis = 'X'
  and sched.dabmg < sched.menge

Learn More