FCOT_EVTBSD_REF
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_ReferenceTable | view_entity | from | BASIC | Reference table |
| R_EvtBsdProdCostgSettlmtRef | view_entity | from | BASIC | Event based settlement reference table view |
Fields (25)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA