JV_ACDOCA_BILLING
JVA view on ACDOCA for partner billing
JV_ACDOCA_BILLING is a CDS View in S/4HANA. JVA view on ACDOCA for partner billing. It contains 53 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| JV_ACDOCA_JVSO2_SWITCH | view | from | ACDOCA-like view on JVSO2/ACDOCA |
Fields (53)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | belnr | belnr | 1 |
| KEY | docln | docln | 1 |
| KEY | gjahr | gjahr | 1 |
| KEY | rbukrs | rbukrs | 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 | |
| co_belnr | co_belnr | 1 | |
| co_buzei | co_buzei | 1 | |
| cpudt | cpudt | 1 | |
| csl | csl | 1 | |
| drcrk | drcrk | 1 | |
| dsl | dsl | 1 | |
| egrup | egrup | 1 | |
| esl | esl | 1 | |
| fsl | fsl | 1 | |
| gsl | gsl | 1 | |
| hsl | hsl | 1 | |
| jvactivity | jvactivity | 1 | |
| ksl | ksl | 1 | |
| kunnr | kunnr | 1 | |
| osl | osl | 1 | |
| pom | pom | 1 | |
| poper | poper | 1 | |
| rbcur | rbcur | 1 | |
| rccur | rccur | 1 | |
| rdcur | rdcur | 1 | |
| recur | recur | 1 | |
| rfcur | rfcur | 1 | |
| rgcur | rgcur | 1 | |
| rhcur | rhcur | 1 | |
| rkcur | rkcur | 1 | |
| rocur | rocur | 1 | |
| rvcur | rvcur | 1 | |
| rwcur | rwcur | 1 | |
| ryear | ryear | 1 | |
| sgtxt | sgtxt | 1 | |
| timestamp | timestamp | 1 | |
| usnam | usnam | 1 | |
| vname | vname | 1 | |
| vorgn | vorgn | 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.
-- JVA view on ACDOCA for partner billing
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE JV_ACDOCA_BILLING (
BELNR,
DOCLN,
GJAHR,
RBUKRS,
AWITEM,
AWORG,
AWREF,
AWSYS,
AWTYP,
BILLM,
BLART,
BLDAT,
BSL,
BTYPE,
BUDAT,
BUZEI,
CO_BELNR,
CO_BUZEI,
CPUDT,
CSL,
DRCRK,
DSL,
EGRUP,
ESL,
FSL,
GSL,
HSL,
JVACTIVITY,
KSL,
KUNNR,
OSL,
POM,
POPER,
RBCUR,
RCCUR,
RDCUR,
RECUR,
RFCUR,
RGCUR,
RHCUR,
RKCUR,
ROCUR,
RVCUR,
RWCUR,
RYEAR,
SGTXT,
TIMESTAMP,
USNAM,
VNAME,
VORGN,
VPTNR,
VSL,
WSL,
PRIMARY KEY (BELNR, DOCLN, GJAHR, RBUKRS)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA