SAP table WB2_C_BVTAB (Rebates: Business Volume Tables)

SAP table WB2_C_BVTAB has 2 primary key fields being MANDT,ID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
ID Profile for the Determination of Business Volume Data CHAR 4 0 WB2_BUSVOLTAB_ID
BUSVOLTAB Database Table or View that Contains the Business Volume CHAR 30 0 DD02L WB2_BUSVOLTAB
FIELD_VENDOR (Alternative) Field Name for Supplier CHAR 30 0 DD03L WB2_FIELD_VENDOR
FIELD_CUSTOMER (Alternative) Field Name for Customer CHAR 30 0 DD03L WB2_FIELD_CUSTOMER
FIELD_DATE Field Name for Date CHAR 30 0 DD03L WB2_FIELD_DATE
FIELD_WAERS Field Name for Currency CHAR 30 0 DD03L WB2_FIELD_WAERS
FIELD_MENGE Field Name for Quantity CHAR 30 0 DD03L WB2_FIELD_MENGE
FIELD_MEINS Field Name for Unit of Measure of the Quantity Field CHAR 30 0 DD03L WB2_FIELD_MEINS
FIELD_COCO_NUM Field Name for Condition Contract Number CHAR 30 0 DD03L WB2_FIELD_COCO_NUM
FIELD_VEND_LIST Field Name Supplier for Supplier List CHAR 30 0 DD03L WB2_FIELD_VENDOR_VEND_LIST
FIELD_CUST_LIST Field Name Customer for Customer List CHAR 30 0 DD03L WB2_FIELD_CUSTOMER_CUST_LIST
ADJUST_SIGN Adjust Sign for Business Volume Determination CHAR 2 0 WB2_BVTAB_ADJUST_SIGN
No
01 Settlement Management Documents
02 SD Billing Documents
03 Goods Receipt / Invoice Verification
04 Purchase Order
05 Settlement Management Documents - Inverted
06 Sales Order
FIELD_PLANT_LIST Field Name Plant for Plant List CHAR 30 0 DD03L WB2_FIELD_PLANT_PLANT_LIST
FIELD_NTGEW Field Name for Net Weight CHAR 30 0 DD03L WB2_FIELD_NTGEW
FIELD_BRGEW Field Name for Gross Weight CHAR 30 0 DD03L WB2_FIELD_BRGEW
FIELD_GEWEI Field Name for Weight Unit CHAR 30 0 DD03L WB2_FIELD_GEWEI
FIELD_VOLUM Field Name for Volume CHAR 30 0 DD03L WB2_FIELD_VOLUM
FIELD_VOLEH Field Name for Volume Unit CHAR 30 0 DD03L WB2_FIELD_VOLEH
FIELD_ANZPU Field Name for Points CHAR 30 0 DD03L WB2_FIELD_ANZPU
FIELD_PUNEI Field Name for Points Unit CHAR 30 0 DD03L WB2_FIELD_PUNEI
DATE_SELECTION Date Selection CHAR 1 0 WB2_DATE_SELECTION
Standard
1 Date Intervall
2 No Date Selection
FIELD_DATE_TO Field Name for 'Date to' CHAR 30 0 DD03L WB2_FIELD_DATE_TO
NO_SELECTION No Selection from Business Volume Table CHAR 1 0 WB2_BVTAB_NO_SELECTION
DOC_TYPE Document Type of Business Volume Source Document CHAR 2 0 WB2_DOC_TYPE_BUSVOL
01 Settlement Management Document
02 SD Billing Document
03 Goods Receipt
04 Invoice Verification
05 Purchase Order
06 Sales Order
07 Universal Journal Entry
08 Convergent Invoicing
09 Billable Item
10 Settlement Document
11 Supplier Billing Document
12 Expense Settlement
13 Customer Settlement
14 Supplier Settlement
FIELD_DOC_ID1 Field Name for Document-ID 1 CHAR 30 0 DD03L WB2_FIELD_DOC_ID_BUSVOL_1
FIELD_DOC_ID2 Field Name for Document-ID 2 CHAR 30 0 DD03L WB2_FIELD_DOC_ID_BUSVOL_2
FIELD_DOC_ID3 Field Name for Document-ID 3 CHAR 30 0 DD03L WB2_FIELD_DOC_ID_BUSVOL_3
FIELD_DOC_ITEM Field Name for Document Item CHAR 30 0 DD03L WB2_FIELD_DOC_ITEM_BUSVOL
FIELD_PRED_CC Field Name of Predecessor Condition Contract Number CHAR 30 0 DD03L WB2_FIELD_PRED_CC
EXPLODE_WGHIE Explode Material Group Hierarchy CHAR 1 0 WB2_EXPLODE_WGHIE
EXPLODE_KUNHIER Explode Customer Hierarchy CHAR 1 0 THIT WB2_EXPLODE_KUNHIER
EXPLOSION_GROUP Explosion Group for Business Volume Selection CHAR 4 0 WB2_C_BVB_XPGRP WB2_BVB_EXPLOSION_GROUP
FIELD_MATNR Field Name for Material CHAR 30 0 DD03L WB2_FIELD_MATNR
FILL_TOTAL_MENGE Transfer Bus Volume Total Quantity to Settlement Documents CHAR 1 0 WB2_FILL_TOTAL_MENGE
FILL_TOTAL_NTGEW Transfer Bus Volume Total Net Weight to Settlement Documents CHAR 1 0 WB2_FILL_TOTAL_NTGEW
FILL_TOTAL_BRGEW Transfer Bus Vol Total Gross Weight to Settlement Documents CHAR 1 0 WB2_FILL_TOTAL_BRGEW
FILL_TOTAL_VOLUM Transfer Bus Volume Total Volume to Settlement Documents CHAR 1 0 WB2_FILL_TOTAL_VOLUM
FILL_TOTAL_ANZPU Transfer Bus Volume Total Points to Settlement Documents CHAR 1 0 WB2_FILL_TOTAL_ANZPU
EXPLODE_KUNHIER_TYPE Customer Hierarchy Explosion Type CHAR 1 0 WB2_EXPLODE_KUNHIER_TYPE
Pricing Relevance & Settlement Period
1 Pricing Relevance & Customer Validity
2 Customer on Lowest Level & Settlement Period
3 Customer on Lowest Level & Customer Validity
BUSVOLTAB_USES_DDL_SOURCE Business Volume Table Uses DDL Source Indicator CHAR 1 0 WB2_BUSVOLTAB_USES_DDL_SOURCE
USE_EXT_NAME_IN_FIELD_COMB Use External Fieldname in Field Combination Indicator CHAR 1 0 WB2_USE_EXT_NAME_IN_FIELD_COMB
FIELD_T2CCODE_FACTOR Field Name Factor for Tax Amount in Company Code Currency CHAR 30 0 DD03L WB2_FIELD_T2CCODE_FACTOR
FIELD_T2CNTRY_FACTOR Field Name Factor for Tax Amount in Reporting Currency CHAR 30 0 DD03L WB2_FIELD_T2CNTRY_FACTOR

