P_StandardizedDataWithParam

DDL: P_STANDARDIZEDDATAWITHPARAM SQL: PSTDDATEP Type: view COMPOSITE Package: FIN_CS_ANALYTICS_FOUNDATION

Consolidation: Standardized Data

P_StandardizedDataWithParam is a Composite CDS View that provides data about "Consolidation: Standardized Data" in SAP S/4HANA. It reads from 1 data source (P_StandardizedData) and exposes 121 fields. Part of development package FIN_CS_ANALYTICS_FOUNDATION.

1 data source(s) 121 fields

Data Sources (1)

SourceAliasJoin Type
P_StandardizedData P_StandardizedData from

Parameters (2)

NameTypeDefault
P_FromFiscalYearPeriod fincs_fiscyearper
P_ToFiscalYearPeriod fincs_fiscyearper

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PSTDDATEP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (121)

KeyFieldSource TableSource FieldDescription
gl_sirid gl_sirid
rldnr rldnr
rrcty rrcty
rvers rvers
ryear ryear
rtcur rtcur
rhcur rhcur
rkcur rkcur
runit runit
drcrk drcrk
poper poper
fiscyearper fiscyearper
docct docct
docnr docnr
docln docln
rcomp rcomp
rdimen rdimen
rbunit rbunit
ritclg ritclg
ritem ritem
rbuptr rbuptr
rcongr rcongr
robukrs robukrs
sityp sityp
subit subit
plevl plevl
rpflg rpflg
rtflg rtflg
docty docty
yracq yracq
pracq pracq
coicu coicu
uppcu uppcu
updhp updhp
tsl tsl
hsl hsl
ksl ksl
msl msl
tsl_csign tsl_csign
hsl_csign hsl_csign
ksl_csign ksl_csign
msl_csign msl_csign
sgtxt sgtxt
autom autom
activ activ
bvorg bvorg
budat budat
wsdat wsdat
refdocnr refdocnr
refryear refryear
refdocln refdocln
refdocct refdocct
refactiv refactiv
cpudt cpudt
cputm cputm
usnam usnam
rvsdocnr rvsdocnr
orndocnr orndocnr
coiac coiac
coinr coinr
revyear revyear
awtyp awtyp
aworg aworg
logsys logsys
timestamp timestamp
racct racct
rcntr rcntr
prctr prctr
rfarea rfarea
rbusa rbusa
kokrs kokrs
segment segment
scntr scntr
pprctr pprctr
sfarea sfarea
sbusa sbusa
rassc rassc
psegment psegment
rmvct rmvct
matnr matnr
werks werks
kunnr kunnr
lifnr lifnr
ps_posid ps_posid
ps_pspid ps_pspid
fkart fkart
vkorg vkorg
vtweg vtweg
spart spart
matnr_copa matnr_copa
matkl matkl
kdgrp kdgrp
land1 land1
brsch brsch
bzirk bzirk
kunre kunre
kunwe kunwe
konzs konzs
zuonr zuonr
aufnr aufnr
xblnr xblnr
matkl_mm matkl_mm
ps_psp_pnr ps_psp_pnr
ktopl ktopl
adhocitem adhocitem
adhocset adhocset
adhocsetitem adhocsetitem
rcode rcode
orig_type orig_type
orig_ref orig_ref
bunnr bunnr
branch_id branch_id
ghgcategory ghgcategory
ghgscope ghgscope
ghgenergymix ghgenergymix
fikrs fikrs
rfund rfund
rgrant_nbr rgrant_nbr
re_ktopl re_ktopl
re_account re_account
bp_p_geber bp_p_geber 
@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