I_AllocationFieldDerivationTP

DDL: I_ALLOCATIONFIELDDERIVATIONTP SQL: ALLOCFLDDERIVTP Type: view TRANSACTIONAL

Allocation Field Derivation

I_AllocationFieldDerivationTP is a Transactional CDS View that provides data about "Allocation Field Derivation" in SAP S/4HANA. It reads from 1 data source (I_AllocationFieldDerivation) and exposes 9 fields with key fields AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationSetType, AllocationFieldName. It has 1 association to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_AllocationFieldDerivation I_AllocationFieldDerivation from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_AllocationCycleTP _Cycle $projection.AllocationType = _Cycle.AllocationType and $projection.AllocationCycle = _Cycle.AllocationCycle and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ALLOCFLDDERIVTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Allocation Field Derivation view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #TRANSACTIONAL view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence ALLOCFLDDERIVTPD view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY AllocationType AllocationType
KEY AllocationCycle AllocationCycle
KEY AllocationCycleStartDate AllocationCycleStartDate
KEY AllocationSetType AllocationSetType
KEY AllocationFieldName AllocationFieldName
AllocationFieldIsDerived AllocationFieldIsDerived
AllocationFieldLabel
IsDefaultValue
_Cycle _Cycle 
@AbapCatalog.sqlViewName: 'ALLOCFLDDERIVTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking:#NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Allocation Field Derivation'

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

@VDM.viewType: #TRANSACTIONAL

@ObjectModel:
{
  transactionalProcessingEnabled:true,
  writeDraftPersistence: 'ALLOCFLDDERIVTPD',
  semanticKey: ['AllocationType', 'AllocationCycle', 'AllocationCycleStartDate', 'AllocationSetType', 'AllocationFieldName' ],
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true
}
define view I_AllocationFieldDerivationTP as 
  select from I_AllocationFieldDerivation
    association [1..1] to I_AllocationCycleTP as _Cycle on  $projection.AllocationType           = _Cycle.AllocationType
                                                        and $projection.AllocationCycle          = _Cycle.AllocationCycle
                                                        and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate 
{    
    key AllocationType,
    key AllocationCycle,
    key AllocationCycleStartDate,
    key AllocationSetType,
    key AllocationFieldName,
        AllocationFieldIsDerived,
        @UI.hidden: true
        @ObjectModel.readOnly: true
        cast ( '' as scrtext_l ) as AllocationFieldLabel,        
        @ObjectModel.readOnly: true
        cast('' as xfeld) as IsDefaultValue,
        @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
        _Cycle    
}

Learn More