P_SCHEDPRODNPLNDORDRELN

CDS View

P_SCHEDPRODNPLNDORDRELN is a CDS View in S/4HANA. It contains 2 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SchedProdnOperReln view inner BASIC

Fields (2)

KeyField CDS FieldsUsed in Views
PredActID PredActID 1
PredGroupCounter PredGroupCounter 1 
@AbapCatalog.sqlViewName: 'PSCHPLORDRELN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel: {
    usageType: {serviceQuality: #A, sizeCategory: #XL, dataClass: #TRANSACTIONAL }
}
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Relations between ops in Planned Order'

define view P_SchedProdnPlndOrdReln 
as select from plab
left outer join I_CapacityRequirementItemCap as PredCapReq on PredCapReq.BillOfOperationsGroup = plab.plnnr and PredCapReq.BillOfOperations = plab.plnal and PredCapReq.BillOfOperationsType = plab.plnty
 and PredCapReq.BOOOperationInternalID = plab.plnkn
  {
      plnnr,
      plnal,
      plnkn,
      plnrn,
      alnrn,
      knnrn,
      PredCapReq.PlannedOrder,
      PredCapReq.CapacityRequirementItem,
      cast(concat(PredCapReq.CapacityRequirementItem, concat(PredCapReq.PlannedOrder, '1')) as /sapapo/om_orderuid ) as PredActID,
      PredCapReq.SuperiorOperationInternalID as PredGroupCounter,
      max(datuv) as MaxChangeNumberDate   
}
where loekz = ' '
and plnnr = plnrn
and plnal = alnrn
and plnty = '2'
and PredCapReq.PlannedOrder is not null
and datuv <= PredCapReq._CapacityRequirement.BOOExplosionDate
group by
plnnr, plnal, plnkn, plnrn, alnrn, knnrn, PredCapReq.PlannedOrder, PredCapReq.SuperiorOperationInternalID, PredCapReq.CapacityRequirementItem
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CAPACITYREQUIREMENT",
"I_CAPACITYREQUIREMENTITEMCAP",
"PLAB"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More