R_CndnContrSettlmtAmtCube

Condition Contract Amount Statement Cube | view: RCCSAMTSMTCUBE | TRAN | Extraction: Not supported | Component: Chargeback
Tables used: SCAL_TT_DATE, WBRK, WBRP, WCOCOH, WBRF, KNA1, LFA1, WB2_D_SETTL_CAL, WB2_C_CCS
Column Name Description
ConditionContract FK Condition Contract
SettlmtDate Settlement Date
SettlmtDateSequentialID Settlement Date - Sequential ID
SettlmtDocCurrency FK Currency of Settlement Document
Supplier FK Supplier as Partner of a Condition Contract
Customer FK Customer as Partner of a Condition Contract
Column Name Description
💲 Currency of Settlement Document (SettlmtDocCurrency):
SettlmtItemNetAmount null
SettlmtItemGrossAmount null
SettlmtItmElgblAmtForCshDisc null
SettlmtEffctvItemAmount null
SettlmtItemTaxAmount null
SettlmtBusVolAmt null
SettlmtAccrRvslAmt null
SettlmtPrtlSettlmtRvslAmt null
Column Name Description
Column Name Description
SettlmtDate Settlement Date
ExchangeRateDate Exchange Rate Date
Column Name Description
SettlmtDateCat Rebates: Settlement Date Type Show values
Column Name Description Domain name
CustSettlmtCompanyCode Customer Company Code BUKRS
DocumentReferenceID Condition Contract: Reference WCB_REFERENCE
NumberOfSettlementDocuments null
CustomerFullName Customer Full Name TEXT220
CustomerAuthznGrp Authorization Group BRGRU
SupplierFullName Supplier Full Name TEXT220
SupplierAuthznGrp Authorization Group BRGRU
SettlmtDateCatName Rebates: Settlement Date Type Description
CndnContrSettlmtDteYrMnth Month for Settlement
CndnContrSettlmtDteYrQtr Quarter for Settlement
CndnContrSettlmtDteYrWk Week for Settlement
CndnContrSettlmtDteYr Year for Settlement
Master Data Relations Join Conditions
Condition Contract Category
  • Client
  • Condition Contract Category
  • R_CNDNCONTRSETTLMTAMTCUBE.MANDT == TWCBCATEGORY.CLIENT
  • R_CNDNCONTRSETTLMTAMTCUBE.CNDNCONTRCLASSFCTNTYPE == TWCBCATEGORY.CATEGORY
Distribution Channel in a Condition Contract
  • Client
  • Distribution Channel
  • Distribution Channel in a Condition Contract
  • R_CNDNCONTRSETTLMTAMTCUBE.MANDT == TVTW.MANDT
  • R_CNDNCONTRSETTLMTAMTCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • R_CNDNCONTRSETTLMTAMTCUBE.CNDNCONTRDISTRCHNL == TVTW.VTWEG
Division in a Condition Contract
  • Client
  • Division
  • Division in a Condition Contract
  • R_CNDNCONTRSETTLMTAMTCUBE.MANDT == TSPA.MANDT
  • R_CNDNCONTRSETTLMTAMTCUBE.DIVISION == TSPA.SPART
  • R_CNDNCONTRSETTLMTAMTCUBE.CNDNCONTRDIVN == TSPA.SPART
Purchasing Group in a Condition Contract
  • Client
  • Purchasing Group in a Condition Contract
  • Purchasing Group
  • R_CNDNCONTRSETTLMTAMTCUBE.MANDT == T024.MANDT
  • R_CNDNCONTRSETTLMTAMTCUBE.CNDNCONTRPURGGROUP == T024.EKGRP
  • R_CNDNCONTRSETTLMTAMTCUBE.PURCHASINGGROUP == T024.EKGRP
Purchasing Organization in a Condition Contract
  • Client
  • Purchasing organization
  • Purchasing Organization in a Condition Contract
  • R_CNDNCONTRSETTLMTAMTCUBE.MANDT == T024E.MANDT
  • R_CNDNCONTRSETTLMTAMTCUBE.PURCHASINGORGANIZATION == T024E.EKORG
  • R_CNDNCONTRSETTLMTAMTCUBE.CNDNCONTRPURGORG == T024E.EKORG
