C_SftyCertOvwByWorkCenter

DDL: C_SFTYCERTOVWBYWORKCENTER SQL: CSFTYCERTWC Type: view CONSUMPTION
21 Fields 1 Data Sources

Safety Certificate By WC

C_SftyCertOvwByWorkCenter is a Consumption CDS View that provides data about "Safety Certificate By WC" in SAP S/4HANA. It reads from 1 data source (C_SafetyCertificateQuery) and exposes 21 fields with key field SafetyCertificate.

Data Sources (1)

SourceAliasJoin Type
C_SafetyCertificateQuery C_SafetyCertificateQuery from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSFTYCERTWC view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Safety Certificate By WC view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #CONSUMPTION view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY SafetyCertificate SafetyCertificate WC Document
SafetyCertificateType SafetyCertificateType Usage
SftyCertificateTypeDescription SftyCertificateTypeDescription Sfty Cert Type Desc
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlant MaintenancePlant Plant
SftyCertProcessingStatus SftyCertProcessingStatus Proc Stat Sfty Cert
SftyCertProcessingStatusText SftyCertProcessingStatusText Short Description
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
TechObjAuthorizationGroup TechObjAuthorizationGroup AuthorizGroup
FunctionalLocation FunctionalLocation Object ID
Equipment Equipment Equipment check
OperationWorkCenterInternalID OperationWorkCenterInternalID Object ID
WorkCenter WorkCenter Work Center
WorkCenterText WorkCenterText Work Center Text
SftyCertValidFrmDate SftyCertValidFrmDate Valid from
SftyCertValidToDate SftyCertValidToDate Valid to
AssetLocation AssetLocation Location
PlantSection PlantSection Plant Section
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
NumberOfOpenSafetyCertificates NumberOfOpenSafetyCertificates
TechnicalObjectLabel TechnicalObjectLabel Tech. Object

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_SftyCertOvwByWorkCenter.
-- 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.
-- SQL view name: CSFTYCERTWC

CREATE VIEW C_SftyCertOvwByWorkCenter AS
SELECT
  SafetyCertificate,
  SafetyCertificateType,
  SftyCertificateTypeDescription,
  MaintenancePlanningPlant,
  MaintenancePlant,
  SftyCertProcessingStatus,
  SftyCertProcessingStatusText,
  MaintenancePlannerGroup,
  TechObjAuthorizationGroup,
  FunctionalLocation,
  Equipment,
  OperationWorkCenterInternalID,
  WorkCenter,
  WorkCenterText,
  SftyCertValidFrmDate,
  SftyCertValidToDate,
  AssetLocation,
  PlantSection,
  TechObjIsEquipOrFuncnlLoc,
  NumberOfOpenSafetyCertificates,
  TechnicalObjectLabel
FROM C_SafetyCertificateQuery
;

Learn More