I_SafetyInstructionDraft

DDL: I_SAFETYINSTRUCTIONDRAFT Type: view BASIC Package: EHHSS_BO_FSI
16 Fields 1 Data Sources

FSI: Interface View - Draft

I_SafetyInstructionDraft is a Basic CDS View that provides data about "FSI: Interface View - Draft" in SAP S/4HANA. It reads from 1 data source (ehhssw_fsi_root) and exposes 16 fields with key field SafetyInstructionUUID. Part of development package EHHSS_BO_FSI.

Data Sources (1)

SourceAliasJoin Type
ehhssw_fsi_root ehhssw_fsi_root from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IHSSFSIDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label FSI: Interface View - Draft view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SafetyInstructionUUID safetyinstructionuuid NodeID
SafetyInstruction safetyinstruction Safety Instr. ID
SafetyInstructionStatus safetyinstructionstatus Status
SafetyInstructionMajorRevision safetyinstructionmajorrevision Major Revision
SafetyInstructionMinorRevision safetyinstructionminorrevision Minor Revision
FactoryEHSLocationUUID factoryehslocationuuid Location
ChemicalUUID chemicaluuid NodeID
ChmlCmplncInfoUUID chmlcmplncinfouuid Chemical Compliance Information PP
JobFreeText jobfreetext Job Description
FactoryAreaFreeText factoryareafreetext Fact. Area Descr.
Language language Report Text Language
SafetyInstructionRelDate safetyinstructionreldate Released On
ActiveSafetyInstructionUUID activeuuid UUID
SafetyInstructionType safetyinstructiontype SI Type
SafetyInstructionSubType safetyinstructionsubtype SI Subtype
SafetyInstructionSubjectDesc safetyinstructionsubjectdesc Subject Description

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_SafetyInstructionDraft.
-- 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_SafetyInstructionDraft AS
SELECT
  SafetyInstructionUUID,
  SafetyInstruction,
  SafetyInstructionStatus,
  SafetyInstructionMajorRevision,
  SafetyInstructionMinorRevision,
  FactoryEHSLocationUUID,
  ChemicalUUID,
  ChmlCmplncInfoUUID,
  JobFreeText,
  FactoryAreaFreeText,
  Language,
  SafetyInstructionRelDate,
  activeuuid AS ActiveSafetyInstructionUUID,
  SafetyInstructionType,
  SafetyInstructionSubType,
  SafetyInstructionSubjectDesc
FROM ehhssw_fsi_root
;

Learn More