P_CN_CADEAcctgDocPayableItem

CADE-Acctg Doc Payable Item P View | view: PCNCADEAPITEMS | Extraction: Not supported | Component: Golden Audit Interface China
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
Creditor null
FiscalPeriod null
CurrencyShortName Short text TEXT15
ExchangeRate Exchange Rate
TransactionCurrencyName Short text TEXT15
DocumentItemText Item Text TEXT50
ClearingAccountingDocument null
BillingDocument null
DocumentReferenceID null
PurchasingDocument null
IsCleared null
BillOfExchange null
AlternativeGLAccount null
AlternativeReferenceDocument null
GLAccountInfo null
CAClearingDocumentNumber null
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_CN_CADEACCTGDOCPAYABLEITEM.MANDT == T003.MANDT
  • P_CN_CADEACCTGDOCPAYABLEITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_CN_CADEACCTGDOCPAYABLEITEM.CHARTOFACCOUNTS == T004.KTOPL
  • P_CN_CADEACCTGDOCPAYABLEITEM.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • P_CN_CADEACCTGDOCPAYABLEITEM.MANDT == T001.MANDT
  • P_CN_CADEACCTGDOCPAYABLEITEM.COMPANYCODE == T001.BUKRS
G/L Account
  • G/L Account
  • Client
  • Company Code
  • P_CN_CADEACCTGDOCPAYABLEITEM.GLACCOUNT == SKB1.SAKNR
  • P_CN_CADEACCTGDOCPAYABLEITEM.MANDT == SKB1.MANDT
  • P_CN_CADEACCTGDOCPAYABLEITEM.COMPANYCODE == SKB1.BUKRS
Payment Method
  • ?
  • Client
  • Payment Method
  • P_CN_CADEACCTGDOCPAYABLEITEM.[column in domain "LAND1"] == T042Z.LAND1
  • P_CN_CADEACCTGDOCPAYABLEITEM.MANDT == T042Z.MANDT
  • P_CN_CADEACCTGDOCPAYABLEITEM.PAYMENTMETHOD == T042Z.ZLSCH
Transaction Currency
  • Client
  • Transaction Currency
  • P_CN_CADEACCTGDOCPAYABLEITEM.MANDT == TCURC.MANDT
  • P_CN_CADEACCTGDOCPAYABLEITEM.TRANSACTIONCURRENCY == TCURC.WAERS