BSBW_VAL
Bewertungen für Abgrenzungsobjekte
BSBW_VAL is an SAP database table in S/4HANA. Bewertungen für Abgrenzungsobjekte. It contains 31 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FI_BSBW_VAL_ARCHIVING | view_entity | from | FI Valuation Protocol Archiving View |
Fields (31)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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.
-- Bewertungen für Abgrenzungsobjekte
-- 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
- 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