FINCS_ADDLCHARCX
Char UUID - Additional Characteristics for Journal Entry
FINCS_ADDLCHARCX is an SAP database table in S/4HANA. Char UUID - Additional Characteristics for Journal Entry. It contains 28 fields. 7 CDS views read from this table.
CDS Views using this table (7)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CnsldtnAddlCharacteristic | view_entity | from | BASIC | Consolidation Additional Characteristic |
| I_CnsldtnAddlCharcsApp | view | from | BASIC | Consolidation Additional Characteristics for SCP App |
| I_CnsldtnAddlMD | view | inner | BASIC | Consolidation Additional Master Data |
| I_CnsldtnProfitCenterElimNode | view | inner | BASIC | Cnsldtn Profit Center Elimination Node |
| I_CnsldtnSegmentElimNode | view | inner | BASIC | Cnsldtn Segment Elimination Node |
| P_CnsldtnProfitCenterElimNodeT | view_entity | inner | BASIC | Cnsldtn Profit Center Elim Node - Text |
| P_CnsldtnSegmentElimNodeT | view_entity | inner | BASIC | Cnsldtn Segment Elimination Node - Text |
Fields (28)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | cnsldtnaddlcharcuuid | fincs_uuid | UUID | |||
| cnsldtnaddlcharcfldname | fieldname | Field Name | ||||
| cnsldtnaddlmdispossible | fincs_md_option | Master Data Possible | ||||
| cnsldtnaddlcharcisinuse | fincs_field_usage | Enable Inputs | ||||
| cnsldtnaddlmdisinuse | fincs_md_usage | Enable Master Data | ||||
| cnsldtnaggrgnonrelispossible | fincs_md_aggr_p | Aggr. Release Poss. | ||||
| cnsldtnaggrgnonrelisactive | fincs_md_aggract | Aggregate on Release | ||||
| cnsldtnaddlmdsuprordfld | fincs_md_ref_field | Suprord. Field | ||||
| is_time_dependent | as4flag | Flag (X or Blank) | ||||
| cnsldtnaddlcharctxt | as4text | Short Description | ||||
| cnsldtnaddlmdsuprordfldtxt | as4text | Short Description | ||||
| cnsldtnaddlmdpairedfld | fincs_md_pair_field | Reference Field | ||||
| cnsldtnaddlmdpairedfldtxt | as4text | Short Description | ||||
| cnsldtnaddlmdhashier | fincs_md_has_hierarchy | Hierarchy Possible | ||||
| cnsldtnaddlmdhierisinuse | fincs_md_use_hierarchy | Enable Hierarchy | ||||
| hasclearinginbalancecarryfwd | fincs_md_has_clearing_in_bcf | BCF Aggr. Possible | ||||
| isclearedinbalancecarryforward | fincs_md_is_cleared_in_bcf | Aggregation on BCF | ||||
| cnsldtnmdcharcfldname | characteristic_name | Char. Name | ||||
| cnsldtcharcdataelmnt | fincs_addl_charc_data_elmnt | Data Element | ||||
| cnsldtnmanagementelimpossible | fincs_md_mgmt_elim_possible | Hier. Elim. Possible | ||||
| cnsldtnmanagementelimenabled | fincs_md_mgmt_elim_enabled | Enable Hier. Elim. | ||||
| cnsldtnaddlmdpairedfldname | characteristic_name | Char. Name | ||||
| cnsldtnaddlmdsuprordfldname | characteristic_name | Char. Name | ||||
| cnsldtnaddlmdpaireddataelmnt | fincs_addl_charc_data_elmnt | Data Element | ||||
| cnsldtnaddlmdsuprorddataelmnt | fincs_addl_charc_data_elmnt | Data Element | ||||
| cnsldtnofinvmtaggrgnisposbl | fincs_md_agcoi_p | |||||
| cnsldtnofinvmtaggrgnisactive | fincs_md_agcoi |
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.
-- Char UUID - Additional Characteristics for Journal Entry
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINCS_ADDLCHARCX (
MANDT, -- Client [mandt]
CNSLDTNADDLCHARCUUID, -- UUID [fincs_uuid]
CNSLDTNADDLCHARCFLDNAME, -- Field Name [fieldname]
CNSLDTNADDLMDISPOSSIBLE, -- Master Data Possible [fincs_md_option]
CNSLDTNADDLCHARCISINUSE, -- Enable Inputs [fincs_field_usage]
CNSLDTNADDLMDISINUSE, -- Enable Master Data [fincs_md_usage]
CNSLDTNAGGRGNONRELISPOSSIBLE, -- Aggr. Release Poss. [fincs_md_aggr_p]
CNSLDTNAGGRGNONRELISACTIVE, -- Aggregate on Release [fincs_md_aggract]
CNSLDTNADDLMDSUPRORDFLD, -- Suprord. Field [fincs_md_ref_field]
IS_TIME_DEPENDENT, -- Flag (X or Blank) [as4flag]
CNSLDTNADDLCHARCTXT, -- Short Description [as4text]
CNSLDTNADDLMDSUPRORDFLDTXT, -- Short Description [as4text]
CNSLDTNADDLMDPAIREDFLD, -- Reference Field [fincs_md_pair_field]
CNSLDTNADDLMDPAIREDFLDTXT, -- Short Description [as4text]
CNSLDTNADDLMDHASHIER, -- Hierarchy Possible [fincs_md_has_hierarchy]
CNSLDTNADDLMDHIERISINUSE, -- Enable Hierarchy [fincs_md_use_hierarchy]
HASCLEARINGINBALANCECARRYFWD, -- BCF Aggr. Possible [fincs_md_has_clearing_in_bcf]
ISCLEAREDINBALANCECARRYFORWARD, -- Aggregation on BCF [fincs_md_is_cleared_in_bcf]
CNSLDTNMDCHARCFLDNAME, -- Char. Name [characteristic_name]
CNSLDTCHARCDATAELMNT, -- Data Element [fincs_addl_charc_data_elmnt]
CNSLDTNMANAGEMENTELIMPOSSIBLE, -- Hier. Elim. Possible [fincs_md_mgmt_elim_possible]
CNSLDTNMANAGEMENTELIMENABLED, -- Enable Hier. Elim. [fincs_md_mgmt_elim_enabled]
CNSLDTNADDLMDPAIREDFLDNAME, -- Char. Name [characteristic_name]
CNSLDTNADDLMDSUPRORDFLDNAME, -- Char. Name [characteristic_name]
CNSLDTNADDLMDPAIREDDATAELMNT, -- Data Element [fincs_addl_charc_data_elmnt]
CNSLDTNADDLMDSUPRORDDATAELMNT, -- Data Element [fincs_addl_charc_data_elmnt]
CNSLDTNOFINVMTAGGRGNISPOSBL, -- fincs_md_agcoi_p
CNSLDTNOFINVMTAGGRGNISACTIVE, -- fincs_md_agcoi
PRIMARY KEY (MANDT, CNSLDTNADDLCHARCUUID)
);
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