I_InsurPlcyCashFlowHeader

DDL: I_INSURPLCYCASHFLOWHEADER Type: view_entity COMPOSITE
41 Fields 1 Data Sources 11 Associations

Insurance Policy Cash Flow Header

I_InsurPlcyCashFlowHeader is a Composite CDS View that provides data about "Insurance Policy Cash Flow Header" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyCashFlowHeaderBasic) and exposes 41 fields with key field InsurPolicyCashFlowDocument. It has 11 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyCashFlowHeaderBasic CFHeader from

Associations (11)

CardinalityTargetAliasCondition
[1..1] I_Currency _Currency $projection.InsurPlcyCshFlwDocCurrency = _Currency.Currency
[1..1] I_InsurPlcyCshFlwDocPostgState _InsurPlcyCshFlwDocPostgState $projection.InsurPlcyCshFlwDocPostingState = _InsurPlcyCshFlwDocPostgState.InsurPlcyCshFlwDocPostingState
[1..1] I_InsurPlcyCshFlwNoTransfRsn _InsurPlcyCshFlwNoTransfRsn $projection.InsurPlcyCshFlwDocNoTransfRsn = _InsurPlcyCshFlwNoTransfRsn.InsurPlcyCshFlwDocNoTransfRsn
[1..1] I_InsurPlcyBusinessObject _InsurPlcyBusinessObject $projection.InsurPlcyBusinessObject = _InsurPlcyBusinessObject.InsurPlcyBusinessObject
[1..1] I_InsurPlcyCshFlwDocOrigin _InsurPlcyCshFlwDocOrigin $projection.InsurPlcyCshFlwDocumentOrigin = _InsurPlcyCshFlwDocOrigin.InsurPlcyCshFlwDocumentOrigin
[1..1] I_InsurPlcyCashFlowHeader _InsurPlcyCashFlowRevDocHeader $projection.InsurPlcyCshFlwDocReversalDoc = _InsurPlcyCashFlowRevDocHeader.InsurPolicyCashFlowDocument
[1..1] I_InsurPlcyCashFlowHeader _InsurPlcyCshFlwCoinsurDocHdr $projection.InsurPlcyCshFlwDocCoinsurDoc = _InsurPlcyCshFlwCoinsurDocHdr.InsurPolicyCashFlowDocument
[1..*] I_InsurPlcyTemplateT _InsurPlcySlsProductTemplateT $projection.InsurPlcySalesProductTemplate = _InsurPlcySlsProductTemplateT.InsurPlcyTemplate
[1..*] I_InsurPlcyTemplateT _InsurPlcyProductTemplateT $projection.InsurPlcyProductTemplate = _InsurPlcyProductTemplateT.InsurPlcyTemplate
[1..1] I_InsurancePolicy _InsurancePolicy $projection.InsurPlcyUUID = _InsurancePolicy.InsurPlcyUUID
[0..*] I_InsurPlcyCashFlowItem _InsurPlcyCashFlowItem

Annotations (11)

