ACES_POSTING

Transparent Table Temporary Data
106 Fields 1 CDS Views

GTT for Accruals Posting

ACES_POSTING is an SAP database table in S/4HANA. GTT for Accruals Posting. It contains 106 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ACCRUALSPOSTINGITEM view from CONSUMPTION

Fields (106)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY bukrs BUKRS Company Code
KEY comp ACE_COMP Component
KEY logsys ACE_LOGSYS Logical System
KEY ref_key ACE_OBJ_ID Accrual Object
KEY ref_subkey ACE_SUBOBJ_ID Accrual Subobject
KEY itemtype ACE_ITEMTYPE Accr Item Type
KEY ldgrp FAGL_LDGRP Ledger Group
KEY gjahr GJAHR Fiscal Year
KEY belnr BELNR_D Document Number
KEY docln DOCLN6 G/L Line Item
acrrefobj_id ACR_REFOBJ_ID Acr. Reference ID
ryear GJAHR_POS G/L Fiscal Year
poper POPER Posting Period
rldnr FINS_LEDGER Ledger
docnr_ld FINS_DOCNR_LD Ledger spec. DocNo
rrcty RRCTY Record Type
slalittype SLALITTYPE SLALineItemType
ttype ACE_TTYPE Accr Trans Type
vsource ACE_VSOURCE ACE Value Source
xaccr_ref ACE_XACCR_REF Accrual Assignment
racct RACCT Account Number
acrvaldat ACR_VALUE_DATE Accrual Value Date
bldat BLDAT Document Date
budat BUDAT Posting Date
perop_beg FM_PEROP_FI_LOW Per. of Perf. Start
perop_end FM_PEROP_FI_HIGH Per. of Perf. End
awitgrp FINS_AWITGRP Ref. Item Group
blart BLART Document Type
shkzg SHKZG Debit/Credit
bstat BSTAT_D Document Status
gkont GKONT Offsetting Acct
rwcur FINS_CURRW Transaction Currency
rhcur FINS_CURRH CompanyCode Currency
rkcur FINS_CURRK Global Currency
rocur FINS_CURR1 Free Defined Crcy 1
rvcur FINS_CURR2 Free Defined Crcy 2
rbcur FINS_CURR3 Free Defined Crcy 3
rccur FINS_CURR4 Free Defined Crcy 4
rdcur FINS_CURR5 Free Defined Crcy 5
recur FINS_CURR6 Free Defined Crcy 6
rfcur FINS_CURR7 Free Defined Crcy 7
rgcur FINS_CURR8 Free Defined Crcy 8
wsl FINS_VWCUR12 Amnt in Trans. Crcy
hsl FINS_VHCUR12 Amnt in Comp Cd Crcy
ksl FINS_VKCUR12 Amnt in Global Crcy
osl FINS_VOCUR12 Amount in Currency 1
vsl FINS_VVCUR12 Amount in Currency 2
bsl FINS_VBCUR12 Amount in Currency 3
csl FINS_VCCUR12 Amount in Currency 4
dsl FINS_VDCUR12 Amount in Currency 5
esl FINS_VECUR12 Amount in Currency 6
fsl FINS_VFCUR12 Amount in Currency 7
gsl FINS_VGCUR12 Amount in Currency 8
runit MEINS Base Unit
msl QUAN1_12 Quantity
gsber GSBER Business Area
prctr PRCTR Profit Center
segment FB_SEGMENT Segment
geber BP_GEBER Fund
fistl FISTL Funds Center
fipos FIPOS Commitment item
fkber FKBER Functional Area
grant_nbr GM_GRANT_NBR Grant
measure FM_MEASURE Funded Program
budget_pd FM_BUDGET_PERIOD Budget Period
kostl KOSTL Cost Center
aufnr AUFNR Order
ps_psp_pnr PS_PSP_PNR WBS Element
kstrg KSTRG Cost Object
lstar LSTAR Activity Type
nplnr NPLNR Network
vornr VORNR Activity
aufpl CO_AUFPL Plan No.f.Oper.
aplzl CIM_COUNT Counter
prznr CO_PRZNR Business Process
kdauf KDAUF Sales Order
kdpos KDPOS Sales Ord. Item
paobjnr RKEOBJNR Profit. segment
offstng_bukrs ACE_OFFSTNG_BUKRS Offstng Company Code
dummy_accrassgmt_incl_eew_ps CFD_DUMMY Dummy
mig_source FINS_ACDOC_MIG_SOURCE Migr. Source
timestamp TIMESTAMP Time Stamp
awtyp AWTYP Ref. procedure
awsys AWSYS Logical System
aworg AWORG Refer. Org.Unit
awref AWREF Reference Doc.
awitem FINS_AWITEM Ref. Doc. Item
vrgng CO_VORGANG Bus.Transaction
prec_awtyp FINS_PREC_AWTYP PrecRefTransact
prec_awsys FINS_PREC_AWSYS PrecRefLogSys
prec_aworg FINS_PREC_AWORG PrecRefOrgUnit
prec_awref FINS_PREC_AWREF PrecRefDocument
prec_awitem FINS_PREC_AWITEM Prec. Ref. Doc. Item
awtyp_rev AWTYP_REV ReversalRefTran
aworg_rev AWORG_REV Reversal Org.
awref_rev AWREF_REV Reversal Ref.
xreversing FINS_XREVERSING Is Reversing
xreversed FINS_XREVERSED Is Reversed
ebeln_logsys EBELN_LOGSYS LogSys of PurchDoc
ebeln EBELN Purchasing Doc.
ebelp EBELP Item
zekkn DZEKKN Account Assgmt No.
matnr MATNR Material
rmvct RMVCT Transact. Type
kokrs KOKRS CO Area

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.

