P_CN_CADEAcctgDocRblItem

CADE-Acctg Doc Receivable Item P view | view: PCNCADEARITEMS | Extraction: Not supported | Component: Golden Audit Interface China
Tables used: BKPFBSEGFEBEPT004T001TKA02TCURTSKA1SKB1T001T014FINSC_FISC_DATE
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocumentType FK Journal Entry Type
AccountingDocument Journal Entry
AccountingDocumentItem Posting View Item
GLAccount FK G/L Account
ChartOfAccounts FK Chart of Accounts
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
ValueDate null
ClearingDate Clearing Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
Debtor null
FiscalPeriod null
CurrencyShortName Short text TEXT15
ExchangeRate Exchange Rate
TransactionCurrencyName Short text TEXT15
DocumentItemText Item Text TEXT50
ClearingAccountingDocument null
BillingDocument null
DocumentReferenceID null
SalesOrder null
IsCleared null
BillOfExchange null
AlternativeGLAccount null
AlternativeReferenceDocument null
GLAccountInfo null
CAClearingDocumentNumber null
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_CN_CADEACCTGDOCRBLITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_CN_CADEACCTGDOCRBLITEM.MANDT == T003.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_CN_CADEACCTGDOCRBLITEM.CHARTOFACCOUNTS == T004.KTOPL
  • P_CN_CADEACCTGDOCRBLITEM.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • P_CN_CADEACCTGDOCRBLITEM.MANDT == T001.MANDT
  • P_CN_CADEACCTGDOCRBLITEM.COMPANYCODE == T001.BUKRS
G/L Account
  • G/L Account
  • Client
  • Company Code
  • P_CN_CADEACCTGDOCRBLITEM.GLACCOUNT == SKB1.SAKNR
  • P_CN_CADEACCTGDOCRBLITEM.MANDT == SKB1.MANDT
  • P_CN_CADEACCTGDOCRBLITEM.COMPANYCODE == SKB1.BUKRS
Payment Method
  • ?
  • Payment Method
  • Client
  • P_CN_CADEACCTGDOCRBLITEM.[column in domain "LAND1"] == T042Z.LAND1
  • P_CN_CADEACCTGDOCRBLITEM.PAYMENTMETHOD == T042Z.ZLSCH
  • P_CN_CADEACCTGDOCRBLITEM.MANDT == T042Z.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • P_CN_CADEACCTGDOCRBLITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_CN_CADEACCTGDOCRBLITEM.MANDT == TCURC.MANDT