TACE_ITEMTYPE
Accrual Item Types
TACE_ITEMTYPE is an SAP database table in S/4HANA. Accrual Item Types. It contains 15 fields. 7 CDS views read from this table.
CDS Views using this table (7)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| ACR_ITEM_TYPE_cds | view | from | Type of the item of the accrual sub obj | |
| I_AccrEngineAccrItemTypeBasic | view | from | BASIC | Accrual Engine: Accrual Item Type |
| I_AccrualItemType | view | from | BASIC | Accrual Item Type |
| P_ACCRUALITEMTYPE | view | from | BASIC | |
| P_ACCRUALITEMTYPE | view | left_outer | BASIC | |
| P_ACCRUALOBJECT_ITEM_TOTAL | view | inner | BASIC | |
| P_ACCRUALOBJECTPERIOD_DERIVE | view | left_outer | BASIC |
Fields (15)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | comp | ACE_COMP | Component | |||
| KEY | itemtype | ACE_ITEMTYPE | Accr Item Type | |||
| xdependent | ACE_XDEPENDENT_S4 | Derived Item Type | ||||
| xupld_currnt_acramnt | ACE_XUPLD_CURRNT_ACRAMNT | Upload Allowed | ||||
| xpost | ACE_XPOST_S4 | Obsolete | ||||
| xpost_inc_delta | ACE_XPOST_INC_DELTA_S4 | Obsolete | ||||
| xpost_fin_delta | ACE_XPOST_FIN_DELTA_S4 | Obsolete | ||||
| xpost_per_delta | ACE_XPOST_PER_DELTA_S4 | Obsolete | ||||
| planned_itemtype | ACE_PLANNED_ITEMTYPE | Plnd Costs Itm Type | ||||
| actual_itemtype | ACE_ACTUAL_ITEMTYPE | Actl Costs Item Type | ||||
| utilize_itemtype | ACE_UTILIZE_ITEMTYPE | Utilization Itm Type | ||||
| deferral_itemtype | ACE_DEFERRAL_ITEMTYPE | Deferral Item Type | ||||
| defacrmethod | ACE_DEFAULT_ACCR_METHOD | Default Accr. Method | ||||
| itemtype_category | ACE_S4_ITEMTYPE_CATEGORY | Item Type Category |
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.
-- Accrual Item Types
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TACE_ITEMTYPE (
MANDT, -- Client [MANDT]
COMP, -- Component [ACE_COMP]
ITEMTYPE, -- Accr Item Type [ACE_ITEMTYPE]
XDEPENDENT, -- Derived Item Type [ACE_XDEPENDENT_S4]
XUPLD_CURRNT_ACRAMNT, -- Upload Allowed [ACE_XUPLD_CURRNT_ACRAMNT]
XPOST, -- Obsolete [ACE_XPOST_S4]
XPOST_INC_DELTA, -- Obsolete [ACE_XPOST_INC_DELTA_S4]
XPOST_FIN_DELTA, -- Obsolete [ACE_XPOST_FIN_DELTA_S4]
XPOST_PER_DELTA, -- Obsolete [ACE_XPOST_PER_DELTA_S4]
PLANNED_ITEMTYPE, -- Plnd Costs Itm Type [ACE_PLANNED_ITEMTYPE]
ACTUAL_ITEMTYPE, -- Actl Costs Item Type [ACE_ACTUAL_ITEMTYPE]
UTILIZE_ITEMTYPE, -- Utilization Itm Type [ACE_UTILIZE_ITEMTYPE]
DEFERRAL_ITEMTYPE, -- Deferral Item Type [ACE_DEFERRAL_ITEMTYPE]
DEFACRMETHOD, -- Default Accr. Method [ACE_DEFAULT_ACCR_METHOD]
ITEMTYPE_CATEGORY, -- Item Type Category [ACE_S4_ITEMTYPE_CATEGORY]
PRIMARY KEY (MANDT, COMP, ITEMTYPE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA