ACDOCU_DELTA

Transparent Table Temporary Data
131 Fields 1 CDS Views

Group Journal Entries Delta Storage

ACDOCU_DELTA is an SAP database table in S/4HANA. Group Journal Entries Delta Storage. It contains 131 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_CnsldtnPostingRuleLogltem view_entity union_all COMPOSITE

Fields (131)

KeyField Data ElementDescription DomainTypeLength
KEY rclnt MANDT Client
KEY rdimen FC_DIMEN Dimension
KEY ryear GJAHR Fiscal Year
KEY runid FINCS_RUNID RunID
KEY runreference FINCS_RUNREFERENCE RunReference
KEY packageid FINCS_PACKAGEID Package
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
bunnr FINCS_BUNNR Document Bundle No.
coiac FC_COIAC C/I Activity
coinr FC_COINR Activity Number
awtyp AWTYP Ref. procedure
aworg AWORG Refer. Org.Unit
logsys LOGSYS Logical system
ktopl KTOPL Chart of Accts
racct RACCT Account Number
xblnr XBLNR1 Reference
zuonr DZUONR Assignment
rcntr KOSTL Cost Center
prctr PRCTR Profit Center
rfarea FKBER Functional Area
rbusa GSBER Business Area
kokrs KOKRS CO Area
segment FB_SEGMENT Segment
scntr SKOST Sender cost ctr
pprctr PPRCTR Partner PC
sfarea SFKBER Partner FArea
sbusa PARGB Trdg Part.BA
rassc RASSC Trading Partner
psegment FB_PSEGMENT Partner Segment
aufnr AUFNR Order
kunnr KUNNR Customer
lifnr LIFNR Supplier
matnr MATNR Material
matkl_mm FINS_MATKL_MM Material Group
werks WERKS_D Plant
rmvct RMVCT Transactn type
ps_psp_pnr PS_PSP_PNR WBS Element
ps_posid PS_POSID WBS Element
ps_pspid PS_PSPID Project def.
fkart FKART Billing Type
vkorg VKORG Sales Org.
vtweg VTWEG Distr. Channel
spart SPART Division
matnr_copa FINS_MATNR_PA Product Sold
matkl FINS_MATKL_PA Product Sold Group
kdgrp KDGRP Customer Group
land1 COBL_LAND1_GP Country/Region
brsch BRSCH Industry
bzirk BZIRK Sales District
kunre KUNRE Bill-to Party
kunwe KUNWE Ship-to Party
konzs KONZS Group
fs_product_group FFS_PRODUCT_GROUP Product Group (FS)
branch_id FFS_BRANCH_ID Branch (FS)
datasource_id FFS_DATASOURCE_ID Data Source
rfund BP_GEBER Fund
rgrant_nbr GM_GRANT_NBR Grant
re_account FIS_RE_ACCOUNT Cash Origin Account
fikrs FIKRS FM Area
re_ktopl FINCS_RE_KTOPL Cash Origin ChtAccts
sfund BP_P_GEBER Partner Fund
ghgcategory SUFND_VDM_GHGCATEGORY GHG Category
ghgscope SUFND_VDM_GHGSCOPE GHG Scope
ghgscp2calcmeth SUFND_VDM_GHGSCP2CALCMETH GHG Scp 2 Calc Meth
ghgscp2contrinstr SUFND_VDM_GHGSCP2CONTRINSTR GHG Scp 2 Cntrctl In
susmodeoftransport SUFND_VDM_SUSMODEOFTRANSPORT Sust Mode of Transpt
ghgdtaqltycharc SUFND_VDM_GHGDTAQLTYCHARC GHG Data Qlty Charc
ghgenergyclass SUFND_VDM_GHGENERGYCLASS GHG Engy Classfctn
ghgenergymix SUFND_VDM_GHGENERGYMIX GHG Energy Mix
ghgengysrcgtype SUFND_VDM_GHGENGYSRCGTYPE GHG Engy Srcg Type
_dataaging DATA_TEMPERATURE Data Aging
adhocitem FINCS_ADHOCITEM Ad Hoc Item
adhocset FINCS_ADHOCSET Ad Hoc Set
adhocsetitem FINCS_ADHOCSETITEM Ad Hoc Set Item
rcode ICA_RCODE Reason Code
orig_type FINCS_ORIG_TYPE Origin Type
orig_ref FINCS_ORIG_REF Origin Ref.
dummy_cje_incl_eew_ps CFD_DUMMY Dummy
rulelogid FINCS_RT_LOG_ID Posting Rule Log ID
rule_group_id FINCS_RULGRP_ID Rule Group
row_number FINCS_RT_ROW_NUMBER Source Line
pstln_sequence FINCS_SEQUENCE Sequence

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 Delta Storage
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACDOCU_DELTA (
    RCLNT,                  -- Client [MANDT]
    RDIMEN,                 -- Dimension [FC_DIMEN]
    RYEAR,                  -- Fiscal Year [GJAHR]
    RUNID,                  -- RunID [FINCS_RUNID]
    RUNREFERENCE,           -- RunReference [FINCS_RUNREFERENCE]
    PACKAGEID,              -- Package [FINCS_PACKAGEID]
    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]
    BUNNR,                  -- Document Bundle No. [FINCS_BUNNR]
    COIAC,                  -- C/I Activity [FC_COIAC]
    COINR,                  -- Activity Number [FC_COINR]
    AWTYP,                  -- Ref. procedure [AWTYP]
    AWORG,                  -- Refer. Org.Unit [AWORG]
    LOGSYS,                 -- Logical system [LOGSYS]
    KTOPL,                  -- Chart of Accts [KTOPL]
    RACCT,                  -- Account Number [RACCT]
    XBLNR,                  -- Reference [XBLNR1]
    ZUONR,                  -- Assignment [DZUONR]
    RCNTR,                  -- Cost Center [KOSTL]
    PRCTR,                  -- Profit Center [PRCTR]
    RFAREA,                 -- Functional Area [FKBER]
    RBUSA,                  -- Business Area [GSBER]
    KOKRS,                  -- CO Area [KOKRS]
    SEGMENT,                -- Segment [FB_SEGMENT]
    SCNTR,                  -- Sender cost ctr [SKOST]
    PPRCTR,                 -- Partner PC [PPRCTR]
    SFAREA,                 -- Partner FArea [SFKBER]
    SBUSA,                  -- Trdg Part.BA [PARGB]
    RASSC,                  -- Trading Partner [RASSC]
    PSEGMENT,               -- Partner Segment [FB_PSEGMENT]
    AUFNR,                  -- Order [AUFNR]
    KUNNR,                  -- Customer [KUNNR]
    LIFNR,                  -- Supplier [LIFNR]
    MATNR,                  -- Material [MATNR]
    MATKL_MM,               -- Material Group [FINS_MATKL_MM]
    WERKS,                  -- Plant [WERKS_D]
    RMVCT,                  -- Transactn type [RMVCT]
    PS_PSP_PNR,             -- WBS Element [PS_PSP_PNR]
    PS_POSID,               -- WBS Element [PS_POSID]
    PS_PSPID,               -- Project def. [PS_PSPID]
    FKART,                  -- Billing Type [FKART]
    VKORG,                  -- Sales Org. [VKORG]
    VTWEG,                  -- Distr. Channel [VTWEG]
    SPART,                  -- Division [SPART]
    MATNR_COPA,             -- Product Sold [FINS_MATNR_PA]
    MATKL,                  -- Product Sold Group [FINS_MATKL_PA]
    KDGRP,                  -- Customer Group [KDGRP]
    LAND1,                  -- Country/Region [COBL_LAND1_GP]
    BRSCH,                  -- Industry [BRSCH]
    BZIRK,                  -- Sales District [BZIRK]
    KUNRE,                  -- Bill-to Party [KUNRE]
    KUNWE,                  -- Ship-to Party [KUNWE]
    KONZS,                  -- Group [KONZS]
    FS_PRODUCT_GROUP,       -- Product Group (FS) [FFS_PRODUCT_GROUP]
    BRANCH_ID,              -- Branch (FS) [FFS_BRANCH_ID]
    DATASOURCE_ID,          -- Data Source [FFS_DATASOURCE_ID]
    RFUND,                  -- Fund [BP_GEBER]
    RGRANT_NBR,             -- Grant [GM_GRANT_NBR]
    RE_ACCOUNT,             -- Cash Origin Account [FIS_RE_ACCOUNT]
    FIKRS,                  -- FM Area [FIKRS]
    RE_KTOPL,               -- Cash Origin ChtAccts [FINCS_RE_KTOPL]
    SFUND,                  -- Partner Fund [BP_P_GEBER]
    GHGCATEGORY,            -- GHG Category [SUFND_VDM_GHGCATEGORY]
    GHGSCOPE,               -- GHG Scope [SUFND_VDM_GHGSCOPE]
    GHGSCP2CALCMETH,        -- GHG Scp 2 Calc Meth [SUFND_VDM_GHGSCP2CALCMETH]
    GHGSCP2CONTRINSTR,      -- GHG Scp 2 Cntrctl In [SUFND_VDM_GHGSCP2CONTRINSTR]
    SUSMODEOFTRANSPORT,     -- Sust Mode of Transpt [SUFND_VDM_SUSMODEOFTRANSPORT]
    GHGDTAQLTYCHARC,        -- GHG Data Qlty Charc [SUFND_VDM_GHGDTAQLTYCHARC]
    GHGENERGYCLASS,         -- GHG Engy Classfctn [SUFND_VDM_GHGENERGYCLASS]
    GHGENERGYMIX,           -- GHG Energy Mix [SUFND_VDM_GHGENERGYMIX]
    GHGENGYSRCGTYPE,        -- GHG Engy Srcg Type [SUFND_VDM_GHGENGYSRCGTYPE]
    _DATAAGING,             -- Data Aging [DATA_TEMPERATURE]
    ADHOCITEM,              -- Ad Hoc Item [FINCS_ADHOCITEM]
    ADHOCSET,               -- Ad Hoc Set [FINCS_ADHOCSET]
    ADHOCSETITEM,           -- Ad Hoc Set Item [FINCS_ADHOCSETITEM]
    RCODE,                  -- Reason Code [ICA_RCODE]
    ORIG_TYPE,              -- Origin Type [FINCS_ORIG_TYPE]
    ORIG_REF,               -- Origin Ref. [FINCS_ORIG_REF]
    DUMMY_CJE_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    RULELOGID,              -- Posting Rule Log ID [FINCS_RT_LOG_ID]
    RULE_GROUP_ID,          -- Rule Group [FINCS_RULGRP_ID]
    ROW_NUMBER,             -- Source Line [FINCS_RT_ROW_NUMBER]
    PSTLN_SEQUENCE,         -- Sequence [FINCS_SEQUENCE]
    PRIMARY KEY (RCLNT, RDIMEN, RYEAR, RUNID, RUNREFERENCE, PACKAGEID, DOCNR, DOCLN)
);

Learn More