R_CndnContrSumzdSettlmtItmVals

Summarized Val of CndnContr Settlmt Itms | view: RCCSITMSUM | Extraction: Not supported | Component: Chargeback

Tables used: WBRK, WBRP, WCOCOH, WBRF, WB2_C_CCS

🔑 Keys (21)
💰 Amounts (16)
∑ Quantities
📅 Dates (2)
☰ Categorical (1)
Other (2)
🔗 Relations (18)

Column Name	Description
ConditionContract FK	Preceding Document for Settlement Management Document
PostingPartnerCat	Posting Partner	Show values
SettlmtDate	Settlement Date
SettlmtDateSequentialID	Settlement Date - Sequential ID
SettlmtDocCurrency FK	Currency of Settlement Document
SettlmtDocType FK	Settlement Document Type
SuplrSettlmtCompanyCode FK	Supplier Company Code
CustSettlmtCompanyCode	Customer Company Code
PurchasingOrganization FK	Purchasing organization
PurchasingGroup FK	Purchasing Group
SalesOrganization FK	Sales Organization
DistributionChannel FK	Distribution Channel
Division FK	Division
Supplier FK	Supplier as Partner of a Condition Contract
Customer FK	Customer as Partner of a Condition Contract
CndnContrType FK	Condition Contract Type
CndnContrPurgOrg FK	Purchasing Organization in a Condition Contract
CndnContrPurgGroup FK	Purchasing Group in a Condition Contract
CndnContrSlsOrg FK	Sales Organization in a Condition Contract
CndnContrDistrChnl FK	Distribution Channel in a Condition Contract
CndnContrDivn FK	Division in a Condition Contract

Column Name	Description
💲 Currency of Settlement Document (SettlmtDocCurrency):
SupplierItemNetAmount	null
CustomerItemNetAmount	null
SupplierItemGrossAmount	null
CustomerItemGrossAmount	null
SuplrItmEligibleAmtForCshDisc	null
CustItmEligibleAmtForCshDisc	null
SupplierEffectiveItemAmount	null
CustomerEffectiveItemAmount	null
SupplierItemTaxAmount	null
CustomerItemTaxAmount	null
SuplrAccrRvslAmt	null
CustAccrRvslAmt	null
SuplrPrtlSettlmtRvslAmt	null
CustPrtlSettlmtRvslAmt	null
SuplrBusVolAmt	null
CustBusVolAmt	null

Column Name	Description

Column Name	Description
SettlmtDate	Settlement Date
ExchangeRateDate	Exchange Rate Date

Column Name	Description
PostingPartnerCat	Posting Partner	Show values

Column Name	Description	Domain name
DocumentReferenceID	Condition Contract: Reference	WCB_REFERENCE
NumberOfSettlementDocuments	null

