FCLM_CP_PROF

Transparent Table Application Table
37 Fields 1 CDS Views

Cash Position Profile

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CashPositionProfileBasic view_entity from BASIC Basic Cash Position Profile

Fields (37)

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 fclm_cp_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
consider_endofday_recncln_rslt fclm_cp_consdr_eod_recn_rslt
allow_key_date_in_the_past fclm_cp_allow_key_dte_in_past
overdraft_type fclm_bam_overnight_overdraft
show_overdraft_limit_original fclm_cp_show_overdraft_origin

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,                     -- fclm_cp_increment
    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]
    CONSIDER_ENDOFDAY_RECNCLN_RSLT,  -- fclm_cp_consdr_eod_recn_rslt
    ALLOW_KEY_DATE_IN_THE_PAST,      -- fclm_cp_allow_key_dte_in_past
    OVERDRAFT_TYPE,                  -- fclm_bam_overnight_overdraft
    SHOW_OVERDRAFT_LIMIT_ORIGINAL,   -- fclm_cp_show_overdraft_origin
    PRIMARY KEY (MANDT, PROFILE_NAME)
);

Learn More