I_BldngForHzdsSubstInvtryActv

DDL: I_BLDNGFORHZDSSUBSTINVTRYACTV SQL: IHASSUBINVBLDACT Type: view COMPOSITE
9 Fields 4 Data Sources

HSI: Buildings belong to active HSI

I_BldngForHzdsSubstInvtryActv is a Composite CDS View that provides data about "HSI: Buildings belong to active HSI" in SAP S/4HANA. It reads from 4 data sources (I_EHSLocationBuilding, I_EHSLocationRevision, I_EHSLocationRevision, I_HzdsSubstInventory) and exposes 9 fields with key fields HzdsSubstInventoryUUID, EHSLocationUUID.

Data Sources (4)

SourceAliasJoin Type
I_EHSLocationBuilding _BuildingLocation inner
I_EHSLocationRevision _BuildingLocationRevision inner
I_EHSLocationRevision _HSILocationRevision inner
I_HzdsSubstInventory I_HzdsSubstInventory from

Annotations (10)

NameValueLevelField
EndUserText.label HSI: Buildings belong to active HSI view
AbapCatalog.sqlViewName IHASSUBINVBLDACT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY HzdsSubstInventoryUUID HzdsSubstInventoryUUID NodeID
KEY EHSLocationUUID I_EHSLocationRevision EHSLocationUUID NodeID
EHSLocationType I_EHSLocationRevision EHSLocationType Loc. Type
EHSLocationStatus I_EHSLocationRevision EHSLocationStatus
EHSLocationAuthorizationGroup
Plant I_EHSLocationRevision Plant Valuation Area
CostCenter I_EHSLocationRevision CostCenter Cost Center
CompanyCode I_EHSLocationRevision CompanyCode Receiver Company Code
BusinessArea I_EHSLocationRevision BusinessArea Business Area

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_BldngForHzdsSubstInvtryActv.
-- 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: IHASSUBINVBLDACT

CREATE VIEW I_BldngForHzdsSubstInvtryActv AS
SELECT
  HzdsSubstInventoryUUID,
  _BuildingLocationRevision.EHSLocationUUID AS EHSLocationUUID,
  _BuildingLocationRevision.EHSLocationType AS EHSLocationType,
  _BuildingLocationRevision.EHSLocationStatus AS EHSLocationStatus,
  cast( _BuildingLocationRevision.EHSLocationAuthorizationGroup as ehfnd_loc_auth_group_nc preserving type ) AS EHSLocationAuthorizationGroup,
  _BuildingLocationRevision.Plant AS Plant,
  _BuildingLocationRevision.CostCenter AS CostCenter,
  _BuildingLocationRevision.CompanyCode AS CompanyCode,
  _BuildingLocationRevision.BusinessArea AS BusinessArea
FROM I_HzdsSubstInventory
INNER JOIN I_EHSLocationRevision AS _HSILocationRevision ON /* join condition not captured in parsed metadata */
INNER JOIN I_EHSLocationBuilding AS _BuildingLocation ON /* join condition not captured in parsed metadata */
INNER JOIN I_EHSLocationRevision AS _BuildingLocationRevision ON /* join condition not captured in parsed metadata */
;

Learn More