C_TrdCndnContrChkBook

TMA Condition Contract Checkbook | view: CTRDCCCKF | Extraction: Not supported | Component: Trade Claims Management on S/4HANA
Tables used: CRM_JEST, WBRK, WBRP, WCOCOH, T001, TKA02, TVKO, FINSC_PERIOD
Column Name Description
ConditionContract Condition Contract
SettlmtDoc Document Number
Product FK Product Number
Column Name Description
💲 Trade Claim Display Currency (DisplayCurrency):
TrdClmTotalAccrualAmtInDspCrcy Trade Claim Total Accrual Amount
TrdClmAccrBalAmtInDspCrcy Trade Claim Accrual Balance Amount
TrdClmNetAccrualAmtInDspCrcy Trade Claim Net Accrual Amount
TrdClmSettledAmtInDspCrcy Trade Claim Settled Amount
TrdClmExpnAmtInDspCrcy Trade Claim Expensed Amount
TrdClmPndgSettlmtAmtInDspCrcy Trade Claim Pending Settlement
TrdClmUnexpdExpnAmtInDspCrcy Trade Claim Unexpected Expense Amount
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Document Date in Settlement Management Document
CndnContrValidFrom Valid From
CndnContrValidTo Valid To
CreationDate Date of Condition Contract Creation
LastChangedDate Date of Last Condition Contract Change
ExchangeRateDate Exchange Rate Date
Column Name Description
CndnContrIsInactive Condition Contract Activation Status Show values
CndnContrSourceDocCat External Reference Document Category Show values
CndnContrPurposeCat Condition Contract Purpose Show values
CndnContrSettlmtIsLocked Settlement Lock Status Show values
CndnContrCustSettlmtCat Settlement Type Customer Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
FiscalYear Fiscal Year GJAHR
CndnContrExternalPartner Condition Contract: External Partner WCB_EXTERNAL_PARTNER
CndnContrIsInactiveCriticality Criticality of the Condition Contract Activation Status
CndnContrUUID Condition Contract GUID WCB_GUID
CndnContrMainSystemStatus Main Status CRM_J_STATUS
ExternalDocumentReferenceID External Document Identifier WCB_EXTERNAL_NUMBER
DocumentReferenceID Condition Contract: Reference WCB_REFERENCE
AssignmentReference Condition Contract: Assignment WCB_ASSIGNMENT
CndnContrSourceDoc External Reference WCB_EXTERNAL_NUMBER2
CreatedByUser Condition Contract Created By USNAM
LastChangedByUser Condition Contract Last Changed By USNAM
PaymentMethod Payment Method ZLSCH
CndnContrSettlmtIsLockedName Short Text for Fixed Values DDTEXT
FiscalYearPeriodCompoundText Trade Claim Fiscal Year Period TMA_FISCAL_YEAR_PERIOD
Master Data Relations Join Conditions
Amount Fields Group
  • Client
  • Amount Fields Group
Condition Contract Category
  • Client
  • Condition Contract Category
  • C_TRDCNDNCONTRCHKBOOK.MANDT == TWCBCATEGORY.CLIENT
  • C_TRDCNDNCONTRCHKBOOK.CNDNCONTRCLASSFCTNTYPE == TWCBCATEGORY.CATEGORY
Currency of Condition Contract
  • Client
  • Currency of Condition Contract
  • C_TRDCNDNCONTRCHKBOOK.MANDT == TCURC.MANDT
  • C_TRDCNDNCONTRCHKBOOK.CNDNCONTRCURRENCY == TCURC.WAERS
Calendar for Condition Contract Extension C_TRDCNDNCONTRCHKBOOK.CNDNCONTREXTENSIONCALENDAR == TFACD.IDENT
Condition Contract Type
  • Client
  • Condition Contract Type
Company Code
  • Client
  • Company Code
  • C_TRDCNDNCONTRCHKBOOK.MANDT == T001.MANDT
  • C_TRDCNDNCONTRCHKBOOK.COMPANYCODE == T001.BUKRS
Customer as Partner of a Condition Contract
  • Client
  • Customer as Partner of a Condition Contract
  • C_TRDCNDNCONTRCHKBOOK.MANDT == KNA1.MANDT
  • C_TRDCNDNCONTRCHKBOOK.CUSTOMER == KNA1.KUNNR
Distribution Channel
  • Client
  • Distribution Channel
  • C_TRDCNDNCONTRCHKBOOK.MANDT == TVTW.MANDT
  • C_TRDCNDNCONTRCHKBOOK.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_TRDCNDNCONTRCHKBOOK.MANDT == TSPA.MANDT
  • C_TRDCNDNCONTRCHKBOOK.DIVISION == TSPA.SPART
Product Number
  • Product Number
  • Client
  • C_TRDCNDNCONTRCHKBOOK.PRODUCT == MARA.MATNR
  • C_TRDCNDNCONTRCHKBOOK.MANDT == MARA.MANDT
Sales group
  • Client
  • Sales group
  • Sales office
  • C_TRDCNDNCONTRCHKBOOK.MANDT == TVBVK.MANDT
  • C_TRDCNDNCONTRCHKBOOK.SALESGROUP == TVBVK.VKGRP
  • C_TRDCNDNCONTRCHKBOOK.SALESOFFICE == TVBVK.VKBUR
Sales office
  • Client
  • Sales office
  • C_TRDCNDNCONTRCHKBOOK.MANDT == TVBUR.MANDT
  • C_TRDCNDNCONTRCHKBOOK.SALESOFFICE == TVBUR.VKBUR
Sales Organization
  • Client
  • Sales Organization
  • C_TRDCNDNCONTRCHKBOOK.MANDT == TVKO.MANDT
  • C_TRDCNDNCONTRCHKBOOK.SALESORGANIZATION == TVKO.VKORG
Settlement Product
  • Client
  • Settlement Product
  • C_TRDCNDNCONTRCHKBOOK.MANDT == MARA.MANDT
  • C_TRDCNDNCONTRCHKBOOK.SETTLMTPRODUCT == MARA.MATNR