P_STANDARDIZEDDATA

CDS View
130 Fields 7 CDS Views

P_STANDARDIZEDDATA is a CDS View in S/4HANA. It contains 130 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
P_Matrix_PreparedSFDForCGDeriv view from COMPOSITE
P_Matrix_SFDWGroupDerived view from COMPOSITE
P_Matrix_VecSFD view from COMPOSITE
P_StandardizedDataEnhC view from COMPOSITE
P_StandardizedDataEnhC view union_all COMPOSITE
P_StandardizedDataWithParam view from COMPOSITE
P_VECStandardizedData_01 view from COMPOSITE

Fields (130)

KeyField CDS FieldsUsed in Views
activ activ 1
adhocitem adhocitem 1
adhocset adhocset 1
adhocsetitem adhocsetitem 1
aufnr aufnr 1
autom autom 1
aworg aworg 1
awtyp awtyp 1
bp_p_geber bp_p_geber 1
branch_id branch_id 1
brsch brsch 1
budat budat 1
bunnr bunnr 1
bvorg bvorg 1
bzirk bzirk 1
coiac coiac 1
coicu coicu 1
coinr coinr 1
cpudt cpudt 1
cputm cputm 1
datasource_id datasource_id 1
docct docct 1
docln docln 1
docnr docnr 1
docty docty 1
drcrk drcrk 1
fikrs fikrs 1
fiscyearper fiscyearper 1
fkart fkart 1
fs_product_group fs_product_group 1
ghgcategory ghgcategory 1
ghgdtaqltycharc ghgdtaqltycharc 1
ghgenergyclass ghgenergyclass 1
ghgenergymix ghgenergymix 1
ghgengysrcgtype ghgengysrcgtype 1
ghgscope ghgscope 1
ghgscp2calcmeth ghgscp2calcmeth 1
ghgscp2contrinstr ghgscp2contrinstr 1
gl_sirid gl_sirid 1
hsl hsl 1
hsl_csign hsl_csign 1
kdgrp kdgrp 1
kokrs kokrs 1
konzs konzs 1
ksl ksl 1
ksl_csign ksl_csign 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
msl_csign msl_csign 1
orig_ref orig_ref 1
orig_type orig_type 1
orndocnr orndocnr 1
plevl plevl 1
poper poper,poper_posting 2
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
rclnt rclnt 1
rcntr rcntr 1
rcode rcode 1
rcomp rcomp 1
rcongr rcongr 1
rdimen rdimen 1
re_account re_account 1
re_ktopl re_ktopl 1
refactiv refactiv 1
refdocct refdocct 1
refdocln refdocln 1
refdocnr refdocnr 1
refryear refryear 1
revyear revyear 1
rfarea rfarea 1
rfund rfund 1
rgrant_nbr rgrant_nbr 1
rhcur rhcur 1
ritclg ritclg 1
ritem ritem 1
rkcur rkcur 1
rldnr rldnr 1
rmvct rmvct 1
robukrs robukrs 1
rpflg rpflg 1
rrcty rrcty 1
rtcur rtcur 1
rtflg rtflg 1
runit runit 1
rvers rvers 2
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
susmodeoftransport susmodeoftransport 1
timestamp timestamp 1
tsl tsl 1
tsl_csign tsl_csign 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_STANDARDIZEDDATA (
    ACTIV,
    ADHOCITEM,
    ADHOCSET,
    ADHOCSETITEM,
    AUFNR,
    AUTOM,
    AWORG,
    AWTYP,
    BP_P_GEBER,
    BRANCH_ID,
    BRSCH,
    BUDAT,
    BUNNR,
    BVORG,
    BZIRK,
    COIAC,
    COICU,
    COINR,
    CPUDT,
    CPUTM,
    DATASOURCE_ID,
    DOCCT,
    DOCLN,
    DOCNR,
    DOCTY,
    DRCRK,
    FIKRS,
    FISCYEARPER,
    FKART,
    FS_PRODUCT_GROUP,
    GHGCATEGORY,
    GHGDTAQLTYCHARC,
    GHGENERGYCLASS,
    GHGENERGYMIX,
    GHGENGYSRCGTYPE,
    GHGSCOPE,
    GHGSCP2CALCMETH,
    GHGSCP2CONTRINSTR,
    GL_SIRID,
    HSL,
    HSL_CSIGN,
    KDGRP,
    KOKRS,
    KONZS,
    KSL,
    KSL_CSIGN,
    KTOPL,
    KUNNR,
    KUNRE,
    KUNWE,
    LAND1,
    LIFNR,
    LOGSYS,
    MATKL,
    MATKL_MM,
    MATNR,
    MATNR_COPA,
    MSL,
    MSL_CSIGN,
    ORIG_REF,
    ORIG_TYPE,
    ORNDOCNR,
    PLEVL,
    POPER,
    PPRCTR,
    PRACQ,
    PRCTR,
    PS_POSID,
    PS_PSP_PNR,
    PS_PSPID,
    PSEGMENT,
    RACCT,
    RASSC,
    RBUNIT,
    RBUPTR,
    RBUSA,
    RCLNT,
    RCNTR,
    RCODE,
    RCOMP,
    RCONGR,
    RDIMEN,
    RE_ACCOUNT,
    RE_KTOPL,
    REFACTIV,
    REFDOCCT,
    REFDOCLN,
    REFDOCNR,
    REFRYEAR,
    REVYEAR,
    RFAREA,
    RFUND,
    RGRANT_NBR,
    RHCUR,
    RITCLG,
    RITEM,
    RKCUR,
    RLDNR,
    RMVCT,
    ROBUKRS,
    RPFLG,
    RRCTY,
    RTCUR,
    RTFLG,
    RUNIT,
    RVERS,
    RVSDOCNR,
    RYEAR,
    SBUSA,
    SCNTR,
    SEGMENT,
    SFAREA,
    SGTXT,
    SITYP,
    SPART,
    SUBIT,
    SUSMODEOFTRANSPORT,
    TIMESTAMP,
    TSL,
    TSL_CSIGN,
    UPDHP,
    UPPCU,
    USNAM,
    VKORG,
    VTWEG,
    WERKS,
    WSDAT,
    XBLNR,
    YRACQ,
    ZUONR
);

Learn More