R_PaymentProposalItem

Payment Proposal Item | view: RPAYTPRPSLITM | Extraction: Not supported | Component: Payment Progam / Payment transfer (DE, JP, US)
Tables used: REGUP, FINSC_LEDGER, FINSC_ACTVE_APPL, FINSC_LD_CMP
Column Name Description
PaymentRunDate Date on Which the Program Is to Be Run
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
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Currency for Automatic Payment (PaymentCurrency):
AmountInTransactionCurrency null
CashDiscountAmtInTransacCrcy null
WhldgTaxAmtInTransacCrcy null
TotDeductionAmtInTransacCrcy null
NetAmountInTransacCurrency null
MaxCshDiscAmtInTransacCrcy null
💲 Currency Key (CompanyCodeCurrency):
HeaderAmtInCoCodeCurrency null
CashDiscountAmtInCoCodeCrcy null
WhldgTaxAmtInCoCodeCrcy null
TotDeductionAmtInCoCodeCrcy null
NetAmountInCoCodeCurrency null
MaxCshDiscAmtInCoCodeCrcy null
💲 Additional Currency 1 (AdditionalCurrency1):
AmountInAdditionalCurrency1 null
CashDiscountAmtInAddlCrcy1 null
💲 Additional Currency 2 (AdditionalCurrency2):
AmountInAdditionalCurrency2 null
CashDiscountAmtInAddlCrcy2 null
Column Name Description
Column Name Description
PaymentRunDate Date on Which the Program Is to Be Run
DocumentDate Journal Entry Date
DueCalculationBaseDate Due Calculation Base Date
PostingDate Posting Date
Column Name Description
PaymentRunIsProposal Auto Payment Is Proposal Show values
DebitCreditCode Debit/Credit Code Show values
FinancialAccountType Account Type Show values
PaymentBlockLevel Level on Which a Payment Block has Taken Place Show values
Column Name Description Domain name
BranchAccount Branch Account MAXKK
PaymentTerms Terms of Payment Key ZTERM
PaymentRunItemMessageNumber Item Indicator CHAR3
AccountingDocExternalReference Reference Document XBLNR
PaymentReference Payment Reference CHAR30
AssetContract Asset Contract RANL
DocumentItemText Item Text TEXT50
AssignmentReference Assignment Reference ZUONR
TaxCode Tax on Sales/Purchases Code MWSKZ
CashDiscount1Days Cash Discount Days 1 ZBDXT
CashDiscount2Days Cash Discount Days 2 ZBDXT
CashDiscount1Percent Cash Discount Percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
BusinessPlace Business Place J_1BBRANCH
BPBankAccountInternalID Business Partner Bank Account Internal ID BVTYP
ProfitCenter Profit Center PRCTR
ConsideredPaymentMethods List of Respected Payment Methods ZWELS
Reference1IDByBusinessPartner ID of Reference 1 by Business Partner CHAR12
Reference2IDByBusinessPartner ID of Reference 2 by Business Partner CHAR12
Reference3IDByBusinessPartner ID of Reference 3 by Business Partner CHAR20
PaymentReason Payment Reason FARP_PAYT_RSN
SystemMessageNumber Message number MSGNR
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • R_PAYMENTPROPOSALITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • R_PAYMENTPROPOSALITEM.MANDT == T003.MANDT
Operational General Ledger Account
  • Company Code
  • Operational General Ledger Account
  • Client
  • R_PAYMENTPROPOSALITEM.COMPANYCODE == SKB1.BUKRS
  • R_PAYMENTPROPOSALITEM.BANKRECONCILIATIONACCOUNT == SKB1.SAKNR
  • R_PAYMENTPROPOSALITEM.MANDT == SKB1.MANDT
Business Area
  • Business Area
  • Client
  • R_PAYMENTPROPOSALITEM.BUSINESSAREA == TGSB.GSBER
  • R_PAYMENTPROPOSALITEM.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • R_PAYMENTPROPOSALITEM.COMPANYCODE == T001.BUKRS
  • R_PAYMENTPROPOSALITEM.MANDT == T001.MANDT
