I_COSTCENTERTP
Cost Center Master Record
I_COSTCENTERTP is a CDS View in S/4HANA. Cost Center Master Record. It contains 101 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CostCenter | view | from | CONSUMPTION | Cost Center Master Record |
Fields (101)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ControllingArea | ControllingArea | 1 |
| KEY | CostCenter | CostCenter | 1 |
| KEY | ValidityEndDate | ValidityEndDate | 1 |
| _ActivityBasedCostingTmplCpd | _ActivityBasedCostingTmplCpd | 1 | |
| _ActivityBasedCostingTmplCpi | _ActivityBasedCostingTmplCpi | 1 | |
| _ActivityBasedCostingTmplScd | _ActivityBasedCostingTmplScd | 1 | |
| _ActivityBasedCostingTmplSci | _ActivityBasedCostingTmplSci | 1 | |
| _ActivityBasedCostingTmplSkd | _ActivityBasedCostingTmplSkd | 1 | |
| _ActivityBasedCostingTmplSki | _ActivityBasedCostingTmplSki | 1 | |
| _BusinessArea | _BusinessArea | 1 | |
| _CompanyCode | _CompanyCode | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _ControllingAreaForEdit | _ControllingAreaForEdit | 1 | |
| _CostCenterCategory | _CostCenterCategory | 1 | |
| _CostCenterHierarchyNode | _CostCenterHierarchyNode | 1 | |
| _CostCenterHierNodeForEdit | _CostCenterHierNodeForEdit | 1 | |
| _Country | _Country | 1 | |
| _Currency | _Currency | 1 | |
| _FunctionalArea | _FunctionalArea | 1 | |
| _Language | _Language | 1 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _Region | _Region | 1 | |
| _Text | _Text | 1 | |
| _UserCrtedContactCard | _UserCrtedContactCard | 1 | |
| _UserRespContactCard | _UserRespContactCard | 1 | |
| ActlDepStatisticalKeyFigures | ActlDepStatisticalKeyFigures | 1 | |
| ActlIndepStatisticalKeyFigures | ActlIndepStatisticalKeyFigures | 1 | |
| ActyDepdntFormulaPlanningTmpl | ActyDepdntFormulaPlanningTmpl | 1 | |
| ActyDependentAllocationTmpl | ActyDependentAllocationTmpl | 1 | |
| ActyIndependentAllocationTmpl | ActyIndependentAllocationTmpl | 1 | |
| ActyIndepFormulaPlanningTmpl | ActyIndepFormulaPlanningTmpl | 1 | |
| AddressAdditionalName | AddressAdditionalName | 1 | |
| AddressName | AddressName | 1 | |
| BusinessArea | BusinessArea | 1 | |
| BusinessAreaName | BusinessAreaName | 1 | |
| ChangeDocObject | ChangeDocObject | 1 | |
| CityName | CityName | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CompanyCodeName | CompanyCodeName | 1 | |
| ConsumptionQtyIsRecorded | ConsumptionQtyIsRecorded | 1 | |
| ControllingAreaForEdit | ControllingAreaForEdit | 1 | |
| ControllingAreaName | ControllingAreaName | 1 | |
| CostCenterAddrName3 | CostCenterAddrName3 | 1 | |
| CostCenterAddrName4 | CostCenterAddrName4 | 1 | |
| CostCenterCategory | CostCenterCategory | 1 | |
| CostCenterCategoryName | CostCenterCategoryName | 1 | |
| CostCenterCreatedByUser | CostCenterCreatedByUser | 1 | |
| CostCenterCreationDate | CostCenterCreationDate | 1 | |
| CostCenterCurrency | CostCenterCurrency | 1 | |
| CostCenterDescription | CostCenterDescription | 1 | |
| CostCenterForEdit | CostCenterForEdit | 1 | |
| CostCenterHierarchyRespyArea | CostCenterHierarchyRespyArea | 1 | |
| CostCenterName | CostCenterName | 1 | |
| CostCenterPrinterDestination | CostCenterPrinterDestination | 1 | |
| CostCenterResponsibilityArea | CostCenterResponsibilityArea | 1 | |
| CostCenterStandardHierArea | CostCenterStandardHierArea | 1 | |
| CostCenterValidityPeriod | CostCenterValidityPeriod | 1 | |
| CostCtrResponsiblePersonName | CostCtrResponsiblePersonName | 1 | |
| CostCtrResponsibleUser | CostCtrResponsibleUser | 1 | |
| CostingSheet | CostingSheet | 1 | |
| Country | Country | 1 | |
| CreatedByUserFullName | CreatedByUserFullName | 1 | |
| DataCommunicationPhoneNumber | DataCommunicationPhoneNumber | 1 | |
| Department | Department | 1 | |
| District | District | 1 | |
| FaxNumber | FaxNumber | 1 | |
| FormOfAddress | FormOfAddress | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| FunctionalAreaName | FunctionalAreaName | 1 | |
| IsBlkdForPrimaryCostsPosting | IsBlkdForPrimaryCostsPosting | 1 | |
| IsBlkdForSecondaryCostsPosting | IsBlkdForSecondaryCostsPosting | 1 | |
| IsBlockedForCommitmentPosting | IsBlockedForCommitmentPosting | 1 | |
| IsBlockedForPlanPrimaryCosts | IsBlockedForPlanPrimaryCosts | 1 | |
| IsBlockedForPlanRevenues | IsBlockedForPlanRevenues | 1 | |
| IsBlockedForPlanSecondaryCosts | IsBlockedForPlanSecondaryCosts | 1 | |
| IsBlockedForRevenuePosting | IsBlockedForRevenuePosting | 1 | |
| JointVenture | JointVenture | 1 | |
| JointVentureClass | JointVentureClass | 1 | |
| JointVentureEquityType | JointVentureEquityType | 1 | |
| JointVentureObjectType | JointVentureObjectType | 1 | |
| JointVentureRecoveryCode | JointVentureRecoveryCode | 1 | |
| JointVentureSubClass | JointVentureSubClass | 1 | |
| Language | Language | 1 | |
| LogicalSystem | LogicalSystem | 1 | |
| PhoneNumber1 | PhoneNumber1 | 1 | |
| PhoneNumber2 | PhoneNumber2 | 1 | |
| POBox | POBox | 1 | |
| POBoxPostalCode | POBoxPostalCode | 1 | |
| PostalCode | PostalCode | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ProfitCenterName | ProfitCenterName | 1 | |
| Region | Region | 1 | |
| ResponsibleUserFullName | ResponsibleUserFullName | 1 | |
| StreetAddressName | StreetAddressName | 1 | |
| TaxJurisdiction | TaxJurisdiction | 1 | |
| TeleboxNumber | TeleboxNumber | 1 | |
| TeletexNumber | TeletexNumber | 1 | |
| TelexNumber | TelexNumber | 1 | |
| UxFcCostCenter | UxFcCostCenter | 1 | |
| ValidityEndDateForEdit | ValidityEndDateForEdit | 1 | |
| ValidityStartDate | ValidityStartDate | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Cost Center Master Record
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_COSTCENTERTP (
CONTROLLINGAREA,
COSTCENTER,
VALIDITYENDDATE,
_ACTIVITYBASEDCOSTINGTMPLCPD,
_ACTIVITYBASEDCOSTINGTMPLCPI,
_ACTIVITYBASEDCOSTINGTMPLSCD,
_ACTIVITYBASEDCOSTINGTMPLSCI,
_ACTIVITYBASEDCOSTINGTMPLSKD,
_ACTIVITYBASEDCOSTINGTMPLSKI,
_BUSINESSAREA,
_COMPANYCODE,
_CONTROLLINGAREA,
_CONTROLLINGAREAFOREDIT,
_COSTCENTERCATEGORY,
_COSTCENTERHIERARCHYNODE,
_COSTCENTERHIERNODEFOREDIT,
_COUNTRY,
_CURRENCY,
_FUNCTIONALAREA,
_LANGUAGE,
_PROFITCENTER,
_REGION,
_TEXT,
_USERCRTEDCONTACTCARD,
_USERRESPCONTACTCARD,
ACTLDEPSTATISTICALKEYFIGURES,
ACTLINDEPSTATISTICALKEYFIGURES,
ACTYDEPDNTFORMULAPLANNINGTMPL,
ACTYDEPENDENTALLOCATIONTMPL,
ACTYINDEPENDENTALLOCATIONTMPL,
ACTYINDEPFORMULAPLANNINGTMPL,
ADDRESSADDITIONALNAME,
ADDRESSNAME,
BUSINESSAREA,
BUSINESSAREANAME,
CHANGEDOCOBJECT,
CITYNAME,
COMPANYCODE,
COMPANYCODENAME,
CONSUMPTIONQTYISRECORDED,
CONTROLLINGAREAFOREDIT,
CONTROLLINGAREANAME,
COSTCENTERADDRNAME3,
COSTCENTERADDRNAME4,
COSTCENTERCATEGORY,
COSTCENTERCATEGORYNAME,
COSTCENTERCREATEDBYUSER,
COSTCENTERCREATIONDATE,
COSTCENTERCURRENCY,
COSTCENTERDESCRIPTION,
COSTCENTERFOREDIT,
COSTCENTERHIERARCHYRESPYAREA,
COSTCENTERNAME,
COSTCENTERPRINTERDESTINATION,
COSTCENTERRESPONSIBILITYAREA,
COSTCENTERSTANDARDHIERAREA,
COSTCENTERVALIDITYPERIOD,
COSTCTRRESPONSIBLEPERSONNAME,
COSTCTRRESPONSIBLEUSER,
COSTINGSHEET,
COUNTRY,
CREATEDBYUSERFULLNAME,
DATACOMMUNICATIONPHONENUMBER,
DEPARTMENT,
DISTRICT,
FAXNUMBER,
FORMOFADDRESS,
FUNCTIONALAREA,
FUNCTIONALAREANAME,
ISBLKDFORPRIMARYCOSTSPOSTING,
ISBLKDFORSECONDARYCOSTSPOSTING,
ISBLOCKEDFORCOMMITMENTPOSTING,
ISBLOCKEDFORPLANPRIMARYCOSTS,
ISBLOCKEDFORPLANREVENUES,
ISBLOCKEDFORPLANSECONDARYCOSTS,
ISBLOCKEDFORREVENUEPOSTING,
JOINTVENTURE,
JOINTVENTURECLASS,
JOINTVENTUREEQUITYTYPE,
JOINTVENTUREOBJECTTYPE,
JOINTVENTURERECOVERYCODE,
JOINTVENTURESUBCLASS,
LANGUAGE,
LOGICALSYSTEM,
PHONENUMBER1,
PHONENUMBER2,
POBOX,
POBOXPOSTALCODE,
POSTALCODE,
PROFITCENTER,
PROFITCENTERNAME,
REGION,
RESPONSIBLEUSERFULLNAME,
STREETADDRESSNAME,
TAXJURISDICTION,
TELEBOXNUMBER,
TELETEXNUMBER,
TELEXNUMBER,
UXFCCOSTCENTER,
VALIDITYENDDATEFOREDIT,
VALIDITYSTARTDATE,
PRIMARY KEY (CONTROLLINGAREA, COSTCENTER, VALIDITYENDDATE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA