C_InspRsltRecgWorkCenter

DDL: C_INSPRSLTRECGWORKCENTER Type: view_entity CONSUMPTION

Work Center Details

C_InspRsltRecgWorkCenter is a Consumption CDS View that provides data about "Work Center Details" in SAP S/4HANA. It reads from 1 data source (I_WorkCenter) and exposes 134 fields with key fields WorkCenterInternalID, WorkCenterTypeCode.

1 data source(s) 134 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkCenter I_WorkCenter from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Work Center Details view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view

Fields (134)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID
KEY WorkCenterTypeCode WorkCenterTypeCode
WorkCenter WorkCenter
WorkCenterIsToBeDeleted WorkCenterIsToBeDeleted
WorkCenterIsLocked WorkCenterIsLocked
WorkCenterIsMntndForCosting WorkCenterIsMntndForCosting
WorkCenterIsMntndForScheduling WorkCenterIsMntndForScheduling
NumberOfConfirmationSlips NumberOfConfirmationSlips
AdvancedPlanningIsSupported AdvancedPlanningIsSupported
ShiftNoteType ShiftNoteType
ShiftReportType ShiftReportType
WorkCenterLastChangedBy WorkCenterLastChangedBy
WorkCenterLastChangeDateTime WorkCenterLastChangeDateTime
WorkCenterCategoryCode WorkCenterCategoryCode
WorkCenterLocation WorkCenterLocation
WorkCenterLocationGroup WorkCenterLocationGroup
WorkCenterUsage WorkCenterUsage
WorkCenterResponsible WorkCenterResponsible
Plant Plant
SupplyArea SupplyArea
CapacityInternalID CapacityInternalID
MachineType MachineType
OperationControlProfile OperationControlProfile
MatlCompIsMarkedForBackflush MatlCompIsMarkedForBackflush
WorkCenterSetupType WorkCenterSetupType
FreeDefinedTableFieldSemantic FreeDefinedTableFieldSemantic
ObjectInternalID ObjectInternalID
StandardTextInternalID StandardTextInternalID
EmployeeWageType EmployeeWageType
EmployeeWageGroup EmployeeWageGroup
EmployeeSuitability EmployeeSuitability
NumberOfTimeTickets NumberOfTimeTickets
PlanVersion PlanVersion
WrkCtrHumRsceObjID WrkCtrHumRsceObjID
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
StandardTextIDIsReferenced StandardTextIDIsReferenced
EmployeeWageTypeIsReferenced EmployeeWageTypeIsReferenced
NmbrOfTimeTicketsIsReferenced NmbrOfTimeTicketsIsReferenced
EmployeeWageGroupIsReferenced EmployeeWageGroupIsReferenced
EmplSuitabilityIsReferenced EmplSuitabilityIsReferenced
WorkCenterSetpTypeIsReferenced WorkCenterSetpTypeIsReferenced
OpControlProfileIsReferenced OpControlProfileIsReferenced
NumberOfConfSlipsIsReferenced NumberOfConfSlipsIsReferenced
WorkCenterStdQueueDurnUnit WorkCenterStdQueueDurnUnit
WorkCenterStandardQueueDurn WorkCenterStandardQueueDurn
WorkCenterMinimumQueueDurnUnit WorkCenterMinimumQueueDurnUnit
WorkCenterMinimumQueueDuration WorkCenterMinimumQueueDuration
WorkCenterStandardWorkQtyUnit1 WorkCenterStandardWorkQtyUnit1
WorkCenterStandardWorkQtyUnit2 WorkCenterStandardWorkQtyUnit2
WorkCenterStandardWorkQtyUnit3 WorkCenterStandardWorkQtyUnit3
WorkCenterStandardWorkQtyUnit4 WorkCenterStandardWorkQtyUnit4
WorkCenterStandardWorkQtyUnit5 WorkCenterStandardWorkQtyUnit5
WorkCenterStandardWorkQtyUnit6 WorkCenterStandardWorkQtyUnit6
StandardWorkQuantityUnit StandardWorkQuantityUnit
StandardWorkFormulaParamGroup StandardWorkFormulaParamGroup
LaborTrackingIsRequired LaborTrackingIsRequired
WorkCenterFormulaParam1 WorkCenterFormulaParam1
WorkCenterFormulaParam2 WorkCenterFormulaParam2
WorkCenterFormulaParam3 WorkCenterFormulaParam3
WorkCenterFormulaParam4 WorkCenterFormulaParam4
WorkCenterFormulaParam5 WorkCenterFormulaParam5
WorkCenterFormulaParam6 WorkCenterFormulaParam6
WorkCenterFmlaParamValue1 WorkCenterFmlaParamValue1
WorkCenterFmlaParamValue2 WorkCenterFmlaParamValue2
WorkCenterFmlaParamValue3 WorkCenterFmlaParamValue3
WorkCenterFmlaParamValue4 WorkCenterFmlaParamValue4
WorkCenterFmlaParamValue5 WorkCenterFmlaParamValue5
WorkCenterFmlaParamValue6 WorkCenterFmlaParamValue6
WorkCenterFmlaParamUnit1 WorkCenterFmlaParamUnit1
WorkCenterFmlaParamUnit2 WorkCenterFmlaParamUnit2
WorkCenterFmlaParamUnit3 WorkCenterFmlaParamUnit3
WorkCenterFmlaParamUnit4 WorkCenterFmlaParamUnit4
WorkCenterFmlaParamUnit5 WorkCenterFmlaParamUnit5
WorkCenterFmlaParamUnit6 WorkCenterFmlaParamUnit6
WrkCtrStdValMaintRule1 WrkCtrStdValMaintRule1
WrkCtrStdValMaintRule2 WrkCtrStdValMaintRule2
WrkCtrStdValMaintRule3 WrkCtrStdValMaintRule3
WrkCtrStdValMaintRule4 WrkCtrStdValMaintRule4
WrkCtrStdValMaintRule5 WrkCtrStdValMaintRule5
WrkCtrStdValMaintRule6 WrkCtrStdValMaintRule6
WrkCtrSetupSchedgFmla WrkCtrSetupSchedgFmla
WrkCtrProcgSchedgFmla WrkCtrProcgSchedgFmla
WrkCtrTeardownSchedgFmla WrkCtrTeardownSchedgFmla
WrkCtrIntProcgSchedgFmla WrkCtrIntProcgSchedgFmla
_Capacity _Capacity
_CostCenter _CostCenter
_EmployeeSuitability _EmployeeSuitability
_EmployeeWageGroup _EmployeeWageGroup
_LastChangedByUser _LastChangedByUser
_MachineType _MachineType
_MinimumQueueDurationUnit _MinimumQueueDurationUnit
_OperationControlProfile _OperationControlProfile
_Plant _Plant
_ProductionResourceType _ProductionResourceType
_StandardQueueDurationUnit _StandardQueueDurationUnit
_StandardTextInternalID _StandardTextInternalID
_StandardWorkFmlaParamGroup _StandardWorkFmlaParamGroup
_StandardWorkFormulaParameter1 _StandardWorkFormulaParameter1
_StandardWorkFormulaParameter2 _StandardWorkFormulaParameter2
_StandardWorkFormulaParameter3 _StandardWorkFormulaParameter3
_StandardWorkFormulaParameter4 _StandardWorkFormulaParameter4
_StandardWorkFormulaParameter5 _StandardWorkFormulaParameter5
_StandardWorkFormulaParameter6 _StandardWorkFormulaParameter6
_StandardWorkQuantityUnit _StandardWorkQuantityUnit
_SupplyArea _SupplyArea
_Text _Text
_ValidityEndDate _ValidityEndDate
_ValidityStartDate _ValidityStartDate
_WorkCenter _WorkCenter
_WorkCenterCategory _WorkCenterCategory
_WorkCenterCostCenter _WorkCenterCostCenter
_WorkCenterFmlaParamUnit1 _WorkCenterFmlaParamUnit1
_WorkCenterFmlaParamUnit2 _WorkCenterFmlaParamUnit2
_WorkCenterFmlaParamUnit3 _WorkCenterFmlaParamUnit3
_WorkCenterFmlaParamUnit4 _WorkCenterFmlaParamUnit4
_WorkCenterFmlaParamUnit5 _WorkCenterFmlaParamUnit5
_WorkCenterFmlaParamUnit6 _WorkCenterFmlaParamUnit6
_WorkCenterLocation _WorkCenterLocation
_WorkCenterLocationGroup _WorkCenterLocationGroup
_WorkCenterResponsible _WorkCenterResponsible
_WorkCenterSetupType _WorkCenterSetupType
_WorkCenterType _WorkCenterType
_WorkCenterUsage _WorkCenterUsage
_WorkQuantityUnit1 _WorkQuantityUnit1
_WorkQuantityUnit2 _WorkQuantityUnit2
_WorkQuantityUnit3 _WorkQuantityUnit3
_WorkQuantityUnit4 _WorkQuantityUnit4
_WorkQuantityUnit5 _WorkQuantityUnit5
_WorkQuantityUnit6 _WorkQuantityUnit6
_WrkCtrIntProcgSchedgFormula _WrkCtrIntProcgSchedgFormula
_WrkCtrProcgSchedgFormula _WrkCtrProcgSchedgFormula
_WrkCtrSchedgSetupFormula _WrkCtrSchedgSetupFormula
_WrkCtrTeardownSchedgFormula _WrkCtrTeardownSchedgFormula 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Work Center Details'
//@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #MASTER
}
@VDM.viewType: #CONSUMPTION
define view entity C_InspRsltRecgWorkCenter as select from I_WorkCenter {
  key WorkCenterInternalID,
  key WorkCenterTypeCode,
  WorkCenter,
  WorkCenterIsToBeDeleted,
  WorkCenterIsLocked,
  WorkCenterIsMntndForCosting,
  WorkCenterIsMntndForScheduling,
  NumberOfConfirmationSlips,
  AdvancedPlanningIsSupported,
  ShiftNoteType,
  ShiftReportType,
  WorkCenterLastChangedBy,
  WorkCenterLastChangeDateTime,
  WorkCenterCategoryCode,
  WorkCenterLocation,
  WorkCenterLocationGroup,
  WorkCenterUsage,
  WorkCenterResponsible,
  Plant,
  SupplyArea,
  CapacityInternalID,
  MachineType,
  OperationControlProfile,
  MatlCompIsMarkedForBackflush,
  WorkCenterSetupType,
  FreeDefinedTableFieldSemantic,
  ObjectInternalID,
  StandardTextInternalID,
  EmployeeWageType,
  EmployeeWageGroup,
  EmployeeSuitability,
  NumberOfTimeTickets,
  PlanVersion,
  WrkCtrHumRsceObjID,
  ValidityStartDate,
  ValidityEndDate,
  StandardTextIDIsReferenced,
  EmployeeWageTypeIsReferenced,
  NmbrOfTimeTicketsIsReferenced,
  EmployeeWageGroupIsReferenced,
  EmplSuitabilityIsReferenced,
  WorkCenterSetpTypeIsReferenced,
  OpControlProfileIsReferenced,
  NumberOfConfSlipsIsReferenced,
  WorkCenterStdQueueDurnUnit,
  WorkCenterStandardQueueDurn,
  WorkCenterMinimumQueueDurnUnit,
  WorkCenterMinimumQueueDuration,
  WorkCenterStandardWorkQtyUnit1,
  WorkCenterStandardWorkQtyUnit2,
  WorkCenterStandardWorkQtyUnit3,
  WorkCenterStandardWorkQtyUnit4,
  WorkCenterStandardWorkQtyUnit5,
  WorkCenterStandardWorkQtyUnit6,
  StandardWorkQuantityUnit,
  StandardWorkFormulaParamGroup,
  LaborTrackingIsRequired,
  WorkCenterFormulaParam1,
  WorkCenterFormulaParam2,
  WorkCenterFormulaParam3,
  WorkCenterFormulaParam4,
  WorkCenterFormulaParam5,
  WorkCenterFormulaParam6,
  WorkCenterFmlaParamValue1,
  WorkCenterFmlaParamValue2,
  WorkCenterFmlaParamValue3,
  WorkCenterFmlaParamValue4,
  WorkCenterFmlaParamValue5,
  WorkCenterFmlaParamValue6,
  WorkCenterFmlaParamUnit1,
  WorkCenterFmlaParamUnit2,
  WorkCenterFmlaParamUnit3,
  WorkCenterFmlaParamUnit4,
  WorkCenterFmlaParamUnit5,
  WorkCenterFmlaParamUnit6,
  WrkCtrStdValMaintRule1,
  WrkCtrStdValMaintRule2,
  WrkCtrStdValMaintRule3,
  WrkCtrStdValMaintRule4,
  WrkCtrStdValMaintRule5,
  WrkCtrStdValMaintRule6,
  WrkCtrSetupSchedgFmla,
  WrkCtrProcgSchedgFmla,
  WrkCtrTeardownSchedgFmla,
  WrkCtrIntProcgSchedgFmla,
  /* Associations */
  _Capacity,
  _CostCenter,
  _EmployeeSuitability,
  _EmployeeWageGroup,
  _LastChangedByUser,
  _MachineType,
  _MinimumQueueDurationUnit,
  _OperationControlProfile,
  _Plant,
  _ProductionResourceType,
  _StandardQueueDurationUnit,
  _StandardTextInternalID,
  _StandardWorkFmlaParamGroup,
  _StandardWorkFormulaParameter1,
  _StandardWorkFormulaParameter2,
  _StandardWorkFormulaParameter3,
  _StandardWorkFormulaParameter4,
  _StandardWorkFormulaParameter5,
  _StandardWorkFormulaParameter6,
  _StandardWorkQuantityUnit,
  _SupplyArea,
  _Text,
  _ValidityEndDate,
  _ValidityStartDate,
  _WorkCenter,
  _WorkCenterCategory,
  _WorkCenterCostCenter,
  _WorkCenterFmlaParamUnit1,
  _WorkCenterFmlaParamUnit2,
  _WorkCenterFmlaParamUnit3,
  _WorkCenterFmlaParamUnit4,
  _WorkCenterFmlaParamUnit5,
  _WorkCenterFmlaParamUnit6,
  _WorkCenterLocation,
  _WorkCenterLocationGroup,
  _WorkCenterResponsible,
  _WorkCenterSetupType,
  _WorkCenterType,
  _WorkCenterUsage,
  _WorkQuantityUnit1,
  _WorkQuantityUnit2,
  _WorkQuantityUnit3,
  _WorkQuantityUnit4,
  _WorkQuantityUnit5,
  _WorkQuantityUnit6,
  _WrkCtrIntProcgSchedgFormula,
  _WrkCtrProcgSchedgFormula,
  _WrkCtrSchedgSetupFormula,
  _WrkCtrTeardownSchedgFormula
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKCENTER"
],
"ASSOCIATED":
[
"I_CALENDARDATE",
"I_CAPACITY",
"I_EMPLOYEESUITABILITY",
"I_EMPLOYEEWAGEGROUP",
"I_MACHINETYPE",
"I_OPERATIONCONTROLPROFILE",
"I_OPERATIONSETUPTYPE",
"I_OPERATIONSTANDARDTEXT",
"I_PLANT",
"I_PRODNRSCETOOLQTYCALCFORMULA",
"I_PRODUCTIONRESOURCETYPE",
"I_PRODUCTIONRESOURCEUSAGE",
"I_PRODUCTIONSUPPLYAREA",
"I_STANDARDWORKFMLAPARAMGROUP",
"I_STANDARDWORKFORMULAPARAMETER",
"I_UNITOFMEASURE",
"I_USER",
"I_WORKCENTERBYSEMANTICKEY",
"I_WORKCENTERCATEGORY",
"I_WORKCENTERCOSTCENTER",
"I_WORKCENTERLOCATION",
"I_WORKCENTERLOCATIONGROUP",
"I_WORKCENTERRESPONSIBLE",
"I_WORKCENTERTEXT",
"I_WORKCENTERTYPE"
],
"BASE":
[
"I_WORKCENTER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More