I_BldngForHzdsSubstInvtryItem

DDL: I_BLDNGFORHZDSSUBSTINVTRYITEM SQL: IHASSUBINVBLDNG Type: view COMPOSITE
9 Fields 4 Data Sources

Building for hazardous substance inventory item

I_BldngForHzdsSubstInvtryItem is a Composite CDS View that provides data about "Building for hazardous substance inventory item" in SAP S/4HANA. It reads from 4 data sources (I_EHSLocationBuilding, I_EHSLocationRevision, I_EHSLocationRevision, I_HzdsSubstInventoryDraft) 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_HzdsSubstInventoryDraft I_HzdsSubstInventoryDraft from

Annotations (10)

NameValueLevelField
EndUserText.label Building for hazardous substance inventory item view
AbapCatalog.sqlViewName IHASSUBINVBLDNG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED 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_BldngForHzdsSubstInvtryItem.
-- 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: IHASSUBINVBLDNG

CREATE VIEW I_BldngForHzdsSubstInvtryItem 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_HzdsSubstInventoryDraft
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