I_COSTCENTERTP

CDS View

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)

ViewTypeJoinVDMDescription
C_CostCenter view from CONSUMPTION Cost Center Master Record

Fields (101)

KeyField CDS FieldsUsed 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)
);