ACE_ACDOCA_MIG_ACCR
Get original source from ACDOCA
ACE_ACDOCA_MIG_ACCR is a CDS View in S/4HANA. Get original source from ACDOCA. It contains 21 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| ACE_ACDOCA_MIG_ACRTYPE_RULE | view | from | Get original source from ACDOCA |
Fields (21)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | acrobjtype | acrobjtype | 1 |
| KEY | gjahr | gjahr | 1 |
| KEY | rbukrs | rbukrs | 1 |
| acritmtype | acritmtype | 1 | |
| acrobj_id | acrobj_id | 1 | |
| acrsobj_id | acrsobj_id | 1 | |
| awkey | awkey | 1 | |
| awsys | awsys | 1 | |
| awtyp | awtyp | 1 | |
| currency | currency | 1 | |
| effdate | effdate | 1 | |
| mig_source | mig_source | 1 | |
| podate | podate | 1 | |
| poper | poper | 1 | |
| poyear | poyear | 1 | |
| pre_gjahr | pre_gjahr | 1 | |
| rldnr | rldnr | 1 | |
| slalittype | slalittype | 1 | |
| timestamp | timestamp | 1 | |
| transtype | transtype | 1 | |
| valtbp | valtbp | 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.
-- Get original source from ACDOCA
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACE_ACDOCA_MIG_ACCR (
ACROBJTYPE,
GJAHR,
RBUKRS,
ACRITMTYPE,
ACROBJ_ID,
ACRSOBJ_ID,
AWKEY,
AWSYS,
AWTYP,
CURRENCY,
EFFDATE,
MIG_SOURCE,
PODATE,
POPER,
POYEAR,
PRE_GJAHR,
RLDNR,
SLALITTYPE,
TIMESTAMP,
TRANSTYPE,
VALTBP,
PRIMARY KEY (ACROBJTYPE, 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