C_CreditOpenItem

Credit Open Items | view: CCREDITOPENITEM | 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
  • Journal Entry Type
  • Client
  • C_CREDITOPENITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_CREDITOPENITEM.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • C_CREDITOPENITEM.COMPANYCODE == T001.BUKRS
  • C_CREDITOPENITEM.MANDT == T001.MANDT
Customer Number
  • Client
  • Customer Number
  • C_CREDITOPENITEM.MANDT == KNA1.MANDT
  • C_CREDITOPENITEM.CUSTOMER == KNA1.KUNNR
Posting Key
  • Posting Key
  • Client
  • C_CREDITOPENITEM.POSTINGKEY == TBSL.BSCHL
  • C_CREDITOPENITEM.MANDT == TBSL.MANDT
Special G/L Indicator
  • Client
  • Special G/L Indicator
  • ?
  • C_CREDITOPENITEM.MANDT == T074U.MANDT
  • C_CREDITOPENITEM.SPECIALGLCODE == T074U.UMSKZ
  • C_CREDITOPENITEM.[column in domain "KOART"] == T074U.KOART
Transaction Currency
  • Client
  • Transaction Currency
  • C_CREDITOPENITEM.MANDT == TCURC.MANDT
  • C_CREDITOPENITEM.TRANSACTIONCURRENCY == TCURC.WAERS