R_InsurancePolicyTaxJournalTP

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

Tax Journal - TP

R_InsurancePolicyTaxJournalTP is a Transactional CDS View that provides data about "Tax Journal - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyHghstVersPerAppl, I_InsurPlcyTaxJournalVersion) 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_InsurPlcyTaxJournalVersion TaxJournal from

Associations (2)

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

Annotations (11)

NameValueLevelField
EndUserText.label Tax Journal - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.sapObjectNodeType.name InsurancePolicyTaxJournal view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix TXJ view
Metadata.ignorePropagatedAnnotations true view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyTaxJournalVersion InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurPlcyTaxJournalVersion InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyTaxJournalVersion InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcyTaxJournalVersion InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurPlcyTaxJournalVersion InsurPlcyCoverageID Coverage Key
KEY InsurPlcyTaxJournalID I_InsurPlcyTaxJournalVersion InsurPlcyTaxJournalID Tax Journal
InsurPlcyOrderNumber I_InsurPlcyTaxJournalVersion InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType I_InsurPlcyTaxJournalVersion InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator I_InsurPlcyTaxJournalVersion InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlEndNmbr I_InsurPlcyTaxJournalVersion InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyJrnlNmbr I_InsurPlcyTaxJournalVersion InsurPlcyJrnlNmbr Journal Number
InsurPlcyProductPackageID I_InsurPlcyTaxJournalVersion InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyTaxJrnlIsCancelled I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlIsCancelled Rev. Flag
InsurPlcyTaxJrnlProcessingDate I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlProcessingDate Processing Date
InsurPlcyTaxJrnlProcessor I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlProcessor Processor
InsurPlcyTaxJrnlProcgStep I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlProcgStep Tax Proc. Step
InsurPlcyTaxJrnlTaxAssmtBase I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlTaxAssmtBase Tax Asmnt Basis
InsurPlcyTaxJrnlBaseAmount I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlBaseAmount Tax Asmt B Amt
InsurPlcyTaxJrnlStrtDate I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlStrtDate Tax Start Date
InsurPlcyTaxJrnlEndDate I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlEndDate Tax End Date
InsurPlcyTaxJrnlRecognition I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlRecognition Tax Recognition
InsurPlcyTaxJrnlCalcdBnftAmt I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlCalcdBnftAmt Calc. Ben. Val.
InsurPlcyTaxJrnlTotPremAmt I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlTotPremAmt Premium Total
InsurPlcyTaxJrnlPremWthdrwnAmt I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlPremWthdrwnAmt Withdrawn Prems
InsurPlcyTaxJrnlTaxAmt I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlTaxAmt Tax Amount
InsurPlcyTaxJrnlCurrency I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlCurrency Currency
InsurPlcyTaxJrnlIsChgTaxRecgn I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlIsChgTaxRecgn Chg. Tax Recog.
InsurPlcyTaxJrnlPremRatio I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlPremRatio Rat. NP to TP
InsurPlcyTaxJrnlBaseGrpID I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlBaseGrpID Tax Jour. Entry
InsurPlcyTaxJrnlIsFinished I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlIsFinished TaxJour.Concluded
InsurPlcyTaxJrnlCountry I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlCountry Country/Reg.
InsurPlcyTaxJrnlRegion I_InsurPlcyTaxJournalVersion InsurPlcyTaxJrnlRegion Region
InsurPlcyBusinessObject I_InsurPlcyTaxJournalVersion InsurPlcyBusinessObject
LastChangeDateTime I_InsurPlcyTaxJournalVersion LastChangeDateTime Timestamp
_Currency I_InsurPlcyTaxJournalVersion _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_InsurancePolicyTaxJournalTP.
-- 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_InsurancePolicyTaxJournalTP AS
SELECT
  TaxJournal.InsurPlcyUUID AS InsurPlcyUUID,
  TaxJournal.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  TaxJournal.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  TaxJournal.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  TaxJournal.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  TaxJournal.InsurPlcyTaxJournalID AS InsurPlcyTaxJournalID,
  TaxJournal.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  TaxJournal.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  TaxJournal.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  TaxJournal.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  TaxJournal.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  TaxJournal.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  TaxJournal.InsurPlcyTaxJrnlIsCancelled AS InsurPlcyTaxJrnlIsCancelled,
  TaxJournal.InsurPlcyTaxJrnlProcessingDate AS InsurPlcyTaxJrnlProcessingDate,
  TaxJournal.InsurPlcyTaxJrnlProcessor AS InsurPlcyTaxJrnlProcessor,
  TaxJournal.InsurPlcyTaxJrnlProcgStep AS InsurPlcyTaxJrnlProcgStep,
  TaxJournal.InsurPlcyTaxJrnlTaxAssmtBase AS InsurPlcyTaxJrnlTaxAssmtBase,
  TaxJournal.InsurPlcyTaxJrnlBaseAmount AS InsurPlcyTaxJrnlBaseAmount,
  TaxJournal.InsurPlcyTaxJrnlStrtDate AS InsurPlcyTaxJrnlStrtDate,
  TaxJournal.InsurPlcyTaxJrnlEndDate AS InsurPlcyTaxJrnlEndDate,
  TaxJournal.InsurPlcyTaxJrnlRecognition AS InsurPlcyTaxJrnlRecognition,
  TaxJournal.InsurPlcyTaxJrnlCalcdBnftAmt AS InsurPlcyTaxJrnlCalcdBnftAmt,
  TaxJournal.InsurPlcyTaxJrnlTotPremAmt AS InsurPlcyTaxJrnlTotPremAmt,
  TaxJournal.InsurPlcyTaxJrnlPremWthdrwnAmt AS InsurPlcyTaxJrnlPremWthdrwnAmt,
  TaxJournal.InsurPlcyTaxJrnlTaxAmt AS InsurPlcyTaxJrnlTaxAmt,
  TaxJournal.InsurPlcyTaxJrnlCurrency AS InsurPlcyTaxJrnlCurrency,
  TaxJournal.InsurPlcyTaxJrnlIsChgTaxRecgn AS InsurPlcyTaxJrnlIsChgTaxRecgn,
  TaxJournal.InsurPlcyTaxJrnlPremRatio AS InsurPlcyTaxJrnlPremRatio,
  TaxJournal.InsurPlcyTaxJrnlBaseGrpID AS InsurPlcyTaxJrnlBaseGrpID,
  TaxJournal.InsurPlcyTaxJrnlIsFinished AS InsurPlcyTaxJrnlIsFinished,
  TaxJournal.InsurPlcyTaxJrnlCountry AS InsurPlcyTaxJrnlCountry,
  TaxJournal.InsurPlcyTaxJrnlRegion AS InsurPlcyTaxJrnlRegion,
  TaxJournal.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  TaxJournal.LastChangeDateTime AS LastChangeDateTime,
  TaxJournal._Currency AS _Currency
FROM I_InsurPlcyTaxJournalVersion AS TaxJournal
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_InsurancePolicyTaxJournal AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyTaxJournalID = _Extension.InsurPlcyTaxJournalID  -- association [1..1]
;

Learn More