FBV_RESULT
Result Table for Inventory Balane Sheet Valuation runs
FBV_RESULT is an SAP database table in S/4HANA. Result Table for Inventory Balane Sheet Valuation runs. It contains 73 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_FBV_RESULT | view | from | BASIC | |
| P_FBV_RESULT_CONSID_ALT | view | from | BASIC | |
| P_FBV_RESULT_CONSID_ALT | view | union_all | BASIC |
Fields (73)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | prkzg | CK_PRICE_KZG | Valuation Alt. | |||
| KEY | bdatj | BDATJ | Year | |||
| KEY | poper | POPER | Posting Period | |||
| KEY | kalnr | CK_KALNR | Cost EstimateNo | |||
| KEY | curtype | FINS_EXT_CURTYPE | Crcy Type/Valn View | |||
| rldnr | RLDNR | Ledger | ||||
| bukrs | BUKRS | Company Code | ||||
| matnr | MATNR | Material | ||||
| bwkey | BWKEY | Valuation Area | ||||
| bwtar | BWTAR_D | Valuation Type | ||||
| valuation_level | FBV_VALUATION_LEVEL | Valuation Level | ||||
| prcid | MY_PROCID | Procedure ID | ||||
| mtart | MTART | Material Type | ||||
| racct | RACCT | Account Number | ||||
| salk3 | SALK3 | Total Value | ||||
| lbkum | LBKUM | Total Stock | ||||
| meins | CKML_MEINS | Unit of Measure | ||||
| waers | WAERS | Currency | ||||
| material_acc_age | FBV_MATERIAL_ACC_AGE | Material Acct. Age | ||||
| valuation_explanation | FBV_VALUATION_EXPLANATION | Valu. Explanation | ||||
| balloghndl | BALLOGHNDL | Handle | ||||
| posting_log_handle | FBV_POSTING_LOG_HANDLE | Posting Application Log Handle | ||||
| peinh | PEINH | Price unit | ||||
| inventory_price | FML_INVENTORY_PRICE | Inventory Price | ||||
| price_numerator | FBV_PRICE_NUMERATOR | Price Numerator | ||||
| price_denominator | FBV_PRICE_DENOMINATOR | Price Denominator | ||||
| cons_qty_wght | FBV_CONS_QTY_WGHT | Consumption Quantity | ||||
| cons_qty_wght_avg | FBV_CONS_QTY_WGHT_AVG | Avg. Wgtd Cnsmpn Qty | ||||
| stock_qty_wght_avg | FBV_STOCK_QTY_WGHT_AVG | Avg. Wgtd Stock Qty | ||||
| receipt_qty_wght | FBV_RECEIPT_QTY_WGHT | Receipt Quantity | ||||
| deval_prc | FBV_DEVAL_PRC | Devaluation Percent | ||||
| deval_exclude_reason | FBV_DEVAL_EXCLUDE_REASON | Exclusion Reason | ||||
| deval_level | FBV_DEVAL_LEVEL | Deval. Level Code | ||||
| pri_sel_id | FBV_PRI_SEL_ID | Price Selection ID | ||||
| pri_sel_va | FBV_PRI_SEL_VA | Sel. Val. Alt. | ||||
| base_price | FBV_BASE_PRICE | Base Price | ||||
| material_acc_exclusion_date | FBV_MATERIAL_ACC_EXCLUDE_DATE | Mat. Acc. Excl. Date | ||||
| cons_threshold | FBV_CONS_THRESHOLD | Thresh. Consumption | ||||
| receipt_threshold | FBV_RECEIPT_THRESHOLD | Threshold Receipt | ||||
| rnge_of_cvrg | FBV_ROC_PER | Range of Coverage | ||||
| mr_deval_keyf_old | FBV_MR_DEVAL_KEYF_OLD | Old Devalution Cnt. | ||||
| mr_deval_keyf_new | FBV_MR_DEVAL_KEYF_NEW | New Devalution Cnt. | ||||
| mov_rate_prc | FBV_MOV_RATE_PRC | Movement Rate | ||||
| cons_mov_rate_prc | FBV_CONS_MOV_RATE_PRC | Cons. Movement Rate | ||||
| receipt_mov_rate_prc | FBV_REC_MOV_RATE_PRC | Receipt Mov. Rate | ||||
| deval_keyf_ref_fiscyear | FBV_DEVAL_KEYF_REF_FISCYEAR | Deval. Ref. Year | ||||
| deval_keyf_ref_fiscper | FBV_DEVAL_KEYF_REF_FISCPER | Deval. Ref. Period | ||||
| is_release_mr_keyf | FBV_IS_RELEASE_MR_KEYF | Release Deval. Cnt. | ||||
| is_consid_inventory_value | FBV_IS_CONSID_INVENTORY_VALUE | Consider Inv. Value | ||||
| considered_valuation_alt_1 | FBV_CONSIDERED_VALUATION_ALT1 | 1. Consid. Val. Alt. | ||||
| considered_val_alt_value_1 | FBV_CONSIDERED_VAL_ALT1_VALUE | 1.Consid Val Alt Val | ||||
| considered_valuation_alt_2 | FBV_CONSIDERED_VALUATION_ALT2 | 2. Consid. Val. Alt. | ||||
| considered_val_alt_value_2 | FBV_CONSIDERED_VAL_ALT2_VALUE | 2.Consid Val Alt Val | ||||
| considered_valuation_alt_3 | FBV_CONSIDERED_VALUATION_ALT3 | 3. Consid. Val. Alt. | ||||
| considered_val_alt_value_3 | FBV_CONSIDERED_VAL_ALT3_VALUE | 3.Consid Val Alt Val | ||||
| considered_valuation_alt_4 | FBV_CONSIDERED_VALUATION_ALT4 | 4. Consid. Val. Alt. | ||||
| considered_val_alt_value_4 | FBV_CONSIDERED_VAL_ALT4_VALUE | 4.Consid Val Alt Val | ||||
| considered_valuation_alt_5 | FBV_CONSIDERED_VALUATION_ALT5 | 5. Consid. Val. Alt. | ||||
| considered_val_alt_value_5 | FBV_CONSIDERED_VAL_ALT5_VALUE | 5.Consid Val Alt Val | ||||
| awtyp | AWTYP | Ref. procedure | ||||
| awref | AWREF | Reference Doc. | ||||
| aworg | AWORG | Refer. Org.Unit | ||||
| delta_run_id | LAUFID | ID of Delta Run | ||||
| accounting_document | BELNR_D | Document Number | ||||
| posting_state | FBV_POSTING_STATE | Posting State | ||||
| reverse_accounting_document | STBLG | Reversed With | ||||
| reverse_fiscal_year | STJAH | Year | ||||
| is_convert_other_curtypes | FBV_IS_CONVERT_OTHER_CURTYPES | Conv Currency Types | ||||
| minimum_valuation_alt | FBV_MINIMUM_VALUATION_ALT | Minimum Val. Alt. | ||||
| minimum_value | FBV_MINIMUM_VALUE | Minimum Value | ||||
| prctr | PRCTR | Profit Center | ||||
| segment | FB_SEGMENT | Segment |
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.
-- Result Table for Inventory Balane Sheet Valuation runs
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FBV_RESULT (
MANDT, -- Client [MANDT]
PRKZG, -- Valuation Alt. [CK_PRICE_KZG]
BDATJ, -- Year [BDATJ]
POPER, -- Posting Period [POPER]
KALNR, -- Cost EstimateNo [CK_KALNR]
CURTYPE, -- Crcy Type/Valn View [FINS_EXT_CURTYPE]
RLDNR, -- Ledger [RLDNR]
BUKRS, -- Company Code [BUKRS]
MATNR, -- Material [MATNR]
BWKEY, -- Valuation Area [BWKEY]
BWTAR, -- Valuation Type [BWTAR_D]
VALUATION_LEVEL, -- Valuation Level [FBV_VALUATION_LEVEL]
PRCID, -- Procedure ID [MY_PROCID]
MTART, -- Material Type [MTART]
RACCT, -- Account Number [RACCT]
SALK3, -- Total Value [SALK3]
LBKUM, -- Total Stock [LBKUM]
MEINS, -- Unit of Measure [CKML_MEINS]
WAERS, -- Currency [WAERS]
MATERIAL_ACC_AGE, -- Material Acct. Age [FBV_MATERIAL_ACC_AGE]
VALUATION_EXPLANATION, -- Valu. Explanation [FBV_VALUATION_EXPLANATION]
BALLOGHNDL, -- Handle [BALLOGHNDL]
POSTING_LOG_HANDLE, -- Posting Application Log Handle [FBV_POSTING_LOG_HANDLE]
PEINH, -- Price unit [PEINH]
INVENTORY_PRICE, -- Inventory Price [FML_INVENTORY_PRICE]
PRICE_NUMERATOR, -- Price Numerator [FBV_PRICE_NUMERATOR]
PRICE_DENOMINATOR, -- Price Denominator [FBV_PRICE_DENOMINATOR]
CONS_QTY_WGHT, -- Consumption Quantity [FBV_CONS_QTY_WGHT]
CONS_QTY_WGHT_AVG, -- Avg. Wgtd Cnsmpn Qty [FBV_CONS_QTY_WGHT_AVG]
STOCK_QTY_WGHT_AVG, -- Avg. Wgtd Stock Qty [FBV_STOCK_QTY_WGHT_AVG]
RECEIPT_QTY_WGHT, -- Receipt Quantity [FBV_RECEIPT_QTY_WGHT]
DEVAL_PRC, -- Devaluation Percent [FBV_DEVAL_PRC]
DEVAL_EXCLUDE_REASON, -- Exclusion Reason [FBV_DEVAL_EXCLUDE_REASON]
DEVAL_LEVEL, -- Deval. Level Code [FBV_DEVAL_LEVEL]
PRI_SEL_ID, -- Price Selection ID [FBV_PRI_SEL_ID]
PRI_SEL_VA, -- Sel. Val. Alt. [FBV_PRI_SEL_VA]
BASE_PRICE, -- Base Price [FBV_BASE_PRICE]
MATERIAL_ACC_EXCLUSION_DATE, -- Mat. Acc. Excl. Date [FBV_MATERIAL_ACC_EXCLUDE_DATE]
CONS_THRESHOLD, -- Thresh. Consumption [FBV_CONS_THRESHOLD]
RECEIPT_THRESHOLD, -- Threshold Receipt [FBV_RECEIPT_THRESHOLD]
RNGE_OF_CVRG, -- Range of Coverage [FBV_ROC_PER]
MR_DEVAL_KEYF_OLD, -- Old Devalution Cnt. [FBV_MR_DEVAL_KEYF_OLD]
MR_DEVAL_KEYF_NEW, -- New Devalution Cnt. [FBV_MR_DEVAL_KEYF_NEW]
MOV_RATE_PRC, -- Movement Rate [FBV_MOV_RATE_PRC]
CONS_MOV_RATE_PRC, -- Cons. Movement Rate [FBV_CONS_MOV_RATE_PRC]
RECEIPT_MOV_RATE_PRC, -- Receipt Mov. Rate [FBV_REC_MOV_RATE_PRC]
DEVAL_KEYF_REF_FISCYEAR, -- Deval. Ref. Year [FBV_DEVAL_KEYF_REF_FISCYEAR]
DEVAL_KEYF_REF_FISCPER, -- Deval. Ref. Period [FBV_DEVAL_KEYF_REF_FISCPER]
IS_RELEASE_MR_KEYF, -- Release Deval. Cnt. [FBV_IS_RELEASE_MR_KEYF]
IS_CONSID_INVENTORY_VALUE, -- Consider Inv. Value [FBV_IS_CONSID_INVENTORY_VALUE]
CONSIDERED_VALUATION_ALT_1, -- 1. Consid. Val. Alt. [FBV_CONSIDERED_VALUATION_ALT1]
CONSIDERED_VAL_ALT_VALUE_1, -- 1.Consid Val Alt Val [FBV_CONSIDERED_VAL_ALT1_VALUE]
CONSIDERED_VALUATION_ALT_2, -- 2. Consid. Val. Alt. [FBV_CONSIDERED_VALUATION_ALT2]
CONSIDERED_VAL_ALT_VALUE_2, -- 2.Consid Val Alt Val [FBV_CONSIDERED_VAL_ALT2_VALUE]
CONSIDERED_VALUATION_ALT_3, -- 3. Consid. Val. Alt. [FBV_CONSIDERED_VALUATION_ALT3]
CONSIDERED_VAL_ALT_VALUE_3, -- 3.Consid Val Alt Val [FBV_CONSIDERED_VAL_ALT3_VALUE]
CONSIDERED_VALUATION_ALT_4, -- 4. Consid. Val. Alt. [FBV_CONSIDERED_VALUATION_ALT4]
CONSIDERED_VAL_ALT_VALUE_4, -- 4.Consid Val Alt Val [FBV_CONSIDERED_VAL_ALT4_VALUE]
CONSIDERED_VALUATION_ALT_5, -- 5. Consid. Val. Alt. [FBV_CONSIDERED_VALUATION_ALT5]
CONSIDERED_VAL_ALT_VALUE_5, -- 5.Consid Val Alt Val [FBV_CONSIDERED_VAL_ALT5_VALUE]
AWTYP, -- Ref. procedure [AWTYP]
AWREF, -- Reference Doc. [AWREF]
AWORG, -- Refer. Org.Unit [AWORG]
DELTA_RUN_ID, -- ID of Delta Run [LAUFID]
ACCOUNTING_DOCUMENT, -- Document Number [BELNR_D]
POSTING_STATE, -- Posting State [FBV_POSTING_STATE]
REVERSE_ACCOUNTING_DOCUMENT, -- Reversed With [STBLG]
REVERSE_FISCAL_YEAR, -- Year [STJAH]
IS_CONVERT_OTHER_CURTYPES, -- Conv Currency Types [FBV_IS_CONVERT_OTHER_CURTYPES]
MINIMUM_VALUATION_ALT, -- Minimum Val. Alt. [FBV_MINIMUM_VALUATION_ALT]
MINIMUM_VALUE, -- Minimum Value [FBV_MINIMUM_VALUE]
PRCTR, -- Profit Center [PRCTR]
SEGMENT, -- Segment [FB_SEGMENT]
PRIMARY KEY (MANDT, PRKZG, BDATJ, POPER, KALNR, CURTYPE)
);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