P_ACCOSTRATERawData

DDL: P_ACCOSTRATERAWDATA SQL: PFIACCOSTRATERAW Type: view BASIC
30 Fields 1 Data Sources

P_ACCOSTRATERawData is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (accostrate) and exposes 30 fields with key field rateuuid.

Data Sources (1)

SourceAliasJoin Type
accostrate accostrate from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PFIACCOSTRATERAW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY rateuuid rateuuid Cost Rate UUID
ledger ledger Ledger
bukrs bukrs Value
cvtyp cvtyp Crcy/Valuation
bttype bttype Business Transaction Type
category category Violation Category
gjahrfrom gjahrfrom From Year
periodfrom periodfrom From Period
datefrom datefrom Valid From
gjahrto gjahrto Year To
periodto periodto To Period
dateto dateto Valid-To Date
currency currency Valuation Crcy
totalamount totalamount Total Rate
fixedamount fixedamount Fixed Rate
scalefactor scalefactor Per
usnam usnam User Name
timestamp timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
deleted deleted Truth Value
deleted_by deleted_by User Name
deleted_time deleted_time Deletion Time
ref_rateuuid ref_rateuuid Cost Rate UUID
kokrs kokrs Org. Value
kostl kostl Substitute CC
ico_rate ico_rate ICO Rate
pernr pernr Personnel no.
ps_posid ps_posid WBS Element
work_item_id work_item_id Work Item ID
overtimecat overtimecat Overtime Category
ps_psp_pnr ps_psp_pnr WBS Element

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_ACCOSTRATERawData.
-- 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: PFIACCOSTRATERAW

CREATE VIEW P_ACCOSTRATERawData AS
SELECT
  rateuuid,
  ledger,
  bukrs,
  cvtyp,
  bttype,
  category,
  gjahrfrom,
  periodfrom,
  datefrom,
  gjahrto,
  periodto,
  dateto,
  currency,
  totalamount,
  fixedamount,
  scalefactor,
  usnam,
  timestamp,
  deleted,
  deleted_by,
  deleted_time,
  ref_rateuuid,
  kokrs,
  kostl,
  ico_rate,
  pernr,
  ps_posid,
  work_item_id,
  overtimecat,
  ps_psp_pnr
FROM accostrate
;

Learn More