I_PaytAdviceItemFromAssignment

Payment advice items created from assignment | view: IPAYTADVITEFASGN | Extraction: Not supported | Component: Fiori FXU Accounts Receivable FI-FIO-AR
Tables used: AVIPBSEGT001TKA02T005KNA1T014
Column Name Description
CompanyCode FK Company Code
PaymentAdviceAccountType Payment Advice Account Type Show values
PaymentAdviceAccount Account Number
PaymentAdvice Payment Advice Number
PaymentAdviceItem Payment Advice Item
Column Name Description
💲 Currency Key (Currency):
AmountInTransactionCurrency Transaction Amount
NetPaymentAmountInPaytCurrency Net Payment Amount with +/- Sign
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
ClearingDate Clearing Date
Column Name Description
PaymentAdviceAccountType Payment Advice Account Type Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
FiscalYear Fiscal Year GJAHR
AccountingDocument Document Number of an Accounting Document BELNR
AccountingDocumentItem Posting View Item BUZEI
PaymentAdviceAltvAccount Alternative Account (Payment Advice Management) KTONR
CustomerName Name of Customer TEXT80
ClearingAccountingDocument Clearing Journal Entry BELNR
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_PAYTADVICEITEMFROMASSIGNMENT.MANDT == T003.MANDT
  • I_PAYTADVICEITEMFROMASSIGNMENT.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Alternative Company Code (Payment Advice Management)
  • Client
  • Alternative Company Code (Payment Advice Management)
  • I_PAYTADVICEITEMFROMASSIGNMENT.MANDT == T001.MANDT
  • I_PAYTADVICEITEMFROMASSIGNMENT.ALTERNATIVECOMPANYCODE == T001.BUKRS
Company Code
  • Company Code
  • Client
  • I_PAYTADVICEITEMFROMASSIGNMENT.COMPANYCODE == T001.BUKRS
  • I_PAYTADVICEITEMFROMASSIGNMENT.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • I_PAYTADVICEITEMFROMASSIGNMENT.MANDT == TCURC.MANDT
  • I_PAYTADVICEITEMFROMASSIGNMENT.CURRENCY == TCURC.WAERS
Customer Number
  • Client
  • Customer Number
  • I_PAYTADVICEITEMFROMASSIGNMENT.MANDT == KNA1.MANDT
  • I_PAYTADVICEITEMFROMASSIGNMENT.CUSTOMER == KNA1.KUNNR
Posting Key
  • Client
  • Posting Key
  • I_PAYTADVICEITEMFROMASSIGNMENT.MANDT == TBSL.MANDT
  • I_PAYTADVICEITEMFROMASSIGNMENT.POSTINGKEY == TBSL.BSCHL
Special G/L Indicator
  • Client
  • Special G/L Indicator
  • ?
  • I_PAYTADVICEITEMFROMASSIGNMENT.MANDT == T074U.MANDT
  • I_PAYTADVICEITEMFROMASSIGNMENT.SPECIALGLCODE == T074U.UMSKZ
  • I_PAYTADVICEITEMFROMASSIGNMENT.[column in domain "KOART"] == T074U.KOART