P_PaymentAdvice

Payment Advice Header | view: PPAYTADVC | Extraction: Not supported | Component: Fiori FXU Accounts Receivable FI-FIO-AR
Tables used: AVIKT001TKA02KNA1KNB1KNB5T053AT053BT053VT053WADCPADR2ADR3ADR6ADRPUSR21
Column Name Description
CompanyCode FK Company Code
PaymentAdviceAccountType Payment Advice Account Type Show values
PaymentAdviceAccount Customer ID
PaymentAdvice Payment Advice Number
Column Name Description
💲 Payment Currency Key (PaymentCurrency):
PaidAmountInPaytCurrency Payment Amount from the Payment Advice Header
CashDiscountAmountInPaytCrcy Cash Discount Amount
Column Name Description
Column Name Description
PaymentDate Payment Date
CreationDate Date on which the record was created
LastChangeDate Last Changed On
CreationTime Time of Entry
Column Name Description
PaymentAdviceAccountType Payment Advice Account Type Show values
PaymentAdviceType Payment Advice Type Show values
Column Name Description Domain name
PaymentAdviceUUID Payment advice UUID OBJKY
PaymentDocument Payment Document Number BELNR
AccountByShipper Payee's Account at the Customer CHAR12
PartnerBank Bank Number of the Payee BANKL
PartnerBankAccount Bank Account Number of the Payee BANKN
PartnerBankCountry Country/Region Key of Partner Bank LAND1
PartnerBankSWIFTCode SWIFT Code of Partner Bank SWIFT
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
PaymentAdviceHeaderText Payment Advice Header Text TEXT25
PaymentAdviceTypeName Short Text for Fixed Values DDTEXT
PaymentAdviceStatus Payment Advice Status CHAR1
PaytAdvcDiffDetnRuleDesc Reason Code Conversion Version Name TXT30
PaytAdviceSelectionRuleDesc Text (25, obsolete)
OriginalReferenceDocument Reference Key AWKEY
FullName Full Name of Person TEXT80
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
CompanyCodeName Name of Company Code or Company TEXT25
Customer Account Number KTONR
BankReference Payment Reference CHAR35
BusinessPartnerName Extracted Customer Name CHAR55
Master Data Relations Join Conditions
Accounting Clerk
  • Accounting Clerk
  • Company Code
  • Client
  • P_PAYMENTADVICE.ACCOUNTINGCLERK == T001S.BUSAB
  • P_PAYMENTADVICE.COMPANYCODE == T001S.BUKRS
  • P_PAYMENTADVICE.MANDT == T001S.MANDT
Company Code
  • Company Code
  • Client
  • P_PAYMENTADVICE.COMPANYCODE == T001.BUKRS
  • P_PAYMENTADVICE.MANDT == T001.MANDT
Selection Rule for Payment Advices
  • Client
  • Selection Rule for Payment Advices
  • P_PAYMENTADVICE.MANDT == T053A.MANDT
  • P_PAYMENTADVICE.PAYMENTADVICESELECTIONRULE == T053A.SREGL
Payment Currency Key
  • Payment Currency Key
  • Client
  • P_PAYMENTADVICE.PAYMENTCURRENCY == TCURC.WAERS
  • P_PAYMENTADVICE.MANDT == TCURC.MANDT
Reason Code Conversion Version
  • Reason Code Conversion Version
  • Client
  • P_PAYMENTADVICE.PAYTADVCDIFFDETERMINATIONRULE == T053V.VRSDG
  • P_PAYMENTADVICE.MANDT == T053V.MANDT