WB2_D_BVDETAIL

Transparent Table Application Table
26 Fields 6 CDS Views

Condition Contract: Settlement Detailed Statement

WB2_D_BVDETAIL is an SAP database table in S/4HANA. Condition Contract: Settlement Detailed Statement. It contains 26 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
R_CndnDocSettlmtDetldStmnt view_entity from BASIC Detailed Statement of Condition Document
view_ds_ab_par view from Det. Stmt. of CCS with Settl. Mgnt.-Docs as Bus. Vol. Docs
view_ds_gr_par view from Det. Stmt. of CCS with Goods Receipts as Bus. Vol. Docs
view_ds_iv_par view from Det. Stmt. of CCS with Incoming Invoices as Bus. Vol. Docs
view_ds_po_par view from Det. Stmt. of CCS with Purchase Orders as Bus. Vol. Docs
view_ds_sdi_par view from Det. Stmt. of CCS with Billing Documents as Bus. Vol. Docs

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY num WCB_COCO_NUM Condition Contract
KEY wbeln WBELN_LF Document
KEY posnr WPOSNR_LF Item
KEY doc_type WB2_DOC_TYPE_BUSVOL Document Type BusVol
KEY doc_id WB2_DOC_ID_BUSVOL Document ID
KEY doc_id2 WB2_DOC_ID_BUSVOL_2 Document ID 2
KEY doc_id3 WB2_DOC_ID_BUSVOL_3 Document ID 3
KEY doc_item WB2_DOC_ITEM_BUSVOL Document Item
bv_date WB2_DATE_FOR_SETTLEMENT Date for Settlement
menge MENGE_D Quantity
meina MEINA Unit of measure
waers WAERS Currency
ntgew NTGEW Net Weight
brgew BRGEW Gross Weight
gewei GEWEI Unit of Weight
volum VOLUM Volume
voleh VOLEH Volume Unit
anzpu ANZPU Points
punei PUNEI Points Unit
settl_doc_type WB2_SETTLEMENT_DOCUMENT_TYPE Settlement Doc Type
busvol_1 WB2_BUSVOL_1 Business Volume 1
busvol_2 WB2_BUSVOL_2 Business Volume 2
busvol_3 WB2_BUSVOL_3 Business Volume 3
busvol_4 WB2_BUSVOL_4 Business Volume 4
dummy1 DUMMY Dummy function in length 1

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.

-- Condition Contract: Settlement Detailed Statement
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WB2_D_BVDETAIL (
    MANDT,           -- Client [MANDT]
    NUM,             -- Condition Contract [WCB_COCO_NUM]
    WBELN,           -- Document [WBELN_LF]
    POSNR,           -- Item [WPOSNR_LF]
    DOC_TYPE,        -- Document Type BusVol [WB2_DOC_TYPE_BUSVOL]
    DOC_ID,          -- Document ID [WB2_DOC_ID_BUSVOL]
    DOC_ID2,         -- Document ID 2 [WB2_DOC_ID_BUSVOL_2]
    DOC_ID3,         -- Document ID 3 [WB2_DOC_ID_BUSVOL_3]
    DOC_ITEM,        -- Document Item [WB2_DOC_ITEM_BUSVOL]
    BV_DATE,         -- Date for Settlement [WB2_DATE_FOR_SETTLEMENT]
    MENGE,           -- Quantity [MENGE_D]
    MEINA,           -- Unit of measure [MEINA]
    WAERS,           -- Currency [WAERS]
    NTGEW,           -- Net Weight [NTGEW]
    BRGEW,           -- Gross Weight [BRGEW]
    GEWEI,           -- Unit of Weight [GEWEI]
    VOLUM,           -- Volume [VOLUM]
    VOLEH,           -- Volume Unit [VOLEH]
    ANZPU,           -- Points [ANZPU]
    PUNEI,           -- Points Unit [PUNEI]
    SETTL_DOC_TYPE,  -- Settlement Doc Type [WB2_SETTLEMENT_DOCUMENT_TYPE]
    BUSVOL_1,        -- Business Volume 1 [WB2_BUSVOL_1]
    BUSVOL_2,        -- Business Volume 2 [WB2_BUSVOL_2]
    BUSVOL_3,        -- Business Volume 3 [WB2_BUSVOL_3]
    BUSVOL_4,        -- Business Volume 4 [WB2_BUSVOL_4]
    DUMMY1,          -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, NUM, WBELN, POSNR, DOC_TYPE, DOC_ID, DOC_ID2, DOC_ID3, DOC_ITEM)
);

Learn More