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 26 fields. 14 CDS views read from this table.
CDS Views using this table (14)
| 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_CnsldtnCustGroupHierDirEnhcd | view | cross | BASIC | Consolidation Combined Cust Grp Hierarchy Directory Enhcd |
| I_CnsldtnGLAccountHierDirEnhcd | view | cross | BASIC | Consolidation Combined G/L Account Hierarchy Directory Enhcd |
| I_CnsldtnMatlGrpHierDir | view | cross | BASIC | Consolidation Material Group Hier Dir |
| I_CnsldtnProdSoldHierDirEnhcd | view | cross | BASIC | Consolidation Product Sold Hierarchy Directory Enhanced |
| I_CnsldtnProfitCenterElimNode | view | inner | BASIC | Cnsldtn Profit Center Elimination Node |
| I_CnsldtnProjectHierDirEnhcd | view | cross | BASIC | Consolidation Project Hierarchy Directory |
| I_CnsldtnSalesOrgHierDirEnhcd | view | cross | BASIC | Consolidation Sales Organization Hierarchy Directory Enhcd |
| I_CnsldtnSegmentElimNode | view | inner | BASIC | Cnsldtn Segment Elimination Node |
| I_CnsldtnSupplierHierDirEnhcd | view | cross | BASIC | Consolidation Supplier Hierarchy Directory Enhanced |
| P_CnsldtnProfitCenterElimNodeT | view_entity | inner | BASIC | |
| P_CnsldtnSegmentElimNodeT | view_entity | inner | BASIC |
Fields (26)
| 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 |
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]
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