ACESOBJ_ITEM

Transparent Table Application Table
48 Fields 16 CDS Views

Item Data for Accrual Subobject

ACESOBJ_ITEM is an SAP database table in S/4HANA. Item Data for Accrual Subobject. It contains 48 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
ACE_ACEDSOH_VIEW_01 view from Compatibility view for ACEDSOH 1
ACE_ACEDSOH_VIEW_01 view union_all Compatibility view for ACEDSOH 1
ACE_ACEDSOI_ACCTS_TD view from Generate Time-Dependence View for Acct
ACE_ACEDSOI_CMPATBL view from Compatibility view for ACEDSOI
ACE_ACEDSOI_CMPATBL view union_all Compatibility view for ACEDSOI
FACRA_RUN_PROGRAM view left_outer
I_AccrEngineAccrItemRawData view from BASIC Accrual Item Raw Data
I_AccrEngineAccrSubobjLifeCyc view from BASIC Accrual Subobject Life Cycle
I_AccrEngineAccrSubobjRawItem view from BASIC Accrual Subobject Raw Item
I_AccrualSubObjItem view from BASIC Accrual Sub Object Item
I_AROAccrualObjectItemData view from BASIC ARO Accrual Object Item Data
P_AccrEngnAccrPostgAccrItem view_entity inner BASIC
P_AccrEngnAccrPostgOffstgItem view_entity inner BASIC
P_AccrEngnRptgMaxAccrValDte view_entity inner COMPOSITE
P_ACCRUALOBJECT_ITEM_TOTAL view from BASIC
P_ACCRUALOBJECTPERIOD_ALL view from BASIC

Fields (48)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY comp ACE_COMP Component
KEY logsys ACE_LOGSYS Logical System
KEY bukrs ACE_BUKRS Company Code
KEY ref_key ACE_OBJ_ID Accrual Object
KEY ref_subkey ACE_SUBOBJ_ID Accrual Subobject
KEY itemtype ACE_ITEMTYPE Accr Item Type
KEY rldnr FINS_LEDGER Ledger
KEY date_to ACE_DATETO To
date_from ACE_DATEFROM From
quantity ACE_TOTAL_QUANTITY Total Qty to Accrue
unit ACE_UNIT Unit of Measure
acrmethod ACEDS_ACRMETHOD Accr/Defrl Method
life_start_date ACE_LIFE_START_DATE Start of Life
life_end_date ACE_LIFE_END_DATE End of Life
xobsolete ACEDS_XOBSOLETE Obsolete
inc_offstng_accnt ACE_ACCNT_INCEPTION_OFFSETTING Offsetting Account
inc_accr_accnt ACE_ACCNT_INCEPTION_ACCRUAL Accr./Dfrl Acct
per_accr_accnt ACE_ACCNT_PERIODIC_ACCRUAL Accr./Dfrl. Account
per_offstng_accnt ACE_ACCNT_PERIODIC_OFFSETTING Offsetting Account
fin_accr_accnt ACE_ACCNT_FINAL_ACCRUAL Accr./Dfrl Acct
fin_offstng_accnt ACE_ACCNT_FINAL_OFFSETTING Offsetting Account
inc_doc_type ACEPS_INC_BLART Document Type
per_doc_type ACEPS_PER_BLART Document Type
fin_doc_type ACEPS_FIN_BLART Document Type
total_accr_amnt_wsl ACE_TOTAL_PER_ACCR_AMNT_WCURR Total A/D Amt (TC)
total_accr_amnt_hsl ACE_TOTAL_PER_ACCR_AMNT_HCURR Total A/D Amt (CC)
total_accr_amnt_ksl ACE_TOTAL_PER_ACCR_AMNT_KCURR Total A/D Amt (GC)
total_accr_amnt_osl ACE_TOTAL_PER_ACCR_AMNT_OCURR Total A/D Amt (FC1)
total_accr_amnt_vsl ACE_TOTAL_PER_ACCR_AMNT_VCURR Total A/D Amt (FC2)
total_accr_amnt_bsl ACE_TOTAL_PER_ACCR_AMNT_BCURR Total A/D Amt (FC3)
total_accr_amnt_csl ACE_TOTAL_PER_ACCR_AMNT_CCURR Total A/D Amt (FC4)
total_accr_amnt_dsl ACE_TOTAL_PER_ACCR_AMNT_DCURR Total A/D Amt (FC5)
total_accr_amnt_esl ACE_TOTAL_PER_ACCR_AMNT_ECURR Total A/D Amt (FC6)
total_accr_amnt_fsl ACE_TOTAL_PER_ACCR_AMNT_FCURR Total A/D Amt (FC7)
total_accr_amnt_gsl ACE_TOTAL_PER_ACCR_AMNT_GCURR Total A/D Amt (FC8)
rwcurttl FINS_CURRW Transaction Currency
rhcurttl FINS_CURRH CompanyCode Currency
rkcurttl FINS_CURRK Global Currency
rocurttl FINS_CURR1 Free Defined Crcy 1
rvcurttl FINS_CURR2 Free Defined Crcy 2
rbcurttl FINS_CURR3 Free Defined Crcy 3
rccurttl FINS_CURR4 Free Defined Crcy 4
rdcurttl FINS_CURR5 Free Defined Crcy 5
recurttl FINS_CURR6 Free Defined Crcy 6
rfcurttl FINS_CURR7 Free Defined Crcy 7
rgcurttl FINS_CURR8 Free Defined Crcy 8
timestmp ACE_HZSTMP_OBSOLETE Time Added

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.

