C_CndnContrSettlmtAmtQry

CndnContr Amount Statement Query | view: CCOCOAMTSMTQRY | Extraction: Not supported | Component: Chargeback
Column Name Description
ConditionContract FK Condition Contract
SettlmtDate Settlement Date
SettlmtDateSequentialID Settlement Date - Sequential ID
SettlmtDocCurrency 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 Settlement Net Amount in Document Currency
SettlmtItemGrossAmount Settlement Gross Amount in Document Currency
SettlmtItmElgblAmtForCshDisc Settlement Amount Eligible for Cash Discount in Doc. Crcy.
SettlmtEffctvItemAmount Settlement Effective Value in Document Currency
SettlmtItemTaxAmount Settlement Tax Amount in Document Currency
SettlmtBusVolAmt Settlement Business Volume Amount
SettlmtAccrRvslAmt Settlement Accruals Reversal Amount
SettlmtPrtlSettlmtRvslAmt Partial Settlement Reversal
💲 Display Currency (DisplayCurrency):
SettlmtItemNetAmtInDC Settlement Net Amount in Document Currency
SettlmtItemGrossAmtInDC Settlement Gross Amount in Display Currency
SettlmtItmElgblAmtCshDiscInDC Settlement Amount Eligible for Cash Discount in Disp. Crcy.
SettlmtEffctvItmAmtInDC Settlement Effective Value in Display Currency
SettlmtItemTaxAmtInDC Settlement Tax Amount in Display Currency
SettlmtBusVolAmtInDC Settlement Business Volume Amount in Display Currency
SettlmtAccrRvslAmtInDC Settlement Accruals Reversal Amount in Display Currency
SettlmtPrtlSettlmtRvslAmtInDC Partial Settlement Reversal Amount in Display Currency
Column Name Description
Column Name Description
SettlmtDate Settlement Date
Column Name Description
SettlmtDateCat Rebates: Settlement Date Type Show values
Column Name Description Domain name
SettlmtDocType Settlement Document Type WFART
SuplrSettlmtCompanyCode Supplier Company Code BUKRS
CustSettlmtCompanyCode Customer Company Code BUKRS
PurchasingOrganization Purchasing organization EKORG
PurchasingGroup Purchasing Group EKGRP
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
Division Division SPART
DocumentReferenceID Condition Contract: Reference WCB_REFERENCE
NumberOfSettlementDocuments Rebates: Number of Settlement Documents WB2_NUMBER_SETTL_DOCS
CustomerFullName Customer Full Name TEXT220
SupplierFullName Supplier Full Name TEXT220
CndnContrSettlmtDteYrMnth Month for Settlement
CndnContrSettlmtDteYrQtr Quarter for Settlement
CndnContrSettlmtDteYrWk Week for Settlement
CndnContrSettlmtDteYr Year for Settlement
SettlmtDateCatName Rebates: Settlement Date Type Description
Master Data Relations Join Conditions
Condition Contract Category
  • Client
  • Condition Contract Category
  • C_CNDNCONTRSETTLMTAMTQRY.MANDT == TWCBCATEGORY.CLIENT
  • C_CNDNCONTRSETTLMTAMTQRY.CNDNCONTRCLASSFCTNTYPE == TWCBCATEGORY.CATEGORY
Distribution Channel in a Condition Contract
  • Client
  • Distribution Channel in a Condition Contract
  • C_CNDNCONTRSETTLMTAMTQRY.MANDT == TVTW.MANDT
  • C_CNDNCONTRSETTLMTAMTQRY.CNDNCONTRDISTRCHNL == TVTW.VTWEG
Division in a Condition Contract
  • Client
  • Division in a Condition Contract
  • C_CNDNCONTRSETTLMTAMTQRY.MANDT == TSPA.MANDT
  • C_CNDNCONTRSETTLMTAMTQRY.CNDNCONTRDIVN == TSPA.SPART
Purchasing Group in a Condition Contract
  • Client
  • Purchasing Group in a Condition Contract
  • C_CNDNCONTRSETTLMTAMTQRY.MANDT == T024.MANDT
  • C_CNDNCONTRSETTLMTAMTQRY.CNDNCONTRPURGGROUP == T024.EKGRP
Purchasing Organization in a Condition Contract
  • Client
  • Purchasing Organization in a Condition Contract
  • C_CNDNCONTRSETTLMTAMTQRY.MANDT == T024E.MANDT
  • C_CNDNCONTRSETTLMTAMTQRY.CNDNCONTRPURGORG == T024E.EKORG
Sales Organization in a Condition Contract
  • Client
  • Sales Organization in a Condition Contract
  • C_CNDNCONTRSETTLMTAMTQRY.MANDT == TVKO.MANDT
  • C_CNDNCONTRSETTLMTAMTQRY.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
  • C_CNDNCONTRSETTLMTAMTQRY.MANDT == KNA1.MANDT
  • C_CNDNCONTRSETTLMTAMTQRY.CUSTOMER == KNA1.KUNNR
Supplier as Partner of a Condition Contract
  • Client
  • Supplier as Partner of a Condition Contract
  • C_CNDNCONTRSETTLMTAMTQRY.MANDT == LFA1.MANDT
  • C_CNDNCONTRSETTLMTAMTQRY.SUPPLIER == LFA1.LIFNR