P_AllocationKeyFields

DDL: P_ALLOCATIONKEYFIELDS SQL: PT881IVH Type: view BASIC

P_AllocationKeyFields is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_AllocationContextType, I_AllocationContextType) and exposes 4 fields.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_AllocationContextType C inner
I_AllocationContextType C inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PT881IVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view
VDM.private true view
Search.searchable false view

Fields (4)

KeyFieldSource TableSource FieldDescription
field field
tab tab
tab tab
alart 
@AbapCatalog.sqlViewName: 'PT881IVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Allocation key fields for VH'


@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S

@VDM.viewType: #BASIC
@VDM.private: true
@Search.searchable: false
define view P_AllocationKeyFields
  as select distinct from t811i                   as I
    inner join            I_AllocationContextType as C on C.AllocationType = I.tab
{
  field,
  tab,
  alart
}
union select distinct from fins_alloc_tmpli        as I
  inner join               I_AllocationContextType as C on C.AllocationType = I.tab
{
  cast(fieldname as fdnam) as field,
  tab,
  'K' as alart
}
//where ract = 'X' or ract = '+' or sact = 'X' or sact = '+'

Learn More