I_CostCenterTP

DDL: I_COSTCENTERTP SQL: IFICOSTCENTERTP Type: view TRANSACTIONAL Package: ODATA_COST_CENTER_V2

Cost Center Master Record

I_CostCenterTP is a Transactional CDS View that provides data about "Cost Center Master Record" in SAP S/4HANA. It reads from 1 data source (P_CostCenter) and exposes 136 fields with key fields ControllingArea, CostCenter, ValidityEndDate. It has 4 associations to related views. Part of development package ODATA_COST_CENTER_V2.

Data Sources (1)

SourceAliasJoin Type
P_CostCenter P_CostCenter from

Associations (4)

CardinalityTargetAliasCondition
[1] I_ControllingArea _ControllingAreaForEdit $projection.ControllingAreaForEdit = _ControllingAreaForEdit.ControllingArea
[0..*] I_CostCenterHierarchyNode _CostCenterHierNodeForEdit $projection.ControllingAreaForEdit = _CostCenterHierNodeForEdit.ControllingArea and $projection.CostCenterForEdit = _CostCenterHierNodeForEdit.CostCenter
[1..*] I_CostCenterLabelTP _CostCenterLabel $projection.ControllingArea = _CostCenterLabel.ControllingArea and $projection.CostCenter = _CostCenterLabel.CostCenter and $projection.ValidityEndDate = _CostCenterLabel.ValidityEndDate
[1..1] E_CostCenter _Extension $projection.ControllingArea = _Extension.ControllingArea and $projection.CostCenter = _Extension.CostCenter and $projection.ValidityEndDate = _Extension.ValidityEndDate

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName IFICOSTCENTERTP view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.compositionRoot true view
ObjectModel.draftEnabled true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence CSKS_DRAFT view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.entityChangeStateId EXTERNAL_CALCULATION view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Cost Center Master Record view

