R_WorkCenterCostCenterTP

DDL: R_WORKCENTERCOSTCENTERTP SQL: IWRKCTRCOSTCTRTP Type: view_entity TRANSACTIONAL

Work Center Cost Center

R_WorkCenterCostCenterTP is a Transactional CDS View that provides data about "Work Center Cost Center" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterCostCenter) and exposes 20 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CostCenterAllocation, ValidityEndDate.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterCostCenter I_WorkCenterCostCenter from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Work Center Cost Center view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID
KEY WorkCenterTypeCode WorkCenterTypeCode
KEY CostCenterAllocation CostCenterAllocation
KEY ValidityEndDate ValidityEndDate
ValidityStartDate ValidityStartDate
WorkCenter _Header 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
_Header _Header 
//@AbapCatalog.sqlViewName: 'IWRKCTRCOSTCTRTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
//@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #MASTER }
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
@EndUserText.label: 'Work Center Cost Center'
define view entity R_WorkCenterCostCenterTP
  as select from I_WorkCenterCostCenter
  association to parent R_WorkCenterTP as _Header on  $projection.WorkCenterInternalID = _Header.WorkCenterInternalID
                                                  and $projection.WorkCenterTypeCode   = _Header.WorkCenterTypeCode
{
  key WorkCenterInternalID,
  key WorkCenterTypeCode,
  key CostCenterAllocation,
  key ValidityEndDate,
      ValidityStartDate,
      _Header.WorkCenter                             as WorkCenter,
      Plant,
      WorkCenterCategoryCode,
      ControllingArea,
      CostCenter,
      CostCtrActivityType,
      //      @Semantics.unitOfMeasure: true

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

      case when _Header.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 _Header.WorkCenterLastChangeDateTime end as WorkCenterLastChangeDateTime,

      /* Associations */
      _Header
}
where
  WorkCenterTypeCode = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKCENTERCOSTCENTER",
"R_WORKCENTERTP"
],
"ASSOCIATED":
[
"R_WORKCENTERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More