WB2_C_BVTAB foreign key relationships

Table Field Check Table Check Field
0 WB2_C_BVTAB BUSVOLTAB DD02L SAP Tables TABNAME
0 WB2_C_BVTAB BUSVOLTAB DD02L SAP Tables AS4LOCAL
0 WB2_C_BVTAB BUSVOLTAB DD02L SAP Tables AS4VERS
1 WB2_C_BVTAB EXPLODE_KUNHIER THIT Customer Hierarchy Types MANDT
1 WB2_C_BVTAB EXPLODE_KUNHIER THIT Customer Hierarchy Types HITYP
0 WB2_C_BVTAB EXPLOSION_GROUP WB2_C_BVB_XPGRP CCS: Explosion Group for Business Volume Base MANDT
1 WB2_C_BVTAB FIELD_ANZPU DD03L Table Fields TABNAME
1 WB2_C_BVTAB FIELD_ANZPU DD03L Table Fields FIELDNAME
1 WB2_C_BVTAB FIELD_ANZPU DD03L Table Fields AS4LOCAL
1 WB2_C_BVTAB FIELD_ANZPU DD03L Table Fields AS4VERS
0 WB2_C_BVTAB FIELD_BRGEW DD03L Table Fields TABNAME
0 WB2_C_BVTAB FIELD_BRGEW DD03L Table Fields FIELDNAME
0 WB2_C_BVTAB FIELD_BRGEW DD03L Table Fields AS4LOCAL
0 WB2_C_BVTAB FIELD_BRGEW DD03L Table Fields AS4VERS
1 WB2_C_BVTAB FIELD_COCO_NUM DD03L Table Fields TABNAME
1 WB2_C_BVTAB FIELD_COCO_NUM DD03L Table Fields FIELDNAME
1 WB2_C_BVTAB FIELD_COCO_NUM DD03L Table Fields AS4LOCAL
1 WB2_C_BVTAB FIELD_COCO_NUM DD03L Table Fields AS4VERS
0 WB2_C_BVTAB FIELD_CUSTOMER DD03L Table Fields TABNAME
0 WB2_C_BVTAB FIELD_CUSTOMER DD03L Table Fields FIELDNAME
0 WB2_C_BVTAB FIELD_CUSTOMER DD03L Table Fields AS4LOCAL
0 WB2_C_BVTAB FIELD_CUSTOMER DD03L Table Fields AS4VERS
1 WB2_C_BVTAB FIELD_CUST_LIST DD03L Table Fields TABNAME
1 WB2_C_BVTAB FIELD_CUST_LIST DD03L Table Fields FIELDNAME
1 WB2_C_BVTAB FIELD_CUST_LIST DD03L Table Fields AS4LOCAL
1 WB2_C_BVTAB FIELD_CUST_LIST DD03L Table Fields AS4VERS
0 WB2_C_BVTAB FIELD_DATE DD03L Table Fields TABNAME
0 WB2_C_BVTAB FIELD_DATE DD03L Table Fields FIELDNAME
0 WB2_C_BVTAB FIELD_DATE DD03L Table Fields AS4LOCAL
0 WB2_C_BVTAB FIELD_DATE DD03L Table Fields AS4VERS
1 WB2_C_BVTAB FIELD_DATE_TO DD03L Table Fields TABNAME
1 WB2_C_BVTAB FIELD_DATE_TO DD03L Table Fields FIELDNAME
1 WB2_C_BVTAB FIELD_DATE_TO DD03L Table Fields AS4LOCAL
1 WB2_C_BVTAB FIELD_DATE_TO DD03L Table Fields AS4VERS
0 WB2_C_BVTAB FIELD_DOC_ID1 DD03L Table Fields TABNAME
0 WB2_C_BVTAB FIELD_DOC_ID1 DD03L Table Fields FIELDNAME
0 WB2_C_BVTAB FIELD_DOC_ID1 DD03L Table Fields AS4LOCAL
0 WB2_C_BVTAB FIELD_DOC_ID1 DD03L Table Fields AS4VERS
1 WB2_C_BVTAB FIELD_DOC_ID2 DD03L Table Fields TABNAME
1 WB2_C_BVTAB FIELD_DOC_ID2 DD03L Table Fields FIELDNAME
1 WB2_C_BVTAB FIELD_DOC_ID2 DD03L Table Fields AS4LOCAL
1 WB2_C_BVTAB FIELD_DOC_ID2 DD03L Table Fields AS4VERS
0 WB2_C_BVTAB FIELD_DOC_ID3 DD03L Table Fields TABNAME
0 WB2_C_BVTAB FIELD_DOC_ID3 DD03L Table Fields FIELDNAME
0 WB2_C_BVTAB FIELD_DOC_ID3 DD03L Table Fields AS4LOCAL
0 WB2_C_BVTAB FIELD_DOC_ID3 DD03L Table Fields AS4VERS
1 WB2_C_BVTAB FIELD_DOC_ITEM DD03L Table Fields TABNAME
1 WB2_C_BVTAB FIELD_DOC_ITEM DD03L Table Fields FIELDNAME
1 WB2_C_BVTAB FIELD_DOC_ITEM DD03L Table Fields AS4LOCAL
1 WB2_C_BVTAB FIELD_DOC_ITEM DD03L Table Fields AS4VERS
0 WB2_C_BVTAB FIELD_GEWEI DD03L Table Fields TABNAME
0 WB2_C_BVTAB FIELD_GEWEI DD03L Table Fields FIELDNAME
0 WB2_C_BVTAB FIELD_GEWEI DD03L Table Fields AS4LOCAL
0 WB2_C_BVTAB FIELD_GEWEI DD03L Table Fields AS4VERS
1 WB2_C_BVTAB FIELD_MATNR DD03L Table Fields TABNAME
1 WB2_C_BVTAB FIELD_MATNR DD03L Table Fields FIELDNAME
1 WB2_C_BVTAB FIELD_MATNR DD03L Table Fields AS4LOCAL
1 WB2_C_BVTAB FIELD_MATNR DD03L Table Fields AS4VERS
0 WB2_C_BVTAB FIELD_MEINS DD03L Table Fields TABNAME
0 WB2_C_BVTAB FIELD_MEINS DD03L Table Fields FIELDNAME
0 WB2_C_BVTAB FIELD_MEINS DD03L Table Fields AS4LOCAL
0 WB2_C_BVTAB FIELD_MEINS DD03L Table Fields AS4VERS
1 WB2_C_BVTAB FIELD_MENGE DD03L Table Fields TABNAME
1 WB2_C_BVTAB FIELD_MENGE DD03L Table Fields FIELDNAME
1 WB2_C_BVTAB FIELD_MENGE DD03L Table Fields AS4LOCAL
1 WB2_C_BVTAB FIELD_MENGE DD03L Table Fields AS4VERS
0 WB2_C_BVTAB FIELD_NTGEW DD03L Table Fields TABNAME
0 WB2_C_BVTAB FIELD_NTGEW DD03L Table Fields FIELDNAME
0 WB2_C_BVTAB FIELD_NTGEW DD03L Table Fields AS4LOCAL
0 WB2_C_BVTAB FIELD_NTGEW DD03L Table Fields AS4VERS
1 WB2_C_BVTAB FIELD_PLANT_LIST DD03L Table Fields TABNAME
1 WB2_C_BVTAB FIELD_PLANT_LIST DD03L Table Fields FIELDNAME
1 WB2_C_BVTAB FIELD_PLANT_LIST DD03L Table Fields AS4LOCAL
1 WB2_C_BVTAB FIELD_PLANT_LIST DD03L Table Fields AS4VERS
0 WB2_C_BVTAB FIELD_PRED_CC DD03L Table Fields TABNAME
0 WB2_C_BVTAB FIELD_PRED_CC DD03L Table Fields FIELDNAME
0 WB2_C_BVTAB FIELD_PRED_CC DD03L Table Fields AS4LOCAL
0 WB2_C_BVTAB FIELD_PRED_CC DD03L Table Fields AS4VERS
1 WB2_C_BVTAB FIELD_PUNEI DD03L Table Fields TABNAME
1 WB2_C_BVTAB FIELD_PUNEI DD03L Table Fields FIELDNAME
1 WB2_C_BVTAB FIELD_PUNEI DD03L Table Fields AS4LOCAL
1 WB2_C_BVTAB FIELD_PUNEI DD03L Table Fields AS4VERS
0 WB2_C_BVTAB FIELD_T2CCODE_FACTOR DD03L Table Fields TABNAME
0 WB2_C_BVTAB FIELD_T2CCODE_FACTOR DD03L Table Fields FIELDNAME
0 WB2_C_BVTAB FIELD_T2CCODE_FACTOR DD03L Table Fields AS4LOCAL
0 WB2_C_BVTAB FIELD_T2CCODE_FACTOR DD03L Table Fields AS4VERS
1 WB2_C_BVTAB FIELD_T2CNTRY_FACTOR DD03L Table Fields TABNAME
1 WB2_C_BVTAB FIELD_T2CNTRY_FACTOR DD03L Table Fields FIELDNAME
1 WB2_C_BVTAB FIELD_T2CNTRY_FACTOR DD03L Table Fields AS4LOCAL
1 WB2_C_BVTAB FIELD_T2CNTRY_FACTOR DD03L Table Fields AS4VERS
0 WB2_C_BVTAB FIELD_VENDOR DD03L Table Fields TABNAME
0 WB2_C_BVTAB FIELD_VENDOR DD03L Table Fields FIELDNAME
0 WB2_C_BVTAB FIELD_VENDOR DD03L Table Fields AS4LOCAL
0 WB2_C_BVTAB FIELD_VENDOR DD03L Table Fields AS4VERS
1 WB2_C_BVTAB FIELD_VEND_LIST DD03L Table Fields TABNAME
1 WB2_C_BVTAB FIELD_VEND_LIST DD03L Table Fields FIELDNAME
1 WB2_C_BVTAB FIELD_VEND_LIST DD03L Table Fields AS4LOCAL
1 WB2_C_BVTAB FIELD_VEND_LIST DD03L Table Fields AS4VERS
0 WB2_C_BVTAB FIELD_VOLEH DD03L Table Fields TABNAME
0 WB2_C_BVTAB FIELD_VOLEH DD03L Table Fields FIELDNAME
0 WB2_C_BVTAB FIELD_VOLEH DD03L Table Fields AS4LOCAL
0 WB2_C_BVTAB FIELD_VOLEH DD03L Table Fields AS4VERS
1 WB2_C_BVTAB FIELD_VOLUM DD03L Table Fields TABNAME
1 WB2_C_BVTAB FIELD_VOLUM DD03L Table Fields FIELDNAME
1 WB2_C_BVTAB FIELD_VOLUM DD03L Table Fields AS4LOCAL
1 WB2_C_BVTAB FIELD_VOLUM DD03L Table Fields AS4VERS
0 WB2_C_BVTAB FIELD_WAERS DD03L Table Fields TABNAME
0 WB2_C_BVTAB FIELD_WAERS DD03L Table Fields FIELDNAME
0 WB2_C_BVTAB FIELD_WAERS DD03L Table Fields AS4LOCAL
0 WB2_C_BVTAB FIELD_WAERS DD03L Table Fields AS4VERS