I_IsolationCertificateItemTP

DDL: I_ISOLATIONCERTIFICATEITEMTP Type: view_entity TRANSACTIONAL
55 Fields 1 Data Sources

Interface for Isolation Cert Item - TP

I_IsolationCertificateItemTP is a Transactional CDS View that provides data about "Interface for Isolation Cert Item - TP" in SAP S/4HANA. It reads from 1 data source (R_IsolationCertificateItemTP) and exposes 55 fields with key fields IsolationCertificate, IsolationCertificateItem.

Data Sources (1)

SourceAliasJoin Type
R_IsolationCertificateItemTP R_IsolationCertificateItemTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Interface for Isolation Cert Item - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY IsolationCertificate IsolationCertificate WC Document
KEY IsolationCertificateItem IsolationCertificateItem Item
OutputControlApplicationObject OutputControlApplicationObject Appl. Object ID
OutputControlApplObjectType OutputControlApplObjectType Appl. Object Type
SAPObjectNodeType SAPObjectNodeType SONT Name
IsolationCertItemInternalID IsolationCertItemInternalID Object number
IsltnCertItmCategory IsltnCertItmCategory Item Category
IsolationCertificateType IsolationCertificateType Usage
IsltnCertItemSequenceNumber IsltnCertItemSequenceNumber Item
TechnicalObject TechnicalObject Technical Object
TechnicalObjectLabel TechnicalObjectLabel Tech. Object
TechnicalObjectDescription TechnicalObjectDescription Tech. Obj. Desc
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
IsltnCertItmCatType IsltnCertItmCatType Item Category
IsltnCertItemDescription IsltnCertItemDescription Switching Loc.
IsltnCertItemOperationalGroup IsltnCertItemOperationalGroup Op. Group
IsltnCertItemOplGroupText IsltnCertItemOplGroupText Text Op. Group
IsltnCertItemTaggingStep IsltnCertItemTaggingStep Tagging Step
IsltnCertItmTaggingCondition IsltnCertItmTaggingCondition Tagging Cond.
IsltnCertItmTaggingType IsltnCertItmTaggingType Tagging Type
IsltnCertItmTagConditionText IsltnCertItmTagConditionText Txt f. Op.Cond.
IsltnCertItmTagTypeText IsltnCertItmTagTypeText Text f. Op.Type
IsltnCertItmTaggingSequence IsltnCertItmTaggingSequence Tag. Sequence
IsltnCertItmTaggingComment IsltnCertItmTaggingComment Tagging Comment
IsltnCertItemLockNumber IsltnCertItemLockNumber Lock
IsltnCertItmUntaggingStep IsltnCertItmUntaggingStep Untagging Step
IsltnCertItmUntaggingCondition IsltnCertItmUntaggingCondition Untag.Cond.
IsltnCertItmUntaggingType IsltnCertItmUntaggingType Untagging Type
IsltnCertItmUntagConditionText IsltnCertItmUntagConditionText Txt f. Op.Cond.
IsltnCertItmUntagTypeText IsltnCertItmUntagTypeText Text f. Op.Type
IsltnCertItmUntaggingSequence IsltnCertItmUntaggingSequence Unt. Sequence
IsltnCertItmUntaggingComment IsltnCertItmUntaggingComment Untag. Comment
IsltnCertItemTagIsRequired IsltnCertItemTagIsRequired Tag Required
IsltnCertItemTagPrintFormat IsltnCertItemTagPrintFormat Print Format
IsolationCertificateItemTag IsolationCertificateItemTag Tag
IsltnCertItmTestTagPrintFormat IsltnCertItmTestTagPrintFormat Print Format
IsltnCertItmTestTag IsltnCertItmTestTag Test Tag
IsltnCertItmCatTypeText IsltnCertItmCatTypeText Short Description
IsltnCertItmPhysBlkIsRqd IsltnCertItmPhysBlkIsRqd Phys. Blocking
IsltnCertItmPhysicalBlockType IsltnCertItmPhysicalBlockType Blocking Type
IsltnCertItmPhysBlockTypeText IsltnCertItmPhysBlockTypeText Txt f. Blkg Ty.
IsltnCertItmSwitchingLocation IsltnCertItmSwitchingLocation Switching Loc.
IsltnCertItmLocation IsltnCertItmLocation Location
IsltnCertItmHasLongText IsltnCertItmHasLongText Long Text
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
IsltnCertItemLongText IsltnCertItemLongText Long Text
IsltnCertItmProcessingStatus IsltnCertItmProcessingStatus
IsltnCertItmProcgStatusText IsltnCertItmProcgStatusText Short Description
IsltnCertItmPersonResponsible IsltnCertItmPersonResponsible WorkForce Assgmt ID
EmailAddress EmailAddress E-Mail Address
MobilePhoneNumber MobilePhoneNumber Telephone
PersonFullName PersonFullName Full Name
IsltnCertItmIsTestingRequired IsltnCertItmIsTestingRequired Boolean Variable (X = True, - = False, Space = Unknown)
IsltnCertItmAdditionalComment IsltnCertItmAdditionalComment
IsltnCertThumbnailURL IsltnCertThumbnailURL Message Text

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_IsolationCertificateItemTP.
-- 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_IsolationCertificateItemTP AS
SELECT
  IsolationCertificate,
  IsolationCertificateItem,
  OutputControlApplicationObject,
  OutputControlApplObjectType,
  SAPObjectNodeType,
  IsolationCertItemInternalID,
  IsltnCertItmCategory,
  IsolationCertificateType,
  IsltnCertItemSequenceNumber,
  TechnicalObject,
  TechnicalObjectLabel,
  TechnicalObjectDescription,
  MaintenancePlanningPlant,
  IsltnCertItmCatType,
  IsltnCertItemDescription,
  IsltnCertItemOperationalGroup,
  IsltnCertItemOplGroupText,
  IsltnCertItemTaggingStep,
  IsltnCertItmTaggingCondition,
  IsltnCertItmTaggingType,
  IsltnCertItmTagConditionText,
  IsltnCertItmTagTypeText,
  IsltnCertItmTaggingSequence,
  IsltnCertItmTaggingComment,
  IsltnCertItemLockNumber,
  IsltnCertItmUntaggingStep,
  IsltnCertItmUntaggingCondition,
  IsltnCertItmUntaggingType,
  IsltnCertItmUntagConditionText,
  IsltnCertItmUntagTypeText,
  IsltnCertItmUntaggingSequence,
  IsltnCertItmUntaggingComment,
  IsltnCertItemTagIsRequired,
  IsltnCertItemTagPrintFormat,
  IsolationCertificateItemTag,
  IsltnCertItmTestTagPrintFormat,
  IsltnCertItmTestTag,
  IsltnCertItmCatTypeText,
  IsltnCertItmPhysBlkIsRqd,
  IsltnCertItmPhysicalBlockType,
  IsltnCertItmPhysBlockTypeText,
  IsltnCertItmSwitchingLocation,
  IsltnCertItmLocation,
  IsltnCertItmHasLongText,
  TechObjIsEquipOrFuncnlLoc,
  IsltnCertItemLongText,
  IsltnCertItmProcessingStatus,
  IsltnCertItmProcgStatusText,
  IsltnCertItmPersonResponsible,
  EmailAddress,
  MobilePhoneNumber,
  PersonFullName,
  IsltnCertItmIsTestingRequired,
  IsltnCertItmAdditionalComment,
  IsltnCertThumbnailURL
FROM R_IsolationCertificateItemTP
;

Learn More