I_RECONTRCONDITIONCALCULATION
RE Condition Calculation Factors
I_RECONTRCONDITIONCALCULATION is a CDS View in S/4HANA. RE Condition Calculation Factors. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_REContractConditionCalc | view | from | CONSUMPTION | RE Contract Condition Calculation |
//@AbapCatalog.sqlViewName: 'IRECNDNCALC'
@AccessControl: {
authorizationCheck: #MANDATORY,
personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@VDM.viewType: #BASIC
@Analytics: {
dataCategory: #DIMENSION,
internalName: #LOCAL,
dataExtraction.enabled: true,
technicalName: 'IRECNDNCALC'
}
@ObjectModel: {
representativeKey: 'RECndnCalculationUUID',
usageType: {
dataClass: #MASTER,
serviceQuality: #A,
sizeCategory: #L
},
modelingPattern: #ANALYTICAL_DIMENSION,
supportedCapabilities: [
#ANALYTICAL_DIMENSION,
#CDS_MODELING_ASSOCIATION_TARGET,
#EXTRACTION_DATA_SOURCE
],
sapObjectNodeType.name: 'REContractConditionCalculation'
}
@Metadata: {
allowExtensions: true,
ignorePropagatedAnnotations: true
}
@EndUserText.label: 'RE Condition Calculation Factors'
define view entity I_REContrConditionCalculation
as select from vicdcondcalc
association [1..1] to I_REContract as _REContract on $projection.InternalRealEstateNumber = _REContract.InternalRealEstateNumber
association [0..1] to I_Currency as _Currency on $projection.REConditionCurrency = _Currency.Currency
association [1..1] to I_REConditionType as _REConditionType on $projection.REConditionType = _REConditionType.REConditionType
{
key calcguid as RECndnCalculationUUID,
condguid as REConditionUUID,
intreno as InternalRealEstateNumber,
objnr as REStatusObjectCalculation,
@ObjectModel.foreignKey.association: '_REConditionType'
condtype as REConditionType,
condvalidfrom as REConditionValidityStartDate,
@Semantics.businessDate.from: true
cast(valuevalidfrom as rebdvdmvalidfrom preserving type) as ValidityStartDate,
@Semantics.businessDate.to: true
cast(valuevalidto as rebdvdmvalidto preserving type) as ValidityEndDate,
calcvalue as REConditionCalculationFactor,
@Semantics.amount.currencyCode: 'REConditionCurrency'
condvalue as REConditionItemAmount,
@Semantics.amount.currencyCode: 'REConditionCurrency'
taxvalue as REConditionItemTaxAmount,
@Semantics.amount.currencyCode: 'REConditionCurrency'
condvaluenet as REConditionNetAmount,
@Semantics.amount.currencyCode: 'REConditionCurrency'
condvaluegross as REConditionGrossAmount,
condcurr as REConditionCurrency,
calcnumber as RENumberOfCalculation,
partner as BusinessPartner,
partnerobjnr as REPartnerStatusObject,
duedate as REConditionDueDate,
_REContract,
_REConditionType,
_Currency
} where intreno like 'IS%'