FAGL_BSBW_HISTRY

Transparent Table Application Table
23 Fields 1 CDS Views

Bewertungshistorie der Belege

FAGL_BSBW_HISTRY is an SAP database table in S/4HANA. Bewertungshistorie der Belege. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ValnHistForDocs view from CONSUMPTION Valuation History For Documents

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY belnr belnr_d Document Number
KEY gjahr gjahr Fiscal Year
KEY buzei buzei Item
KEY curtp fins_curtype Curr./Val. Type
KEY bwber bwber Valuation Area
KEY methd umbwm Val. Method
KEY datum datum Date
KEY runid fagl_runid Run ID
timestamp timestamp Time Stamp
bwshb bwshb Valuation Diff.
reverse_id fagl_reverse_id Reversal Run ID
fcv_status fagl_fcv_status Status:FC Valuation
valrunkey fagl_fcv_runkey Valuation Run ID No.
valtrgtpl_acct saknr G/L Account
valtrgtpl_type fagl_fcv_pltype P&L Target Account
rxdrunkey fagl_fcv_runkey Valuation Run ID No.
rxdxkdft xkdft Post Translation
valtrgtba_acct korrk Adjustment Acct
valrunkey_nrnr nrnr No. Range No.
rxdrunkey_nrnr nrnr No. Range No.
_dataaging data_temperature Data Aging

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.

-- Bewertungshistorie der Belege
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAGL_BSBW_HISTRY (
    MANDT,           -- Client [mandt]
    BUKRS,           -- Company Code [bukrs]
    BELNR,           -- Document Number [belnr_d]
    GJAHR,           -- Fiscal Year [gjahr]
    BUZEI,           -- Item [buzei]
    CURTP,           -- Curr./Val. Type [fins_curtype]
    BWBER,           -- Valuation Area [bwber]
    METHD,           -- Val. Method [umbwm]
    DATUM,           -- Date [datum]
    RUNID,           -- Run ID [fagl_runid]
    TIMESTAMP,       -- Time Stamp [timestamp]
    BWSHB,           -- Valuation Diff. [bwshb]
    REVERSE_ID,      -- Reversal Run ID [fagl_reverse_id]
    FCV_STATUS,      -- Status:FC Valuation [fagl_fcv_status]
    VALRUNKEY,       -- Valuation Run ID No. [fagl_fcv_runkey]
    VALTRGTPL_ACCT,  -- G/L Account [saknr]
    VALTRGTPL_TYPE,  -- P&L Target Account [fagl_fcv_pltype]
    RXDRUNKEY,       -- Valuation Run ID No. [fagl_fcv_runkey]
    RXDXKDFT,        -- Post Translation [xkdft]
    VALTRGTBA_ACCT,  -- Adjustment Acct [korrk]
    VALRUNKEY_NRNR,  -- No. Range No. [nrnr]
    RXDRUNKEY_NRNR,  -- No. Range No. [nrnr]
    _DATAAGING,      -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, BUKRS, BELNR, GJAHR, BUZEI, CURTP, BWBER, METHD, DATUM, RUNID)
);

Learn More