NameValueLevelField
EndUserText.label Insurance Policy Cash Flow Header view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey InsurPolicyCashFlowDocument view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations false view
Analytics.technicalName IPPlcyCFH view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY InsurPolicyCashFlowDocument I_InsurPlcyCashFlowHeaderBasic InsurPolicyCashFlowDocument CF Document No.
InsurancePolicy I_InsurPlcyCashFlowHeaderBasic InsurancePolicy Policy Number
InsurPlcyUUID I_InsurPlcyCashFlowHeaderBasic InsurPlcyUUID Policy UUID
InsuranceApplication I_InsurPlcyCashFlowHeaderBasic InsuranceApplication Application No.
InsuranceContract I_InsurPlcyCashFlowHeaderBasic InsuranceContract Contract
InsurPlcyCashFlowDocumentDate I_InsurPlcyCashFlowHeaderBasic InsurPlcyCashFlowDocumentDate Document Date
InsurPlcyCshFlwDocPostingState I_InsurPlcyCashFlowHeaderBasic InsurPlcyCshFlwDocPostingState Posting Status
InsurPlcyCshFlwDocNoTransfRsn I_InsurPlcyCashFlowHeaderBasic InsurPlcyCshFlwDocNoTransfRsn Status Reason
InsurPlcyCshFlwDocPostingDate I_InsurPlcyCashFlowHeaderBasic InsurPlcyCshFlwDocPostingDate Posting Date
InsurPlcyCshFlwSettlmtStrtDate I_InsurPlcyCashFlowHeaderBasic InsurPlcyCshFlwSettlmtStrtDate Settlement From
InsurPlcyCshFlwSettlmtEndDate I_InsurPlcyCashFlowHeaderBasic InsurPlcyCshFlwSettlmtEndDate Settlement To
InsurPlcyCshFlwDocCompanyCode I_InsurPlcyCashFlowHeaderBasic InsurPlcyCshFlwDocCompanyCode Company Code
InsurPlcyCshFlwDocCurrency I_InsurPlcyCashFlowHeaderBasic InsurPlcyCshFlwDocCurrency Indx-Based Curr
InsurPlcyCshFlwOriglJrnlNmbr I_InsurPlcyCashFlowHeaderBasic InsurPlcyCshFlwOriglJrnlNmbr Journal Number
InsurPlcyBusinessObject I_InsurPlcyCashFlowHeaderBasic InsurPlcyBusinessObject Process.Status
InsurPlcyCshFlwDocCurJrnlNmbr I_InsurPlcyCashFlowHeaderBasic InsurPlcyCshFlwDocCurJrnlNmbr Cur.Journal No.
InsurPlcyCshFlwDocumentOrigin I_InsurPlcyCashFlowHeaderBasic InsurPlcyCshFlwDocumentOrigin Origin
InsurPlcyCshFlwDocReversalDoc I_InsurPlcyCashFlowHeaderBasic InsurPlcyCshFlwDocReversalDoc Orig. Doc. No.
InsurPlcyCshFlwDocIsRvslDoc I_InsurPlcyCashFlowHeaderBasic InsurPlcyCshFlwDocIsRvslDoc Is Ofsetng Doc.
InsurPlcyCshFlwDocIsReversed I_InsurPlcyCashFlowHeaderBasic InsurPlcyCshFlwDocIsReversed OfSetng Doc Exs
InsurPlcyCshFlwDocCoinsurDoc I_InsurPlcyCashFlowHeaderBasic InsurPlcyCshFlwDocCoinsurDoc Coins: Orig.Doc
InsurPlcyInsurContr I_InsurPlcyCashFlowHeaderBasic InsurPlcyInsurContr Contract Key
InsurPlcyCshFlwDocumentDueDate I_InsurPlcyCashFlowHeaderBasic InsurPlcyCshFlwDocumentDueDate Due Date
InsurPlcySalesProductTemplate I_InsurPlcyCashFlowHeaderBasic InsurPlcySalesProductTemplate SlsProdTempl.ID
InsurPlcyProductTemplate I_InsurPlcyCashFlowHeaderBasic InsurPlcyProductTemplate Product
InsurPlcyCshFlwValdtyBeginDte I_InsurPlcyCashFlowHeaderBasic InsurPlcyCshFlwValdtyBeginDte Valid
InsurPlcyChangedByUser I_InsurPlcyCashFlowHeaderBasic InsurPlcyChangedByUser Processor
LastChangeDateTime I_InsurPlcyCashFlowHeaderBasic LastChangeDateTime Timestamp
InsrrIDByInsrr _InsurancePolicy InsrrIDByInsrr Company ID
InsurPlcyAuthznSlsProductGroup _InsurancePolicy InsurPlcyAuthznSlsProductGroup Auth. Sales Prod. Module Group
_InsurPlcyCashFlowItem _InsurPlcyCashFlowItem
_InsurPlcySlsProductTemplateT _InsurPlcySlsProductTemplateT
_InsurPlcyProductTemplateT _InsurPlcyProductTemplateT
_InsurPlcyCshFlwCoinsurDocHdr _InsurPlcyCshFlwCoinsurDocHdr
_InsurPlcyCashFlowRevDocHeader _InsurPlcyCashFlowRevDocHeader
_InsurPlcyCshFlwDocOrigin _InsurPlcyCshFlwDocOrigin
_InsurPlcyBusinessObject _InsurPlcyBusinessObject
_InsurPlcyCshFlwDocPostgState _InsurPlcyCshFlwDocPostgState
_InsurPlcyCshFlwNoTransfRsn _InsurPlcyCshFlwNoTransfRsn
_Currency _Currency
_InsurancePolicy _InsurancePolicy

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_InsurPlcyCashFlowHeader.
-- 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 I_InsurPlcyCashFlowHeader AS
SELECT
  CFHeader.InsurPolicyCashFlowDocument AS InsurPolicyCashFlowDocument,
  CFHeader.InsurancePolicy AS InsurancePolicy,
  CFHeader.InsurPlcyUUID AS InsurPlcyUUID,
  CFHeader.InsuranceApplication AS InsuranceApplication,
  CFHeader.InsuranceContract AS InsuranceContract,
  CFHeader.InsurPlcyCashFlowDocumentDate AS InsurPlcyCashFlowDocumentDate,
  CFHeader.InsurPlcyCshFlwDocPostingState AS InsurPlcyCshFlwDocPostingState,
  CFHeader.InsurPlcyCshFlwDocNoTransfRsn AS InsurPlcyCshFlwDocNoTransfRsn,
  CFHeader.InsurPlcyCshFlwDocPostingDate AS InsurPlcyCshFlwDocPostingDate,
  CFHeader.InsurPlcyCshFlwSettlmtStrtDate AS InsurPlcyCshFlwSettlmtStrtDate,
  CFHeader.InsurPlcyCshFlwSettlmtEndDate AS InsurPlcyCshFlwSettlmtEndDate,
  CFHeader.InsurPlcyCshFlwDocCompanyCode AS InsurPlcyCshFlwDocCompanyCode,
  CFHeader.InsurPlcyCshFlwDocCurrency AS InsurPlcyCshFlwDocCurrency,
  CFHeader.InsurPlcyCshFlwOriglJrnlNmbr AS InsurPlcyCshFlwOriglJrnlNmbr,
  CFHeader.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  CFHeader.InsurPlcyCshFlwDocCurJrnlNmbr AS InsurPlcyCshFlwDocCurJrnlNmbr,
  CFHeader.InsurPlcyCshFlwDocumentOrigin AS InsurPlcyCshFlwDocumentOrigin,
  CFHeader.InsurPlcyCshFlwDocReversalDoc AS InsurPlcyCshFlwDocReversalDoc,
  CFHeader.InsurPlcyCshFlwDocIsRvslDoc AS InsurPlcyCshFlwDocIsRvslDoc,
  CFHeader.InsurPlcyCshFlwDocIsReversed AS InsurPlcyCshFlwDocIsReversed,
  CFHeader.InsurPlcyCshFlwDocCoinsurDoc AS InsurPlcyCshFlwDocCoinsurDoc,
  CFHeader.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  CFHeader.InsurPlcyCshFlwDocumentDueDate AS InsurPlcyCshFlwDocumentDueDate,
  CFHeader.InsurPlcySalesProductTemplate AS InsurPlcySalesProductTemplate,
  CFHeader.InsurPlcyProductTemplate AS InsurPlcyProductTemplate,
  CFHeader.InsurPlcyCshFlwValdtyBeginDte AS InsurPlcyCshFlwValdtyBeginDte,
  CFHeader.InsurPlcyChangedByUser AS InsurPlcyChangedByUser,
  CFHeader.LastChangeDateTime AS LastChangeDateTime,
  _InsurancePolicy.InsrrIDByInsrr AS InsrrIDByInsrr,
  _InsurancePolicy.InsurPlcyAuthznSlsProductGroup AS InsurPlcyAuthznSlsProductGroup
