R_IsltnCertApprvlHistoryDraft

DDL: R_ISLTNCERTAPPRVLHISTORYDRAFT Type: view_entity BASIC
29 Fields 1 Data Sources

Isltn Cert Approval History - Draft

R_IsltnCertApprvlHistoryDraft is a Basic CDS View that provides data about "Isltn Cert Approval History - Draft" in SAP S/4HANA. It reads from 1 data source (isltnapprh_d) and exposes 29 fields with key fields IsolationCertificateInternalID, NmbrOfApprvlInIsltnCertValue, NrOfApprvlInIsltnCertificate, DraftUUID.

Data Sources (1)

SourceAliasJoin Type
isltnapprh_d isltnapprh_d from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Isltn Cert Approval History - Draft 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
Metadata.ignorePropagatedAnnotations true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY IsolationCertificateInternalID isolationcertificateinternalid Object number
KEY NmbrOfApprvlInIsltnCertValue nmbrofapprvlinisltncertvalue Counter
KEY NrOfApprvlInIsltnCertificate nrofapprvlinisltncertificate Counter
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
IsolationCertificate isolationcertificate WC Document
IsltnCertApprovalEnteredByUser isltncertapprovalenteredbyuser Entered by
ApprovalDateTime approvaldatetime Time Stamp
IsltnCertApprovalComment isltncertapprovalcomment Approval Comment
IsltnCertApprovalRevokedByUser isltncertapprovalrevokedbyuser Deactivated by
IsltnCertRevokeDateTime isltncertrevokedatetime Time Stamp
TextObjectKey textobjectkey Text Name
IsltnCertRevokeLongTextKey isltncertrevokelongtextkey Text Name
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
PlainLongText plainlongtext Long Text
IsltnCertRevokeLongText isltncertrevokelongtext Long Text
IsltnCertApprvlSgmtIsInactive isltncertapprvlsgmtisinactive Permit inactive
IsltnCertApprvlDactvtnTime isltncertapprvldactvtntime Deactivated at
IsltnCertApprovedFromDate isltncertapprovedfromdate App.fr date
IsltnCertApprovalEntryTime isltncertapprovalentrytime Entered At
IsltnCertApprovedFromTime isltncertapprovedfromtime Entered At
IsltnCertApprovedToDate isltncertapprovedtodate App.to date
IsltnCertApprvlDactvtnDate isltncertapprvldactvtndate Deactivated on
IsltnCertApprovedToTime isltncertapprovedtotime AppToTime
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_IsltnCertApprvlHistoryDraft.
-- 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_IsltnCertApprvlHistoryDraft AS
SELECT
  IsolationCertificateInternalID,
  NmbrOfApprvlInIsltnCertValue,
  NrOfApprvlInIsltnCertificate,
  DraftUUID,
  ParentDraftUUID,
  IsolationCertificate,
  IsltnCertApprovalEnteredByUser,
  ApprovalDateTime,
  IsltnCertApprovalComment,
  IsltnCertApprovalRevokedByUser,
  IsltnCertRevokeDateTime,
  TextObjectKey,
  IsltnCertRevokeLongTextKey,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  PlainLongText,
  IsltnCertRevokeLongText,
  IsltnCertApprvlSgmtIsInactive,
  IsltnCertApprvlDactvtnTime,
  IsltnCertApprovedFromDate,
  IsltnCertApprovalEntryTime,
  IsltnCertApprovedFromTime,
  IsltnCertApprovedToDate,
  IsltnCertApprvlDactvtnDate,
  IsltnCertApprovedToTime,
  HasActiveEntity,
  DraftFieldChanges
FROM isltnapprh_d
;

Learn More