Which tables does P_StandardizedDataEnhC use?

P_StandardizedDataEnhC reads from 6 data source(s): I_CnsldtnVersion, I_CnsldtnVersion, I_CnsldtnVersionRelation, I_CnsldtnVersionRelation, P_StandardizedData, P_StandardizedData.

How many fields does P_StandardizedDataEnhC have?

P_StandardizedDataEnhC has 245 fields.

P_StandardizedDataEnhC

DDL: P_STANDARDIZEDDATAENHC SQL: PSTANDARDDATENHC Type: view COMPOSITE Package: FCIN_UC

Consolidation: Standardized Data

P_StandardizedDataEnhC is a Composite CDS View that provides data about "Consolidation: Standardized Data" in SAP S/4HANA. It reads from 6 data sources and exposes 245 fields. Part of development package FCIN_UC.

Data Sources (6)

Source	Alias	Join Type
I_CnsldtnVersion	CnsldtnVersion	inner
I_CnsldtnVersion	CnsldtnVersion	inner
I_CnsldtnVersionRelation	CnsldtnVersionRelation	inner
I_CnsldtnVersionRelation	CnsldtnVersionRelation	inner
P_StandardizedData	StandardizedData	from
P_StandardizedData	StandardizedData	union_all

Annotations (12)

Name	Value	Level
AbapCatalog.preserveKey	true	view
AbapCatalog.sqlViewName	PSTANDARDDATENHC	view
AbapCatalog.compiler.compareFilter	true	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
VDM.private	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.sizeCategory	#XL	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (245)

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

@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PSTANDARDDATENHC'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm:#SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