Customer Number
  • Customer Number
  • Client
  • R_PAYMENTPROPOSALITEM.CUSTOMER == KNA1.KUNNR
  • R_PAYMENTPROPOSALITEM.MANDT == KNA1.MANDT
G/L Account
  • Company Code
  • G/L Account
  • Client
  • R_PAYMENTPROPOSALITEM.COMPANYCODE == SKB1.BUKRS
  • R_PAYMENTPROPOSALITEM.GLACCOUNT == SKB1.SAKNR
  • R_PAYMENTPROPOSALITEM.MANDT == SKB1.MANDT
House Bank Key
  • House Bank Key
  • Paying Company Code
  • Client
  • R_PAYMENTPROPOSALITEM.HOUSEBANK == T012.HBKID
  • R_PAYMENTPROPOSALITEM.PAYINGCOMPANYCODE == T012.BUKRS
  • R_PAYMENTPROPOSALITEM.MANDT == T012.MANDT
Paying Company Code
  • Paying Company Code
  • Client
  • R_PAYMENTPROPOSALITEM.PAYINGCOMPANYCODE == T001.BUKRS
  • R_PAYMENTPROPOSALITEM.MANDT == T001.MANDT
Payment Blocking Reason
  • Payment Blocking Reason
  • Client
  • R_PAYMENTPROPOSALITEM.PAYMENTBLOCKINGREASON == T008.ZAHLS
  • R_PAYMENTPROPOSALITEM.MANDT == T008.MANDT
Currency for Automatic Payment
  • Additional Currency 2
  • Currency for Automatic Payment
  • Currency Key
  • Additional Currency 1
  • Functional Currency
  • Client
  • R_PAYMENTPROPOSALITEM.ADDITIONALCURRENCY2 == TCURC.WAERS
  • R_PAYMENTPROPOSALITEM.PAYMENTCURRENCY == TCURC.WAERS
  • R_PAYMENTPROPOSALITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • R_PAYMENTPROPOSALITEM.ADDITIONALCURRENCY1 == TCURC.WAERS
  • R_PAYMENTPROPOSALITEM.FUNCTIONALCURRENCY == TCURC.WAERS
  • R_PAYMENTPROPOSALITEM.MANDT == TCURC.MANDT
Payment Method
  • Payment Method
  • ?
  • Client
  • R_PAYMENTPROPOSALITEM.PAYMENTMETHOD == T042Z.ZLSCH
  • R_PAYMENTPROPOSALITEM.[column in domain "LAND1"] == T042Z.LAND1
  • R_PAYMENTPROPOSALITEM.MANDT == T042Z.MANDT
Posting Key
  • Posting Key
  • Client
  • R_PAYMENTPROPOSALITEM.POSTINGKEY == TBSL.BSCHL
  • R_PAYMENTPROPOSALITEM.MANDT == TBSL.MANDT
Special G/L Indicator
  • Special G/L Indicator
  • Account Type
  • Client
  • R_PAYMENTPROPOSALITEM.SPECIALGLCODE == T074U.UMSKZ
  • R_PAYMENTPROPOSALITEM.FINANCIALACCOUNTTYPE == T074U.KOART
  • R_PAYMENTPROPOSALITEM.MANDT == T074U.MANDT
State Central Bank Indicator
  • State Central Bank Indicator
  • Client
  • R_PAYMENTPROPOSALITEM.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
  • R_PAYMENTPROPOSALITEM.MANDT == T015L.MANDT
Supplier
  • Supplier
  • Client
  • R_PAYMENTPROPOSALITEM.SUPPLIER == LFA1.LIFNR
  • R_PAYMENTPROPOSALITEM.MANDT == LFA1.MANDT
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • R_PAYMENTPROPOSALITEM.SUPPLYINGCOUNTRY == T005.LAND1
  • R_PAYMENTPROPOSALITEM.MANDT == T005.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • R_PAYMENTPROPOSALITEM.TRADINGPARTNER == T880.RCOMP
  • R_PAYMENTPROPOSALITEM.MANDT == T880.MANDT