A_SftyCertApprovalHistory

DDL: A_SFTYCERTAPPROVALHISTORY Type: view_entity CONSUMPTION
24 Fields 1 Data Sources

Approval History in Safety Certificate

A_SftyCertApprovalHistory is a Consumption CDS View that provides data about "Approval History in Safety Certificate" in SAP S/4HANA. It reads from 1 data source (R_SftyCertApprovalSegmentTP) and exposes 24 fields with key fields SafetyCertificateInternalID, SftyCertApprovalSegmentValue, NumberOfSftyCertApprovals.

Data Sources (1)

SourceAliasJoin Type
R_SftyCertApprovalSegmentTP R_SftyCertApprovalSegmentTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Approval History in Safety Certificate view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name SftyCertApprHistory_Type view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY SafetyCertificateInternalID SafetyCertificateInternalID Object number
KEY SftyCertApprovalSegmentValue SftyCertApprovalSegmentValue Counter
KEY NumberOfSftyCertApprovals NumberOfSftyCertApprovals Counter
SafetyCertificateApprovalCode SafetyCertificateApprovalCode Permit
SafetyCertificate SafetyCertificate WC Document
SftyCertApprovalEnteredByUser SftyCertApprovalEnteredByUser Entered by
SftyCertApprovalEntryDate SftyCertApprovalEntryDate Created on
SftyCertApprovalEntryTime SftyCertApprovalEntryTime Entered At
ApprovalDateTime ApprovalDateTime Time Stamp
SftyCertApprovedFromDate SftyCertApprovedFromDate App.fr date
SftyCertApprovedToDate SftyCertApprovedToDate App.to date
SftyCertApprovedFromTime SftyCertApprovedFromTime Entered At
SftyCertApprovedToTime SftyCertApprovedToTime AppToTime
SftyCertApprovalDactvtdByUsr SftyCertApprovalDactvtdByUsr Deactivated by
SftyCertApprvlDeactivationDate SftyCertApprvlDeactivationDate Deactivated on
SftyCertApprvlDeactivationTime SftyCertApprvlDeactivationTime Deactivated at
SftyCertRevokeDateTime SftyCertRevokeDateTime Time Stamp
SftyCertApprvlSgmtIsInactive SftyCertApprvlSgmtIsInactive Permit inactive
SftyCertificateApprovalComment SftyCertificateApprovalComment Approval Comment
SftyCertApprovalDescription SftyCertApprovalDescription Permit Text
TextObjectKey TextObjectKey Text Name
SftyCertRevokeLongTextKey SftyCertRevokeLongTextKey Text Name
PlainLongText PlainLongText Long Text
SftyCertRevokeLongText SftyCertRevokeLongText Long 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 A_SftyCertApprovalHistory.
-- 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 A_SftyCertApprovalHistory AS
SELECT
  SafetyCertificateInternalID,
  SftyCertApprovalSegmentValue,
  NumberOfSftyCertApprovals,
  SafetyCertificateApprovalCode,
  SafetyCertificate,
  SftyCertApprovalEnteredByUser,
  SftyCertApprovalEntryDate,
  SftyCertApprovalEntryTime,
  ApprovalDateTime,
  SftyCertApprovedFromDate,
  SftyCertApprovedToDate,
  SftyCertApprovedFromTime,
  SftyCertApprovedToTime,
  SftyCertApprovalDactvtdByUsr,
  SftyCertApprvlDeactivationDate,
  SftyCertApprvlDeactivationTime,
  SftyCertRevokeDateTime,
  SftyCertApprvlSgmtIsInactive,
  SftyCertificateApprovalComment,
  SftyCertApprovalDescription,
  TextObjectKey,
  SftyCertRevokeLongTextKey,
  PlainLongText,
  SftyCertRevokeLongText
FROM R_SftyCertApprovalSegmentTP
;

Learn More