ACDOCU

Transparent Table Application Table
70 Fields 22 CDS Views

Group Journal Entries

ACDOCU is an SAP database table in S/4HANA. Group Journal Entries. It contains 70 fields. 22 CDS views read from this table.

CDS Views using this table (22)

ViewTypeJoinVDMDescription
E_CnsldtnGroupJrnlEntryItem view from EXTENSION Group Journal Entry Item - Extension
E_CnsldtnGroupJrnlEntryItem_2 view from EXTENSION Group Journal Entry Item - Extension
E_CnsldtnGroupJrnlEntryItem_3 view from EXTENSION Group Journal Entry Item - Extension
I_CnsldtnJrnlEntryItemTP view from TRANSACTIONAL Journal Entry Item
ICA_ConsJournalEntries view from Match Consolidation Journal Entry Lines
ICA_CONSJOURNALENTRIES_2 view from Match Consolidation Journal Entry Lines
ICA_CONSJOURNALENTRIES_3 view from Match Consolidation Journal Entry Lines
ICA_CONSJOURNALENTRIES_3C view_entity from Match Consolidation Journal Entry Lines
ICA_CONSJOURNALENTRIES_4 view from Match Consolidation Journal Entry Lines
ICA_CONSJOURNALENTRIES_5 view from Match Consolidation Journal Entry Lines
ICA_CONSJOURNALENTRIES_6 view_entity from ICA: Consolidation Journal Entry Line Items
ICA_CONSJOURNALENTRIES_7 view_entity from ICA: Consolidation Journal Entry Line Items
P_CnsldtnDataWCnsldtnLogic view from COMPOSITE Consolidation: Consolidated Data with Reporting Logic
P_CnsldtnDataWCnsldtnLogicYTD view from COMPOSITE Consolidation: Consolidated Data with Reporting Logic
P_CnsldtnGroupJrnlEntrItm view from BASIC Group Journal Entry Item Extraction
P_CnsldtnJrnlEntryMaxItem view from BASIC Group Journal Entry Header
P_CnsldtnJrnlEntryTP view from BASIC Group Journal Entry Header
P_IJE_LOG_DETAIL_PRE view from BASIC Import Journal Entries Log Details
P_Matrix_NewPCC view from COMPOSITE Matrix Consolidation: additional posting from new PCC
P_Matrix_VecPCC view from COMPOSITE Matrix Consolidation: For Vec, PCC Data
P_Matrix_VecPCC view union_all COMPOSITE Matrix Consolidation: For Vec, PCC Data
P_ReportedFinancialData_RL_AG view from COMPOSITE Reported Financial Data for Real-time Units

Fields (70)

KeyField Data ElementDescription DomainTypeLength
KEY rclnt mandt Client
KEY rldnr rldnr Ledger
KEY rdimen fc_dimen Dimension
KEY ryear gjahr Fiscal Year
KEY docnr belnr_d Document Number
KEY docln docln6 G/L Line Item
rrcty fc_rrcty Record Type
rvers fc_rvers Version
rtcur rtcur Currency
rhcur lcurr Local crcy
rkcur gcurr Ledger curr.
runit meins Base Unit
poper poper Posting Period
fiscyearper fincs_fiscyearper Period/Year
docct docct Document Categ.
rcomp rcomp_d Company
rbunit fc_bunit Cons. Unit
ritclg fc_itclg Cons. COA
ritem fc_item FS Item
rbuptr fc_buptr Partner Unit
rcongr fc_congr Cons. Group
robukrs obukr Orig. CC
sityp fc_sityp Subitem Category
subit fc_sitem Subitem
plevl fc_plevl Posting Level
rpflg fc_rpflg Apportionment
rtflg fc_rtflg CT Indicator
docty fc_docty Document Type
yracq fc_ryacq Acquis. Year
pracq rpacq Period of Acq.
coicu fc_coicu Investee Unit
uppcu fc_uppcu Investor Unit
tsl vtcur12 Amount in TC
hsl vlcur12 Local Crcy Amt
ksl vgcur12 Amnt in GrpCrcy
msl fincs_quan Quantity
tsl_csign vtcur12 Amount in TC
hsl_csign vlcur12 Local Crcy Amt
ksl_csign vgcur12 Amnt in GrpCrcy
msl_csign fincs_quan Quantity
sgtxt sgtxt Text
autom autom Auto. ID
activ glvor Bus.transaction
bvorg bvorg Cross-CC Number
budat budat Posting Date
wsdat wsdat Value Date
refdocnr belnr_d Document Number
refryear fc_oyear Original FY
refdocln buzei6 Item
refdocct docct Document Categ.
refactiv glvor Bus.transaction
timestamp timestamp Time Stamp
cpudt cpudt Entered On
cputm cputm Entered at
usnam usnam User Name
rvsdocnr stblg Reversed With
orndocnr stbln Reversed doc.
bunnr fincs_bunnr Document Bundle No.
coiac fc_coiac C/I Activity
coinr fc_coinr Activity Number
revyear fc_revyear Year of reversal doc
awtyp awtyp Ref. procedure
aworg aworg Refer. Org.Unit
logsys logsys Logical system
draft fincs_draft Draft
runid fincs_runid RunID
runreference fincs_runreference RunReference
cacti fincs_cacti
_dataaging data_temperature Data Aging
rcode ica_rcode Reason Code

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.

