What is I_PaymentProposalItem in SAP S/4HANA?

I_PaymentProposalItem is a basic CDS view in SAP S/4HANA. Payment Proposal Item It contains 91 fields.

Which tables does I_PaymentProposalItem read from?

I_PaymentProposalItem reads data from: R_PaymentProposalItem.

What VDM layer is I_PaymentProposalItem?

I_PaymentProposalItem is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_PaymentProposalItem

DDL: I_PAYMENTPROPOSALITEM Type: view BASIC

91 Fields 1 Data Sources 2 Associations

Payment Proposal Item

I_PaymentProposalItem (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Financial Operations

I_PaymentProposalItem is a Basic CDS View (Fact) that provides data about "Payment Proposal Item" in SAP S/4HANA. It reads from 1 data source (R_PaymentProposalItem) and exposes 91 fields with key fields PaymentRunDate, PaymentRunID, PaymentRunIsProposal, PayingCompanyCode, Supplier. It has 2 associations to related views.

SAP Help Documentation

Category	CDS Views for Invoice Management
Data Category	FACT
Status	Released

Purpose
This CDS view provides access to all details of payment proposal item data (database table REGUP), including the most important business entities, such as payment items and exception items. The most important attributes of these business entities are included. For example, document type, reference document number, posting date, payment method are included for payment items, and payment block key and item indicator are included for exception items. This CDS view provides the data to answer the following business questions: What are the payment proposal item details for a single payment run? What are the exception items in a proposal or from a payment run? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to consume data collected by this CDS view must be able to display data for the following fields: Authorization Object Fields with Display Access Needed F_REGU_BUK Paying Company Code F_REGU_KOA Financial Account Type F_LFA1_BEK Authorization Group F_KNA1_BED Authorization Group The authorization values for these authorization objects are edited using transaction PFCG.

Structure
Measures and Attributes Some important attributes are: Paying Company Code Supplier Payment Document Accounting Document Accounting Document Item Payment Reason Payment Terms Posting Key Payment Run Item Message Number Payment Blocking Reason House Bank House Bank Account Some important meastures are: Amount in Transaction Currency Cash Discount Amount in Transaction Currency Amount in Company Code Currency Cash Discount Amount in Company Code Currency

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Financial Operations
Application Component	FI-AP-AP-B
Capabilities	Association Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source in SQL Select
Package	Financial Operations for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view provides access to all details of payment proposal item data (database table REGUP), including the most important business entities, such as payment items and exception items. The most important attributes of these business entities are included. For example, document type, reference document number, posting date, payment method are included for payment items, and payment block key and item indicator are included for exception items.</p> This CDS view provides the data to answer the following business questions:<ul> <li><p>What are the payment proposal item details for a single payment run?</p></li> <li><p>What are the exception items in a proposal or from a payment run?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
R_PaymentProposalItem	R_PaymentProposalItem	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_PaymentProposalPayment	_PaymentProposalPayment	$projection.PaymentRunID = _PaymentProposalPayment.PaymentRunID and $projection.PaymentRunDate = _PaymentProposalPayment.PaymentRunDate and $projection.PaymentDocument = _PaymentProposalPayment.PaymentDocument and $projection.PaymentRunIsProposal = _PaymentProposalPayment.PaymentRunIsProposal and $projection.PayingCompanyCode = _PaymentProposalPayment.PayingCompanyCode and $projection.Supplier = _PaymentProposalPayment.Supplier and $projection.Customer = _PaymentProposalPayment.Customer and $projection.PaymentRecipient = _PaymentProposalPayment.PaymentRecipient
[0..*]	I_PostingKeyWthSpclGLCodeTxt	_PostingKeyWthSpclGLCodeTxt	`$projection.PostingKey = _PostingKeyWthSpclGLCodeTxt.PostingKey and $projection.SpecialGLCode = _PostingKeyWthSpclGLCodeTxt.SpecialGLCode`

Annotations (16)

Name	Value	Level
AbapCatalog.sqlViewName	IPAYTPRPSLITM	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
EndUserText.label	Payment Proposal Item	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.modelingPattern	#NONE	view
ClientHandling.type	#INHERITED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
Analytics.dataCategory	#FACT	view
Analytics.internalName	#LOCAL	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (91)

Key	Field	Source Field	Description
KEY	PaymentRunDate	PaymentRunDate	Date on Which the Program Is to Be Run
KEY	PaymentRunID	PaymentRunID	Auto Payment Run ID
KEY	PaymentRunIsProposal	PaymentRunIsProposal	Auto Payment Is Proposal
KEY	PayingCompanyCode	PayingCompanyCode	Paying Company Code
KEY	Supplier	Supplier	Supplier
KEY	Customer	Customer	Customer Number
KEY	PaymentRecipient	PaymentRecipient	Payment Recipient
KEY	PaymentDocument	PaymentDocument	Payment Document Number
KEY	CompanyCode	CompanyCode	Receiver Company Code
KEY	AccountingDocument	AccountingDocument	Journal Entry
KEY	FiscalYear	FiscalYear	G/L Fiscal Year
KEY	AccountingDocumentItem	AccountingDocumentItem	Journal Entry Posting View Item
	BranchAccount	BranchAccount	Branch Account No.
	BusinessArea	BusinessArea	Business Area
	AccountingDocumentType	AccountingDocumentType	Journal Entry Type
	DocumentDate	DocumentDate	Journal Entry Date
	DueCalculationBaseDate	DueCalculationBaseDate	Due Calculation Base Date
	PaymentTerms	PaymentTerms	Terms of Payment Key
	PostingKey	PostingKey	Posting Key
	SpecialGLCode	SpecialGLCode	Special G/L Indicator
	PaymentRunItemMessageNumber	PaymentRunItemMessageNumber	Payt Exception
	PaymentMethod	PaymentMethod	Payment Method
	PaymentBlockingReason	PaymentBlockingReason	Payment Blocking Reason
	AccountingDocExternalReference	AccountingDocExternalReference	Document Reference ID
	DocumentReferenceID	AccountingDocExternalReference	Document Reference ID
	PaymentReference	PaymentReference	Payment Reference
	AssetContract	AssetContract	Asset Contract
	PostingDate	PostingDate	Posting Date for GR
	DocumentItemText	DocumentItemText	Item Text
	GLAccount	GLAccount	General Ledger
	AssignmentReference	AssignmentReference	Assignment Reference
	TaxCode	TaxCode	Tax on Sales/Purchases Code
	SystemMessageNumber	SystemMessageNumber	Message Number
	PaymentCurrency	PaymentCurrency	Currency for Automatic Payment
	AmountInTransactionCurrency	AmountInTransactionCurrency	Pt Crcy Amt
	CashDiscountAmtInTransacCrcy	CashDiscountAmtInTransacCrcy
	WhldgTaxAmtInTransacCrcy	WhldgTaxAmtInTransacCrcy
	TotDeductionAmtInTransacCrcy	TotDeductionAmtInTransacCrcy
	NetAmountInTransacCurrency	NetAmountInTransacCurrency
	MaxCshDiscAmtInTransacCrcy	MaxCshDiscAmtInTransacCrcy
	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	CashDiscountAmtInCoCodeCrcy	CashDiscountAmtInCoCodeCrcy	Discount Amt
	WhldgTaxAmtInCoCodeCrcy	WhldgTaxAmtInCoCodeCrcy
	TotDeductionAmtInCoCodeCrcy	TotDeductionAmtInCoCodeCrcy
	NetAmountInCoCodeCurrency	NetAmountInCoCodeCurrency
	HeaderAmtInCoCodeCurrency	HeaderAmtInCoCodeCurrency
	MaxCshDiscAmtInCoCodeCrcy	MaxCshDiscAmtInCoCodeCrcy
	FunctionalCurrency	FunctionalCurrency	Functional Currency
	CashDiscount1Days	CashDiscount1Days	Days from Baseline Date for Payment
	CashDiscount2Days	CashDiscount2Days	Days from Baseline Date for Payment
	CashDiscount1Percent	CashDiscount1Percent	Cash Discount Percentage 1
	CashDiscount2Percent	CashDiscount2Percent	Cash Discount Percentage 2
	StateCentralBankPaymentReason	StateCentralBankPaymentReason	State Central Bank Indicator
	SupplyingCountry	SupplyingCountry	Supplying Country/Region
	DebitCreditCode	DebitCreditCode	Single-Character Flag
	FinancialAccountType	FinancialAccountType	Fin. Account Type
	BusinessPlace	BusinessPlace	Business place
	TradingPartner	TradingPartner	Company ID of Trading Partner
	HouseBank	HouseBank	House Bank Key
	BPBankAccountInternalID	BPBankAccountInternalID	Business Partner Bank Account Internal ID
	ProfitCenter	ProfitCenter	Profit Center
	BankReconciliationAccount	BankReconciliationAccount	Operational General Ledger Account
	PaymentBlockLevel	PaymentBlockLevel	Level on Which a Payment Block has Taken Place
	ConsideredPaymentMethods	ConsideredPaymentMethods	List of Respected Payment Methods
	Reference1IDByBusinessPartner	Reference1IDByBusinessPartner	ID of Reference 1 by Business Partner
	Reference2IDByBusinessPartner	Reference2IDByBusinessPartner	ID of Reference 2 by Business Partner
	Reference3IDByBusinessPartner	Reference3IDByBusinessPartner	ID of Reference 3 by Business Partner
	PaymentReason	PaymentReason	Payment Reason
	BranchCode	BranchCode	Branch Code
	_Supplier	_Supplier
	_Customer	_Customer
	_PayableToleranceDay	_PayableToleranceDay
	_PostingKeyWithSpecialGLCode	_PostingKeyWithSpecialGLCode
	_PaytProposalRunMessage	_PaytProposalRunMessage
	_CompanyCode	_CompanyCode
	_PaymentCurrency	_PaymentCurrency
	_CompanyCodeCurrency	_CompanyCodeCurrency
	_FunctionalCurrency	_FunctionalCurrency
	_PaymentProposalPayment	_PaymentProposalPayment
	_OperationalAcctgDocItem	_OperationalAcctgDocItem
	_BusinessArea	_BusinessArea
	_AccountingDocumentType	_AccountingDocumentType
	_PostingKey	_PostingKey
	_DebitCreditCode	_DebitCreditCode
	_HouseBank	_HouseBank
	_PaymentReason	_PaymentReason
	_FinancialAccountType	_FinancialAccountType
	_SpecialGLCode	_SpecialGLCode
	_GLAccountInCompanyCode	_GLAccountInCompanyCode
	_PaymentBlockLevel	_PaymentBlockLevel
	_PostingKeyWthSpclGLCodeTxt	_PostingKeyWthSpclGLCodeTxt

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_PaymentProposalItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_PaymentProposalItem AS
SELECT
  PaymentRunDate,
  PaymentRunID,
  PaymentRunIsProposal,
  PayingCompanyCode,
  Supplier,
  Customer,
  PaymentRecipient,
  PaymentDocument,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  BranchAccount,
  BusinessArea,
  AccountingDocumentType,
  DocumentDate,
  DueCalculationBaseDate,
  PaymentTerms,
  PostingKey,
  SpecialGLCode,
  PaymentRunItemMessageNumber,
  PaymentMethod,
  PaymentBlockingReason,
  AccountingDocExternalReference,
  AccountingDocExternalReference AS DocumentReferenceID,
  PaymentReference,
  AssetContract,
  PostingDate,
  DocumentItemText,
  GLAccount,
  AssignmentReference,
  TaxCode,
  SystemMessageNumber,
  PaymentCurrency,
  AmountInTransactionCurrency,
  CashDiscountAmtInTransacCrcy,
  WhldgTaxAmtInTransacCrcy,
  TotDeductionAmtInTransacCrcy,
  NetAmountInTransacCurrency,
  MaxCshDiscAmtInTransacCrcy,
  CompanyCodeCurrency,
  CashDiscountAmtInCoCodeCrcy,
  WhldgTaxAmtInCoCodeCrcy,
  TotDeductionAmtInCoCodeCrcy,
  NetAmountInCoCodeCurrency,
  HeaderAmtInCoCodeCurrency,
  MaxCshDiscAmtInCoCodeCrcy,
  FunctionalCurrency,
  CashDiscount1Days,
  CashDiscount2Days,
  CashDiscount1Percent,
  CashDiscount2Percent,
  StateCentralBankPaymentReason,
  SupplyingCountry,
  DebitCreditCode,
  FinancialAccountType,
  BusinessPlace,
  TradingPartner,
  HouseBank,
  BPBankAccountInternalID,
  ProfitCenter,
  BankReconciliationAccount,
  PaymentBlockLevel,
  ConsideredPaymentMethods,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  PaymentReason,
  BranchCode
FROM R_PaymentProposalItem
LEFT OUTER JOIN I_PaymentProposalPayment AS _PaymentProposalPayment ON PaymentRunID = _PaymentProposalPayment.PaymentRunID AND PaymentRunDate = _PaymentProposalPayment.PaymentRunDate AND PaymentDocument = _PaymentProposalPayment.PaymentDocument AND PaymentRunIsProposal = _PaymentProposalPayment.PaymentRunIsProposal AND PayingCompanyCode = _PaymentProposalPayment.PayingCompanyCode AND Supplier = _PaymentProposalPayment.Supplier AND Customer = _PaymentProposalPayment.Customer AND PaymentRecipient = _PaymentProposalPayment.PaymentRecipient  -- association [0..1]
LEFT OUTER JOIN I_PostingKeyWthSpclGLCodeTxt AS _PostingKeyWthSpclGLCodeTxt ON PostingKey = _PostingKeyWthSpclGLCodeTxt.PostingKey AND SpecialGLCode = _PostingKeyWthSpclGLCodeTxt.SpecialGLCode  -- association [0..*]
;

Depth:

I_PaymentProposalItem view

R_PaymentProposalItem view