define view P_StandardizedDataEnhC
  as select from P_StandardizedData       as StandardizedData

    inner join   I_CnsldtnVersionRelation as CnsldtnVersionRelation on CnsldtnVersionRelation.ConsolidationVersionElement = StandardizedData.rvers
    inner join   I_CnsldtnVersion         as CnsldtnVersion         on  CnsldtnVersion.ConsolidationVersion = CnsldtnVersionRelation.ConsolidationVersion
                                                                    and CnsldtnVersion.GroupCurrency        = StandardizedData.rkcur
{
  StandardizedData.rclnt,
  StandardizedData.gl_sirid,
  StandardizedData.rldnr,
  StandardizedData.rrcty,
  StandardizedData.rvers,
  CnsldtnVersionRelation.ConsolidationVersion,
  StandardizedData.ryear,
  StandardizedData.rtcur,
  StandardizedData.rhcur,
  StandardizedData.rkcur,
  StandardizedData.runit,
  StandardizedData.drcrk,
  StandardizedData.poper,
  StandardizedData.fiscyearper,
  StandardizedData.docct,
  StandardizedData.docnr,
  StandardizedData.docln,
  StandardizedData.rcomp,
  StandardizedData.rdimen,
  StandardizedData.rbunit,
  StandardizedData.ritclg,
  StandardizedData.ritem,
  StandardizedData.rbuptr,
  StandardizedData.rcongr,
  StandardizedData.robukrs,
  StandardizedData.sityp,
  StandardizedData.subit,
  StandardizedData.plevl,
  StandardizedData.rpflg,
  StandardizedData.rtflg,
  StandardizedData.docty,
  StandardizedData.yracq,
  StandardizedData.pracq,
  StandardizedData.coicu,
  StandardizedData.uppcu,
  StandardizedData.updhp,
  StandardizedData.tsl,
  StandardizedData.hsl,
  StandardizedData.ksl,
  StandardizedData.msl,
  StandardizedData.tsl_csign,
  StandardizedData.hsl_csign,
  StandardizedData.ksl_csign,
  StandardizedData.msl_csign,
  StandardizedData.sgtxt,
  StandardizedData.autom,
  StandardizedData.activ,
  StandardizedData.bvorg,
  StandardizedData.budat,
  StandardizedData.wsdat,
  StandardizedData.refdocnr,
  StandardizedData.refryear,
  StandardizedData.refdocln,
  StandardizedData.refdocct,
  StandardizedData.refactiv,
  StandardizedData.cpudt,
  StandardizedData.cputm,
  StandardizedData.usnam,
  StandardizedData.rvsdocnr,
  StandardizedData.orndocnr,
  StandardizedData.coiac,
  StandardizedData.coinr,
  StandardizedData.revyear,
  StandardizedData.awtyp,
  StandardizedData.aworg,
  StandardizedData.logsys,
  StandardizedData.timestamp,
  StandardizedData.racct,
  StandardizedData.rcntr,
  StandardizedData.prctr,
  StandardizedData.rfarea,
  StandardizedData.rbusa,
  StandardizedData.kokrs,
  StandardizedData.segment,
  StandardizedData.scntr,
  StandardizedData.pprctr,
  StandardizedData.sfarea,
  StandardizedData.sbusa,
  StandardizedData.rassc,
  StandardizedData.psegment,
  StandardizedData.rmvct,
  StandardizedData.matnr,
  StandardizedData.werks,
  StandardizedData.kunnr,
  StandardizedData.lifnr,
  StandardizedData.ps_posid,
  StandardizedData.ps_pspid,
  StandardizedData.fkart,
  StandardizedData.vkorg,
  StandardizedData.vtweg,
  StandardizedData.spart,
  StandardizedData.matnr_copa,
  StandardizedData.matkl,
  StandardizedData.kdgrp,
  StandardizedData.land1,
  StandardizedData.brsch,
  StandardizedData.bzirk,
  StandardizedData.kunre,
  StandardizedData.kunwe,
  StandardizedData.konzs,
  StandardizedData.zuonr,
  StandardizedData.aufnr,
  StandardizedData.xblnr,
  StandardizedData.matkl_mm,
  StandardizedData.ps_psp_pnr,
  StandardizedData.ktopl,
  StandardizedData.adhocitem,
  StandardizedData.adhocset,
  StandardizedData.adhocsetitem,
  StandardizedData.rcode,
  StandardizedData.orig_type,
  StandardizedData.orig_ref,
  StandardizedData.bunnr,

  //Industry-specific F: Banking Fields

  StandardizedData.fs_product_group,
  StandardizedData.branch_id,
  StandardizedData.datasource_id,

  // industry-specific fields  Financial services: Green House Fields

  StandardizedData.ghgcategory,
  StandardizedData.ghgscope,
  StandardizedData.ghgscp2calcmeth,
  StandardizedData.ghgscp2contrinstr,
  StandardizedData.susmodeoftransport,
  StandardizedData.ghgdtaqltycharc,
  StandardizedData.ghgenergyclass,
  StandardizedData.ghgenergymix,
  StandardizedData.ghgengysrcgtype,

  // industry-specific fields  Financial services: Public Sector Fields

  StandardizedData.fikrs,
  StandardizedData.rfund,
  StandardizedData.rgrant_nbr,
  StandardizedData.re_ktopl,
  StandardizedData.re_account,
  StandardizedData.bp_p_geber
}

