C_JP_TaxReallocation

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_JP_TaxReallocation.
-- 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.
-- SQL view name: CJPTAXREALLOC

CREATE VIEW C_JP_TaxReallocation AS
SELECT
  Detail.CustomerProject AS CustomerProject,
  Detail.SalesOrder AS SalesOrder,
  cast(Detail.SalesOrderItem as sales_order_item preserving type ) AS SalesOrderItem,
  Detail.BillingPlan AS BillingPlan,
  Detail.BillingPlanItem AS BillingPlanItem,
  Detail.BillingDocument AS BillingDocument,
  Detail.BillingDocumentItem AS BillingDocumentItem,
  _TaxReallocation.JP_TaxReallocateUUID AS JP_TaxReallocateUUID,
  Detail.Product AS Product,
  Detail.WBSElementExternalID AS WBSElementExternalID,
  _PricingElement.TaxCode AS TaxCode,
  _PricingElement.ConditionRateRatio AS ConditionRateRatio,
  _PricingElement.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  _WorkPackage.WorkPackage AS WorkPackage,
  Detail.SalesOrganization AS SalesOrganization,
  Detail.SalesOrderCondition AS SalesOrderCondition,
  Detail.BillToParty AS BillToParty,
  Detail.BillingPlanBillingDate AS BillingPlanBillingDate,
  Detail.BillingPlanRelatedBillgStatus AS BillingPlanRelatedBillgStatus,
  _BillingPlanRelatedBillgStatus._Text[1: Language = $session.system_language ].BillingPlanRelatedBillgStsDesc AS BillingPlanRelatedBillgStsDesc,
  Detail.BillingPlanServiceStartDate AS BillingPlanServiceStartDate,
  Detail.BillingPlanServiceEndDate AS BillingPlanServiceEndDate,
  Detail.BillingPlanAmount AS BillingPlanAmount,
  Detail.TransactionCurrency AS TransactionCurrency,
  Detail.DebitMemoRequest AS DebitMemoRequest,
  Detail.ProjectBillingRequest AS ProjectBillingRequest,
  Detail.BillingDocumentRequest AS BillingDocumentRequest,
  Detail.BillingDocumentDate AS BillingDocumentDate,
  Detail.OverallBillingStatus AS OverallBillingStatus,
  _OverallBillingStatus._Text[1: Language = $session.system_language ].OverallBillingStatusDesc AS OverallBillingStatusDesc,
  Detail.TotalNetAmount AS TotalNetAmount,
  Detail.TotalTaxAmount AS TotalTaxAmount,
  Detail.BillDocItemTaxAmt AS BillDocItemTaxAmt,
  Detail.ItemNetAmount AS ItemNetAmount,
  Detail.CompanyCode AS CompanyCode,
  Detail.AccountingDocument AS AccountingDocument,
  Detail.FiscalYear AS FiscalYear,
  Detail.DocumentReferenceID AS DocumentReferenceID,
  cast( 0 as wmwst_shl ) AS TaxAmount,
  cast( 0 as fwbas_shl) AS TaxBaseAmountInTransCrcy,
  cast( '' as waers) AS DocumentCurrency,
  Detail.JP_TaxOffsetStatus AS JP_TaxOffsetStatus,
  Detail.IsReversed AS IsReversed,
  _OffsetStatus._Text[1: Language = $session.system_language ].JP_TaxOffsetStatusDesc AS JP_TaxOffsetStatusDesc,
  Detail.JP_TaxReallocationStatus AS JP_TaxReallocationStatus,
  _ReallocationStatus._Text[1: Language = $session.system_language ].JP_TaxReallocationStatusDesc AS JP_TaxReallocationStatusDesc,
  cast(' ' as abap_boolean preserving type) AS BPCustMultiAddrIsActive
FROM I_JP_TaxReallocationDetail AS Detail
LEFT OUTER JOIN I_JP_TaxReallocationRoot AS _TaxReallocation ON CustomerProject = _TaxReallocation.CustomerProject AND BillingPlan = _TaxReallocation.BillingPlan AND BillingPlanItem = _TaxReallocation.BillingPlanItem AND SalesOrder = _TaxReallocation.SalesOrder AND SalesOrderItem = _TaxReallocation.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_PricingElement AS _PricingElement ON SalesOrderCondition = _PricingElement.PricingDocument AND SalesOrderItem = _PricingElement.PricingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_BillingPlanRelatedBillgSts AS _BillingPlanRelatedBillgStatus ON BillingPlanRelatedBillgStatus = _BillingPlanRelatedBillgStatus.BillingPlanRelatedBillgStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallBillingStatus AS _OverallBillingStatus ON OverallBillingStatus = _OverallBillingStatus.OverallBillingStatus  -- association [0..1]
LEFT OUTER JOIN I_JP_TaxReallocationStatus AS _ReallocationStatus ON JP_TaxReallocationStatus = _ReallocationStatus.JP_TaxReallocationStatus  -- association [0..1]
LEFT OUTER JOIN I_JP_TaxReallocationOffsetSts AS _OffsetStatus ON JP_TaxOffsetStatus = _OffsetStatus.JP_TaxOffsetStatus  -- association [0..1]
LEFT OUTER JOIN P_JP_SalesOrderWorkPackageAgg AS _WorkPackage ON SalesOrder = _WorkPackage.SalesOrder AND SalesOrderItem = _WorkPackage.SalesOrderItem  -- association [0..1]
;