I_PaytMediaItem

Payment Media Item | view: IPAYTMEDIAITM | Extraction: Not supported | Component: Payment Progam / Payment transfer (DE, JP, US)
Tables used: DFPAYG, REGUT, REGUH, T001, TKA02, KNA1, FINSC_LEDGER, TFCUPM042F, TFPM042F, FCLM_BAM_ACLINK2, FCLM_BAM_AMD, T012K, FINSC_ACTVE_APPL, FINSC_LD_CMP
Column Name Description
PaymentRunDate Auto Payment Run Date
PaymentRunID Auto Payment Run ID
PayingCompanyCode FK Paying Company Code
PaymentRunIsProposal Auto Payment Is Proposal Show values
PaymentDocument Payment Document Number
Supplier FK Supplier
Customer FK Customer Number
Column Name Description
💲 Currency for Automatic Payment (PaymentCurrency):
PaidAmountInPaytCurrency null
💲 Currency Key (Currency):
AmountInCompanyCodeCurrency null
💲 Currency Key (CompanyCodeCurrency):
PaytAmountInCoCodeCurrency null
Column Name Description
Column Name Description
PostingDate Posting Date of Payment Document
PaidItemDueDate Due Date
ValueDate Value date
CreationDate File Creation Date
Column Name Description
PaymentRunIsProposal Auto Payment Is Proposal Show values
PaymentOrigin Grouping Criterion for Payments Show values
Column Name Description Domain name
SupplierName null
CustomerName Name of Customer TEXT80
ExchangeRate null
PostalCode Postal Code PSTLZ
SupplierCityName City TEXT35
StreetAddressName Street and House Number TEXT35
PayeeBank Bank number of the payee's bank BANKL
BankName Name of Financial Institution TEXT60
PayeeName Name of the payee TEXT35
PayeeBankAccount Bank account number of the payee BANKN
PayeeBankAccountLongID Payee's Bank Account Number BANKN35
PayeeBankInternalID Bank key of the payee's bank BANKK
PayeeIBAN IBAN of the Payee IBAN
SWIFTCode SWIFT/BIC for International Payments SWIFT
PayeePaymentSystem Payee Payment System PAYMENT_SYSTEM
PayeeAliasType Payee Alias Type ALIAS_TYPE
PayeeAliasName Payee Alias BANK_ALIAS
HouseBank Short Key for a House Bank HBKID
HouseBankAccount ID for Account Details HKTID
BankKey Bank Keys BANKK
HouseBankIBAN IBAN at Our House Bank IBAN
PaymentMediumStatus null
CreatedByUser Name of the User Who Created the TemSe File UNAME
PaymentMediumReference Reference Number TEXT16
PaymentMediumFormat Payment Medium Format FORMI_FPM
CompanyCodeName Name of Company Code or Company TEXT25
ApplicationJobName null
PaymentAdvice null
Master Data Relations Join Conditions
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • I_PAYTMEDIAITEM.BANKCOUNTRY == T005.LAND1
  • I_PAYTMEDIAITEM.MANDT == T005.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Currency Key
  • Currency for Automatic Payment
  • Client
  • I_PAYTMEDIAITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PAYTMEDIAITEM.CURRENCY == TCURC.WAERS
  • I_PAYTMEDIAITEM.HOUSEBANKCURRENCY == TCURC.WAERS
  • I_PAYTMEDIAITEM.PAYMENTCURRENCY == TCURC.WAERS
  • I_PAYTMEDIAITEM.MANDT == TCURC.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Currency Key
  • Currency for Automatic Payment
  • Client
  • I_PAYTMEDIAITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PAYTMEDIAITEM.CURRENCY == TCURC.WAERS
  • I_PAYTMEDIAITEM.HOUSEBANKCURRENCY == TCURC.WAERS
  • I_PAYTMEDIAITEM.PAYMENTCURRENCY == TCURC.WAERS
  • I_PAYTMEDIAITEM.MANDT == TCURC.MANDT
Customer Number
  • Customer Number
  • Client
  • I_PAYTMEDIAITEM.CUSTOMER == KNA1.KUNNR
  • I_PAYTMEDIAITEM.MANDT == KNA1.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Currency Key
  • Currency for Automatic Payment
  • Client
  • I_PAYTMEDIAITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PAYTMEDIAITEM.CURRENCY == TCURC.WAERS
  • I_PAYTMEDIAITEM.HOUSEBANKCURRENCY == TCURC.WAERS
  • I_PAYTMEDIAITEM.PAYMENTCURRENCY == TCURC.WAERS
  • I_PAYTMEDIAITEM.MANDT == TCURC.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • I_PAYTMEDIAITEM.PAYEEBANKCOUNTRY == T005.LAND1
  • I_PAYTMEDIAITEM.MANDT == T005.MANDT
Paying Company Code
  • Paying Company Code
  • Client
  • I_PAYTMEDIAITEM.PAYINGCOMPANYCODE == T001.BUKRS
  • I_PAYTMEDIAITEM.MANDT == T001.MANDT
Currency for Automatic Payment
  • Currency Key
  • Currency Key
  • Currency Key
  • Currency for Automatic Payment
  • Client
  • I_PAYTMEDIAITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PAYTMEDIAITEM.CURRENCY == TCURC.WAERS
  • I_PAYTMEDIAITEM.HOUSEBANKCURRENCY == TCURC.WAERS
  • I_PAYTMEDIAITEM.PAYMENTCURRENCY == TCURC.WAERS
  • I_PAYTMEDIAITEM.MANDT == TCURC.MANDT
Payment Method
  • Payment Method
  • Country/Region Key of Bank
  • Client
  • I_PAYTMEDIAITEM.PAYMENTMETHOD == T042Z.ZLSCH
  • I_PAYTMEDIAITEM.BANKCOUNTRY == T042Z.LAND1
  • I_PAYTMEDIAITEM.MANDT == T042Z.MANDT
Supplier
  • Supplier
  • Client
  • I_PAYTMEDIAITEM.SUPPLIER == LFA1.LIFNR
  • I_PAYTMEDIAITEM.MANDT == LFA1.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • I_PAYTMEDIAITEM.SUPPLIERCOUNTRY == T005.LAND1
  • I_PAYTMEDIAITEM.MANDT == T005.MANDT
Regional code of the payee
  • Regional code of the payee
  • ?
  • Client
  • I_PAYTMEDIAITEM.SUPPLIERREGION == T005S.BLAND
  • I_PAYTMEDIAITEM.[column in domain "LAND1"] == T005S.LAND1
  • I_PAYTMEDIAITEM.MANDT == T005S.MANDT