C_NoRecnclnAccountCustomer

No Reconciliation Account Customer | view: CGRCRECNCACCTCUS | Extraction: Not supported | Component: Information System
Tables used: T001TKA02KNA1KNB1KNB5
Column Name Description
Customer FK Customer Number
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
PostingIsBlocked Central posting block Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
DeletionIndicator Deletion Flag for Master Record (Company Code Level) Show values
Column Name Description Domain name
CompanyCodeName Name of Company Code or Company TEXT25
CustomerName Name of Customer TEXT80
CreatedByUser Name of Person who Created the Object USNAM
CityName City TEXT35
AuthorizationGroup Authorization Group BRGRU
Master Data Relations Join Conditions
Central billing block for customer
  • Client
  • Central billing block for customer
  • C_NORECNCLNACCOUNTCUSTOMER.MANDT == TVFS.MANDT
  • C_NORECNCLNACCOUNTCUSTOMER.BILLINGISBLOCKEDFORCUSTOMER == TVFS.FAKSP
Company Code
  • Client
  • Company Code
  • C_NORECNCLNACCOUNTCUSTOMER.MANDT == T001.MANDT
  • C_NORECNCLNACCOUNTCUSTOMER.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • C_NORECNCLNACCOUNTCUSTOMER.MANDT == T005.MANDT
  • C_NORECNCLNACCOUNTCUSTOMER.COUNTRY == T005.LAND1
Customer Number
  • Client
  • Customer Number
  • C_NORECNCLNACCOUNTCUSTOMER.MANDT == KNA1.MANDT
  • C_NORECNCLNACCOUNTCUSTOMER.CUSTOMER == KNA1.KUNNR
Customer Account Group
  • Customer Account Group
  • Client
  • C_NORECNCLNACCOUNTCUSTOMER.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • C_NORECNCLNACCOUNTCUSTOMER.MANDT == T077D.MANDT
Central delivery block for the customer
  • Client
  • Central delivery block for the customer
  • C_NORECNCLNACCOUNTCUSTOMER.MANDT == TVLS.MANDT
  • C_NORECNCLNACCOUNTCUSTOMER.DELIVERYISBLOCKED == TVLS.LIFSP
Central order block for customer
  • ?
  • Client
  • Central order block for customer
  • C_NORECNCLNACCOUNTCUSTOMER.[column in domain "SPRAS"] == TVAST.SPRAS
  • C_NORECNCLNACCOUNTCUSTOMER.MANDT == TVAST.MANDT
  • C_NORECNCLNACCOUNTCUSTOMER.ORDERISBLOCKEDFORCUSTOMER == TVAST.AUFSP
Reconciliation Account in General Ledger
  • Client
  • Company Code
  • Reconciliation Account in General Ledger
  • C_NORECNCLNACCOUNTCUSTOMER.MANDT == SKB1.MANDT
  • C_NORECNCLNACCOUNTCUSTOMER.COMPANYCODE == SKB1.BUKRS
  • C_NORECNCLNACCOUNTCUSTOMER.RECONCILIATIONACCOUNT == SKB1.SAKNR