R_ConditionContract

Condition Contract | view: RCNDNCNTR | TRAN | Extraction: Not supported | Component: Chargeback
Tables used: WCOCOH
Column Name Description
ConditionContract Condition Contract
Column Name Description
Column Name Description
Column Name Description
CreationDate Date of Condition Contract Creation
CreationTime Time of Condition Contract Creation
LastChangedDate Date of Last Condition Contract Change
LastChangeTime Time of Last Condition Contract Change
CndnContrValidFrom Valid From
CndnContrValidTo Valid To
ExchangeRateDate Conversion Date
Column Name Description
CndnContrActvtnStatus Condition Contract Activation Status Show values
CndnContrSuplrSettlmtCat Settlement Type Supplier Show values
CndnContrCustSettlmtCat Settlement Type Customer Show values
CndnContrPurposeCat Condition Contract Purpose Show values
CndnContrSourceDocCat External Reference Document Category Show values
AccrualUpdateIsRequired Accruals Update Required Show values
CndnContrPrcgDetnRlvnceCat CC Determination Relevance in Pricing (Condition Contract) Show values
CndnContrPartnerCat Type of Business Partner for Condition Contract Show values
CndnContrProcessCategory Process Category of a Condition Contract Show values
CndnContrSettlmtType Condition Contract Settlement Type Show values
Column Name Description Domain name
DocumentReferenceID Condition Contract: Reference WCB_REFERENCE
CndnContrAssgmtRef Condition Contract: Assignment WCB_ASSIGNMENT
CndnContrExternalPartner Condition Contract: External Partner WCB_EXTERNAL_PARTNER
CreatedByUser Condition Contract Created By USNAM
CreationTimeZone Time Zone SYCHAR06
CreationUTCDateTime UTC Time Stamp of Condition Contract Creation TZNTSTMPS
LastChangedByUser Condition Contract Last Changed By USNAM
LastChangeUTCDateTime UTC Time Stamp of Last Condition Contract Change TZNTSTMPS
PaymentTerms Terms of payment key ZTERM
CashDiscount1Days First Payment in Days ZBDXT
CashDiscount1Percent Discount for First Payment in % PRZ23
CashDiscount2Days Second Payment in Days ZBDXT
CashDiscount2Percent Discount for Second Payment in % PRZ23
NetPaymentDays Cash Discount Days ZBDXT
PaymentMethod Payment Method ZLSCH
CndnContrUUID Condition Contract GUID WCB_GUID
ExternalDocumentReferenceID External Document Identifier WCB_EXTERNAL_NUMBER
ExchangeRate Exchange Rate (no Conversion)
PrecedingConditionContract Predecessor Condition Contract WCB_COCO_NUM
CndnContrSourceDoc External Reference WCB_EXTERNAL_NUMBER2
CndnContrSourceDocItem External Reference Item WCB_EXTERNAL_REF_ITEM
CndnContrSourceUUID External Condition Contract GUID WCB_GUID
SettlmtPartTxRegnNmbr VAT Registration Number STCEG
Master Data Relations Join Conditions
Calendar for Accruals Deferral Settlement R_CONDITIONCONTRACT.ACCRUALCLEARINGSETTLMTCALENDAR == TFACD.IDENT
Amount Fields Group
  • Client
  • Amount Fields Group
Business Volume Table Group
  • Client
  • Business Volume Table Group
Group of Split Criteria Used for Total Amounts as per Split
  • Client
  • Group of Split Criteria Used for Total Amounts as per Split
Condition Contract Category
  • Client
  • Condition Contract Category
Currency of Condition Contract
  • Client
  • Currency of Condition Contract
  • R_CONDITIONCONTRACT.MANDT == TCURC.MANDT
  • R_CONDITIONCONTRACT.CNDNCONTRCURRENCY == TCURC.WAERS
Calendar for Condition Contract Extension R_CONDITIONCONTRACT.CNDNCONTREXTENSIONCALENDAR == TFACD.IDENT
Settlement Points Unit
  • Client
  • Settlement Points Unit
  • R_CONDITIONCONTRACT.MANDT == T006.MANDT
  • R_CONDITIONCONTRACT.CNDNCONTRPOINTSQTYUNIT == T006.MSEHI
Condition Contract Process Variant
  • Client
  • Condition Contract Process Variant
Condition Contract Type
  • Client
  • Condition Contract Type
Settlement Unit of Measure
  • Client
  • Settlement Unit of Measure
  • R_CONDITIONCONTRACT.MANDT == T006.MANDT
  • R_CONDITIONCONTRACT.CNDNCONTRUNIT == T006.MSEHI
