P_IL_PaymentItemForReceipt

DDL: P_IL_PAYMENTITEMFORRECEIPT Type: view_entity COMPOSITE Package: RAP_GLO_FIN_CASH_IL_INCOMPMT
56 Fields 1 Data Sources

IL Payment Items for Receipt

P_IL_PaymentItemForReceipt is a Composite CDS View that provides data about "IL Payment Items for Receipt" in SAP S/4HANA. It reads from 1 data source (I_IL_PaymentItem) and exposes 56 fields with key fields CompanyCode, FiscalYear, AccountingDocument, IL_IdentifierCashPaymentItem, FiscalYear. Part of development package RAP_GLO_FIN_CASH_IL_INCOMPMT.

Data Sources (1)

SourceAliasJoin Type
I_IL_PaymentItem I_IL_PaymentItem from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label IL Payment Items for Receipt view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY IL_IdentifierCashPaymentItem IL_IdentifierCashPaymentItem Payment ID
PaymentMethod PaymentMethod Pymt Meth.
PaymentMethodDescription PaymentMethodDescription
IL_PaymentMethod IL_PaymentMethod Payment Method
IL_CashNumberKey IL_CashNumberKey Cash Number
TransactionCurrency TransactionCurrency Transaction Currency
IL_PaytItmAmountInDocCrcy IL_PaytItmAmountInDocCrcy Value Amount
IL_PaymentStatus IL_PaymentStatus Workflow Status
BankNumber BankNumber Bank Key
BankAccount BankAccount Bank acct
IL_ChequeNumber IL_ChequeNumber Cheque Number
CreditCardNumber CreditCardNumber Card Number
IL_CreditCardReference IL_CreditCardReference Reference Number
IL_CreditCardTransactionType IL_CreditCardTransactionType Credit Type
IL_BankTransferReferenceNumber IL_BankTransferReferenceNumber Bank T. Ref Number
Customer Customer Sold-to Party
Supplier Supplier Supplier
GLAccount GLAccount General Ledger
IL_ChequeDueDate IL_ChequeDueDate Cheque Duedate
LastChangeByUser LastChangeByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
RefAccountingDocument RefAccountingDocument Document Number
ReferenceCompanyCode ReferenceCompanyCode Company Code
ReferenceFiscalYear ReferenceFiscalYear Original FY
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY IL_IdentifierCashPaymentItem IL_IdentifierCashPaymentItem Payment ID
PaymentMethod PaymentMethod Pymt Meth.
PaymentMethodDescription PaymentMethodDescription
IL_PaymentMethod IL_PaymentMethod Payment Method
IL_CashNumberKey IL_CashNumberKey Cash Number
TransactionCurrency TransactionCurrency Transaction Currency
IL_PaytItmAmountInDocCrcy IL_PaytItmAmountInDocCrcy Value Amount
IL_PaymentStatus IL_PaymentStatus Workflow Status
BankNumber BankNumber Bank Key
BankAccount BankAccount Bank acct
IL_ChequeNumber IL_ChequeNumber Cheque Number
CreditCardNumber CreditCardNumber Card Number
IL_CreditCardReference IL_CreditCardReference Reference Number
IL_CreditCardTransactionType IL_CreditCardTransactionType Credit Type
IL_BankTransferReferenceNumber IL_BankTransferReferenceNumber Bank T. Ref Number
Customer Customer Sold-to Party
Supplier Supplier Supplier
GLAccount GLAccount General Ledger
IL_ChequeDueDate IL_ChequeDueDate Cheque Duedate
LastChangeByUser LastChangeByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
RefAccountingDocument RefAccountingDocument Document Number
ReferenceCompanyCode ReferenceCompanyCode Company Code
ReferenceFiscalYear ReferenceFiscalYear Original FY
_PaymentMethodText _PaymentMethodText

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 P_IL_PaymentItemForReceipt.
-- 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 P_IL_PaymentItemForReceipt AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  IL_IdentifierCashPaymentItem,
  PaymentMethod,
  PaymentMethodDescription,
  IL_PaymentMethod,
  IL_CashNumberKey,
  TransactionCurrency,
  IL_PaytItmAmountInDocCrcy,
  IL_PaymentStatus,
  BankNumber,
  BankAccount,
  IL_ChequeNumber,
  CreditCardNumber,
  IL_CreditCardReference,
  IL_CreditCardTransactionType,
  IL_BankTransferReferenceNumber,
  Customer,
  Supplier,
  GLAccount,
  IL_ChequeDueDate,
  LastChangeByUser,
  LastChangeDate,
  LastChangeTime,
  RefAccountingDocument,
  ReferenceCompanyCode,
  ReferenceFiscalYear
FROM I_IL_PaymentItem
;

Learn More