C_InspRsltRecgWorkCenter

DDL: C_INSPRSLTRECGWORKCENTER Type: view_entity CONSUMPTION Package: ODATA_QM_RSLT_RECG
134 Fields 1 Data Sources 2 OData Services 1 Fiori Apps

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. It is exposed through 2 OData services (ASQL_F1685A, UI_INSPLOT_RSLTRECG). It is used in 1 Fiori application: Record Inspection Results (Version 2). Part of development package ODATA_QM_RSLT_RECG.

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

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F1685A ASQL_F1685A C2 NOT_RELEASED
UI_INSPLOT_RSLTRECG UI_INSPLOT_RSLTRECG V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F1685A Record Inspection Results (Version 2) Transactional An application to record results for inspection characteristics.

Record Inspection Results (Version 2)

Business Role: Quality Technician

With the new Record Inspection Results app, you can record and process results for characteristics for one or more inspection lots effectively. You can also use this app to create defects manually for different categories, such as inspection lots, inspection operations, and characteristics.

Fields (134)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID Work Center
KEY WorkCenterTypeCode WorkCenterTypeCode Object Type
WorkCenter WorkCenter Work Center
WorkCenterIsToBeDeleted WorkCenterIsToBeDeleted Stock del. flag
WorkCenterIsLocked WorkCenterIsLocked Locked
WorkCenterIsMntndForCosting WorkCenterIsMntndForCosting Costs
WorkCenterIsMntndForScheduling WorkCenterIsMntndForScheduling Scheduling
NumberOfConfirmationSlips NumberOfConfirmationSlips No. of Conf. Slips
AdvancedPlanningIsSupported AdvancedPlanningIsSupported Advanced Planning
ShiftNoteType ShiftNoteType Shift Note Type
ShiftReportType ShiftReportType Report Type
WorkCenterLastChangedBy WorkCenterLastChangedBy User Name
WorkCenterLastChangeDateTime WorkCenterLastChangeDateTime
WorkCenterCategoryCode WorkCenterCategoryCode Work Center Category
WorkCenterLocation WorkCenterLocation Std Class Type
WorkCenterLocationGroup WorkCenterLocationGroup Location Group
WorkCenterUsage WorkCenterUsage
WorkCenterResponsible WorkCenterResponsible Responsible
Plant Plant Valuation Area
SupplyArea SupplyArea Supply Area
CapacityInternalID CapacityInternalID Capacity ID
MachineType MachineType Machine Type
OperationControlProfile OperationControlProfile Control Key
MatlCompIsMarkedForBackflush MatlCompIsMarkedForBackflush Backflush
WorkCenterSetupType WorkCenterSetupType
FreeDefinedTableFieldSemantic FreeDefinedTableFieldSemantic
ObjectInternalID ObjectInternalID Object number
StandardTextInternalID StandardTextInternalID
EmployeeWageType EmployeeWageType Wage type
EmployeeWageGroup EmployeeWageGroup Wage Group
EmployeeSuitability EmployeeSuitability
NumberOfTimeTickets NumberOfTimeTickets No.TimeTickets
PlanVersion PlanVersion
WrkCtrHumRsceObjID WrkCtrHumRsceObjID
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
StandardTextIDIsReferenced StandardTextIDIsReferenced Std Text Referenced
EmployeeWageTypeIsReferenced EmployeeWageTypeIsReferenced Wage Type Ref.
NmbrOfTimeTicketsIsReferenced NmbrOfTimeTicketsIsReferenced No. Time Ticktes Ref
EmployeeWageGroupIsReferenced EmployeeWageGroupIsReferenced Wage Group Ref.
EmplSuitabilityIsReferenced EmplSuitabilityIsReferenced Suitability Ref.
WorkCenterSetpTypeIsReferenced WorkCenterSetpTypeIsReferenced Setup Type Ref.
OpControlProfileIsReferenced OpControlProfileIsReferenced Control Profile Ref.
NumberOfConfSlipsIsReferenced NumberOfConfSlipsIsReferenced No. Conf. Slips Ref.
WorkCenterStdQueueDurnUnit WorkCenterStdQueueDurnUnit Std Queue Unit
WorkCenterStandardQueueDurn WorkCenterStandardQueueDurn Min. Queue Time
WorkCenterMinimumQueueDurnUnit WorkCenterMinimumQueueDurnUnit Std Queue Unit
WorkCenterMinimumQueueDuration WorkCenterMinimumQueueDuration Min. Queue Time
WorkCenterStandardWorkQtyUnit1 WorkCenterStandardWorkQtyUnit1
WorkCenterStandardWorkQtyUnit2 WorkCenterStandardWorkQtyUnit2
WorkCenterStandardWorkQtyUnit3 WorkCenterStandardWorkQtyUnit3
WorkCenterStandardWorkQtyUnit4 WorkCenterStandardWorkQtyUnit4
WorkCenterStandardWorkQtyUnit5 WorkCenterStandardWorkQtyUnit5
WorkCenterStandardWorkQtyUnit6 WorkCenterStandardWorkQtyUnit6
StandardWorkQuantityUnit StandardWorkQuantityUnit Work Unit
StandardWorkFormulaParamGroup StandardWorkFormulaParamGroup Std Value Key
LaborTrackingIsRequired LaborTrackingIsRequired Labor Tracking
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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_InspRsltRecgWorkCenter.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_InspRsltRecgWorkCenter AS
SELECT
  WorkCenterInternalID,
  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
FROM I_WorkCenter
;

Learn More