P_CASecInterestDocument

DDL: P_CASECINTERESTDOCUMENT SQL: PSECINCDOC Type: view COMPOSITE Package: ODATA_O2C_FICA_SCRTY_DEP_MNG
10 Fields 1 Data Sources

Security Deposit interest Document

P_CASecInterestDocument is a Composite CDS View that provides data about "Security Deposit interest Document" in SAP S/4HANA. It reads from 1 data source (I_CAInterestSupplement) and exposes 10 fields with key fields CAInterestDocument, CAInterestItemNumber, CADocumentNumber, CARepetitionItemNumber, CABPItemNumber. Part of development package ODATA_O2C_FICA_SCRTY_DEP_MNG.

Data Sources (1)

SourceAliasJoin Type
I_CAInterestSupplement InterestDoc from

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PSECINCDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Security Deposit interest Document view
VDM.private true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CAInterestDocument CAInterestDocument Interest Doc.No
KEY CAInterestItemNumber CAInterestItemNumber Item
KEY CADocumentNumber CADocumentNumber Document Number
KEY CARepetitionItemNumber CARepetitionItemNumber Repetition Item
KEY CABPItemNumber CABPItemNumber Item
KEY CASubItemNumber CASubItemNumber Subitem
KEY CAInterestSequenceNumber CAInterestSequenceNumber Tax sequence
KEY CASecurityDeposit CASecurityDeposit XSRF
Currency Currency Valuation Crcy
CAInterestAmountInTransCrcy CAInterestAmountInTransCrcy Interest Amount

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_CASecInterestDocument.
-- 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.
-- SQL view name: PSECINCDOC

CREATE VIEW P_CASecInterestDocument AS
SELECT
  CAInterestDocument,
  CAInterestItemNumber,
  CADocumentNumber,
  CARepetitionItemNumber,
  CABPItemNumber,
  CASubItemNumber,
  CAInterestSequenceNumber,
  CASecurityDeposit,
  Currency,
  CAInterestAmountInTransCrcy
FROM I_CAInterestSupplement AS InterestDoc
;

Learn More