A_WorkCenter

DDL: A_WORKCENTER Type: view_entity CONSUMPTION Package: ODATA_PP_WORKCENTER_API
56 Fields 1 Data Sources 2 OData Services

Work Center Header

A_WorkCenter is a Consumption CDS View that provides data about "Work Center Header" in SAP S/4HANA. It reads from 1 data source (R_WorkCenterTP) and exposes 56 fields with key fields WorkCenterInternalID, WorkCenterTypeCode. It is exposed through 2 OData services (API_WORKCENTER, ASQL_F8413). Part of development package ODATA_PP_WORKCENTER_API.

Data Sources (1)

SourceAliasJoin Type
R_WorkCenterTP R_WorkCenterTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Work Center Header view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view

OData Services (2)

ServiceBindingVersionContractRelease
API_WORKCENTER API_WORK_CENTER V4 C2 C1
ASQL_F8413 ASQL_F8413 C2 NOT_RELEASED

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID Work Center Internal Id
KEY WorkCenterTypeCode WorkCenterTypeCode Work Center Type Code
WorkCenter WorkCenter Work Center
WorkCenterDesc WorkCenterDesc
Plant Plant Valuation Area
WorkCenterCategoryCode WorkCenterCategoryCode
WorkCenterResponsible WorkCenterResponsible
WorkCenterResponsibleName WorkCenterResponsibleName
SupplyArea SupplyArea Supply Area
WorkCenterUsage WorkCenterUsage
CapacityInternalID CapacityInternalID Capacity ID
CapacityCategoryCode CapacityCategoryCode
Capacity Capacity Engine Capacity
WorkCenterIsToBeDeleted WorkCenterIsToBeDeleted
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
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
StandardWorkFormulaParamGroup StandardWorkFormulaParamGroup
WrkCtrStdValMaintRule1 WrkCtrStdValMaintRule1
WrkCtrStdValMaintRule2 WrkCtrStdValMaintRule2
WrkCtrStdValMaintRule3 WrkCtrStdValMaintRule3
WrkCtrStdValMaintRule4 WrkCtrStdValMaintRule4
WrkCtrStdValMaintRule5 WrkCtrStdValMaintRule5
WrkCtrStdValMaintRule6 WrkCtrStdValMaintRule6
WorkCenterStandardWorkQtyUnit1 WorkCenterStandardWorkQtyUnit1
WorkCenterStandardWorkQtyUnit2 WorkCenterStandardWorkQtyUnit2
WorkCenterStandardWorkQtyUnit3 WorkCenterStandardWorkQtyUnit3
WorkCenterStandardWorkQtyUnit4 WorkCenterStandardWorkQtyUnit4
WorkCenterStandardWorkQtyUnit5 WorkCenterStandardWorkQtyUnit5
WorkCenterStandardWorkQtyUnit6 WorkCenterStandardWorkQtyUnit6
OperationControlProfile OperationControlProfile Control Key
MatlCompIsMarkedForBackflush MatlCompIsMarkedForBackflush Backflush
WorkCenterLocation WorkCenterLocation
WorkCenterLocationGroup WorkCenterLocationGroup
WrkCtrSetupSchedgFmla WrkCtrSetupSchedgFmla
WrkCtrProcgSchedgFmla WrkCtrProcgSchedgFmla
WrkCtrTeardownSchedgFmla WrkCtrTeardownSchedgFmla
WrkCtrIntProcgSchedgFmla WrkCtrIntProcgSchedgFmla
WorkCenterLastChangeDateTime WorkCenterLastChangeDateTime

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 A_WorkCenter.
-- 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 A_WorkCenter AS
SELECT
  WorkCenterInternalID,
  WorkCenterTypeCode,
  WorkCenter,
  WorkCenterDesc,
  Plant,
  WorkCenterCategoryCode,
  WorkCenterResponsible,
  WorkCenterResponsibleName,
  SupplyArea,
  WorkCenterUsage,
  CapacityInternalID,
  CapacityCategoryCode,
  Capacity,
  WorkCenterIsToBeDeleted,
  ValidityStartDate,
  ValidityEndDate,
  WorkCenterFormulaParam1,
  WorkCenterFormulaParam2,
  WorkCenterFormulaParam3,
  WorkCenterFormulaParam4,
  WorkCenterFormulaParam5,
  WorkCenterFormulaParam6,
  WorkCenterFmlaParamValue1,
  WorkCenterFmlaParamValue2,
  WorkCenterFmlaParamValue3,
  WorkCenterFmlaParamValue4,
  WorkCenterFmlaParamValue5,
  WorkCenterFmlaParamValue6,
  WorkCenterFmlaParamUnit1,
  WorkCenterFmlaParamUnit2,
  WorkCenterFmlaParamUnit3,
  WorkCenterFmlaParamUnit4,
  WorkCenterFmlaParamUnit5,
  WorkCenterFmlaParamUnit6,
  StandardWorkFormulaParamGroup,
  WrkCtrStdValMaintRule1,
  WrkCtrStdValMaintRule2,
  WrkCtrStdValMaintRule3,
  WrkCtrStdValMaintRule4,
  WrkCtrStdValMaintRule5,
  WrkCtrStdValMaintRule6,
  WorkCenterStandardWorkQtyUnit1,
  WorkCenterStandardWorkQtyUnit2,
  WorkCenterStandardWorkQtyUnit3,
  WorkCenterStandardWorkQtyUnit4,
  WorkCenterStandardWorkQtyUnit5,
  WorkCenterStandardWorkQtyUnit6,
  OperationControlProfile,
  MatlCompIsMarkedForBackflush,
  WorkCenterLocation,
  WorkCenterLocationGroup,
  WrkCtrSetupSchedgFmla,
  WrkCtrProcgSchedgFmla,
  WrkCtrTeardownSchedgFmla,
  WrkCtrIntProcgSchedgFmla,
  WorkCenterLastChangeDateTime
FROM R_WorkCenterTP
;

Learn More