R_PrftCtrValidityPeriodEvent

DDL: R_PRFTCTRVALIDITYPERIODEVENT Type: view_entity TRANSACTIONAL
46 Fields 1 Data Sources

Profit Center Validity Period Business Event

R_PrftCtrValidityPeriodEvent is a Transactional CDS View that provides data about "Profit Center Validity Period Business Event" in SAP S/4HANA. It reads from 1 data source (I_ProfitCenter) and exposes 46 fields with key fields ControllingArea, ProfitCenter, ValidityEndDate.

Data Sources (1)

SourceAliasJoin Type
I_ProfitCenter I_ProfitCenter from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Profit 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 ProfitCenter view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea ControllingArea Controlling Area
KEY ProfitCenter ProfitCenter Profit Center
KEY ValidityEndDate ValidityEndDate ValidTo
ProfitCtrResponsiblePersonName ProfitCtrResponsiblePersonName Person Respons.
CompanyCode CompanyCode Receiver Company Code
ProfitCtrResponsibleUser ProfitCtrResponsibleUser User Responsible
ValidityStartDate ValidityStartDate Validity Start Date
ProfitCenterStandardHierarchy ProfitCenterStandardHierarchy Standard Hierarchy Node
Segment Segment Segment number
ProfitCenterIsBlocked ProfitCenterIsBlocked Locked
FormulaPlanningTemplate FormulaPlanningTemplate Form. Planning Temp.
AddressName AddressName Name
AdditionalName AdditionalName Name 2
ProfitCenterAddrName3 ProfitCenterAddrName3 Name 3
ProfitCenterAddrName4 ProfitCenterAddrName4 Name 4
StreetAddressName StreetAddressName Street
POBox POBox PO Box
CityName CityName Name
PostalCode PostalCode Postal Code
POBoxPostalCode POBoxPostalCode PO Box Postal Code
District District District Court
Country Country Venue: Ctry/Reg
Region Region Venue Region
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
Language Language Report Text Language
PhoneNumber1 PhoneNumber1 Telephone 1
PhoneNumber2 PhoneNumber2 Telephone 2
TeleboxNumber TeleboxNumber Telebox Number
TelexNumber TelexNumber Telex Number
FaxNumber FaxNumber Fax Number
TeletexNumber TeletexNumber Teletex Number
DataCommunicationPhoneNumber DataCommunicationPhoneNumber Data Line
ProfitCenterPrinterName ProfitCenterPrinterName Printer
ProfitCenterCreatedByUser ProfitCenterCreatedByUser Created By
ProfitCenterCreationDate ProfitCenterCreationDate Entered On
_Company _Company
_ControllingArea _ControllingArea
_ControllingAreaText _ControllingAreaText
_Country _Country
_Language _Language
_PrftCtrCompanyCodeAssignment _PrftCtrCompanyCodeAssignment
_ProfitCenterHierarchyNode _ProfitCenterHierarchyNode
_Region _Region
_Segment _Segment
_SegmentText _SegmentText
_Text _Text

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_PrftCtrValidityPeriodEvent.
-- 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_PrftCtrValidityPeriodEvent AS
SELECT
  ControllingArea,
  ProfitCenter,
  ValidityEndDate,
  ProfitCtrResponsiblePersonName,
  CompanyCode,
  ProfitCtrResponsibleUser,
  ValidityStartDate,
  ProfitCenterStandardHierarchy,
  Segment,
  ProfitCenterIsBlocked,
  FormulaPlanningTemplate,
  AddressName,
  AdditionalName,
  ProfitCenterAddrName3,
  ProfitCenterAddrName4,
  StreetAddressName,
  POBox,
  CityName,
  PostalCode,
  POBoxPostalCode,
  District,
  Country,
  Region,
  TaxJurisdiction,
  Language,
  PhoneNumber1,
  PhoneNumber2,
  TeleboxNumber,
  TelexNumber,
  FaxNumber,
  TeletexNumber,
  DataCommunicationPhoneNumber,
  ProfitCenterPrinterName,
  ProfitCenterCreatedByUser,
  ProfitCenterCreationDate
FROM I_ProfitCenter
;

Learn More