I_CostCenterInCompanyCode

DDL: I_COSTCENTERINCOMPANYCODE Type: view_entity BASIC

Cost Center In Company Code

I_CostCenterInCompanyCode (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cost Center · Accounting and Financial Close

I_CostCenterInCompanyCode is a Basic CDS View (Dimension) that provides data about "Cost Center In Company Code" in SAP S/4HANA. It reads from 1 data source (I_CostCenter) and exposes 21 fields with key fields CompanyCode, CostCenter, ValidityEndDate.

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-FIO-GL-IS
CapabilitiesAnalytical Dimension, Association Target for Defining CDS Entities, Data Source in SQL Select
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_CostCenter I_CostCenter from

Annotations (16)

NameValueLevelField
Analytics.internalName #LOCAL view
Analytics.dataCategory #DIMENSION view
ObjectModel.representativeKey CostCenter view
ObjectModel.sapObjectNodeType.name CostCenter view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Cost Center In Company Code view
VDM.viewType #BASIC view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view
Consumption.ranked true view
Consumption.filter.businessDate.at true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CostCenter CompanyCode Receiver Company Code
KEY CostCenter I_CostCenter CostCenter Cost Center
KEY ValidityEndDate I_CostCenter ValidityEndDate Valid To Date
ValidityStartDate I_CostCenter ValidityStartDate Validity Start Date
ControllingArea I_CostCenter ControllingArea Controlling Area
IsBlkdForPrimaryCostsPosting I_CostCenter IsBlkdForPrimaryCostsPosting Lock Indicator for Actual Primary Postings
IsBlockedForPlanPrimaryCosts I_CostCenter IsBlockedForPlanPrimaryCosts Lock Indicator for Plan Primary Costs
CostCenterCategory I_CostCenter CostCenterCategory Cost Center Category
CostCtrResponsibleUser I_CostCenter CostCtrResponsibleUser User Responsible
CostCenterCreationDate I_CostCenter CostCenterCreationDate Created On
CostCenterCreatedByUser I_CostCenter CostCenterCreatedByUser Created By
IsBlkdForSecondaryCostsPosting I_CostCenter IsBlkdForSecondaryCostsPosting Lock Indicator for Actual Secondary Costs
IsBlockedForRevenuePosting I_CostCenter IsBlockedForRevenuePosting Lock Indicator for Actual Revenue Postings
IsBlockedForCommitmentPosting I_CostCenter IsBlockedForCommitmentPosting Lock Indicator for Commitment Update
IsBlockedForPlanSecondaryCosts I_CostCenter IsBlockedForPlanSecondaryCosts Lock Indicator for Plan Secondary Costs
IsBlockedForPlanRevenues I_CostCenter IsBlockedForPlanRevenues Lock Indicator for Planning Revenues
_CompanyCode I_CostCenter _CompanyCode
_ControllingArea I_CostCenter _ControllingArea
_CostCenterCategory I_CostCenter _CostCenterCategory
_UserCrtedContactCard I_CostCenter _UserCrtedContactCard
_UserRespContactCard I_CostCenter _UserRespContactCard

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CostCenterInCompanyCode.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_CostCenterInCompanyCode AS
SELECT
  I_CostCenter.CompanyCode AS CompanyCode,
  I_CostCenter.CostCenter AS CostCenter,
  I_CostCenter.ValidityEndDate AS ValidityEndDate,
  I_CostCenter.ValidityStartDate AS ValidityStartDate,
  I_CostCenter.ControllingArea AS ControllingArea,
  I_CostCenter.IsBlkdForPrimaryCostsPosting AS IsBlkdForPrimaryCostsPosting,
  I_CostCenter.IsBlockedForPlanPrimaryCosts AS IsBlockedForPlanPrimaryCosts,
  I_CostCenter.CostCenterCategory AS CostCenterCategory,
  I_CostCenter.CostCtrResponsibleUser AS CostCtrResponsibleUser,
  I_CostCenter.CostCenterCreationDate AS CostCenterCreationDate,
  I_CostCenter.CostCenterCreatedByUser AS CostCenterCreatedByUser,
  I_CostCenter.IsBlkdForSecondaryCostsPosting AS IsBlkdForSecondaryCostsPosting,
  I_CostCenter.IsBlockedForRevenuePosting AS IsBlockedForRevenuePosting,
  I_CostCenter.IsBlockedForCommitmentPosting AS IsBlockedForCommitmentPosting,
  I_CostCenter.IsBlockedForPlanSecondaryCosts AS IsBlockedForPlanSecondaryCosts,
  I_CostCenter.IsBlockedForPlanRevenues AS IsBlockedForPlanRevenues,
  I_CostCenter._CompanyCode AS _CompanyCode,
  I_CostCenter._ControllingArea AS _ControllingArea,
  I_CostCenter._CostCenterCategory AS _CostCenterCategory,
  I_CostCenter._UserCrtedContactCard AS _UserCrtedContactCard,
  I_CostCenter._UserRespContactCard AS _UserRespContactCard
FROM I_CostCenter
;