R_CostCenterTP

DDL: R_COSTCENTERTP Type: view_entity TRANSACTIONAL

Cost Center

R_CostCenterTP is a Transactional CDS View that provides data about "Cost Center" in SAP S/4HANA. It reads from 1 data source (I_CostCenter) and exposes 91 fields with key fields ControllingArea, CostCenter, ValidityEndDate. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CostCenter I_CostCenter from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_CostCenterTextTP _CostCenterTextTP

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Cost Center view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name CostCenter view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view

Fields (91)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea ControllingArea
KEY CostCenter CostCenter
KEY ValidityEndDate ValidityEndDate
ValidityStartDate ValidityStartDate
ControllingAreaForEdit ControllingArea
CostCenterForEdit CostCenter
ValidityEndDateForEdit ValidityEndDate
CostCenterName
CostCenterDescription
IsBlkdForPrimaryCostsPosting
IsBlockedForPlanPrimaryCosts
CompanyCode CompanyCode
BusinessArea BusinessArea
CostCenterCategory CostCenterCategory
CostCtrResponsiblePersonName CostCtrResponsiblePersonName
CostCtrResponsibleUser CostCtrResponsibleUser
CostCenterCurrency CostCenterCurrency
CostingSheet CostingSheet
TaxJurisdiction TaxJurisdiction
ProfitCenter ProfitCenter
Plant Plant
LogicalSystem LogicalSystem
CostCenterCreationDate
CostCenterCreatedByUser
IsBlkdForSecondaryCostsPosting
IsBlockedForRevenuePosting
IsBlockedForCommitmentPosting
IsBlockedForPlanSecondaryCosts
IsBlockedForPlanRevenues
CostCenterAllocationMethod CostCenterAllocationMethod
ConsumptionQtyIsRecorded ConsumptionQtyIsRecorded
Department Department
SubsequentCostCenter SubsequentCostCenter
ConditionUsage ConditionUsage
ConditionApplication ConditionApplication
CostCenterAccountingOverhead CostCenterAccountingOverhead
Country
FormOfAddress FormOfAddress
AddressName
AddressAdditionalName AddressAdditionalName
CostCenterAddrName3 CostCenterAddrName3
CostCenterAddrName4 CostCenterAddrName4
CityName CityName
District District
StreetAddressName StreetAddressName
POBox POBox
PostalCode PostalCode
POBoxPostalCode POBoxPostalCode
Region Region
Language Language
TeleboxNumber TeleboxNumber
PhoneNumber1
PhoneNumber2 PhoneNumber2
FaxNumber FaxNumber
TeletexNumber TeletexNumber
TelexNumber TelexNumber
DataCommunicationPhoneNumber DataCommunicationPhoneNumber
CostCenterPrinterDestination
CostCenterStandardHierArea
CostCollector CostCollector
CostCenterIsComplete CostCenterIsComplete
IsStatisticalCostCenter IsStatisticalCostCenter
ObjectInternalID ObjectInternalID
CostCenterFunction CostCenterFunction
CostCenterAlternativeFunction CostCenterAlternativeFunction
FunctionalArea FunctionalArea
ActyIndepFormulaPlanningTmpl
ActyDepdntFormulaPlanningTmpl
ActyIndependentAllocationTmpl
ActyDependentAllocationTmpl
ActlIndepStatisticalKeyFigures
ActlDepStatisticalKeyFigures
JointVenture JointVenture
JointVentureRecoveryCode JointVentureRecoveryCode
JointVentureEquityType JointVentureEquityType
JointVentureObjectType JointVentureObjectType
JointVentureClass JointVentureClass
JointVentureSubClass JointVentureSubClass
BudgetCarryingCostCenter
AvailabilityControlProfile
AvailabilityControlIsActive
Fund Fund
GrantID GrantID
FundIsFixAssigned FundIsFixAssigned
GrantIDIsFixAssigned GrantIDIsFixAssigned
FunctionalAreaIsFixAssigned FunctionalAreaIsFixAssigned
FinancialManagementArea _CompanyCode FinancialManagementArea
_CostCenterTextTP _CostCenterTextTP
_Region _Region
_Language _Language
_Country _Country
@AccessControl.authorizationCheck: #MANDATORY

@EndUserText.label: 'Cost Center'

@ObjectModel: {
  usageType: {
    serviceQuality: #B,
    sizeCategory: #L,
    dataClass: #MASTER
  },
  semanticKey: [ 'ControllingArea','CostCenter', 'ValidityEndDate' ],
  sapObjectNodeType.name: 'CostCenter'
}

@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}

@Metadata.ignorePropagatedAnnotations: true

define root view entity R_CostCenterTP
  as select from I_CostCenter

  composition [0..*] of R_CostCenterTextTP as _CostCenterTextTP

