C_IL_ReturnableFromBankItemTP

DDL: C_IL_RETURNABLEFROMBANKITEMTP Type: view_entity CONSUMPTION Package: RAP_GLO_FIN_CASH_IL_CNCLDEPCHQ
41 Fields 1 Data Sources 1 OData Services

IL Cancelebale Deposit Item

C_IL_ReturnableFromBankItemTP is a Consumption CDS View that provides data about "IL Cancelebale Deposit Item" in SAP S/4HANA. It reads from 1 data source (I_IL_ReturnableFromBankItem) and exposes 41 fields with key fields AccountingDocument, CompanyCode, FiscalYear, IL_IdentifierCashPaymentItem. It is exposed through 1 OData service (GSFINCSIL_CANCEL_DEPOSIT). Part of development package RAP_GLO_FIN_CASH_IL_CNCLDEPCHQ.

Data Sources (1)

SourceAliasJoin Type
I_IL_ReturnableFromBankItem I_IL_ReturnableFromBankItem projection

Annotations (8)

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

OData Services (1)

ServiceBindingVersionContractRelease
GSFINCSIL_CANCEL_DEPOSIT UI_GSFINCSIL_CANCEL_DEPOSIT_V4 V4 C1 NOT_RELEASED

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocument AccountingDocument Journal Entry
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY IL_IdentifierCashPaymentItem IL_IdentifierCashPaymentItem
RefAccountingDocument RefAccountingDocument Document Number
ReferenceCompanyCode ReferenceCompanyCode
ReferenceFiscalYear ReferenceFiscalYear Original FY
AccountingDocumentHeaderText _JournalEntry AccountingDocumentHeaderText Doc.Header Text
HouseBank HouseBank House Bank
HouseBankName _HouseBankText HouseBankName
HouseBankAccount HouseBankAccount House Bank Account
HouseBankAccountDescription _HouseBankAccountText HouseBankAccountDescription
PostingDate _JournalEntry PostingDate Posting Date for GR
CompanyCodeName _CompanyCode CompanyCodeName Company Name
IL_PaytItmAmountInDocCrcy IL_PaytItmAmountInDocCrcy
TransactionCurrency TransactionCurrency Transaction Currency
IL_PaymentMethod IL_PaymentMethod
IL_PaymentMethodText _IL_PaymentMethodText IL_PaymentMethodText
PaymentMethod PaymentMethod Pymt Meth.
PaymentMethodDescription PaymentMethodDescription
IL_CashNumberKey IL_CashNumberKey
IL_CashShortDescription _CashRegisterText IL_CashShortDescription
BankNumber BankNumber Bank Key
BankAccount BankAccount Bank acct
IL_ChequeDueDate IL_ChequeDueDate
IL_ChequeNumber IL_ChequeNumber
Customer Customer Sold-to Party
CustomerFullName _Customer CustomerFullName Customer Name
Supplier Supplier Supplier
SupplierFullName _Supplier SupplierFullName
IL_PaymentItemIconURL IL_PaymentItemIconURL
IL_DepositItemType IL_DepositItemType
IL_DepositItemTypeText _DepositItemTypeText IL_DepositItemTypeText
IL_CancelDepositStatus IL_CancelDepositStatus
IL_CancelDepositStatusText _CancelDepositStatusText IL_CancelDepositStatusText
Criticality Criticality Status Rating
IL_ChqInfoFacetIsToBeHidden IL_ChqInfoFacetIsToBeHidden
IL_DocInfoFacetIsToBeHidden IL_DocInfoFacetIsToBeHidden
EntryTimestamp EntryTimestamp
_IL_PaymentMethodText _IL_PaymentMethodText
_CancelDepositStatusText _CancelDepositStatusText

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_ReturnableFromBankItemTP.
-- 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_ReturnableFromBankItemTP AS
SELECT
  AccountingDocument,
  CompanyCode,
  FiscalYear,
  IL_IdentifierCashPaymentItem,
  RefAccountingDocument,
  ReferenceCompanyCode,
  ReferenceFiscalYear,
  _JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  HouseBank,
  _HouseBankText.HouseBankName AS HouseBankName,
  HouseBankAccount,
  _HouseBankAccountText.HouseBankAccountDescription AS HouseBankAccountDescription,
  _JournalEntry.PostingDate AS PostingDate,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  IL_PaytItmAmountInDocCrcy,
  TransactionCurrency,
  IL_PaymentMethod,
  _IL_PaymentMethodText.IL_PaymentMethodText AS IL_PaymentMethodText,
  PaymentMethod,
  PaymentMethodDescription,
  IL_CashNumberKey,
  _CashRegisterText.IL_CashShortDescription AS IL_CashShortDescription,
  BankNumber,
  BankAccount,
  IL_ChequeDueDate,
  IL_ChequeNumber,
  Customer,
  _Customer.CustomerFullName AS CustomerFullName,
  Supplier,
  _Supplier.SupplierFullName AS SupplierFullName,
  IL_PaymentItemIconURL,
  IL_DepositItemType,
  _DepositItemTypeText.IL_DepositItemTypeText AS IL_DepositItemTypeText,
  IL_CancelDepositStatus,
  _CancelDepositStatusText.IL_CancelDepositStatusText AS IL_CancelDepositStatusText,
  Criticality,
  IL_ChqInfoFacetIsToBeHidden,
  IL_DocInfoFacetIsToBeHidden,
  EntryTimestamp
FROM I_IL_ReturnableFromBankItem
;

Learn More