A_WorkCenterCostCenter

DDL: A_WORKCENTERCOSTCENTER SQL: AWORKCTRCOSTCTR Type: view COMPOSITE

Cost Center Allocation

A_WorkCenterCostCenter is a Composite CDS View that provides data about "Cost Center Allocation" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterCostCenter) and exposes 19 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CostCenterAllocation, ValidityEndDate. It has 1 association to related views.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterCostCenter I_WorkCenterCostCenter from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_WorkCenters _WorkCenter $projection.WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode and $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName AWORKCTRCOSTCTR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Cost Center Allocation view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.updateEnabled true view
ObjectModel.createEnabled true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID
KEY WorkCenterTypeCode WorkCenterTypeCode
KEY CostCenterAllocation CostCenterAllocation
KEY ValidityEndDate ValidityEndDate
ValidityStartDate ValidityStartDate
WorkCenter _WorkCenter WorkCenter
Plant Plant
WorkCenterCategoryCode WorkCenterCategoryCode
ControllingArea ControllingArea
CostCenter CostCenter
CostCtrActivityType CostCtrActivityType
CostCtrActivityTypeQtyUnit CostCtrActivityTypeQtyUnit
BusinessProcess BusinessProcess
ActivityDescOriginType ActivityDescOriginType
CostCenterActivityAltvDescID CostCenterActivityAltvDescID
CostCenterActivityTypeFormula CostCenterActivityTypeFormula
CostCtrActyTypeIsReferenced CostCtrActyTypeIsReferenced
CostCtrActyTypeIncntvWageCode CostCtrActyTypeIncntvWageCode
CostCtrActyTypeRecdTypeGrpCode CostCtrActyTypeRecdTypeGrpCode 
@AbapCatalog.sqlViewName: 'AWORKCTRCOSTCTR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Cost Center Allocation'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@Metadata.ignorePropagatedAnnotations:true
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
@ObjectModel.updateEnabled: true
@ObjectModel.createEnabled: true
define view A_WorkCenterCostCenter
  as select from I_WorkCenterCostCenter
  association [1..1] to A_WorkCenters as _WorkCenter on  $projection.WorkCenterTypeCode   = _WorkCenter.WorkCenterTypeCode
                                                     and $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID
{

  key WorkCenterInternalID,
  key WorkCenterTypeCode,
  key CostCenterAllocation,
  key ValidityEndDate,
      ValidityStartDate,
      _WorkCenter.WorkCenter                             as WorkCenter,
      Plant,
      WorkCenterCategoryCode,
      ControllingArea,
      CostCenter,
      CostCtrActivityType,

      @Semantics.unitOfMeasure: true
      CostCtrActivityTypeQtyUnit,

      BusinessProcess,
      ActivityDescOriginType,
      CostCenterActivityAltvDescID,
      CostCenterActivityTypeFormula,
      CostCtrActyTypeIsReferenced,
      CostCtrActyTypeIncntvWageCode,
      CostCtrActyTypeRecdTypeGrpCode,

      case when _WorkCenter.WorkCenterLastChangeDateTime is null then
       cast(dats_tims_to_tstmp(cast('20190101' as dats), cast('120000'as tims), 'UTC', $session.client, 'NULL') as cr_lastchange_datetime)
       else _WorkCenter.WorkCenterLastChangeDateTime end as WorkCenterLastChangeDateTime
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_WORKCENTERS",
"I_WORKCENTERCOSTCENTER"
],
"ASSOCIATED":
[
"A_WORKCENTERS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More