I_CostCenterTP
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)
| Source | Alias | Join Type |
|---|---|---|
| P_CostCenter | P_CostCenter | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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]
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- 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
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA