P_STANDARDIZEDDATAWITHPARAM

CDS View

Consolidation: Standardized Data

P_STANDARDIZEDDATAWITHPARAM is a CDS View in S/4HANA. Consolidation: Standardized Data. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_Matrix_CP_GroupDerived_2 view from COMPOSITE Matrix Consolidation Periodic with derived Group 
@AbapCatalog.sqlViewName: 'PSTDDATEP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm:#SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: { dataClass: #MIXED, serviceQuality: #X, sizeCategory: #XL }
@VDM.private:true
@VDM.viewType: #COMPOSITE
define view P_StandardizedDataWithParam
  with parameters
    P_FromFiscalYearPeriod : fincs_fiscyearper,
    P_ToFiscalYearPeriod   : fincs_fiscyearper
  as select from P_StandardizedData
{
  gl_sirid,
  rldnr,
  rrcty,
  rvers,
  ryear,
  rtcur,
  rhcur,
  rkcur,
  runit,
  drcrk,
  poper,
  fiscyearper,
  docct,
  docnr,
  docln,
  rcomp,
  rdimen,
  rbunit,
  ritclg,
  ritem,
  rbuptr,
  rcongr,
  robukrs,
  sityp,
  subit,
  plevl,
  rpflg,
  rtflg,
  docty,
  yracq,
  pracq,
  coicu,
  uppcu,
  updhp,
  tsl,
  hsl,
  ksl,
  msl,
  tsl_csign,
  hsl_csign,
  ksl_csign,
  msl_csign,
  sgtxt,
  autom,
  activ,
  bvorg,
  budat,
  wsdat,
  refdocnr,
  refryear,
  refdocln,
  refdocct,
  refactiv,
  cpudt,
  cputm,
  usnam,
  rvsdocnr,
  orndocnr,
  coiac,
  coinr,
  revyear,
  awtyp,
  aworg,
  logsys,
  timestamp,
  racct,
  rcntr,
  prctr,
  rfarea,
  rbusa,
  kokrs,
  segment,
  scntr,
  pprctr,
  sfarea,
  sbusa,
  rassc,
  psegment,
  rmvct,
  matnr,
  werks,
  kunnr,
  lifnr,
  ps_posid,
  ps_pspid,
  fkart,
  vkorg,
  vtweg,
  spart,
  matnr_copa,
  matkl,
  kdgrp,
  land1,
  brsch,
  bzirk,
  kunre,
  kunwe,
  konzs,
  zuonr,
  aufnr,
  xblnr,
  matkl_mm,
  ps_psp_pnr,
  ktopl,
  adhocitem,
  adhocset,
  adhocsetitem,
  rcode,
  orig_type,
  orig_ref,
  bunnr,

  // industry-specific fields  Financial services: Banking Fields

  fs_product_group,
  branch_id,
  datasource_id,

  // industry-specific fields  Financial services: Green House Fields

  ghgcategory,
  ghgscope,
  ghgscp2calcmeth,
  ghgscp2contrinstr,
  ghgdtaqltycharc,
  ghgenergyclass,
  ghgenergymix,
  ghgengysrcgtype,
  susmodeoftransport,

  // industry-specific fields  Financial services: Public Sector Fields

  fikrs,
  rfund,
  rgrant_nbr,
  re_ktopl,
  re_account,
  bp_p_geber

}
where
  fiscyearper between $parameters.P_FromFiscalYearPeriod and $parameters.P_ToFiscalYearPeriod

Learn More