Fields (50)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| aufnr | aufnr | 1 | |
| augbl | augbl,ClearingAccountingDocument | 2 | |
| augdt | augdt,ClearingDate | 2 | |
| awref | ReferenceDocument | 1 | |
| awtyp | awtyp | 1 | |
| belnr | AccountingDocument | 2 | |
| brsch | brsch | 1 | |
| bstat | bstat | 1 | |
| budat | budat | 1 | |
| bzirk | bzirk | 1 | |
| docln | LedgerGLLineItem | 2 | |
| fkart | fkart | 1 | |
| gjahr | FiscalYear | 2 | |
| glaccount_type | glaccount_type | 1 | |
| kdgrp | kdgrp | 1 | |
| koart | FinancialAccountType | 1 | |
| kokrs | kokrs | 1 | |
| konzs | konzs | 1 | |
| ktosl | ktosl | 1 | |
| kunnr | kunnr | 1 | |
| kunre | kunre | 1 | |
| kunwe | kunwe | 1 | |
| land1 | land1 | 1 | |
| lifnr | lifnr | 1 | |
| matkl | matkl | 1 | |
| matkl_mm | matkl_mm | 1 | |
| matnr | matnr | 1 | |
| matnr_copa | matnr_copa | 1 | |
| netdt | NetDueDate | 1 | |
| poper | poper | 1 | |
| pprctr | pprctr | 1 | |
| ps_posid | ps_posid | 1 | |
| ps_psp_pnr | ps_psp_pnr | 1 | |
| ps_pspid | ps_pspid | 1 | |
| psegment | psegment | 1 | |
| rassc | rassc | 1 | |
| rbukrs | SourceCompanyCode | 2 | |
| rldnr | Ledger,SourceLedger | 2 | |
| sbusa | sbusa | 1 | |
| scntr | scntr | 1 | |
| sfarea | sfarea | 1 | |
| slalittype | slalittype | 1 | |
| spart | spart | 1 | |
| timestamp | Timestamp | 3 | |
| vkorg | vkorg | 1 | |
| vorgn | vorgn | 1 | |
| vornr | vornr | 1 | |
| vtweg | vtweg | 1 | |
| werks | werks | 1 | |
| zuonr | zuonr | 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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _ACDOCA (
AUFNR,
AUGBL,
AUGDT,
AWREF,
AWTYP,
BELNR,
BRSCH,
BSTAT,
BUDAT,
BZIRK,
DOCLN,
FKART,
GJAHR,
GLACCOUNT_TYPE,
KDGRP,
KOART,
KOKRS,
KONZS,
KTOSL,
KUNNR,
KUNRE,
KUNWE,
LAND1,
LIFNR,
MATKL,
MATKL_MM,
MATNR,
MATNR_COPA,
NETDT,
POPER,
PPRCTR,
PS_POSID,
PS_PSP_PNR,
PS_PSPID,
PSEGMENT,
RASSC,
RBUKRS,
RLDNR,
SBUSA,
SCNTR,
SFAREA,
SLALITTYPE,
SPART,
TIMESTAMP,
VKORG,
VORGN,
VORNR,
VTWEG,
WERKS,
ZUONR
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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