FINCS_BUNIT_ATVD
Consolidation Unit Attributes Time and Version Dependent
FINCS_BUNIT_ATVD is an SAP database table in S/4HANA. Consolidation Unit Attributes Time and Version Dependent. It contains 20 fields. 8 CDS views read from this table.
CDS Views using this table (8)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_CnsldtnUnitByTimeVersion | view_entity | from | EXTENSION | Consolidation Unit by Time and Version - Extension |
| I_CnsldtnUnitByTimeVersion | view | from | BASIC | Consolidation Unit by Time and Version |
| ICA_CONSJOURNALENTRIES_4 | view | left_outer | Match Consolidation Journal Entry Lines | |
| ICA_CONSJOURNALENTRIES_5 | view | left_outer | Match Consolidation Journal Entry Lines | |
| ICA_CONSJOURNALENTRIES_6 | view_entity | left_outer | ICA: Consolidation Journal Entry Line Items | |
| ICA_CONSJOURNALENTRIES_7 | view_entity | left_outer | ICA: Consolidation Journal Entry Line Items | |
| ICA_P_CONSJOURNALENTRIES_01 | view | left_outer | ICA: Consolidation Journal Entry Line Items from ACDOCA | |
| P_CnsldtnUnitByTimeVersion_2 | view | from | BASIC | Consolidation Unit by Time and Version |
Fields (20)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | dimen | FC_DIMEN | Dimension | |||
| KEY | bunit | FINCS_MD_BUNIT | Consolidation Unit | |||
| KEY | cuavs | FC_CU_ATTR_VS | CU Attributes | |||
| KEY | fromyearper | FINCS_FISCALYEARPER | Fiscal Year Period | |||
| toyearper | FINCS_FISCALYEARPER | Fiscal Year Period | ||||
| local_curr_source | FINCS_LOCAL_CURR_SOURCE | Source for Local Currency Key Figure | ||||
| group_curr_source | FINCS_GROUP_CURR_SOURCE | Source for Group Currency Key Figure | ||||
| periv | FC_PERIV | FY variant | ||||
| gcind | FC_GCIND | Entry in GC | ||||
| trans | FINCS_DATATRANSFERMETHOD | Univ. Journ. Integr. | ||||
| upmeth | FC_UPMETH | Upload method | ||||
| ctrgr | FC_CTRGR | Transl. Method | ||||
| taxrt | FC_TAXRT | Tax Rate | ||||
| is_partner_only | FINCS_BUNIT_PARTNER_ONLY | Consolidation Unit is Partner Unit Only | ||||
| sa_data_collection | FINCS_UNITDATACOLLECTION | Data Collection Selection | ||||
| sa_posting_rule | FINCS_UNITPOSTINGRULE | Posting Rule Selection | ||||
| sa_partner | FINCS_UNITPARTNER | Partner Selection | ||||
| sa_validation | FINCS_UNITVALIDATION | Validation Selection | ||||
| dummy_fincs_cu_tvd_incl_eew_ps | CFD_DUMMY | Dummy |
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.
-- Consolidation Unit Attributes Time and Version Dependent
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINCS_BUNIT_ATVD (
MANDT, -- Client [MANDT]
DIMEN, -- Dimension [FC_DIMEN]
BUNIT, -- Consolidation Unit [FINCS_MD_BUNIT]
CUAVS, -- CU Attributes [FC_CU_ATTR_VS]
FROMYEARPER, -- Fiscal Year Period [FINCS_FISCALYEARPER]
TOYEARPER, -- Fiscal Year Period [FINCS_FISCALYEARPER]
LOCAL_CURR_SOURCE, -- Source for Local Currency Key Figure [FINCS_LOCAL_CURR_SOURCE]
GROUP_CURR_SOURCE, -- Source for Group Currency Key Figure [FINCS_GROUP_CURR_SOURCE]
PERIV, -- FY variant [FC_PERIV]
GCIND, -- Entry in GC [FC_GCIND]
TRANS, -- Univ. Journ. Integr. [FINCS_DATATRANSFERMETHOD]
UPMETH, -- Upload method [FC_UPMETH]
CTRGR, -- Transl. Method [FC_CTRGR]
TAXRT, -- Tax Rate [FC_TAXRT]
IS_PARTNER_ONLY, -- Consolidation Unit is Partner Unit Only [FINCS_BUNIT_PARTNER_ONLY]
SA_DATA_COLLECTION, -- Data Collection Selection [FINCS_UNITDATACOLLECTION]
SA_POSTING_RULE, -- Posting Rule Selection [FINCS_UNITPOSTINGRULE]
SA_PARTNER, -- Partner Selection [FINCS_UNITPARTNER]
SA_VALIDATION, -- Validation Selection [FINCS_UNITVALIDATION]
DUMMY_FINCS_CU_TVD_INCL_EEW_PS, -- Dummy [CFD_DUMMY]
PRIMARY KEY (MANDT, DIMEN, BUNIT, CUAVS, FROMYEARPER)
);
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