C_MngCustCndnContr

Monitor Customer Condition Contracts | view: CWCBMNGCUSTCONTR | Extraction: Not supported | Component: Chargeback
Tables used: CRM_JEST, WCOCOH, MARA, TWCBCATEGORY, TWCBCATEGORYT, WCB_C_PROC_VAR, WCB_C_PROC_VART, TWCBCONTRTYPET, T001, TKA02, KNA1, TVTW, TVTWT, TSPA, TSPAT, MARA, MAKT, TVKO, TVKOT, TJ02, TJ02T, USR21, TWCBCONTRTYPE
Column Name Description
ConditionContract Condition Contract
Column Name Description
Column Name Description
Column Name Description
CndnContrValidFrom Valid From
CndnContrValidTo Valid To
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
Column Name Description
CndnContrIsInactive Condition Contract Activation Status Show values
CndnContrPurposeCat Condition Contract Purpose Show values
CndnContrSourceDocCat External Reference Document Category Show values
AccrualUpdateIsRequired Accruals Update Required Show values
CndnContrSettlmtIsLocked Settlement Lock Status Show values
Column Name Description Domain name
CndnContrTypeDesc Description WCB_TEXT
CustomerName Name of Customer TEXT80
DocumentReferenceID Condition Contract: Reference WCB_REFERENCE
AssignmentReference Condition Contract: Assignment WCB_ASSIGNMENT
CndnContrAssgmtRef Condition Contract: Assignment WCB_ASSIGNMENT
CndnContrExternalPartner Condition Contract: External Partner WCB_EXTERNAL_PARTNER
CreatedByUser Condition Contract Created By USNAM
CreatedByUserFullName Created By User Full Name
LastChangedByUser Condition Contract Last Changed By USNAM
LastChangedByUserFullName User Description SUIDTECHDESC
SalesOrganizationName Sales Organization Description TEXT20
DistributionChannelName Distribution Channel Description TEXT20
DivisionName Division Description TEXT20
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
CndnContrIsInactiveName Short Text for Fixed Values DDTEXT
ExternalDocumentReferenceID External Document Identifier WCB_EXTERNAL_NUMBER
ProductName Product Description TEXT40
CompanyCodeName Name of Company Code or Company TEXT25
PrecedingConditionContract Predecessor Condition Contract WCB_COCO_NUM
CndnContrClassfctnTypeDesc Condition Contract Category Text TEXT40
CndnContrSourceDoc External Reference WCB_EXTERNAL_NUMBER2
CreationUTCDateTime UTC Time Stamp of Condition Contract Creation TZNTSTMPS
LastChangeUTCDateTime UTC Time Stamp of Last Condition Contract Change TZNTSTMPS
CndnContrUUID Condition Contract GUID WCB_GUID
CndnContrSourceUUID External Condition Contract GUID WCB_GUID
CndnContrProcVarDesc Condition Contract Process Variant Text WCB_TEXT
CndnContrIsInactiveCriticality Criticality of the Condition Contract Activation Status
CndnContrChartCounter Measure for Chart and Graph Calculations
CndnContrMainSystemStatus Main Status CRM_J_STATUS
CndnContrMainSystemStatusText Object status TEXT30
CndnContrSettlmtIsLockedName Short Text for Fixed Values DDTEXT
Master Data Relations Join Conditions
Condition Contract Category
  • Client
  • Condition Contract Category
Currency of Condition Contract
  • Client
  • Currency of Condition Contract
  • C_MNGCUSTCNDNCONTR.MANDT == TCURC.MANDT
  • C_MNGCUSTCNDNCONTR.CNDNCONTRCURRENCY == TCURC.WAERS
Settlement Points Unit
  • Client
  • Settlement Points Unit
  • C_MNGCUSTCNDNCONTR.MANDT == T006.MANDT
  • C_MNGCUSTCNDNCONTR.CNDNCONTRPOINTSQTYUNIT == T006.MSEHI
