FCOT_EBPR_TMPRUL

Transparent Table Application Table

Event-Based Temp Posting Rule

FCOT_EBPR_TMPRUL is an SAP database table in S/4HANA. Event-Based Temp Posting Rule. It contains 33 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_EvtBsdTmpPostingRule view from BASIC Event-Based Temporary Posting Rule

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY identifier fco_ebpr_identifier Identifier
KEY rule_uuid fco_ebdp_rule_uuid Rule UUID
object_number j_objnr Object number
object_type j_obart Object Type
distribution_sequence br_lfdnr Sequence Number
posting_type fco_rtpc_posting_type Posting Type
source_structure ursch Source Struct.
source_assignment urzuo Source Assgnmnt
percentage_rate fco_rtpc_postg_percentage_rate Percent
equivalence_number fco_rtpc_postg_eqvln_nmbr Equivalence No.
default_rule dfreg Default Rule
order_number aufnr Order
order_item co_posnr Item Number
sales_order_number kdauf Sales Order
sales_order_item_number kdpos Sales Ord. Item
wbs_element_internal_id ps_psp_pnr WBS Element
wbs_element_external_id ps_posid WBS Element
rcvr_object_type fco_rtpc_postg_receiver_type Receiver Type
receiver fco_ebpr_receiver Receiver
rcvr_wbs_element_internal_id ps_psp_pnr WBS Element
tracing_factor_determ_method fco_rtpc_postg_trcg_fctr_meth Methods
valuation_type bwtar_d Valuation Type
is_settled boolean Boolean Variable (X = True, - = False, Space = Unknown)
settled_timestamp timestamp Time Stamp
entered_by brgernam Entered By
created_by fco_created_by Created By
created_on brgerdat Created On
changed_by brgaenam Changed By
changed_on brgaedat Changed On
created_time fco_ebpr_create_time Creation Time
changed_time fco_ebpr_change_time Change Time
upd_flag char1 Single-Character Flag

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.

-- Event-Based Temp Posting Rule
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCOT_EBPR_TMPRUL (
    MANDT,                         -- Client [mandt]
    IDENTIFIER,                    -- Identifier [fco_ebpr_identifier]
    RULE_UUID,                     -- Rule UUID [fco_ebdp_rule_uuid]
    OBJECT_NUMBER,                 -- Object number [j_objnr]
    OBJECT_TYPE,                   -- Object Type [j_obart]
    DISTRIBUTION_SEQUENCE,         -- Sequence Number [br_lfdnr]
    POSTING_TYPE,                  -- Posting Type [fco_rtpc_posting_type]
    SOURCE_STRUCTURE,              -- Source Struct. [ursch]
    SOURCE_ASSIGNMENT,             -- Source Assgnmnt [urzuo]
    PERCENTAGE_RATE,               -- Percent [fco_rtpc_postg_percentage_rate]
    EQUIVALENCE_NUMBER,            -- Equivalence No. [fco_rtpc_postg_eqvln_nmbr]
    DEFAULT_RULE,                  -- Default Rule [dfreg]
    ORDER_NUMBER,                  -- Order [aufnr]
    ORDER_ITEM,                    -- Item Number [co_posnr]
    SALES_ORDER_NUMBER,            -- Sales Order [kdauf]
    SALES_ORDER_ITEM_NUMBER,       -- Sales Ord. Item [kdpos]
    WBS_ELEMENT_INTERNAL_ID,       -- WBS Element [ps_psp_pnr]
    WBS_ELEMENT_EXTERNAL_ID,       -- WBS Element [ps_posid]
    RCVR_OBJECT_TYPE,              -- Receiver Type [fco_rtpc_postg_receiver_type]
    RECEIVER,                      -- Receiver [fco_ebpr_receiver]
    RCVR_WBS_ELEMENT_INTERNAL_ID,  -- WBS Element [ps_psp_pnr]
    TRACING_FACTOR_DETERM_METHOD,  -- Methods [fco_rtpc_postg_trcg_fctr_meth]
    VALUATION_TYPE,                -- Valuation Type [bwtar_d]
    IS_SETTLED,                    -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    SETTLED_TIMESTAMP,             -- Time Stamp [timestamp]
    ENTERED_BY,                    -- Entered By [brgernam]
    CREATED_BY,                    -- Created By [fco_created_by]
    CREATED_ON,                    -- Created On [brgerdat]
    CHANGED_BY,                    -- Changed By [brgaenam]
    CHANGED_ON,                    -- Changed On [brgaedat]
    CREATED_TIME,                  -- Creation Time [fco_ebpr_create_time]
    CHANGED_TIME,                  -- Change Time [fco_ebpr_change_time]
    UPD_FLAG,                      -- Single-Character Flag [char1]
    PRIMARY KEY (MANDT, IDENTIFIER, RULE_UUID)
);