A_WorkCenterCapDayOp

DDL: A_WORKCENTERCAPDAYOP SQL: AWCCAPDAYOP Type: view COMPOSITE Package: ODATA_PP_WORKCENTER_API

Daily Operations Capacity

A_WorkCenterCapDayOp is a Composite CDS View that provides data about "Daily Operations Capacity" in SAP S/4HANA. It reads from 1 data source (A_WorkCenterCapPplineOp) and exposes 37 fields with key fields Plant, MRPController, WorkCenter, CapacityInternalID, CapacityRequirement. Part of development package ODATA_PP_WORKCENTER_API.

1 data source(s) 37 fields

Data Sources (1)

SourceAliasJoin Type
A_WorkCenterCapPplineOp WrkCtrCapPplineOp from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName AWCCAPDAYOP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D 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 Daily Operations Capacity view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY Plant A_WorkCenterCapPplineOp Plant
KEY MRPController A_WorkCenterCapPplineOp MRPController
KEY WorkCenter A_WorkCenterCapPplineOp WorkCenter
KEY CapacityInternalID A_WorkCenterCapPplineOp CapacityInternalID
KEY CapacityRequirement A_WorkCenterCapPplineOp CapacityRequirement
KEY Material A_WorkCenterCapPplineOp Material
KEY OrderID A_WorkCenterCapPplineOp OrderID
KEY Operation A_WorkCenterCapPplineOp Operation
WorkCenterDesc A_WorkCenterCapPplineOp WorkCenterDesc
WorkCenterResponsible A_WorkCenterCapPplineOp WorkCenterResponsible
WorkCenterCategoryCode A_WorkCenterCapPplineOp WorkCenterCategoryCode
WorkCenterInternalID A_WorkCenterCapPplineOp WorkCenterInternalID
CapacityRequirementOrigin A_WorkCenterCapPplineOp CapacityRequirementOrigin
CapacityRequirementUnit A_WorkCenterCapPplineOp CapacityRequirementUnit
OrderType A_WorkCenterCapPplineOp OrderType
OrderTypeName A_WorkCenterCapPplineOp OrderTypeName
OrderPlannedTotalQty A_WorkCenterCapPplineOp OrderPlannedTotalQty
BaseUnit A_WorkCenterCapPplineOp BaseUnit
ProductionVersion A_WorkCenterCapPplineOp ProductionVersion
OperationPlanningStatusText A_WorkCenterCapPplineOp OperationPlanningStatusText
OperationPlanningStatusCode A_WorkCenterCapPplineOp OperationPlanningStatusCode
OperationLatestStartDate A_WorkCenterCapPplineOp OperationLatestStartDate
OperationLatestStartTime A_WorkCenterCapPplineOp OperationLatestStartTime
OperationLatestEndDate A_WorkCenterCapPplineOp OperationLatestEndDate
OperationLatestEndTime A_WorkCenterCapPplineOp OperationLatestEndTime
OrderStatusText A_WorkCenterCapPplineOp OrderStatusText
OrderStatusCode A_WorkCenterCapPplineOp OrderStatusCode
OrderFirmingStatusText A_WorkCenterCapPplineOp OrderFirmingStatusText
OpLtstSchedldProcgStrtDte A_WorkCenterCapPplineOp OpLtstSchedldProcgStrtDte
OpLtstSchedldProcgStrtTme A_WorkCenterCapPplineOp OpLtstSchedldProcgStrtTme
OpLtstSchedldTrdwnStrtDte A_WorkCenterCapPplineOp OpLtstSchedldTrdwnStrtDte
OpLtstSchedldTrdwnStrtTme A_WorkCenterCapPplineOp OpLtstSchedldTrdwnStrtTme
RemainingCapReqOpSegSetupDurn A_WorkCenterCapPplineOp RemainingCapReqOpSegSetupDurn
RemainingCapReqOpSegProcgDurn A_WorkCenterCapPplineOp RemainingCapReqOpSegProcgDurn
RemainingCapReqOpSegTrdwnDurn A_WorkCenterCapPplineOp RemainingCapReqOpSegTrdwnDurn
CapacityRequirementsAreDtmnd A_WorkCenterCapPplineOp CapacityRequirementsAreDtmnd
OrderInternalID A_WorkCenterCapPplineOp OrderInternalID 
@AbapCatalog.sqlViewName: 'AWCCAPDAYOP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Daily Operations Capacity'
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
define view A_WorkCenterCapDayOp as
            select from A_WorkCenterCapPplineOp as WrkCtrCapPplineOp
{
    key WrkCtrCapPplineOp.Plant,
    key WrkCtrCapPplineOp.MRPController,
    key WrkCtrCapPplineOp.WorkCenter,
    key WrkCtrCapPplineOp.CapacityInternalID,
    key WrkCtrCapPplineOp.CapacityRequirement,
    key WrkCtrCapPplineOp.Material,
    key WrkCtrCapPplineOp.OrderID,
    key WrkCtrCapPplineOp.Operation,
    
        WrkCtrCapPplineOp.WorkCenterDesc,
        WrkCtrCapPplineOp.WorkCenterResponsible,
        WrkCtrCapPplineOp.WorkCenterCategoryCode,
        WrkCtrCapPplineOp.WorkCenterInternalID,
        WrkCtrCapPplineOp.CapacityRequirementOrigin,
        WrkCtrCapPplineOp.CapacityRequirementUnit,
        WrkCtrCapPplineOp.OrderType,
        WrkCtrCapPplineOp.OrderTypeName,
        @Semantics.quantity.unitOfMeasure: 'BaseUnit'
        WrkCtrCapPplineOp.OrderPlannedTotalQty,
        @Semantics.unitOfMeasure: true
        WrkCtrCapPplineOp.BaseUnit,
        WrkCtrCapPplineOp.ProductionVersion,
        WrkCtrCapPplineOp.OperationPlanningStatusText,
        WrkCtrCapPplineOp.OperationPlanningStatusCode,
        WrkCtrCapPplineOp.OperationLatestStartDate,
        WrkCtrCapPplineOp.OperationLatestStartTime,
        WrkCtrCapPplineOp.OperationLatestEndDate,
        WrkCtrCapPplineOp.OperationLatestEndTime,
        WrkCtrCapPplineOp.OrderStatusText,
        WrkCtrCapPplineOp.OrderStatusCode,
        WrkCtrCapPplineOp.OrderFirmingStatusText,
        WrkCtrCapPplineOp.OpLtstSchedldProcgStrtDte,
        WrkCtrCapPplineOp.OpLtstSchedldProcgStrtTme,
        WrkCtrCapPplineOp.OpLtstSchedldTrdwnStrtDte,
        WrkCtrCapPplineOp.OpLtstSchedldTrdwnStrtTme,
        WrkCtrCapPplineOp.RemainingCapReqOpSegSetupDurn,
        WrkCtrCapPplineOp.RemainingCapReqOpSegProcgDurn,
        WrkCtrCapPplineOp.RemainingCapReqOpSegTrdwnDurn,
        WrkCtrCapPplineOp.CapacityRequirementsAreDtmnd,
        WrkCtrCapPplineOp.OrderInternalID
}
where OperationLatestStartDate <= $session.system_date
and OperationLatestEndDate >= $session.system_date

Learn More