I_SchedProdnGetLogsOrdEndDate

DDL: I_SCHEDPRODNGETLOGSORDENDDATE SQL: ISCHEDLOGSORD Type: view COMPOSITE

Logistics order End date

I_SchedProdnGetLogsOrdEndDate is a Composite CDS View that provides data about "Logistics order End date" in SAP S/4HANA. It reads from 2 data sources (I_LogisticsOrder, I_SchedCapacityRqmtItemCap) and exposes 2 fields.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_LogisticsOrder aufk from
I_SchedCapacityRqmtItemCap kbed inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISCHEDLOGSORD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Logistics order End date view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (2)

KeyFieldSource TableSource FieldDescription
PlannedEndDate I_LogisticsOrder PlannedEndDate
PlannedStartDate I_LogisticsOrder PlannedStartDate 
@AbapCatalog.sqlViewName: 'ISCHEDLOGSORD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Logistics order End date'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_SchedProdnGetLogsOrdEndDate as select from  I_LogisticsOrder as aufk
inner join I_SchedCapacityRqmtItemCap as kbed on kbed.CapacityRequirement = aufk.CapacityRequirement
left outer to one join I_WrkCtrUtilznPrsnlzn as _prsnlzn on _prsnlzn.UserName = $session.user
    
    left outer to one join I_CapPlngWrkCtrGrpRespyArea as _wrkgrpaor on _wrkgrpaor.WorkCenterInternalID = kbed.WorkCenterInternalID
                                                               and _wrkgrpaor.Plant = aufk.Plant
                                                               and _wrkgrpaor.UserID = $session.user
                                                               
    left outer to one join I_SDMAreaOfResponsibility as _sdmaor on _sdmaor.Plant = aufk.Plant
                                                         and _sdmaor.MRPController = aufk.MRPController
                                                         and _sdmaor.UserID = $session.user
                                             
{
aufk.PlannedEndDate as PlannedEndDate,
aufk.PlannedStartDate as PlannedStartDate
}          

where  (aufk.BillOfOperationsType = 'N' or aufk.BillOfOperationsType = '2')
and(
       aufk.OrderCategory                        =  '10'
//    and aufk.seqnr                       =  '0000'

    or aufk.OrderCategory                        =  '40'
//    and aufk.seqnr                       =  '0000'

//   or  aufk.autyp                       =  '30'

  )
  and ( ( aufk.MRPController = _sdmaor.MRPController and aufk.Plant = _sdmaor.Plant and (_prsnlzn.PlantMRPCtrlrRespyAreaIsRqd = 'X' or (_prsnlzn.PlantMRPCtrlrRespyAreaIsRqd = ' ' and _prsnlzn.WorkCenterGroupRespyAreaIsRqd = ' ')))
       or
        ( kbed.WorkCenterInternalID = _wrkgrpaor.WorkCenterInternalID and aufk.Plant = _wrkgrpaor.Plant and _prsnlzn.WorkCenterGroupRespyAreaIsRqd = 'X') 
      )
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CAPPLNGWRKCTRGRPRESPYAREA",
"I_LOGISTICSORDER",
"I_SCHEDCAPACITYRQMTITEMCAP",
"I_SDMAREAOFRESPONSIBILITY",
"I_WRKCTRUTILZNPRSNLZN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More