P_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 P_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.
-- SQL view name: PFIPRFTCTRTP

CREATE VIEW P_ProfitCenterTP AS
SELECT
  ControllingArea,
  ProfitCenter,
  ValidityEndDate,
  ValidityStartDate,
  cast ( ProfitCtrResponsiblePersonName as verak) AS ProfitCtrResponsiblePersonName,
  CompanyCode,
  ProfitCtrResponsibleUser,
  Department,
  cast( ProfitCenterStandardHierarchy as fac_mpc_pcg preserving type ) AS ProfitCenterStandardHierarchy,
  Segment,
  cast ( ProfitCenterIsBlocked as fac_mpc_lock_indicator ) AS ProfitCenterIsBlocked,
  FormulaPlanningTemplate,
  FormOfAddress,
  AddressName,
  AdditionalName,
  ProfitCenterAddrName3,
  ProfitCenterAddrName4,
  StreetAddressName,
  POBox,
  CityName,
  PostalCode,
  POBoxPostalCode,
  District,
  cast(Country as fis_land1 preserving type ) AS Country,
  Region,
  TaxJurisdiction,
  Language,
  PhoneNumber1,
  PhoneNumber2,
  cast( TeleboxNumber as fac_mpc_comm_telbx preserving type ) AS TeleboxNumber,
  cast( TelexNumber as fac_mpc_comm_telx1 preserving type ) AS TelexNumber,
  cast( TeletexNumber as fac_mpc_teltx preserving type ) AS TeletexNumber,
  FaxNumber,
  cast( DataCommunicationPhoneNumber as fac_mpc_comm_data_line preserving type ) AS DataCommunicationPhoneNumber,
  cast( ProfitCenterPrinterName as fac_mpc_comm_printer preserving type ) AS ProfitCenterPrinterName,
  ProfitCenterCreatedByUser,
  cast ( ProfitCenterCreationDate as ersda) AS ProfitCenterCreationDate,
  _UserCrtedContactCard.FullName AS CreatedByUserFullName,
  cast( concat('PC', concat(ControllingArea, ProfitCenter)) as fac_mpc_resparea ) AS ProfitCenterResponsibilityArea,
  cast( concat('PH', concat(ControllingArea, ProfitCenterStandardHierarchy)) as fac_mpc_hier_resparea ) AS ProfitCenterHierarchyRespyArea,
  _Text[1:Language=$session.system_language].ProfitCenterName AS ProfitCenterName,
  cast( _Text[1:Language=$session.system_language].ProfitCenterLongName as fac_prctr_ltext_short preserving type ) AS ProfitCenterLongName,
  _ControllingAreaText.ControllingAreaName AS ControllingAreaName,
  _Company.CompanyCodeName AS CompanyCodeName
FROM I_ProfitCenter
LEFT OUTER JOIN I_UserContactCard AS _UserCrtedContactCard ON ProfitCenterCreatedByUser = _UserCrtedContactCard.ContactCardID  -- association [0..1]
;