I_PaymentProposalHeader

Payment Header | view: IPAYTPRPSLHDR | Extraction: Not supported | Component: Payment Progam / Payment transfer (DE, JP, US)
Tables used: REGUH, T001, TKA02, FINSC_LEDGER, FINSC_ACTVE_APPL, FINSC_LD_CMP
Column Name Description
PaymentRunDate Auto Payment Run Date
PaymentRunID Auto Payment Run ID
PaymentRunIsProposal Auto Payment Is Proposal Show values
PayingCompanyCode FK Paying Company Code
Supplier FK Supplier
Customer FK Customer Number
PaymentRecipient Payment Recipient
PaymentDocument Payment Document Number
Column Name Description
💲 Currency for Automatic Payment (PaymentCurrency):
PaidAmountInPaytCurrency Amount Paid in Foreign Currency
CashDiscountAmtInTransacCrcy Cash Discounts in Foreign Currency
LostCashDiscountInTransacCrcy Lost Cash Discounts in Foreign Currency
💲 Currency Key (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount Paid in Local Currency
CashDiscountAmtInCoCodeCrcy Cash Discounts in Local Currency
LostCashDiscountInCoCodeCrcy Lost Cash Discounts in Local Currency
💲 Functional Currency (FunctionalCurrency):
PaymentAmountInFunctionalCrcy Payment Amount in Functional Currency
CashDiscountAmountInFuncnlCrcy Cash Discount in Functional Currency
Column Name Description
Column Name Description
PaidItemDueDate Due Date
PostingDate Posting Date of Payment Document
ValueDate Value date
BillOfExchangeIssueDate Bill of Exchange Issue Date
BillOfExchangeDueDate Bill of Exchange Due Date
Column Name Description
PaymentRunIsProposal Auto Payment Is Proposal Show values
EDIPaymentOrderStatus EDI Payment Order Status Show values
EDIPaymentAdviceStatus EDI Payment Advice Status Show values
DirectDebitType Local Instrument Code Show values
SEPASequenceType SEPA: Sequence Type Show values
PaymentOrigin Grouping Criterion for Payments Show values
BankChainBank1Type Type of Bank 1 in a Bank Chain (Correspondent, Intermediary) Show values
BankChainBank2Type Type of Bank 2 in a Bank Chain (Correspondent, Intermediary) Show values
BankChainBank3Type Type of Bank 3 in a Bank Chain (Correspondent, Intermediary) Show values
Column Name Description Domain name
SupplierClerkIDBySupplier Shipper Account CHAR12
BankAccountHolderName Account Holder Name KOINH
PayeeBankControlKey Bank Control Key of the Payee's Bank BKONT
BankControlKey Bank control key at our bank BKONT
PayeeBankInternalID Bank key of the payee's bank BANKK
PayeeBank Bank number of the payee's bank BANKL
SupplierCityName City TEXT35
PayeeCityName City of the payee TEXT35
District Location from payee's address TEXT35
PaymentRequestPaymentGroup Grouping Field for Automatic Payments CHAR20
BankInternalID Bank Key of Our Bank BANKK
Bank Bank number of our bank BANKL
HouseBankIBAN IBAN at Our House Bank IBAN
PayeeIBAN IBAN of the Payee IBAN
DataExchangeInstructionKey Instruction Key for Data Medium Exchange DTAWS
DataExchangeInstruction1 Instruction Key 1 DTWSX
DataExchangeInstruction2 Instruction Key 2 DTWSX
DataExchangeInstruction3 Instruction key 3 DTWSX
DataExchangeInstruction4 Instruction key 4 DTWSX
SupplierName Name 1 NAME
SupplierAdditionalName Name 2 NAME
CustomerName Name 1 NAME
CustomerAdditionalName Name 2 NAME
PayeeName Name of the payee TEXT35
PayeeAdditionalName Name of the payee TEXT35
PayeeTitle Title of the payee TEXT15
AddressID Address Number AD_ADDRNUM
NumberOfTextLines Number of Text Lines for Items Paid PACK3
NumberOfPaidItems Item Included PACK3
BankAccount Our account number at the bank BANKN
BankAccountLongID Bank Account Number BANKN35
POBoxDeviatingCityName City of payee's PO box TEXT35
POBoxPostalCode P.O. Box Postal Code PSTLZ
PayeePOBoxPostalCode P.O. box postal code of the payee PSTLZ
PayeePostalCode Postal Code of the Payee PSTLZ
PayeeBankAccount Bank account number of the payee BANKN
PayeeBankAccountLongID Payee's Bank Account Number BANKN35
PayeePOBox P.O. box of the payee PFACH
PayeeStreet Street and house number of the payee TEXT35
PaymentReference Payment Reference CHAR30
PersonnelNumber Personnel Number PERNR
POBox PO Box PFACH
PostalCode Postal Code PSTLZ
BankAccountReferenceText Reference Details for Bank Details CHAR20
Region Region (State, Province, County) REGIO
PaymentOrder Payment Order PYORD
StreetAddressName Street and House Number TEXT35
SWIFTCode SWIFT/BIC for International Payments SWIFT
SEPAMandateUUID SEPA Mandate: GUID of Mandate
ExchangeRate Exchange Rate FIS_UKURS
BankPaymentGroupingOrigin Payment Media Origin FIBL_ORIGIN
SWIFTTransactionReferenceUUID Unique Transaction Reference (UETR) SMUM_C36
BusinessPlace Business Place J_1BBRANCH
BankChainBank1Country Country/Region Key of Bank 1 in a Bank Chain LAND1
BankChainBank1 Bank Key of Bank 1 in a Bank Chain BANKK
BankChainBank1BankAccount Bank Account Number of Bank 1 in a Bank Chain BANKN
BankChainBank1ControlKey Bank Control Key of Bank 1 in a Bank Chain BKONT
BankChainBank1DetailReference Reference Specifications for Bank Details of Bank 1 CHAR20
BankChainBank1IBAN International Bank Account Number of Bank 1 in a Bank Chain IBAN
BankChainBank2Country Country/Region Key of Bank 2 in a Bank Chain LAND1
BankChainBank2 Bank Key of Bank 2 in a Bank Chain BANKK
BankChainBank2BankAccount Bank Account Number of Bank 2 in a Bank Chain BANKN
BankChainBank2ControlKey Bank Control Key of Bank 2 in a Bank Chain BKONT
BankChainBank2DetailReference Reference Specifications for Bank Details of Bank 2 CHAR20
BankChainBank2IBAN International Bank Account Number of Bank 2 in a Bank Chain IBAN
BankChainBank3Country Country/Region Key of Bank 3 in a Bank Chain LAND1
BankChainBank3 Bank Key of Bank 3 in a Bank Chain BANKK
BankChainBank3BankAccount Bank Account Number of Bank 3 in a Bank Chain BANKN
BankChainBank3ControlKey Bank Control Key of Bank 3 in a Bank Chain BKONT
BankChainBank3DetailReference Reference Specifications for Bank Details of Bank 3 CHAR20
BankChainBank3IBAN International Bank Account Number of Bank 3 in a Bank Chain IBAN
PayeePaymentSystem Payee Payment System PAYMENT_SYSTEM
PayeeAliasType Payee Alias Type ALIAS_TYPE
PayeeAliasName Payee Alias BANK_ALIAS
Master Data Relations Join Conditions
Accounting Clerk
  • Accounting Clerk
  • Client
  • Sending Company Code
  • I_PAYMENTPROPOSALHEADER.ACCOUNTINGCLERK == T001S.BUSAB
  • I_PAYMENTPROPOSALHEADER.MANDT == T001S.MANDT
  • I_PAYMENTPROPOSALHEADER.SENDINGCOMPANYCODE == T001S.BUKRS
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • I_PAYMENTPROPOSALHEADER.MANDT == T005.MANDT
  • I_PAYMENTPROPOSALHEADER.BANKCOUNTRY == T005.LAND1
Business Area
  • Client
  • Business Area
  • I_PAYMENTPROPOSALHEADER.MANDT == TGSB.MANDT
  • I_PAYMENTPROPOSALHEADER.BUSINESSAREA == TGSB.GSBER
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • I_PAYMENTPROPOSALHEADER.MANDT == T005.MANDT
  • I_PAYMENTPROPOSALHEADER.SUPPLIERCOUNTRY == T005.LAND1
  • I_PAYMENTPROPOSALHEADER.COUNTRY == T005.LAND1
Customer Number
  • Client
  • Customer Number
  • I_PAYMENTPROPOSALHEADER.MANDT == KNA1.MANDT
  • I_PAYMENTPROPOSALHEADER.CUSTOMER == KNA1.KUNNR
Short Key for a House Bank
  • Client
  • Short Key for a House Bank
  • Paying Company Code
  • I_PAYMENTPROPOSALHEADER.MANDT == T012.MANDT
  • I_PAYMENTPROPOSALHEADER.HOUSEBANK == T012.HBKID
  • I_PAYMENTPROPOSALHEADER.PAYINGCOMPANYCODE == T012.BUKRS
ID for Account Details
  • Client
  • ID for Account Details
  • Short Key for a House Bank
  • Paying Company Code
  • I_PAYMENTPROPOSALHEADER.MANDT == T012K.MANDT
  • I_PAYMENTPROPOSALHEADER.HOUSEBANKACCOUNT == T012K.HKTID
  • I_PAYMENTPROPOSALHEADER.HOUSEBANK == T012K.HBKID
  • I_PAYMENTPROPOSALHEADER.PAYINGCOMPANYCODE == T012K.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • I_PAYMENTPROPOSALHEADER.MANDT == T005.MANDT
  • I_PAYMENTPROPOSALHEADER.PAYEEBANKCOUNTRY == T005.LAND1
Country/Region Key
  • Client
  • Country/Region Key
  • I_PAYMENTPROPOSALHEADER.MANDT == T005.MANDT
  • I_PAYMENTPROPOSALHEADER.PAYEECOUNTRY == T005.LAND1
Language key of the payee I_PAYMENTPROPOSALHEADER.PAYEELANGUAGE == T002.SPRAS
Paying Company Code
  • Client
  • Paying Company Code
  • I_PAYMENTPROPOSALHEADER.MANDT == T001.MANDT
  • I_PAYMENTPROPOSALHEADER.PAYINGCOMPANYCODE == T001.BUKRS
Currency for Automatic Payment
  • Client
  • Currency Key
  • Functional Currency
  • Currency for Automatic Payment
  • I_PAYMENTPROPOSALHEADER.MANDT == TCURC.MANDT
  • I_PAYMENTPROPOSALHEADER.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PAYMENTPROPOSALHEADER.FUNCTIONALCURRENCY == TCURC.WAERS
  • I_PAYMENTPROPOSALHEADER.PAYMENTCURRENCY == TCURC.WAERS
Payment Method for This Payment
  • Client
  • Payment Method for This Payment
  • Country/Region Key
  • Country/Region Key
  • I_PAYMENTPROPOSALHEADER.MANDT == T042Z.MANDT
  • I_PAYMENTPROPOSALHEADER.PAYMENTMETHOD == T042Z.ZLSCH
  • I_PAYMENTPROPOSALHEADER.SUPPLIERCOUNTRY == T042Z.LAND1
  • I_PAYMENTPROPOSALHEADER.COUNTRY == T042Z.LAND1
Payment Method Supplement
  • Client
  • Payment Method Supplement
  • I_PAYMENTPROPOSALHEADER.MANDT == T042F.MANDT
  • I_PAYMENTPROPOSALHEADER.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE
Payment Reason
  • Client
  • Payment Reason
Sending Company Code
  • Client
  • Sending Company Code
  • I_PAYMENTPROPOSALHEADER.MANDT == T001.MANDT
  • I_PAYMENTPROPOSALHEADER.SENDINGCOMPANYCODE == T001.BUKRS
Supplier
  • Client
  • Supplier
  • I_PAYMENTPROPOSALHEADER.MANDT == LFA1.MANDT
  • I_PAYMENTPROPOSALHEADER.SUPPLIER == LFA1.LIFNR
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • I_PAYMENTPROPOSALHEADER.MANDT == T005.MANDT
  • I_PAYMENTPROPOSALHEADER.SUPPLIERCOUNTRY == T005.LAND1
  • I_PAYMENTPROPOSALHEADER.COUNTRY == T005.LAND1
Regional code of the payee
  • Client
  • Regional code of the payee
  • Country/Region Key
  • I_PAYMENTPROPOSALHEADER.MANDT == T005S.MANDT
  • I_PAYMENTPROPOSALHEADER.SUPPLIERREGION == T005S.BLAND
  • I_PAYMENTPROPOSALHEADER.PAYEECOUNTRY == T005S.LAND1