R_CostCtrValidityPeriodEvent

DDL: R_COSTCTRVALIDITYPERIODEVENT Type: view_entity TRANSACTIONAL
95 Fields 1 Data Sources

Cost Center Validity Period Business Event

R_CostCtrValidityPeriodEvent is a Transactional CDS View that provides data about "Cost Center Validity Period Business Event" in SAP S/4HANA. It reads from 1 data source (I_CostCenter) and exposes 95 fields with key fields ControllingArea, CostCenter, ValidityEndDate.

Data Sources (1)

SourceAliasJoin Type
I_CostCenter I_CostCenter from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Cost Center Validity Period Business Event view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.sapObjectNodeType.name CostCenter view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (95)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea ControllingArea Controlling Area
KEY CostCenter CostCenter Cost Center
KEY ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
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
SubsequentCostCenter SubsequentCostCenter Subseq.CCtr
ConditionUsage ConditionUsage Usage
ConditionApplication ConditionApplication Application
CostCenterAccountingOverhead CostCenterAccountingOverhead Overhead Key
Country Country Venue: Ctry/Reg
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
CostCollector CostCollector Cost Collector
CostCenterIsComplete CostCenterIsComplete Complete
IsStatisticalCostCenter IsStatisticalCostCenter Cost Center Is Stat.
ObjectInternalID ObjectInternalID Object number
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
_AvailabilityCtrlProfile _AvailabilityCtrlProfile
_BusinessArea _BusinessArea
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_CostCenterCategory _CostCenterCategory
_CostCenterHierarchyNode _CostCenterHierarchyNode
_CostingSheetProcedure _CostingSheetProcedure
_Country _Country
_Currency _Currency
_FunctionalArea _FunctionalArea
_Language _Language
_ProfitCenter _ProfitCenter
_Region _Region
_Text _Text
_UserCrtedContactCard _UserCrtedContactCard
_UserRespContactCard _UserRespContactCard

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

Learn More