I_COSTELEMENTONCONTROLLINGAREA
Cost element depend on controlling area
I_COSTELEMENTONCONTROLLINGAREA is a CDS View in S/4HANA. Cost element depend on controlling area. It contains 8 fields. 18 CDS views read from this table.
CDS Views using this table (18)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_AllocationSenderGLAcctVH | view | inner | CONSUMPTION | Allocation Sender GL Account |
| C_OverheadAllocationAccountVH | view | inner | CONSUMPTION | Overhead Allocation Account Value Help |
| C_OvhdAllocAcctWithCtrlgAreaVH | view_entity | inner | CONSUMPTION | Overhead Alloc Account Controlling Area |
| I_CostElement | view | inner | COMPOSITE | Cost Element |
| I_CostElmntOnCtrlgAreaStdVH | view | from | COMPOSITE | Cost element depend on controlling area |
| I_InternalOrderCostElementVH | view_entity | from | COMPOSITE | Cost Element |
| I_SrvcDocBslnPlannedCost | view | inner | COMPOSITE | Baseline Planned Cost of Srv Transaction |
| I_SrvcDocBslnPlannedRevenue | view | inner | COMPOSITE | Baseline Planned Revenue of Srv Txn |
| I_SrvcDocContnsPlannedCost | view_entity | inner | COMPOSITE | Ongoing Planned Cost of Srv Transaction |
| I_SrvcDocContnsPlannedRevenue | view_entity | inner | COMPOSITE | Ongoing Planned Revenue of Srv Trans |
| I_SrvcDocItmBslnPlannedCost | view | inner | COMPOSITE | Baseline Planned Cost of Srv Txn Item |
| I_SrvcDocItmBslnPlannedRevenue | view | inner | COMPOSITE | Baseline Planned Revenue of Srv Txn Item |
| I_SrvcDocItmContnsPlannedCost | view_entity | inner | COMPOSITE | Ongoing Planned Cost Srv Trans Item |
| I_SrvcDocItmContnsPlndRevenue | view_entity | inner | COMPOSITE | Ongoing Planned Revenue Srv Trans Item |
| P_DMVCECCostElement | view_entity | from | BASIC | |
| P_EffctvCostElmntOnCtrlgArea | view | from | COMPOSITE | |
| P_GLAccountVH | view | inner | CONSUMPTION | gl account vh |
| P_GLOverheadAccountVH | view | inner | CONSUMPTION | gl account vh |
Fields (8)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ControllingArea | ControllingArea | 3 |
| KEY | CostElement | CostElement | 2 |
| ConsumptionQtyIsRecorded | ConsumptionQtyIsRecorded | 1 | |
| CostElementCategory | CostElementCategory | 2 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| UnitOfMeasure | UnitOfMeasure | 1 | |
| ValidityEndDate | ValidityEndDate | 2 | |
| ValidityStartDate | ValidityStartDate | 2 |
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'ICECA'
@AbapCatalog.compiler.compareFilter: true
//@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Cost element depend on controlling area'
@ObjectModel.entityChangeStateId: 'LastChangeDateTime'
@ObjectModel.representativeKey: 'CostElement'
@ObjectModel.usageType: {
serviceQuality: #C,
sizeCategory: #M,
dataClass: #MIXED
}
//--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG
@AccessControl.privilegedAssociations: ['_ControllingAreaText']
// ]--GENERATED
define view I_CostElementOnControllingArea
as select from cskb
left outer to one join tka01 on cskb.kokrs = tka01.kokrs
//--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG
association [0..1] to I_ControllingArea as _ControllingAreaText on $projection.ControllingArea = _ControllingAreaText.ControllingArea
// ]--GENERATED
association [0..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea
association [0..1] to I_UnitOfMeasure as _UnitOfMeasure on $projection.UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure
association [0..1] to I_CostElementOnChartOfAccounts as _CostElementOnChartOfAccounts on $projection.ChartOfAccounts = _CostElementOnChartOfAccounts.ChartOfAccounts
and $projection.CostElement = _CostElementOnChartOfAccounts.CostElement
association [0..1] to I_CostElementCategory as _CostElementCategory on $projection.CostElementCategory = _CostElementCategory.CostElementCategory
{
//--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_ControllingAreaStdVH',
element: 'ControllingArea' }
}]
@ObjectModel.text.association: '_ControllingAreaText'
// ]--GENERATED
@ObjectModel.foreignKey.association: '_ControllingArea'
key cskb.kokrs as ControllingArea,
key cskb.kstar as CostElement,
@Semantics.businessDate.to: true
key cskb.datbi as ValidityEndDate,
@Semantics.businessDate.from: true
cskb.datab as ValidityStartDate,
@ObjectModel.foreignKey.association: '_CostElementCategory'
cskb.katyp as CostElementCategory,
cskb.mgefl as ConsumptionQtyIsRecorded,
@ObjectModel.foreignKey.association: '_UnitOfMeasure'
cskb.msehi as UnitOfMeasure,
tka01.ktopl as ChartOfAccounts,
cskb.last_changed_ts as LastChangeDateTime,
_ControllingArea,
_CostElementOnChartOfAccounts,
_CostElementCategory,
_UnitOfMeasure,
//--[ GENERATED:012:29JlHNUf7jY4ioM8lnJMdG
@Consumption.hidden: true
_ControllingAreaText
// ]--GENERATED
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CSKB",
"TKA01"
],
"ASSOCIATED":
[
"I_CONTROLLINGAREA",
"I_COSTELEMENTCATEGORY",
"I_COSTELEMENTONCHARTOFACCOUNTS",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/