What is I_CostCenterForCompanyCode in SAP S/4HANA?

I_CostCenterForCompanyCode is a basic CDS view in SAP S/4HANA. Cost Center For Company Code It contains 92 fields.

Which tables does I_CostCenterForCompanyCode read from?

I_CostCenterForCompanyCode reads data from: I_CostCenter.

What VDM layer is I_CostCenterForCompanyCode?

I_CostCenterForCompanyCode is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_CostCenterForCompanyCode

DDL: I_COSTCENTERFORCOMPANYCODE SQL: IFICCTRBUKRS Type: view BASIC

92 Fields 1 Data Sources 2 Associations

Cost Center For Company Code

I_CostCenterForCompanyCode is a Basic CDS View (Dimension) that provides data about "Cost Center For Company Code" in SAP S/4HANA. It reads from 1 data source (I_CostCenter) and exposes 92 fields with key fields CompanyCode, CostCenter, ValidityEndDate. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_CostCenter	I_CostCenter	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	I_CostCenter	_CostCenter	`$projection.ControllingArea = _CostCenter.ControllingArea and $projection.CostCenter = _CostCenter.CostCenter and $projection.ValidityEndDate = _CostCenter.ValidityEndDate`
[1..1]	E_CostCenter	_Extension	`$projection.ControllingArea = _Extension.ControllingArea and $projection.CostCenter = _Extension.CostCenter and $projection.ValidityEndDate = _Extension.ValidityEndDate`

Annotations (17)

Name	Value	Level
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
AbapCatalog.sqlViewName	IFICCTRBUKRS	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Cost Center For Company Code	view
Analytics.dataCategory	#DIMENSION	view
ObjectModel.representativeKey	CostCenter	view
AccessControl.personalData.blocking	#REQUIRED	view
Metadata.allowExtensions	true	view
VDM.viewType	#BASIC	view
ObjectModel.usageType.dataClass	#ORGANIZATIONAL	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Search.searchable	true	view
Consumption.filter.businessDate.at	true	view

