I_RECndnCalculationRuleExt
External Calculation Formula
I_RECndnCalculationRuleExt is a Basic CDS View (Dimension) that provides data about "External Calculation Formula" in SAP S/4HANA. It reads from 1 data source (tivcdcalcext) and exposes 30 fields with key field RECalculationRule. It has 11 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| tivcdcalcext | tivcdcalcext | from |
Associations (11)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_RECndnCalculationRuleExtText | _Text | $projection.RECalculationRule = _Text.RECalculationRule |
| [0..1] | I_RECndnCalculationRuleInt | _RECndnCalculationRuleInt | $projection.REInternalCalculationRule = _RECndnCalculationRuleInt.REInternalCalculationRule |
| [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_RECndnDistributionRuleExt | _RECndnDistributionRuleExt | $projection.REDistributionRule = _RECndnDistributionRuleExt.REDistributionRule |
| [0..1] | I_RERoundingTypeForUnitPrc | _RERoundingTypeForUnitPrc | $projection.REUnitPriceRoundingType = _RERoundingTypeForUnitPrc.REUnitPriceRoundingType |
| [0..1] | I_RERoundingTypeForCndnAmt | _RERoundingTypeForCndnAmt | $projection.RECndnAmountRoundingType = _RERoundingTypeForCndnAmt.RECndnAmountRoundingType |
| [0..1] | I_REGrossOrNetRounding | _REGrossOrNetRounding | $projection.REGrossOrNetRounding = _REGrossOrNetRounding.REGrossOrNetRounding |
| [0..1] | I_REFullDistributionRule | _REFullDistributionRule | $projection.REFullDistributionRule = _REFullDistributionRule.REFullDistributionRule |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IRECALCRULEEXT | 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 Calculation Formula | view | |
| ObjectModel.usageType.dataClass | #CUSTOMIZING | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.sizeCategory | #M | view | |
| VDM.viewType | #BASIC | view |
Fields (30)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | RECalculationRule | calcruleext | ||
| REInternalCalculationRule | calcruleint | |||
| RECalculationRuleParam1 | calcrulepara1 | |||
| RERuleFieldModifSttg1 | calcrulepamocu1 | |||
| RERuleFieldModifAppl1 | calcrulepamoap1 | |||
| RECalculationRuleParam2 | calcrulepara2 | |||
| RERuleFieldModifSttg2 | calcrulepamocu2 | |||
| RERuleFieldModifAppl2 | calcrulepamoap2 | |||
| REDistributionIsIndependent | calcrulenodist | |||
| REDistributionRule | distruleext | |||
| RECalculationRuleIsModifiable | calcrulemod | |||
| REUnitPriceRoundingType | roundtype | |||
| REUnitPriceNmbrOfDcmlsToRound | rounddecimal | |||
| REUnitPriceRoundingThreshold | roundunit | |||
| RECndnAmountRoundingType | caroundtype | |||
| RECndnAmountNmbrOfDcmlsToRound | carounddecimal | |||
| RECndnAmountRoundingThreshold | caroundunit | |||
| REGrossOrNetRounding | caroundgrne | |||
| REFullDistributionRule | distcomplete | |||
| _Text | _Text | |||
| _RECndnCalculationRuleInt | _RECndnCalculationRuleInt | |||
| _RERuleFieldModifSttg1 | _RERuleFieldModifSttg1 | |||
| _RERuleFieldModifSttg2 | _RERuleFieldModifSttg2 | |||
| _RERuleFieldModifAppl1 | _RERuleFieldModifAppl1 | |||
| _RERuleFieldModifAppl2 | _RERuleFieldModifAppl2 | |||
| _RECndnDistributionRuleExt | _RECndnDistributionRuleExt | |||
| _RERoundingTypeForUnitPrc | _RERoundingTypeForUnitPrc | |||
| _RERoundingTypeForCndnAmt | _RERoundingTypeForCndnAmt | |||
| _REGrossOrNetRounding | _REGrossOrNetRounding | |||
| _REFullDistributionRule | _REFullDistributionRule |
@AbapCatalog.sqlViewName: 'IRECALCRULEEXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics.dataCategory: #DIMENSION
@Analytics.internalName:#LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'External Calculation Formula'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.representativeKey: ['RECalculationRule']
@ObjectModel.semanticKey: ['RECalculationRule']
@VDM.viewType: #BASIC
define view I_RECndnCalculationRuleExt
as select from tivcdcalcext
association [0..*] to I_RECndnCalculationRuleExtText as _Text on $projection.RECalculationRule = _Text.RECalculationRule
association [0..1] to I_RECndnCalculationRuleInt as _RECndnCalculationRuleInt on $projection.REInternalCalculationRule = _RECndnCalculationRuleInt.REInternalCalculationRule
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_RECndnDistributionRuleExt as _RECndnDistributionRuleExt on $projection.REDistributionRule = _RECndnDistributionRuleExt.REDistributionRule
association [0..1] to I_RERoundingTypeForUnitPrc as _RERoundingTypeForUnitPrc on $projection.REUnitPriceRoundingType = _RERoundingTypeForUnitPrc.REUnitPriceRoundingType
association [0..1] to I_RERoundingTypeForCndnAmt as _RERoundingTypeForCndnAmt on $projection.RECndnAmountRoundingType = _RERoundingTypeForCndnAmt.RECndnAmountRoundingType
association [0..1] to I_REGrossOrNetRounding as _REGrossOrNetRounding on $projection.REGrossOrNetRounding = _REGrossOrNetRounding.REGrossOrNetRounding
association [0..1] to I_REFullDistributionRule as _REFullDistributionRule on $projection.REFullDistributionRule = _REFullDistributionRule.REFullDistributionRule
{
@ObjectModel.text.association: '_Text'
key calcruleext as RECalculationRule,
@ObjectModel.foreignKey.association: '_RECndnCalculationRuleInt'
calcruleint as REInternalCalculationRule,
calcrulepara1 as RECalculationRuleParam1,
@ObjectModel.foreignKey.association: '_RERuleFieldModifSttg1'
calcrulepamocu1 as RERuleFieldModifSttg1,
@ObjectModel.foreignKey.association: '_RERuleFieldModifAppl1'
calcrulepamoap1 as RERuleFieldModifAppl1,
calcrulepara2 as RECalculationRuleParam2,
@ObjectModel.foreignKey.association: '_RERuleFieldModifSttg2'
calcrulepamocu2 as RERuleFieldModifSttg2,
@ObjectModel.foreignKey.association: '_RERuleFieldModifAppl2'
calcrulepamoap2 as RERuleFieldModifAppl2,
calcrulenodist as REDistributionIsIndependent,
@ObjectModel.foreignKey.association: '_RECndnDistributionRuleExt'
distruleext as REDistributionRule,
calcrulemod as RECalculationRuleIsModifiable,
@ObjectModel.foreignKey.association: '_RERoundingTypeForUnitPrc'
roundtype as REUnitPriceRoundingType,
rounddecimal as REUnitPriceNmbrOfDcmlsToRound,
roundunit as REUnitPriceRoundingThreshold,
@ObjectModel.foreignKey.association: '_RERoundingTypeForCndnAmt'
caroundtype as RECndnAmountRoundingType,
carounddecimal as RECndnAmountNmbrOfDcmlsToRound,
caroundunit as RECndnAmountRoundingThreshold,
@ObjectModel.foreignKey.association: '_REGrossOrNetRounding'
caroundgrne as REGrossOrNetRounding,
@ObjectModel.foreignKey.association: '_REFullDistributionRule'
distcomplete as REFullDistributionRule,
_Text,
_RECndnCalculationRuleInt,
_RERuleFieldModifSttg1,
_RERuleFieldModifSttg2,
_RERuleFieldModifAppl1,
_RERuleFieldModifAppl2,
_RECndnDistributionRuleExt,
_RERoundingTypeForUnitPrc,
_RERoundingTypeForCndnAmt,
_REGrossOrNetRounding,
_REFullDistributionRule
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TIVCDCALCEXT"
],
"ASSOCIATED":
[
"I_RECNDNCALCULATIONRULEEXTTEXT",
"I_RECNDNCALCULATIONRULEINT",
"I_RECNDNDISTRIBUTIONRULEEXT",
"I_REFULLDISTRIBUTIONRULE",
"I_REGROSSORNETROUNDING",
"I_REROUNDINGTYPEFORCNDNAMT",
"I_REROUNDINGTYPEFORUNITPRC",
"I_RERULEFIELDMODIFAPPL1",
"I_RERULEFIELDMODIFAPPL2",
"I_RERULEFIELDMODIFSTTG1",
"I_RERULEFIELDMODIFSTTG2"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA