P_PaymentAdviceItem

Payment Advice Item | view: PPAYTADVCITM | Extraction: Not supported | Component: Fiori FXU Accounts Receivable FI-FIO-AR
Tables used: AVIPBSEGTGSBTGSBTT001TKA02T005T053RT053ST001T014
Column Name Description
CompanyCode FK Company Code
PaymentAdviceAccountType Payment Advice Account Type Show values
PaymentAdviceAccount Customer ID
PaymentAdvice Payment Advice Number
PaymentAdviceItem Payment Advice Item
Column Name Description
💲 Currency Key (Currency):
TaxAmountInCoCodeCrcy Tax Amount in Local Currency
GrossAmountInPaymentCurrency Gross Amount
NetPaymentAmountInPaytCurrency Net Payment Amount with +/- Sign
CashDiscountAmountInPaytCrcy Cash Discount Amount with +/- Sign
DifferenceAmountInCoCodeCrcy Amount Difference in Local Currency
DeductionAmountInPaytCurrency Deduction Amount
💲 Currency Key (CompanyCodeCurrency):
DifferenceAmount Amount Difference in Foreign Currency
💲 Additional Currency 1 (AdditionalCurrency1):
DiffAmtInAdditionalCurrency1 Amount Difference in Second Local Currency
💲 Additional Currency 2 (AdditionalCurrency2):
DiffAmtInAdditionalCurrency2 Amount Difference in Third Local Currency
Column Name Description
Column Name Description
AccountingDocumentCreationDate Journal Entry Date
InvoiceDate Document Date
Column Name Description
PaymentAdviceAccountType Payment Advice Account Type Show values
PaymentAdviceAltvAccountType Account Type Show values
ItemIsActivated Indicator: Items Activated? Show values
CashDiscountIsActivated Flag whether Cash Discount is Active Show values
IsPartialPayment Indicator: Partial Payments Show values
PaytDiffRsdlBalIsCarriedFwd Indicator: Carryforward Residual Bal. for Payt Difference? Show values
IsPostedOnAccount Indicator: Posting on Account Show values
Column Name Description Domain name
PaymentAdviceAltvAccount Alternative Account (Payment Advice Management) KTONR
AccountingDocument Document BELNR
DocumentReferenceID Reference Document XBLNR1
BillingDocument Billing Document VBELN
BranchAccount Account Number of the Branch MAXKK
BusinessAreaName Business Area Description TEXT30
AssignmentReference Assignment number ZUONR
PaytDifferenceReasonExtCode External Reason Code for Payment Differences CHAR3
DocumentItemText Item Description TEXT50
FiscalYear Fiscal Year GJAHR
AccountingDocumentItem Posting View Item BUZEI
CashDiscountPercent Selected Cash Discount Percentage Rate PRZ23
CashDiscountDays Selected cash discount days ZBDXT
PaymentDifferenceReasonName Reason Code Short Text TXT20
PaymentDifferenceReasonDesc Payment Difference Reason Code Description TXT40
Reference1IDByBusinessPartner Business Partner Reference Key 1 CHAR12
Reference2IDByBusinessPartner Business Partner Reference Key 2 CHAR12
DeliveryDocument Delivery VBELN
PurchasingDocReferenceByCust Customer Reference BSTNK
PaymentAdviceStatus Payment Advice Status CHAR1
PaymentReference Payment Reference CHAR30
Master Data Relations Join Conditions
Alternative Company Code (Payment Advice Management)
  • Alternative Company Code (Payment Advice Management)
  • Client
  • P_PAYMENTADVICEITEM.ALTERNATIVECOMPANYCODE == T001.BUKRS
  • P_PAYMENTADVICEITEM.MANDT == T001.MANDT
Business Area
  • Business Area
  • Client
  • P_PAYMENTADVICEITEM.BUSINESSAREA == TGSB.GSBER
  • P_PAYMENTADVICEITEM.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • P_PAYMENTADVICEITEM.COMPANYCODE == T001.BUKRS
  • P_PAYMENTADVICEITEM.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • P_PAYMENTADVICEITEM.CURRENCY == TCURC.WAERS
  • P_PAYMENTADVICEITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • P_PAYMENTADVICEITEM.MANDT == TCURC.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • P_PAYMENTADVICEITEM.CURRENCY == TCURC.WAERS
  • P_PAYMENTADVICEITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • P_PAYMENTADVICEITEM.MANDT == TCURC.MANDT
Reason Code for Payments
  • Reason Code for Payments
  • Alternative Company Code (Payment Advice Management)
  • Client
  • P_PAYMENTADVICEITEM.PAYMENTDIFFERENCEREASON == T053R.RSTGR
  • P_PAYMENTADVICEITEM.ALTERNATIVECOMPANYCODE == T053R.BUKRS
  • P_PAYMENTADVICEITEM.MANDT == T053R.MANDT
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • P_PAYMENTADVICEITEM.[column in domain "KVEWE"] == T683.KVEWE
  • P_PAYMENTADVICEITEM.[column in domain "KAPPL"] == T683.KAPPL
  • P_PAYMENTADVICEITEM.TAXCALCULATIONPROCEDURE == T683.KALSM
  • P_PAYMENTADVICEITEM.MANDT == T683.MANDT
Tax on sales/purchases code
  • Tax on sales/purchases code
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • P_PAYMENTADVICEITEM.TAXCODE == T007A.MWSKZ
  • P_PAYMENTADVICEITEM.TAXCALCULATIONPROCEDURE == T007A.KALSM
  • P_PAYMENTADVICEITEM.MANDT == T007A.MANDT