C_TankVisualization

DDL: C_TANKVISUALIZATION SQL: CTANKVISU Type: view CONSUMPTION
37 Fields 1 Data Sources

Consumption of Tank Visualization Details

C_TankVisualization is a Consumption CDS View that provides data about "Consumption of Tank Visualization Details" in SAP S/4HANA. It reads from 1 data source (I_TankVisualization) and exposes 37 fields with key fields LocationId, TankID, Material, OpenTankDipTime.

Data Sources (1)

SourceAliasJoin Type
I_TankVisualization I_TankVisualization from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CTANKVISU view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Consumption of Tank Visualization Details view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY LocationId LocationId Location ID
KEY TankID TankID SOCSEG number
KEY Material Material Vehicle Model
KEY OpenTankDipTime OpenTankDipTime
DipGUID DipGUID
OilTimeStampDisplay OilTimeStampDisplay
MaterialDescription MaterialDescription
Capacity Capacity Engine Capacity
UnpumpableQuantity UnpumpableQuantity Unp.qty.
MaterialVolumeUoM MaterialVolumeUoM Volume UoM
MinimumHeight MinimumHeight
MaximumHeight MaximumHeight
LengthUnitOfMeasure LengthUnitOfMeasure
TankDipTotalHeight TankDipTotalHeight
TankDipTotalHeightUoM TankDipTotalHeightUoM Length UoM
TankDipWaterHeight TankDipWaterHeight
TankDipWaterHeightUoM TankDipWaterHeightUoM
LinearVolMaterialQty LinearVolMaterialQty
LinearVolWaterQty LinearVolWaterQty
LinearVolCnvrsnUom LinearVolCnvrsnUom
NetStandardVolume NetStandardVolume
NetStandardVolumeUoM NetStandardVolumeUoM
DryGrossVolume DryGrossVolume
DryGrossVolumeUoM DryGrossVolumeUoM
AmbientTemperature AmbientTemperature
AmbientTemperatureUnit AmbientTemperatureUnit
StandardDensity StandardDensity
StandardDensityUnit StandardDensityUnit
BaseSedimentWater BaseSedimentWater
BaseSedimentWaterUnit BaseSedimentWaterUnit
VaporLiqVolume VaporLiqVolume
VaporLiqVolumeUnit VaporLiqVolumeUnit
ShellTemperature ShellTemperature
ShellTemperatureUnit ShellTemperatureUnit
TankUtilizationRatio TankUtilizationRatio
StorageType StorageType Storage Type
PlantCountry PlantCountry Country/Region

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 C_TankVisualization.
-- 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: CTANKVISU

CREATE VIEW C_TankVisualization AS
SELECT
  LocationId,
  TankID,
  Material,
  OpenTankDipTime,
  DipGUID,
  OilTimeStampDisplay,
  MaterialDescription,
  Capacity,
  UnpumpableQuantity,
  MaterialVolumeUoM,
  MinimumHeight,
  MaximumHeight,
  LengthUnitOfMeasure,
  TankDipTotalHeight,
  TankDipTotalHeightUoM,
  TankDipWaterHeight,
  TankDipWaterHeightUoM,
  LinearVolMaterialQty,
  LinearVolWaterQty,
  LinearVolCnvrsnUom,
  NetStandardVolume,
  NetStandardVolumeUoM,
  DryGrossVolume,
  DryGrossVolumeUoM,
  AmbientTemperature,
  AmbientTemperatureUnit,
  StandardDensity,
  StandardDensityUnit,
  BaseSedimentWater,
  BaseSedimentWaterUnit,
  VaporLiqVolume,
  VaporLiqVolumeUnit,
  ShellTemperature,
  ShellTemperatureUnit,
  TankUtilizationRatio,
  StorageType,
  PlantCountry
FROM I_TankVisualization
;

Learn More