ESH_N_CNDNCONTR

Enterprise Search for Condition Contracts "Rootview" | view: ESH_N_CC | Extraction: Not supported | Component: Chargeback
Tables used: WCOCOH, BUT000, TWCBCONTRTYPET, KNA1, CVI_CUST_LINK, LFA1, CVI_VEND_LINK, TWCBCONTRTYPE
Column Name Description
ConditionContract Condition Contract
Column Name Description
Column Name Description
Column Name Description
CreationDate Date of Condition Contract Creation
CndnContrValidFrom Valid From
CndnContrValidTo Valid To
Column Name Description
CndnContrIsInactive Condition Contract Activation Status Show values
Column Name Description Domain name
CreatedByUser Condition Contract Created By USNAM
ExternalDocumentReferenceID External Document Identifier WCB_EXTERNAL_NUMBER
CndnContrTypeDesc Description WCB_TEXT
CustomerBpUUID Business Partner GUID SYSUUID
CustomerOrganizationBPName1 Name 1 of organization BU_NAME
SupplierBpUUID Business Partner GUID SYSUUID
SupplierOrganizationBPName1 Name 1 of organization BU_NAME
CndnContrIsInactiveName Short Text for Fixed Values DDTEXT
Master Data Relations Join Conditions
Condition Contract Type
  • Client
  • Condition Contract Type
Company Code
  • Client
  • Company Code
  • ESH_N_CNDNCONTR.MANDT == T001.MANDT
  • ESH_N_CNDNCONTR.COMPANYCODE == T001.BUKRS
Customer as Partner of a Condition Contract
  • Client
  • Customer as Partner of a Condition Contract
  • ESH_N_CNDNCONTR.MANDT == KNA1.MANDT
  • ESH_N_CNDNCONTR.CUSTOMER == KNA1.KUNNR
Authorization Group
  • ?
  • Client
  • Authorization Group
  • Authorization Group
  • ESH_N_CNDNCONTR.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • ESH_N_CNDNCONTR.MANDT == TB037.CLIENT
  • ESH_N_CNDNCONTR.CUSTOMERAUTHORIZATIONGROUP == TB037.AUGRP
  • ESH_N_CNDNCONTR.SUPPLIERAUTHORIZATIONGROUP == TB037.AUGRP
Distribution Channel
  • Client
  • Distribution Channel
  • ESH_N_CNDNCONTR.MANDT == TVTW.MANDT
  • ESH_N_CNDNCONTR.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • ESH_N_CNDNCONTR.MANDT == TSPA.MANDT
  • ESH_N_CNDNCONTR.DIVISION == TSPA.SPART
Purchasing Group
  • Purchasing Group
  • Client
  • ESH_N_CNDNCONTR.PURCHASINGGROUP == T024.EKGRP
  • ESH_N_CNDNCONTR.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • ESH_N_CNDNCONTR.MANDT == T024E.MANDT
  • ESH_N_CNDNCONTR.PURCHASINGORGANIZATION == T024E.EKORG
Sales Organization
  • Sales Organization
  • Client
  • ESH_N_CNDNCONTR.SALESORGANIZATION == TVKO.VKORG
  • ESH_N_CNDNCONTR.MANDT == TVKO.MANDT
Supplier as Partner of a Condition Contract
  • Client
  • Supplier as Partner of a Condition Contract
  • ESH_N_CNDNCONTR.MANDT == LFA1.MANDT
  • ESH_N_CNDNCONTR.SUPPLIER == LFA1.LIFNR
Authorization Group
  • ?
  • Client
  • Authorization Group
  • Authorization Group
  • ESH_N_CNDNCONTR.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • ESH_N_CNDNCONTR.MANDT == TB037.CLIENT
  • ESH_N_CNDNCONTR.CUSTOMERAUTHORIZATIONGROUP == TB037.AUGRP
  • ESH_N_CNDNCONTR.SUPPLIERAUTHORIZATIONGROUP == TB037.AUGRP