FCLM_CP_PROF

Transparent Table Application Table
33 Fields 1 CDS Views

Cash Position Profile

FCLM_CP_PROF is an SAP database table in S/4HANA. Cash Position Profile. It contains 33 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CashPositionProfile view_entity from

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY profile_name FCLM_CP_PROFILE_NAME Cash Pos. Profile
prof_description FCLM_CP_PROFILE_DESC Description
hierarchy_source FCLM_CP_PROFILE_HIERSRC Hierarchy Src.
hierarchy_level1 FCLM_CP_PROFILE_HIERLEVEL1 Hier. Level 1
hierarchy_level2 FCLM_CP_PROFILE_HIERLEVEL2 Hier. Level 2
hierarchy_level3 FCLM_CP_PROFILE_HIERLEVEL3 Hier. Level 3
bank_acc_hierarchy_id VHRID Hierarchy ID
balance_type FCLM_CP_BALANCE_TYPE Balance Type
balance_category FCLM_CP_BALANCE_CATEGORY Bal. Category
view_category FCLM_CP_VIEW_CATEGORY View Category
step_rhythm STEP_RHYTHM Increment
step_unit FCLM_CP_STEP_UNIT Period Unit
period_end FCLM_CP_PERIOD_END Calendar Period
show_overdue FCLM_CP_SHOW_OVERDUE Show Overdue
include_overdue_in_closing FCLM_CP_INCL_OVERDUE_CLOSING Incl. Overdue
shift_option FCLM_CP_FLOW_SHIFT_OPTION Shift Option
factory_calendar WFCID Factory Cal. ID
display_currency DISP_CURR Display Crcy
exchange_rate_type KURST Exch. Rate Type
scaling_decimal_place TS70SKAL_NACH Scaling
scaling_predecimal_place FCLM_CP_SCALING_PREDECIMAL Scaling Factor (Deprecated)
created_by UNAME User Name
created_at TIMESTAMP Time Stamp
last_changed_by UNAME User Name
last_changed_at TIMESTAMP Time Stamp
need_root_node FCLM_CP_NEED_ROOTNODE Enable Root Node
root_node FCLM_CP_ROOTNODE_NAME Root Node Name
show_future FCLM_CP_SHOW_FUTURE Show Future
enable_smart_currency FCLM_CP_ENABLE_SMART_CURRENCY Enable Smart Curr
display_embed_csh_pos_det_view FCLM_CP_DSP_EMBED_CSHPOSDET_VW Display Pos. Details
highlight_negative_amount FCLM_CP_HIGHLIGHT_NEGATIVE_AMT Highlight in Red
consider_intraday_recncln_rslt FCLM_CP_CONSDR_INTRD_RECN_RSLT Consider Intraday Recon. Result

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.

-- Cash Position Profile
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_CP_PROF (
    MANDT,                           -- Client [MANDT]
    PROFILE_NAME,                    -- Cash Pos. Profile [FCLM_CP_PROFILE_NAME]
    PROF_DESCRIPTION,                -- Description [FCLM_CP_PROFILE_DESC]
    HIERARCHY_SOURCE,                -- Hierarchy Src. [FCLM_CP_PROFILE_HIERSRC]
    HIERARCHY_LEVEL1,                -- Hier. Level 1 [FCLM_CP_PROFILE_HIERLEVEL1]
    HIERARCHY_LEVEL2,                -- Hier. Level 2 [FCLM_CP_PROFILE_HIERLEVEL2]
    HIERARCHY_LEVEL3,                -- Hier. Level 3 [FCLM_CP_PROFILE_HIERLEVEL3]
    BANK_ACC_HIERARCHY_ID,           -- Hierarchy ID [VHRID]
    BALANCE_TYPE,                    -- Balance Type [FCLM_CP_BALANCE_TYPE]
    BALANCE_CATEGORY,                -- Bal. Category [FCLM_CP_BALANCE_CATEGORY]
    VIEW_CATEGORY,                   -- View Category [FCLM_CP_VIEW_CATEGORY]
    STEP_RHYTHM,                     -- Increment [STEP_RHYTHM]
    STEP_UNIT,                       -- Period Unit [FCLM_CP_STEP_UNIT]
    PERIOD_END,                      -- Calendar Period [FCLM_CP_PERIOD_END]
    SHOW_OVERDUE,                    -- Show Overdue [FCLM_CP_SHOW_OVERDUE]
    INCLUDE_OVERDUE_IN_CLOSING,      -- Incl. Overdue [FCLM_CP_INCL_OVERDUE_CLOSING]
    SHIFT_OPTION,                    -- Shift Option [FCLM_CP_FLOW_SHIFT_OPTION]
    FACTORY_CALENDAR,                -- Factory Cal. ID [WFCID]
    DISPLAY_CURRENCY,                -- Display Crcy [DISP_CURR]
    EXCHANGE_RATE_TYPE,              -- Exch. Rate Type [KURST]
    SCALING_DECIMAL_PLACE,           -- Scaling [TS70SKAL_NACH]
    SCALING_PREDECIMAL_PLACE,        -- Scaling Factor (Deprecated) [FCLM_CP_SCALING_PREDECIMAL]
    CREATED_BY,                      -- User Name [UNAME]
    CREATED_AT,                      -- Time Stamp [TIMESTAMP]
    LAST_CHANGED_BY,                 -- User Name [UNAME]
    LAST_CHANGED_AT,                 -- Time Stamp [TIMESTAMP]
    NEED_ROOT_NODE,                  -- Enable Root Node [FCLM_CP_NEED_ROOTNODE]
    ROOT_NODE,                       -- Root Node Name [FCLM_CP_ROOTNODE_NAME]
    SHOW_FUTURE,                     -- Show Future [FCLM_CP_SHOW_FUTURE]
    ENABLE_SMART_CURRENCY,           -- Enable Smart Curr [FCLM_CP_ENABLE_SMART_CURRENCY]
    DISPLAY_EMBED_CSH_POS_DET_VIEW,  -- Display Pos. Details [FCLM_CP_DSP_EMBED_CSHPOSDET_VW]
    HIGHLIGHT_NEGATIVE_AMOUNT,       -- Highlight in Red [FCLM_CP_HIGHLIGHT_NEGATIVE_AMT]
    CONSIDER_INTRADAY_RECNCLN_RSLT,  -- Consider Intraday Recon. Result [FCLM_CP_CONSDR_INTRD_RECN_RSLT]
    PRIMARY KEY (MANDT, PROFILE_NAME)
);

Learn More