FROM I_InsurPlcyCashFlowHeaderBasic AS CFHeader
LEFT OUTER JOIN I_Currency AS _Currency ON InsurPlcyCshFlwDocCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyCshFlwDocPostgState AS _InsurPlcyCshFlwDocPostgState ON InsurPlcyCshFlwDocPostingState = _InsurPlcyCshFlwDocPostgState.InsurPlcyCshFlwDocPostingState  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyCshFlwNoTransfRsn AS _InsurPlcyCshFlwNoTransfRsn ON InsurPlcyCshFlwDocNoTransfRsn = _InsurPlcyCshFlwNoTransfRsn.InsurPlcyCshFlwDocNoTransfRsn  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyBusinessObject AS _InsurPlcyBusinessObject ON InsurPlcyBusinessObject = _InsurPlcyBusinessObject.InsurPlcyBusinessObject  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyCshFlwDocOrigin AS _InsurPlcyCshFlwDocOrigin ON InsurPlcyCshFlwDocumentOrigin = _InsurPlcyCshFlwDocOrigin.InsurPlcyCshFlwDocumentOrigin  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyCashFlowHeader AS _InsurPlcyCashFlowRevDocHeader ON InsurPlcyCshFlwDocReversalDoc = _InsurPlcyCashFlowRevDocHeader.InsurPolicyCashFlowDocument  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyCashFlowHeader AS _InsurPlcyCshFlwCoinsurDocHdr ON InsurPlcyCshFlwDocCoinsurDoc = _InsurPlcyCshFlwCoinsurDocHdr.InsurPolicyCashFlowDocument  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyTemplateT AS _InsurPlcySlsProductTemplateT ON InsurPlcySalesProductTemplate = _InsurPlcySlsProductTemplateT.InsurPlcyTemplate  -- association [1..*]
LEFT OUTER JOIN I_InsurPlcyTemplateT AS _InsurPlcyProductTemplateT ON InsurPlcyProductTemplate = _InsurPlcyProductTemplateT.InsurPlcyTemplate  -- association [1..*]
LEFT OUTER JOIN I_InsurancePolicy AS _InsurancePolicy ON InsurPlcyUUID = _InsurancePolicy.InsurPlcyUUID  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyCashFlowItem AS _InsurPlcyCashFlowItem ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More