C_DebitOpenItem

Debit Open Items | view: CDEBITOPENITEM | Extraction: Not supported | Component: Fiori FXU Accounts Receivable FI-FIO-AR
Tables used: AVIPBKPFBSEGT001TKA02T005KNA1T001T014
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Transaction Amount
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
ClearingDate Clearing Date
Column Name Description
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
SpecialGLTransactionType Special G/L Transaction Type UMSKS
ClearingAccountingDocument Clearing Journal Entry BELNR
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
CustomerName Name of Customer TEXT80
PaymentAdvice Payment Advice Number AVSID
Reference1IDByBusinessPartner ID of Reference 1 by Business Partner CHAR12
DocumentReferenceID Document Reference ID XBLNR1
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_DEBITOPENITEM.MANDT == T003.MANDT
  • C_DEBITOPENITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Company Code
  • Client
  • C_DEBITOPENITEM.COMPANYCODE == T001.BUKRS
  • C_DEBITOPENITEM.MANDT == T001.MANDT
Customer Number
  • Customer Number
  • Client
  • C_DEBITOPENITEM.CUSTOMER == KNA1.KUNNR
  • C_DEBITOPENITEM.MANDT == KNA1.MANDT
Posting Key
  • Posting Key
  • Client
  • C_DEBITOPENITEM.POSTINGKEY == TBSL.BSCHL
  • C_DEBITOPENITEM.MANDT == TBSL.MANDT
Special G/L Indicator
  • ?
  • Special G/L Indicator
  • Client
  • C_DEBITOPENITEM.[column in domain "KOART"] == T074U.KOART
  • C_DEBITOPENITEM.SPECIALGLCODE == T074U.UMSKZ
  • C_DEBITOPENITEM.MANDT == T074U.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • C_DEBITOPENITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_DEBITOPENITEM.MANDT == TCURC.MANDT