JV_ACDOCA_JVSO1

CDS View
92 Fields 1 CDS Views

ACDOCA-like view on JVSO1

JV_ACDOCA_JVSO1 is a CDS View in S/4HANA. ACDOCA-like view on JVSO1. It contains 92 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
JV_ACDOCA_JVSO1_SWITCH view union ACDOCA-like view on JVSO1/ACDOCA

Fields (92)

KeyField CDS FieldsUsed in Views
KEY belnr belnr 1
KEY docln docln 1
KEY gjahr gjahr 1
KEY rbukrs rbukrs 1
accasty accasty 1
anbwa anbwa 1
anln1 anln1 1
anln2 anln2 1
aufnr aufnr 1
awitem awitem 1
aworg aworg 1
awref awref 1
awsys awsys 1
awtyp awtyp 1
billm billm 1
blart blart 1
bldat bldat 1
bsl bsl 1
btype btype 1
budat budat 1
buzei buzei 1
cbrunid cbrunid 1
co_belnr co_belnr 1
co_buzei co_buzei 1
csl csl 1
drcrk drcrk 1
dsl dsl 1
ebeln ebeln 1
ebelp ebelp 1
egrup egrup 1
esl esl 1
etype etype 1
fsl fsl 1
gsl gsl 1
hsl hsl 1
jv_docnr jv_docnr 1
jvactivity jvactivity 1
kokrs kokrs 1
ksl ksl 1
ktosl ktosl 1
kunnr kunnr 1
lifnr lifnr 1
lstar lstar 1
matnr matnr 1
msl msl 1
mwskz mwskz 1
nplnr nplnr 1
nplnr_vorgn nplnr_vorgn 1
objnr objnr 1
osl osl 1
pom pom 1
poper poper 1
prctr prctr 1
prec_awitem prec_awitem 1
prec_aworg prec_aworg 1
prec_awref prec_awref 1
prec_awsys prec_awsys 1
prec_awtyp prec_awtyp 1
prodper prodper 1
ps_psp_pnr ps_psp_pnr 1
racct racct 1
rbcur rbcur 1
rbusa rbusa 1
rccur rccur 1
rcntr rcntr 1
rdcur rdcur 1
recid recid 1
recur recur 1
rfcur rfcur 1
rgcur rgcur 1
rhcur rhcur 1
rkcur rkcur 1
rocur rocur 1
runit runit 1
rvcur rvcur 1
rwcur rwcur 1
ryear ryear 1
sgtxt sgtxt 1
src_awitem src_awitem 1
src_aworg src_aworg 1
src_awref src_awref 1
src_awsys src_awsys 1
src_awtyp src_awtyp 1
timestamp timestamp 1
usnam usnam 1
valut valut 1
vname vname 1
vorgn vorgn 1
vornr vornr 1
vptnr vptnr 1
vsl vsl 1
wsl wsl 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.

-- ACDOCA-like view on JVSO1
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE JV_ACDOCA_JVSO1 (
    BELNR,
    DOCLN,
    GJAHR,
    RBUKRS,
    ACCASTY,
    ANBWA,
    ANLN1,
    ANLN2,
    AUFNR,
    AWITEM,
    AWORG,
    AWREF,
    AWSYS,
    AWTYP,
    BILLM,
    BLART,
    BLDAT,
    BSL,
    BTYPE,
    BUDAT,
    BUZEI,
    CBRUNID,
    CO_BELNR,
    CO_BUZEI,
    CSL,
    DRCRK,
    DSL,
    EBELN,
    EBELP,
    EGRUP,
    ESL,
    ETYPE,
    FSL,
    GSL,
    HSL,
    JV_DOCNR,
    JVACTIVITY,
    KOKRS,
    KSL,
    KTOSL,
    KUNNR,
    LIFNR,
    LSTAR,
    MATNR,
    MSL,
    MWSKZ,
    NPLNR,
    NPLNR_VORGN,
    OBJNR,
    OSL,
    POM,
    POPER,
    PRCTR,
    PREC_AWITEM,
    PREC_AWORG,
    PREC_AWREF,
    PREC_AWSYS,
    PREC_AWTYP,
    PRODPER,
    PS_PSP_PNR,
    RACCT,
    RBCUR,
    RBUSA,
    RCCUR,
    RCNTR,
    RDCUR,
    RECID,
    RECUR,
    RFCUR,
    RGCUR,
    RHCUR,
    RKCUR,
    ROCUR,
    RUNIT,
    RVCUR,
    RWCUR,
    RYEAR,
    SGTXT,
    SRC_AWITEM,
    SRC_AWORG,
    SRC_AWREF,
    SRC_AWSYS,
    SRC_AWTYP,
    TIMESTAMP,
    USNAM,
    VALUT,
    VNAME,
    VORGN,
    VORNR,
    VPTNR,
    VSL,
    WSL,
    PRIMARY KEY (BELNR, DOCLN, GJAHR, RBUKRS)
);

Learn More