P_CN_CustAcctBalRaw

Customer Account Balance Raw Data | view: PCNCUSTACCTBALR | Extraction: Not supported | Component: Financials China
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
GLAccount FK G/L Account
AlternativeGLAccount Alternative Account Number in Company Code
Customer FK Customer Number
Supplier FK Supplier
SpecialGLCode FK Special G/L Indicator
ProfitCenter FK Profit Center
BusinessArea FK Business Area
DisplayCurrency Company Code Currency
TransactionCurrency FK Transaction Currency
Column Name Description
💲 Company Code Currency (DisplayCurrency):
BalCarFwdAmtInDspCrcy null
StartingBalAmtInDspCrcy null
EndingBalAmtInDspCrcy null
DebitAmountInDspCrcy null
CreditAmountInDspCrcy null
YTDDebitAmtInDspCrcy null
YTDCrdtAmtInDspCrcy null
💲 Transaction Currency (TransactionCurrency):
DebitAmountInTransCrcy null
CreditAmountInTransCrcy null
YTDDebitAmtInTransCrcy null
YTDCrdtAmtInTransCrcy null
BalCarFwdAmtInTransacCrcy null
StartingBalanceAmtInTransCrcy null
EndingBalanceAmtInTransCrcy null
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
AssignmentReference Assignment Reference ZUONR
Master Data Relations Join Conditions
Business Area
  • Client
  • Business Area
  • P_CN_CUSTACCTBALRAW.MANDT == TGSB.MANDT
  • P_CN_CUSTACCTBALRAW.BUSINESSAREA == TGSB.GSBER
Company Code
  • Company Code
  • Client
  • P_CN_CUSTACCTBALRAW.COMPANYCODE == T001.BUKRS
  • P_CN_CUSTACCTBALRAW.MANDT == T001.MANDT
Customer Number
  • Client
  • Customer Number
  • P_CN_CUSTACCTBALRAW.MANDT == KNA1.MANDT
  • P_CN_CUSTACCTBALRAW.CUSTOMER == KNA1.KUNNR
G/L Account
  • G/L Account
  • ?
  • Client
  • P_CN_CUSTACCTBALRAW.GLACCOUNT == SKB1.SAKNR
  • P_CN_CUSTACCTBALRAW.[column in domain "BUKRS"] == SKB1.BUKRS
  • P_CN_CUSTACCTBALRAW.MANDT == SKB1.MANDT
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • P_CN_CUSTACCTBALRAW.[column in domain "DATBI"] == CEPC.DATBI
  • P_CN_CUSTACCTBALRAW.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_CN_CUSTACCTBALRAW.MANDT == CEPC.MANDT
  • P_CN_CUSTACCTBALRAW.PROFITCENTER == CEPC.PRCTR
Special G/L Indicator
  • Special G/L Indicator
  • ?
  • Client
  • P_CN_CUSTACCTBALRAW.SPECIALGLCODE == T074U.UMSKZ
  • P_CN_CUSTACCTBALRAW.[column in domain "KOART"] == T074U.KOART
  • P_CN_CUSTACCTBALRAW.MANDT == T074U.MANDT
Supplier
  • Supplier
  • Client
  • P_CN_CUSTACCTBALRAW.SUPPLIER == LFA1.LIFNR
  • P_CN_CUSTACCTBALRAW.MANDT == LFA1.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • P_CN_CUSTACCTBALRAW.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_CN_CUSTACCTBALRAW.MANDT == TCURC.MANDT