JV_JVSO1_ACDOCA_4A_4C

CDS View
88 Fields 1 CDS Views

JVSO1-like view on ACDOCA w/ JV ledgers

JV_JVSO1_ACDOCA_4A_4C is a CDS View in S/4HANA. JVSO1-like view on ACDOCA w/ JV ledgers. It contains 88 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
JV_JVSO1_ACDOCA_4A_4C_SWITCH view from JVSO1-like view on ACDOCA/JVSO1

Fields (88)

KeyField CDS FieldsUsed in Views
KEY docct docct 1
KEY docln_acd docln_acd 1
KEY docnr docnr 1
KEY drcrk drcrk 1
KEY gl_sirid gl_sirid 1
KEY poper poper 1
KEY rbukrs rbukrs 1
KEY rclnt rclnt 1
KEY rldnr rldnr 1
KEY rrcty rrcty 1
KEY rtcur rtcur 1
KEY runit runit 1
KEY rvers rvers 1
KEY ryear ryear 1
activ activ 1
aplzl aplzl 1
aufpl aufpl 1
aunit aunit 1
autom autom 1
aworg aworg 1
awtyp awtyp 1
bilid bilid 1
billm billm 1
bldat bldat 1
budat budat 1
cbcustomer cbcustomer 1
cbpayterm cbpayterm 1
cbperiod cbperiod 1
cbvendor cbvendor 1
condi condi 1
cpudt cpudt 1
cputm cputm 1
cycle cycle 1
docln docln 1
docty docty 1
ebeln ebeln 1
ebelp ebelp 1
hsl hsl 1
ksl ksl 1
ktosl ktosl 1
logsys logsys 1
lstar lstar 1
matnr matnr 1
mmact mmact 1
msl msl 1
mwskz mwskz 1
nplnr nplnr 1
orecid orecid 1
pom pom 1
prodper prodper 1
racct racct 1
ranbwa ranbwa 1
ranln1 ranln1 1
ranln2 ranln2 1
rbusa rbusa 1
rcntr rcntr 1
rdbillm rdbillm 1
rdpom rdpom 1
refactiv refactiv 1
refaworg refaworg 1
refawref refawref 1
refawtyp refawtyp 1
refcyc refcyc 1
refdocct refdocct 1
refdocln refdocln 1
refdocnr refdocnr 1
reffidln reffidln 1
reffidoc reffidoc 1
reflogsys reflogsys 1
refryear refryear 1
regrou regrou 1
rjvnam rjvnam 1
rkokrs rkokrs 1
rordnr rordnr 1
rpartn rpartn 1
rprctr rprctr 1
rprojk rprojk 1
rrecin rrecin 1
sdate sdate 1
seqname seqname 1
seqnr seqnr 1
sgtxt sgtxt 1
tsl tsl 1
usnam usnam 1
valut valut 1
vornr vornr 1
wsdat wsdat 1
xsbl xsbl 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.

-- JVSO1-like view on ACDOCA w/ JV ledgers
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE JV_JVSO1_ACDOCA_4A_4C (
    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,
    CYCLE,
    DOCLN,
    DOCTY,
    EBELN,
    EBELP,
    HSL,
    KSL,
    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,
    RJVNAM,
    RKOKRS,
    RORDNR,
    RPARTN,
    RPRCTR,
    RPROJK,
    RRECIN,
    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