BSBW_VAL

Transparent Table Application Table
31 Fields 1 CDS Views

Valuations for Accrual Objects

BSBW_VAL is an SAP database table in S/4HANA. Valuations for Accrual Objects. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FI_BSBW_VAL_ARCHIVING view_entity from FI Valuation Protocol Archiving View

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY acrobjtype ACR_OBJ_TYPE Accrual Object Type
KEY acrobj_id ACR_OBJ_ID Accrual Object
KEY acrsobj_id ACR_SUBOBJ_ID Accrual Subobject
KEY acritmtype ACR_ITEM_TYPE Accrual Item Type
KEY curtp CURTP Crcy type/val.
KEY bwber BWBER Valuation Area
KEY methd UMBWM Val. Method
KEY datum DATUM Date
KEY runkey FAGL_FCV_RUNKEY Valuation Run ID No.
reset_runkey FAGL_FCV_RUNKEY Valuation Run ID No.
status BSBW_VAL_STATUS Status o. Valuatn.
bwshb BWSHB Valuation Diff.
waers WAERS Currency
base_amount FAGL_BASE_AMOUNT Base Amt of Val.
wbrsl WBRSL Value Adj. Key
methd_base UMBWM Val. Method
maturity_bucket DUE_BUCKET Maturity Bucket
maturity_score DUE_SCORE Maturity Score
maturity_unit TIMEUNIT Time unit
maturity_future FFUTURE Future
xno_bucket DUE_XNO_BUCKET No Maturity Bucket
zinso DZINSO Debit Int. Rate
netting XCLEAR_F107 Offset by CM
x_bsbm BSBM_X Manually
xmanu XMANU Manual
translation BSBW_VAL_TRANSL Translation
kunnr KUNNR Customer
lifnr LIFNR Supplier
timestamp TIMESTAMP 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.

-- Valuations for Accrual Objects
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BSBW_VAL (
    MANDT,            -- Client [MANDT]
    BUKRS,            -- Company Code [BUKRS]
    ACROBJTYPE,       -- Accrual Object Type [ACR_OBJ_TYPE]
    ACROBJ_ID,        -- Accrual Object [ACR_OBJ_ID]
    ACRSOBJ_ID,       -- Accrual Subobject [ACR_SUBOBJ_ID]
    ACRITMTYPE,       -- Accrual Item Type [ACR_ITEM_TYPE]
    CURTP,            -- Crcy type/val. [CURTP]
    BWBER,            -- Valuation Area [BWBER]
    METHD,            -- Val. Method [UMBWM]
    DATUM,            -- Date [DATUM]
    RUNKEY,           -- Valuation Run ID No. [FAGL_FCV_RUNKEY]
    RESET_RUNKEY,     -- Valuation Run ID No. [FAGL_FCV_RUNKEY]
    STATUS,           -- Status o. Valuatn. [BSBW_VAL_STATUS]
    BWSHB,            -- Valuation Diff. [BWSHB]
    WAERS,            -- Currency [WAERS]
    BASE_AMOUNT,      -- Base Amt of Val. [FAGL_BASE_AMOUNT]
    WBRSL,            -- Value Adj. Key [WBRSL]
    METHD_BASE,       -- Val. Method [UMBWM]
    MATURITY_BUCKET,  -- Maturity Bucket [DUE_BUCKET]
    MATURITY_SCORE,   -- Maturity Score [DUE_SCORE]
    MATURITY_UNIT,    -- Time unit [TIMEUNIT]
    MATURITY_FUTURE,  -- Future [FFUTURE]
    XNO_BUCKET,       -- No Maturity Bucket [DUE_XNO_BUCKET]
    ZINSO,            -- Debit Int. Rate [DZINSO]
    NETTING,          -- Offset by CM [XCLEAR_F107]
    X_BSBM,           -- Manually [BSBM_X]
    XMANU,            -- Manual [XMANU]
    TRANSLATION,      -- Translation [BSBW_VAL_TRANSL]
    KUNNR,            -- Customer [KUNNR]
    LIFNR,            -- Supplier [LIFNR]
    TIMESTAMP,        -- Time Stamp [TIMESTAMP]
    PRIMARY KEY (MANDT, BUKRS, ACROBJTYPE, ACROBJ_ID, ACRSOBJ_ID, ACRITMTYPE, CURTP, BWBER, METHD, DATUM, RUNKEY)
);

Learn More