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