FAC_DART_Z3_PROFITCENTER

DDL: FAC_DART_Z3_PROFITCENTER SQL: FAC_DZPROFITCTR Type: view
47 Fields 2 Data Sources 2 Associations

Profit Center

FAC_DART_Z3_PROFITCENTER is a CDS View that provides data about "Profit Center" in SAP S/4HANA. It reads from 2 data sources (FAC_DART_Z3_PROFITCENTER_BASE, I_LedgerCompanyCodeCrcyRoles) and exposes 47 fields with key fields ProfitCenter, ControllingArea, ValidityEndDate, CompanyCode. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
FAC_DART_Z3_PROFITCENTER_BASE FAC_DART_Z3_PROFITCENTER_BASE from
I_LedgerCompanyCodeCrcyRoles I_LedgerCompanyCodeCrcyRoles inner

Parameters (5)

NameTypeDefault
P_Ledger fins_ledger
P_FiscalYear fins_gjahr
P_FromFiscalPeriod fins_fagl_fiscper_from
P_ToFiscalPeriod fins_fagl_fiscper_to
P_Language sylangu

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_FiscalPeriodForVariant _ToFiscalPeriodForVariant _ToFiscalPeriodForVariant.FiscalYearVariant = $projection.FiscalYearVariant and _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear and _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod
[0..1] I_FiscalPeriodForVariant _FromFiscalPeriodForVariant _FromFiscalPeriodForVariant.FiscalYearVariant = $projection.FiscalYearVariant and _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear and _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName FAC_DZPROFITCTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Profit Center 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 (47)

KeyFieldSource TableSource FieldDescription
KEY ProfitCenter _profitcenter ProfitCenter Profit Center
KEY ControllingArea _profitcenter ControllingArea Controlling Area
KEY ValidityEndDate _profitcenter ValidityEndDate ValidTo
KEY CompanyCode _profitcenter CompanyCode Receiver Company Code
ControllingAreaName ControllingAreaName Long Text
InputCompanyCode _profitcenter CompanyCode Company Code
ProfitCenterName ProfitCenterName Profit Center Name
ProfitCenterLongName ProfitCenterLongName Description of Profit Center Long
FiscalYearVariant I_LedgerCompanyCodeCrcyRoles FiscalYearVariant FY Variant
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
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
SystemClient System Client
_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.
-- 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_DZPROFITCTR
-- Parameters: P_Ledger : fins_ledger, P_FiscalYear : fins_gjahr, P_FromFiscalPeriod : fins_fagl_fiscper_from, P_ToFiscalPeriod : fins_fagl_fiscper_to, P_Language : sylangu

CREATE VIEW FAC_DART_Z3_PROFITCENTER AS
SELECT
  _profitcenter.ProfitCenter AS ProfitCenter,
  _profitcenter.ControllingArea AS ControllingArea,
  _profitcenter.ValidityEndDate AS ValidityEndDate,
  _profitcenter.CompanyCode AS CompanyCode,
  ControllingAreaName,
  _profitcenter.CompanyCode AS InputCompanyCode,
  ProfitCenterName,
  ProfitCenterLongName,
  I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant AS FiscalYearVariant,
  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,
  $session.client AS SystemClient
FROM FAC_DART_Z3_PROFITCENTER_BASE
INNER JOIN I_LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _ToFiscalPeriodForVariant ON _ToFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FromFiscalPeriodForVariant ON _FromFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod  -- association [0..1]
;

Learn More