C_ProfitCenterTP

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 C_ProfitCenterTP.
-- 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 C_ProfitCenterTP AS
SELECT
  ControllingArea,
  ProfitCenter,
  ValidityEndDate,
  ControllingAreaForEdit,
  ControllingAreaName,
  ProfitCenterForEdit,
  ProfitCenterName,
  ValidityEndDateForEdit,
  ValidityStartDate,
  ProfitCenterValidityPeriod,
  ProfitCenterLongName,
  ProfitCtrResponsiblePersonName,
  ProfitCtrResponsibleUser,
  ProfitCenterCreationDate,
  ProfitCenterCreatedByUser,
  CompanyCode,
  CompanyCodeName,
  ProfitCenterStandardHierarchy,
  _SetHeader._SetHeaderText[1:Language = $session.system_language].SetDescription AS SetDescription,
  Segment,
  _Segment._Text[1:Language = $session.system_language].SegmentName AS SegmentName,
  Department,
  ProfitCenterIsBlocked,
  FormOfAddress,
  AddressName,
  AdditionalName,
  ProfitCenterAddrName3,
  ProfitCenterAddrName4,
  StreetAddressName,
  CityName,
  PostalCode,
  District,
  Country,
  TaxJurisdiction,
  Region,
  POBox,
  POBoxPostalCode,
  Language,
  PhoneNumber1,
  PhoneNumber2,
  FaxNumber,
  TeleboxNumber,
  TelexNumber,
  DataCommunicationPhoneNumber,
  ProfitCenterPrinterName,
  TeletexNumber,
  ETag,
  ProfitCenterResponsibilityArea,
  ProfitCenterHierarchyRespyArea,
  ChangeDocObject,
  CreatedByUserFullName,
  _UserRespContactCard.FullName AS ResponsibleUserFullName,
  _Country._Text[1: Language = $session.system_language].CountryName AS CountryName,
  _Region._RegionText[1:Language = $session.system_language].RegionName AS RegionName,
  _Language._Text[1:Language = $session.system_language].LanguageName AS LanguageName
FROM I_ProfitCenterTP AS ProfitCenter
LEFT OUTER JOIN C_ProfitCenterTextTP AS _MultiLangText ON ControllingArea = _MultiLangText.ControllingArea AND ProfitCenter = _MultiLangText.ProfitCenter AND ValidityEndDate = _MultiLangText.ValidityEndDate  -- association [1..*]
LEFT OUTER JOIN C_PrftCtrCompCodeAssgmtTP AS _CompanyCodeAssignment ON ControllingArea = _CompanyCodeAssignment.ControllingArea AND ProfitCenter = _CompanyCodeAssignment.ProfitCenter AND ValidityEndDate = _CompanyCodeAssignment.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN C_ProfitCenterChangeDocument AS _ProfitCenterChangeDocument ON ChangeDocObject = _ProfitCenterChangeDocument.ChangeDocObject AND _ProfitCenterChangeDocument.ChangeDocumentSAPClient = $session.client AND ControllingAreaForEdit = _ProfitCenterChangeDocument.ControllingArea AND ProfitCenterForEdit = _ProfitCenterChangeDocument.ProfitCenter AND ValidityEndDateForEdit = _ProfitCenterChangeDocument.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_SetHeader AS _SetHeader ON _SetHeader.SetSubClass = ControllingAreaForEdit AND _SetHeader.SetClass = '0106' AND _SetHeader.SetID = ProfitCenterStandardHierarchy  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON _Segment.Segment = Segment  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _UserRespContactCard ON ProfitCtrResponsibleUser = _UserRespContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _UserCrtedContactCard ON ProfitCenterCreatedByUser = _UserCrtedContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ProfitCenterUserRespVH ON ProfitCtrResponsibleUser = _ProfitCenterUserRespVH.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ProfitCenterUserCreatedVH ON ProfitCenterCreatedByUser = _ProfitCenterUserCreatedVH.ContactCardID  -- association [0..1]
;