I_CN_CADEJournalEntryWithBal

CADE - Journal Entry Item with Balance | view: ICNJRNLENTRWBAL | Extraction: Not supported | Component: Golden Audit Interface China
Column Name Description
CompanyCode FK Company Code
Ledger FK Ledger
FiscalYear Fiscal Year
CN_CADENatlStdRelVersion National Standard Release Version for CADE Show values
AccountingDocument Journal Entry
PostingDate Posting Date
LedgerGLLineItem Ledger Journal Entry Item
FiscalPeriod Fiscal Period
FiscalYearPostingPeriod Fiscal Period
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
AmountInCompanyCodeCurrency Amount in Company Code Currency
OpeningBalanceAmtInCoCodeCrcy Amount in Company Code Currency
EndingBalanceAmtInCoCodeCrcy Amount in Company Code Currency
IntmdEndingBalAmtInCoCodeCrcy Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy Credit Amount in Transaction Currency
AmountInTransactionCurrency Amount in Transaction Currency
OpeningBalanceAmtInTransCrcy Amount in Transaction Currency
EndingBalanceAmtInTransCrcy Amount in Transaction Currency
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
CN_CADENatlStdRelVersion National Standard Release Version for CADE Show values
Column Name Description Domain name
FunctionalAreaIsUsed Functional Area FKBER
FiscalYearPeriod null
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
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_CN_CADEJOURNALENTRYWITHBAL.CHARTOFACCOUNTS == T004.KTOPL
  • I_CN_CADEJOURNALENTRYWITHBAL.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • I_CN_CADEJOURNALENTRYWITHBAL.MANDT == T001.MANDT
  • I_CN_CADEJOURNALENTRYWITHBAL.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • I_CN_CADEJOURNALENTRYWITHBAL.MANDT == TCURC.MANDT
  • I_CN_CADEJOURNALENTRYWITHBAL.COMPANYCODECURRENCY == TCURC.WAERS
G/L Account
  • Client
  • G/L Account
  • ?
  • I_CN_CADEJOURNALENTRYWITHBAL.MANDT == SKB1.MANDT
  • I_CN_CADEJOURNALENTRYWITHBAL.GLACCOUNT == SKB1.SAKNR
  • I_CN_CADEJOURNALENTRYWITHBAL.[column in domain "BUKRS"] == SKB1.BUKRS
Ledger
  • Client
  • Ledger
Transaction Currency
  • Client
  • Transaction Currency
  • I_CN_CADEJOURNALENTRYWITHBAL.MANDT == TCURC.MANDT
  • I_CN_CADEJOURNALENTRYWITHBAL.TRANSACTIONCURRENCY == TCURC.WAERS