C_IsltnCertOvwByIsltnCertType

DDL: C_ISLTNCERTOVWBYISLTNCERTTYPE Type: view_entity CONSUMPTION
16 Fields 1 Data Sources

Isolation Certificate By Type

C_IsltnCertOvwByIsltnCertType is a Consumption CDS View that provides data about "Isolation Certificate By Type" in SAP S/4HANA. It reads from 1 data source (C_IsolationCertificateQuery) and exposes 16 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 Type 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 (16)

KeyFieldSource TableSource FieldDescription
KEY IsolationCertificate IsolationCertificate WC Document
IsolationCertificateType IsolationCertificateType Usage
IsltnCertTypeDescription IsltnCertTypeDescription Sfty Cert Type Desc
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
WorkCenter WorkCenter Work Center
MaintenancePlant MaintenancePlant Plant
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
IsltnCertProcessingStatus IsltnCertProcessingStatus Proc Stat Sfty Cert
IsltnCertProcessingStatusText IsltnCertProcessingStatusText Short Description
NrOfOpenIsolationCertificates NrOfOpenIsolationCertificates
TechObjAuthorizationGroup TechObjAuthorizationGroup AuthorizGroup
AssetLocation AssetLocation Location
PlantSection PlantSection Plant Section
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
TechObjIsEquipOrFuncnlLocDesc TechObjIsEquipOrFuncnlLocDesc TObj.Type Desc.
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_IsltnCertOvwByIsltnCertType.
-- 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_IsltnCertOvwByIsltnCertType AS
SELECT
  IsolationCertificate,
  IsolationCertificateType,
  IsltnCertTypeDescription,
  MaintenancePlanningPlant,
  WorkCenter,
  MaintenancePlant,
  MaintenancePlannerGroup,
  IsltnCertProcessingStatus,
  IsltnCertProcessingStatusText,
  NrOfOpenIsolationCertificates,
  TechObjAuthorizationGroup,
  AssetLocation,
  PlantSection,
  TechObjIsEquipOrFuncnlLoc,
  TechObjIsEquipOrFuncnlLocDesc,
  TechnicalObjectLabel
FROM C_IsolationCertificateQuery
;

Learn More