I_CostCenterTP_2

DDL: I_COSTCENTERTP_2 Type: view_entity TRANSACTIONAL
80 Fields 1 Data Sources

Cost Center

I_CostCenterTP_2 is a Transactional CDS View that provides data about "Cost Center" in SAP S/4HANA. It reads from 1 data source (R_CostCenterTP) and exposes 80 fields with key fields ControllingArea, CostCenter, ValidityEndDate.

Data Sources (1)

SourceAliasJoin Type
R_CostCenterTP R_CostCenterTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Cost Center view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.sapObjectNodeType.name CostCenter view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view

Fields (80)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea ControllingArea Controlling Area
KEY CostCenter CostCenter Cost Center
KEY ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
ControllingAreaForEdit ControllingAreaForEdit Controlling Area
CostCenterForEdit CostCenterForEdit Cost Center
ValidityEndDateForEdit ValidityEndDateForEdit Valid To
CostCenterName CostCenterName Name
CostCenterDescription CostCenterDescription Description
IsBlkdForPrimaryCostsPosting IsBlkdForPrimaryCostsPosting Lock Primary Costs Posting
IsBlockedForPlanPrimaryCosts IsBlockedForPlanPrimaryCosts Lock Primary Costs Planning
CompanyCode CompanyCode Receiver Company Code
BusinessArea BusinessArea Business Area
CostCenterCategory CostCenterCategory CCtr Category
CostCtrResponsiblePersonName CostCtrResponsiblePersonName Person Resp.
CostCtrResponsibleUser CostCtrResponsibleUser User Responsible
CostCenterCurrency CostCenterCurrency Currency
CostingSheet CostingSheet Costing Sheet
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
ProfitCenter ProfitCenter Profit Center
Plant Plant Valuation Area
LogicalSystem LogicalSystem Logical System
CostCenterCreationDate CostCenterCreationDate Created On
CostCenterCreatedByUser CostCenterCreatedByUser Created By
IsBlkdForSecondaryCostsPosting IsBlkdForSecondaryCostsPosting Lock Secondary Costs Posting
IsBlockedForRevenuePosting IsBlockedForRevenuePosting Lock Revenue Posting
IsBlockedForCommitmentPosting IsBlockedForCommitmentPosting Lock Commitment Updates
IsBlockedForPlanSecondaryCosts IsBlockedForPlanSecondaryCosts Lock Secondary Costs Planning
IsBlockedForPlanRevenues IsBlockedForPlanRevenues Lock Revenue Planning
CostCenterAllocationMethod CostCenterAllocationMethod Alloc. Methods
ConsumptionQtyIsRecorded ConsumptionQtyIsRecorded Record Quantity
Department Department Department
Country Country Venue: Ctry/Reg
FormOfAddress FormOfAddress Title Key
AddressName AddressName Name
AddressAdditionalName AddressAdditionalName Name 2
CostCenterAddrName3 CostCenterAddrName3 Name 3
CostCenterAddrName4 CostCenterAddrName4 Name 4
CityName CityName Name
District District District Court
StreetAddressName StreetAddressName Street
POBox POBox PO Box
PostalCode PostalCode Postal Code
POBoxPostalCode POBoxPostalCode PO Box Postal Code
Region Region Venue Region
Language Language Report Text Language
TeleboxNumber TeleboxNumber Telebox Number
PhoneNumber1 PhoneNumber1 Telephone 1
PhoneNumber2 PhoneNumber2 Telephone 2
FaxNumber FaxNumber Fax Number
TeletexNumber TeletexNumber Teletex Number
TelexNumber TelexNumber Telex Number
DataCommunicationPhoneNumber DataCommunicationPhoneNumber Data Line
CostCenterPrinterDestination CostCenterPrinterDestination Printer Destination
CostCenterStandardHierArea CostCenterStandardHierArea Standard Hierarchy Node
CostCenterFunction CostCenterFunction Function
CostCenterAlternativeFunction CostCenterAlternativeFunction Alt. Function
FunctionalArea FunctionalArea Sendr Fctl Area
ActyIndepFormulaPlanningTmpl ActyIndepFormulaPlanningTmpl Act. Indep. Formula Planning Template
ActyDepdntFormulaPlanningTmpl ActyDepdntFormulaPlanningTmpl Act. Depen. Formula Planning Template
ActyIndependentAllocationTmpl ActyIndependentAllocationTmpl Activity Independent Allocation Template
ActyDependentAllocationTmpl ActyDependentAllocationTmpl Activity Dependent Allocation Template
ActlIndepStatisticalKeyFigures ActlIndepStatisticalKeyFigures Act. Indep. Statistical Key Figure Tmp.
ActlDepStatisticalKeyFigures ActlDepStatisticalKeyFigures Act. Dep. Statistical Key Figure Tmp.
JointVenture JointVenture Joint venture
JointVentureRecoveryCode JointVentureRecoveryCode Recovery Ind.
JointVentureEquityType JointVentureEquityType Joint Venture Equity Type
JointVentureObjectType JointVentureObjectType JV Object Type
JointVentureClass JointVentureClass JIB/JIBE Class
JointVentureSubClass JointVentureSubClass JIB/JIBE SbClsA
BudgetCarryingCostCenter BudgetCarryingCostCenter Budget-Carrying Cost Center
AvailabilityControlProfile AvailabilityControlProfile Budget Availability Control Profile
AvailabilityControlIsActive AvailabilityControlIsActive Budget Availability Control is Active
Fund Fund Sender Fund
GrantID GrantID Sender Grant
FundIsFixAssigned FundIsFixAssigned Fund Fixed Assignment
GrantIDIsFixAssigned GrantIDIsFixAssigned Grant Fixed Assignment
FunctionalAreaIsFixAssigned FunctionalAreaIsFixAssigned Functional Area Fixed Assignment
CostCenterIsBudgetCarrying CostCenterIsBudgetCarrying Is Budget Carrying
ChangeDocObject ChangeDocObject Object Value

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_CostCenterTP_2.
-- 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_CostCenterTP_2 AS
SELECT
  ControllingArea,
  CostCenter,
  ValidityEndDate,
  ValidityStartDate,
  ControllingAreaForEdit,
  CostCenterForEdit,
  ValidityEndDateForEdit,
  CostCenterName,
  CostCenterDescription,
  IsBlkdForPrimaryCostsPosting,
  IsBlockedForPlanPrimaryCosts,
  CompanyCode,
  BusinessArea,
  CostCenterCategory,
  CostCtrResponsiblePersonName,
  CostCtrResponsibleUser,
  CostCenterCurrency,
  CostingSheet,
  TaxJurisdiction,
  ProfitCenter,
  Plant,
  LogicalSystem,
  CostCenterCreationDate,
  CostCenterCreatedByUser,
  IsBlkdForSecondaryCostsPosting,
  IsBlockedForRevenuePosting,
  IsBlockedForCommitmentPosting,
  IsBlockedForPlanSecondaryCosts,
  IsBlockedForPlanRevenues,
  CostCenterAllocationMethod,
  ConsumptionQtyIsRecorded,
  Department,
  Country,
  FormOfAddress,
  AddressName,
  AddressAdditionalName,
  CostCenterAddrName3,
  CostCenterAddrName4,
  CityName,
  District,
  StreetAddressName,
  POBox,
  PostalCode,
  POBoxPostalCode,
  Region,
  Language,
  TeleboxNumber,
  PhoneNumber1,
  PhoneNumber2,
  FaxNumber,
  TeletexNumber,
  TelexNumber,
  DataCommunicationPhoneNumber,
  CostCenterPrinterDestination,
  CostCenterStandardHierArea,
  CostCenterFunction,
  CostCenterAlternativeFunction,
  FunctionalArea,
  ActyIndepFormulaPlanningTmpl,
  ActyDepdntFormulaPlanningTmpl,
  ActyIndependentAllocationTmpl,
  ActyDependentAllocationTmpl,
  ActlIndepStatisticalKeyFigures,
  ActlDepStatisticalKeyFigures,
  JointVenture,
  JointVentureRecoveryCode,
  JointVentureEquityType,
  JointVentureObjectType,
  JointVentureClass,
  JointVentureSubClass,
  BudgetCarryingCostCenter,
  AvailabilityControlProfile,
  AvailabilityControlIsActive,
  Fund,
  GrantID,
  FundIsFixAssigned,
  GrantIDIsFixAssigned,
  FunctionalAreaIsFixAssigned,
  CostCenterIsBudgetCarrying,
  ChangeDocObject
FROM R_CostCenterTP
;

Learn More