I_SiloTankDipAnalysis

DDL: I_SILOTANKDIPANALYSIS SQL: ITANKANALYSIS Type: view COMPOSITE
7 Fields 3 Data Sources

Silo Tank Dip height analysis across a number of days

I_SiloTankDipAnalysis is a Composite CDS View that provides data about "Silo Tank Dip height analysis across a number of days" in SAP S/4HANA. It reads from 3 data sources (adrc, I_PhysInvtryGaugeRdngFld, I_SiloTankMatlAssign) and exposes 7 fields with key fields TankID, StorageObjSgmntNmbr.

Data Sources (3)

SourceAliasJoin Type
adrc t2 left_outer
I_PhysInvtryGaugeRdngFld v1 from
I_SiloTankMatlAssign v2 inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ITANKANALYSIS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Silo Tank Dip height analysis across a number of days view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY TankID I_SiloTankMatlAssign TankID SOCSEG number
KEY StorageObjSgmntNmbr I_SiloTankMatlAssign StorageObjSgmntNmbr SOCSEG number
LocationId I_SiloTankMatlAssign LocationId Location ID
OpenTankDipTime I_PhysInvtryGaugeRdngFld OpenTankDipTime Dip timestamp
clientNULL521asOilTimeStampDisplay
TankDipTotalHeight I_PhysInvtryGaugeRdngFld TankDipTotalHeight Total height
TankDipTotalHeightUoM I_PhysInvtryGaugeRdngFld TankDipTotalHeightUoM Length UoM

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_SiloTankDipAnalysis.
-- 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: ITANKANALYSIS

CREATE VIEW I_SiloTankDipAnalysis AS
SELECT
  v2.TankID AS TankID,
  v2.StorageObjSgmntNmbr AS StorageObjSgmntNmbr,
  v2.LocationId AS LocationId,
  v1.OpenTankDipTime AS OpenTankDipTime,
  concat_with_space( concat( concat( concat( substring(tstmp_to_dats( cast( v1.OpenTankDipTime as abap.dec( 15,0 ) ), t2.time_zone, $session.client, 'NULL' ) ,7,2), '.'), concat( substring(tstmp_to_dats( cast( v1.OpenTankDipTime as abap.dec( 15,0 ) ), t2.time_zone, $session.client, 'NULL' ),5,2), '.') ), concat( substring(tstmp_to_dats( cast( v1.OpenTankDipTime as abap.dec( 15,0 ) ), t2.time_zone, $session.client, 'NULL' ),1,4), ' ' ) ), concat( concat( concat( substring(tstmp_to_tims( cast ( v1.OpenTankDipTime as abap.dec( 15,0 ) ) , t2.time_zone, $session.client, 'NULL' ),1,2), ':'), concat( substring(tstmp_to_tims( cast ( v1.OpenTankDipTime as abap.dec( 15,0 ) ) , t2.time_zone, $session.client, 'NULL' ),3,2), ':') ), concat( substring(tstmp_to_tims( cast ( v1.OpenTankDipTime as abap.dec( 15,0 ) ) , t2.time_zone, $session.client, 'NULL' ),5,2), ' ' ) ),1 ) as OilTimeStampDisplay AS clientNULL521asOilTimeStampDisplay,
  v1.TankDipTotalHeight AS TankDipTotalHeight,
  v1.TankDipTotalHeightUoM AS TankDipTotalHeightUoM
FROM I_PhysInvtryGaugeRdngFld AS v1
INNER JOIN I_SiloTankMatlAssign AS v2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrc AS t2 ON /* join condition not captured in parsed metadata */
;

Learn More