PSM_SPLIT_DISTR

Transparent Table Application Table
25 Fields 1 CDS Views

Distributions for Rule-Based Account Distributions

PSM_SPLIT_DISTR is an SAP database table in S/4HANA. Distributions for Rule-Based Account Distributions. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PubSecSplittingRuleDistr view from BASIC Distribution of Account Assignment Split

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY split_id fmsp_split_id Distribution ID
split_rule_uuid sysuuid_x16 UUID
split_rule fmsp_rule_id Distrib. Rule
alloc_block fmsp_alloc_block Alloc. Block
sequence_nbr fmsp_sequence_nbr Sequence No.
from_date begdatum Start date
to_date enddatum End Date
dist_method fmsp_dist_method Distrib.Method
dist_percent fmsp_dist_percent Percentage
currency waers Currency
dist_amount fmsp_dist_amount Amount
event_used fmsp_event_used Event If Used
event_nused fmsp_event_nused Event If Not Used
final_split fmsp_final_split Final Dist.
created_by fm_erfname Created By
created_on fm_erfdat Entered On
modified_by fm_aenname Changed By
modified_on fm_aendat Changed On
grantnbr gm_grant_nbr Grant
functionalarea fkber Functional Area
fund bp_geber Fund
isoverrideallowedfund override_non_blan_fund Override Fund
isoverrideallowedgrantid override_non_blan_grant Override Grant
isovrrdeallowedfctar override_non_blan_fctar Override Farea

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.

-- Distributions for Rule-Based Account Distributions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PSM_SPLIT_DISTR (
    MANDT,                     -- Client [mandt]
    SPLIT_ID,                  -- Distribution ID [fmsp_split_id]
    SPLIT_RULE_UUID,           -- UUID [sysuuid_x16]
    SPLIT_RULE,                -- Distrib. Rule [fmsp_rule_id]
    ALLOC_BLOCK,               -- Alloc. Block [fmsp_alloc_block]
    SEQUENCE_NBR,              -- Sequence No. [fmsp_sequence_nbr]
    FROM_DATE,                 -- Start date [begdatum]
    TO_DATE,                   -- End Date [enddatum]
    DIST_METHOD,               -- Distrib.Method [fmsp_dist_method]
    DIST_PERCENT,              -- Percentage [fmsp_dist_percent]
    CURRENCY,                  -- Currency [waers]
    DIST_AMOUNT,               -- Amount [fmsp_dist_amount]
    EVENT_USED,                -- Event If Used [fmsp_event_used]
    EVENT_NUSED,               -- Event If Not Used [fmsp_event_nused]
    FINAL_SPLIT,               -- Final Dist. [fmsp_final_split]
    CREATED_BY,                -- Created By [fm_erfname]
    CREATED_ON,                -- Entered On [fm_erfdat]
    MODIFIED_BY,               -- Changed By [fm_aenname]
    MODIFIED_ON,               -- Changed On [fm_aendat]
    GRANTNBR,                  -- Grant [gm_grant_nbr]
    FUNCTIONALAREA,            -- Functional Area [fkber]
    FUND,                      -- Fund [bp_geber]
    ISOVERRIDEALLOWEDFUND,     -- Override Fund [override_non_blan_fund]
    ISOVERRIDEALLOWEDGRANTID,  -- Override Grant [override_non_blan_grant]
    ISOVRRDEALLOWEDFCTAR,      -- Override Farea [override_non_blan_fctar]
    PRIMARY KEY (MANDT, SPLIT_ID)
);

Learn More