FCOT_EVTBSD_REF

Transparent Table Application Table

Event-Based References for ACDOCA Line Items

FCOT_EVTBSD_REF is an SAP database table in S/4HANA. Event-Based References for ACDOCA Line Items. It contains 25 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_ReferenceTable view_entity from BASIC Reference table
R_EvtBsdProdCostgSettlmtRef view_entity from BASIC Event based settlement reference table view

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY reference_uuid fco_evtbsd_ref_uuid Ref UUID
object_number j_objnr Object number
order_id aufnr Order
order_item co_posnr Item Number
prec_awtyp fins_prec_awtyp PrecRefTransact
prec_aworg fins_prec_aworg PrecRefOrgUnit
prec_awref fins_prec_awref PrecRefDocument
prec_bukrs fins_prec_bukrs PrecJE CoCode
prec_gjahr fins_prec_gjahr PrecJE Year
prec_poper fins_prec_poper PrecJE Period
prec_belnr fins_prec_belnr PrecJE DocNo
ledger fins_ledger Ledger
evtbsd_bttype fins_bttype Bus. Trans. Category
evtbsd_awtyp awtyp Ref. procedure
evtbsd_aworg aworg Refer. Org.Unit
evtbsd_awref awref Reference Doc.
evtbsd_postg_date budat Posting Date
evtbsd_fiscalyear fco_evtbsd_fiscalyear EvtBsd Fiscal Year
evtbsd_period fco_evtbsd_period EB Posting Period
wp_cleared fco_evtbsd_ref_wp_clrd_vp_rvsd WP Clrd / VP Rvsd
cleared_date fco_evtbsd_ref_cleared_date
deleted fco_evtbsd_ref_deleted Reference Deleted
created_by fco_created_by Created By
crea_date_time timestampl Time Stamp

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 References for ACDOCA Line Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCOT_EVTBSD_REF (
    CLIENT,             -- Client [mandt]
    REFERENCE_UUID,     -- Ref UUID [fco_evtbsd_ref_uuid]
    OBJECT_NUMBER,      -- Object number [j_objnr]
    ORDER_ID,           -- Order [aufnr]
    ORDER_ITEM,         -- Item Number [co_posnr]
    PREC_AWTYP,         -- PrecRefTransact [fins_prec_awtyp]
    PREC_AWORG,         -- PrecRefOrgUnit [fins_prec_aworg]
    PREC_AWREF,         -- PrecRefDocument [fins_prec_awref]
    PREC_BUKRS,         -- PrecJE CoCode [fins_prec_bukrs]
    PREC_GJAHR,         -- PrecJE Year [fins_prec_gjahr]
    PREC_POPER,         -- PrecJE Period [fins_prec_poper]
    PREC_BELNR,         -- PrecJE DocNo [fins_prec_belnr]
    LEDGER,             -- Ledger [fins_ledger]
    EVTBSD_BTTYPE,      -- Bus. Trans. Category [fins_bttype]
    EVTBSD_AWTYP,       -- Ref. procedure [awtyp]
    EVTBSD_AWORG,       -- Refer. Org.Unit [aworg]
    EVTBSD_AWREF,       -- Reference Doc. [awref]
    EVTBSD_POSTG_DATE,  -- Posting Date [budat]
    EVTBSD_FISCALYEAR,  -- EvtBsd Fiscal Year [fco_evtbsd_fiscalyear]
    EVTBSD_PERIOD,      -- EB Posting Period [fco_evtbsd_period]
    WP_CLEARED,         -- WP Clrd / VP Rvsd [fco_evtbsd_ref_wp_clrd_vp_rvsd]
    CLEARED_DATE,       -- fco_evtbsd_ref_cleared_date
    DELETED,            -- Reference Deleted [fco_evtbsd_ref_deleted]
    CREATED_BY,         -- Created By [fco_created_by]
    CREA_DATE_TIME,     -- Time Stamp [timestampl]
    PRIMARY KEY (CLIENT, REFERENCE_UUID)
);