P_Fiarcn_Cust_Balance

Customer Balance | view: PVFIARCNCUSTBAL | 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
CustBalYTDDebitAmtInDspCrcy Debit of Current Year in Local Currency
CustBalStartingBalAmtInDspCrcy Balance at Beginning of the Period in Local Currency
CustBalEndingBalAmtInDspCrcy Balance at Ending of the Period in Local Currency
CustBalCreditAmtInDspCrcy null
CustBalYTDCrdtAmtInDspCrcy null
CreditAmountInTransCrcy null
AmountInTransactionCurrency null
YTDCrdtAmtInTransCrcy null
YrToDteAmtInTransacCrcy null
💲 Transaction Currency (TransactionCurrency):
BalCarFwdAmtInTransacCrcy Balance at Beginning of the Year in Transaction Currency
DebitAmountInTransCrcy Debit of Current Period in Transaction Currency
YTDDebitAmtInTransCrcy Debit 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
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
AssignmentReference Assignment Reference ZUONR
CustBalGLAccountInfo G/L Account Information: Identification and Name FIARCN_GLACCOUNTDESC
CustBalAltvGLAccountInfo G/L Account Information: Identification and Name FIARCN_GLACCOUNTDESC
CustBalBusinessPartnerInfo Business Partner Information: Identification and Name FIARCN_BUSI_PTNR
CustBalCustomerInfo Customer Information: Identification and Name FIARCN_CUSTOMER
CustBalSupplierInfo Supplier Information: Identification and Name FIARCN_SUPPLIER
FsclPerdHasAcctgDocPostings null
Master Data Relations Join Conditions
Customer Account Group
  • Customer Account Group
  • Client
  • P_FIARCN_CUST_BALANCE.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • P_FIARCN_CUST_BALANCE.MANDT == T077D.MANDT
Country key
  • Client
  • Country/Region Key
  • P_FIARCN_CUST_BALANCE.MANDT == T005.MANDT
  • P_FIARCN_CUST_BALANCE.CUSTOMERCOUNTRY == T005.LAND1
Region code
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • P_FIARCN_CUST_BALANCE.MANDT == T005S.MANDT
  • P_FIARCN_CUST_BALANCE.CUSTOMERREGION == T005S.BLAND
  • P_FIARCN_CUST_BALANCE.CUSTOMERCOUNTRY == T005S.LAND1