C_InsurClmPaymentTP

DDL: C_INSURCLMPAYMENTTP Type: view_entity CONSUMPTION

Consumption View for Payments App

C_InsurClmPaymentTP is a Consumption CDS View that provides data about "Consumption View for Payments App" in SAP S/4HANA. It reads from 1 data source (I_InsurClmPaymentTP) and exposes 65 fields with key fields InsuranceClaim, InsurClmSubclm, InsurClmPayt, InsurClmPaytDraftUUID. It is exposed through 1 OData service (ICL_INSURCLMPAYMENT).

Data Sources (1)

SourceAliasJoin Type
I_InsurClmPaymentTP I_InsurClmPaymentTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Consumption View for Payments App view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view

OData Services (1)

ServiceBindingVersionContractRelease
ICL_INSURCLMPAYMENT ICL_UI_INSURCLMPAYMENT_O2 V2 C1 NOT_RELEASED

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmSubclm InsurClmSubclm Subclaim
KEY InsurClmPayt InsurClmPayt Payment Number
KEY InsurClmPaytDraftUUID InsurClmPaytDraftUUID
InsuranceClaimForEdit InsuranceClaimForEdit
InsurClmSubclmForEdit InsurClmSubclmForEdit
InsurClmSubclmTypeName InsurClmSubclmTypeName
InsurClmPaytSubobject InsurClmPaytSubobject
InsurClmPaymentIsParked InsurClmPaymentIsParked
InsurClmPaytIsFinalPayment InsurClmPaytIsFinalPayment
InsurClmPaytCat InsurClmPaytCat Rec.Type
InsurClmPaytCatName InsurClmPaytCatName
InsurClmPaymentType InsurClmPaymentType Payment Type
InsurClmPaymentCurrency InsurClmPaymentCurrency Currency
InsurClmDisplayCurrency InsurClmDisplayCurrency Currency
InsurClmPaytTotalAmount InsurClmPaytTotalAmount Payment Amount
InsurClmPaytRequestedAmount InsurClmPaytRequestedAmount Amount Requestd
InsurClmPaymentDatabaseStatus InsurClmPaymentDatabaseStatus Internal Status
InsurClmPaytStatusName InsurClmPaytStatusName
InsurClmAssignUUID InsurClmAssignUUID Link UUID
InsurClmPaytPostgDte InsurClmPaytPostgDte Posting Date
InsurClmPaytMethod InsurClmPaytMethod Payment Method
InsurClmPaytMethodName
InsurClmPaytCheque InsurClmPaytCheque Check Number
InsurClmBankID InsurClmBankID Bank Details
InsurClmPaytDocRefInSubLedger InsurClmPaytDocRefInSubLedger Doc. Ref.
InsurClmPaytDueDate InsurClmPaytDueDate Net Due Date
InsurClmPaytNote InsurClmPaytNote Purpose
InsurClmPaytHasAlreadyPaid InsurClmPaytHasAlreadyPaid Already Paid
InsurClmPaytHasAddlPayee InsurClmPaytHasAddlPayee Addl Payee
InsurClmPaytAddrNmbrForChecks InsurClmPaytAddrNmbrForChecks Address
InsurClmPaytCheckRcpntAddrNmbr InsurClmPaytCheckRcpntAddrNmbr Address
InsurClmServicePeriodStartDate InsurClmServicePeriodStartDate Service Start
InsurClmServicePeriodEndDate InsurClmServicePeriodEndDate Service End
CompanyCode CompanyCode Receiver Company Code
Country Country Venue: Ctry/Reg
TaxCalculationProcedure TaxCalculationProcedure Tax Procedure
InsuranceClaimPayee InsuranceClaimPayee Participant
InsuranceClaimPayeeName _Payee BusinessPartnerName Extracted Customer Name
InsuranceClaimPayer InsuranceClaimPayer Participant
InsuranceClaimPayerName _Payer BusinessPartnerName Extracted Customer Name
InsurClmPaytAdditionalPayee InsurClmPaytAdditionalPayee Participant
InsurClmPaytCheckRecipient InsurClmPaytCheckRecipient Participant
InsurLineOfBus InsurLineOfBus
BankDetailsOfBPAreRequired BankDetailsOfBPAreRequired
AddressDetailsAreRequired AddressDetailsAreRequired
InsurClmPaytMethodType InsurClmPaytMethodType
ChequeIsCreatedWithPaytMeth ChequeIsCreatedWithPaytMeth
InsurClmPaytProcessingCat InsurClmPaytProcessingCat
InsurClmPaytCatIsImplmtdInRap InsurClmPaytCatIsImplmtdInRap
InsurClmPaytDisbmtFldIsHidden InsurClmPaytDisbmtFldIsHidden
InsurClmPaytRefundFldIsHidden InsurClmPaytRefundFldIsHidden
InsurClmPaytCompnCalcIsHidden InsurClmPaytCompnCalcIsHidden
InsurClmPaytProcgCatIsHidden InsurClmPaytProcgCatIsHidden
InsuranceClaimIsNotDraft InsuranceClaimIsNotDraft
InsurClmPaytProcgCatIsDspdOnUI InsurClmPaytProcgCatIsDspdOnUI
InsurClmType InsurClmType Claim Type
InsurClmTypeGeneration InsurClmTypeGeneration Generation
InsurClmTypeVers InsurClmTypeVers Clm Type Versn
InsurClmAuthznGrp InsurClmAuthznGrp AuthGroup (VIP)
InsurClmImageURL InsurClmImageURL
InsurClmItmToPaytNavgnCntxtKey InsurClmItmToPaytNavgnCntxtKey
_PaytCompnCalcHdr _PaytCompnCalcHdr
_PaytCompnCalcItems _PaytCompnCalcItems
_Currency _Currency

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_InsurClmPaymentTP.
-- 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_InsurClmPaymentTP AS
SELECT
  InsuranceClaim,
  InsurClmSubclm,
  InsurClmPayt,
  InsurClmPaytDraftUUID,
  InsuranceClaimForEdit,
  InsurClmSubclmForEdit,
  InsurClmSubclmTypeName,
  InsurClmPaytSubobject,
  InsurClmPaymentIsParked,
  InsurClmPaytIsFinalPayment,
  InsurClmPaytCat,
  InsurClmPaytCatName,
  InsurClmPaymentType,
  InsurClmPaymentCurrency,
  InsurClmDisplayCurrency,
  InsurClmPaytTotalAmount,
  InsurClmPaytRequestedAmount,
  InsurClmPaymentDatabaseStatus,
  InsurClmPaytStatusName,
  InsurClmAssignUUID,
  InsurClmPaytPostgDte,
  InsurClmPaytMethod,
  _PaytMethod._Text[1:Language=$session.system_language].CAPaymentMethodName AS InsurClmPaytMethodName,
  InsurClmPaytCheque,
  InsurClmBankID,
  InsurClmPaytDocRefInSubLedger,
  InsurClmPaytDueDate,
  InsurClmPaytNote,
  InsurClmPaytHasAlreadyPaid,
  InsurClmPaytHasAddlPayee,
  InsurClmPaytAddrNmbrForChecks,
  InsurClmPaytCheckRcpntAddrNmbr,
  InsurClmServicePeriodStartDate,
  InsurClmServicePeriodEndDate,
  CompanyCode,
  Country,
  TaxCalculationProcedure,
  InsuranceClaimPayee,
  _Payee.BusinessPartnerName AS InsuranceClaimPayeeName,
  InsuranceClaimPayer,
  _Payer.BusinessPartnerName AS InsuranceClaimPayerName,
  InsurClmPaytAdditionalPayee,
  InsurClmPaytCheckRecipient,
  InsurLineOfBus,
  BankDetailsOfBPAreRequired,
  AddressDetailsAreRequired,
  InsurClmPaytMethodType,
  ChequeIsCreatedWithPaytMeth,
  InsurClmPaytProcessingCat,
  InsurClmPaytCatIsImplmtdInRap,
  InsurClmPaytDisbmtFldIsHidden,
  InsurClmPaytRefundFldIsHidden,
  InsurClmPaytCompnCalcIsHidden,
  InsurClmPaytProcgCatIsHidden,
  InsuranceClaimIsNotDraft,
  InsurClmPaytProcgCatIsDspdOnUI,
  InsurClmType,
  InsurClmTypeGeneration,
  InsurClmTypeVers,
  InsurClmAuthznGrp,
  InsurClmImageURL,
  InsurClmItmToPaytNavgnCntxtKey
FROM I_InsurClmPaymentTP
;