C_PaymentProposalItem

Payment Proposal Header And Item | view: CPAYTPRPSLITM | Extraction: Not supported | Component: Payment Progam / Payment transfer (DE, JP, US)
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
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 Gross Amount in Foreign Currency
CashDiscountAmtInTransacCrcy Cash Discounts in Foreign Currency
WhldgTaxAmtInTransacCrcy Withholding Tax in Foreign Currency
NetAmountInTransacCurrency Net Amount in Foreign Currency
TotDeductionAmtInTransacCrcy Total Deductions in Foreign Currency
💲 Currency Key (Currency):
HeaderAmtInCoCodeCurrency Gross Amount in Local Currency
CashDiscountAmtInCoCodeCrcy Cash Discounts in Local Currency
WhldgTaxAmtInCoCodeCrcy Withholding Tax in Local Currency
NetAmountInCoCodeCurrency Net Amount in Local Currency
TotDeductionAmtInCoCodeCrcy Total Deductions in Local Currency
💲 Functional Currency (FunctionalCurrency):
AmountInFunctionalCurrency Amount in Functional Currency
CashDiscountAmountInFuncnlCrcy Cash Discount in Functional Currency
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
DueCalculationBaseDate Due Calculation Base Date
PostingDate Posting Date
Column Name Description
PaymentRunIsProposal Auto Payment Is Proposal Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
BranchAccount Branch Account MAXKK
PaymentTerms Terms of Payment Key ZTERM
DocumentReferenceID Reference Document XBLNR
PaymentReference Payment Reference CHAR30
AssetContract Asset Contract RANL
DocumentItemText Item Text TEXT50
BusinessPlace Business Place J_1BBRANCH
PaymentReason Payment Reason FARP_PAYT_RSN
SystemMessageDescription Error ID CHAR255
PostingKeyName Posting Key Name TEXT20
PaymentReasonText Payment Reason Description CHAR130
CompanyCodeName Name of Company Code or Company TEXT25
PostalCode Supplier Postal Code PSTLZ
SupplierCityName Supplier's City ORT01
SupplierStreetName Supplier's Street TEXT35
SupplierName Name 1 NAME
SupplierAdditionalName Name 2 NAME
CustomerPostalCode Customer Postal Code PSTLZ
CustomerCityName Customer's City ORT01
CustomerStreetName Customer's Street TEXT35
CustomerName Name 1 NAME
CustomerAdditionalName Name 2 NAME
SupplierBasicAuthorizationGrp Authorization Group BRGRU
CustomerBasicAuthorizationGrp Authorization Group BRGRU
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_PAYMENTPROPOSALITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_PAYMENTPROPOSALITEM.MANDT == T003.MANDT
Business Area
  • Business Area
  • Client
  • C_PAYMENTPROPOSALITEM.BUSINESSAREA == TGSB.GSBER
  • C_PAYMENTPROPOSALITEM.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • C_PAYMENTPROPOSALITEM.COMPANYCODE == T001.BUKRS
  • C_PAYMENTPROPOSALITEM.MANDT == T001.MANDT
Currency Key
  • Functional Currency
  • Currency for Automatic Payment
  • Currency Key
  • Client
  • C_PAYMENTPROPOSALITEM.FUNCTIONALCURRENCY == TCURC.WAERS
  • C_PAYMENTPROPOSALITEM.PAYMENTCURRENCY == TCURC.WAERS
  • C_PAYMENTPROPOSALITEM.CURRENCY == TCURC.WAERS
  • C_PAYMENTPROPOSALITEM.MANDT == TCURC.MANDT
Customer Number
  • Client
  • Customer Number
  • C_PAYMENTPROPOSALITEM.MANDT == KNA1.MANDT
  • C_PAYMENTPROPOSALITEM.CUSTOMER == KNA1.KUNNR
Customer Account Group
  • Client
  • Customer Account Group
  • C_PAYMENTPROPOSALITEM.MANDT == T077D.MANDT
  • C_PAYMENTPROPOSALITEM.CUSTOMERACCOUNTGROUP == T077D.KTOKD
Paying Company Code
  • Client
  • Paying Company Code
  • C_PAYMENTPROPOSALITEM.MANDT == T001.MANDT
  • C_PAYMENTPROPOSALITEM.PAYINGCOMPANYCODE == T001.BUKRS
Payment Blocking Reason
  • Client
  • Payment Blocking Reason
  • C_PAYMENTPROPOSALITEM.MANDT == T008.MANDT
  • C_PAYMENTPROPOSALITEM.PAYMENTBLOCKINGREASON == T008.ZAHLS
Currency for Automatic Payment
  • Functional Currency
  • Currency for Automatic Payment
  • Currency Key
  • Client
  • C_PAYMENTPROPOSALITEM.FUNCTIONALCURRENCY == TCURC.WAERS
  • C_PAYMENTPROPOSALITEM.PAYMENTCURRENCY == TCURC.WAERS
  • C_PAYMENTPROPOSALITEM.CURRENCY == TCURC.WAERS
  • C_PAYMENTPROPOSALITEM.MANDT == TCURC.MANDT
Payment Method
  • Payment Method
  • ?
  • Client
  • C_PAYMENTPROPOSALITEM.PAYMENTMETHOD == T042Z.ZLSCH
  • C_PAYMENTPROPOSALITEM.[column in domain "LAND1"] == T042Z.LAND1
  • C_PAYMENTPROPOSALITEM.MANDT == T042Z.MANDT
Posting Key
  • Posting Key
  • Client
  • C_PAYMENTPROPOSALITEM.POSTINGKEY == TBSL.BSCHL
  • C_PAYMENTPROPOSALITEM.MANDT == TBSL.MANDT
State Central Bank Indicator
  • State Central Bank Indicator
  • Client
  • C_PAYMENTPROPOSALITEM.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
  • C_PAYMENTPROPOSALITEM.MANDT == T015L.MANDT
Supplier
  • Supplier
  • Client
  • C_PAYMENTPROPOSALITEM.SUPPLIER == LFA1.LIFNR
  • C_PAYMENTPROPOSALITEM.MANDT == LFA1.MANDT
Vendor account group
  • Client
  • Vendor account group
  • C_PAYMENTPROPOSALITEM.MANDT == T077K.MANDT
  • C_PAYMENTPROPOSALITEM.SUPPLIERACCOUNTGROUP == T077K.KTOKK
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • C_PAYMENTPROPOSALITEM.SUPPLYINGCOUNTRY == T005.LAND1
  • C_PAYMENTPROPOSALITEM.MANDT == T005.MANDT