I_IsltnCertItmConflictCheck

DDL: I_ISLTNCERTITMCONFLICTCHECK Type: view_entity BASIC
31 Fields 1 Data Sources

Isolation Item Conflict Log

I_IsltnCertItmConflictCheck is a Basic CDS View that provides data about "Isolation Item Conflict Log" in SAP S/4HANA. It reads from 1 data source (wcaci) and exposes 31 fields with key field IsolationCertItemInternalID.

Data Sources (1)

SourceAliasJoin Type
wcaci wcaci from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Isolation Item Conflict Log view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY IsolationCertItemInternalID objnr Val. Obj. No.
MaintenancePlanningPlant iwerk Planning Plant
IsolationCertificate wcnr WC Document
IsolationCertificateItem wcitm Item
IsltnCertItemSequenceNumber seq Sequence
TechnicalObjectLabel ccobj Tech. Object
IsltnCertItmCatType cctyp Item Category
IsltnCertItemOperationalGroup tggrp Op. Group
IsltnCertItemTaggingStep tgstep Tagging Step
IsltnCertItmTaggingCondition tgproc Tagging Cond.
IsltnCertItmTaggingType tgtyp Tagging Type
IsltnCertItmUntaggingStep unstep Untagging Step
IsltnCertItmUntaggingCondition unproc Untag.Cond.
IsltnCertItmUntaggingType untyp Untagging Type
StatusCode tgstat Status
IsltnCertItmPhysBlkIsRqd phblflg Phys. Blocking
IsltnCertItmPhysicalBlockType phbltyp Blocking Type
IsltnCertItemLockNumber phblnr Lock
IsltnCertItemTagIsRequired tgflg TG Text Exists
IsolationCertificateItemTag tgnr Tag
IsltnCertItemTagPrintFormat tgform Print Format
IsltnCertItmTestTag unnr Test Tag
CreatedByUserName crname Last Changed By
CreationDate crdate Sizing Date
CreationTime crtime Time Created
LastChangedByUserName chname Changed By
LastChangeDate chdate Date Changed
LastChangeTime chtime Time Changed
IsltnCertItmCurOplStep actstep Step
IsltnCertItmCurOplCondition actproc Op. Condition
IsltnCertItmCurOplType acttyp Optn Type

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 I_IsltnCertItmConflictCheck.
-- 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 I_IsltnCertItmConflictCheck AS
SELECT
  objnr AS IsolationCertItemInternalID,
  iwerk AS MaintenancePlanningPlant,
  wcnr AS IsolationCertificate,
  wcitm AS IsolationCertificateItem,
  seq AS IsltnCertItemSequenceNumber,
  ccobj AS TechnicalObjectLabel,
  cctyp AS IsltnCertItmCatType,
  tggrp AS IsltnCertItemOperationalGroup,
  tgstep AS IsltnCertItemTaggingStep,
  tgproc AS IsltnCertItmTaggingCondition,
  tgtyp AS IsltnCertItmTaggingType,
  unstep AS IsltnCertItmUntaggingStep,
  unproc AS IsltnCertItmUntaggingCondition,
  untyp AS IsltnCertItmUntaggingType,
  tgstat AS StatusCode,
  phblflg AS IsltnCertItmPhysBlkIsRqd,
  phbltyp AS IsltnCertItmPhysicalBlockType,
  phblnr AS IsltnCertItemLockNumber,
  tgflg AS IsltnCertItemTagIsRequired,
  tgnr AS IsolationCertificateItemTag,
  tgform AS IsltnCertItemTagPrintFormat,
  unnr AS IsltnCertItmTestTag,
  crname AS CreatedByUserName,
  crdate AS CreationDate,
  crtime AS CreationTime,
  chname AS LastChangedByUserName,
  chdate AS LastChangeDate,
  chtime AS LastChangeTime,
  actstep AS IsltnCertItmCurOplStep,
  actproc AS IsltnCertItmCurOplCondition,
  acttyp AS IsltnCertItmCurOplType
FROM wcaci
;

Learn More