C_IsltnCertOvwByWorkCenter

DDL: C_ISLTNCERTOVWBYWORKCENTER Type: view_entity CONSUMPTION
22 Fields 1 Data Sources

Isolation Certificate By WC

C_IsltnCertOvwByWorkCenter is a Consumption CDS View that provides data about "Isolation Certificate By WC" in SAP S/4HANA. It reads from 1 data source (C_IsolationCertificateQuery) and exposes 22 fields with key field IsolationCertificate.

Data Sources (1)

SourceAliasJoin Type
C_IsolationCertificateQuery C_IsolationCertificateQuery from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Isolation 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 (22)

KeyFieldSource TableSource FieldDescription
KEY IsolationCertificate IsolationCertificate WC Document
IsolationCertificateType IsolationCertificateType Usage
IsltnCertTypeDescription IsltnCertTypeDescription Sfty Cert Type Desc
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlant MaintenancePlant Plant
IsltnCertProcessingStatus IsltnCertProcessingStatus Proc Stat Sfty Cert
IsltnCertProcessingStatusText IsltnCertProcessingStatusText 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
ValidFromDateTime ValidFromDateTime Time Stamp
ValidToDateTime ValidToDateTime Time Stamp
AssetLocation AssetLocation Location
PlantSection PlantSection Plant Section
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
TechObjIsEquipOrFuncnlLocDesc TechObjIsEquipOrFuncnlLocDesc TObj.Type Desc.
NrOfOpenIsolationCertificates NrOfOpenIsolationCertificates
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_IsltnCertOvwByWorkCenter.
-- 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_IsltnCertOvwByWorkCenter AS
SELECT
  IsolationCertificate,
  IsolationCertificateType,
  IsltnCertTypeDescription,
  MaintenancePlanningPlant,
  MaintenancePlant,
  IsltnCertProcessingStatus,
  IsltnCertProcessingStatusText,
  MaintenancePlannerGroup,
  TechObjAuthorizationGroup,
  FunctionalLocation,
  Equipment,
  OperationWorkCenterInternalID,
  WorkCenter,
  WorkCenterText,
  ValidFromDateTime,
  ValidToDateTime,
  AssetLocation,
  PlantSection,
  TechObjIsEquipOrFuncnlLoc,
  TechObjIsEquipOrFuncnlLocDesc,
  NrOfOpenIsolationCertificates,
  TechnicalObjectLabel
FROM C_IsolationCertificateQuery
;

Learn More