P_CNSLDTNINTEGRPTDFINDATA_RT

CDS View

P_CNSLDTNINTEGRPTDFINDATA_RT is a CDS View in S/4HANA. It contains 101 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ReportedFinancialData_RL view union_all COMPOSITE

Fields (101)

KeyField CDS FieldsUsed in Views
_dataaging _dataaging 1
activ activ 1
aufnr aufnr 1
autom autom 1
aworg aworg 1
awtyp awtyp 1
brsch brsch 1
budat budat 1
bvorg bvorg 1
bzirk bzirk 1
coiac coiac 1
coicu coicu 1
coinr coinr 1
cpudt cpudt 1
cputm cputm 1
docct docct 1
docln docln 1
docnr docnr 1
docty docty 1
drcrk drcrk 1
fiscyearper fiscyearper 1
fkart fkart 1
hsl hsl 1
kdgrp kdgrp 1
kokrs kokrs 1
konzs konzs 1
ksl ksl 1
ktopl ktopl 1
kunnr kunnr 1
kunre kunre 1
kunwe kunwe 1
land1 land1 1
lifnr lifnr 1
logsys logsys 1
matkl matkl 1
matkl_mm matkl_mm 1
matnr matnr 1
matnr_copa matnr_copa 1
msl msl 1
orndocnr orndocnr 1
plevl plevl 1
poper poper 1
pprctr pprctr 1
pracq pracq 1
prctr prctr 1
ps_posid ps_posid 1
ps_psp_pnr ps_psp_pnr 1
ps_pspid ps_pspid 1
psegment psegment 1
racct racct 1
rassc rassc 1
rbunit rbunit 1
rbuptr rbuptr 1
rbusa rbusa 1
rcntr rcntr 1
rcomp rcomp 1
rcongr rcongr 1
rdimen rdimen 1
refactiv refactiv 1
refdocct refdocct 1
refdocln refdocln 1
refdocnr refdocnr 1
refryear refryear 1
revyear revyear 1
rfarea rfarea 1
rhcur rhcur 1
ritclg ritclg 1
ritem ritem 1
rkcur rkcur 1
rldnr rldnr 1
rldnr_fin rldnr_fin 1
rmvct rmvct 1
robukrs robukrs 1
rpflg rpflg 1
rrcty rrcty 1
rtcur rtcur 1
rtflg rtflg 1
runit runit 1
rvers rvers 1
rvsdocnr rvsdocnr 1
ryear ryear 1
sbusa sbusa 1
scntr scntr 1
segment segment 1
sfarea sfarea 1
sgtxt sgtxt 1
sityp sityp 1
spart spart 1
subit subit 1
timestamp timestamp 1
tsl tsl 1
updhp updhp 1
uppcu uppcu 1
usnam usnam 1
vkorg vkorg 1
vtweg vtweg 1
werks werks 1
wsdat wsdat 1
xblnr xblnr 1
yracq yracq 1
zuonr zuonr 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CNSLDTNINTEGRPTDFINDATA_RT (
    _DATAAGING,
    ACTIV,
    AUFNR,
    AUTOM,
    AWORG,
    AWTYP,
    BRSCH,
    BUDAT,
    BVORG,
    BZIRK,
    COIAC,
    COICU,
    COINR,
    CPUDT,
    CPUTM,
    DOCCT,
    DOCLN,
    DOCNR,
    DOCTY,
    DRCRK,
    FISCYEARPER,
    FKART,
    HSL,
    KDGRP,
    KOKRS,
    KONZS,
    KSL,
    KTOPL,
    KUNNR,
    KUNRE,
    KUNWE,
    LAND1,
    LIFNR,
    LOGSYS,
    MATKL,
    MATKL_MM,
    MATNR,
    MATNR_COPA,
    MSL,
    ORNDOCNR,
    PLEVL,
    POPER,
    PPRCTR,
    PRACQ,
    PRCTR,
    PS_POSID,
    PS_PSP_PNR,
    PS_PSPID,
    PSEGMENT,
    RACCT,
    RASSC,
    RBUNIT,
    RBUPTR,
    RBUSA,
    RCNTR,
    RCOMP,
    RCONGR,
    RDIMEN,
    REFACTIV,
    REFDOCCT,
    REFDOCLN,
    REFDOCNR,
    REFRYEAR,
    REVYEAR,
    RFAREA,
    RHCUR,
    RITCLG,
    RITEM,
    RKCUR,
    RLDNR,
    RLDNR_FIN,
    RMVCT,
    ROBUKRS,
    RPFLG,
    RRCTY,
    RTCUR,
    RTFLG,
    RUNIT,
    RVERS,
    RVSDOCNR,
    RYEAR,
    SBUSA,
    SCNTR,
    SEGMENT,
    SFAREA,
    SGTXT,
    SITYP,
    SPART,
    SUBIT,
    TIMESTAMP,
    TSL,
    UPDHP,
    UPPCU,
    USNAM,
    VKORG,
    VTWEG,
    WERKS,
    WSDAT,
    XBLNR,
    YRACQ,
    ZUONR
);