P_CN_CADEAcctgBalWthAddlInfo

CADE Accounting Balance With Additional Information | view: PCADEACCTGBALINF | Extraction: Not supported | Component: Golden Audit Interface China
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
Ledger FK Ledger
FiscalYearPeriod null
GLAccount FK G/L Account
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
EndingBalanceAmtInCoCodeCrcy Amount in Company Code Currency
OpeningBalanceAmtInCoCodeCrcy Amount in Company Code Currency
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
EndingBalanceAmtInTransCrcy Amount in Transaction Currency
OpeningBalanceAmtInTransCrcy Amount in Transaction Currency
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy Credit Amount in Transaction Currency
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
Supplier Supplier LIFNR
Customer Customer Number KUNNR
CostCenter Cost Center KOSTL
InternalOrder Order ID AUFNR
BillToParty Bill-to Party KUNNR
BusinessArea Business Area GSBER
BusinessProcess Business Process CO_PRZNR
ControllingArea Controlling Area CACCD
CustomerGroup Customer Group KDGRP
DistributionChannel Distribution Channel VTWEG
FunctionalArea Functional Area FKBER
Fund Fund BP_GEBER
FundsCenter Funds Management Center FISTL
HouseBank House Bank Key HBKID
HouseBankAccount House Bank Account HKTID
Material Material Number MATNR
MaterialGroup Product Sold Group MATKL
Plant Plant WERKS
ProfitCenter Profit Center PRCTR
Project Project FIS_PROJECT
ProjectNetwork Network Number for Account Assignment AUFNR
SalesDistrict Sales District BZIRK
SalesOrganization Sales Organization VKORG
Segment Segment for Segmental Reporting FB_SEGMENT
ShipToParty Ship-to Party KUNNR
SoldMaterial Sold Material MATNR
WBSElement WBS Element FIS_WBS
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_CN_CADEACCTGBALWTHADDLINFO.MANDT == T001.MANDT
  • P_CN_CADEACCTGBALWTHADDLINFO.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_CN_CADEACCTGBALWTHADDLINFO.MANDT == TCURC.MANDT
  • P_CN_CADEACCTGBALWTHADDLINFO.COMPANYCODECURRENCY == TCURC.WAERS
G/L Account
  • Client
  • ?
  • G/L Account
  • P_CN_CADEACCTGBALWTHADDLINFO.MANDT == SKB1.MANDT
  • P_CN_CADEACCTGBALWTHADDLINFO.[column in domain "BUKRS"] == SKB1.BUKRS
  • P_CN_CADEACCTGBALWTHADDLINFO.GLACCOUNT == SKB1.SAKNR
Ledger
  • Client
  • Ledger