I_SCHEDPRODNCAPACITYRQMT

CDS View

Scheduled Production Capacity Requirement

I_SCHEDPRODNCAPACITYRQMT is a CDS View in S/4HANA. Scheduled Production Capacity Requirement. It contains 5 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 5 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SchedProdnGetPlndOrdEndDate view inner COMPOSITE Planned order end date
P_SchedOperations_Version_2 view inner COMPOSITE

Fields (5)

KeyField CDS FieldsUsed in Views
KEY CapacityRequirement CapacityRequirement 1
ScheduledBasicEndDate ScheduledBasicEndDate 1
ScheduledBasicEndTime ScheduledBasicEndTime 1
ScheduledBasicStartDate ScheduledBasicStartDate 1
ScheduledBasicStartTime ScheduledBasicStartTime 1 
@AbapCatalog.sqlViewName: 'ISCHEDCAPRQMT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Scheduled Production Capacity Requirement' 
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_SchedProdnCapacityRqmt as select from           kbko as kbko
 // left outer to one join afko as afko on  kbko.aufpl = afko.aufpl

                                       // and kbko.aufpl > '0000000000'


  //association [1..1] to I_CapacityRequirementOrigin    as _CapacityRequirementOrigin    on  $projection.CapacityRequirementOrigin= _CapacityRequirementOrigin.CapacityRequirementOrigin

  //association [0..1] to I_PlannedOrder                 as _PlannedOrder                 on  $projection.PlannedOrder = _PlannedOrder.PlannedOrder

  //association [0..1] to I_LogisticsOrder               as _Order                        on  $projection.OrderID = _Order.OrderID

  //association [0..1] to I_SalesOperationsPlanningOrder as _SalesOperationsPlanningOrder on  $projection.SalesOperationsPlanningOrder= _SalesOperationsPlanningOrder.SalesOperationsPlanningOrder

  //association [0..1] to I_BillOfOperationsType         as _BillOfOperationsType         on  $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType

  //association [0..1] to I_BillOfOperationsGroup        as _BillOfOperationsGroup        on  $projection.BillOfOperationsType  = _BillOfOperationsGroup.BillOfOperationsType

                                                                                      //  and $projection.BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup

  //association [0..1] to I_BillOfOperations             as _BillOfOperations             on  $projection.BillOfOperationsType  = _BillOfOperations.BillOfOperationsType

                                                                                       // and $projection.BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup

                                                                                       // and $projection.BillOfOperations      = _BillOfOperations.BillOfOperationsVariant                                                                                        

//  association [0..1] to I_SchedulingType               as _SchedulingType               on  $projection.SchedulingType = _SchedulingType.SchedulingType


  {
    // Key

    key kbko.bedid as CapacityRequirement,

    // Assignments

  //  @ObjectModel.foreignKey.association: '_CapacityRequirementOrigin'

    cast(kbko.typkz as capacityrequirementorigin preserving type) as CapacityRequirementOrigin,
 //   @ObjectModel.foreignKey.association: '_PlannedOrder'

    kbko.plnum as PlannedOrder,
  //  @ObjectModel.foreignKey.association: '_Order'

   // afko.aufnr as OrderID,

  //  @ObjectModel.foreignKey.association: '_SalesOperationsPlanningOrder'

    kbko.safnr as SalesOperationsPlanningOrder,
   // @ObjectModel.foreignKey.association: '_BillOfOperationsType'

    kbko.plnty as BillOfOperationsType,
   // @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'

    kbko.plnnr as BillOfOperationsGroup,
  //  @ObjectModel.foreignKey.association: '_BillOfOperations'

  //  kbko.plnal as BillOfOperations,

  //  @ObjectModel.foreignKey.association: '_SchedulingType'

    cast(kbko.terkz as pph_termkz preserving type)                as SchedulingType,

    // Dates and Times

    kbko.gstrs as ScheduledBasicStartDate,
    kbko.gsuzs as ScheduledBasicStartTime,    
    kbko.gltrs as ScheduledBasicEndDate,
    kbko.gluzs as ScheduledBasicEndTime,
    kbko.trmdt as LastScheduledDate,
    kbko.plauf as BOOExplosionDate

    // Associations

   /* _CapacityRequirementOrigin,
    _BillOfOperationsType,
    _BillOfOperationsGroup,
    _BillOfOperations,
    _PlannedOrder,
    _SalesOperationsPlanningOrder,
    _Order,
    _SchedulingType */
  };

Learn More