What is R_IsolationCertificateDraft in SAP S/4HANA?

R_IsolationCertificateDraft is a basic CDS view in SAP S/4HANA. Isolation Certificate - Draft It contains 74 fields.

Which tables does R_IsolationCertificateDraft read from?

R_IsolationCertificateDraft reads data from: isltncert_d.

What VDM layer is R_IsolationCertificateDraft?

R_IsolationCertificateDraft is classified as a Basic (interface) view providing a 1:1 representation of a database table.

R_IsolationCertificateDraft

DDL: R_ISOLATIONCERTIFICATEDRAFT Type: view_entity BASIC

74 Fields 1 Data Sources

Isolation Certificate - Draft

R_IsolationCertificateDraft is a Basic CDS View that provides data about "Isolation Certificate - Draft" in SAP S/4HANA. It reads from 1 data source (isltncert_d) and exposes 74 fields with key fields IsolationCertificate, DraftUUID.

Data Sources (1)

Source	Alias	Join Type
isltncert_d	isltncert_d	from

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Isolation Certificate - Draft	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MIXED	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (74)

Key	Field	Source Field	Description
KEY	IsolationCertificate	isolationcertificate	WC Document
KEY	DraftUUID	draftuuid	UUID
	SAPObjectNodeType	sapobjectnodetype	SONT Name
	IsolationCertificateInternalID	isolationcertificateinternalid	Object number
	IsltnCertificateSubobjectType	isltncertificatesubobjecttype	Object Type
	IsltnCertExternalNumber	isltncertexternalnumber	WC Document
	IsolationCertificateType	isolationcertificatetype	Usage
	IsltnCertTypeDescription	isltncerttypedescription	Sfty Cert Type Desc
	IsltnCertificateDescription	isltncertificatedescription	Short Text
	LongTextKey	longtextkey	Text Name
	IsltnCertificateIsDeleted	isltncertificateisdeleted	Delete
	MaintenancePlannerGroup	maintenanceplannergroup	Planner Group
	MaintenancePlanningPlant	maintenanceplanningplant	Planning Plant
	ObjectTypeCode	objecttypecode	Object Type
	OperationWorkCenterInternalID	operationworkcenterinternalid	Object ID
	TechObjAuthorizationGroup	techobjauthorizationgroup	AuthorizGroup
	IsltnCertValidFromDate	isltncertvalidfromdate	Valid from
	IsltnCertValidFromTime	isltncertvalidfromtime	ValidFrm Time
	IsltnCertValidToDate	isltncertvalidtodate	Valid to
	IsltnCertValidToTime	isltncertvalidtotime	Valid-To Time
	FunctionalLocation	functionallocation	Object ID
	Equipment	equipment	Equipment check
	FunctionalLocationLabelName	functionallocationlabelname	Functional Loc.
	TechObjIsEquipOrFuncnlLoc	techobjisequiporfuncnlloc	Tech. Obj. Type
	TechnicalObject	technicalobject	Technical Object
	TechnicalObjectLabel	technicalobjectlabel	Tech. Object
	TechnicalObjectDescription	technicalobjectdescription	Tech. Obj. Desc
	WorkPermitReferenceWorkPermit	workpermitreferenceworkpermit	Application
	MaintenancePlant	maintenanceplant	Plant
	PlantName	plantname	Plant Name
	PlantSection	plantsection	Plant Section
	AssetLocation	assetlocation	Location
	AssetRoom	assetroom	Room
	LocationName	locationname	Location Name
	IsolationCertificateLongText	isolationcertificatelongtext	Long Text
	IsltnCertHasLongText	isltncerthaslongtext	Long Text
	PlantSectionDesc	plantsectiondesc
	MaintenancePlantName	maintenanceplantname	Plant Name
	CreatedByUser	createdbyuser	User Name
	CreatedByUserName	createdbyusername	Person Resp.
	CreationDate	creationdate	Time Stamp
	CreationTime	creationtime	Time of Change
	CreationDateTime	creationdatetime	Timestamp
	LastChangedByUserName	lastchangedbyusername	User Name
	LastChangedByUser	lastchangedbyuser	User Name
	LastChangeDate	lastchangedate	Time Stamp
	LastChangeTime	lastchangetime	Time changed
	LastChangeDateTime	lastchangedatetime	Timestamp
	IsolationCertificateTemplate	isolationcertificatetemplate	WC Document
	IsolationCertificateReference	isolationcertificatereference	WC Document
	RefIsltnCertificateTemplate	refisltncertificatetemplate	WC Document
	ReferenceIsolationCertificate	referenceisolationcertificate	WC Document
	RefIsltnCertificateIsHidden	refisltncertificateishidden	Truth Value
	RefIsltnCertTmplIsHidden	refisltncerttmplishidden	Truth Value
	RefIsltnCertSubobjectType	refisltncertsubobjecttype	Object Type
	ValidFromDateTime	validfromdatetime	Time Stamp
	ValidToDateTime	validtodatetime	Time Stamp
	IsltnCertProcessingStatus	isltncertprocessingstatus	Proc Stat Sfty Cert
	IsltnCertProcessingStatusText	isltncertprocessingstatustext	Short Description
	WorkCenter	workcenter	Work Center
	WorkCenterInternalID	workcenterinternalid	Work Center
	WorkCenterPlant	workcenterplant	Plant
	IsApproved	isapproved	Checkbox
	IsltnCertThumbnailURL	isltncertthumbnailurl	Message Text
	IsltnCertItmConflictStsMessage	IsltnCertItmConflictStsMessage
	IsltnCertItmConflictStsCritlty	isltncertitmconflictstscritlty
	IsltnCertCancellationText	isltncertcancellationtext	Long Text
	ReferenceObjectCheckCode	referenceobjectcheckcode
	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_IsolationCertificateDraft.
