R_CostCenterTP
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)
| Source | Alias | Join Type |
|---|---|---|
| I_CostCenter | I_CostCenter | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | R_CostCenterTextTP | _CostCenterTextTP | |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA