I_SiloTankMatlAssign

DDL: I_SILOTANKMATLASSIGN SQL: ISILOTANKMAST Type: view BASIC

CDS for Tank Master Data

I_SiloTankMatlAssign is a Basic CDS View that provides data about "CDS for Tank Master Data" in SAP S/4HANA. It reads from 5 data sources (oiisoco1, oiisock, t001w, oij07_tank_shape, I_OilPartnerRoles) and exposes 9 fields with key field TankID.

5 data source(s) 9 fields

Data Sources (5)

SourceAliasJoin Type
oiisoco1 t1 left_outer
oiisock t2 left_outer
t001w t3 left_outer
oij07_tank_shape t5 left_outer
I_OilPartnerRoles v2 inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISILOTANKMAST view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label CDS for Tank Master Data view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY TankID
StorageObjSgmntNmbr v1 StorageObjSgmntNmbr
LocationId I_OilPartnerRoles LocationId
OilLinearVolCnvrsnSetNmbr oiisoco1 slvnr
RecalibrationIndex oiisoco1 slvind
Plant v1 Plant
AddressID t001w adrnr
PlantCountry t001w land1
StorageType oij07_tank_shape tankshape 
@AbapCatalog.sqlViewName: 'ISILOTANKMAST'
@VDM.viewType:#BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'CDS for Tank Master Data'
define view I_SiloTankMatlAssign as 
select distinct from I_StorageLocationIndex as v1 
                             inner join I_OilPartnerRoles as v2
                             on v1.Plant = v2.Plant and v2.OilPartnerRoleType = 'LG'
                             left outer join oiisoco1 as t1
                             on v1.StorageObjSgmntNmbr = t1.socnr
                             left outer join oiisock as t2
                             on v1.StorageObjSgmntNmbr = t2.socnr
                             left outer join oij07_tank_shape as t5
                             on t2.soctyp = t5.soctyp and t2.sockl = t5.sockl
                             left outer join t001w as t3
                             on v1.Plant = t3.werks
                            
{
      key cast ( v1.SequenceNumber as abap.char( 10 ) ) as TankID,
      v1.StorageObjSgmntNmbr as StorageObjSgmntNmbr,
      v2.LocationId as LocationId,
      t1.slvnr as OilLinearVolCnvrsnSetNmbr,
      t1.slvind as RecalibrationIndex,
      v1.Plant as Plant,
      t3.adrnr as AddressID,
      t3.land1 as PlantCountry,
      t5.tankshape as StorageType    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OILPARTNERROLES",
"I_STORAGELOCATIONINDEX",
"OIISOCK",
"OIISOCO1",
"OIJ07_TANK_SHAPE",
"T001W"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More