I_JP_TaxReallocationRoot

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 I_JP_TaxReallocationRoot.
-- 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: IJPTAXREALOC

CREATE VIEW I_JP_TaxReallocationRoot AS
SELECT
  JP_TaxReallocateUUID,
  CustomerProject,
  SalesOrder,
  SalesOrderItem,
  BillingPlan,
  BillingPlanItem,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  ChangedDateTime,
  _SalesOrder.SalesOrganization AS SalesOrganization,
  _SalesOrder.BillingCompanyCode AS BillingCompanyCode,
  _SDDocumentPartner[1:PartnerFunction='RE'].Customer AS BillToParty,
  _SDDocumentPartner[1:PartnerFunction='RE'].Customer AS Customer
FROM I_JP_TaxReallocationRootBasic
LEFT OUTER JOIN I_JP_TaxReallocationOffset AS _Offset ON JP_TaxReallocateUUID = _Offset.JP_TaxReallocateUUID  -- association [0..1]
LEFT OUTER JOIN I_JP_TaxReallocationResult AS _Result ON JP_TaxReallocateUUID = _Result.JP_TaxReallocateUUID  -- association [0..*]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON billingcompanycode = _CompanyCode.Company  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentPartner AS _SDDocumentPartner ON SalesOrder = _SDDocumentPartner.SDDocument  -- association [0..*]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON salesorganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON BillToParty = _Customer.Customer  -- association [1..1]
;