R_InsurPlcyMnlPostgTxDetnTP

DDL: R_INSURPLCYMNLPOSTGTXDETNTP Type: view_entity TRANSACTIONAL
23 Fields 2 Data Sources 2 Associations

Mnl Posting Tax Detn - TP

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

Data Sources (2)

SourceAliasJoin Type
I_InsurPlcyMnlPostgTxDetnVers _MnlPostgTxDetn from
I_InsurPlcyHghstVersPerAppl HighestVersion inner

Associations (2)

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

Annotations (11)

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

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyMnlPostgTxDetnVers InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurPlcyMnlPostgTxDetnVers InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyMnlPostgTxDetnVers InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcyMnlPostgTxDetnVers InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurPlcyMnlPostgTxDetnVers InsurPlcyCoverageID Coverage Key
KEY InsurPlcyMnlSettlmtAmtID I_InsurPlcyMnlPostgTxDetnVers InsurPlcyMnlSettlmtAmtID Manual Posting
KEY InsurancePolicyManualTaxId I_InsurPlcyMnlPostgTxDetnVers InsurancePolicyManualTaxId Tax Determinat.
InsurPlcyOrderNumber I_InsurPlcyMnlPostgTxDetnVers InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType I_InsurPlcyMnlPostgTxDetnVers InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator I_InsurPlcyMnlPostgTxDetnVers InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlEndNmbr I_InsurPlcyMnlPostgTxDetnVers InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyJrnlNmbr I_InsurPlcyMnlPostgTxDetnVers InsurPlcyJrnlNmbr Journal Number
InsurPlcyProductPackageID I_InsurPlcyMnlPostgTxDetnVers InsurPlcyProductPackageID Prod. Pckg. Key
InsPlcyMnlPostgTxDetnIsCancld I_InsurPlcyMnlPostgTxDetnVers InsPlcyMnlPostgTxDetnIsCancld Rev. Flag
MnlPostgTxDetnSettlmtFrmDte I_InsurPlcyMnlPostgTxDetnVers MnlPostgTxDetnSettlmtFrmDte Settlement From
InPlMnlPostgTxDetnSettlmtToDte I_InsurPlcyMnlPostgTxDetnVers InPlMnlPostgTxDetnSettlmtToDte Settlement To
InsurPlcyMnlPostgTxDetnCrcy I_InsurPlcyMnlPostgTxDetnVers InsurPlcyMnlPostgTxDetnCrcy Currency
InsurPlcyMnlPostgTxDetnPrtlAmt I_InsurPlcyMnlPostgTxDetnVers InsurPlcyMnlPostgTxDetnPrtlAmt Partial Amount
InsurPlcyMnlPostgTxDetnDte I_InsurPlcyMnlPostgTxDetnVers InsurPlcyMnlPostgTxDetnDte Tax Determ.Date
InsurPlcyBusinessObject I_InsurPlcyMnlPostgTxDetnVers InsurPlcyBusinessObject
LastChangeDateTime I_InsurPlcyMnlPostgTxDetnVers LastChangeDateTime Timestamp
_Currency I_InsurPlcyMnlPostgTxDetnVers _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_InsurPlcyMnlPostgTxDetnTP.
-- 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_InsurPlcyMnlPostgTxDetnTP AS
SELECT
  _MnlPostgTxDetn.InsurPlcyUUID AS InsurPlcyUUID,
  _MnlPostgTxDetn.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  _MnlPostgTxDetn.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  _MnlPostgTxDetn.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  _MnlPostgTxDetn.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  _MnlPostgTxDetn.InsurPlcyMnlSettlmtAmtID AS InsurPlcyMnlSettlmtAmtID,
  _MnlPostgTxDetn.InsurancePolicyManualTaxId AS InsurancePolicyManualTaxId,
  _MnlPostgTxDetn.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  _MnlPostgTxDetn.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  _MnlPostgTxDetn.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  _MnlPostgTxDetn.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  _MnlPostgTxDetn.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  _MnlPostgTxDetn.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  _MnlPostgTxDetn.InsPlcyMnlPostgTxDetnIsCancld AS InsPlcyMnlPostgTxDetnIsCancld,
  _MnlPostgTxDetn.MnlPostgTxDetnSettlmtFrmDte AS MnlPostgTxDetnSettlmtFrmDte,
  _MnlPostgTxDetn.InPlMnlPostgTxDetnSettlmtToDte AS InPlMnlPostgTxDetnSettlmtToDte,
  _MnlPostgTxDetn.InsurPlcyMnlPostgTxDetnCrcy AS InsurPlcyMnlPostgTxDetnCrcy,
  _MnlPostgTxDetn.InsurPlcyMnlPostgTxDetnPrtlAmt AS InsurPlcyMnlPostgTxDetnPrtlAmt,
  _MnlPostgTxDetn.InsurPlcyMnlPostgTxDetnDte AS InsurPlcyMnlPostgTxDetnDte,
  _MnlPostgTxDetn.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  _MnlPostgTxDetn.LastChangeDateTime AS LastChangeDateTime,
  _MnlPostgTxDetn._Currency AS _Currency
FROM I_InsurPlcyMnlPostgTxDetnVers AS _MnlPostgTxDetn
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_InsurPlcyMnlPostgTxDetn AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyMnlSettlmtAmtID = _Extension.InsurPlcyMnlSettlmtAmtID AND InsurancePolicyManualTaxId = _Extension.InsurancePolicyManualTaxId  -- association [1..1]
;

Learn More