P_AccountingCostRate

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_AccountingCostRate.
-- 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: PFIACCOSTRATE

CREATE VIEW P_AccountingCostRate AS
SELECT
  r.rateuuid AS AccountingCostRateUUID,
  r.cvtyp AS CurrencyRole,
  r.ledger AS Ledger,
  r.bukrs AS CompanyCode,
  r.kostl AS CostCenter,
  r.activity_type AS ActivityType,
  r.gjahrfrom AS ValidityStartFiscalYear,
  r.periodfrom AS ValidityStartFiscalPeriod,
  r.datefrom AS ValidityStartDate,
  r.gjahrto AS ValidityEndFiscalYear,
  r.periodto AS ValidityEndFiscalPeriod,
  r.dateto AS ValidityEndDate,
  r.kokrs AS ControllingArea,
  r.currency AS Currency,
  r.totalamount AS CostRateTotalAmount,
  r.fixedamount AS CostRateFixedAmount,
  r.scalefactor AS CostRateScaleFactor,
  r.activity_unit AS CostCtrActivityTypeQtyUnit,
  r.category AS PlanningCategory,
  r.bttype AS BusinessTransactionType,
  r.usnam AS CreatedByUser,
  r.timestamp AS CreationDateTime,
  r.usnam AS LastChangedByUser,
  r.deleted AS CostRateIsDeleted,
  r.deleted_by AS DeletedByUser,
  r.ico_rate AS IsIntercompanyRate,
  r.comp_receiving AS ReceivingCompanyCode,
  r.srv_cost_level AS ServiceCostLevel,
  r.pernr AS PersonnelNumber,
  r.ps_psp_pnr AS WBSElementInternalID,
  r.ps_posid AS WBSElementExternalID,
  r.work_item_id AS WorkItem,
  r.overtimecat AS TimeSheetOvertimeCategory,
  coalesce(c.objnr, '') AS ControllingObject
FROM P_ACCOSTRATERawData AS r
;