I_PaytProposalItemAggregation

Payt Proposal Item Aggregation | view: IPAYTITMAGGRGN | Extraction: Not supported | Component: Payment Progam / Payment transfer (DE, JP, US)
Tables used: REGUPREGUHT001TKA02
Column Name Description
PaymentRunDate Date on Which the Program Is to Be Run
PaymentRunID Additional Identification
PaymentRunIsProposal Indicator: Only Proposal Run? Show values
PayingCompanyCode FK Paying company code
Supplier FK Account Number of Supplier
Customer FK Customer Number
PaymentRecipient Payment Recipient Code
PaymentDocument Document Number of the Payment Document
Column Name Description
💲 Currency Key (PaymentCurrency):
AmountInTransactionCurrency null
WhldgTaxAmtInTransacCrcy null
TotDeductionAmtInTransacCrcy null
NetAmountInTransacCurrency null
💲 Currency Key (CompanyCodeCurrency):
HeaderAmtInCoCodeCurrency null
WhldgTaxAmtInCoCodeCrcy null
TotDeductionAmtInCoCodeCrcy null
NetAmountInCoCodeCurrency null
Column Name Description
Column Name Description
PaymentRunDate Date on Which the Program Is to Be Run
Column Name Description
PaymentRunIsProposal Indicator: Only Proposal Run? Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • I_PAYTPROPOSALITEMAGGREGATION.MANDT == TCURC.MANDT
  • I_PAYTPROPOSALITEMAGGREGATION.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PAYTPROPOSALITEMAGGREGATION.PAYMENTCURRENCY == TCURC.WAERS
Customer Number
  • Client
  • Customer Number
  • I_PAYTPROPOSALITEMAGGREGATION.MANDT == KNA1.MANDT
  • I_PAYTPROPOSALITEMAGGREGATION.CUSTOMER == KNA1.KUNNR
Paying company code
  • Client
  • Paying company code
  • I_PAYTPROPOSALITEMAGGREGATION.MANDT == T001.MANDT
  • I_PAYTPROPOSALITEMAGGREGATION.PAYINGCOMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • I_PAYTPROPOSALITEMAGGREGATION.MANDT == TCURC.MANDT
  • I_PAYTPROPOSALITEMAGGREGATION.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PAYTPROPOSALITEMAGGREGATION.PAYMENTCURRENCY == TCURC.WAERS
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • I_PAYTPROPOSALITEMAGGREGATION.MANDT == LFA1.MANDT
  • I_PAYTPROPOSALITEMAGGREGATION.SUPPLIER == LFA1.LIFNR