Condition Contract Process Variant
  • Client
  • Condition Contract Process Variant
Condition Contract Type
  • Condition Contract Type
  • Client
Settlement Unit of Measure
  • Client
  • Settlement Unit of Measure
  • C_MNGCUSTCNDNCONTR.MANDT == T006.MANDT
  • C_MNGCUSTCNDNCONTR.CNDNCONTRUNIT == T006.MSEHI
Settlement Unit of Volume
  • Settlement Unit of Volume
  • Client
  • C_MNGCUSTCNDNCONTR.CNDNCONTRVOLUMEUNIT == T006.MSEHI
  • C_MNGCUSTCNDNCONTR.MANDT == T006.MANDT
Settlement Unit of Weight
  • Client
  • Settlement Unit of Weight
  • C_MNGCUSTCNDNCONTR.MANDT == T006.MANDT
  • C_MNGCUSTCNDNCONTR.CNDNCONTRWEIGHTUNIT == T006.MSEHI
Company Code
  • Client
  • Company Code
  • C_MNGCUSTCNDNCONTR.MANDT == T001.MANDT
  • C_MNGCUSTCNDNCONTR.COMPANYCODE == T001.BUKRS
Customer as Partner of a Condition Contract
  • Client
  • Customer as Partner of a Condition Contract
  • C_MNGCUSTCNDNCONTR.MANDT == KNA1.MANDT
  • C_MNGCUSTCNDNCONTR.CUSTOMER == KNA1.KUNNR
Distribution Channel
  • Client
  • Distribution Channel
  • C_MNGCUSTCNDNCONTR.MANDT == TVTW.MANDT
  • C_MNGCUSTCNDNCONTR.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_MNGCUSTCNDNCONTR.MANDT == TSPA.MANDT
  • C_MNGCUSTCNDNCONTR.DIVISION == TSPA.SPART
Prior Supplier
  • Client
  • Prior Supplier
  • C_MNGCUSTCNDNCONTR.MANDT == LFA1.MANDT
  • C_MNGCUSTCNDNCONTR.PRIORSUPPLIER == LFA1.LIFNR
Purchasing Group
  • Client
  • Purchasing Group
  • C_MNGCUSTCNDNCONTR.MANDT == T024.MANDT
  • C_MNGCUSTCNDNCONTR.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • C_MNGCUSTCNDNCONTR.MANDT == T024E.MANDT
  • C_MNGCUSTCNDNCONTR.PURCHASINGORGANIZATION == T024E.EKORG
Sales group
  • Client
  • Sales office
  • Sales group
  • C_MNGCUSTCNDNCONTR.MANDT == TVBVK.MANDT
  • C_MNGCUSTCNDNCONTR.SALESOFFICE == TVBVK.VKBUR
  • C_MNGCUSTCNDNCONTR.SALESGROUP == TVBVK.VKGRP
Sales office
  • Client
  • Sales office
  • C_MNGCUSTCNDNCONTR.MANDT == TVBUR.MANDT
  • C_MNGCUSTCNDNCONTR.SALESOFFICE == TVBUR.VKBUR
Sales Organization
  • Client
  • Sales Organization
  • C_MNGCUSTCNDNCONTR.MANDT == TVKO.MANDT
  • C_MNGCUSTCNDNCONTR.SALESORGANIZATION == TVKO.VKORG
Settlement Product
  • Client
  • Settlement Product
  • C_MNGCUSTCNDNCONTR.MANDT == MARA.MANDT
  • C_MNGCUSTCNDNCONTR.SETTLMTPRODUCT == MARA.MATNR
Supplier as Partner of a Condition Contract
  • Client
  • Supplier as Partner of a Condition Contract
  • C_MNGCUSTCNDNCONTR.MANDT == LFA1.MANDT
  • C_MNGCUSTCNDNCONTR.SUPPLIER == LFA1.LIFNR