I_WorkCenterCapAlloc

DDL: I_WORKCENTERCAPALLOC SQL: IWRKCTRCAPALLOC Type: view COMPOSITE Package: PPH_VDM_CAP_EVAL

Work Center Capacity Allocation

I_WorkCenterCapAlloc is a Composite CDS View that provides data about "Work Center Capacity Allocation" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterCapacity) and exposes 12 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID. Part of development package PPH_VDM_CAP_EVAL.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterCapacity crca from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IWRKCTRCAPALLOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Work Center Capacity Allocation view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID I_WorkCenterCapacity WorkCenterInternalID
KEY WorkCenterTypeCode I_WorkCenterCapacity WorkCenterTypeCode
KEY CapacityCategoryAllocation I_WorkCenterCapacity CapacityCategoryAllocation
KEY CapacityInternalID I_WorkCenterCapacity CapacityInternalID
LastChangeDate I_WorkCenterCapacity LastChangeDate
LastChangedByUser I_WorkCenterCapacity LastChangedByUser
SetupCapRequirementFormula I_WorkCenterCapacity SetupCapRequirementFormula
ProcgCapRequirementFormula I_WorkCenterCapacity ProcgCapRequirementFormula
TeardownCapRequirementFormula I_WorkCenterCapacity TeardownCapRequirementFormula
OtherCapRequirementFormula I_WorkCenterCapacity OtherCapRequirementFormula
ValidityStartDate I_WorkCenterCapacity ValidityStartDate
ValidityEndDate I_WorkCenterCapacity ValidityEndDate 
@AbapCatalog.sqlViewName: 'IWRKCTRCAPALLOC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Work Center Capacity Allocation'
define view I_WorkCenterCapAlloc 
//       as select from P_CRCA as crca

         as select from I_WorkCenterCapacity as crca
{
    key crca.WorkCenterInternalID,
    key crca.WorkCenterTypeCode,
    key crca.CapacityCategoryAllocation,
    key crca.CapacityInternalID ,
        crca.LastChangeDate,
        crca.LastChangedByUser,
        crca.SetupCapRequirementFormula,
        crca.ProcgCapRequirementFormula,
        crca.TeardownCapRequirementFormula,
        crca.OtherCapRequirementFormula,
        crca.ValidityStartDate,
        crca.ValidityEndDate        
}

Learn More