C_OperationActivitySFIGroup

DDL: C_OPERATIONACTIVITYSFIGROUP Type: view_entity CONSUMPTION
20 Fields 1 Data Sources 1 OData Services

Manage SFI at Operation Activity Group

C_OperationActivitySFIGroup is a Consumption CDS View that provides data about "Manage SFI at Operation Activity Group" in SAP S/4HANA. It reads from 1 data source (I_OpActySFIGroupTP) and exposes 20 fields with key field OperationActivitySFIGroup. It is exposed through 1 OData service (UI_OPACTYSFIGROUP_MANAGE).

Data Sources (1)

SourceAliasJoin Type
I_OpActySFIGroupTP I_OpActySFIGroupTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey OperationActivitySFIGroup view
VDM.viewType #CONSUMPTION view
EndUserText.label Manage SFI at Operation Activity Group view

OData Services (1)

ServiceBindingVersionContractRelease
UI_OPACTYSFIGROUP_MANAGE UI_OPACTYSFIGROUP_MANAGE V2 C1 NOT_RELEASED

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY OperationActivitySFIGroup OpActySFIGroup OperationActivitySFIGroup
OpActySFIGroupName OpActySFIGroup OpActySFIGroupName
ProductionPlant OpActySFIGroup ProductionPlant Prod plnt
WorkCenterInternalID OpActySFIGroup WorkCenterInternalID Work Center
WorkCenter OpActySFIGroup WorkCenter Work Center
StatusAndActionSchema OpActySFIGroup StatusAndActionSchema
StatusAndActionSchemaStatus OpActySFIGroup StatusAndActionSchemaStatus
SASStatusName
SASStatusCategory OpActySFIGroup SASStatusCategory
CreatedByUser OpActySFIGroup CreatedByUser User Name
CreationDateTime OpActySFIGroup CreationDateTime Timestamp
LastChangedByUser OpActySFIGroup LastChangedByUser User Name
LastChangeDateTime OpActySFIGroup LastChangeDateTime Timestamp
_ProductionPlant OpActySFIGroup _ProductionPlant
_SASSchema OpActySFIGroup _SASSchema
_SASStatus OpActySFIGroup _SASStatus
_SASStatusText OpActySFIGroup _SASStatusText
_SASStatusCategory OpActySFIGroup _SASStatusCategory
_WorkCenterByInternalID OpActySFIGroup _WorkCenterByInternalID
_ShopFloorItemStatus OpActySFIGroup _ShopFloorItemStatus

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_OperationActivitySFIGroup.
-- 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_OperationActivitySFIGroup AS
SELECT
  OpActySFIGroup.OperationActivitySFIGroup AS OperationActivitySFIGroup,
  OpActySFIGroup.OpActySFIGroupName AS OpActySFIGroupName,
  OpActySFIGroup.ProductionPlant AS ProductionPlant,
  OpActySFIGroup.WorkCenterInternalID AS WorkCenterInternalID,
  OpActySFIGroup.WorkCenter AS WorkCenter,
  OpActySFIGroup.StatusAndActionSchema AS StatusAndActionSchema,
  OpActySFIGroup.StatusAndActionSchemaStatus AS StatusAndActionSchemaStatus,
  OpActySFIGroup._SASStatusText[1: Language=$session.system_language].SASStatusName AS SASStatusName,
  OpActySFIGroup.SASStatusCategory AS SASStatusCategory,
  OpActySFIGroup.CreatedByUser AS CreatedByUser,
  OpActySFIGroup.CreationDateTime AS CreationDateTime,
  OpActySFIGroup.LastChangedByUser AS LastChangedByUser,
  OpActySFIGroup.LastChangeDateTime AS LastChangeDateTime,
  OpActySFIGroup._ProductionPlant AS _ProductionPlant,
  OpActySFIGroup._SASSchema AS _SASSchema,
  OpActySFIGroup._SASStatus AS _SASStatus,
  OpActySFIGroup._SASStatusText AS _SASStatusText,
  OpActySFIGroup._SASStatusCategory AS _SASStatusCategory,
  OpActySFIGroup._WorkCenterByInternalID AS _WorkCenterByInternalID,
  OpActySFIGroup._ShopFloorItemStatus AS _ShopFloorItemStatus
FROM I_OpActySFIGroupTP
;

Learn More