C_IL_DepositDocumentTP

DDL: C_IL_DEPOSITDOCUMENTTP Type: view_entity CONSUMPTION Package: RAP_GLO_FIN_CASH_IL_DEPDOCMGMT
15 Fields 1 Data Sources 1 OData Services

Deposit Documents V Projection

C_IL_DepositDocumentTP is a Consumption CDS View that provides data about "Deposit Documents V Projection" in SAP S/4HANA. It reads from 1 data source (I_IL_DepositDocument) and exposes 15 fields with key fields CompanyCode, FiscalYear, AccountingDocument. It is exposed through 1 OData service (GSFINCSIL_DEPOSITDOCUMENT). Part of development package RAP_GLO_FIN_CASH_IL_DEPDOCMGMT.

Data Sources (1)

SourceAliasJoin Type
I_IL_DepositDocument I_IL_DepositDocument projection

Annotations (8)

NameValueLevelField
EndUserText.label Deposit Documents V Projection view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
GSFINCSIL_DEPOSITDOCUMENT UI_GSFINCSIL_DEPOSITDOCUMENT V4 C1 NOT_RELEASED

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
AccountingDocumentHeaderText AccountingDocumentHeaderText Doc.Header Text
PostingDate PostingDate Posting Date for GR
IL_DepositReference IL_DepositReference
IL_CashNumberKey IL_CashNumberKey
IL_CashShortDescription _CashNumberText IL_CashShortDescription
IL_PaytItmAmountInDocCrcy IL_PaytItmAmountInDocCrcy
TransactionCurrency TransactionCurrency Transaction Currency
NumberOfCheques NumberOfCheques
IL_FileInDepDocumentIsExisting IL_FileInDepDocumentIsExisting
IL_AttachmentTypeText IL_AttachmentTypeText
IL_AttachmentContentBinary IL_AttachmentContentBinary
FileName FileName URL or Filenam Path

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_DepositDocumentTP.
-- 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_DepositDocumentTP AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentHeaderText,
  PostingDate,
  IL_DepositReference,
  IL_CashNumberKey,
  _CashNumberText.IL_CashShortDescription AS IL_CashShortDescription,
  IL_PaytItmAmountInDocCrcy,
  TransactionCurrency,
  NumberOfCheques,
  IL_FileInDepDocumentIsExisting,
  IL_AttachmentTypeText,
  IL_AttachmentContentBinary,
  FileName
FROM I_IL_DepositDocument
;

Learn More