-- 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_IsolationCertificateDraft AS
SELECT
  IsolationCertificate,
  DraftUUID,
  SAPObjectNodeType,
  IsolationCertificateInternalID,
  IsltnCertificateSubobjectType,
  IsltnCertExternalNumber,
  IsolationCertificateType,
  IsltnCertTypeDescription,
  IsltnCertificateDescription,
  LongTextKey,
  IsltnCertificateIsDeleted,
  MaintenancePlannerGroup,
  MaintenancePlanningPlant,
  ObjectTypeCode,
  OperationWorkCenterInternalID,
  TechObjAuthorizationGroup,
  IsltnCertValidFromDate,
  IsltnCertValidFromTime,
  IsltnCertValidToDate,
  IsltnCertValidToTime,
  FunctionalLocation,
  Equipment,
  FunctionalLocationLabelName,
  TechObjIsEquipOrFuncnlLoc,
  TechnicalObject,
  TechnicalObjectLabel,
  TechnicalObjectDescription,
  WorkPermitReferenceWorkPermit,
  MaintenancePlant,
  PlantName,
  PlantSection,
  AssetLocation,
  AssetRoom,
  LocationName,
  IsolationCertificateLongText,
  IsltnCertHasLongText,
  PlantSectionDesc,
  MaintenancePlantName,
  CreatedByUser,
  CreatedByUserName,
  CreationDate,
  CreationTime,
  CreationDateTime,
  LastChangedByUserName,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime,
  IsolationCertificateTemplate,
  IsolationCertificateReference,
  RefIsltnCertificateTemplate,
  ReferenceIsolationCertificate,
  RefIsltnCertificateIsHidden,
  RefIsltnCertTmplIsHidden,
  RefIsltnCertSubobjectType,
  ValidFromDateTime,
  ValidToDateTime,
  IsltnCertProcessingStatus,
  IsltnCertProcessingStatusText,
  WorkCenter,
  WorkCenterInternalID,
  WorkCenterPlant,
  IsApproved,
  IsltnCertThumbnailURL,
  IsltnCertItmConflictStsMessage,
  IsltnCertItmConflictStsCritlty,
  IsltnCertCancellationText,
  ReferenceObjectCheckCode,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM isltncert_d
;

Depth:

R_IsolationCertificateDraft view_entity

isltncert_d