C_SftyInstrnTextBlockFactoryVH

DDL: C_SFTYINSTRNTEXTBLOCKFACTORYVH Type: view CONSUMPTION
18 Fields 1 Data Sources 1 Associations

Safety Instruction TB Factory

C_SftyInstrnTextBlockFactoryVH is a Consumption CDS View that provides data about "Safety Instruction TB Factory" in SAP S/4HANA. It reads from 1 data source (P_SftyInstrnTextBlockFactory) and exposes 18 fields with key fields EHSLocationUUID, SafetyInstructionType, SafetyInstructionSubType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_SftyInstrnTextBlockFactory P_SftyInstrnTextBlockFactory from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CurrentEHSLocationNameText _EHSLocationName $projection.EHSLocationUUID = _EHSLocationName.EHSLocationUUID and _EHSLocationName.Language = $session.system_language

Annotations (16)

NameValueLevelField
EndUserText.label Safety Instruction TB Factory view
AbapCatalog.sqlViewName CFSITBLOCVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey EHSLocationUUID view
ObjectModel.semanticKey EHSLocationUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY EHSLocationUUID EHSLocationUUID NodeID
KEY SafetyInstructionType SafetyInstructionType SI Type
KEY SafetyInstructionSubType SafetyInstructionSubType SI Subtype
EHSLocationType EHSLocationType Loc. Type
EHSLocationName _EHSLocationName EHSLocationName
Plant Plant Valuation Area
EHSLocationStatus EHSLocationStatus
EHSLocationAuthorizationGroup EHSLocationAuthorizationGroup
CostCenter CostCenter Cost Center
Country Country Venue: Ctry/Reg
CompanyCode CompanyCode Receiver Company Code
BusinessArea BusinessArea Business Area
Associations_EHSLocationName
_Plant _Plant
_EHSLocationStatus _EHSLocationStatus
_BusinessArea _BusinessArea
_CompanyCode _CompanyCode
_Country _Country

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 C_SftyInstrnTextBlockFactoryVH.
-- 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 C_SftyInstrnTextBlockFactoryVH AS
SELECT
  EHSLocationUUID,
  SafetyInstructionType,
  SafetyInstructionSubType,
  EHSLocationType,
  _EHSLocationName.EHSLocationName AS EHSLocationName,
  Plant,
  EHSLocationStatus,
  EHSLocationAuthorizationGroup,
  CostCenter,
  Country,
  CompanyCode,
  BusinessArea
FROM P_SftyInstrnTextBlockFactory
LEFT OUTER JOIN I_CurrentEHSLocationNameText AS _EHSLocationName ON EHSLocationUUID = _EHSLocationName.EHSLocationUUID AND _EHSLocationName.Language = $session.system_language  -- association [0..1]
;

Learn More