I_RECndnDistributionRuleExt

DDL: I_RECNDNDISTRIBUTIONRULEEXT SQL: IREDISTRULEEXT Type: view BASIC

External Distribution Formula

I_RECndnDistributionRuleExt is a Basic CDS View (Dimension) that provides data about "External Distribution Formula" in SAP S/4HANA. It reads from 1 data source (tivcddistext) and exposes 23 fields with key field REDistributionRule. It has 9 associations to related views.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
tivcddistext tivcddistext from

Associations (9)

CardinalityTargetAliasCondition
[0..*] I_RECndnDistrRuleExtText _Text $projection.REDistributionRule = _Text.REDistributionRule
[0..1] I_RECndnDistributionRuleInt _RECndnDistributionRuleInt $projection.REInternalDistributionRule = _RECndnDistributionRuleInt.REInternalDistributionRule
[0..1] I_RERuleFieldModifSttg1 _RERuleFieldModifSttg1 $projection.RERuleFieldModifSttg1 = _RERuleFieldModifSttg1.RERuleFieldModifSttg1
[0..1] I_RERuleFieldModifSttg2 _RERuleFieldModifSttg2 $projection.RERuleFieldModifSttg2 = _RERuleFieldModifSttg2.RERuleFieldModifSttg2
[0..1] I_RERuleFieldModifAppl1 _RERuleFieldModifAppl1 $projection.RERuleFieldModifAppl1 = _RERuleFieldModifAppl1.RERuleFieldModifAppl1
[0..1] I_RERuleFieldModifAppl2 _RERuleFieldModifAppl2 $projection.RERuleFieldModifAppl2 = _RERuleFieldModifAppl2.RERuleFieldModifAppl2
[0..1] I_REObjectTypeDistribution _REObjectTypeDistribution $projection.REObjectTypeDistribution = _REObjectTypeDistribution.REObjectTypeDistribution
[0..1] I_REObjectTypePosting _REObjectTypePosting $projection.REObjectTypePosting = _REObjectTypePosting.REObjectTypePosting
[0..1] I_REFullDistributionRule _REFullDistributionRule $projection.REFullDistributionRule = _REFullDistributionRule.REFullDistributionRule

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IREDISTRULEEXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label External Distribution Formula view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY REDistributionRule distruleext
REInternalDistributionRule distruleint
REDistributionRuleParam1 distrulepara1
RERuleFieldModifSttg1 distrulepamocu1
RERuleFieldModifAppl1 distrulepamoap1
REDistributionRuleParam2 distrulepara2
RERuleFieldModifSttg2 distrulepamocu2
RERuleFieldModifAppl2 distrulepamoap2
REObjectTypeDistribution objtypedist
REObjectTypePosting objtypepost
REDistributionIsModifiable distrulemod
REDirectDistributionIsActive directdist
REDistributionIsChecked chdicompleteness
REFullDistributionRule distcomplete
_Text _Text
_RECndnDistributionRuleInt _RECndnDistributionRuleInt
_RERuleFieldModifSttg1 _RERuleFieldModifSttg1
_RERuleFieldModifSttg2 _RERuleFieldModifSttg2
_RERuleFieldModifAppl1 _RERuleFieldModifAppl1
_RERuleFieldModifAppl2 _RERuleFieldModifAppl2
_REObjectTypeDistribution _REObjectTypeDistribution
_REObjectTypePosting _REObjectTypePosting
_REFullDistributionRule _REFullDistributionRule 
@AbapCatalog.sqlViewName: 'IREDISTRULEEXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics.dataCategory: #DIMENSION
@Analytics.internalName:#LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'External Distribution Formula'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.representativeKey: ['REDistributionRule']
@ObjectModel.semanticKey: ['REDistributionRule']
@VDM.viewType: #BASIC
define view I_RECndnDistributionRuleExt 
    as select from tivcddistext
    association [0..*] to I_RECndnDistrRuleExtText as _Text on $projection.REDistributionRule = _Text.REDistributionRule
    association [0..1] to I_RECndnDistributionRuleInt as _RECndnDistributionRuleInt on $projection.REInternalDistributionRule = _RECndnDistributionRuleInt.REInternalDistributionRule
    association [0..1] to I_RERuleFieldModifSttg1 as _RERuleFieldModifSttg1 on $projection.RERuleFieldModifSttg1 = _RERuleFieldModifSttg1.RERuleFieldModifSttg1
    association [0..1] to I_RERuleFieldModifSttg2 as _RERuleFieldModifSttg2 on $projection.RERuleFieldModifSttg2 = _RERuleFieldModifSttg2.RERuleFieldModifSttg2
    association [0..1] to I_RERuleFieldModifAppl1 as _RERuleFieldModifAppl1 on $projection.RERuleFieldModifAppl1 = _RERuleFieldModifAppl1.RERuleFieldModifAppl1
    association [0..1] to I_RERuleFieldModifAppl2 as _RERuleFieldModifAppl2 on $projection.RERuleFieldModifAppl2 = _RERuleFieldModifAppl2.RERuleFieldModifAppl2
    association [0..1] to I_REObjectTypeDistribution as _REObjectTypeDistribution on $projection.REObjectTypeDistribution = _REObjectTypeDistribution.REObjectTypeDistribution
    association [0..1] to I_REObjectTypePosting as _REObjectTypePosting on $projection.REObjectTypePosting = _REObjectTypePosting.REObjectTypePosting
    association [0..1] to I_REFullDistributionRule as _REFullDistributionRule on $projection.REFullDistributionRule = _REFullDistributionRule.REFullDistributionRule
{
        @ObjectModel.text.association: '_Text'
    key distruleext         as REDistributionRule,
        @ObjectModel.foreignKey.association:  '_RECndnDistributionRuleInt'
        distruleint         as REInternalDistributionRule,
        distrulepara1       as REDistributionRuleParam1,
        @ObjectModel.foreignKey.association:  '_RERuleFieldModifSttg1'
        distrulepamocu1     as RERuleFieldModifSttg1,
        @ObjectModel.foreignKey.association:  '_RERuleFieldModifAppl1'
        distrulepamoap1     as RERuleFieldModifAppl1,
        distrulepara2       as REDistributionRuleParam2,
        @ObjectModel.foreignKey.association:  '_RERuleFieldModifSttg2'
        distrulepamocu2     as RERuleFieldModifSttg2,
        @ObjectModel.foreignKey.association:  '_RERuleFieldModifAppl2'
        distrulepamoap2     as RERuleFieldModifAppl2,
        @ObjectModel.foreignKey.association:  '_REObjectTypeDistribution'
        objtypedist         as REObjectTypeDistribution,
        @ObjectModel.foreignKey.association:  '_REObjectTypePosting'
        objtypepost         as REObjectTypePosting,
        distrulemod         as REDistributionIsModifiable,
        directdist          as REDirectDistributionIsActive,
        chdicompleteness    as REDistributionIsChecked,
        @ObjectModel.foreignKey.association:  '_REFullDistributionRule'
        distcomplete        as REFullDistributionRule,
        
        _Text,
        _RECndnDistributionRuleInt,
        _RERuleFieldModifSttg1,
        _RERuleFieldModifSttg2,
        _RERuleFieldModifAppl1,
        _RERuleFieldModifAppl2,
        _REObjectTypeDistribution,
        _REObjectTypePosting,
        _REFullDistributionRule
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TIVCDDISTEXT"
],
"ASSOCIATED":
[
"I_RECNDNDISTRIBUTIONRULEINT",
"I_RECNDNDISTRRULEEXTTEXT",
"I_REFULLDISTRIBUTIONRULE",
"I_REOBJECTTYPEDISTRIBUTION",
"I_REOBJECTTYPEPOSTING",
"I_RERULEFIELDMODIFAPPL1",
"I_RERULEFIELDMODIFAPPL2",
"I_RERULEFIELDMODIFSTTG1",
"I_RERULEFIELDMODIFSTTG2"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More