I_WrkPmtSftyCertApproval

DDL: I_WRKPMTSFTYCERTAPPROVAL SQL: IWPSCAPPRVL Type: view COMPOSITE
22 Fields 2 Data Sources

Wrk Pmt Sfty Cert Approval

I_WrkPmtSftyCertApproval is a Composite CDS View that provides data about "Wrk Pmt Sfty Cert Approval" in SAP S/4HANA. It reads from 2 data sources (I_WorkPermitSafetyCertificate, I_SafetyCertificateApproval) and exposes 22 fields with key fields SafetyCertificateInternalID, NumberOfSftyCertApprovals, WorkPermitInternalID.

Data Sources (2)

SourceAliasJoin Type
I_WorkPermitSafetyCertificate _WorkPermitSafetyCertificate inner
I_SafetyCertificateApproval I_SafetyCertificateApproval from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IWPSCAPPRVL view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Wrk Pmt Sfty Cert Approval view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY SafetyCertificateInternalID I_SafetyCertificateApproval SafetyCertificateInternalID Object number
KEY NumberOfSftyCertApprovals I_SafetyCertificateApproval NumberOfSftyCertApprovals Counter
KEY WorkPermitInternalID I_WorkPermitSafetyCertificate WorkPermitInternalID Object number
SafetyCertificate I_SafetyCertificateApproval SafetyCertificate WC Document
SftyCertDesc I_WorkPermitSafetyCertificate SftyCertDesc Short Text
SafetyCertificateApprovalCode I_SafetyCertificateApproval SafetyCertificateApprovalCode Permit
SftyCertHasLongText I_SafetyCertificateApproval SftyCertHasLongText Long Text
CreationDate I_SafetyCertificateApproval CreationDate Time Stamp
CreatedByUser I_SafetyCertificateApproval CreatedByUser User Name
LastChangedDate I_SafetyCertificateApproval LastChangedDate Created On
LastChangedByUser I_SafetyCertificateApproval LastChangedByUser User Name
SftyCertificateApprovalStatus I_SafetyCertificateApproval SftyCertificateApprovalStatus Approval Status
SftyCertApprovalDescription I_SafetyCertificateApproval SftyCertApprovalDescription Permit Text
MaintenancePlanningPlant I_SafetyCertificateApproval MaintenancePlanningPlant Planning Plant
SafetyCertificateType I_SafetyCertificateApproval SafetyCertificateType Usage
SftyCertificateTypeDescription _SafetyCertificateType SftyCertificateTypeDescription Sfty Cert Type Desc
SftyCertificateApprovalComment I_SafetyCertificateApproval SftyCertificateApprovalComment Approval Comment
TextObjectKey I_SafetyCertificateApproval TextObjectKey Text Name
SftyCertApprvlIsProcRelevant I_SafetyCertificateApproval SftyCertApprvlIsProcRelevant Proc Relvncy Ind
WorkPermit I_WorkPermitSafetyCertificate WorkPermit Application
DomainText I_SafetyCertificateApproval DomainText Short Description
_ApprovalDetails I_SafetyCertificateApproval _ApprovalDetails

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 I_WrkPmtSftyCertApproval.
-- 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.
-- SQL view name: IWPSCAPPRVL

CREATE VIEW I_WrkPmtSftyCertApproval AS
SELECT
  I_SafetyCertificateApproval.SafetyCertificateInternalID AS SafetyCertificateInternalID,
  I_SafetyCertificateApproval.NumberOfSftyCertApprovals AS NumberOfSftyCertApprovals,
  _WorkPermitSafetyCertificate.WorkPermitInternalID AS WorkPermitInternalID,
  I_SafetyCertificateApproval.SafetyCertificate AS SafetyCertificate,
  _WorkPermitSafetyCertificate.SftyCertDesc AS SftyCertDesc,
  I_SafetyCertificateApproval.SafetyCertificateApprovalCode AS SafetyCertificateApprovalCode,
  I_SafetyCertificateApproval.SftyCertHasLongText AS SftyCertHasLongText,
  I_SafetyCertificateApproval.CreationDate AS CreationDate,
  I_SafetyCertificateApproval.CreatedByUser AS CreatedByUser,
  I_SafetyCertificateApproval.LastChangedDate AS LastChangedDate,
  I_SafetyCertificateApproval.LastChangedByUser AS LastChangedByUser,
  I_SafetyCertificateApproval.SftyCertificateApprovalStatus AS SftyCertificateApprovalStatus,
  I_SafetyCertificateApproval.SftyCertApprovalDescription AS SftyCertApprovalDescription,
  I_SafetyCertificateApproval.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_SafetyCertificateApproval.SafetyCertificateType AS SafetyCertificateType,
  _SafetyCertificateType.SftyCertificateTypeDescription AS SftyCertificateTypeDescription,
  I_SafetyCertificateApproval.SftyCertificateApprovalComment AS SftyCertificateApprovalComment,
  I_SafetyCertificateApproval.TextObjectKey AS TextObjectKey,
  I_SafetyCertificateApproval.SftyCertApprvlIsProcRelevant AS SftyCertApprvlIsProcRelevant,
  _WorkPermitSafetyCertificate.WorkPermit AS WorkPermit,
  I_SafetyCertificateApproval.DomainText AS DomainText,
  I_SafetyCertificateApproval._ApprovalDetails AS _ApprovalDetails
FROM I_SafetyCertificateApproval
INNER JOIN I_WorkPermitSafetyCertificate AS _WorkPermitSafetyCertificate ON /* join condition not captured in parsed metadata */
;

Learn More