-- Group Journal Entries
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACDOCU (
    RCLNT,         -- Client [mandt]
    RLDNR,         -- Ledger [rldnr]
    RDIMEN,        -- Dimension [fc_dimen]
    RYEAR,         -- Fiscal Year [gjahr]
    DOCNR,         -- Document Number [belnr_d]
    DOCLN,         -- G/L Line Item [docln6]
    RRCTY,         -- Record Type [fc_rrcty]
    RVERS,         -- Version [fc_rvers]
    RTCUR,         -- Currency [rtcur]
    RHCUR,         -- Local crcy [lcurr]
    RKCUR,         -- Ledger curr. [gcurr]
    RUNIT,         -- Base Unit [meins]
    POPER,         -- Posting Period [poper]
    FISCYEARPER,   -- Period/Year [fincs_fiscyearper]
    DOCCT,         -- Document Categ. [docct]
    RCOMP,         -- Company [rcomp_d]
    RBUNIT,        -- Cons. Unit [fc_bunit]
    RITCLG,        -- Cons. COA [fc_itclg]
    RITEM,         -- FS Item [fc_item]
    RBUPTR,        -- Partner Unit [fc_buptr]
    RCONGR,        -- Cons. Group [fc_congr]
    ROBUKRS,       -- Orig. CC [obukr]
    SITYP,         -- Subitem Category [fc_sityp]
    SUBIT,         -- Subitem [fc_sitem]
    PLEVL,         -- Posting Level [fc_plevl]
    RPFLG,         -- Apportionment [fc_rpflg]
    RTFLG,         -- CT Indicator [fc_rtflg]
    DOCTY,         -- Document Type [fc_docty]
    YRACQ,         -- Acquis. Year [fc_ryacq]
    PRACQ,         -- Period of Acq. [rpacq]
    COICU,         -- Investee Unit [fc_coicu]
    UPPCU,         -- Investor Unit [fc_uppcu]
    TSL,           -- Amount in TC [vtcur12]
    HSL,           -- Local Crcy Amt [vlcur12]
    KSL,           -- Amnt in GrpCrcy [vgcur12]
    MSL,           -- Quantity [fincs_quan]
    TSL_CSIGN,     -- Amount in TC [vtcur12]
    HSL_CSIGN,     -- Local Crcy Amt [vlcur12]
    KSL_CSIGN,     -- Amnt in GrpCrcy [vgcur12]
    MSL_CSIGN,     -- Quantity [fincs_quan]
    SGTXT,         -- Text [sgtxt]
    AUTOM,         -- Auto. ID [autom]
    ACTIV,         -- Bus.transaction [glvor]
    BVORG,         -- Cross-CC Number [bvorg]
    BUDAT,         -- Posting Date [budat]
    WSDAT,         -- Value Date [wsdat]
    REFDOCNR,      -- Document Number [belnr_d]
    REFRYEAR,      -- Original FY [fc_oyear]
    REFDOCLN,      -- Item [buzei6]
    REFDOCCT,      -- Document Categ. [docct]
    REFACTIV,      -- Bus.transaction [glvor]
    TIMESTAMP,     -- Time Stamp [timestamp]
    CPUDT,         -- Entered On [cpudt]
    CPUTM,         -- Entered at [cputm]
    USNAM,         -- User Name [usnam]
    RVSDOCNR,      -- Reversed With [stblg]
    ORNDOCNR,      -- Reversed doc. [stbln]
    BUNNR,         -- Document Bundle No. [fincs_bunnr]
    COIAC,         -- C/I Activity [fc_coiac]
    COINR,         -- Activity Number [fc_coinr]
    REVYEAR,       -- Year of reversal doc [fc_revyear]
    AWTYP,         -- Ref. procedure [awtyp]
    AWORG,         -- Refer. Org.Unit [aworg]
    LOGSYS,        -- Logical system [logsys]
    DRAFT,         -- Draft [fincs_draft]
    RUNID,         -- RunID [fincs_runid]
    RUNREFERENCE,  -- RunReference [fincs_runreference]
    CACTI,         -- fincs_cacti
    _DATAAGING,    -- Data Aging [data_temperature]
    RCODE,         -- Reason Code [ica_rcode]
    PRIMARY KEY (RCLNT, RLDNR, RDIMEN, RYEAR, DOCNR, DOCLN)
);

Learn More