I_WRKCTRCAPBYAREAOFRESPY
Work Center By Area Of Responsibility
I_WRKCTRCAPBYAREAOFRESPY is a CDS View in S/4HANA. Work Center By Area Of Responsibility. It contains 6 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_WorkCenterCapOverviewTP | view | from | TRANSACTIONAL | Work Center Capacity Overview |
Fields (6)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CapacityCategoryAllocation | CapacityCategoryAllocation | 1 |
| KEY | CapacityInternalID | CapacityInternalID | 1 |
| KEY | WorkCenterInternalID | WorkCenterInternalID | 1 |
| KEY | WorkCenterTypeCode | WorkCenterTypeCode | 1 |
| CapacityActiveVersion | CapacityActiveVersion | 1 | |
| WorkCenterResponsible | WorkCenterResponsible | 1 |
@AbapCatalog.sqlViewName: 'IWCCAPBYAOR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Work Center By Area Of Responsibility'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_WrkCtrCapByAreaOfRespy
as select distinct from I_WorkCenterCapacity as _WorkCenterCapacity
inner join I_WorkCenter as _WorkCenter on _WorkCenterCapacity.WorkCenterTypeCode = 'A'
and _WorkCenterCapacity.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID
inner join I_Capacity as _Capacity on _WorkCenterCapacity.CapacityInternalID = _Capacity.CapacityInternalID
and _Capacity.CapacityIsFinite = 'X'
and _WorkCenter.WorkCenterIsToBeDeleted = ''
and _WorkCenter.WorkCenterTypeCode = 'A'
and _WorkCenter.AdvancedPlanningIsSupported = ''
inner join I_OperationControlProfile as _OperationControlProfile on _OperationControlProfile.CapacityRequirementsAreDtmnd = 'X'
// inner join I_BillOfOperationsOpBasic as _OperationActTasks on _OperationActTasks.WorkCenterInternalID = _WorkCenterCapacity.WorkCenterInternalID
// and _OperationControlProfile.OperationControlProfile = _OperationActTasks.OperationControlProfile
// and _OperationActTasks.IsDeleted = ''
inner join I_BillOfOperationsOpBasic as _OperationActTasks on ( _OperationActTasks.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID
and _WorkCenter.OpControlProfileIsReferenced = 'X'
and _WorkCenter.OperationControlProfile = _OperationControlProfile.OperationControlProfile
and _OperationActTasks.IsDeleted = '' )
or
( _OperationActTasks.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID
and _OperationControlProfile.OperationControlProfile= _OperationActTasks.OperationControlProfile
and _OperationActTasks.IsDeleted= ''
)
inner join I_BOOSqncOperationAssgmtChgSt as _OperationActivities on _OperationActivities.IsDeleted = ''
and _OperationActivities.BillOfOperationsType = _OperationActTasks.BillOfOperationsType
and _OperationActivities.BillOfOperationsGroup = _OperationActTasks.BillOfOperationsGroup
and _OperationActivities.BOOOperationInternalID = _OperationActTasks.BOOOperationInternalID
// and _OperationActivities.BOOSqncOpAssgmtIntVersionCntr = _OperationActTasks.BOOOpInternalVersionCounter
inner join I_BOOMaterialAssgmtChangeState as _MaterialTaskList on _MaterialTaskList.BillOfOperationsGroup = _OperationActTasks.BillOfOperationsGroup
and _MaterialTaskList.BillOfOperationsGroup = _OperationActivities.BillOfOperationsGroup
and _MaterialTaskList.BillOfOperationsVariant = _OperationActivities.BillOfOperationsVariant
and _MaterialTaskList.IsDeleted = ''
inner join P_WrkCtrCapAreaOfRespyHrzn as _Horizon on(
_Horizon.HorizonStartDate <= $session.system_date
and _Horizon.HorizonEndDate >= $session.system_date
)
//_Horizon.HorizonStartDate = $session.system_date
inner join I_ProductionVersion as _ProductionVersions on _OperationActTasks.BillOfOperationsType = _ProductionVersions.BillOfOperationsType
and _OperationActivities.BillOfOperationsType = _ProductionVersions.BillOfOperationsType
and _ProductionVersions.BillOfOperationsGroup = _MaterialTaskList.BillOfOperationsGroup
and _MaterialTaskList.BillOfOperationsType = _ProductionVersions.BillOfOperationsType
and _ProductionVersions.BillOfOperationsVariant = _MaterialTaskList.BillOfOperationsVariant
and (
_ProductionVersions.ValidityStartDate <= $session.system_date
or _ProductionVersions.ValidityStartDate between $session.system_date and _Horizon.HorizonEndDate
)
and (
_ProductionVersions.ValidityEndDate >= $session.system_date
)
and _ProductionVersions.ProductionVersionIsLocked = ''
and (
_ProductionVersions.BillOfOperationsType = 'N'
or _ProductionVersions.BillOfOperationsType = 'R'
or _ProductionVersions.BillOfOperationsType = '2'
or _ProductionVersions.BillOfOperationsType = 'V' // Shop Floor Routing - Support in Private Cloud
or _ProductionVersions.BillOfOperationsType = 'P' // Planning Routing - Support in Private Cloud
)
// inner join I_ProductPlantMRPArea as _MaterialVH on _MaterialVH.Material = _ProductionVersions.Material
// and _MaterialVH.Plant = _ProductionVersions.Plant
inner join I_MaterialPlant as _MaterialVH on _MaterialVH.Material = _ProductionVersions.Material
and _MaterialVH.Plant = _ProductionVersions.Plant
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 = _WorkCenterCapacity.WorkCenterInternalID
and _wrkgrpaor.Plant = _MaterialVH.Plant
and _wrkgrpaor.UserID = $session.user
left outer to one join I_SDMAreaOfResponsibility as _SDMAreaOfResponsibility on _MaterialVH.MRPController = _SDMAreaOfResponsibility.MRPController
and _SDMAreaOfResponsibility.UserID = $session.user
and _SDMAreaOfResponsibility.Plant = _MaterialVH.Plant
{
key _WorkCenterCapacity.WorkCenterInternalID as WorkCenterInternalID,
key _WorkCenterCapacity.WorkCenterTypeCode as WorkCenterTypeCode,
key _WorkCenterCapacity.CapacityCategoryAllocation,
key _WorkCenterCapacity.CapacityInternalID as CapacityInternalID,
_WorkCenterCapacity.Plant as Plant,
_WorkCenterCapacity.WorkCenter as WorkCenter,
_WorkCenterCapacity.CapacityCategoryCode as CapacityCategoryCode,
_WorkCenterCapacity.Capacity as Capacity,
_Capacity.CapacityActiveVersion as CapacityActiveVersion,
_WorkCenter.WorkCenterResponsible as WorkCenterResponsible,
//'' as WorkCenterResponsible,
_Capacity.CapacityResponsiblePlanner as CapacityResponsiblePlanner,
_WorkCenter._Text[1:Language=$session.system_language].WorkCenterText as WorkCenterDesc,
//'' as WorkCenterDesc,
//tstmp_current_utctimestamp() as LastChangeDateTime
cast( _WorkCenterCapacity.CapacityInternalID as abap.dec(15,0) ) as LastChangeDateTime,
_Capacity.CapacityLastChangeDateTime as CapacityLastChangeDateTime,
_WorkCenterCapacity._Plant.PlantName as PlantName
}
where ( ( _MaterialVH.MRPController = _SDMAreaOfResponsibility.MRPController and _MaterialVH.Plant = _SDMAreaOfResponsibility.Plant and (_prsnlzn.PlantMRPCtrlrRespyAreaIsRqd = 'X' or (_prsnlzn.PlantMRPCtrlrRespyAreaIsRqd = ' ' and _prsnlzn.WorkCenterGroupRespyAreaIsRqd = ' ')))
or
( _WorkCenterCapacity.WorkCenterInternalID = _wrkgrpaor.WorkCenterInternalID and _MaterialVH.Plant = _wrkgrpaor.Plant and _prsnlzn.WorkCenterGroupRespyAreaIsRqd = 'X')
);
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFOPERATIONSOPBASIC",
"I_BOOMATERIALASSGMTCHANGESTATE",
"I_BOOSQNCOPERATIONASSGMTCHGST",
"I_CAPACITY",
"I_CAPPLNGWRKCTRGRPRESPYAREA",
"I_MATERIALPLANT",
"I_OPERATIONCONTROLPROFILE",
"I_PLANT",
"I_PRODUCTIONVERSION",
"I_SDMAREAOFRESPONSIBILITY",
"I_WORKCENTER",
"I_WORKCENTERCAPACITY",
"I_WORKCENTERTEXT",
"I_WRKCTRUTILZNPRSNLZN",
"P_WRKCTRCAPAREAOFRESPYHRZN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/