ACES_OVERVIEW

GLOBAL_TEMPORARY Temporary Data
47 Fields 1 CDS Views

GTT for Accruals Overview

ACES_OVERVIEW is an SAP database table in S/4HANA. GTT for Accruals Overview. It contains 47 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ACCRUALSOVERVIEW view from CONSUMPTION Accrual Overview

Fields (47)

KeyField Data ElementDescription DomainTypeLength
KEY accrualengineaccrualobjecttype ace_comp Component
KEY accrualobjectlogicalsystem ace_logsys Logical System
KEY companycode ace_bukrs Company Code
KEY accrualitemtype ace_itemtype Accr Item Type
KEY ledger fins_ledger Ledger
KEY accrualobject ace_obj_id Accrual Object
KEY accrualsubobject ace_subobj_id Accrual Subobject
KEY accrualenginereferenceobject ace_refobj_id Acr. Reference ID
KEY fiscalyear fis_gjahr Fiscal Year
KEY accrualperiodenddate ace_period_end_date Last Day of Period
accrualperiodstartdate ace_period_start_date First Day of Period
plannedcostintranscrcy ace_plnd_cost_bal_amnt_wcurr Plnd Costs Bal. (TC)
plndcostincocodecrcy ace_plnd_cost_bal_amnt_hcurr Plnd Costs Bal. (CC)
plannedcostinglobalcrcy ace_plnd_cost_bal_amnt_kcurr Plnd Costs Bal. (GC)
actualcostintranscrcy ace_act_cost_bal_amnt_wcurr Actl Costs Bal. (TC)
actualcostamtincccrcy ace_act_cost_bal_amnt_hcurr Actl Costs Bal. (CC)
actualcostinglobalcrcy ace_act_cost_bal_amnt_kcurr Actl Costs Bal. (GC)
postedperiodamtintranscrcy ace_posted_cost_bal_amnt_wcurr Pstd Accr. Bal. (TC)
postedperiodamtincocodecrcy ace_posted_cost_bal_amnt_hcurr Pstd Accr. Bal. (CC)
postedperiodamtinglobalcrcy ace_posted_cost_bal_amnt_kcurr Pstd Accr. Bal. (GC)
adjustedcostintranscrcy ace_adjstd_cost_bal_amnt_wcurr Rvsd Costs Bal. (TC)
adjustedcostincocodecrcy ace_adjstd_cost_bal_amnt_hcurr Rvsd Costs Bal. (CC)
adjustedcostinglobalcrcy ace_adjstd_cost_bal_amnt_kcurr Rvsd Costs Bal. (GC)
balanceaccramountintranscrcy ace_calctd_accr_bal_amnt_wcurr Cal. Accr. Bal. (TC)
balanceaccramountincocodecrcy ace_calctd_accr_bal_amnt_hcurr Cal. Accr. Bal. (CC)
balanceaccramountinglobalcrcy ace_calctd_accr_bal_amnt_kcurr Cal. Accr. Bal. (GC)
deferredcostintranscrcy ace_accr_amnt_wcurr_der Dfrd Costs Bal. (TC)
deferredcostincocodecrcy ace_accr_amnt_hcurr_der Dfrd Costs Bal.(CC)
deferredcostinglobalcrcy ace_accr_amnt_kcurr_der Dfrd Costs Bal. (GC)
recognizedcostintranscrcy ace_accr_amnt_wcurr_rec Recgnd Costs Bal(TC)
recognizedcostincocodecrcy ace_accr_amnt_hcurr_rec Recgnd Costs Bal(CC)
recognizedcostinglobalcrcy ace_accr_amnt_kcurr_rec Recgnd Costs Bal(GC)
accrdeltaamountintranscrcy ace_accr_amnt_wcurr_delta Delta A/D Amt (TC)
accrdeltaamountincocodecrcy ace_accr_amnt_hcurr_delta Delta A/D Amt (CC)
accrdeltaamountinglobcrcy ace_accr_amnt_kcurr_delta Delta A/D Amt (GC)
defrldeltaamountintranscrcy ace_accr_amnt_wcurr_delta_der Delta Dfrl Amt (TC)
defrldeltaamountincocodecrcy ace_accr_amnt_hcurr_delta_der Delta Dfrl Amt (CC)
defrldeltaamountinglobcrcy ace_accr_amnt_kcurr_delta_der Delta Dfrl Amt (GC)
transactioncurrency fins_currw Transaction Currency
companycodecurrency fins_currh CompanyCode Currency
globalcurrency fins_currk Global Currency
totalaccrualquantityunit meins Base Unit
accrualengineactlqtyinbaseunit ace_accr_amnt_msl_actl Actual Quantity
accrualengineaccrqtyinbaseunit ace_accr_amnt_msl_blc Balance Quantity
serviceentrysheet mmpur_ses_serviceentrysheet Service Entry Sheet
serviceentrysheetitem mmpur_ses_serviceentrysheetitm Item Number of SES
sesaccountassignment dzekkn Account Assgmt No.

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 Overview
-- Category GLOBAL_TEMPORARY · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACES_OVERVIEW (
    ACCRUALENGINEACCRUALOBJECTTYPE,  -- Component [ace_comp]
    ACCRUALOBJECTLOGICALSYSTEM,      -- Logical System [ace_logsys]
    COMPANYCODE,                     -- Company Code [ace_bukrs]
    ACCRUALITEMTYPE,                 -- Accr Item Type [ace_itemtype]
    LEDGER,                          -- Ledger [fins_ledger]
    ACCRUALOBJECT,                   -- Accrual Object [ace_obj_id]
    ACCRUALSUBOBJECT,                -- Accrual Subobject [ace_subobj_id]
    ACCRUALENGINEREFERENCEOBJECT,    -- Acr. Reference ID [ace_refobj_id]
    FISCALYEAR,                      -- Fiscal Year [fis_gjahr]
    ACCRUALPERIODENDDATE,            -- Last Day of Period [ace_period_end_date]
    ACCRUALPERIODSTARTDATE,          -- First Day of Period [ace_period_start_date]
    PLANNEDCOSTINTRANSCRCY,          -- Plnd Costs Bal. (TC) [ace_plnd_cost_bal_amnt_wcurr]
    PLNDCOSTINCOCODECRCY,            -- Plnd Costs Bal. (CC) [ace_plnd_cost_bal_amnt_hcurr]
    PLANNEDCOSTINGLOBALCRCY,         -- Plnd Costs Bal. (GC) [ace_plnd_cost_bal_amnt_kcurr]
    ACTUALCOSTINTRANSCRCY,           -- Actl Costs Bal. (TC) [ace_act_cost_bal_amnt_wcurr]
    ACTUALCOSTAMTINCCCRCY,           -- Actl Costs Bal. (CC) [ace_act_cost_bal_amnt_hcurr]
    ACTUALCOSTINGLOBALCRCY,          -- Actl Costs Bal. (GC) [ace_act_cost_bal_amnt_kcurr]
    POSTEDPERIODAMTINTRANSCRCY,      -- Pstd Accr. Bal. (TC) [ace_posted_cost_bal_amnt_wcurr]
    POSTEDPERIODAMTINCOCODECRCY,     -- Pstd Accr. Bal. (CC) [ace_posted_cost_bal_amnt_hcurr]
    POSTEDPERIODAMTINGLOBALCRCY,     -- Pstd Accr. Bal. (GC) [ace_posted_cost_bal_amnt_kcurr]
    ADJUSTEDCOSTINTRANSCRCY,         -- Rvsd Costs Bal. (TC) [ace_adjstd_cost_bal_amnt_wcurr]
    ADJUSTEDCOSTINCOCODECRCY,        -- Rvsd Costs Bal. (CC) [ace_adjstd_cost_bal_amnt_hcurr]
    ADJUSTEDCOSTINGLOBALCRCY,        -- Rvsd Costs Bal. (GC) [ace_adjstd_cost_bal_amnt_kcurr]
    BALANCEACCRAMOUNTINTRANSCRCY,    -- Cal. Accr. Bal. (TC) [ace_calctd_accr_bal_amnt_wcurr]
    BALANCEACCRAMOUNTINCOCODECRCY,   -- Cal. Accr. Bal. (CC) [ace_calctd_accr_bal_amnt_hcurr]
    BALANCEACCRAMOUNTINGLOBALCRCY,   -- Cal. Accr. Bal. (GC) [ace_calctd_accr_bal_amnt_kcurr]
    DEFERREDCOSTINTRANSCRCY,         -- Dfrd Costs Bal. (TC) [ace_accr_amnt_wcurr_der]
    DEFERREDCOSTINCOCODECRCY,        -- Dfrd Costs Bal.(CC) [ace_accr_amnt_hcurr_der]
    DEFERREDCOSTINGLOBALCRCY,        -- Dfrd Costs Bal. (GC) [ace_accr_amnt_kcurr_der]
    RECOGNIZEDCOSTINTRANSCRCY,       -- Recgnd Costs Bal(TC) [ace_accr_amnt_wcurr_rec]
    RECOGNIZEDCOSTINCOCODECRCY,      -- Recgnd Costs Bal(CC) [ace_accr_amnt_hcurr_rec]
    RECOGNIZEDCOSTINGLOBALCRCY,      -- Recgnd Costs Bal(GC) [ace_accr_amnt_kcurr_rec]
    ACCRDELTAAMOUNTINTRANSCRCY,      -- Delta A/D Amt (TC) [ace_accr_amnt_wcurr_delta]
    ACCRDELTAAMOUNTINCOCODECRCY,     -- Delta A/D Amt (CC) [ace_accr_amnt_hcurr_delta]
    ACCRDELTAAMOUNTINGLOBCRCY,       -- Delta A/D Amt (GC) [ace_accr_amnt_kcurr_delta]
    DEFRLDELTAAMOUNTINTRANSCRCY,     -- Delta Dfrl Amt (TC) [ace_accr_amnt_wcurr_delta_der]
    DEFRLDELTAAMOUNTINCOCODECRCY,    -- Delta Dfrl Amt (CC) [ace_accr_amnt_hcurr_delta_der]
    DEFRLDELTAAMOUNTINGLOBCRCY,      -- Delta Dfrl Amt (GC) [ace_accr_amnt_kcurr_delta_der]
    TRANSACTIONCURRENCY,             -- Transaction Currency [fins_currw]
    COMPANYCODECURRENCY,             -- CompanyCode Currency [fins_currh]
    GLOBALCURRENCY,                  -- Global Currency [fins_currk]
    TOTALACCRUALQUANTITYUNIT,        -- Base Unit [meins]
    ACCRUALENGINEACTLQTYINBASEUNIT,  -- Actual Quantity [ace_accr_amnt_msl_actl]
    ACCRUALENGINEACCRQTYINBASEUNIT,  -- Balance Quantity [ace_accr_amnt_msl_blc]
    SERVICEENTRYSHEET,               -- Service Entry Sheet [mmpur_ses_serviceentrysheet]
    SERVICEENTRYSHEETITEM,           -- Item Number of SES [mmpur_ses_serviceentrysheetitm]
    SESACCOUNTASSIGNMENT,            -- Account Assgmt No. [dzekkn]
    PRIMARY KEY (ACCRUALENGINEACCRUALOBJECTTYPE, ACCRUALOBJECTLOGICALSYSTEM, COMPANYCODE, ACCRUALITEMTYPE, LEDGER, ACCRUALOBJECT, ACCRUALSUBOBJECT, ACCRUALENGINEREFERENCEOBJECT, FISCALYEAR, ACCRUALPERIODENDDATE)
);

Learn More