I_COSTCENTER

CDS View

Cost Center

I_COSTCENTER is a CDS View in S/4HANA. Cost Center. It contains 97 fields. 46 CDS views read from this table.

CDS Views using this table (46)

ViewTypeJoinVDMDescription
A_CostCenter view from BASIC Cost Center
C_CmmdtyHdgPlnExpsrCostCtrVH view from CONSUMPTION Cmmdty Hedge Plan Exposure Cost Center
C_EntProjCostCenterVH view from CONSUMPTION Cost Center
C_FixedAssetOvwCostCenterVH view from CONSUMPTION Cost Center by Company Code Value Help
C_MM_CostCenterValueHelp view from CONSUMPTION Value Help for Cost Center
C_ProjDemandCostCenterVH view from CONSUMPTION Cost Center Value Help
C_PurOrdAccrsEmlTmplCostCtr view from CONSUMPTION E-mail Tmpl for PO Accrs of Cost Center
C_ReExAssignCostCenter view from CONSUMPTION Cost Center
fac_cds_fh_costcenter view from Cost Center in Flexible Hierarchy
fac_cds_uh_costcenter view from Cost Center in Flexible Hierarchy
FAC_COST_CENTER_VH view from Cost Center (Value help)
FAC_DART_Z3_COSTCENTER view from Cost Center Master Data
FINOC_RT_CCR_FILL view inner Orgl Change: Fill Runtime for Cost Cntrs
FINOC_RT_CCR_FILL view from Orgl Change: Fill Runtime for Cost Cntrs
FINOC_RT_CCR_FILL_TIME_SLICED view from Orgl Change: CCTR with prev. time slice
FINOC_RT_CCR_FILL_TIME_SLICED view inner Orgl Change: CCTR with prev. time slice
I_BudgetCarryingCostCenterVH view from BASIC Budget-Carrying Cost Center Value Help
I_CostCenterChangeLog view left_outer COMPOSITE Cost Center Change Log
I_CostCenterForCompanyCode view from BASIC Cost Center For Company Code
I_CostCenterInCompanyCode view_entity from BASIC Cost Center In Company Code
I_CostCenterStdVH view from COMPOSITE Cost Center
I_CostCenterVH view from BASIC Cost Center
I_CurrentCostCenter view from BASIC Current Cost Center
I_EmployeeOp view left_outer BASIC Employee CDS view for OP
I_JointVentureCostCenter view from BASIC Joint Venture Cost Center
I_MM_CostCenterValueHelp view from BASIC Purchasing Cost Center Value Help
I_PRACostCenter view from COMPOSITE PRA Cost Center
I_QltyMgmtPlantCostCenterVH view from COMPOSITE Cost Center By Plant
I_REControllingObject view from COMPOSITE Real Estate Accounting Object
I_SAFTCostCenter view from BASIC SAF-T Cost Centers
I_TripCostCenterVH view from BASIC Material group Value Help
P_CostCenter view from COMPOSITE
P_CostCenterBudget view inner COMPOSITE
P_CostCtrChangeLogCostCenter view union CONSUMPTION
P_CostCtrChangeLogCostCenter view from CONSUMPTION
P_EngmntProjIntcoCostCtrVH view inner CONSUMPTION
P_FuncnlAreaCostCenters view from COMPOSITE WUFAREA Cost Centers
P_FundCostCenters view from COMPOSITE WUFUND Cost Centers
P_GrantCostCenters view from COMPOSITE WUGRANT Cost Centers
P_NextCostCenter view from COMPOSITE
P_PreviousCostCenter view from COMPOSITE
P_WhereUsedCCAccrual view inner COMPOSITE
R_CostCenterTP view_entity from TRANSACTIONAL Cost Center
R_CostCtrValidityPeriodEvent view_entity from TRANSACTIONAL Cost Center Validity Period Business Event
R_EvtBsdPostgRuleCostCenterVH view from COMPOSITE Cost Center
R_EvtBsdPostingRuleReceiverVH view union_all COMPOSITE EB Posting Rule Receiver