Fields (92)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	I_CostCenter	CompanyCode	Receiver Company Code
KEY	CostCenter	I_CostCenter	CostCenter	Cost Center
KEY	ValidityEndDate	I_CostCenter	ValidityEndDate	ValidTo
	ControllingArea	I_CostCenter	ControllingArea	Controlling Area
	ValidityStartDate	I_CostCenter	ValidityStartDate	Validity Start Date
	IsBlkdForPrimaryCostsPosting	I_CostCenter	IsBlkdForPrimaryCostsPosting	Lock Primary Costs Posting
	IsBlockedForPlanPrimaryCosts	I_CostCenter	IsBlockedForPlanPrimaryCosts	Lock Primary Costs Planning
	BusinessArea	I_CostCenter	BusinessArea	Business Area
	CostCenterCategory	I_CostCenter	CostCenterCategory	CCtr Category
	CostCtrResponsiblePersonName	I_CostCenter	CostCtrResponsiblePersonName	Person Resp.
	CostCtrResponsibleUser	I_CostCenter	CostCtrResponsibleUser	User Responsible
	CostCenterCurrency	I_CostCenter	CostCenterCurrency	Currency
	CostingSheet	I_CostCenter	CostingSheet	Costing Sheet
	TaxJurisdiction	I_CostCenter	TaxJurisdiction	Tax Jurisdiction
	ProfitCenter	I_CostCenter	ProfitCenter	Profit Center
	Plant	I_CostCenter	Plant	Valuation Area
	LogicalSystem	I_CostCenter	LogicalSystem	Logical System
	CostCenterCreationDate	I_CostCenter	CostCenterCreationDate	Created On
	CostCenterCreatedByUser	I_CostCenter	CostCenterCreatedByUser	Created By
	IsBlkdForSecondaryCostsPosting	I_CostCenter	IsBlkdForSecondaryCostsPosting	Lock Secondary Costs Posting
	IsBlockedForRevenuePosting	I_CostCenter	IsBlockedForRevenuePosting	Lock Revenue Posting
	IsBlockedForCommitmentPosting	I_CostCenter	IsBlockedForCommitmentPosting	Lock Commitment Updates
	IsBlockedForPlanSecondaryCosts	I_CostCenter	IsBlockedForPlanSecondaryCosts	Lock Secondary Costs Planning
	IsBlockedForPlanRevenues	I_CostCenter	IsBlockedForPlanRevenues	Lock Revenue Planning
	CostCenterAllocationMethod	I_CostCenter	CostCenterAllocationMethod	Alloc. Methods
	ConsumptionQtyIsRecorded	I_CostCenter	ConsumptionQtyIsRecorded	Record Quantity
	Department	I_CostCenter	Department	Department
	SubsequentCostCenter	I_CostCenter	SubsequentCostCenter	Subseq.CCtr
	ConditionUsage	I_CostCenter	ConditionUsage	Usage
	ConditionApplication	I_CostCenter	ConditionApplication	Application
	CostCenterAccountingOverhead	I_CostCenter	CostCenterAccountingOverhead	Overhead Key
	Country	I_CostCenter	Country	Venue: Ctry/Reg
	FormOfAddress	I_CostCenter	FormOfAddress	Title Key
	AddressName	I_CostCenter	AddressName	Name
	AddressAdditionalName	I_CostCenter	AddressAdditionalName	Name 2
	CostCenterAddrName3	I_CostCenter	CostCenterAddrName3	Name 3
	CostCenterAddrName4	I_CostCenter	CostCenterAddrName4	Name 4
	CityName	I_CostCenter	CityName	Name
	District	I_CostCenter	District	District Court
	StreetAddressName	I_CostCenter	StreetAddressName	Street
	POBox	I_CostCenter	POBox	PO Box
	PostalCode	I_CostCenter	PostalCode	Postal Code
	POBoxPostalCode	I_CostCenter	POBoxPostalCode	PO Box Postal Code
	Region	I_CostCenter	Region	Venue Region
	Language	I_CostCenter	Language	Report Text Language
	TeleboxNumber	I_CostCenter	TeleboxNumber	Telebox Number
	PhoneNumber1	I_CostCenter	PhoneNumber1	Telephone 1
	PhoneNumber2	I_CostCenter	PhoneNumber2	Telephone 2
	FaxNumber	I_CostCenter	FaxNumber	Fax Number
	TeletexNumber	I_CostCenter	TeletexNumber	Teletex Number
	TelexNumber	I_CostCenter	TelexNumber	Telex Number
	DataCommunicationPhoneNumber	I_CostCenter	DataCommunicationPhoneNumber	Data Line
	CostCenterPrinterDestination	I_CostCenter	CostCenterPrinterDestination	Printer Destination
	CostCenterStandardHierArea	I_CostCenter	CostCenterStandardHierArea	Standard Hierarchy Node
	CostCollector	I_CostCenter	CostCollector	Cost Collector
	CostCenterIsComplete	I_CostCenter	CostCenterIsComplete	Complete
	IsStatisticalCostCenter	I_CostCenter	IsStatisticalCostCenter	Cost Center Is Stat.
	ObjectInternalID	I_CostCenter	ObjectInternalID	Object number
	CostCenterFunction	I_CostCenter	CostCenterFunction	Function
	CostCenterAlternativeFunction	I_CostCenter	CostCenterAlternativeFunction	Alt. Function
	FunctionalArea	I_CostCenter	FunctionalArea	Sendr Fctl Area
	JointVenture	I_CostCenter	JointVenture	Joint venture
	JointVentureRecoveryCode	I_CostCenter	JointVentureRecoveryCode	Recovery Ind.
	JointVentureEquityType	I_CostCenter	JointVentureEquityType	Joint Venture Equity Type
	JointVentureObjectType	I_CostCenter	JointVentureObjectType	JV Object Type
	JointVentureClass	I_CostCenter	JointVentureClass	JIB/JIBE Class
	JointVentureSubClass	I_CostCenter	JointVentureSubClass	JIB/JIBE SbClsA
	BudgetCarryingCostCenter	I_CostCenter	BudgetCarryingCostCenter	Budget-Carrying Cost Center
	AvailabilityControlProfile	I_CostCenter	AvailabilityControlProfile	Budget Availability Control Profile
	AvailabilityControlIsActive	I_CostCenter	AvailabilityControlIsActive	Budget Availability Control is Active
	Fund	I_CostCenter	Fund	Sender Fund
	GrantID	I_CostCenter	GrantID	Sender Grant
	FundIsFixAssigned	I_CostCenter	FundIsFixAssigned	Fund Fixed Assignment
	GrantIDIsFixAssigned	I_CostCenter	GrantIDIsFixAssigned	Grant Fixed Assignment
	FunctionalAreaIsFixAssigned	I_CostCenter	FunctionalAreaIsFixAssigned	Functional Area Fixed Assignment
	_CostCenter		_CostCenter
	_AvailabilityCtrlProfile	I_CostCenter	_AvailabilityCtrlProfile
	_BusinessArea	I_CostCenter	_BusinessArea
	_CompanyCode	I_CostCenter	_CompanyCode
	_ControllingArea	I_CostCenter	_ControllingArea
	_CostCenterCategory	I_CostCenter	_CostCenterCategory
	_CostCenterHierarchyNode	I_CostCenter	_CostCenterHierarchyNode
	_CostingSheetProcedure	I_CostCenter	_CostingSheetProcedure
	_Country	I_CostCenter	_Country
	_Currency	I_CostCenter	_Currency
	_FunctionalArea	I_CostCenter	_FunctionalArea
	_Language	I_CostCenter	_Language
	_ProfitCenter	I_CostCenter	_ProfitCenter
	_Region	I_CostCenter	_Region
	_Text	I_CostCenter	_Text
	_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_CostCenterForCompanyCode.
