WB2_D_BVB_SETTL

Snapshot of BV Selection Criteria Used in CC Settlement | #transactional | Component: Chargeback
Column Name Description
MANDT Client
NUM FK Condition Contract
SETTL_DATE Rebates: Settlement Date
GUID Condition Contract: Business volume base item GUID
Column Name Description
Column Name Description
Column Name Description
SETTL_DATE Rebates: Settlement Date
VALID_FROM Valid from
VALID_TO Valid to
_DATAAGING Data Filter Value for Data Aging
Column Name Description
INCL_EXCL Status Including / Excluding Show values
Column Name Description Domain name
TIMESTAMP Timestamp TIMESTAMP
OFFERID Offer ID for Promotion WPM_OFFERID
WGHIE Material group hierarchy KLASSE
CAMPAIGN Campaign ID CMPGN_ID_R3
EKKOL Condition Group with Supplier CHAR4
SERVICE_DOC_ID Service Document ID CRM_OBJECT_ID
SERVICE_DOC_ITEM_ID Service Document Item ID FCO_SRVDOC_ITEM_ID
DUMMY Dummy function in length 1 DUMMY
Master Data Relations Join Conditions
Promotion
  • Promotion
  • Client
  • WB2_D_BVB_SETTL.AKTNR == WAKH.AKTNR
  • WB2_D_BVB_SETTL.MANDT == WAKH.MANDT
Sales Document Reason
  • WB2_D_BVB_SETTL.MANDT == TVAU.MANDT
  • WB2_D_BVB_SETTL.AUGRU == TVAU.AUGRU
Document Type
  • Document Type
  • Client
  • WB2_D_BVB_SETTL.BLART == T003.BLART
  • WB2_D_BVB_SETTL.MANDT == T003.MANDT
Sales Volume Rebate Group
  • Sales Volume Rebate Group
  • Client
  • WB2_D_BVB_SETTL.BONUS == TVBO.BONUS
  • WB2_D_BVB_SETTL.MANDT == TVBO.MANDT
Company Code
  • WB2_D_BVB_SETTL.MANDT == T001.MANDT
  • WB2_D_BVB_SETTL.BUKRS == T001.BUKRS
Condition Contract Process Variant
Purchasing Group
  • Purchasing Group
  • Client
  • WB2_D_BVB_SETTL.EKGRP == T024.EKGRP
  • WB2_D_BVB_SETTL.MANDT == T024.MANDT
Purchasing organization
  • WB2_D_BVB_SETTL.MANDT == T024E.MANDT
  • WB2_D_BVB_SETTL.EKORG == T024E.EKORG
Field Combination for Business Volume Selection
Customer Group
  • Customer Group
  • Client
  • WB2_D_BVB_SETTL.KDGRP == T151.KDGRP
  • WB2_D_BVB_SETTL.MANDT == T151.MANDT
Material Price Group
  • WB2_D_BVB_SETTL.MANDT == T178.MANDT
  • WB2_D_BVB_SETTL.KONDM == T178.KONDM
Customer Hierarchy
  • WB2_D_BVB_SETTL.MANDT == KNA1.MANDT
  • WB2_D_BVB_SETTL.KUNHIER == KNA1.KUNNR
Customer Number
  • WB2_D_BVB_SETTL.MANDT == KNA1.MANDT
  • WB2_D_BVB_SETTL.KUNNR == KNA1.KUNNR
Payer
  • WB2_D_BVB_SETTL.MANDT == KNA1.MANDT
  • WB2_D_BVB_SETTL.KUNRG == KNA1.KUNNR
Ship-to Party
  • WB2_D_BVB_SETTL.MANDT == KNA1.MANDT
  • WB2_D_BVB_SETTL.KUNWE == KNA1.KUNNR
Customer Group 1
  • WB2_D_BVB_SETTL.MANDT == TVV1.MANDT
  • WB2_D_BVB_SETTL.KVGR1 == TVV1.KVGR1
Customer Group 2
  • WB2_D_BVB_SETTL.MANDT == TVV2.MANDT
  • WB2_D_BVB_SETTL.KVGR2 == TVV2.KVGR2
Customer Group 3
  • Customer Group 3
  • Client
  • WB2_D_BVB_SETTL.KVGR3 == TVV3.KVGR3
  • WB2_D_BVB_SETTL.MANDT == TVV3.MANDT
Customer Group 4
  • WB2_D_BVB_SETTL.MANDT == TVV4.MANDT
  • WB2_D_BVB_SETTL.KVGR4 == TVV4.KVGR4
