C_NoClrgCustomerSupplier

No Clearing with Customer Supplier | view: CGRCNOCLRGCUSSUP | Extraction: Not supported | Component: Information System
Tables used: T001TKA02LFA1LFB1
Column Name Description
Supplier FK Account Number of Supplier
CompanyCode FK Company Code
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the Record Was Created
Column Name Description
IsOneTimeAccount Indicator: Is the account a one-time account? Show values
SupplierIsBlockedForPosting Posting block for company code Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
DeletionIndicator Deletion Flag for Master Record (Company Code Level) Show values
ClearCustomerSupplier Indicator: Clearing between customer and vendor? Show values
Column Name Description Domain name
CompanyCodeName Name of Company Code or Company TEXT25
SupplierName Name of Supplier TEXT80
CreatedByUser Name of Person who Created the Object USNAM
CityName City TEXT35
AuthorizationGroup Authorization Group BRGRU
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_NOCLRGCUSTOMERSUPPLIER.COMPANYCODE == T001.BUKRS
  • C_NOCLRGCUSTOMERSUPPLIER.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • C_NOCLRGCUSTOMERSUPPLIER.COUNTRY == T005.LAND1
  • C_NOCLRGCUSTOMERSUPPLIER.MANDT == T005.MANDT
Customer Number
  • Customer Number
  • Client
  • C_NOCLRGCUSTOMERSUPPLIER.CUSTOMER == KNA1.KUNNR
  • C_NOCLRGCUSTOMERSUPPLIER.MANDT == KNA1.MANDT
Reconciliation Account in General Ledger
  • Company Code
  • Reconciliation Account in General Ledger
  • Client
  • C_NOCLRGCUSTOMERSUPPLIER.COMPANYCODE == SKB1.BUKRS
  • C_NOCLRGCUSTOMERSUPPLIER.RECONCILIATIONACCOUNT == SKB1.SAKNR
  • C_NOCLRGCUSTOMERSUPPLIER.MANDT == SKB1.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • C_NOCLRGCUSTOMERSUPPLIER.SUPPLIER == LFA1.LIFNR
  • C_NOCLRGCUSTOMERSUPPLIER.MANDT == LFA1.MANDT
Vendor account group
  • Vendor account group
  • Client
  • C_NOCLRGCUSTOMERSUPPLIER.SUPPLIERACCOUNTGROUP == T077K.KTOKK
  • C_NOCLRGCUSTOMERSUPPLIER.MANDT == T077K.MANDT