P_TDDVirtualField

DDL: P_TDDVIRTUALFIELD SQL: PALOSEGMVIRT Type: view COMPOSITE

P_TDDVirtualField is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_AllocationKeyField) and exposes 11 fields with key fields AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment, AllocationSetType.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_AllocationKeyField I_AllocationKeyField from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PALOSEGMVIRT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY AllocationType AllocationType
KEY AllocationCycle AllocationCycle
KEY AllocationCycleStartDate AllocationCycleStartDate
KEY AllocationCycleSegment AllocationCycleSegment
KEY AllocationSetType AllocationSetType
KEY AllocDocumentSequenceNumber AllocDocumentSequenceNumber
AllocationFieldName AllocationFieldName
AllocationSetName AllocationSetName
AllocationFieldMinimumValue AllocationFieldMinimumValue
AllocationFieldMaximumValue AllocationFieldMaximumValue
AllocationSetId AllocationSetId 
@AbapCatalog.sqlViewName: 'PALOSEGMVIRT'

@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@VDM.private: true
@VDM.viewType: #COMPOSITE
define view P_TDDVirtualField as 
select from I_AllocationKeyField 
{
  //I_AllocationKeyFieldTP

  key AllocationType,
  key AllocationCycle,
  key AllocationCycleStartDate,
  key AllocationCycleSegment,
  key AllocationSetType,
  key AllocDocumentSequenceNumber,
  AllocationFieldName,
  AllocationSetName,
  AllocationFieldMinimumValue,
  AllocationFieldMaximumValue,
  AllocationSetId
}
where AllocationSetType = '4' and ( AllocationFieldName = 'CATEGORY' or AllocationFieldName = 'RUNIT' or AllocationFieldName = 'RVUNIT' or AllocationFieldName = 'RLDNR' )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ALLOCATIONKEYFIELD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More