I_HzdsSubstInventoryTP

DDL: I_HZDSSUBSTINVENTORYTP Type: view TRANSACTIONAL Package: EHHSS_BO_HSI
16 Fields 1 Data Sources 1 Associations

HSI: Transactional View

I_HzdsSubstInventoryTP is a Transactional CDS View that provides data about "HSI: Transactional View" in SAP S/4HANA. It reads from 1 data source (I_HzdsSubstInventory) and exposes 16 fields with key field HzdsSubstInventoryUUID. It has 1 association to related views. Part of development package EHHSS_BO_HSI.

Data Sources (1)

SourceAliasJoin Type
I_HzdsSubstInventory I_HzdsSubstInventory from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_HzdsSubstInventoryItemTP _HzdsSubstInventoryItem $projection.HzdsSubstInventoryUUID = _HzdsSubstInventoryItem.HzdsSubstInventoryUUID

Annotations (21)

NameValueLevelField
EndUserText.label HSI: Transactional View view
AbapCatalog.sqlViewName IHASSUBINVTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.sapObjectNodeType.name HazardousSubstanceInventory view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.draftEnabled true view
ObjectModel.entityChangeStateId LastChangeUTCDateTime view
ObjectModel.writeDraftPersistence EHHSSW_HSI_ROOT view
ObjectModel.writeActivePersistence EHHSSV_HSI_ROOT view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY HzdsSubstInventoryUUID HzdsSubstInventoryUUID NodeID
EHSLocationUUID EHSLocationUUID NodeID
CreationUTCDateTime CreationUTCDateTime Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeUTCDateTime LastChangeUTCDateTime Time Stamp
LastChangedByUser LastChangedByUser User Name
HzdsSubstInventoryStatus HzdsSubstInventoryStatus Status
HzdsSubstInventoryNote HzdsSubstInventoryNote Note
HzdsSubstInvtryRelUTCDateTime HzdsSubstInvtryRelUTCDateTime Released On
ReleasedByUser ReleasedByUser Released By
HzdsSubstInventoryMjrRevision HzdsSubstInventoryMjrRevision Major Revision
HzdsSubstInventoryMnrRevision HzdsSubstInventoryMnrRevision Substance Revision
HzdsSubstInvtryCalcIsRunning HzdsSubstInvtryCalcIsRunning Is Running
HzdsSubstInvtryMigrationSource HzdsSubstInvtryMigrationSource Migration Source
_HzdsSubstInventoryItem _HzdsSubstInventoryItem
_EHSLocation _EHSLocation

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_HzdsSubstInventoryTP.
-- 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_HzdsSubstInventoryTP AS
SELECT
  HzdsSubstInventoryUUID,
  EHSLocationUUID,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser,
  HzdsSubstInventoryStatus,
  HzdsSubstInventoryNote,
  HzdsSubstInvtryRelUTCDateTime,
  ReleasedByUser,
  HzdsSubstInventoryMjrRevision,
  HzdsSubstInventoryMnrRevision,
  HzdsSubstInvtryCalcIsRunning,
  HzdsSubstInvtryMigrationSource
FROM I_HzdsSubstInventory
LEFT OUTER JOIN I_HzdsSubstInventoryItemTP AS _HzdsSubstInventoryItem ON HzdsSubstInventoryUUID = _HzdsSubstInventoryItem.HzdsSubstInventoryUUID  -- association [1..*]
;

Learn More