JV_JVSO1_ACDOCA

CDS View
101 Fields 6 CDS Views

JVSO1-like view on ACDOCA

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

CDS Views using this table (6)

ViewTypeJoinVDMDescription
JV_JVSO1_ACDOCA_4A_4C view from JVSO1-like view on ACDOCA w/ JV ledgers
JV_JVSO1_ACDOCA_4A_4C view union JVSO1-like view on ACDOCA w/ JV ledgers
JV_JVSO1_ACDOCA_DOC_BALANCE view from Doc. bal. for JVSO1-like view on ACDOCA
JV_JVSO1_ACDOCA_SWITCH view from JVSO1-like view on ACDOCA/JVSO1
JV_JVTO1_ACDOCA_CFW_PREP view from JVTO1-like ACDOCA view for CFW amnts PR
JV_JVTO1_ACDOCA_INT view from Intermediate JVTO1-like view on ACDOCA

Fields (101)

KeyField CDS FieldsUsed in Views
KEY docct docct 2
KEY docln_acd docln_acd 2
KEY docnr docnr 2
KEY drcrk drcrk 2
KEY gl_sirid gl_sirid 2
KEY poper poper 2
KEY rbukrs rbukrs 2
KEY rclnt rclnt 1
KEY rldnr rldnr 1
KEY rrcty rrcty 2
KEY rtcur rtcur 2
KEY runit runit 2
KEY rvers rvers 2
KEY ryear ryear 2
activ activ 2
aplzl aplzl 2
aufpl aufpl 2
aunit aunit 2
autom autom 2
aworg aworg 2
awtyp awtyp 2
bilid bilid 2
billm billm 2
bldat bldat 2
budat budat 2
cbcustomer cbcustomer 2
cbpayterm cbpayterm 2
cbperiod cbperiod 2
cbvendor cbvendor 2
condi condi 2
cpudt cpudt 2
cputm cputm 2
curr1_4a curr1,curr1_4a 2
curr1_4c curr1,curr1_4c 2
curr2_4a curr2,curr2_4a 2
curr2_4c curr2,curr2_4c 2
curt1_4a curt1,curt1_4a 2
curt1_4c curt1,curt1_4c 2
curt2_4a curt2,curt2_4a 2
curt2_4c curt2,curt2_4c 2
cycle cycle 2
docln docln 2
docty docty 2
ebeln ebeln 2
ebelp ebelp 2
hsl hsl 2
hsl_4c hsl,hsl_4c,ksl 2
ksl ksl 2
ksl_4c ksl_4c 1
ktosl ktosl 2
logsys logsys 2
lstar lstar 2
matnr matnr 2
mmact mmact 2
msl msl 2
mwskz mwskz 2
nplnr nplnr 2
orecid orecid 2
pom pom 2
prodper prodper 2
racct racct 2
ranbwa ranbwa 2
ranln1 ranln1 2
ranln2 ranln2 2
rbusa rbusa 2
rcntr rcntr 2
rdbillm rdbillm 2
rdpom rdpom 2
refactiv refactiv 2
refaworg refaworg 2
refawref refawref 2
refawtyp refawtyp 2
refcyc refcyc 2
refdocct refdocct 2
refdocln refdocln 2
refdocnr refdocnr 2
reffidln reffidln 2
reffidoc reffidoc 2
reflogsys reflogsys 2
refryear refryear 2
regrou regrou 2
rhcur rhcur 1
rjvnam rjvnam 2
rkcur rkcur 1
rkokrs rkokrs 2
rordnr rordnr 2
rpartn rpartn 2
rprctr rprctr 2
rprojk rprojk 2
rrecin rrecin 2
sbrefln sbrefln 1
sdate sdate 2
seqname seqname 2
seqnr seqnr 2
sgtxt sgtxt 2
tsl tsl 2
usnam usnam 2
valut valut 2
vornr vornr 2
wsdat wsdat 2
xsbl xsbl 2

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.

-- JVSO1-like view on ACDOCA
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE JV_JVSO1_ACDOCA (
    DOCCT,
    DOCLN_ACD,
    DOCNR,
    DRCRK,
    GL_SIRID,
    POPER,
    RBUKRS,
    RCLNT,
    RLDNR,
    RRCTY,
    RTCUR,
    RUNIT,
    RVERS,
    RYEAR,
    ACTIV,
    APLZL,
    AUFPL,
    AUNIT,
    AUTOM,
    AWORG,
    AWTYP,
    BILID,
    BILLM,
    BLDAT,
    BUDAT,
    CBCUSTOMER,
    CBPAYTERM,
    CBPERIOD,
    CBVENDOR,
    CONDI,
    CPUDT,
    CPUTM,
    CURR1_4A,
    CURR1_4C,
    CURR2_4A,
    CURR2_4C,
    CURT1_4A,
    CURT1_4C,
    CURT2_4A,
    CURT2_4C,
    CYCLE,
    DOCLN,
    DOCTY,
    EBELN,
    EBELP,
    HSL,
    HSL_4C,
    KSL,
    KSL_4C,
    KTOSL,
    LOGSYS,
    LSTAR,
    MATNR,
    MMACT,
    MSL,
    MWSKZ,
    NPLNR,
    ORECID,
    POM,
    PRODPER,
    RACCT,
    RANBWA,
    RANLN1,
    RANLN2,
    RBUSA,
    RCNTR,
    RDBILLM,
    RDPOM,
    REFACTIV,
    REFAWORG,
    REFAWREF,
    REFAWTYP,
    REFCYC,
    REFDOCCT,
    REFDOCLN,
    REFDOCNR,
    REFFIDLN,
    REFFIDOC,
    REFLOGSYS,
    REFRYEAR,
    REGROU,
    RHCUR,
    RJVNAM,
    RKCUR,
    RKOKRS,
    RORDNR,
    RPARTN,
    RPRCTR,
    RPROJK,
    RRECIN,
    SBREFLN,
    SDATE,
    SEQNAME,
    SEQNR,
    SGTXT,
    TSL,
    USNAM,
    VALUT,
    VORNR,
    WSDAT,
    XSBL,
    PRIMARY KEY (DOCCT, DOCLN_ACD, DOCNR, DRCRK, GL_SIRID, POPER, RBUKRS, RCLNT, RLDNR, RRCTY, RTCUR, RUNIT, RVERS, RYEAR)
);

Learn More