Fields (136)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea P_CostCenter ControllingArea Controlling Area
KEY CostCenter P_CostCenter CostCenter Cost Center
KEY ValidityEndDate P_CostCenter ValidityEndDate ValidTo
ControllingAreaForEdit P_CostCenter ControllingArea Controlling Area
CostCenterForEdit P_CostCenter CostCenter Cost Center
ValidityEndDateForEdit P_CostCenter ValidityEndDate ValidTo
ValidityStartDate P_CostCenter ValidityStartDate Validity Start Date
CostCenterName P_CostCenter CostCenterName Name
CostCenterDescription P_CostCenter CostCenterDescription Description
IsBlkdForPrimaryCostsPosting P_CostCenter IsBlkdForPrimaryCostsPosting Lock Primary Costs Posting
IsBlockedForPlanPrimaryCosts P_CostCenter IsBlockedForPlanPrimaryCosts Lock Primary Costs Planning
CompanyCode P_CostCenter CompanyCode Receiver Company Code
BusinessArea P_CostCenter BusinessArea Business Area
CostCenterCategory P_CostCenter CostCenterCategory CCtr Category
CostCtrResponsiblePersonName P_CostCenter CostCtrResponsiblePersonName Person Resp.
CostCtrResponsibleUser P_CostCenter CostCtrResponsibleUser User Responsible
CostCenterCurrency P_CostCenter CostCenterCurrency Currency
CostingSheet P_CostCenter CostingSheet Costing Sheet
TaxJurisdiction P_CostCenter TaxJurisdiction Tax Jurisdiction
ProfitCenter P_CostCenter ProfitCenter Profit Center
Plant P_CostCenter Plant Valuation Area
LogicalSystem P_CostCenter LogicalSystem Logical System
CostCenterCreationDate P_CostCenter CostCenterCreationDate Created On
CostCenterCreatedByUser P_CostCenter CostCenterCreatedByUser Created By
IsBlkdForSecondaryCostsPosting P_CostCenter IsBlkdForSecondaryCostsPosting Lock Secondary Costs Posting
IsBlockedForRevenuePosting P_CostCenter IsBlockedForRevenuePosting Lock Revenue Posting
IsBlockedForCommitmentPosting P_CostCenter IsBlockedForCommitmentPosting Lock Commitment Updates
IsBlockedForPlanSecondaryCosts P_CostCenter IsBlockedForPlanSecondaryCosts Lock Secondary Costs Planning
IsBlockedForPlanRevenues P_CostCenter IsBlockedForPlanRevenues Lock Revenue Planning
CostCenterAllocationMethod P_CostCenter CostCenterAllocationMethod Alloc. Methods
ConsumptionQtyIsRecorded P_CostCenter ConsumptionQtyIsRecorded Record Quantity
Department P_CostCenter Department Department
SubsequentCostCenter P_CostCenter SubsequentCostCenter Subseq.CCtr
ConditionUsage P_CostCenter ConditionUsage Usage
ConditionApplication P_CostCenter ConditionApplication Application
CostCenterAccountingOverhead P_CostCenter CostCenterAccountingOverhead Overhead Key
Country P_CostCenter Country Venue: Ctry/Reg
FormOfAddress P_CostCenter FormOfAddress Title Key
AddressName P_CostCenter AddressName Name
AddressAdditionalName P_CostCenter AddressAdditionalName Name 2
CostCenterAddrName3 P_CostCenter CostCenterAddrName3 Name 3
CostCenterAddrName4 P_CostCenter CostCenterAddrName4 Name 4
CityName P_CostCenter CityName Name
District P_CostCenter District District Court
StreetAddressName P_CostCenter StreetAddressName Street
POBox P_CostCenter POBox PO Box
PostalCode P_CostCenter PostalCode Postal Code
POBoxPostalCode P_CostCenter POBoxPostalCode PO Box Postal Code
Region P_CostCenter Region Venue Region
Language P_CostCenter Language Report Text Language
TeleboxNumber P_CostCenter TeleboxNumber Telebox Number
PhoneNumber1 P_CostCenter PhoneNumber1 Telephone 1
PhoneNumber2 P_CostCenter PhoneNumber2 Telephone 2
FaxNumber P_CostCenter FaxNumber Fax Number
TeletexNumber P_CostCenter TeletexNumber Teletex Number
TelexNumber P_CostCenter TelexNumber Telex Number
DataCommunicationPhoneNumber P_CostCenter DataCommunicationPhoneNumber Data Line
CostCenterPrinterDestination P_CostCenter CostCenterPrinterDestination Printer Destination
CostCenterStandardHierArea P_CostCenter CostCenterStandardHierArea Standard Hierarchy Node
CostCollector P_CostCenter CostCollector Cost Collector
CostCenterIsComplete P_CostCenter CostCenterIsComplete Complete
IsStatisticalCostCenter P_CostCenter IsStatisticalCostCenter Cost Center Is Stat.
ObjectInternalID P_CostCenter ObjectInternalID Object number
CostCenterFunction P_CostCenter CostCenterFunction Function
CostCenterAlternativeFunction P_CostCenter CostCenterAlternativeFunction Alt. Function
FunctionalArea P_CostCenter FunctionalArea Sendr Fctl Area
ControllingAreaName P_CostCenter ControllingAreaName Long Text
CostCenterCategoryName P_CostCenter CostCenterCategoryName
CompanyCodeName P_CostCenter CompanyCodeName Company Name
BusinessAreaName P_CostCenter BusinessAreaName Business Area Name
FunctionalAreaName P_CostCenter FunctionalAreaName Long Text
ProfitCenterName P_CostCenter ProfitCenterName Profit Center Name
CostingSheetProcedureDesc P_CostCenter CostingSheetProcedureDesc
ChangeDocObject P_CostCenter ChangeDocObject Object Value
ResponsibleUserFullName P_CostCenter ResponsibleUserFullName
CreatedByUserFullName P_CostCenter CreatedByUserFullName Description
CostCenterResponsibilityArea P_CostCenter CostCenterResponsibilityArea
CostCenterHierarchyRespyArea P_CostCenter CostCenterHierarchyRespyArea
CostCenterValidityPeriod
UxFcCostCenter
ActyIndepFormulaPlanningTmpl P_CostCenter ActyIndepFormulaPlanningTmpl Act. Indep. Formula Planning Template
ActyDepdntFormulaPlanningTmpl P_CostCenter ActyDepdntFormulaPlanningTmpl Act. Depen. Formula Planning Template
ActyIndependentAllocationTmpl P_CostCenter ActyIndependentAllocationTmpl Activity Independent Allocation Template
ActyDependentAllocationTmpl P_CostCenter ActyDependentAllocationTmpl Activity Dependent Allocation Template
ActlIndepStatisticalKeyFigures P_CostCenter ActlIndepStatisticalKeyFigures Act. Indep. Statistical Key Figure Tmp.
ActlDepStatisticalKeyFigures P_CostCenter ActlDepStatisticalKeyFigures Act. Dep. Statistical Key Figure Tmp.
JointVenture P_CostCenter JointVenture Joint venture
JointVentureRecoveryCode P_CostCenter JointVentureRecoveryCode Recovery Ind.
JointVentureEquityType P_CostCenter JointVentureEquityType Joint Venture Equity Type
JointVentureObjectType P_CostCenter JointVentureObjectType JV Object Type
JointVentureClass P_CostCenter JointVentureClass JIB/JIBE Class
JointVentureSubClass P_CostCenter JointVentureSubClass JIB/JIBE SbClsA
UxFcJointVenture
UxFcABCIndicator
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
FinancialManagementArea _CompanyCode FinancialManagementArea FM Area
CostCenterIsCopied
CostCenterTranslationIsHidden
CostCenterChangeLogIsHidden
CostCenterCreationTime CostCenterCreationTime
CostCenterLastChangedByUser CostCenterLastChangedByUser
CostCenterLastChangedOnDate CostCenterLastChangedOnDate
CostCenterLastChangedAtTime CostCenterLastChangedAtTime
LastChangedByUserFullName LastChangedByUserFullName Name
_ControllingAreaForEdit _ControllingAreaForEdit
_CostCenterHierNodeForEdit _CostCenterHierNodeForEdit
_ControllingArea P_CostCenter _ControllingArea
_Text P_CostCenter _Text
_CostCenterHierarchyNode P_CostCenter _CostCenterHierarchyNode
_Currency P_CostCenter _Currency
_CompanyCode P_CostCenter _CompanyCode
_BusinessArea P_CostCenter _BusinessArea
_ProfitCenter P_CostCenter _ProfitCenter
_FunctionalArea P_CostCenter _FunctionalArea
_CostCenterCategory P_CostCenter _CostCenterCategory
_Country P_CostCenter _Country
_Region P_CostCenter _Region
_CostingSheetProcedure P_CostCenter _CostingSheetProcedure
_Language P_CostCenter _Language
_UserRespContactCard P_CostCenter _UserRespContactCard
_UserCrtedContactCard P_CostCenter _UserCrtedContactCard
_ActivityBasedCostingTmplCpi P_CostCenter _ActivityBasedCostingTmplCpi
_ActivityBasedCostingTmplCpd P_CostCenter _ActivityBasedCostingTmplCpd
_ActivityBasedCostingTmplSci P_CostCenter _ActivityBasedCostingTmplSci
_ActivityBasedCostingTmplScd P_CostCenter _ActivityBasedCostingTmplScd
_ActivityBasedCostingTmplSki P_CostCenter _ActivityBasedCostingTmplSki
_ActivityBasedCostingTmplSkd P_CostCenter _ActivityBasedCostingTmplSkd
_LastChangedByUserContactCard P_CostCenter _LastChangedByUserContactCard
_CostCenterLabel _CostCenterLabel

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.
-- 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: IFICOSTCENTERTP