-- 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.
-- SQL view name: IFICCTRBUKRS

CREATE VIEW I_CostCenterForCompanyCode AS
SELECT
  I_CostCenter.CompanyCode AS CompanyCode,
  I_CostCenter.CostCenter AS CostCenter,
  I_CostCenter.ValidityEndDate AS ValidityEndDate,
  I_CostCenter.ControllingArea AS ControllingArea,
  I_CostCenter.ValidityStartDate AS ValidityStartDate,
  I_CostCenter.IsBlkdForPrimaryCostsPosting AS IsBlkdForPrimaryCostsPosting,
  I_CostCenter.IsBlockedForPlanPrimaryCosts AS IsBlockedForPlanPrimaryCosts,
  I_CostCenter.BusinessArea AS BusinessArea,
  I_CostCenter.CostCenterCategory AS CostCenterCategory,
  I_CostCenter.CostCtrResponsiblePersonName AS CostCtrResponsiblePersonName,
  I_CostCenter.CostCtrResponsibleUser AS CostCtrResponsibleUser,
  I_CostCenter.CostCenterCurrency AS CostCenterCurrency,
  I_CostCenter.CostingSheet AS CostingSheet,
  I_CostCenter.TaxJurisdiction AS TaxJurisdiction,
  I_CostCenter.ProfitCenter AS ProfitCenter,
  I_CostCenter.Plant AS Plant,
  I_CostCenter.LogicalSystem AS LogicalSystem,
  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.CostCenterAllocationMethod AS CostCenterAllocationMethod,
  I_CostCenter.ConsumptionQtyIsRecorded AS ConsumptionQtyIsRecorded,
  I_CostCenter.Department AS Department,
  I_CostCenter.SubsequentCostCenter AS SubsequentCostCenter,
  I_CostCenter.ConditionUsage AS ConditionUsage,
  I_CostCenter.ConditionApplication AS ConditionApplication,
  I_CostCenter.CostCenterAccountingOverhead AS CostCenterAccountingOverhead,
  I_CostCenter.Country AS Country,
  I_CostCenter.FormOfAddress AS FormOfAddress,
  I_CostCenter.AddressName AS AddressName,
  I_CostCenter.AddressAdditionalName AS AddressAdditionalName,
  I_CostCenter.CostCenterAddrName3 AS CostCenterAddrName3,
  I_CostCenter.CostCenterAddrName4 AS CostCenterAddrName4,
  I_CostCenter.CityName AS CityName,
  I_CostCenter.District AS District,
  I_CostCenter.StreetAddressName AS StreetAddressName,
  I_CostCenter.POBox AS POBox,
  I_CostCenter.PostalCode AS PostalCode,
  I_CostCenter.POBoxPostalCode AS POBoxPostalCode,
  I_CostCenter.Region AS Region,
  I_CostCenter.Language AS Language,
  I_CostCenter.TeleboxNumber AS TeleboxNumber,
  I_CostCenter.PhoneNumber1 AS PhoneNumber1,
  I_CostCenter.PhoneNumber2 AS PhoneNumber2,
  I_CostCenter.FaxNumber AS FaxNumber,
  I_CostCenter.TeletexNumber AS TeletexNumber,
  I_CostCenter.TelexNumber AS TelexNumber,
  I_CostCenter.DataCommunicationPhoneNumber AS DataCommunicationPhoneNumber,
  I_CostCenter.CostCenterPrinterDestination AS CostCenterPrinterDestination,
  I_CostCenter.CostCenterStandardHierArea AS CostCenterStandardHierArea,
  I_CostCenter.CostCollector AS CostCollector,
  I_CostCenter.CostCenterIsComplete AS CostCenterIsComplete,
  I_CostCenter.IsStatisticalCostCenter AS IsStatisticalCostCenter,
  I_CostCenter.ObjectInternalID AS ObjectInternalID,
  I_CostCenter.CostCenterFunction AS CostCenterFunction,
  I_CostCenter.CostCenterAlternativeFunction AS CostCenterAlternativeFunction,
  I_CostCenter.FunctionalArea AS FunctionalArea,
  I_CostCenter.JointVenture AS JointVenture,
  I_CostCenter.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  I_CostCenter.JointVentureEquityType AS JointVentureEquityType,
  I_CostCenter.JointVentureObjectType AS JointVentureObjectType,
  I_CostCenter.JointVentureClass AS JointVentureClass,
  I_CostCenter.JointVentureSubClass AS JointVentureSubClass,
  I_CostCenter.BudgetCarryingCostCenter AS BudgetCarryingCostCenter,
  I_CostCenter.AvailabilityControlProfile AS AvailabilityControlProfile,
  I_CostCenter.AvailabilityControlIsActive AS AvailabilityControlIsActive,
  I_CostCenter.Fund AS Fund,
  I_CostCenter.GrantID AS GrantID,
  I_CostCenter.FundIsFixAssigned AS FundIsFixAssigned,
  I_CostCenter.GrantIDIsFixAssigned AS GrantIDIsFixAssigned,
  I_CostCenter.FunctionalAreaIsFixAssigned AS FunctionalAreaIsFixAssigned,
  I_CostCenter._AvailabilityCtrlProfile AS _AvailabilityCtrlProfile,
  I_CostCenter._BusinessArea AS _BusinessArea,
  I_CostCenter._CompanyCode AS _CompanyCode,
  I_CostCenter._ControllingArea AS _ControllingArea,
  I_CostCenter._CostCenterCategory AS _CostCenterCategory,
  I_CostCenter._CostCenterHierarchyNode AS _CostCenterHierarchyNode,
  I_CostCenter._CostingSheetProcedure AS _CostingSheetProcedure,
  I_CostCenter._Country AS _Country,
  I_CostCenter._Currency AS _Currency,
  I_CostCenter._FunctionalArea AS _FunctionalArea,
  I_CostCenter._Language AS _Language,
  I_CostCenter._ProfitCenter AS _ProfitCenter,
  I_CostCenter._Region AS _Region,
  I_CostCenter._Text AS _Text,
  I_CostCenter._UserCrtedContactCard AS _UserCrtedContactCard,
  I_CostCenter._UserRespContactCard AS _UserRespContactCard
FROM I_CostCenter
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter AND ValidityEndDate = _CostCenter.ValidityEndDate  -- association [1..1]
LEFT OUTER JOIN E_CostCenter AS _Extension ON ControllingArea = _Extension.ControllingArea AND CostCenter = _Extension.CostCenter AND ValidityEndDate = _Extension.ValidityEndDate  -- association [1..1]
;

Depth:

I_CostCenterForCompanyCode view

I_CostCenter view