FAC_DART_Z3_PROFITCENTER_BASE

DDL: FAC_DART_Z3_PROFITCNTR_BASE SQL: FAC_DZPROFITCTRB Type: view Package: FINS_FI_DART_Z3
89 Fields 4 Data Sources

Profit Center Master Data Base

FAC_DART_Z3_PROFITCENTER_BASE is a CDS View that provides data about "Profit Center Master Data Base" in SAP S/4HANA. It reads from 4 data sources (cepc_bukrs, I_ProfitCenter, I_ProfitCenter, I_CompanyCode) and exposes 89 fields with key fields ProfitCenter, ControllingArea, ValidityEndDate, CompanyCodeAssigned, CompanyCode. Part of development package FINS_FI_DART_Z3.

Data Sources (4)

SourceAliasJoin Type
cepc_bukrs _assignedcocode inner
I_ProfitCenter _profitcenter from
I_ProfitCenter _profitcenter union_all
I_CompanyCode I_CompanyCode inner

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName FAC_DZPROFITCTRB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Profit Center Master Data Base view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (89)

KeyFieldSource TableSource FieldDescription
KEY ProfitCenter I_ProfitCenter ProfitCenter Profit Center
KEY ControllingArea I_ProfitCenter ControllingArea Controlling Area
KEY ValidityEndDate I_ProfitCenter ValidityEndDate ValidTo
KEY CompanyCodeAssigned cepc_bukrs bukrs Value
KEY CompanyCode cepc_bukrs bukrs Receiver Company Code
ControllingAreaName _ControllingArea ControllingAreaName Long Text
ProfitCenterName
ProfitCenterLongName
ProfitCtrResponsibleUser ProfitCtrResponsibleUser User Responsible
ValidityStartDate ValidityStartDate Validity Start Date
Department Department Department
ProfitCenterStandardHierarchy ProfitCenterStandardHierarchy Standard Hierarchy Node
Segment Segment Segment number
ProfitCenterIsBlocked ProfitCenterIsBlocked Locked
FormulaPlanningTemplate FormulaPlanningTemplate Form. Planning Temp.
FormOfAddress FormOfAddress Title Key
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
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
DataCommunicationPhoneNumber DataCommunicationPhoneNumber Data Line
ProfitCenterPrinterName ProfitCenterPrinterName Printer
ProfitCenterCreatedByUser ProfitCenterCreatedByUser Created By
ProfitCenterCreationDate ProfitCenterCreationDate Entered On
_Text _Text
_Country _Country
_ControllingArea _ControllingArea
_ProfitCenterHierarchyNode _ProfitCenterHierarchyNode
_Language _Language
_Segment _Segment
ProfitCenter Profit Center
KEY ControllingArea I_ProfitCenter ControllingArea Controlling Area
KEY ValidityEndDate I_ProfitCenter ValidityEndDate ValidTo
KEY CompanyCodeAssigned cepc_bukrs bukrs Value
KEY CompanyCode I_CompanyCode CompanyCode Receiver Company Code
ControllingAreaName Long Text
ProfitCenterName
ProfitCenterLongName
ProfitCtrResponsibleUser ProfitCtrResponsibleUser User Responsible
ValidityStartDate ValidityStartDate Validity Start Date
Department Department Department
ProfitCenterStandardHierarchy ProfitCenterStandardHierarchy Standard Hierarchy Node
Segment Segment Segment number
ProfitCenterIsBlocked ProfitCenterIsBlocked Locked
FormulaPlanningTemplate FormulaPlanningTemplate Form. Planning Temp.
FormOfAddress FormOfAddress Title Key
AddressName AddressName Name
AdditionalName AdditionalName Name 2
ProfitCenterAddrName3 ProfitCenterAddrName3 Name 3
ProfitCenterAddrName4 ProfitCenterAddrName4 Name 4
StreetAddressName StreetAddressName Street
POBox POBox PO Box
CityName I_ProfitCenter CityName Name
PostalCode PostalCode Postal Code
District District District Court
Country I_ProfitCenter Country Venue: Ctry/Reg
Region Region Venue Region
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
Language I_ProfitCenter Language Report Text Language
PhoneNumber1 PhoneNumber1 Telephone 1
PhoneNumber2 PhoneNumber2 Telephone 2
TeleboxNumber TeleboxNumber Telebox Number
TelexNumber TelexNumber Telex Number
FaxNumber FaxNumber Fax Number
DataCommunicationPhoneNumber DataCommunicationPhoneNumber Data Line
ProfitCenterPrinterName ProfitCenterPrinterName Printer
ProfitCenterCreatedByUser ProfitCenterCreatedByUser Created By
ProfitCenterCreationDate ProfitCenterCreationDate Entered On
_Text _Text
_Country _Country
_ControllingArea _ControllingArea
_ProfitCenterHierarchyNode _ProfitCenterHierarchyNode
_Language _Language
_Segment _Segment
_Region _Region

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 FAC_DART_Z3_PROFITCENTER_BASE.
-- 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: FAC_DZPROFITCTRB
-- Parameters: P_Language : sylangu

CREATE VIEW FAC_DART_Z3_PROFITCENTER_BASE AS
SELECT
  _profitcenter.ProfitCenter AS ProfitCenter,
  _profitcenter.ControllingArea AS ControllingArea,
  _profitcenter.ValidityEndDate AS ValidityEndDate,
  _assignedcocode.bukrs AS CompanyCodeAssigned,
  _assignedcocode.bukrs AS CompanyCode,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  _profitcenter._Text[1:Language=$parameters.P_Language].ProfitCenterName AS ProfitCenterName,
  _profitcenter._Text[1:Language=$parameters.P_Language].ProfitCenterLongName AS ProfitCenterLongName,
  ProfitCtrResponsibleUser,
  ValidityStartDate,
  Department,
  ProfitCenterStandardHierarchy,
  Segment,
  ProfitCenterIsBlocked,
  FormulaPlanningTemplate,
  FormOfAddress,
  AddressName,
  AdditionalName,
  ProfitCenterAddrName3,
  ProfitCenterAddrName4,
  StreetAddressName,
  POBox,
  CityName,
  PostalCode,
  District,
  Country,
  Region,
  TaxJurisdiction,
  Language,
  PhoneNumber1,
  PhoneNumber2,
  TeleboxNumber,
  TelexNumber,
  FaxNumber,
  DataCommunicationPhoneNumber,
  ProfitCenterPrinterName,
  ProfitCenterCreatedByUser,
  ProfitCenterCreationDate
FROM I_ProfitCenter AS _profitcenter
INNER JOIN cepc_bukrs AS _assignedcocode ON /* join condition not captured in parsed metadata */
INNER JOIN I_CompanyCode ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_ProfitCenter
;

Learn More