CREATE VIEW I_CostCenterTP AS
SELECT
  P_CostCenter.ControllingArea AS ControllingArea,
  P_CostCenter.CostCenter AS CostCenter,
  P_CostCenter.ValidityEndDate AS ValidityEndDate,
  P_CostCenter.ControllingArea AS ControllingAreaForEdit,
  P_CostCenter.CostCenter AS CostCenterForEdit,
  P_CostCenter.ValidityEndDate AS ValidityEndDateForEdit,
  P_CostCenter.ValidityStartDate AS ValidityStartDate,
  P_CostCenter.CostCenterName AS CostCenterName,
  P_CostCenter.CostCenterDescription AS CostCenterDescription,
  P_CostCenter.IsBlkdForPrimaryCostsPosting AS IsBlkdForPrimaryCostsPosting,
  P_CostCenter.IsBlockedForPlanPrimaryCosts AS IsBlockedForPlanPrimaryCosts,
  P_CostCenter.CompanyCode AS CompanyCode,
  P_CostCenter.BusinessArea AS BusinessArea,
  P_CostCenter.CostCenterCategory AS CostCenterCategory,
  P_CostCenter.CostCtrResponsiblePersonName AS CostCtrResponsiblePersonName,
  P_CostCenter.CostCtrResponsibleUser AS CostCtrResponsibleUser,
  P_CostCenter.CostCenterCurrency AS CostCenterCurrency,
  P_CostCenter.CostingSheet AS CostingSheet,
  P_CostCenter.TaxJurisdiction AS TaxJurisdiction,
  P_CostCenter.ProfitCenter AS ProfitCenter,
  P_CostCenter.Plant AS Plant,
  P_CostCenter.LogicalSystem AS LogicalSystem,
  P_CostCenter.CostCenterCreationDate AS CostCenterCreationDate,
  P_CostCenter.CostCenterCreatedByUser AS CostCenterCreatedByUser,
  P_CostCenter.IsBlkdForSecondaryCostsPosting AS IsBlkdForSecondaryCostsPosting,
  P_CostCenter.IsBlockedForRevenuePosting AS IsBlockedForRevenuePosting,
  P_CostCenter.IsBlockedForCommitmentPosting AS IsBlockedForCommitmentPosting,
  P_CostCenter.IsBlockedForPlanSecondaryCosts AS IsBlockedForPlanSecondaryCosts,
  P_CostCenter.IsBlockedForPlanRevenues AS IsBlockedForPlanRevenues,
  P_CostCenter.CostCenterAllocationMethod AS CostCenterAllocationMethod,
  P_CostCenter.ConsumptionQtyIsRecorded AS ConsumptionQtyIsRecorded,
  P_CostCenter.Department AS Department,
  P_CostCenter.SubsequentCostCenter AS SubsequentCostCenter,
  P_CostCenter.ConditionUsage AS ConditionUsage,
  P_CostCenter.ConditionApplication AS ConditionApplication,
  P_CostCenter.CostCenterAccountingOverhead AS CostCenterAccountingOverhead,
  P_CostCenter.Country AS Country,
  P_CostCenter.FormOfAddress AS FormOfAddress,
  P_CostCenter.AddressName AS AddressName,
  P_CostCenter.AddressAdditionalName AS AddressAdditionalName,
  P_CostCenter.CostCenterAddrName3 AS CostCenterAddrName3,
  P_CostCenter.CostCenterAddrName4 AS CostCenterAddrName4,
  P_CostCenter.CityName AS CityName,
  P_CostCenter.District AS District,
  P_CostCenter.StreetAddressName AS StreetAddressName,
  P_CostCenter.POBox AS POBox,
  P_CostCenter.PostalCode AS PostalCode,
  P_CostCenter.POBoxPostalCode AS POBoxPostalCode,
  P_CostCenter.Region AS Region,
  P_CostCenter.Language AS Language,
  P_CostCenter.TeleboxNumber AS TeleboxNumber,
  P_CostCenter.PhoneNumber1 AS PhoneNumber1,
  P_CostCenter.PhoneNumber2 AS PhoneNumber2,
  P_CostCenter.FaxNumber AS FaxNumber,
  P_CostCenter.TeletexNumber AS TeletexNumber,
  P_CostCenter.TelexNumber AS TelexNumber,
  P_CostCenter.DataCommunicationPhoneNumber AS DataCommunicationPhoneNumber,
  P_CostCenter.CostCenterPrinterDestination AS CostCenterPrinterDestination,
  P_CostCenter.CostCenterStandardHierArea AS CostCenterStandardHierArea,
  P_CostCenter.CostCollector AS CostCollector,
  P_CostCenter.CostCenterIsComplete AS CostCenterIsComplete,
  P_CostCenter.IsStatisticalCostCenter AS IsStatisticalCostCenter,
  P_CostCenter.ObjectInternalID AS ObjectInternalID,
  P_CostCenter.CostCenterFunction AS CostCenterFunction,
  P_CostCenter.CostCenterAlternativeFunction AS CostCenterAlternativeFunction,
  P_CostCenter.FunctionalArea AS FunctionalArea,
  P_CostCenter.ControllingAreaName AS ControllingAreaName,
  P_CostCenter.CostCenterCategoryName AS CostCenterCategoryName,
  P_CostCenter.CompanyCodeName AS CompanyCodeName,
  P_CostCenter.BusinessAreaName AS BusinessAreaName,
  P_CostCenter.FunctionalAreaName AS FunctionalAreaName,
  P_CostCenter.ProfitCenterName AS ProfitCenterName,
  P_CostCenter.CostingSheetProcedureDesc AS CostingSheetProcedureDesc,
  P_CostCenter.ChangeDocObject AS ChangeDocObject,
  P_CostCenter.ResponsibleUserFullName AS ResponsibleUserFullName,
  P_CostCenter.CreatedByUserFullName AS CreatedByUserFullName,
  P_CostCenter.CostCenterResponsibilityArea AS CostCenterResponsibilityArea,
  P_CostCenter.CostCenterHierarchyRespyArea AS CostCenterHierarchyRespyArea,
  cast( concat(ValidityStartDate, concat('-',ValidityEndDate)) as costcentervalidityperiod ) AS CostCenterValidityPeriod,
  cast( concat(CostCenter, concat(' (', concat(CostCenterName, ')' ) ) ) as costcentercodeandname ) AS UxFcCostCenter,
  P_CostCenter.ActyIndepFormulaPlanningTmpl AS ActyIndepFormulaPlanningTmpl,
  P_CostCenter.ActyDepdntFormulaPlanningTmpl AS ActyDepdntFormulaPlanningTmpl,
  P_CostCenter.ActyIndependentAllocationTmpl AS ActyIndependentAllocationTmpl,
  P_CostCenter.ActyDependentAllocationTmpl AS ActyDependentAllocationTmpl,
  P_CostCenter.ActlIndepStatisticalKeyFigures AS ActlIndepStatisticalKeyFigures,
  P_CostCenter.ActlDepStatisticalKeyFigures AS ActlDepStatisticalKeyFigures,
  P_CostCenter.JointVenture AS JointVenture,
  P_CostCenter.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  P_CostCenter.JointVentureEquityType AS JointVentureEquityType,
  P_CostCenter.JointVentureObjectType AS JointVentureObjectType,
  P_CostCenter.JointVentureClass AS JointVentureClass,
  P_CostCenter.JointVentureSubClass AS JointVentureSubClass,
  cast( '' as fco_is_jointventure_active ) AS UxFcJointVenture,
  cast( '' as fco_is_abc_active ) AS UxFcABCIndicator,
  BudgetCarryingCostCenter,
  AvailabilityControlProfile,
  AvailabilityControlIsActive,
  Fund,
  GrantID,
  FundIsFixAssigned,
  GrantIDIsFixAssigned,
  FunctionalAreaIsFixAssigned,
  _CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  cast( '' as fco_costcenter_is_copied ) AS CostCenterIsCopied,
  cast( '' as fco_cost_center_transl_hidden ) AS CostCenterTranslationIsHidden,
  cast( '' as fco_cost_center_chglg_hidden ) AS CostCenterChangeLogIsHidden,
  CostCenterCreationTime,
  CostCenterLastChangedByUser,
  CostCenterLastChangedOnDate,
  CostCenterLastChangedAtTime,
  LastChangedByUserFullName,
  P_CostCenter._ControllingArea AS _ControllingArea,
  P_CostCenter._Text AS _Text,
  P_CostCenter._CostCenterHierarchyNode AS _CostCenterHierarchyNode,
  P_CostCenter._Currency AS _Currency,
  P_CostCenter._CompanyCode AS _CompanyCode,
  P_CostCenter._BusinessArea AS _BusinessArea,
  P_CostCenter._ProfitCenter AS _ProfitCenter,
  P_CostCenter._FunctionalArea AS _FunctionalArea,
  P_CostCenter._CostCenterCategory AS _CostCenterCategory,
  P_CostCenter._Country AS _Country,
  P_CostCenter._Region AS _Region,
  P_CostCenter._CostingSheetProcedure AS _CostingSheetProcedure,
  P_CostCenter._Language AS _Language,
  P_CostCenter._UserRespContactCard AS _UserRespContactCard,
  P_CostCenter._UserCrtedContactCard AS _UserCrtedContactCard,
  P_CostCenter._ActivityBasedCostingTmplCpi AS _ActivityBasedCostingTmplCpi,
  P_CostCenter._ActivityBasedCostingTmplCpd AS _ActivityBasedCostingTmplCpd,
  P_CostCenter._ActivityBasedCostingTmplSci AS _ActivityBasedCostingTmplSci,
  P_CostCenter._ActivityBasedCostingTmplScd AS _ActivityBasedCostingTmplScd,
  P_CostCenter._ActivityBasedCostingTmplSki AS _ActivityBasedCostingTmplSki,
  P_CostCenter._ActivityBasedCostingTmplSkd AS _ActivityBasedCostingTmplSkd,
  P_CostCenter._LastChangedByUserContactCard AS _LastChangedByUserContactCard
FROM P_CostCenter
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaForEdit ON ControllingAreaForEdit = _ControllingAreaForEdit.ControllingArea  -- association [1]
LEFT OUTER JOIN I_CostCenterHierarchyNode AS _CostCenterHierNodeForEdit ON ControllingAreaForEdit = _CostCenterHierNodeForEdit.ControllingArea AND CostCenterForEdit = _CostCenterHierNodeForEdit.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterLabelTP AS _CostCenterLabel ON ControllingArea = _CostCenterLabel.ControllingArea AND CostCenter = _CostCenterLabel.CostCenter AND ValidityEndDate = _CostCenterLabel.ValidityEndDate  -- association [1..*]
LEFT OUTER JOIN E_CostCenter AS _Extension ON ControllingArea = _Extension.ControllingArea AND CostCenter = _Extension.CostCenter AND ValidityEndDate = _Extension.ValidityEndDate  -- association [1..1]
;