C_DeltaOpenItem

Delta Open Item | view: CGROITDII | Extraction: Not supported | Component: Fiori FXU Accounts Payable FI-FIO-AP
Tables used: BKPFBSEGT001T014
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
CashDiscountBaseAmount Cash Discount Base Amount
CashDiscountAmount Cash Discount Amount
Column Name Description
Column Name Description
CreationDate Accounting Document Entry Date
CreationTime Creation Time
ClearingCreationDate Accounting Document Entry Date
ClearingCreationTime Creation Time
ClearingDate Clearing Date
LastChangeDate Last Change Date
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
BillingDocument Billing Document VBELN
AssignmentReference Assignment Reference ZUONR
AccountingDocumentHeaderText Document Header Text TEXT25
DocumentItemText Item Text TEXT50
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingItem Clearing Item AGZEI
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
LastCreationOrClearingDatetime null
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_DELTAOPENITEM.MANDT == T003.MANDT
  • C_DELTAOPENITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Client
  • Company Code
  • C_DELTAOPENITEM.MANDT == T001.MANDT
  • C_DELTAOPENITEM.COMPANYCODE == T001.BUKRS
Customer Number
  • Client
  • Customer Number
  • C_DELTAOPENITEM.MANDT == KNA1.MANDT
  • C_DELTAOPENITEM.CUSTOMER == KNA1.KUNNR
Payment Blocking Reason
  • Client
  • Payment Blocking Reason
  • C_DELTAOPENITEM.MANDT == T008.MANDT
  • C_DELTAOPENITEM.PAYMENTBLOCKINGREASON == T008.ZAHLS
Payment Difference Reason
  • Client
  • Payment Difference Reason
  • Company Code
  • C_DELTAOPENITEM.MANDT == T053R.MANDT
  • C_DELTAOPENITEM.PAYMENTDIFFERENCEREASON == T053R.RSTGR
  • C_DELTAOPENITEM.COMPANYCODE == T053R.BUKRS
Transaction Currency
  • Client
  • Transaction Currency
  • C_DELTAOPENITEM.MANDT == TCURC.MANDT
  • C_DELTAOPENITEM.TRANSACTIONCURRENCY == TCURC.WAERS