C_CN_CustBalance

Customer Balance | view: CCNCUSTBALANCE | Extraction: Not supported | Component: Financials China
Tables used: SCAL_TT_DATE, ACDOCA, ADCP, ADRC, BUT000, T001, TKA02, FINSC_CURTYPE, FINSC_CURTYPET, KNA1, KNB1, KNB5, CVI_CUST_LINK, SKB1, LFA1, CVI_VEND_LINK, SKAT, T004, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
CompanyCode Company Code
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
FiscalYearPeriod Fiscal Year Period
Customer Customer Number
BusinessPartner Business Partner Number
Supplier null
GLAccount G/L Account
AlternativeGLAccount Alternative Account Number in Company Code
SpecialGLCode Special G/L Indicator
BusinessArea Business Area
ProfitCenter Profit Center
DisplayCurrency Reporting Currency
TransactionCurrency Transaction Currency
Column Name Description
💲 Reporting Currency (DisplayCurrency):
CustBalCarryFwdAmtInDspCrcy Balance at Beginning of the Year in Local Currency
CustBalDebitAmtInDspCrcy Debit of Current Period in Local Currency
CustBalCreditAmtInDspCrcy Credit of Current Period in Local Currency
AmountInCompanyCodeCurrency null
CustBalYTDDebitAmtInDspCrcy Debit of Current Year in Local Currency
CustBalYTDCrdtAmtInDspCrcy Credit of Current Year in Local Currency
YTDAmtInLoclCrcy null
CustBalStartingBalAmtInDspCrcy Balance at Beginning of the Period in Local Currency
CustBalEndingBalAmtInDspCrcy Balance at Ending of the Period in Local Currency
💲 Transaction Currency (TransactionCurrency):
BalCarFwdAmtInTransacCrcy Balance at Beginning of the Year in Transaction Currency
DebitAmountInTransCrcy Debit of Current Period in Transaction Currency
CreditAmountInTransCrcy Credit of Current Period in Transaction Currency
AmountInTransactionCurrency Balance of Current Period in Transaction Currency
YTDDebitAmtInTransCrcy Debit of Current Year in Transaction Currency
YTDCrdtAmtInTransCrcy Credit of Current Year in Transaction Currency
YrToDteAmtInTransacCrcy Balance of Current Year in Transaction Currency
StartingBalanceAmtInTransCrcy Balance at Beginning of the Period in Transaction Currency
EndingBalanceAmtInTransCrcy Balance at Ending of the Period in Transaction Currency
Column Name Description
Column Name Description
Column Name Description
FsclPerdHasAcctgDocPostings Indicator: Posting of FI Acctg Docs Exists in This Fscl Perd Show values
Column Name Description Domain name
CustomerSearchText Search Term CHAR30
CustomerVATRegistration Tax Number 5 CHAR60
CustomerCityName City TEXT40
CustomerName Name of Customer TEXT80
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
BusinessPartnerName null
GLAccountName G/L Account Name TEXT20
AlternativeGLAccountName G/L Account Name TEXT20
CustBalSupplierInfo Supplier Information: Identification and Name FIARCN_SUPPLIER
CustBalBusinessPartnerInfo Business Partner Information: Identification and Name FIARCN_BUSI_PTNR
AssignmentReference Assignment Reference
CustBalCustomerInfo Customer Information: Identification and Name FIARCN_CUSTOMER
CustBalGLAccountInfo G/L Account Information: Identification and Name FIARCN_GLACCOUNTDESC
Master Data Relations Join Conditions
Customer Account Group
  • Customer Account Group
  • Client
  • C_CN_CUSTBALANCE.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • C_CN_CUSTBALANCE.MANDT == T077D.MANDT
Country key
  • Country/Region Key
  • Client
  • C_CN_CUSTBALANCE.CUSTOMERCOUNTRY == T005.LAND1
  • C_CN_CUSTBALANCE.MANDT == T005.MANDT
Region code
  • Country/Region Key
  • Region (State, Province, County)
  • Client
  • C_CN_CUSTBALANCE.CUSTOMERCOUNTRY == T005S.LAND1
  • C_CN_CUSTBALANCE.CUSTOMERREGION == T005S.BLAND
  • C_CN_CUSTBALANCE.MANDT == T005S.MANDT