P_StandardizedDataWithParam

DDL: P_STANDARDIZEDDATAWITHPARAM SQL: PSTDDATEP Type: view COMPOSITE

P_StandardizedDataWithParam is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_StandardizedData) and exposes 107 fields.

1 data source(s) 107 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 (107)

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
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 
@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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_STANDARDIZEDDATA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More