C_DeltaResidualOpenItem

Open item delta | view: CGROITD | Extraction: Not supported | Component: Fiori FXU Accounts Payable FI-FIO-AP
Tables used: BKPFBSEGT001T014
Column Name Description
CompanyCode FK Company Code
ClearedFiscalYear Fiscal Year
ClearedAccountingDocument Journal Entry
ClearedAccountingDocumentItem Journal Entry Posting View Item
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
II_AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
ClearedCashDiscountAmount Cash Discount Amount
CashDiscountBaseAmount Cash Discount Base Amount
CashDiscountAmount Cash Discount Amount
II_AmountInTransactionCurrency Amount in Transaction Currency
II_CashDiscountBaseAmount Cash Discount Base Amount
II_CashDiscountAmount Cash Discount Amount
Column Name Description
Column Name Description
CreationDate Accounting Document Entry Date
CreationTime Creation Time
ClearingDate Clearing Date
ClearingCreationDate Clearing Creation Date
PostingDate Posting Date
DocumentDate Journal Entry Date
NetDueDate Due Date for Net Payment
DueCalculationBaseDate Due Calculation Base Date
II_ClearingDate Clearing Date
II_ClearingCreationDate Clearing Creation Date
II_PostingDate Posting Date
II_DocumentDate Journal Entry Date
II_NetDueDate Due Date for Net Payment
II_DueCalculationBaseDate Due Calculation Base Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
FixedCashDiscount Fixed Cash Discount Show values
II_DebitCreditCode Debit/Credit Code Show values
II_FixedCashDiscount Fixed Cash Discount Show values
Column Name Description Domain name
BillingDocument Billing Document VBELN
AssignmentReference Assignment Reference ZUONR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceReference Invoice Reference BELNR
InvoiceItemReference Invoice Item Reference BUZEI
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
II_BillingDocument Billing Document VBELN
II_AssignmentReference Assignment Reference ZUONR
II_DocumentItemText Item Text TEXT50
II_ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
II_ClearingAccountingDocument Clearing Journal Entry BELNR
II_ClearingItem Clearing Item AGZEI
II_PaymentTerms Terms of Payment Key ZTERM
II_CashDiscount1Days Cash Discount Days 1 ZBDXT
II_CashDiscount2Days Cash Discount Days 2 ZBDXT
II_NetPaymentDays Net Payment Terms Period ZBDXT
II_CashDiscount1Percent Cash Discount Percentage 1 PRZ23
II_CashDiscount2Percent Cash Discount Percentage 2 PRZ23
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_DELTARESIDUALOPENITEM.COMPANYCODE == T001.BUKRS
  • C_DELTARESIDUALOPENITEM.MANDT == T001.MANDT
Customer Number
  • Customer Number
  • Customer Number
  • Client
  • C_DELTARESIDUALOPENITEM.CUSTOMER == KNA1.KUNNR
  • C_DELTARESIDUALOPENITEM.II_CUSTOMER == KNA1.KUNNR
  • C_DELTARESIDUALOPENITEM.MANDT == KNA1.MANDT
Customer Number
  • Customer Number
  • Customer Number
  • Client
  • C_DELTARESIDUALOPENITEM.CUSTOMER == KNA1.KUNNR
  • C_DELTARESIDUALOPENITEM.II_CUSTOMER == KNA1.KUNNR
  • C_DELTARESIDUALOPENITEM.MANDT == KNA1.MANDT
Payment Blocking Reason
  • Client
  • Payment Blocking Reason
  • Payment Blocking Reason
  • C_DELTARESIDUALOPENITEM.MANDT == T008.MANDT
  • C_DELTARESIDUALOPENITEM.II_PAYMENTBLOCKINGREASON == T008.ZAHLS
  • C_DELTARESIDUALOPENITEM.PAYMENTBLOCKINGREASON == T008.ZAHLS
Payment Difference Reason
  • Payment Difference Reason
  • Payment Difference Reason
  • Company Code
  • Client
  • C_DELTARESIDUALOPENITEM.PAYMENTDIFFERENCEREASON == T053R.RSTGR
  • C_DELTARESIDUALOPENITEM.II_PAYMENTDIFFERENCEREASON == T053R.RSTGR
  • C_DELTARESIDUALOPENITEM.COMPANYCODE == T053R.BUKRS
  • C_DELTARESIDUALOPENITEM.MANDT == T053R.MANDT
Transaction Currency
  • Transaction Currency
  • Transaction Currency
  • Client
  • C_DELTARESIDUALOPENITEM.II_TRANSACTIONCURRENCY == TCURC.WAERS
  • C_DELTARESIDUALOPENITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_DELTARESIDUALOPENITEM.MANDT == TCURC.MANDT
Payment Blocking Reason
  • Client
  • Payment Blocking Reason
  • Payment Blocking Reason
  • C_DELTARESIDUALOPENITEM.MANDT == T008.MANDT
  • C_DELTARESIDUALOPENITEM.II_PAYMENTBLOCKINGREASON == T008.ZAHLS
  • C_DELTARESIDUALOPENITEM.PAYMENTBLOCKINGREASON == T008.ZAHLS
Payment Difference Reason
  • Payment Difference Reason
  • Payment Difference Reason
  • Company Code
  • Client
  • C_DELTARESIDUALOPENITEM.PAYMENTDIFFERENCEREASON == T053R.RSTGR
  • C_DELTARESIDUALOPENITEM.II_PAYMENTDIFFERENCEREASON == T053R.RSTGR
  • C_DELTARESIDUALOPENITEM.COMPANYCODE == T053R.BUKRS
  • C_DELTARESIDUALOPENITEM.MANDT == T053R.MANDT
Transaction Currency
  • Transaction Currency
  • Transaction Currency
  • Client
  • C_DELTARESIDUALOPENITEM.II_TRANSACTIONCURRENCY == TCURC.WAERS
  • C_DELTARESIDUALOPENITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_DELTARESIDUALOPENITEM.MANDT == TCURC.MANDT