Customer Group 5
  • Customer Group 5
  • Client
  • WB2_D_BVB_SETTL.KVGR5 == TVV5.KVGR5
  • WB2_D_BVB_SETTL.MANDT == TVV5.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • WB2_D_BVB_SETTL.LAND1 == T005.LAND1
  • WB2_D_BVB_SETTL.MANDT == T005.MANDT
Account Number of Supplier
  • WB2_D_BVB_SETTL.MANDT == LFA1.MANDT
  • WB2_D_BVB_SETTL.LIFNR == LFA1.LIFNR
Commission Recipient
  • WB2_D_BVB_SETTL.MANDT == LFA1.MANDT
  • WB2_D_BVB_SETTL.LIFNR_COMMISSION == LFA1.LIFNR
Royalties Recipient
  • WB2_D_BVB_SETTL.MANDT == LFA1.MANDT
  • WB2_D_BVB_SETTL.LIFNR_ROYALTIES == LFA1.LIFNR
Material Group
  • WB2_D_BVB_SETTL.MANDT == T023.MANDT
  • WB2_D_BVB_SETTL.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • WB2_D_BVB_SETTL.MATNR == MARA.MATNR
  • WB2_D_BVB_SETTL.MANDT == MARA.MANDT
Manufacturer number
  • WB2_D_BVB_SETTL.MANDT == LFA1.MANDT
  • WB2_D_BVB_SETTL.MFRNR == LFA1.LIFNR
Material type
  • WB2_D_BVB_SETTL.MANDT == T134.MANDT
  • WB2_D_BVB_SETTL.MTART == T134.MTART
Material Group 1
  • Material Group 1
  • Client
  • WB2_D_BVB_SETTL.MVGR1 == TVM1.MVGR1
  • WB2_D_BVB_SETTL.MANDT == TVM1.MANDT
Material Group 2
  • Material Group 2
  • Client
  • WB2_D_BVB_SETTL.MVGR2 == TVM2.MVGR2
  • WB2_D_BVB_SETTL.MANDT == TVM2.MANDT
Material Group 3
  • WB2_D_BVB_SETTL.MANDT == TVM3.MANDT
  • WB2_D_BVB_SETTL.MVGR3 == TVM3.MVGR3
Material Group 4
  • WB2_D_BVB_SETTL.MANDT == TVM4.MANDT
  • WB2_D_BVB_SETTL.MVGR4 == TVM4.MVGR4
Material Group 5
  • WB2_D_BVB_SETTL.MANDT == TVM5.MANDT
  • WB2_D_BVB_SETTL.MVGR5 == TVM5.MVGR5
Pricing Reference Material
  • Pricing Reference Material
  • Client
  • WB2_D_BVB_SETTL.PMATN == MARA.MATNR
  • WB2_D_BVB_SETTL.MANDT == MARA.MANDT
Product hierarchy
  • Product hierarchy
  • Client
  • WB2_D_BVB_SETTL.PRODH == T179.PRODH
  • WB2_D_BVB_SETTL.MANDT == T179.MANDT
Commission Group
  • Commission Group
  • Client
  • WB2_D_BVB_SETTL.PROVG == TVPR.PROVG
  • WB2_D_BVB_SETTL.MANDT == TVPR.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • WB2_D_BVB_SETTL.MANDT == T005S.MANDT
  • WB2_D_BVB_SETTL.LAND1 == T005S.LAND1
  • WB2_D_BVB_SETTL.REGIO == T005S.BLAND
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • WB2_D_BVB_SETTL.SATNR == MARA.MATNR
  • WB2_D_BVB_SETTL.MANDT == MARA.MANDT
Selection Group
Service Document Type
Division
  • WB2_D_BVB_SETTL.MANDT == TSPA.MANDT
  • WB2_D_BVB_SETTL.SPART == TSPA.SPART
CRM Marketing: Target Group ID
Sales office
  • Sales office
  • Client
  • WB2_D_BVB_SETTL.VKBUR == TVBUR.VKBUR
  • WB2_D_BVB_SETTL.MANDT == TVBUR.MANDT
Sales group
  • WB2_D_BVB_SETTL.MANDT == TVKGR.MANDT
  • WB2_D_BVB_SETTL.VKGRP == TVKGR.VKGRP
Sales Organization
  • WB2_D_BVB_SETTL.MANDT == TVKO.MANDT
  • WB2_D_BVB_SETTL.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • WB2_D_BVB_SETTL.VTWEG == TVTW.VTWEG
  • WB2_D_BVB_SETTL.MANDT == TVTW.MANDT