P_CN_CADEAccountBalanceSum

CADE - Account Balance Subtotal | view: PCNACCTBALSUM | Extraction: Not supported | Component: Golden Audit Interface China
Column Name Description
CompanyCode FK Company Code
CN_CADENatlStdRelVersion National Standard Release Version for CADE Show values
Ledger FK Ledger
FiscalYear Fiscal Year
FiscalYearPeriod null
GLAccount FK G/L Account
FunctionalAreaIsUsed Functional Area
CompanyCodeCurrency FK Company Code Currency
TransactionCurrency FK Transaction Currency
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
DebitAmountInCoCodeCrcy null
CreditAmountInCoCodeCrcy null
OpeningBalanceAmtInCoCodeCrcy null
EndingBalanceAmtInCoCodeCrcy null
IntmdEndingBalAmtInCoCodeCrcy null
💲 Transaction Currency (TransactionCurrency):
DebitAmountInTransCrcy null
CreditAmountInTransCrcy null
OpeningBalanceAmtInTransCrcy null
EndingBalanceAmtInTransCrcy null
Column Name Description
Column Name Description
Column Name Description
CN_CADENatlStdRelVersion National Standard Release Version for CADE Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_CN_CADEACCOUNTBALANCESUM.MANDT == T001.MANDT
  • P_CN_CADEACCOUNTBALANCESUM.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_CN_CADEACCOUNTBALANCESUM.MANDT == TCURC.MANDT
  • P_CN_CADEACCOUNTBALANCESUM.COMPANYCODECURRENCY == TCURC.WAERS
G/L Account
  • Client
  • G/L Account
  • ?
  • P_CN_CADEACCOUNTBALANCESUM.MANDT == SKB1.MANDT
  • P_CN_CADEACCOUNTBALANCESUM.GLACCOUNT == SKB1.SAKNR
  • P_CN_CADEACCOUNTBALANCESUM.[column in domain "BUKRS"] == SKB1.BUKRS
Ledger
  • Client
  • Ledger
Transaction Currency
  • Client
  • Transaction Currency
  • P_CN_CADEACCOUNTBALANCESUM.MANDT == TCURC.MANDT
  • P_CN_CADEACCOUNTBALANCESUM.TRANSACTIONCURRENCY == TCURC.WAERS