Sales Organization in a Condition Contract
  • Client
  • Sales Organization
  • Sales Organization in a Condition Contract
  • R_CNDNCONTRSETTLMTAMTCUBE.MANDT == TVKO.MANDT
  • R_CNDNCONTRSETTLMTAMTCUBE.SALESORGANIZATION == TVKO.VKORG
  • R_CNDNCONTRSETTLMTAMTCUBE.CNDNCONTRSLSORG == TVKO.VKORG
Condition Contract Type
  • Client
  • Condition Contract Type
Customer as Partner of a Condition Contract
  • Client
  • Customer as Partner of a Condition Contract
  • R_CNDNCONTRSETTLMTAMTCUBE.MANDT == KNA1.MANDT
  • R_CNDNCONTRSETTLMTAMTCUBE.CUSTOMER == KNA1.KUNNR
Distribution Channel
  • Client
  • Distribution Channel
  • Distribution Channel in a Condition Contract
  • R_CNDNCONTRSETTLMTAMTCUBE.MANDT == TVTW.MANDT
  • R_CNDNCONTRSETTLMTAMTCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • R_CNDNCONTRSETTLMTAMTCUBE.CNDNCONTRDISTRCHNL == TVTW.VTWEG
Division
  • Client
  • Division
  • Division in a Condition Contract
  • R_CNDNCONTRSETTLMTAMTCUBE.MANDT == TSPA.MANDT
  • R_CNDNCONTRSETTLMTAMTCUBE.DIVISION == TSPA.SPART
  • R_CNDNCONTRSETTLMTAMTCUBE.CNDNCONTRDIVN == TSPA.SPART
Purchasing Group
  • Client
  • Purchasing Group in a Condition Contract
  • Purchasing Group
  • R_CNDNCONTRSETTLMTAMTCUBE.MANDT == T024.MANDT
  • R_CNDNCONTRSETTLMTAMTCUBE.CNDNCONTRPURGGROUP == T024.EKGRP
  • R_CNDNCONTRSETTLMTAMTCUBE.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • Purchasing Organization in a Condition Contract
  • R_CNDNCONTRSETTLMTAMTCUBE.MANDT == T024E.MANDT
  • R_CNDNCONTRSETTLMTAMTCUBE.PURCHASINGORGANIZATION == T024E.EKORG
  • R_CNDNCONTRSETTLMTAMTCUBE.CNDNCONTRPURGORG == T024E.EKORG
Sales Organization
  • Client
  • Sales Organization
  • Sales Organization in a Condition Contract
  • R_CNDNCONTRSETTLMTAMTCUBE.MANDT == TVKO.MANDT
  • R_CNDNCONTRSETTLMTAMTCUBE.SALESORGANIZATION == TVKO.VKORG
  • R_CNDNCONTRSETTLMTAMTCUBE.CNDNCONTRSLSORG == TVKO.VKORG
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • R_CNDNCONTRSETTLMTAMTCUBE.MANDT == TCURC.MANDT
  • R_CNDNCONTRSETTLMTAMTCUBE.SETTLMTDOCCURRENCY == TCURC.WAERS
Settlement Document Type
  • Client
  • Settlement Document Type
  • R_CNDNCONTRSETTLMTAMTCUBE.MANDT == TMFK.MANDT
  • R_CNDNCONTRSETTLMTAMTCUBE.SETTLMTDOCTYPE == TMFK.LFART
Supplier Company Code
  • Client
  • Supplier Company Code
  • R_CNDNCONTRSETTLMTAMTCUBE.MANDT == T001.MANDT
  • R_CNDNCONTRSETTLMTAMTCUBE.SUPLRSETTLMTCOMPANYCODE == T001.BUKRS
Supplier as Partner of a Condition Contract
  • Client
  • Supplier as Partner of a Condition Contract
  • R_CNDNCONTRSETTLMTAMTCUBE.MANDT == LFA1.MANDT
  • R_CNDNCONTRSETTLMTAMTCUBE.SUPPLIER == LFA1.LIFNR