I_CAInterestNoticeHeader

DDL: I_CAINTERESTNOTICEHEADER SQL: ICAINTRSTNTCHDR Type: view COMPOSITE
24 Fields 1 Data Sources

View for Interest Notice Header Data

I_CAInterestNoticeHeader is a Composite CDS View that provides data about "View for Interest Notice Header Data" in SAP S/4HANA. It reads from 1 data source (I_CADocumentHeader) and exposes 24 fields with key fields CACorrespondence, CACorrespondenceType.

Data Sources (1)

SourceAliasJoin Type
I_CADocumentHeader Interest from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (9)

NameValueLevelField
EndUserText.label View for Interest Notice Header Data view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ICAINTRSTNTCHDR view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY CACorrespondence Correspndc CACorrespondence
KEY CACorrespondenceType Correspndc CACorrespondenceType Corresp. Type
BusinessPartner Correspndc BusinessPartner Issuing Authority
CAContract Correspndc CAContract Contract
ContractAccount Correspndc ContractAccount Contract Acct
CompanyCode Correspndc CompanyCode Receiver Company Code
Language Correspndc Language Report Text Language
ContractAccountName
CorrespondenceIssueDate Correspndc CorrespondenceIssueDate
CADocumentNumber I_CADocumentHeader CADocumentNumber Document Number
CAApplicationArea I_CADocumentHeader CAApplicationArea ApplicationArea
CADocumentType I_CADocumentHeader CADocumentType Document Type
CADocumentOriginCode I_CADocumentHeader CADocumentOriginCode Document Origin
CreatedByUser I_CADocumentHeader CreatedByUser User Name
CreationDate I_CADocumentHeader CreationDate Time Stamp
CreationTime I_CADocumentHeader CreationTime Time of Change
DocumentDate I_CADocumentHeader DocumentDate Journal Entry Date
CAPostingDate I_CADocumentHeader CAPostingDate Posting Date
CADocumentClass I_CADocumentHeader CADocumentClass Document Class
CATaxCompanyCode I_CADocumentHeader CATaxCompanyCode Tax comp. code
CAReversalDocumentNumber I_CADocumentHeader CAReversalDocumentNumber Revers.document
CADocumentVersion I_CADocumentHeader CADocumentVersion Version
TransactionCurrency Amount TransactionCurrency Transaction Currency
TotalInterestAmountInTransCrcy Amount TotalInterestAmountInTransCrcy

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 I_CAInterestNoticeHeader.
-- 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: ICAINTRSTNTCHDR
-- Parameters: P_Language : sylangu

CREATE VIEW I_CAInterestNoticeHeader AS
SELECT
  Correspndc.CACorrespondence AS CACorrespondence,
  Correspndc.CACorrespondenceType AS CACorrespondenceType,
  Correspndc.BusinessPartner AS BusinessPartner,
  Correspndc.CAContract AS CAContract,
  Correspndc.ContractAccount AS ContractAccount,
  Correspndc.CompanyCode AS CompanyCode,
  Correspndc.Language AS Language,
  Correspndc._ContrAcc.ContractAccountName AS ContractAccountName,
  Correspndc.CorrespondenceIssueDate AS CorrespondenceIssueDate,
  Interest.CADocumentNumber AS CADocumentNumber,
  Interest.CAApplicationArea AS CAApplicationArea,
  Interest.CADocumentType AS CADocumentType,
  Interest.CADocumentOriginCode AS CADocumentOriginCode,
  Interest.CreatedByUser AS CreatedByUser,
  Interest.CreationDate AS CreationDate,
  Interest.CreationTime AS CreationTime,
  Interest.DocumentDate AS DocumentDate,
  Interest.CAPostingDate AS CAPostingDate,
  Interest.CADocumentClass AS CADocumentClass,
  Interest.CATaxCompanyCode AS CATaxCompanyCode,
  Interest.CAReversalDocumentNumber AS CAReversalDocumentNumber,
  Interest.CADocumentVersion AS CADocumentVersion,
  Amount.TransactionCurrency AS TransactionCurrency,
  Amount.TotalInterestAmountInTransCrcy AS TotalInterestAmountInTransCrcy
FROM I_CADocumentHeader AS Interest
;

Learn More