A_ProfitCenter

DDL: A_PROFITCENTER SQL: AFIPROFITCENTER Type: view BASIC
37 Fields 1 Data Sources 3 Associations

Profit Center

A_ProfitCenter is a Basic CDS View that provides data about "Profit Center" in SAP S/4HANA. It reads from 1 data source (I_ProfitCenter) and exposes 37 fields with key fields ControllingArea, ProfitCenter, ValidityEndDate. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProfitCenter I_ProfitCenter from

Associations (3)

CardinalityTargetAliasCondition
[0..*] A_ProfitCenterText _Text $projection.ControllingArea = _Text.ControllingArea and $projection.ProfitCenter = _Text.ProfitCenter and $projection.ValidityEndDate = _Text.ValidityEndDate
[0..*] A_PrftCtrCompanyCodeAssignment _PrftCtrCompanyCodeAssignment $projection.ControllingArea = _PrftCtrCompanyCodeAssignment.ControllingArea and $projection.ProfitCenter = _PrftCtrCompanyCodeAssignment.ProfitCenter
[1..1] E_ProfitCenter _Extension $projection.ControllingArea = _Extension.ControllingArea and $projection.ProfitCenter = _Extension.ProfitCenter and $projection.ValidityEndDate = _Extension.ValidityEndDate

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName AFIPROFITCENTER view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Profit Center view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (37)

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
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
_PrftCtrCompanyCodeAssignment _PrftCtrCompanyCodeAssignment

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 A_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: AFIPROFITCENTER

CREATE VIEW A_ProfitCenter AS
SELECT
  ControllingArea,
  ProfitCenter,
  ValidityEndDate,
  ProfitCtrResponsiblePersonName,
  CompanyCode,
  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
LEFT OUTER JOIN A_ProfitCenterText AS _Text ON ControllingArea = _Text.ControllingArea AND ProfitCenter = _Text.ProfitCenter AND ValidityEndDate = _Text.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN A_PrftCtrCompanyCodeAssignment AS _PrftCtrCompanyCodeAssignment ON ControllingArea = _PrftCtrCompanyCodeAssignment.ControllingArea AND ProfitCenter = _PrftCtrCompanyCodeAssignment.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN E_ProfitCenter AS _Extension ON ControllingArea = _Extension.ControllingArea AND ProfitCenter = _Extension.ProfitCenter AND ValidityEndDate = _Extension.ValidityEndDate  -- association [1..1]
;

Learn More