R_CostCenterTP

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 R_CostCenterTP.
-- 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 R_CostCenterTP AS
SELECT
  ControllingArea,
  CostCenter,
  ValidityEndDate,
  ValidityStartDate,
  ControllingArea AS ControllingAreaForEdit,
  CostCenter AS CostCenterForEdit,
  ValidityEndDate AS ValidityEndDateForEdit,
  _Text[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  _Text[1:Language = $session.system_language].CostCenterDescription AS CostCenterDescription,
  cast( IsBlkdForPrimaryCostsPosting as fis_cc_bkzkp preserving type ) AS IsBlkdForPrimaryCostsPosting,
  cast( IsBlockedForPlanPrimaryCosts as fis_cc_pkzkp preserving type ) AS IsBlockedForPlanPrimaryCosts,
  CompanyCode,
  BusinessArea,
  CostCenterCategory,
  CostCtrResponsiblePersonName,
  CostCtrResponsibleUser,
  CostCenterCurrency,
  CostingSheet,
  TaxJurisdiction,
  ProfitCenter,
  Plant,
  LogicalSystem,
  cast ( CostCenterCreationDate as fis_cc_erfdt preserving type ) AS CostCenterCreationDate,
  cast ( CostCenterCreatedByUser as fis_cc_erfnm preserving type ) AS CostCenterCreatedByUser,
  cast ( IsBlkdForSecondaryCostsPosting as fis_cc_bkzks preserving type ) AS IsBlkdForSecondaryCostsPosting,
  cast ( IsBlockedForRevenuePosting as fis_cc_bkzer preserving type ) AS IsBlockedForRevenuePosting,
  cast ( IsBlockedForCommitmentPosting as fis_cc_bkzob preserving type ) AS IsBlockedForCommitmentPosting,
  cast ( IsBlockedForPlanSecondaryCosts as fis_cc_pkzks preserving type ) AS IsBlockedForPlanSecondaryCosts,
  cast ( IsBlockedForPlanRevenues as fis_cc_pkzer preserving type ) AS IsBlockedForPlanRevenues,
  CostCenterAllocationMethod,
  ConsumptionQtyIsRecorded,
  Department,
  SubsequentCostCenter,
  ConditionUsage,
  ConditionApplication,
  CostCenterAccountingOverhead,
  cast( Country as fis_land1 preserving type ) AS Country,
  FormOfAddress,
  cast ( AddressName as fco_cc_addressname preserving type ) AS AddressName,
  AddressAdditionalName,
  CostCenterAddrName3,
  CostCenterAddrName4,
  CityName,
  District,
  StreetAddressName,
  POBox,
  PostalCode,
  POBoxPostalCode,
  Region,
  Language,
  TeleboxNumber,
  cast ( PhoneNumber1 as fco_cc_telf1 preserving type ) AS PhoneNumber1,
  PhoneNumber2,
  FaxNumber,
  TeletexNumber,
  TelexNumber,
  DataCommunicationPhoneNumber,
  cast( CostCenterPrinterDestination as fis_kdnam preserving type ) AS CostCenterPrinterDestination,
  cast ( CostCenterStandardHierArea as fco_cc_khinr preserving type ) AS CostCenterStandardHierArea,
  CostCollector,
  CostCenterIsComplete,
  IsStatisticalCostCenter,
  ObjectInternalID,
  CostCenterFunction,
  CostCenterAlternativeFunction,
  FunctionalArea,
  cast ( ActyIndepFormulaPlanningTmpl as fco_cca_templ_cpi preserving type ) AS ActyIndepFormulaPlanningTmpl,
  cast ( ActyDepdntFormulaPlanningTmpl as fco_cca_templ_cpd preserving type ) AS ActyDepdntFormulaPlanningTmpl,
  cast ( ActyIndependentAllocationTmpl as fco_cca_templ_sci preserving type ) AS ActyIndependentAllocationTmpl,
  cast ( ActyDependentAllocationTmpl as fco_cca_templ_scd preserving type ) AS ActyDependentAllocationTmpl,
  cast ( ActlIndepStatisticalKeyFigures as fco_cca_templ_ski preserving type ) AS ActlIndepStatisticalKeyFigures,
  cast ( ActlDepStatisticalKeyFigures as fco_cca_templ_skd preserving type ) AS ActlDepStatisticalKeyFigures,
  JointVenture,
  JointVentureRecoveryCode,
  JointVentureEquityType,
  JointVentureObjectType,
  JointVentureClass,
  JointVentureSubClass,
  cast ( BudgetCarryingCostCenter as fco_budgetcarryingcostcenter preserving type ) AS BudgetCarryingCostCenter,
  cast ( AvailabilityControlProfile as fco_budgetavailabilityctrlprof preserving type ) AS AvailabilityControlProfile,
  cast ( AvailabilityControlIsActive as fco_availabilityctrlprofisact preserving type ) AS AvailabilityControlIsActive,
  Fund,
  GrantID,
  FundIsFixAssigned,
  GrantIDIsFixAssigned,
  FunctionalAreaIsFixAssigned,
  _CompanyCode.FinancialManagementArea AS FinancialManagementArea
FROM I_CostCenter
LEFT OUTER JOIN R_CostCenterTextTP AS _CostCenterTextTP ON /* condition not available in parsed metadata */  -- association [0..*]
;