I_SftyCertificateApprovalBasic

DDL: I_SFTYCERTIFICATEAPPROVALBASIC Type: view_entity BASIC Package: VDM_EAM_WCM_SAFETY_CERTIFICATE
10 Fields 1 Data Sources 2 Associations

Maintain Approvals for Safety Cert

I_SftyCertificateApprovalBasic is a Basic CDS View that provides data about "Maintain Approvals for Safety Cert" in SAP S/4HANA. It reads from 1 data source (ptwsftycertapprv) and exposes 10 fields with key fields MaintenancePlanningPlant, SafetyCertificateType, SafetyCertificateApprovalCode, SftyCertApprovalScenario. It has 2 associations to related views. Part of development package VDM_EAM_WCM_SAFETY_CERTIFICATE.

Data Sources (1)

SourceAliasJoin Type
ptwsftycertapprv Approval from

Associations (2)

CardinalityTargetAliasCondition
[0..1] t357g _SftyCert $projection.SafetyCertificateApprovalCode = _SftyCert.sogen
[0..1] t357g_t _SftyCertTxt $projection.SafetyCertificateApprovalCode = _SftyCertTxt.pmsog and _SftyCertTxt.spras = $session.system_language

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Maintain Approvals for Safety Cert view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlanningPlant iwerk Planning Plant
KEY SafetyCertificateType safetycertificatetype Usage
KEY SafetyCertificateApprovalCode sogen Approval Type
KEY SftyCertApprovalScenario scenario VAT Scenario
SftyCertApprvlHierLevelValue hierarchylevel Hierarchy Level
SftyCertApprvlCopyIsAutomatic sftycertapprvlcopyisautomatic Copy Apprv Auto
SftyCertApprovalIsMandatory sftycertapprovalismandatory App. Mandatory
SftyCertApprovalDescription _SftyCertTxt gntxt
char10asSftyCertApprvlMandText
SftyCertApprvlIsProcRelevant sftycertapprvlisprocessrelvind Proc Relvncy Ind

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_SftyCertificateApprovalBasic.
-- 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 I_SftyCertificateApprovalBasic AS
SELECT
  iwerk AS MaintenancePlanningPlant,
  SafetyCertificateType,
  sogen AS SafetyCertificateApprovalCode,
  scenario AS SftyCertApprovalScenario,
  hierarchylevel AS SftyCertApprvlHierLevelValue,
  SftyCertApprvlCopyIsAutomatic,
  SftyCertApprovalIsMandatory,
  _SftyCertTxt.gntxt AS SftyCertApprovalDescription,
  cast( case when sftycertapprovalismandatory = 'X' then 'Mandatory' else 'Optional' end as abap.char(10) ) as SftyCertApprvlMandText AS char10asSftyCertApprvlMandText,
  sftycertapprvlisprocessrelvind AS SftyCertApprvlIsProcRelevant
FROM ptwsftycertapprv AS Approval
LEFT OUTER JOIN t357g AS _SftyCert ON SafetyCertificateApprovalCode = _SftyCert.sogen  -- association [0..1]
LEFT OUTER JOIN t357g_t AS _SftyCertTxt ON SafetyCertificateApprovalCode = _SftyCertTxt.pmsog AND _SftyCertTxt.spras = $session.system_language  -- association [0..1]
;

Learn More