R_IsltnCertTemplateItemDraft

DDL: R_ISLTNCERTTEMPLATEITEMDRAFT Type: view_entity BASIC
62 Fields 1 Data Sources

Isolation Cert Template Item - Draft

R_IsltnCertTemplateItemDraft is a Basic CDS View that provides data about "Isolation Cert Template Item - Draft" in SAP S/4HANA. It reads from 1 data source (isltntitems_d) and exposes 62 fields with key fields IsolationCertificateTemplate, IsolationCertificateItem, DraftUUID.

Data Sources (1)

SourceAliasJoin Type
isltntitems_d isltntitems_d from

Annotations (8)

NameValueLevelField
EndUserText.label Isolation Cert Template Item - Draft view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #MANDATORY view

Fields (62)

KeyFieldSource TableSource FieldDescription
KEY IsolationCertificateTemplate isolationcertificatetemplate WC Document
KEY IsolationCertificateItem isolationcertificateitem Item
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
SAPObjectNodeType sapobjectnodetype SONT Name
IsolationCertItemInternalID isolationcertiteminternalid Object number
IsltnCertItmCategory isltncertitmcategory Item Category
IsolationCertificateType isolationcertificatetype Usage
IsltnCertItemSequenceNumber isltncertitemsequencenumber Item
FunctionalLocation functionallocation Object ID
TechnicalObjectDescription technicalobjectdescription Tech. Obj. Desc
TechnicalObjectLabel technicalobjectlabel Tech. Object
TechnicalObject technicalobject Technical Object
MaintenancePlanningPlant maintenanceplanningplant Planning Plant
IsltnCertItmCatType isltncertitmcattype Item Category
IsltnCertItemDescription isltncertitemdescription Switching Loc.
IsltnCertItemOperationalGroup isltncertitemoperationalgroup Op. Group
IsltnCertItmTaggingCondition isltncertitmtaggingcondition Tagging Cond.
IsltnCertItemTaggingStep isltncertitemtaggingstep Tagging Step
IsltnCertItmTaggingType isltncertitmtaggingtype Tagging Type
IsltnCertItmTaggingSequence isltncertitmtaggingsequence Tag. Sequence
IsltnCertItmTaggingComment isltncertitmtaggingcomment Tagging Comment
IsltnCertItmTagConditionText isltncertitmtagconditiontext Txt f. Op.Cond.
IsltnCertItmTagTypeText isltncertitmtagtypetext Text f. Op.Type
IsltnCertItmUntaggingCondition isltncertitmuntaggingcondition Untag.Cond.
IsltnCertItmUntaggingType isltncertitmuntaggingtype Untagging Type
IsltnCertItmUntaggingStep isltncertitmuntaggingstep Untagging Step
IsltnCertItmUntaggingSequence isltncertitmuntaggingsequence Unt. Sequence
IsltnCertItmUntaggingComment isltncertitmuntaggingcomment Untag. Comment
IsltnCertItmUntagConditionText isltncertitmuntagconditiontext Txt f. Op.Cond.
IsltnCertItmUntagTypeText isltncertitmuntagtypetext Text f. Op.Type
IsltnCertItmPhysBlkIsRqd isltncertitmphysblkisrqd Phys. Blocking
IsltnCertItmPhysicalBlockType isltncertitmphysicalblocktype Blocking Type
IsltnCertItmPhysBlockTypeText isltncertitmphysblocktypetext Txt f. Blkg Ty.
IsltnCertItemTagIsRequired isltncertitemtagisrequired Tag Required
IsltnCertItemTagPrintFormat isltncertitemtagprintformat Print Format
IsolationCertificateItemTag isolationcertificateitemtag Tag
IsltnCertItmTestTag isltncertitmtesttag Test Tag
IsltnCertItmTestTagPrintFormat isltncertitmtesttagprintformat Print Format
IsltnCertItmSwitchingLocation isltncertitmswitchinglocation Switching Loc.
IsltnCertItmLocation isltncertitmlocation Location
IsltnCertItmPersonResponsible isltncertitmpersonresponsible WorkForce Assgmt ID
EmailAddress emailaddress E-Mail Address
MobilePhoneNumber mobilephonenumber Telephone
PersonFullName personfullname Full Name
IsltnCertItmAdditionalComment isltncertitmadditionalcomment
IsltnCertItmIsTestingRequired isltncertitmistestingrequired Boolean Variable (X = True, - = False, Space = Unknown)
IsltnCertItemLockNumber isltncertitemlocknumber Lock
IsltnCertItmHasLongText isltncertitmhaslongtext Long Text
IsltnCertItmProcessingStatus isltncertitmprocessingstatus
IsltnCertItmProcgStatusText isltncertitmprocgstatustext Short Description
TechObjIsEquipOrFuncnlLoc techobjisequiporfuncnlloc Tech. Obj. Type
IsltnCertItemOplGroupText isltncertitemoplgrouptext Text Op. Group
IsltnCertItemLongText isltncertitemlongtext Long Text
IsltnCertItmCatTypeText isltncertitmcattypetext Short Description
IsltnCertThumbnailURL isltncertthumbnailurl Message Text
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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 R_IsltnCertTemplateItemDraft.
-- 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 R_IsltnCertTemplateItemDraft AS
SELECT
  IsolationCertificateTemplate,
  IsolationCertificateItem,
  DraftUUID,
  ParentDraftUUID,
  SAPObjectNodeType,
  IsolationCertItemInternalID,
  IsltnCertItmCategory,
  IsolationCertificateType,
  IsltnCertItemSequenceNumber,
  FunctionalLocation,
  TechnicalObjectDescription,
  TechnicalObjectLabel,
  TechnicalObject,
  MaintenancePlanningPlant,
  IsltnCertItmCatType,
  IsltnCertItemDescription,
  IsltnCertItemOperationalGroup,
  IsltnCertItmTaggingCondition,
  IsltnCertItemTaggingStep,
  IsltnCertItmTaggingType,
  IsltnCertItmTaggingSequence,
  IsltnCertItmTaggingComment,
  IsltnCertItmTagConditionText,
  IsltnCertItmTagTypeText,
  IsltnCertItmUntaggingCondition,
  IsltnCertItmUntaggingType,
  IsltnCertItmUntaggingStep,
  IsltnCertItmUntaggingSequence,
  IsltnCertItmUntaggingComment,
  IsltnCertItmUntagConditionText,
  IsltnCertItmUntagTypeText,
  IsltnCertItmPhysBlkIsRqd,
  IsltnCertItmPhysicalBlockType,
  IsltnCertItmPhysBlockTypeText,
  IsltnCertItemTagIsRequired,
  IsltnCertItemTagPrintFormat,
  IsolationCertificateItemTag,
  IsltnCertItmTestTag,
  IsltnCertItmTestTagPrintFormat,
  IsltnCertItmSwitchingLocation,
  IsltnCertItmLocation,
  IsltnCertItmPersonResponsible,
  EmailAddress,
  MobilePhoneNumber,
  PersonFullName,
  IsltnCertItmAdditionalComment,
  IsltnCertItmIsTestingRequired,
  IsltnCertItemLockNumber,
  IsltnCertItmHasLongText,
  IsltnCertItmProcessingStatus,
  IsltnCertItmProcgStatusText,
  TechObjIsEquipOrFuncnlLoc,
  IsltnCertItemOplGroupText,
  IsltnCertItemLongText,
  IsltnCertItmCatTypeText,
  IsltnCertThumbnailURL,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM isltntitems_d
;

Learn More