{
  key ControllingArea,
  key CostCenter,
      @Semantics.businessDate.to: true
  key ValidityEndDate,
      @Semantics.businessDate.from: true
      ValidityStartDate,
      @ObjectModel.editableFieldFor: 'ControllingArea'
      ControllingArea                                                                       as ControllingAreaForEdit,
      @ObjectModel.editableFieldFor: 'CostCenter'
      CostCenter                                                                            as CostCenterForEdit,
      @ObjectModel.editableFieldFor: 'ValidityEndDate'
      ValidityEndDate                                                                       as ValidityEndDateForEdit,
      _Text[1:Language = $session.system_language].CostCenterName,
      _Text[1:Language = $session.system_language].CostCenterDescription,
      @Semantics.booleanIndicator: true
      cast( IsBlkdForPrimaryCostsPosting as fis_cc_bkzkp preserving type )                  as IsBlkdForPrimaryCostsPosting,
      @Semantics.booleanIndicator: true
      cast( IsBlockedForPlanPrimaryCosts as fis_cc_pkzkp preserving type )                  as IsBlockedForPlanPrimaryCosts,
      CompanyCode,
      BusinessArea,
      CostCenterCategory,
      CostCtrResponsiblePersonName,
      CostCtrResponsibleUser,
      CostCenterCurrency,
      CostingSheet,
      TaxJurisdiction,
      ProfitCenter,
      Plant,
      LogicalSystem,
      cast ( CostCenterCreationDate as fis_cc_erfdt preserving type )                       as CostCenterCreationDate,
      cast ( CostCenterCreatedByUser as fis_cc_erfnm preserving type )                      as CostCenterCreatedByUser,
      @Semantics.booleanIndicator: true
      cast ( IsBlkdForSecondaryCostsPosting as fis_cc_bkzks preserving type )               as IsBlkdForSecondaryCostsPosting,
      @Semantics.booleanIndicator: true
      cast ( IsBlockedForRevenuePosting as fis_cc_bkzer preserving type )                   as IsBlockedForRevenuePosting,
      @Semantics.booleanIndicator: true
      cast ( IsBlockedForCommitmentPosting as fis_cc_bkzob preserving type )                as IsBlockedForCommitmentPosting,
      @Semantics.booleanIndicator: true
      cast ( IsBlockedForPlanSecondaryCosts as fis_cc_pkzks preserving type )               as IsBlockedForPlanSecondaryCosts,
      @Semantics.booleanIndicator: true
      cast ( IsBlockedForPlanRevenues as fis_cc_pkzer preserving type )                     as IsBlockedForPlanRevenues,
      CostCenterAllocationMethod,
      @Semantics.booleanIndicator: true
      ConsumptionQtyIsRecorded,
      Department,
      SubsequentCostCenter,
      ConditionUsage,
      ConditionApplication,
      CostCenterAccountingOverhead,
      cast( Country as fis_land1 preserving type )                                          as Country,
      FormOfAddress,
      cast ( AddressName as fco_cc_addressname preserving type )                            as AddressName,
      AddressAdditionalName,
      CostCenterAddrName3,
      CostCenterAddrName4,
      CityName,
      District,
      StreetAddressName,
      POBox,
      PostalCode,
      POBoxPostalCode,
      Region,
      Language,
      TeleboxNumber,
      cast ( PhoneNumber1 as fco_cc_telf1 preserving type )                                 as PhoneNumber1,
      PhoneNumber2,
      FaxNumber,
      TeletexNumber,
      TelexNumber,
      DataCommunicationPhoneNumber,
      cast( CostCenterPrinterDestination as fis_kdnam preserving type )                     as CostCenterPrinterDestination,
      cast ( CostCenterStandardHierArea as fco_cc_khinr preserving type )                   as CostCenterStandardHierArea,
      CostCollector,
      @Semantics.booleanIndicator: true
      CostCenterIsComplete,
      IsStatisticalCostCenter,
      ObjectInternalID,
      CostCenterFunction,
      CostCenterAlternativeFunction,
      FunctionalArea,
      cast ( ActyIndepFormulaPlanningTmpl as fco_cca_templ_cpi preserving type )            as ActyIndepFormulaPlanningTmpl,
      cast ( ActyDepdntFormulaPlanningTmpl as fco_cca_templ_cpd preserving type )           as ActyDepdntFormulaPlanningTmpl,
      cast ( ActyIndependentAllocationTmpl as fco_cca_templ_sci preserving type )           as ActyIndependentAllocationTmpl,
      cast ( ActyDependentAllocationTmpl as fco_cca_templ_scd preserving type )             as ActyDependentAllocationTmpl,
      cast ( ActlIndepStatisticalKeyFigures as fco_cca_templ_ski preserving type )          as ActlIndepStatisticalKeyFigures,
      cast ( ActlDepStatisticalKeyFigures as fco_cca_templ_skd preserving type )            as ActlDepStatisticalKeyFigures,
      JointVenture,
      JointVentureRecoveryCode,
      JointVentureEquityType,
      JointVentureObjectType,
      JointVentureClass,
      JointVentureSubClass,
      cast ( BudgetCarryingCostCenter as fco_budgetcarryingcostcenter preserving type )     as BudgetCarryingCostCenter,
      cast ( AvailabilityControlProfile as fco_budgetavailabilityctrlprof preserving type ) as AvailabilityControlProfile,
      cast ( AvailabilityControlIsActive as fco_availabilityctrlprofisact preserving type ) as AvailabilityControlIsActive,
      Fund,
      GrantID,
      FundIsFixAssigned,
      GrantIDIsFixAssigned,
      FunctionalAreaIsFixAssigned,
      _CompanyCode.FinancialManagementArea,

      case
        when BudgetCarryingCostCenter = CostCenter
          then cast( 'X' as fco_costcenterisbudgetcarrying preserving type )
          else cast( '' as fco_costcenterisbudgetcarrying preserving type )
      end                                                                                   as CostCenterIsBudgetCarrying,

      case( length( ControllingArea ) )
        when 2 then cast( concat_with_space(ControllingArea, CostCenter, 2 ) as cdobjectv )
        when 3 then cast( concat_with_space(ControllingArea, CostCenter, 1 ) as cdobjectv )
        else cast( concat(ControllingArea, CostCenter ) as cdobjectv )
      end                                                                                   as ChangeDocObject,

      /* Associations */
      _CostCenterTextTP,
      _Region,
      _Language,
      _Country
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_COSTCENTER",
"I_COSTCENTERTEXT"
],
"ASSOCIATED":
[
"I_COUNTRY",
"I_LANGUAGE",
"I_REGION",
"R_COSTCENTERTEXTTP"
],
"BASE":
[
"I_COSTCENTER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/