Settlement Unit of Volume
  • Client
  • Settlement Unit of Volume
  • R_CONDITIONCONTRACT.MANDT == T006.MANDT
  • R_CONDITIONCONTRACT.CNDNCONTRVOLUMEUNIT == T006.MSEHI
Settlement Unit of Weight
  • Client
  • Settlement Unit of Weight
  • R_CONDITIONCONTRACT.MANDT == T006.MANDT
  • R_CONDITIONCONTRACT.CNDNCONTRWEIGHTUNIT == T006.MSEHI
Company Code
  • Client
  • Company Code
  • R_CONDITIONCONTRACT.MANDT == T001.MANDT
  • R_CONDITIONCONTRACT.COMPANYCODE == T001.BUKRS
Customer as Partner of a Condition Contract
  • Client
  • Customer as Partner of a Condition Contract
  • R_CONDITIONCONTRACT.MANDT == KNA1.MANDT
  • R_CONDITIONCONTRACT.CUSTOMER == KNA1.KUNNR
Calendar for Delta Accruals Settlement R_CONDITIONCONTRACT.DELTAACCRUALSETTLMTCALENDAR == TFACD.IDENT
Calendar for Delta Settlement R_CONDITIONCONTRACT.DELTASETTLMTCALENDAR == TFACD.IDENT
Distribution Channel
  • Client
  • Distribution Channel
  • R_CONDITIONCONTRACT.MANDT == TVTW.MANDT
  • R_CONDITIONCONTRACT.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • R_CONDITIONCONTRACT.MANDT == TSPA.MANDT
  • R_CONDITIONCONTRACT.DIVISION == TSPA.SPART
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • R_CONDITIONCONTRACT.MANDT == TCURV.MANDT
  • R_CONDITIONCONTRACT.EXCHANGERATETYPE == TCURV.KURST
Calendar for Final Settlement R_CONDITIONCONTRACT.FINALSETTLMTCALENDAR == TFACD.IDENT
Calendar for Partial Settlement R_CONDITIONCONTRACT.PARTIALSETTLMTCALENDAR == TFACD.IDENT
Prior Supplier
  • Client
  • Prior Supplier
  • R_CONDITIONCONTRACT.MANDT == LFA1.MANDT
  • R_CONDITIONCONTRACT.PRIORSUPPLIER == LFA1.LIFNR
Purchasing Group
  • Client
  • Purchasing Group
  • R_CONDITIONCONTRACT.MANDT == T024.MANDT
  • R_CONDITIONCONTRACT.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • R_CONDITIONCONTRACT.MANDT == T024E.MANDT
  • R_CONDITIONCONTRACT.PURCHASINGORGANIZATION == T024E.EKORG
Sales group
  • Client
  • Sales office
  • Sales group
  • R_CONDITIONCONTRACT.MANDT == TVBVK.MANDT
  • R_CONDITIONCONTRACT.SALESOFFICE == TVBVK.VKBUR
  • R_CONDITIONCONTRACT.SALESGROUP == TVBVK.VKGRP
Sales office
  • Client
  • Sales office
  • R_CONDITIONCONTRACT.MANDT == TVBUR.MANDT
  • R_CONDITIONCONTRACT.SALESOFFICE == TVBUR.VKBUR
Sales Organization
  • Client
  • Sales Organization
  • R_CONDITIONCONTRACT.MANDT == TVKO.MANDT
  • R_CONDITIONCONTRACT.SALESORGANIZATION == TVKO.VKORG
Partner Tax Country/Region
  • Client
  • Partner Tax Country/Region
  • R_CONDITIONCONTRACT.MANDT == T005.MANDT
  • R_CONDITIONCONTRACT.SETTLMTPARTTXREGNCNTRY == T005.LAND1
Settlement Product
  • Client
  • Settlement Product
  • R_CONDITIONCONTRACT.MANDT == MARA.MANDT
  • R_CONDITIONCONTRACT.SETTLMTPRODUCT == MARA.MATNR
Supplier as Partner of a Condition Contract
  • Client
  • Supplier as Partner of a Condition Contract
  • R_CONDITIONCONTRACT.MANDT == LFA1.MANDT
  • R_CONDITIONCONTRACT.SUPPLIER == LFA1.LIFNR
Tax Reporting Country/Region
  • Client
  • Tax Reporting Country/Region
  • R_CONDITIONCONTRACT.MANDT == T005.MANDT
  • R_CONDITIONCONTRACT.TAXCOUNTRY == T005.LAND1