P_CN_CustAcctBal

Customer Account Balance | view: PCNCUSTACCTBAL | Extraction: Not supported | Component: Financials China
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
FiscalYearPeriod null
GLAccount G/L Account
AlternativeGLAccount Alternative Account Number in Company Code
BusinessPartner Business Partner Number
Customer Customer Number
Supplier Supplier
DisplayCurrency Company Code Currency
Column Name Description
💲 Company Code Currency (DisplayCurrency):
BalCarFwdAmtInDspCrcy null
StartingBalAmtInDspCrcy null
EndingBalAmtInDspCrcy null
DebitAmountInDspCrcy null
CreditAmountInDspCrcy null
YTDDebitAmtInDspCrcy null
YTDCrdtAmtInDspCrcy null
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
CustomerName Name of Customer TEXT80
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
CustomerVATRegistration Tax Number 5 CHAR60
CustomerCityName City TEXT40
BusinessPartnerName null
CustBalAltvGLAccountInfo null
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_CN_CUSTACCTBAL.MANDT == T001.MANDT
  • P_CN_CUSTACCTBAL.COMPANYCODE == T001.BUKRS
Customer Account Group
  • Customer Account Group
  • Client
  • P_CN_CUSTACCTBAL.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • P_CN_CUSTACCTBAL.MANDT == T077D.MANDT
Country key
  • Client
  • Country/Region Key
  • P_CN_CUSTACCTBAL.MANDT == T005.MANDT
  • P_CN_CUSTACCTBAL.CUSTOMERCOUNTRY == T005.LAND1
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • P_CN_CUSTACCTBAL.MANDT == T005S.MANDT
  • P_CN_CUSTACCTBAL.CUSTOMERCOUNTRY == T005S.LAND1
  • P_CN_CUSTACCTBAL.CUSTOMERREGION == T005S.BLAND