I_HZDSSUBSTINVENTORYDRAFT

CDS View

HSI: Draft view for Substance Inventory

I_HZDSSUBSTINVENTORYDRAFT is a CDS View in S/4HANA. HSI: Draft view for Substance Inventory. It contains 1 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 1 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_HzdsSubstInventoryFreeLoc view left_outer CONSUMPTION HSI: Set of free locations
C_HzdsSubstInventoryLocVH view left_outer CONSUMPTION HSI: Location Value Help
C_HzdsSubstInvtryChmlRstrcdVH view cross CONSUMPTION HSI: Chemicals Restricted Value Help
C_HzdsSubstInvtrySubstProposal view inner CONSUMPTION HSI: Items Consumption View
I_BldngForHzdsSubstInvtryItem view from COMPOSITE Building for hazardous substance inventory item
I_HzdsSubstInvtryProdQty view inner COMPOSITE HSI: Product Quantitiy
P_HzdsSubstInvtrySubstProposal view inner CONSUMPTION Private view for proposed substances for the HSI

Fields (1)

KeyField CDS FieldsUsed in Views
KEY HzdsSubstInventoryUUID HzdsSubstInventoryUUID 2 
@EndUserText.label: 'HSI: Draft view for Substance Inventory'

@AbapCatalog: { sqlViewName: 'IHASSUBINVDR',
                compiler.compareFilter: true,
                preserveKey: true }

@AccessControl: { authorizationCheck: #NOT_REQUIRED }

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #BASIC

@ObjectModel:
{
  usageType:
  {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #M,
    serviceQuality: #B
  }
}

define view I_HzdsSubstInventoryDraft
  as select from ehhssw_hsi_root

{
  key hzdssubstinventoryuuid        as HzdsSubstInventoryUUID,
      ehslocationuuid               as EHSLocationUUID,
      creationutcdatetime           as CreationUTCDateTime,
      createdbyuser                 as CreatedByUser,
      lastchangeutcdatetime         as LastChangeUTCDateTime,
      lastchangedbyuser             as LastChangedByUser,
      hzdssubstinventorystatus      as HzdsSubstInventoryStatus,
      hzdssubstinventorynote        as HzdsSubstInventoryNote,
      hzdssubstinvtryrelutcdatetime as HzdsSubstInvtryRelUTCDateTime,
      releasedbyuser                as ReleasedByUser,
      hzdssubstinventorymjrrevision as HzdsSubstInventoryMjrRevision,
      hzdssubstinventorymnrrevision as HzdsSubstInventoryMnrRevision,
      activeuuid                    as ActiveHzdsSubstInventoryUUID   
}

Learn More