-- Item Data for Accrual Subobject
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACESOBJ_ITEM (
    MANDT,                -- Client [MANDT]
    COMP,                 -- Component [ACE_COMP]
    LOGSYS,               -- Logical System [ACE_LOGSYS]
    BUKRS,                -- Company Code [ACE_BUKRS]
    REF_KEY,              -- Accrual Object [ACE_OBJ_ID]
    REF_SUBKEY,           -- Accrual Subobject [ACE_SUBOBJ_ID]
    ITEMTYPE,             -- Accr Item Type [ACE_ITEMTYPE]
    RLDNR,                -- Ledger [FINS_LEDGER]
    DATE_TO,              -- To [ACE_DATETO]
    DATE_FROM,            -- From [ACE_DATEFROM]
    QUANTITY,             -- Total Qty to Accrue [ACE_TOTAL_QUANTITY]
    UNIT,                 -- Unit of Measure [ACE_UNIT]
    ACRMETHOD,            -- Accr/Defrl Method [ACEDS_ACRMETHOD]
    LIFE_START_DATE,      -- Start of Life [ACE_LIFE_START_DATE]
    LIFE_END_DATE,        -- End of Life [ACE_LIFE_END_DATE]
    XOBSOLETE,            -- Obsolete [ACEDS_XOBSOLETE]
    INC_OFFSTNG_ACCNT,    -- Offsetting Account [ACE_ACCNT_INCEPTION_OFFSETTING]
    INC_ACCR_ACCNT,       -- Accr./Dfrl Acct [ACE_ACCNT_INCEPTION_ACCRUAL]
    PER_ACCR_ACCNT,       -- Accr./Dfrl. Account [ACE_ACCNT_PERIODIC_ACCRUAL]
    PER_OFFSTNG_ACCNT,    -- Offsetting Account [ACE_ACCNT_PERIODIC_OFFSETTING]
    FIN_ACCR_ACCNT,       -- Accr./Dfrl Acct [ACE_ACCNT_FINAL_ACCRUAL]
    FIN_OFFSTNG_ACCNT,    -- Offsetting Account [ACE_ACCNT_FINAL_OFFSETTING]
    INC_DOC_TYPE,         -- Document Type [ACEPS_INC_BLART]
    PER_DOC_TYPE,         -- Document Type [ACEPS_PER_BLART]
    FIN_DOC_TYPE,         -- Document Type [ACEPS_FIN_BLART]
    TOTAL_ACCR_AMNT_WSL,  -- Total A/D Amt (TC) [ACE_TOTAL_PER_ACCR_AMNT_WCURR]
    TOTAL_ACCR_AMNT_HSL,  -- Total A/D Amt (CC) [ACE_TOTAL_PER_ACCR_AMNT_HCURR]
    TOTAL_ACCR_AMNT_KSL,  -- Total A/D Amt (GC) [ACE_TOTAL_PER_ACCR_AMNT_KCURR]
    TOTAL_ACCR_AMNT_OSL,  -- Total A/D Amt (FC1) [ACE_TOTAL_PER_ACCR_AMNT_OCURR]
    TOTAL_ACCR_AMNT_VSL,  -- Total A/D Amt (FC2) [ACE_TOTAL_PER_ACCR_AMNT_VCURR]
    TOTAL_ACCR_AMNT_BSL,  -- Total A/D Amt (FC3) [ACE_TOTAL_PER_ACCR_AMNT_BCURR]
    TOTAL_ACCR_AMNT_CSL,  -- Total A/D Amt (FC4) [ACE_TOTAL_PER_ACCR_AMNT_CCURR]
    TOTAL_ACCR_AMNT_DSL,  -- Total A/D Amt (FC5) [ACE_TOTAL_PER_ACCR_AMNT_DCURR]
    TOTAL_ACCR_AMNT_ESL,  -- Total A/D Amt (FC6) [ACE_TOTAL_PER_ACCR_AMNT_ECURR]
    TOTAL_ACCR_AMNT_FSL,  -- Total A/D Amt (FC7) [ACE_TOTAL_PER_ACCR_AMNT_FCURR]
    TOTAL_ACCR_AMNT_GSL,  -- Total A/D Amt (FC8) [ACE_TOTAL_PER_ACCR_AMNT_GCURR]
    RWCURTTL,             -- Transaction Currency [FINS_CURRW]
    RHCURTTL,             -- CompanyCode Currency [FINS_CURRH]
    RKCURTTL,             -- Global Currency [FINS_CURRK]
    ROCURTTL,             -- Free Defined Crcy 1 [FINS_CURR1]
    RVCURTTL,             -- Free Defined Crcy 2 [FINS_CURR2]
    RBCURTTL,             -- Free Defined Crcy 3 [FINS_CURR3]
    RCCURTTL,             -- Free Defined Crcy 4 [FINS_CURR4]
    RDCURTTL,             -- Free Defined Crcy 5 [FINS_CURR5]
    RECURTTL,             -- Free Defined Crcy 6 [FINS_CURR6]
    RFCURTTL,             -- Free Defined Crcy 7 [FINS_CURR7]
    RGCURTTL,             -- Free Defined Crcy 8 [FINS_CURR8]
    TIMESTMP,             -- Time Added [ACE_HZSTMP_OBSOLETE]
    PRIMARY KEY (MANDT, COMP, LOGSYS, BUKRS, REF_KEY, REF_SUBKEY, ITEMTYPE, RLDNR, DATE_TO)
);

Learn More