I_PaymentProposalItem

Payment Proposal Item | view: IPAYTPRPSLITM | TRAN | 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):
CashDiscountAmtInCoCodeCrcy null
WhldgTaxAmtInCoCodeCrcy null
TotDeductionAmtInCoCodeCrcy null
NetAmountInCoCodeCurrency null
HeaderAmtInCoCodeCurrency null
MaxCshDiscAmtInCoCodeCrcy null
💲 Functional Currency (FunctionalCurrency):
AmountInFunctionalCurrency Amount in Functional Currency
CashDiscountAmountInFuncnlCrcy Cash Discount in Functional Currency
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
DocumentReferenceID 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
SystemMessageNumber Message number MSGNR
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
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_PAYMENTPROPOSALITEM.MANDT == T003.MANDT
  • I_PAYMENTPROPOSALITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Operational General Ledger Account
  • Company Code
  • Client
  • Operational General Ledger Account
  • I_PAYMENTPROPOSALITEM.COMPANYCODE == SKB1.BUKRS
  • I_PAYMENTPROPOSALITEM.MANDT == SKB1.MANDT
  • I_PAYMENTPROPOSALITEM.BANKRECONCILIATIONACCOUNT == SKB1.SAKNR
Business Area
  • Client
  • Business Area
  • I_PAYMENTPROPOSALITEM.MANDT == TGSB.MANDT
  • I_PAYMENTPROPOSALITEM.BUSINESSAREA == TGSB.GSBER
Company Code
  • Company Code
  • Client
  • I_PAYMENTPROPOSALITEM.COMPANYCODE == T001.BUKRS
  • I_PAYMENTPROPOSALITEM.MANDT == T001.MANDT
Customer Number
  • Client
  • Customer Number
  • I_PAYMENTPROPOSALITEM.MANDT == KNA1.MANDT
  • I_PAYMENTPROPOSALITEM.CUSTOMER == KNA1.KUNNR
G/L Account
  • Company Code
  • G/L Account
  • Client
  • I_PAYMENTPROPOSALITEM.COMPANYCODE == SKB1.BUKRS
  • I_PAYMENTPROPOSALITEM.GLACCOUNT == SKB1.SAKNR
  • I_PAYMENTPROPOSALITEM.MANDT == SKB1.MANDT
House Bank Key
  • House Bank Key
  • Client
  • Paying Company Code
  • I_PAYMENTPROPOSALITEM.HOUSEBANK == T012.HBKID
  • I_PAYMENTPROPOSALITEM.MANDT == T012.MANDT
  • I_PAYMENTPROPOSALITEM.PAYINGCOMPANYCODE == T012.BUKRS
Paying Company Code
  • Client
  • Paying Company Code
  • I_PAYMENTPROPOSALITEM.MANDT == T001.MANDT
  • I_PAYMENTPROPOSALITEM.PAYINGCOMPANYCODE == T001.BUKRS
Payment Blocking Reason
  • Client
  • Payment Blocking Reason
  • I_PAYMENTPROPOSALITEM.MANDT == T008.MANDT
  • I_PAYMENTPROPOSALITEM.PAYMENTBLOCKINGREASON == T008.ZAHLS
Currency for Automatic Payment
  • Client
  • Currency for Automatic Payment
  • Functional Currency
  • Currency Key
  • I_PAYMENTPROPOSALITEM.MANDT == TCURC.MANDT
  • I_PAYMENTPROPOSALITEM.PAYMENTCURRENCY == TCURC.WAERS
  • I_PAYMENTPROPOSALITEM.FUNCTIONALCURRENCY == TCURC.WAERS
  • I_PAYMENTPROPOSALITEM.COMPANYCODECURRENCY == TCURC.WAERS
Payment Method
  • Client
  • Payment Method
  • ?
  • I_PAYMENTPROPOSALITEM.MANDT == T042Z.MANDT
  • I_PAYMENTPROPOSALITEM.PAYMENTMETHOD == T042Z.ZLSCH
  • I_PAYMENTPROPOSALITEM.[column in domain "LAND1"] == T042Z.LAND1
Posting Key
  • Client
  • Posting Key
  • I_PAYMENTPROPOSALITEM.MANDT == TBSL.MANDT
  • I_PAYMENTPROPOSALITEM.POSTINGKEY == TBSL.BSCHL
Special G/L Indicator
  • Client
  • Special G/L Indicator
  • Account Type
  • I_PAYMENTPROPOSALITEM.MANDT == T074U.MANDT
  • I_PAYMENTPROPOSALITEM.SPECIALGLCODE == T074U.UMSKZ
  • I_PAYMENTPROPOSALITEM.FINANCIALACCOUNTTYPE == T074U.KOART
State Central Bank Indicator
  • Client
  • State Central Bank Indicator
  • I_PAYMENTPROPOSALITEM.MANDT == T015L.MANDT
  • I_PAYMENTPROPOSALITEM.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
Supplier
  • Client
  • Supplier
  • I_PAYMENTPROPOSALITEM.MANDT == LFA1.MANDT
  • I_PAYMENTPROPOSALITEM.SUPPLIER == LFA1.LIFNR
Supplying Country/Region
  • Client
  • Supplying Country/Region
  • I_PAYMENTPROPOSALITEM.MANDT == T005.MANDT
  • I_PAYMENTPROPOSALITEM.SUPPLYINGCOUNTRY == T005.LAND1
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • I_PAYMENTPROPOSALITEM.MANDT == T880.MANDT
  • I_PAYMENTPROPOSALITEM.TRADINGPARTNER == T880.RCOMP