I_OILPARTNERROLES

CDS View

OIL TSW: Partner roles

I_OILPARTNERROLES is a CDS View in S/4HANA. OIL TSW: Partner roles. It contains 1 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 1 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_DCBBaseLocationFilter view inner COMPOSITE Base Location filter
I_SiloTankMatlAssign view inner BASIC CDS for Tank Master Data
I_VisualAnalysis view left_outer COMPOSITE Visual Analysis

Fields (1)

KeyField CDS FieldsUsed in Views
LocationId LocationId 1 
@AbapCatalog.sqlViewName: 'IOILPARTNERROLES'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'OIL TSW: Partner roles'
define view I_OilPartnerRoles as select distinct from oijrra as  a 
 {
   key a.kunnr as Customer,
   key a.lifnr as SupplierAccount,
   key a.werk  as Plant,  
   key a.lgort as StorageLocation, 
   key a.rtype as OilRoleType, 
   key a.rdiff as OilRoleDifferentiation,
       a.rpart as OilPartnerRoleType,
       a.locid as LocationId
 }
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"OIJRRA"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More