I_SUPDMNDPURORDERSCHEDLINE

CDS View

Basic View for PO Schedule Line

I_SUPDMNDPURORDERSCHEDLINE is a CDS View in S/4HANA. Basic View for PO Schedule Line. It contains 1 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 1 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SupDmndAllDocPOBsc view inner BASIC Basic View for Purchase Order
I_SupDmndOvwPO view inner BASIC Basic View for Purchase Orders

Fields (1)

KeyField CDS FieldsUsed in Views
ScheduleLineDeliveryDate ProductAvailabilityDate,RequestedDeliveryDate,ScheduleLineDeliveryDate,SupplyDeliveryDate 2 
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Basic View for PO Schedule Line'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'ISUPDMNDPOSL',
  compiler.compareFilter: true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #X,
     sizeCategory:   #XXL
   }
}
define view I_SupDmndPurOrderSchedLine
  as select from eket as sched
{

 key sched.ebeln                                                                                                             as  PurchasingDocument,
 key sched.ebelp                                                                                                             as  PurchasingDocumentItem,
 key sched.etenr                                                                                                             as  ScheduleLine,
  sched.menge                                                                                                             as  ScheduleLineOrderQuantity,
  sched.eindt                                                                                                             as  ScheduleLineDeliveryDate,
  sched.wemng                                                                                                             as  RoughGoodsReceiptQty,
  //  sched.dabmg                                                                                                             as  MRPReducedQuantity,

  case when  sched.wemng > sched.dabmg then
        ( sched.menge - sched.wemng )
  else  ( sched.menge - sched.dabmg )
  end                                                                                                                     as  OpenSupplyQuantity
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EKET"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More