R_SafetyCertificateDraft

DDL: R_SAFETYCERTIFICATEDRAFT Type: view_entity BASIC
77 Fields 1 Data Sources 1 Associations

Safety Certificate Draft

R_SafetyCertificateDraft is a Basic CDS View that provides data about "Safety Certificate Draft" in SAP S/4HANA. It reads from 1 data source (safetycert_d) and exposes 77 fields with key fields SafetyCertificate, DraftUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
safetycert_d safetycert_d from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_SafetyCertificateDraft _SafetyCertDExtension $projection.SafetyCertificate = _SafetyCertDExtension.SafetyCertificate and $projection.DraftUUID = _SafetyCertDExtension.DraftUUID

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Safety Certificate Draft view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix SFT view
AbapCatalog.extensibility.quota.maximumFields 250 view
AbapCatalog.extensibility.quota.maximumBytes 5000 view

Fields (77)

KeyFieldSource TableSource FieldDescription
KEY SafetyCertificate safetycertificate WC Document
KEY DraftUUID draftuuid UUID
SafetyCertificateInternalID safetycertificateinternalid Object number
SftyCertificateSubobjectType sftycertificatesubobjecttype Object Type
SftyCertExternalNumber sftycertexternalnumber WC Document
SafetyCertificateType safetycertificatetype Usage
SftyCertDesc sftycertdesc Short Text
WorkPermitReferenceWorkPermit workpermitreferenceworkpermit Application
SftyCertHasLongText sftycerthaslongtext Long Text
LongTextKey longtextkey Text Name
SftyCertIsDeleted sftycertisdeleted Delete
MaintenancePlannerGroup maintenanceplannergroup Planner Group
MaintenancePlanningPlant maintenanceplanningplant Planning Plant
SftyCertReferenceObjectType sftycertreferenceobjecttype Create with Referenc
ObjectTypeCode objecttypecode Object Type
OperationWorkCenterInternalID operationworkcenterinternalid Object ID
TechObjAuthorizationGroup techobjauthorizationgroup AuthorizGroup
SftyCertValidFrmDate sftycertvalidfrmdate Valid from
SftyCertValidFrmTime sftycertvalidfrmtime ValidFrm Time
SftyCertValidToDate sftycertvalidtodate Valid to
SftyCertValidToTime sftycertvalidtotime 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
SftyCertRefSftyCertTemplate sftycertrefsftycerttemplate WC Document
MaintenancePlant maintenanceplant Plant
PlantName plantname Plant Name
PlantSection plantsection Plant Section
AssetLocation assetlocation Location
AssetRoom assetroom Room
LocationName locationname Location Name
PlantSectionDesc plantsectiondesc
MaintenancePlantName maintenanceplantname Plant Name
SftyCertHasObjectList sftycerthasobjectlist Obj.List Exists
CreatedByUserName createdbyusername Person Resp.
CreatedByUser createdbyuser User Name
CreationDate creationdate Time Stamp
CreationTime creationtime Time of Change
CreationDateTime creationdatetime Timestamp
ValidFromDateTime validfromdatetime Time Stamp
ValidToDateTime validtodatetime Time Stamp
LastChangedByUserName lastchangedbyusername User Name
LastChangedByUser lastchangedbyuser User Name
MaintenancePlanningPlantName maintenanceplanningplantname Plant Name
MaintenancePlannerGroupName maintenanceplannergroupname Planner Group Name
SftyCertificateTypeDescription sftycertificatetypedescription Sfty Cert Type Desc
LastChangeDate lastchangedate Time Stamp
LastChangeTime lastchangetime Time changed
LastChangeDateTime lastchangedatetime Timestamp
WorkCenter workcenter Work Center
WorkCenterText workcentertext Work Center Text
SftyCertCnctntdActvSystStsTxt sftycertcnctntdactvsystststxt Concatenated System Status
WorkCenterPlant workcenterplant Plant
MainWorkCenterPlantName mainworkcenterplantname Plant Name
SftyCertIsLinkdToDoc sftycertislinkdtodoc Document Link
StatusProfile statusprofile Status Profile
IsAttachmentsEnabled isattachmentsenabled Originals
SafetyCertificateTmplID safetycertificatetmplid Template
SftyCertHasMaintRemark sftycerthasmaintremark Remarks Mt
SftyCertHasOpRemark sftycerthasopremark Remarks Op
SftyCertProcessingStatus sftycertprocessingstatus Proc Stat Sfty Cert
SftyCertProcessingStatusText sftycertprocessingstatustext Short Description
SafetyCertificateLongText safetycertificatelongtext Long Text
SftyCertCancellationText sftycertcancellationtext Long Text
IsApproved isapproved Checkbox
PrintIsReal printisreal
SftyCertChgStsActnEnbldVal sftycertchgstsactnenbldval
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_SafetyCertificateDraft.
-- 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_SafetyCertificateDraft AS
SELECT
  SafetyCertificate,
  DraftUUID,
  SafetyCertificateInternalID,
  SftyCertificateSubobjectType,
  SftyCertExternalNumber,
  SafetyCertificateType,
  SftyCertDesc,
  WorkPermitReferenceWorkPermit,
  SftyCertHasLongText,
  LongTextKey,
  SftyCertIsDeleted,
  MaintenancePlannerGroup,
  MaintenancePlanningPlant,
  SftyCertReferenceObjectType,
  ObjectTypeCode,
  OperationWorkCenterInternalID,
  TechObjAuthorizationGroup,
  SftyCertValidFrmDate,
  SftyCertValidFrmTime,
  SftyCertValidToDate,
  SftyCertValidToTime,
  FunctionalLocation,
  Equipment,
  FunctionalLocationLabelName,
  TechObjIsEquipOrFuncnlLoc,
  TechnicalObject,
  TechnicalObjectLabel,
  TechnicalObjectDescription,
  SftyCertRefSftyCertTemplate,
  MaintenancePlant,
  PlantName,
  PlantSection,
  AssetLocation,
  AssetRoom,
  LocationName,
  PlantSectionDesc,
  MaintenancePlantName,
  SftyCertHasObjectList,
  CreatedByUserName,
  CreatedByUser,
  CreationDate,
  CreationTime,
  CreationDateTime,
  ValidFromDateTime,
  ValidToDateTime,
  LastChangedByUserName,
  LastChangedByUser,
  MaintenancePlanningPlantName,
  MaintenancePlannerGroupName,
  SftyCertificateTypeDescription,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime,
  WorkCenter,
  WorkCenterText,
  SftyCertCnctntdActvSystStsTxt,
  WorkCenterPlant,
  MainWorkCenterPlantName,
  SftyCertIsLinkdToDoc,
  StatusProfile,
  IsAttachmentsEnabled,
  SafetyCertificateTmplID,
  SftyCertHasMaintRemark,
  SftyCertHasOpRemark,
  SftyCertProcessingStatus,
  SftyCertProcessingStatusText,
  SafetyCertificateLongText,
  SftyCertCancellationText,
  IsApproved,
  PrintIsReal,
  SftyCertChgStsActnEnbldVal,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM safetycert_d
LEFT OUTER JOIN E_SafetyCertificateDraft AS _SafetyCertDExtension ON SafetyCertificate = _SafetyCertDExtension.SafetyCertificate AND DraftUUID = _SafetyCertDExtension.DraftUUID  -- association [0..1]
;

Learn More