Master Data Relations	Join Conditions
Condition Contract Category Client Condition Contract Category	`R_CNDNCONTRSUMZDSETTLMTITMVALS.MANDT == TWCBCATEGORY.CLIENT` `R_CNDNCONTRSUMZDSETTLMTITMVALS.CNDNCONTRCLASSFCTNTYPE == TWCBCATEGORY.CATEGORY`
Distribution Channel in a Condition Contract Client Distribution Channel Distribution Channel in a Condition Contract	`R_CNDNCONTRSUMZDSETTLMTITMVALS.MANDT == TVTW.MANDT` `R_CNDNCONTRSUMZDSETTLMTITMVALS.DISTRIBUTIONCHANNEL == TVTW.VTWEG` `R_CNDNCONTRSUMZDSETTLMTITMVALS.CNDNCONTRDISTRCHNL == TVTW.VTWEG`
Division in a Condition Contract Client Division in a Condition Contract Division	`R_CNDNCONTRSUMZDSETTLMTITMVALS.MANDT == TSPA.MANDT` `R_CNDNCONTRSUMZDSETTLMTITMVALS.CNDNCONTRDIVN == TSPA.SPART` `R_CNDNCONTRSUMZDSETTLMTITMVALS.DIVISION == TSPA.SPART`
Purchasing Group in a Condition Contract Client Purchasing Group Purchasing Group in a Condition Contract	`R_CNDNCONTRSUMZDSETTLMTITMVALS.MANDT == T024.MANDT` `R_CNDNCONTRSUMZDSETTLMTITMVALS.PURCHASINGGROUP == T024.EKGRP` `R_CNDNCONTRSUMZDSETTLMTITMVALS.CNDNCONTRPURGGROUP == T024.EKGRP`
Purchasing Organization in a Condition Contract Client Purchasing organization Purchasing Organization in a Condition Contract	`R_CNDNCONTRSUMZDSETTLMTITMVALS.MANDT == T024E.MANDT` `R_CNDNCONTRSUMZDSETTLMTITMVALS.PURCHASINGORGANIZATION == T024E.EKORG` `R_CNDNCONTRSUMZDSETTLMTITMVALS.CNDNCONTRPURGORG == T024E.EKORG`
Sales Organization in a Condition Contract Client Sales Organization Sales Organization in a Condition Contract	`R_CNDNCONTRSUMZDSETTLMTITMVALS.MANDT == TVKO.MANDT` `R_CNDNCONTRSUMZDSETTLMTITMVALS.SALESORGANIZATION == TVKO.VKORG` `R_CNDNCONTRSUMZDSETTLMTITMVALS.CNDNCONTRSLSORG == TVKO.VKORG`
Condition Contract Type Client Condition Contract Type	`R_CNDNCONTRSUMZDSETTLMTITMVALS.MANDT == TWCBCONTRTYPE.CLIENT` `R_CNDNCONTRSUMZDSETTLMTITMVALS.CNDNCONTRTYPE == TWCBCONTRTYPE.CONTRACT_TYPE`
Customer as Partner of a Condition Contract Client Customer as Partner of a Condition Contract	`R_CNDNCONTRSUMZDSETTLMTITMVALS.MANDT == KNA1.MANDT` `R_CNDNCONTRSUMZDSETTLMTITMVALS.CUSTOMER == KNA1.KUNNR`
Distribution Channel Client Distribution Channel Distribution Channel in a Condition Contract	`R_CNDNCONTRSUMZDSETTLMTITMVALS.MANDT == TVTW.MANDT` `R_CNDNCONTRSUMZDSETTLMTITMVALS.DISTRIBUTIONCHANNEL == TVTW.VTWEG` `R_CNDNCONTRSUMZDSETTLMTITMVALS.CNDNCONTRDISTRCHNL == TVTW.VTWEG`
Division Division in a Condition Contract Division Client	`R_CNDNCONTRSUMZDSETTLMTITMVALS.CNDNCONTRDIVN == TSPA.SPART` `R_CNDNCONTRSUMZDSETTLMTITMVALS.DIVISION == TSPA.SPART` `R_CNDNCONTRSUMZDSETTLMTITMVALS.MANDT == TSPA.MANDT`
Purchasing Group Purchasing Group Purchasing Group in a Condition Contract Client	`R_CNDNCONTRSUMZDSETTLMTITMVALS.PURCHASINGGROUP == T024.EKGRP` `R_CNDNCONTRSUMZDSETTLMTITMVALS.CNDNCONTRPURGGROUP == T024.EKGRP` `R_CNDNCONTRSUMZDSETTLMTITMVALS.MANDT == T024.MANDT`
Purchasing organization Purchasing organization Purchasing Organization in a Condition Contract Client	`R_CNDNCONTRSUMZDSETTLMTITMVALS.PURCHASINGORGANIZATION == T024E.EKORG` `R_CNDNCONTRSUMZDSETTLMTITMVALS.CNDNCONTRPURGORG == T024E.EKORG` `R_CNDNCONTRSUMZDSETTLMTITMVALS.MANDT == T024E.MANDT`
Sales Organization Client Sales Organization Sales Organization in a Condition Contract	`R_CNDNCONTRSUMZDSETTLMTITMVALS.MANDT == TVKO.MANDT` `R_CNDNCONTRSUMZDSETTLMTITMVALS.SALESORGANIZATION == TVKO.VKORG` `R_CNDNCONTRSUMZDSETTLMTITMVALS.CNDNCONTRSLSORG == TVKO.VKORG`
Currency of Settlement Document Client Currency of Settlement Document	`R_CNDNCONTRSUMZDSETTLMTITMVALS.MANDT == TCURC.MANDT` `R_CNDNCONTRSUMZDSETTLMTITMVALS.SETTLMTDOCCURRENCY == TCURC.WAERS`
Settlement Document Type Settlement Document Type Client	`R_CNDNCONTRSUMZDSETTLMTITMVALS.SETTLMTDOCTYPE == TMFK.LFART` `R_CNDNCONTRSUMZDSETTLMTITMVALS.MANDT == TMFK.MANDT`
Supplier Company Code Supplier Company Code Client	`R_CNDNCONTRSUMZDSETTLMTITMVALS.SUPLRSETTLMTCOMPANYCODE == T001.BUKRS` `R_CNDNCONTRSUMZDSETTLMTITMVALS.MANDT == T001.MANDT`
Supplier as Partner of a Condition Contract Client Supplier as Partner of a Condition Contract	`R_CNDNCONTRSUMZDSETTLMTITMVALS.MANDT == LFA1.MANDT` `R_CNDNCONTRSUMZDSETTLMTITMVALS.SUPPLIER == LFA1.LIFNR`