R_CndnContrSettlmtDocsHasDvtg

Condition Contract Settlement Documents with deviating Data | view: RCOCOSDOCSHAS | TRAN | Extraction: Not supported | Component: Chargeback
Tables used: WBRKWBRPWBRF
Column Name Description
ConditionContract FK Preceding Document for Settlement Management Document
SettlmtDoc FK Subsequent Document Number for Settlement Management Doc.
SettlmtDocItem Document Item
Column Name Description
💲 Currency of Settlement Document (SettlmtDocCurrency):
SupplierItemNetAmount Item Net Amount for Supplier in Document Currency
CustomerItemNetAmount Item Net Amount for Customer in Document Currency
SupplierItemGrossAmount Item Gross Amount for Supplier in Document Currency
CustomerItemGrossAmount Item Gross Amount for Customer in Document Currency
SupplierSubtotal1Amount null
CustomerSubtotal1Amount null
SupplierSubtotal2Amount null
CustomerSubtotal2Amount null
SupplierSubtotal3Amount null
CustomerSubtotal3Amount null
SupplierSubtotal4Amount null
CustomerSubtotal4Amount null
SupplierSubtotal5Amount null
CustomerSubtotal5Amount null
SupplierSubtotal6Amount null
CustomerSubtotal6Amount null
SupplierRebateBasisAmount null
CustomerRebateBasisAmount null
SuplrItmEligibleAmtForCshDisc null
CustItmEligibleAmtForCshDisc null
SupplierEffectiveItemAmount null
CustomerEffectiveItemAmount null
SupplierItemTaxAmount null
CustomerItemTaxAmount null
Column Name Description
Column Name Description
SettlmtDate Settlement Date
ExchangeRateDate Exchange Rate Date
Column Name Description
SettlmtMgmtAcctgTransfSts Posting Status for Transfer to Financial Accounting Show values
SettlmtDocIsCanceled Settlement Document is Reversed Show values
SettlmtDateCat Rebates: Settlement Date Type Show values
PostingPartnerCat Posting Partner Show values
SettlmtItmStatisticalPrpty Statistical Property of Settlement Management Item Show values
Column Name Description Domain name
SettlmtDateSequentialID Settlement Date - Sequential ID WB2_SETTLEMENT_DATE_SEQ_ID
CustSettlmtCompanyCode Customer Company Code BUKRS
Master Data Relations Join Conditions
Distribution Channel
  • Client
  • Distribution Channel
  • R_CNDNCONTRSETTLMTDOCSHASDVTG.MANDT == TVTW.MANDT
  • R_CNDNCONTRSETTLMTDOCSHASDVTG.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • R_CNDNCONTRSETTLMTDOCSHASDVTG.MANDT == TSPA.MANDT
  • R_CNDNCONTRSETTLMTDOCSHASDVTG.DIVISION == TSPA.SPART
Purchasing Group
  • Client
  • Purchasing Group
  • R_CNDNCONTRSETTLMTDOCSHASDVTG.MANDT == T024.MANDT
  • R_CNDNCONTRSETTLMTDOCSHASDVTG.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • R_CNDNCONTRSETTLMTDOCSHASDVTG.MANDT == T024E.MANDT
  • R_CNDNCONTRSETTLMTDOCSHASDVTG.PURCHASINGORGANIZATION == T024E.EKORG
Sales Organization
  • Client
  • Sales Organization
  • R_CNDNCONTRSETTLMTDOCSHASDVTG.MANDT == TVKO.MANDT
  • R_CNDNCONTRSETTLMTDOCSHASDVTG.SALESORGANIZATION == TVKO.VKORG
Currency of Settlement Document
  • Client
  • Currency of Settlement Document
  • R_CNDNCONTRSETTLMTDOCSHASDVTG.MANDT == TCURC.MANDT
  • R_CNDNCONTRSETTLMTDOCSHASDVTG.SETTLMTDOCCURRENCY == TCURC.WAERS
Settlement Document Type
  • Client
  • Settlement Document Type
  • R_CNDNCONTRSETTLMTDOCSHASDVTG.MANDT == TMFK.MANDT
  • R_CNDNCONTRSETTLMTDOCSHASDVTG.SETTLMTDOCTYPE == TMFK.LFART
Supplier Company Code
  • Client
  • Supplier Company Code
  • R_CNDNCONTRSETTLMTDOCSHASDVTG.MANDT == T001.MANDT
  • R_CNDNCONTRSETTLMTDOCSHASDVTG.SUPLRSETTLMTCOMPANYCODE == T001.BUKRS