C_PaymentProposalHeader

Payment Proposal Header | view: CPAYTHEADER | Extraction: Not supported | Component: Payment Progam / Payment transfer (DE, JP, US)
Tables used: REGUP, REGUH, REGUH, T001, TKA02, T005, T005T, KNA1, FINSC_LEDGER, T042, T042Z, T042ZT, T042H, FARP_PAYT_RSN_T, FARP_PAYT_RSN_TX, LFA1, FCLM_BAM_ACLINK2, FCLM_BAM_AMD, T012K, FCLM_BAM_ACLINK2, FCLM_BAM_AMD, FCLM_BAM_AMD_T, T042ZT, 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
AmountInTransactionCurrency Gross Amount in Foreign Currency
WhldgTaxAmtInTransacCrcy Withholding Tax in Foreign Currency
TotDeductionAmtInTransacCrcy Total Deductions in Foreign Currency
NetAmountInTransacCurrency Net Amount in Foreign Currency
💲 Currency Key (Currency):
AmountInCompanyCodeCurrency Amount Paid in Local Currency
CashDiscountAmtInCoCodeCrcy Cash Discounts in Local Currency
LostCashDiscountInCoCodeCrcy Lost Cash Discounts in Local Currency
HeaderAmtInCoCodeCurrency Gross Amount in Local Currency
WhldgTaxAmtInCoCodeCrcy Withholding Tax in Local Currency
TotDeductionAmtInCoCodeCrcy Total Deductions in Local Currency
NetAmountInCoCodeCurrency Net Amount 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
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
FinancialAccountType Account Type 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
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
HouseBankAccountDescription Account Description TEXT60
HouseBankName Name of Financial Institution TEXT60
Branch Bank Branch TEXT40
CompanyCodeName Name of Company Code or Company TEXT25
CountryName Country/Region Name TEXT50
PayableToleranceDays Tolerance Days for Payables NUM02
PaymentMethodName Description of Payment Method in Logon Language TEXT30
AdditionalPaymentMethod Name of the Payment Method Supplement TEXT30
PaymentReasonText Payment Reason Description CHAR130
BankName Name of Financial Institution TEXT60
BranchCode Bank Branch TEXT40
CityName City TEXT35
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
PaymentSystemText Payment System Text PAYMENT_SYSTEM_TEXT
AliasTypeText Alias Type Text ALIAS_TYPE_TEXT
SupplierBasicAuthorizationGrp Authorization Group BRGRU
CustomerBasicAuthorizationGrp Authorization Group BRGRU
Master Data Relations Join Conditions
Accounting Clerk
  • Sending Company Code
  • Accounting Clerk
  • Client
  • C_PAYMENTPROPOSALHEADER.SENDINGCOMPANYCODE == T001S.BUKRS
  • C_PAYMENTPROPOSALHEADER.ACCOUNTINGCLERK == T001S.BUSAB
  • C_PAYMENTPROPOSALHEADER.MANDT == T001S.MANDT
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • C_PAYMENTPROPOSALHEADER.BANKCOUNTRY == T005.LAND1
  • C_PAYMENTPROPOSALHEADER.MANDT == T005.MANDT
Business Area
  • Business Area
  • Client
  • C_PAYMENTPROPOSALHEADER.BUSINESSAREA == TGSB.GSBER
  • C_PAYMENTPROPOSALHEADER.MANDT == TGSB.MANDT
Currency Key
  • Functional Currency
  • Currency for Automatic Payment
  • Currency Key
  • Client
  • C_PAYMENTPROPOSALHEADER.FUNCTIONALCURRENCY == TCURC.WAERS
  • C_PAYMENTPROPOSALHEADER.PAYMENTCURRENCY == TCURC.WAERS
  • C_PAYMENTPROPOSALHEADER.CURRENCY == TCURC.WAERS
  • C_PAYMENTPROPOSALHEADER.MANDT == TCURC.MANDT
Customer Number
  • Customer Number
  • Client
  • C_PAYMENTPROPOSALHEADER.CUSTOMER == KNA1.KUNNR
  • C_PAYMENTPROPOSALHEADER.MANDT == KNA1.MANDT
