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)
);