R_InsurPlcyManualCostPostingTP

DDL: R_INSURPLCYMANUALCOSTPOSTINGTP Type: view_entity TRANSACTIONAL
36 Fields 2 Data Sources 2 Associations

Manual Cost Posting - TP

R_InsurPlcyManualCostPostingTP is a Transactional CDS View that provides data about "Manual Cost Posting - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyHghstVersPerAppl, I_InsurPlcyMnlCostPostgVersion) and exposes 36 fields with key fields InsurPlcyUUID, InsurPlcyApplUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurPlcyHghstVersPerAppl HighestVersion inner
I_InsurPlcyMnlCostPostgVersion MnlCostPostg from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_InsurancePolicyTP_3 _Policy $projection.InsurPlcyUUID = _Policy.InsurPlcyUUID and $projection.InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID
[1..1] E_InsurPlcyManualCostPosting _Extension ( $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID or $projection.InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID and $projection.InsurPlcyManualCostPostingID = _Extension.InsurPlcyManualCostPostingID

Annotations (11)

NameValueLevelField
EndUserText.label Manual Cost Posting - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.sapObjectNodeType.name InsurPlcyManualCostPosting view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix MCP view
Metadata.ignorePropagatedAnnotations true view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyMnlCostPostgVersion InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurPlcyMnlCostPostgVersion InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyMnlCostPostgVersion InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcyMnlCostPostgVersion InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurPlcyMnlCostPostgVersion InsurPlcyCoverageID Coverage Key
KEY InsurPlcyManualCostPostingID I_InsurPlcyMnlCostPostgVersion InsurPlcyManualCostPostingID Manual Posting
InsurPlcyOrderNumber I_InsurPlcyMnlCostPostgVersion InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType I_InsurPlcyMnlCostPostgVersion InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator I_InsurPlcyMnlCostPostgVersion InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlEndNmbr I_InsurPlcyMnlCostPostgVersion InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyJrnlNmbr I_InsurPlcyMnlCostPostgVersion InsurPlcyJrnlNmbr Journal Number
InsurPlcyProductPackageID I_InsurPlcyMnlCostPostgVersion InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyMnlCostIsCancelled I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostIsCancelled Rev. Flag
InsurPlcyMnlCostPostgTargetID I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostPostgTargetID Posting Target
InsurPlcyMnlCostPostgPartnerID I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostPostgPartnerID BusPartner
InsurPlcyMnlCostPostgAddrNmbr I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostPostgAddrNmbr Address
InsurPlcyMnlCostSettlmtFrmDte I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostSettlmtFrmDte Settlement From
InsurPlcyMnlCostSettlmtToDte I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostSettlmtToDte Settlement To
InsurPlcyMnlCostPostgCodeID I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostPostgCodeID Posting Code
InsurPlcyMnlCostPostgText I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostPostgText Posting Text
InsurPlcyMnlCostPostgDebitID I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostPostgDebitID Posting Code
InsurPlcyMnlCostPostgDebitText I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostPostgDebitText Posting Text
InsurPlcyMnlCostPostgRcpntID I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostPostgRcpntID Recipient
InsurPlcyMnlCostPostgPaytMeth I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostPostgPaytMeth Payment Method
InsurPlcyMnlCostPostgCostAmt I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostPostgCostAmt Cost Amount
InsurPlcyMnlCostPostgCrcy I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostPostgCrcy Currency
InsurPlcyMnlCostPostgPayer I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostPostgPayer Payer
InsurPlcyMnlCostPostgDebitAmt I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostPostgDebitAmt Debit Amount
InsurPlcyMnlCostPostgIsSettled I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostPostgIsSettled Settled
InsurPlcyMnlCostPostgBankDetID I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostPostgBankDetID Bank Details
InsurPlcyMnlCostExchRateDte I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostExchRateDte Exchange Rate Date
InsurPlcyMnlCostPostgExchRate I_InsurPlcyMnlCostPostgVersion InsurPlcyMnlCostPostgExchRate Exch Rate Doc Crcy
InsurPlcyBusinessObject I_InsurPlcyMnlCostPostgVersion InsurPlcyBusinessObject
LastChangeDateTime I_InsurPlcyMnlCostPostgVersion LastChangeDateTime Timestamp
_Currency I_InsurPlcyMnlCostPostgVersion _Currency
_Policy _Policy

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_InsurPlcyManualCostPostingTP.
-- 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_InsurPlcyManualCostPostingTP AS
SELECT
  MnlCostPostg.InsurPlcyUUID AS InsurPlcyUUID,
  MnlCostPostg.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  MnlCostPostg.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  MnlCostPostg.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  MnlCostPostg.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  MnlCostPostg.InsurPlcyManualCostPostingID AS InsurPlcyManualCostPostingID,
  MnlCostPostg.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  MnlCostPostg.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  MnlCostPostg.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  MnlCostPostg.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  MnlCostPostg.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  MnlCostPostg.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  MnlCostPostg.InsurPlcyMnlCostIsCancelled AS InsurPlcyMnlCostIsCancelled,
  MnlCostPostg.InsurPlcyMnlCostPostgTargetID AS InsurPlcyMnlCostPostgTargetID,
  MnlCostPostg.InsurPlcyMnlCostPostgPartnerID AS InsurPlcyMnlCostPostgPartnerID,
  MnlCostPostg.InsurPlcyMnlCostPostgAddrNmbr AS InsurPlcyMnlCostPostgAddrNmbr,
  MnlCostPostg.InsurPlcyMnlCostSettlmtFrmDte AS InsurPlcyMnlCostSettlmtFrmDte,
  MnlCostPostg.InsurPlcyMnlCostSettlmtToDte AS InsurPlcyMnlCostSettlmtToDte,
  MnlCostPostg.InsurPlcyMnlCostPostgCodeID AS InsurPlcyMnlCostPostgCodeID,
  MnlCostPostg.InsurPlcyMnlCostPostgText AS InsurPlcyMnlCostPostgText,
  MnlCostPostg.InsurPlcyMnlCostPostgDebitID AS InsurPlcyMnlCostPostgDebitID,
  MnlCostPostg.InsurPlcyMnlCostPostgDebitText AS InsurPlcyMnlCostPostgDebitText,
  MnlCostPostg.InsurPlcyMnlCostPostgRcpntID AS InsurPlcyMnlCostPostgRcpntID,
  MnlCostPostg.InsurPlcyMnlCostPostgPaytMeth AS InsurPlcyMnlCostPostgPaytMeth,
  MnlCostPostg.InsurPlcyMnlCostPostgCostAmt AS InsurPlcyMnlCostPostgCostAmt,
  MnlCostPostg.InsurPlcyMnlCostPostgCrcy AS InsurPlcyMnlCostPostgCrcy,
  MnlCostPostg.InsurPlcyMnlCostPostgPayer AS InsurPlcyMnlCostPostgPayer,
  MnlCostPostg.InsurPlcyMnlCostPostgDebitAmt AS InsurPlcyMnlCostPostgDebitAmt,
  MnlCostPostg.InsurPlcyMnlCostPostgIsSettled AS InsurPlcyMnlCostPostgIsSettled,
  MnlCostPostg.InsurPlcyMnlCostPostgBankDetID AS InsurPlcyMnlCostPostgBankDetID,
  MnlCostPostg.InsurPlcyMnlCostExchRateDte AS InsurPlcyMnlCostExchRateDte,
  MnlCostPostg.InsurPlcyMnlCostPostgExchRate AS InsurPlcyMnlCostPostgExchRate,
  MnlCostPostg.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  MnlCostPostg.LastChangeDateTime AS LastChangeDateTime,
  MnlCostPostg._Currency AS _Currency
FROM I_InsurPlcyMnlCostPostgVersion AS MnlCostPostg
INNER JOIN I_InsurPlcyHghstVersPerAppl AS HighestVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_InsurancePolicyTP_3 AS _Policy ON InsurPlcyUUID = _Policy.InsurPlcyUUID AND InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID  -- association [1..1]
LEFT OUTER JOIN E_InsurPlcyManualCostPosting AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyManualCostPostingID = _Extension.InsurPlcyManualCostPostingID  -- association [1..1]
;

Learn More