union all select from P_StandardizedData       as StandardizedData

  inner join          I_CnsldtnVersionRelation as CnsldtnVersionRelation on CnsldtnVersionRelation.ConsolidationVersionElement = StandardizedData.rvers
  inner join          I_CnsldtnVersion         as CnsldtnVersion         on  CnsldtnVersion.ConsolidationVersion =  CnsldtnVersionRelation.ConsolidationVersion
                                                                         and CnsldtnVersion.GroupCurrency        <> StandardizedData.rkcur
{
  StandardizedData.rclnt,
  StandardizedData.gl_sirid,
  StandardizedData.rldnr,
  StandardizedData.rrcty,
  StandardizedData.rvers,
  CnsldtnVersionRelation.ConsolidationVersion,
  StandardizedData.ryear,
  StandardizedData.rtcur,
  StandardizedData.rhcur,
  cast('' as fincs_ui_gcurr)     as rkcur,
  StandardizedData.runit,
  StandardizedData.drcrk,
  StandardizedData.poper,
  StandardizedData.fiscyearper,
  StandardizedData.docct,
  StandardizedData.docnr,
  StandardizedData.docln,
  StandardizedData.rcomp,
  StandardizedData.rdimen,
  StandardizedData.rbunit,
  StandardizedData.ritclg,
  StandardizedData.ritem,
  StandardizedData.rbuptr,
  StandardizedData.rcongr,
  StandardizedData.robukrs,
  StandardizedData.sityp,
  StandardizedData.subit,
  StandardizedData.plevl,
  StandardizedData.rpflg,
  StandardizedData.rtflg,
  StandardizedData.docty,
  StandardizedData.yracq,
  StandardizedData.pracq,
  StandardizedData.coicu,
  StandardizedData.uppcu,
  StandardizedData.updhp,
  StandardizedData.tsl,
  StandardizedData.hsl,
  cast( '0' as fincs_ksl )       as ksl,
  StandardizedData.msl,
  StandardizedData.tsl_csign,
  StandardizedData.hsl_csign,
  cast( '0' as fincs_ksl_csign ) as ksl_csign,
  StandardizedData.msl_csign,
  StandardizedData.sgtxt,
  StandardizedData.autom,
  StandardizedData.activ,
  StandardizedData.bvorg,
  StandardizedData.budat,
  StandardizedData.wsdat,
  StandardizedData.refdocnr,
  StandardizedData.refryear,
  StandardizedData.refdocln,
  StandardizedData.refdocct,
  StandardizedData.refactiv,
  StandardizedData.cpudt,
  StandardizedData.cputm,
  StandardizedData.usnam,
  StandardizedData.rvsdocnr,
  StandardizedData.orndocnr,
  StandardizedData.coiac,
  StandardizedData.coinr,
  StandardizedData.revyear,
  StandardizedData.awtyp,
  StandardizedData.aworg,
  StandardizedData.logsys,
  StandardizedData.timestamp,
  StandardizedData.racct,
  StandardizedData.rcntr,
  StandardizedData.prctr,
  StandardizedData.rfarea,
  StandardizedData.rbusa,
  StandardizedData.kokrs,
  StandardizedData.segment,
  StandardizedData.scntr,
  StandardizedData.pprctr,
  StandardizedData.sfarea,
  StandardizedData.sbusa,
  StandardizedData.rassc,
  StandardizedData.psegment,
  StandardizedData.rmvct,
  StandardizedData.matnr,
  StandardizedData.werks,
  StandardizedData.kunnr,
  StandardizedData.lifnr,
  StandardizedData.ps_posid,
  StandardizedData.ps_pspid,
  StandardizedData.fkart,
  StandardizedData.vkorg,
  StandardizedData.vtweg,
  StandardizedData.spart,
  StandardizedData.matnr_copa,
  StandardizedData.matkl,
  StandardizedData.kdgrp,
  StandardizedData.land1,
  StandardizedData.brsch,
  StandardizedData.bzirk,
  StandardizedData.kunre,
  StandardizedData.kunwe,
  StandardizedData.konzs,
  StandardizedData.zuonr,
  StandardizedData.aufnr,
  StandardizedData.xblnr,
  StandardizedData.matkl_mm,
  StandardizedData.ps_psp_pnr,
  StandardizedData.ktopl,
  StandardizedData.adhocitem,
  StandardizedData.adhocset,
  StandardizedData.adhocsetitem,
  StandardizedData.rcode,
  StandardizedData.orig_type,
  StandardizedData.orig_ref,
  StandardizedData.bunnr,

  //Industry-specific F: Banking Fields

  StandardizedData.fs_product_group,
  StandardizedData.branch_id,
  StandardizedData.datasource_id,

  // industry-specific fields  Financial services: Green House Fields

  StandardizedData.ghgcategory,
  StandardizedData.ghgscope,
  StandardizedData.ghgscp2calcmeth,
  StandardizedData.ghgscp2contrinstr,
  StandardizedData.susmodeoftransport,
  StandardizedData.ghgdtaqltycharc,
  StandardizedData.ghgenergyclass,
  StandardizedData.ghgenergymix,
  StandardizedData.ghgengysrcgtype,

  // industry-specific fields  Financial services: Public Sector Fields

  StandardizedData.fikrs,
  StandardizedData.rfund,
  StandardizedData.rgrant_nbr,
  StandardizedData.re_ktopl,
  StandardizedData.re_account,
  StandardizedData.bp_p_geber
}

Depth:

P_StandardizedDataEnhC view

P_Matrix_CP_GroupDerived view