C_HzdsSubstInventoryInfo

Column Name Description
HzdsSubstInventoryItemUUID NodeID
Column Name Description
Column Name Description
Column Name Description
HzdsSubstInvtryRelUTCDateTime null
LastChangeDate null
HzdsSubstInvtryRlvtDateTime null
Column Name Description
HzdsSubstInventoryStatus Status Show values
HzdsSubstInvtryItemIsPrinted Inventory Item Printed Show values
Column Name Description Domain name
ChemicalUUID Chemical - Root UUID SYSUUID
ChemicalRevisionUUID NodeID /BOBF/CONF_KEY
FactoryJargonForSubstance Factory Jargon of Substance EHHSS_HSI_SUBSTANCE_JARGON
NameOfChemical Name of the Chemical
CASNumber CAS Number TEXT20
AssignedMatlNamesConcatenated null
GHSHazardStatementCodes null
GHSHazardStatementNames null
GHSHazardClassCategoryNames null
HzdsSubstInvtryIngrdntCnctntd null
EHSLocationUUID Location SYSUUID
EHSLocationName Location
CityName City EHFND_ADDR_CITY1
Plant Plant ID WERKS
HzdsSubstInvtryBldngCnctntd null
HzdsSubstInventoryRevision null
HzdsSubstInventoryStatusText Short Text for Fixed Values DDTEXT
HzdsSubstInvtryStsCriticality null
CostCenter Cost Center KOSTL
CompanyCode Company Code BUKRS
BusinessArea Business Area GSBER
OrganizationalUnit Organizational Unit ID EHFND_ORGUNITID
GHSSignalWordName Description (Extra Short) EHFND_DESCRIPTION_XS
GHSHazardSymbolCodes null
GHSHazardSymbolNames null
MolecularFormula Molecular Formula EHFND_DESCRIPTION_S
DE_TRGS510StorageClass Storage Class EHFND_STORAGE_CLASS_CODE_NC
DE_TRGS510StorageClassName Description (Long)
WaterHazardClass Water Hazard Class EHFND_WATER_HAZ_CLASS_CODE_NC
WaterHazardClassName Description (Extra Short)
WaterSolubilityRemark Remarks on Water Solubility EHFND_CHM_WATER_SOL_CODE_NC
WaterSolubilityRemarkName Description (Extra Long)
StateOfMatter Physical State EHFND_CHM_STATE_OF_MATTER_CNC
StateOfMatterName Description (Extra Short)
HzdsIngrdntWthPrptnCnctntdName null
IgnitionTemperatureTxt null
FlashPointTemperatureTxt null
WaterSolubilityTxt null
UpperExplosionLimitTxt null
LowerExplosionLimitTxt null
ChemicalDensityTxt null
SubstHoldupQtyTxt null
SubstYearlyTonnageQtyTxt null
VaporPressure20Qty null
VaporPressure50Qty null
ChemicalID Chemical ID EHFND_BO_ID
Country Country/Region LAND1
Master Data Relations Join Conditions
NodeID
  • Client
  • NodeID