P_STANDARDIZEDDATAWITHPARAM
P_STANDARDIZEDDATAWITHPARAM is a CDS View in S/4HANA. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_Matrix_CP_GroupDerived_2 | view | from | COMPOSITE |
@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,
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
}
where fiscyearper between $parameters.P_FromFiscalYearPeriod and $parameters.P_ToFiscalYearPeriod