R_InsurPlcyCashFlowItemTP

DDL: R_INSURPLCYCASHFLOWITEMTP Type: view_entity TRANSACTIONAL
38 Fields 1 Data Sources 1 Associations

Cashflow Document Item

R_InsurPlcyCashFlowItemTP is a Transactional CDS View that provides data about "Cashflow Document Item" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyCashFlowItemBsBasic) and exposes 38 fields with key fields InsurPolicyCashFlowDocument, InsurPlcyCashFlowDocumentItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyCashFlowItemBsBasic I_InsurPlcyCashFlowItemBsBasic from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_InsurancePolicyCashFlowItem _Extension $projection.InsurPolicyCashFlowDocument = _Extension.InsurPolicyCashFlowDocument and $projection.InsurPlcyCashFlowDocumentItem = _Extension.InsurPlcyCashFlowDocumentItem

Annotations (13)

NameValueLevelField
EndUserText.label Cashflow Document Item view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix CFI view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.allowNewCompositions true view
AbapCatalog.extensibility.quota.maximumFields 250 view
AbapCatalog.extensibility.quota.maximumBytes 2500 view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY InsurPolicyCashFlowDocument InsurPolicyCashFlowDocument CF Document No.
KEY InsurPlcyCashFlowDocumentItem InsurPlcyCashFlowDocumentItem Item Number
InsurPlcyCshFlwAmtInCshFlwCrcy InsurPlcyCshFlwAmtInCshFlwCrcy Srch./Disc.Amt
InsurPlcyCshFlwDocCurrency InsurPlcyCshFlwDocCurrency
InsurPlcyCshFlwDocItmPostgType InsurPlcyCshFlwDocItmPostgType Posting Type
InsurPlcyCshFlwDocItmPostgCode InsurPlcyCshFlwDocItmPostgCode Posting Code
InsurPlcyAccountAssignmentText InsurPlcyAccountAssignmentText Acct assignment
InsurancePolicyCoinsuranceKey InsurancePolicyCoinsuranceKey Coinsurance Key
InsurPlcyCoinsurDocCategory InsurPlcyCoinsurDocCategory Category
InsurPlcyCoveragePackageID InsurPlcyCoveragePackageID Cov.Package ID
InsurPlcyCoverageID InsurPlcyCoverageID Coverage Key
InsurPlcyCoverageOptionID InsurPlcyCoverageOptionID Cov. Option Key
InsurPlcyElementaryProdTmpl InsurPlcyElementaryProdTmpl Element. Prod.
InsurPlcyCshFlwDocItmIsStstcl InsurPlcyCshFlwDocItmIsStstcl Statistical
InsurPlcyStepOfProcessing InsurPlcyStepOfProcessing Step of Caller
InsurancePolicyInsuranceObject InsurancePolicyInsuranceObject Posting Target
InsurContrAcct InsurContrAcct ContractAcctNo.
InsurPlcyCshFlwDocumentItemBP InsurPlcyCshFlwDocumentItemBP BusPartner
InsurPlcyCashFlowAddressNumber InsurPlcyCashFlowAddressNumber
InsurPlcyPaymentMethod InsurPlcyPaymentMethod Payment Method
InsurPlcyCashFlowBkAcctDet InsurPlcyCashFlowBkAcctDet Bank Details
InsurPlcyCreditCardNumber InsurPlcyCreditCardNumber Pymnt Card No.
InsurPlcyMnlCostPostgText InsurPlcyMnlCostPostgText Posting Text
InsurPlcyAltvBusinessPartner InsurPlcyAltvBusinessPartner Alt. Partner
InsurPlcyAltvAddressNumber InsurPlcyAltvAddressNumber Alt. Add. No.
InsurPlcyAltvBankAccount InsurPlcyAltvBankAccount Alt. Bank Det.
InsurPlcyAltvCardNumber InsurPlcyAltvCardNumber Alt. Card ID
InsurPlcyAltvPostingTarget InsurPlcyAltvPostingTarget Alt. Pst Target
InsurPlcyAltvPostgTgtBizPrtn InsurPlcyAltvPostgTgtBizPrtn Alt. Bus. Prtnr
InsurPlcyCshFlwDocItmTxCode InsurPlcyCshFlwDocItmTxCode TxCde:Oth.Taxes
InsurPlcyCshFlwDocItmDocNmbr InsurPlcyCshFlwDocItmDocNmbr DocNoCntrCurAcc
InsurPlcyAmountInLocalCurrency InsurPlcyAmountInLocalCurrency Amnt Loc.Crcy
InsurPlcyAmountInRiskCurrency InsurPlcyAmountInRiskCurrency Amnt Risk Curr.
InsurancePolicyLocalCurrency InsurancePolicyLocalCurrency
InsurPlcyRiskCurrency InsurPlcyRiskCurrency
InsurPlcyChangedByUser InsurPlcyChangedByUser Processor
LastChangeDateTime LastChangeDateTime Timestamp
_CashFlowDocumentHeader _CashFlowDocumentHeader

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 R_InsurPlcyCashFlowItemTP.
-- 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 R_InsurPlcyCashFlowItemTP AS
SELECT
  InsurPolicyCashFlowDocument,
  InsurPlcyCashFlowDocumentItem,
  InsurPlcyCshFlwAmtInCshFlwCrcy,
  InsurPlcyCshFlwDocCurrency,
  InsurPlcyCshFlwDocItmPostgType,
  InsurPlcyCshFlwDocItmPostgCode,
  InsurPlcyAccountAssignmentText,
  InsurancePolicyCoinsuranceKey,
  InsurPlcyCoinsurDocCategory,
  InsurPlcyCoveragePackageID,
  InsurPlcyCoverageID,
  InsurPlcyCoverageOptionID,
  InsurPlcyElementaryProdTmpl,
  InsurPlcyCshFlwDocItmIsStstcl,
  InsurPlcyStepOfProcessing,
  InsurancePolicyInsuranceObject,
  InsurContrAcct,
  InsurPlcyCshFlwDocumentItemBP,
  InsurPlcyCashFlowAddressNumber,
  InsurPlcyPaymentMethod,
  InsurPlcyCashFlowBkAcctDet,
  InsurPlcyCreditCardNumber,
  InsurPlcyMnlCostPostgText,
  InsurPlcyAltvBusinessPartner,
  InsurPlcyAltvAddressNumber,
  InsurPlcyAltvBankAccount,
  InsurPlcyAltvCardNumber,
  InsurPlcyAltvPostingTarget,
  InsurPlcyAltvPostgTgtBizPrtn,
  InsurPlcyCshFlwDocItmTxCode,
  InsurPlcyCshFlwDocItmDocNmbr,
  InsurPlcyAmountInLocalCurrency,
  InsurPlcyAmountInRiskCurrency,
  InsurancePolicyLocalCurrency,
  InsurPlcyRiskCurrency,
  InsurPlcyChangedByUser,
  LastChangeDateTime
FROM I_InsurPlcyCashFlowItemBsBasic
LEFT OUTER JOIN E_InsurancePolicyCashFlowItem AS _Extension ON InsurPolicyCashFlowDocument = _Extension.InsurPolicyCashFlowDocument AND InsurPlcyCashFlowDocumentItem = _Extension.InsurPlcyCashFlowDocumentItem  -- association [1..1]
;

Learn More