P_CNSLDTNINTEGRPTDFINDATA_RT
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_ReportedFinancialData_RL | view | union_all | COMPOSITE |
Fields (101)
| Key | Field | CDS Fields | Used 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
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA