P_UnivAllocKeyFieldVersion

DDL: P_UNIVALLOCKEYFIELDVERSION Type: view_entity CONSUMPTION Package: ODATA_MANAGE_ALLOC_CHANGES

Universal Allocation Key Field

P_UnivAllocKeyFieldVersion is a Consumption CDS View that provides data about "Universal Allocation Key Field" in SAP S/4HANA. It reads from 2 data sources (I_UnivAllocKeyFieldVersion, I_UniversalAllocationKeyField) and exposes 22 fields with key fields AllocCycleKeyFieldVersionValue, AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment. Part of development package ODATA_MANAGE_ALLOC_CHANGES.

2 data source(s) 22 fields

Data Sources (2)

SourceAliasJoin Type
I_UnivAllocKeyFieldVersion I_UnivAllocKeyFieldVersion from
I_UniversalAllocationKeyField I_UniversalAllocationKeyField union_all

Annotations (4)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY AllocCycleKeyFieldVersionValue
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
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 
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

define view entity P_UnivAllocKeyFieldVersion
  as select from I_UnivAllocKeyFieldVersion
{
  key cast( AllocCycleKeyFieldVersionValue as fcoua_version_id_decimal) as AllocCycleKeyFieldVersionValue,
  key AllocationType,
  key AllocationCycle,
  key AllocationCycleStartDate,
  key AllocationCycleSegment,
  key AllocationSetType,
  key AllocDocumentSequenceNumber,
      AllocationFieldName,
      AllocationSetName,
      AllocationFieldMinimumValue,
      AllocationFieldMaximumValue,
      AllocationSetId
}
union all select from I_UniversalAllocationKeyField
{
  key cast(99990101010101.0000000 as fcoua_version_id_decimal ) as AllocCycleKeyFieldVersionValue,
  key AllocationType,
  key AllocationCycle,
  key AllocationCycleStartDate,
  key AllocationCycleSegment,
  key AllocationSetType,
  key AllocDocumentSequenceNumber,
      AllocationFieldName,
      AllocationSetName,
      AllocationFieldMinimumValue,
      AllocationFieldMaximumValue,
      AllocationSetId
}

Learn More