R_WORKCENTERPOOLEDCAPALLOCTP

CDS View

Work Center Pooled Capacity Allocation

R_WORKCENTERPOOLEDCAPALLOCTP is a CDS View in S/4HANA. Work Center Pooled Capacity Allocation. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_WorkCenterPooledCapAlloc view_entity projection CONSUMPTION Work Center Pooled Capacity Allocation
I_WorkCenterPooledCapAllocTP view_entity projection TRANSACTIONAL Interface for the BO WrkCtr PooledCapacity Allocation - TP 
//@AbapCatalog.sqlViewName: 'RCAPALLOCTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
//@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #MASTER }
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
@EndUserText.label: 'Work Center Pooled Capacity Allocation'
define view entity R_WorkCenterPooledCapAllocTP
  as select from I_WorkCenterCapacity_2
  association to parent R_WorkCenterTP as _Header on  $projection.WorkCenterInternalID = _Header.WorkCenterInternalID
                                                  and $projection.WorkCenterTypeCode   = _Header.WorkCenterTypeCode
{
  key WorkCenterInternalID,
  key WorkCenterTypeCode,
  key CapacityCategoryAllocation,
  key CapacityInternalID,
      LastChangeDate,
      LastChangedByUser,
      Plant,
      WorkCenter,
      WorkCenterCategoryCode,
      CapacityCategoryCode,
      Capacity,
      SetupCapRequirementFormula,
      ProcgCapRequirementFormula,
      TeardownCapRequirementFormula,
      OtherCapRequirementFormula,
      ValidityStartDate,
      ValidityEndDate,
      WorkCenterLastChangeDateTime,
      /*Association*/
      _Header
}
where
      WorkCenterTypeCode = 'A'
  and CapacityIsPooled   is not initial

Learn More