C_UpdatedOpenItem

Updated Open Item | view: CAGRIUU | Extraction: Not supported | Component: Fiori FXU Accounts Payable FI-FIO-AP
Tables used: BKPFCDHDRBSEGT000T001T014CDPOS
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Transaction Currency (TransactionCurrency):
CashDiscountBaseAmount Cash Discount Base Amount
CashDiscountAmount Cash Discount Amount
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
Column Name Description
Column Name Description
CreationDate Accounting Document Entry Date
CreationTime Creation Time
LastChangeDate Last Change Date
ChangeDocCreationDate Creation date of the change document
ChangeDocumentCreationTime Time changed
PostingDate Posting Date
DocumentDate Journal Entry Date
NetDueDate Due Date for Net Payment
DueCalculationBaseDate Due Calculation Base Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
FixedCashDiscount Fixed Cash Discount Show values
Column Name Description Domain name
AssignmentReference Assignment Reference ZUONR
AccountingDocumentHeaderText Document Header Text TEXT25
DocumentItemText Item Text TEXT50
PaymentTerms Terms of Payment Key ZTERM
CashDiscount1Days Cash Discount Days 1 ZBDXT
CashDiscount2Days Cash Discount Days 2 ZBDXT
NetPaymentDays Net Payment Terms Period ZBDXT
CashDiscount1Percent Cash Discount Percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
BillingDocument Billing Document VBELN
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_UPDATEDOPENITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_UPDATEDOPENITEM.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • C_UPDATEDOPENITEM.COMPANYCODE == T001.BUKRS
  • C_UPDATEDOPENITEM.MANDT == T001.MANDT
Customer Number
  • Customer Number
  • Client
  • C_UPDATEDOPENITEM.CUSTOMER == KNA1.KUNNR
  • C_UPDATEDOPENITEM.MANDT == KNA1.MANDT
Payment Blocking Reason
  • Payment Blocking Reason
  • Client
  • C_UPDATEDOPENITEM.PAYMENTBLOCKINGREASON == T008.ZAHLS
  • C_UPDATEDOPENITEM.MANDT == T008.MANDT
Payment Difference Reason
  • Company Code
  • Client
  • Payment Difference Reason
  • C_UPDATEDOPENITEM.COMPANYCODE == T053R.BUKRS
  • C_UPDATEDOPENITEM.MANDT == T053R.MANDT
  • C_UPDATEDOPENITEM.PAYMENTDIFFERENCEREASON == T053R.RSTGR
Transaction Currency
  • Transaction Currency
  • Client
  • C_UPDATEDOPENITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_UPDATEDOPENITEM.MANDT == TCURC.MANDT