C_PaytMediaItem

Payment Media Item | view: CPAYTMEDIAITM | Extraction: Not supported | Component: Payment Progam / Payment transfer (DE, JP, US)
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 Amount Paid in Foreign Currency
💲 Currency Key (Currency):
AmountInCompanyCodeCurrency Amount Paid in Local Currency
💲 Currency Key (CompanyCodeCurrency):
PaytAmountInCoCodeCurrency Amount Paid in Local Currency
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
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
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
PaymentSystemText Payment System Text PAYMENT_SYSTEM_TEXT
AliasTypeText Alias Type Text ALIAS_TYPE_TEXT
BankKey Bank Keys BANKK
HouseBank Short Key for a House Bank HBKID
HouseBankAccount ID for Account Details HKTID
HouseBankAccountDescription Account Description TEXT60
HouseBankIBAN IBAN at Our House Bank IBAN
BankInternalID Bank Keys BANKK
HouseBankName Name of Financial Institution TEXT60
CityName City TEXT35
StreetName Street and House Number TEXT35
PaymentMediumStatus null
BankCountryName Country/Region Name TEXT50
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
PaymentMethodName Payment Method Name TEXT30
PaymentAdvice Payment Advice Number AVSID
ScheduledByUser Initiator of job/step scheduling CHAR12
SupplierBasicAuthorizationGrp Authorization Group BRGRU
CustomerBasicAuthorizationGrp Authorization Group BRGRU
Master Data Relations Join Conditions
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • C_PAYTMEDIAITEM.BANKCOUNTRY == T005.LAND1
  • C_PAYTMEDIAITEM.MANDT == T005.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Currency Key
  • Currency for Automatic Payment
  • Client
  • C_PAYTMEDIAITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • C_PAYTMEDIAITEM.CURRENCY == TCURC.WAERS
  • C_PAYTMEDIAITEM.HOUSEBANKCURRENCY == TCURC.WAERS
  • C_PAYTMEDIAITEM.PAYMENTCURRENCY == TCURC.WAERS
  • C_PAYTMEDIAITEM.MANDT == TCURC.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Currency Key
  • Currency for Automatic Payment
  • Client
  • C_PAYTMEDIAITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • C_PAYTMEDIAITEM.CURRENCY == TCURC.WAERS
  • C_PAYTMEDIAITEM.HOUSEBANKCURRENCY == TCURC.WAERS
  • C_PAYTMEDIAITEM.PAYMENTCURRENCY == TCURC.WAERS
  • C_PAYTMEDIAITEM.MANDT == TCURC.MANDT
Customer Number
  • Customer Number
  • Client
  • C_PAYTMEDIAITEM.CUSTOMER == KNA1.KUNNR
  • C_PAYTMEDIAITEM.MANDT == KNA1.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Currency Key
  • Currency for Automatic Payment
  • Client
  • C_PAYTMEDIAITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • C_PAYTMEDIAITEM.CURRENCY == TCURC.WAERS
  • C_PAYTMEDIAITEM.HOUSEBANKCURRENCY == TCURC.WAERS
  • C_PAYTMEDIAITEM.PAYMENTCURRENCY == TCURC.WAERS
  • C_PAYTMEDIAITEM.MANDT == TCURC.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • C_PAYTMEDIAITEM.MANDT == T005.MANDT
  • C_PAYTMEDIAITEM.PAYEEBANKCOUNTRY == T005.LAND1
Paying Company Code
  • Client
  • Paying Company Code
  • C_PAYTMEDIAITEM.MANDT == T001.MANDT
  • C_PAYTMEDIAITEM.PAYINGCOMPANYCODE == T001.BUKRS
Currency for Automatic Payment
  • Currency Key
  • Currency Key
  • Currency Key
  • Currency for Automatic Payment
  • Client
  • C_PAYTMEDIAITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • C_PAYTMEDIAITEM.CURRENCY == TCURC.WAERS
  • C_PAYTMEDIAITEM.HOUSEBANKCURRENCY == TCURC.WAERS
  • C_PAYTMEDIAITEM.PAYMENTCURRENCY == TCURC.WAERS
  • C_PAYTMEDIAITEM.MANDT == TCURC.MANDT
Payment Method
  • Country/Region Key of Bank
  • Payment Method
  • Client
  • C_PAYTMEDIAITEM.BANKCOUNTRY == T042Z.LAND1
  • C_PAYTMEDIAITEM.PAYMENTMETHOD == T042Z.ZLSCH
  • C_PAYTMEDIAITEM.MANDT == T042Z.MANDT
Supplier
  • Supplier
  • Client
  • C_PAYTMEDIAITEM.SUPPLIER == LFA1.LIFNR
  • C_PAYTMEDIAITEM.MANDT == LFA1.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • C_PAYTMEDIAITEM.SUPPLIERCOUNTRY == T005.LAND1
  • C_PAYTMEDIAITEM.MANDT == T005.MANDT
Regional code of the payee
  • ?
  • Regional code of the payee
  • Client
  • C_PAYTMEDIAITEM.[column in domain "LAND1"] == T005S.LAND1
  • C_PAYTMEDIAITEM.SUPPLIERREGION == T005S.BLAND
  • C_PAYTMEDIAITEM.MANDT == T005S.MANDT