Fields (97)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 14
KEY ControllingArea ControllingArea 19
KEY CostCenter BudgetCarryingCostCenter,CostCenter 19
KEY ObjectInternalID ObjectInternalID,ObjectNumber,REAccountingObject 4
KEY ValidityEndDate ValidityEndDate 15
KEY ValidityStartDate ValidityStartDate 14
_ActivityBasedCostingTmplCpd _ActivityBasedCostingTmplCpd 1
_ActivityBasedCostingTmplCpi _ActivityBasedCostingTmplCpi 1
_ActivityBasedCostingTmplScd _ActivityBasedCostingTmplScd 1
_ActivityBasedCostingTmplSci _ActivityBasedCostingTmplSci 1
_ActivityBasedCostingTmplSkd _ActivityBasedCostingTmplSkd 1
_ActivityBasedCostingTmplSki _ActivityBasedCostingTmplSki 1
_AvailabilityCtrlProfile _AvailabilityCtrlProfile 1
_BusinessArea _BusinessArea 3
_CompanyCode _CompanyCode 4
_ControllingArea _ControllingArea 5
_CostCenterCategory _CostCenterCategory 3
_CostCenterHierarchyNode _CostCenterHierarchyNode 2
_CostingSheetProcedure _CostingSheetProcedure 2
_Country _Country 2
_Currency _Currency 2
_FunctionalArea _FunctionalArea 2
_Language _Language 2
_ProfitCenter _ProfitCenter 1
_Region _Region 2
_Text _Text 3
_UserCrtedContactCard _UserCrtedContactCard 3
_UserRespContactCard _UserRespContactCard 3
AddressAdditionalName AddressAdditionalName 2
AddressName AddressName 1
AvailabilityControlIsActive AvailabilityControlIsActive 1
AvailabilityControlProfile AvailabilityControlProfile 3
BudgetCarryingCostCenter BudgetCarryingCostCenter 2
BusinessArea BusinessArea 4
CityName CityName 3
ConditionApplication ConditionApplication 2
ConditionUsage ConditionUsage 2
ConsumptionQtyIsRecorded ConsumptionQtyIsRecorded 2
CostCenterAccountingOverhead CostCenterAccountingOverhead 2
CostCenterAddrName3 CostCenterAddrName3 2
CostCenterAddrName4 CostCenterAddrName4 2
CostCenterAllocationMethod CostCenterAllocationMethod 2
CostCenterAlternativeFunction CostCenterAlternativeFunction 2
CostCenterCategory CostCenterCategory 7
CostCenterCreatedByUser CostCenterCreatedByUser 2
CostCenterCreationDate CostCenterCreationDate 2
CostCenterCurrency CostCenterCurrency 3
CostCenterFunction CostCenterFunction 3
CostCenterIsComplete CostCenterIsComplete 2
CostCenterPrinterDestination CostCenterPrinterDestination 1
CostCenterStandardHierArea CostCenterStandardHierArea 1
CostCollector CostCollector 2
CostCtrResponsiblePersonName CostCtrResponsiblePersonName 7
CostCtrResponsibleUser CostCtrResponsibleUser 5
CostingSheet CostingSheet 2
Country Country 2
DataCommunicationPhoneNumber DataCommunicationPhoneNumber 2
Department Department 3
District District 2
FaxNumber FaxNumber 2
FormOfAddress FormOfAddress 2
FunctionalArea FunctionalArea 3
FunctionalAreaIsFixAssigned FunctionalAreaIsFixAssigned 1
Fund Fund 1
FundIsFixAssigned FundIsFixAssigned 1
GrantID GrantID 1
GrantIDIsFixAssigned GrantIDIsFixAssigned 1
IsBlkdForPrimaryCostsPosting IsBlkdForPrimaryCostsPosting 2
IsBlkdForSecondaryCostsPosting IsBlkdForSecondaryCostsPosting 2
IsBlockedForCommitmentPosting IsBlockedForCommitmentPosting 2
IsBlockedForPlanPrimaryCosts IsBlockedForPlanPrimaryCosts 2
IsBlockedForPlanRevenues IsBlockedForPlanRevenues 2
IsBlockedForPlanSecondaryCosts IsBlockedForPlanSecondaryCosts 2
IsBlockedForRevenuePosting IsBlockedForRevenuePosting 2
IsStatisticalCostCenter IsStatisticalCostCenter 2
JointVenture JointVenture 1
JointVentureClass JointVentureClass 1
JointVentureEquityType JointVentureEquityType 1
JointVentureObjectType JointVentureObjectType 1
JointVentureRecoveryCode JointVentureRecoveryCode 1
JointVentureSubClass JointVentureSubClass 1
Language Language 3
LogicalSystem LogicalSystem 2
PhoneNumber1 PhoneNumber1 1
PhoneNumber2 PhoneNumber2 2
Plant Plant 2
POBox POBox 2
POBoxPostalCode POBoxPostalCode 2
PostalCode PostalCode 2
ProfitCenter ProfitCenter,ProfitCenterBeforeOrglChange,ProfitCenterByOrglChange 6
Region Region 3
StreetAddressName StreetAddressName 2
SubsequentCostCenter SubsequentCostCenter 2
TaxJurisdiction TaxJurisdiction 2
TeleboxNumber TeleboxNumber 2
TeletexNumber TeletexNumber 2
TelexNumber TelexNumber 2

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_COSTCENTER (
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    OBJECTINTERNALID,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    _ACTIVITYBASEDCOSTINGTMPLCPD,
    _ACTIVITYBASEDCOSTINGTMPLCPI,
    _ACTIVITYBASEDCOSTINGTMPLSCD,
    _ACTIVITYBASEDCOSTINGTMPLSCI,
    _ACTIVITYBASEDCOSTINGTMPLSKD,
    _ACTIVITYBASEDCOSTINGTMPLSKI,
    _AVAILABILITYCTRLPROFILE,
    _BUSINESSAREA,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _COSTCENTERCATEGORY,
    _COSTCENTERHIERARCHYNODE,
    _COSTINGSHEETPROCEDURE,
    _COUNTRY,
    _CURRENCY,
    _FUNCTIONALAREA,
    _LANGUAGE,
    _PROFITCENTER,
    _REGION,
    _TEXT,
    _USERCRTEDCONTACTCARD,
    _USERRESPCONTACTCARD,
    ADDRESSADDITIONALNAME,
    ADDRESSNAME,
    AVAILABILITYCONTROLISACTIVE,
    AVAILABILITYCONTROLPROFILE,
    BUDGETCARRYINGCOSTCENTER,
    BUSINESSAREA,
    CITYNAME,
    CONDITIONAPPLICATION,
    CONDITIONUSAGE,
    CONSUMPTIONQTYISRECORDED,
    COSTCENTERACCOUNTINGOVERHEAD,
    COSTCENTERADDRNAME3,
    COSTCENTERADDRNAME4,
    COSTCENTERALLOCATIONMETHOD,
    COSTCENTERALTERNATIVEFUNCTION,
    COSTCENTERCATEGORY,
    COSTCENTERCREATEDBYUSER,
    COSTCENTERCREATIONDATE,
    COSTCENTERCURRENCY,
    COSTCENTERFUNCTION,
    COSTCENTERISCOMPLETE,
    COSTCENTERPRINTERDESTINATION,
    COSTCENTERSTANDARDHIERAREA,
    COSTCOLLECTOR,
    COSTCTRRESPONSIBLEPERSONNAME,
    COSTCTRRESPONSIBLEUSER,
    COSTINGSHEET,
    COUNTRY,
    DATACOMMUNICATIONPHONENUMBER,
    DEPARTMENT,
    DISTRICT,
    FAXNUMBER,
    FORMOFADDRESS,
    FUNCTIONALAREA,
    FUNCTIONALAREAISFIXASSIGNED,
    FUND,
    FUNDISFIXASSIGNED,
    GRANTID,
    GRANTIDISFIXASSIGNED,
    ISBLKDFORPRIMARYCOSTSPOSTING,
    ISBLKDFORSECONDARYCOSTSPOSTING,
    ISBLOCKEDFORCOMMITMENTPOSTING,
    ISBLOCKEDFORPLANPRIMARYCOSTS,
    ISBLOCKEDFORPLANREVENUES,
    ISBLOCKEDFORPLANSECONDARYCOSTS,
    ISBLOCKEDFORREVENUEPOSTING,
    ISSTATISTICALCOSTCENTER,
    JOINTVENTURE,
    JOINTVENTURECLASS,
    JOINTVENTUREEQUITYTYPE,
    JOINTVENTUREOBJECTTYPE,
    JOINTVENTURERECOVERYCODE,
    JOINTVENTURESUBCLASS,
    LANGUAGE,
    LOGICALSYSTEM,
    PHONENUMBER1,
    PHONENUMBER2,
    PLANT,
    POBOX,
    POBOXPOSTALCODE,
    POSTALCODE,
    PROFITCENTER,
    REGION,
    STREETADDRESSNAME,
    SUBSEQUENTCOSTCENTER,
    TAXJURISDICTION,
    TELEBOXNUMBER,
    TELETEXNUMBER,
    TELEXNUMBER,
    PRIMARY KEY (COMPANYCODE, CONTROLLINGAREA, COSTCENTER, OBJECTINTERNALID, VALIDITYENDDATE, VALIDITYSTARTDATE)
);