C_IL_RefundItem

DDL: C_IL_REFUNDITEM Type: view_entity CONSUMPTION Package: RAP_GLO_FIN_CASH_IL_RETURN
33 Fields 1 Data Sources 1 OData Services

IL Refund Item

C_IL_RefundItem is a Consumption CDS View that provides data about "IL Refund Item" in SAP S/4HANA. It reads from 1 data source (I_IL_RefundItem) and exposes 33 fields with key fields IL_ReferencePaymentItem, IL_IdentifierCashPaymentItem. It is exposed through 1 OData service (GSFINCSIL_RETURN_PAYMENT). Part of development package RAP_GLO_FIN_CASH_IL_RETURN.

Data Sources (1)

SourceAliasJoin Type
I_IL_RefundItem I_IL_RefundItem projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
EndUserText.label IL Refund Item view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

OData Services (1)

ServiceBindingVersionContractRelease
GSFINCSIL_RETURN_PAYMENT UI_GSFINCSIL_RETURN_PMT_V4 V4 C1 NOT_RELEASED

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY IL_ReferencePaymentItem IL_ReferencePaymentItem
KEY IL_IdentifierCashPaymentItem IL_IdentifierCashPaymentItem
CompanyCode CompanyCode Receiver Company Code
FiscalYear FiscalYear G/L Fiscal Year
AccountingDocument AccountingDocument Journal Entry
PaymentMethod PaymentMethod Pymt Meth.
PaymentMethodDescription PaymentMethodDescription
IL_PaymentMethod IL_PaymentMethod
IL_CashNumberKey IL_CashNumberKey
TransactionCurrency TransactionCurrency Transaction Currency
IL_PaytItmAmountInDocCrcy IL_PaytItmAmountInDocCrcy
IL_PaymentStatus IL_PaymentStatus
IL_CreditCardReference IL_CreditCardReference
TransactionDate TransactionDate Value Date
IL_CreditCardBrand IL_CreditCardBrand
CreditCardNumber CreditCardNumber Card Number
IL_CreditCardTransactionType IL_CreditCardTransactionType
IL_ChequeNumber IL_ChequeNumber
IL_ChequeDueDate IL_ChequeDueDate
BankAccount BankAccount Bank acct
BankNumber BankNumber Bank Key
IL_BankTransferReferenceNumber IL_BankTransferReferenceNumber
Customer Customer Sold-to Party
Supplier Supplier Supplier
GLAccount GLAccount General Ledger
LastChangeByUser LastChangeByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
RefAccountingDocument RefAccountingDocument Document Number
ReferenceCompanyCode ReferenceCompanyCode
ReferenceFiscalYear ReferenceFiscalYear Original FY
_JournalEntry _JournalEntry
_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 C_IL_RefundItem.
-- 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 C_IL_RefundItem AS
SELECT
  IL_ReferencePaymentItem,
  IL_IdentifierCashPaymentItem,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  PaymentMethod,
  PaymentMethodDescription,
  IL_PaymentMethod,
  IL_CashNumberKey,
  TransactionCurrency,
  IL_PaytItmAmountInDocCrcy,
  IL_PaymentStatus,
  IL_CreditCardReference,
  TransactionDate,
  IL_CreditCardBrand,
  CreditCardNumber,
  IL_CreditCardTransactionType,
  IL_ChequeNumber,
  IL_ChequeDueDate,
  BankAccount,
  BankNumber,
  IL_BankTransferReferenceNumber,
  Customer,
  Supplier,
  GLAccount,
  LastChangeByUser,
  LastChangeDate,
  LastChangeTime,
  RefAccountingDocument,
  ReferenceCompanyCode,
  ReferenceFiscalYear
FROM I_IL_RefundItem
;

Learn More