C_ServiceCostRate

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_ServiceCostRate.
-- 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: CFISRVCOSTRATE

CREATE VIEW C_ServiceCostRate AS
SELECT
  AccountingCostRateUUID,
  CompanyCode,
  cast(ValidityStartDate as fco_valid_on) AS ValidityDate,
  ReceivingCompanyCode,
  IsIntercompanyRate,
  CostCenter,
  cast('' as fis_cctr_hryid_42) AS CostCenterHierarchy,
  cast('' as fis_cctr_hrynid_50) AS CostCenterHierarchyNode,
  TimeSheetOvertimeCategory,
  ActivityType,
  WorkItem,
  cast( _PersonWorkAgreement.PersonFullName as fco_employee_full_name preserving type) AS EmployeeFullName,
  WBSElementExternalID,
  ValidityStartFiscalYear,
  ValidityStartFiscalPeriod,
  Currency,
  cast( CostRateVarblAmount as fco_cost_rate preserving type ) AS CostRateVarblAmount,
  CostRateScaleFactor,
  CostCtrActivityTypeQtyUnit,
  ControllingArea,
  WBSElementInternalID,
  ValidityEndFiscalYear,
  ValidityEndFiscalPeriod,
  ValidityStartDate,
  ValidityEndDate,
  cast( 0 as int4) AS RowIndex,
  cast( '' as fco_overwrite) AS CostRateIsOverwriteMode,
  cast( _CompanyCode.CompanyCodeName as fis_butxt preserving type ) AS CompanyCodeName,
  cast( _ReceivingCompanyCode.CompanyCodeName as fco_receiving_companycode_name preserving type ) AS ReceivingCompanyCodeName,
  cast( _CurrentCostCenter._Text[1: Language = $session.system_language].CostCenterName as fis_kostl_name preserving type) AS CostCenterName,
  cast(_I_TimeSheetOvertimeCat._TimeSheetOvertimeCatText [1:Language = $session.system_language].TimeSheetOvertimeCategoryText as cats_ssc_overtimecattext ) AS TimeSheetOvertimeCategoryText,
  cast( _CurrentCostCtrActyType._Text[1: Language = $session.system_language].CostCtrActivityTypeName as fco_activity_type_name preserving type) AS CostCtrActivityTypeName,
  cast( _CurrentServiceCostLevel._Text[1: Language = $session.system_language].ServiceCostLevelName as fco_service_cost_level_name preserving type) AS ServiceCostLevelName,
  _WorkItem._Text[1: Language = $session.system_language].WorkItemName AS WorkItemName,
  _WBSElementInternalID.WBSDescription AS WBSElementDescription,
  Ledger,
  _LedgerText.LedgerName AS LedgerName
FROM I_ServiceCostRate
LEFT OUTER JOIN I_CostCenterVH AS _CostCenterVH ON ControllingArea = _CostCenterVH.ControllingArea AND CompanyCode = _CostCenterVH.CompanyCode AND CostCenter = _CostCenterVH.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityTypeVH AS _ActivityTypeVH ON ControllingArea = _ActivityTypeVH.ControllingArea AND ActivityType = _ActivityTypeVH.CostCtrActivityType AND CostCtrActivityTypeQtyUnit = _ActivityTypeVH.CostCtrActivityTypeQtyUnit  -- association [0..*]
LEFT OUTER JOIN I_ServiceCostLevelVH AS _ServiceCostLevelVH ON ServiceCostLevel = _ServiceCostLevelVH.ServiceCostLevel  -- association [0..*]
LEFT OUTER JOIN I_Employmentshlp AS _Employmentshlp ON PersonnelNumber = _Employmentshlp.PersonnelNumber AND CompanyCode = _Employmentshlp.CompanyCode  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicDataStdVH AS _WBSElementValueHelp ON WBSElementExternalID = _WBSElementValueHelp.WBSElementExternalID  -- association [0..*]
LEFT OUTER JOIN I_TimeSheetOvertimeCat AS _I_TimeSheetOvertimeCat ON TimeSheetOvertimeCategory = _I_TimeSheetOvertimeCat.TimeSheetOvertimeCategory  -- association [0..1]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger AND _LedgerText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_HierRuntimeRprstnDplLeafNode AS _CostCenterHierarchyLeafNode ON CostCenter = _CostCenterHierarchyLeafNode.UnivHierarchyBusinessEntity AND ControllingArea = _CostCenterHierarchyLeafNode.HierarchyNodeClass AND _CostCenterHierarchyLeafNode.ValidityStartDate <= $session.system_date AND _CostCenterHierarchyLeafNode.ValidityEndDate >= $session.system_date AND _CostCenterHierarchyLeafNode.HierarchyType = '0101'  -- association [0..*]
;