Customer Account Group
  • Customer Account Group
  • Client
  • C_PAYMENTPROPOSALHEADER.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • C_PAYMENTPROPOSALHEADER.MANDT == T077D.MANDT
Short Key for a House Bank
  • Paying Company Code
  • Short Key for a House Bank
  • Client
  • C_PAYMENTPROPOSALHEADER.PAYINGCOMPANYCODE == T012.BUKRS
  • C_PAYMENTPROPOSALHEADER.HOUSEBANK == T012.HBKID
  • C_PAYMENTPROPOSALHEADER.MANDT == T012.MANDT
ID for Account Details
  • ID for Account Details
  • Paying Company Code
  • Short Key for a House Bank
  • Client
  • C_PAYMENTPROPOSALHEADER.HOUSEBANKACCOUNT == T012K.HKTID
  • C_PAYMENTPROPOSALHEADER.PAYINGCOMPANYCODE == T012K.BUKRS
  • C_PAYMENTPROPOSALHEADER.HOUSEBANK == T012K.HBKID
  • C_PAYMENTPROPOSALHEADER.MANDT == T012K.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • C_PAYMENTPROPOSALHEADER.MANDT == T005.MANDT
  • C_PAYMENTPROPOSALHEADER.PAYEEBANKCOUNTRY == T005.LAND1
Country/Region Key
  • Client
  • Country/Region Key
  • C_PAYMENTPROPOSALHEADER.MANDT == T005.MANDT
  • C_PAYMENTPROPOSALHEADER.PAYEECOUNTRY == T005.LAND1
Language key of the payee C_PAYMENTPROPOSALHEADER.PAYEELANGUAGE == T002.SPRAS
Paying Company Code
  • Paying Company Code
  • Client
  • C_PAYMENTPROPOSALHEADER.PAYINGCOMPANYCODE == T001.BUKRS
  • C_PAYMENTPROPOSALHEADER.MANDT == T001.MANDT
Currency for Automatic Payment
  • Functional Currency
  • Currency for Automatic Payment
  • Currency Key
  • Client
  • C_PAYMENTPROPOSALHEADER.FUNCTIONALCURRENCY == TCURC.WAERS
  • C_PAYMENTPROPOSALHEADER.PAYMENTCURRENCY == TCURC.WAERS
  • C_PAYMENTPROPOSALHEADER.CURRENCY == TCURC.WAERS
  • C_PAYMENTPROPOSALHEADER.MANDT == TCURC.MANDT
Payment Method for This Payment
  • Payment Method for This Payment
  • Country/Region Key
  • Client
  • C_PAYMENTPROPOSALHEADER.PAYMENTMETHOD == T042Z.ZLSCH
  • C_PAYMENTPROPOSALHEADER.SUPPLIERCOUNTRY == T042Z.LAND1
  • C_PAYMENTPROPOSALHEADER.MANDT == T042Z.MANDT
Payment Method Supplement
  • Payment Method Supplement
  • Client
  • C_PAYMENTPROPOSALHEADER.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE
  • C_PAYMENTPROPOSALHEADER.MANDT == T042F.MANDT
Payment Reason
  • Client
  • Payment Reason
Sending Company Code
  • Sending Company Code
  • Client
  • C_PAYMENTPROPOSALHEADER.SENDINGCOMPANYCODE == T001.BUKRS
  • C_PAYMENTPROPOSALHEADER.MANDT == T001.MANDT
Supplier
  • Supplier
  • Client
  • C_PAYMENTPROPOSALHEADER.SUPPLIER == LFA1.LIFNR
  • C_PAYMENTPROPOSALHEADER.MANDT == LFA1.MANDT
Vendor account group
  • Vendor account group
  • Client
  • C_PAYMENTPROPOSALHEADER.SUPPLIERACCOUNTGROUP == T077K.KTOKK
  • C_PAYMENTPROPOSALHEADER.MANDT == T077K.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • C_PAYMENTPROPOSALHEADER.SUPPLIERCOUNTRY == T005.LAND1
  • C_PAYMENTPROPOSALHEADER.MANDT == T005.MANDT