-- GTT for Accruals Posting
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACES_POSTING (
    CLIENT,                        -- abap.clnt
    BUKRS,                         -- Company Code [BUKRS]
    COMP,                          -- Component [ACE_COMP]
    LOGSYS,                        -- Logical System [ACE_LOGSYS]
    REF_KEY,                       -- Accrual Object [ACE_OBJ_ID]
    REF_SUBKEY,                    -- Accrual Subobject [ACE_SUBOBJ_ID]
    ITEMTYPE,                      -- Accr Item Type [ACE_ITEMTYPE]
    LDGRP,                         -- Ledger Group [FAGL_LDGRP]
    GJAHR,                         -- Fiscal Year [GJAHR]
    BELNR,                         -- Document Number [BELNR_D]
    DOCLN,                         -- G/L Line Item [DOCLN6]
    ACRREFOBJ_ID,                  -- Acr. Reference ID [ACR_REFOBJ_ID]
    RYEAR,                         -- G/L Fiscal Year [GJAHR_POS]
    POPER,                         -- Posting Period [POPER]
    RLDNR,                         -- Ledger [FINS_LEDGER]
    DOCNR_LD,                      -- Ledger spec. DocNo [FINS_DOCNR_LD]
    RRCTY,                         -- Record Type [RRCTY]
    SLALITTYPE,                    -- SLALineItemType [SLALITTYPE]
    TTYPE,                         -- Accr Trans Type [ACE_TTYPE]
    VSOURCE,                       -- ACE Value Source [ACE_VSOURCE]
    XACCR_REF,                     -- Accrual Assignment [ACE_XACCR_REF]
    RACCT,                         -- Account Number [RACCT]
    ACRVALDAT,                     -- Accrual Value Date [ACR_VALUE_DATE]
    BLDAT,                         -- Document Date [BLDAT]
    BUDAT,                         -- Posting Date [BUDAT]
    PEROP_BEG,                     -- Per. of Perf. Start [FM_PEROP_FI_LOW]
    PEROP_END,                     -- Per. of Perf. End [FM_PEROP_FI_HIGH]
    AWITGRP,                       -- Ref. Item Group [FINS_AWITGRP]
    BLART,                         -- Document Type [BLART]
    SHKZG,                         -- Debit/Credit [SHKZG]
    BSTAT,                         -- Document Status [BSTAT_D]
    GKONT,                         -- Offsetting Acct [GKONT]
    RWCUR,                         -- Transaction Currency [FINS_CURRW]
    RHCUR,                         -- CompanyCode Currency [FINS_CURRH]
    RKCUR,                         -- Global Currency [FINS_CURRK]
    ROCUR,                         -- Free Defined Crcy 1 [FINS_CURR1]
    RVCUR,                         -- Free Defined Crcy 2 [FINS_CURR2]
    RBCUR,                         -- Free Defined Crcy 3 [FINS_CURR3]
    RCCUR,                         -- Free Defined Crcy 4 [FINS_CURR4]
    RDCUR,                         -- Free Defined Crcy 5 [FINS_CURR5]
    RECUR,                         -- Free Defined Crcy 6 [FINS_CURR6]
    RFCUR,                         -- Free Defined Crcy 7 [FINS_CURR7]
    RGCUR,                         -- Free Defined Crcy 8 [FINS_CURR8]
    WSL,                           -- Amnt in Trans. Crcy [FINS_VWCUR12]
    HSL,                           -- Amnt in Comp Cd Crcy [FINS_VHCUR12]
    KSL,                           -- Amnt in Global Crcy [FINS_VKCUR12]
    OSL,                           -- Amount in Currency 1 [FINS_VOCUR12]
    VSL,                           -- Amount in Currency 2 [FINS_VVCUR12]
    BSL,                           -- Amount in Currency 3 [FINS_VBCUR12]
    CSL,                           -- Amount in Currency 4 [FINS_VCCUR12]
    DSL,                           -- Amount in Currency 5 [FINS_VDCUR12]
    ESL,                           -- Amount in Currency 6 [FINS_VECUR12]
    FSL,                           -- Amount in Currency 7 [FINS_VFCUR12]
    GSL,                           -- Amount in Currency 8 [FINS_VGCUR12]
    RUNIT,                         -- Base Unit [MEINS]
    MSL,                           -- Quantity [QUAN1_12]
    GSBER,                         -- Business Area [GSBER]
    PRCTR,                         -- Profit Center [PRCTR]
    SEGMENT,                       -- Segment [FB_SEGMENT]
    GEBER,                         -- Fund [BP_GEBER]
    FISTL,                         -- Funds Center [FISTL]
    FIPOS,                         -- Commitment item [FIPOS]
    FKBER,                         -- Functional Area [FKBER]
    GRANT_NBR,                     -- Grant [GM_GRANT_NBR]
    MEASURE,                       -- Funded Program [FM_MEASURE]
    BUDGET_PD,                     -- Budget Period [FM_BUDGET_PERIOD]
    KOSTL,                         -- Cost Center [KOSTL]
    AUFNR,                         -- Order [AUFNR]
    PS_PSP_PNR,                    -- WBS Element [PS_PSP_PNR]
    KSTRG,                         -- Cost Object [KSTRG]
    LSTAR,                         -- Activity Type [LSTAR]
    NPLNR,                         -- Network [NPLNR]
    VORNR,                         -- Activity [VORNR]
    AUFPL,                         -- Plan No.f.Oper. [CO_AUFPL]
    APLZL,                         -- Counter [CIM_COUNT]
    PRZNR,                         -- Business Process [CO_PRZNR]
    KDAUF,                         -- Sales Order [KDAUF]
    KDPOS,                         -- Sales Ord. Item [KDPOS]
    PAOBJNR,                       -- Profit. segment [RKEOBJNR]
    OFFSTNG_BUKRS,                 -- Offstng Company Code [ACE_OFFSTNG_BUKRS]
    DUMMY_ACCRASSGMT_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    MIG_SOURCE,                    -- Migr. Source [FINS_ACDOC_MIG_SOURCE]
    TIMESTAMP,                     -- Time Stamp [TIMESTAMP]
    AWTYP,                         -- Ref. procedure [AWTYP]
    AWSYS,                         -- Logical System [AWSYS]
    AWORG,                         -- Refer. Org.Unit [AWORG]
    AWREF,                         -- Reference Doc. [AWREF]
    AWITEM,                        -- Ref. Doc. Item [FINS_AWITEM]
    VRGNG,                         -- Bus.Transaction [CO_VORGANG]
    PREC_AWTYP,                    -- PrecRefTransact [FINS_PREC_AWTYP]
    PREC_AWSYS,                    -- PrecRefLogSys [FINS_PREC_AWSYS]
    PREC_AWORG,                    -- PrecRefOrgUnit [FINS_PREC_AWORG]
    PREC_AWREF,                    -- PrecRefDocument [FINS_PREC_AWREF]
    PREC_AWITEM,                   -- Prec. Ref. Doc. Item [FINS_PREC_AWITEM]
    AWTYP_REV,                     -- ReversalRefTran [AWTYP_REV]
    AWORG_REV,                     -- Reversal Org. [AWORG_REV]
    AWREF_REV,                     -- Reversal Ref. [AWREF_REV]
    XREVERSING,                    -- Is Reversing [FINS_XREVERSING]
    XREVERSED,                     -- Is Reversed [FINS_XREVERSED]
    EBELN_LOGSYS,                  -- LogSys of PurchDoc [EBELN_LOGSYS]
    EBELN,                         -- Purchasing Doc. [EBELN]
    EBELP,                         -- Item [EBELP]
    ZEKKN,                         -- Account Assgmt No. [DZEKKN]
    MATNR,                         -- Material [MATNR]
    RMVCT,                         -- Transact. Type [RMVCT]
    KOKRS,                         -- CO Area [KOKRS]
    PRIMARY KEY (CLIENT, BUKRS, COMP, LOGSYS, REF_KEY, REF_SUBKEY, ITEMTYPE, LDGRP, GJAHR, BELNR, DOCLN)
);

Learn More