I_ID_PricingElementsGroupCube

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_ID_PricingElementsGroupCube.
-- 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: IIDPRICEGCUBE
-- Parameters: P_CompanyCode : fis_bukrs, P_FiscalYear : gjahr

CREATE VIEW I_ID_PricingElementsGroupCube AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  P_ID_StRpTaxItemFromBilling.TaxCode AS TaxCode,
  P_ID_StRpTaxItemFromBilling.TransactionTypeDetermination AS TransactionTypeDetermination,
  TaxBox,
  TaxDeclnAmountType,
  TaxItemGroupingVersion,
  TaxBoxStructureType AS UnifiedTaxBoxStructureType,
  TaxGroup,
  P_ID_StRpTaxItemFromBilling.BillingDocument AS BillingDocument,
  BillingDocumentItem,
  Material,
  TaxBoxStrucValidityStartDate,
  TaxBoxStrucValidityEndDate,
  BillingQuantity,
  BillingQuantityUnit,
  PostingDate,
  DocumentDate,
  I_StRpTaxItemGrpg.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  Ledger,
  P_ID_StRpTaxItemFromBilling.TaxReportingDate AS TaxReportingDate,
  P_ID_StRpTaxItemFromBilling.BusinessPlace AS BusinessPlace,
  P_ID_StRpTaxItemFromBilling.Customer AS Customer,
  P_ID_StRpTaxItemFromBilling.BillingDocumentItemText AS BillingDocumentItemText,
  P_ID_StRpTaxItemFromBilling.BillingDocumentType AS BillingDocumentType,
  P_ID_StRpTaxItemFromBilling.SalesOrganization AS SalesOrganization,
  cast(case when P_ID_StRpTaxItemFromBilling.DocumentReferenceID != '' then P_ID_StRpTaxItemFromBilling.DocumentReferenceID else AccountingDocument end as abap.char(35)) as DCoDocumentReference AS char35asDCoDocumentReference,
  substring(P_ID_StRpTaxItemFromBilling.DocumentReferenceID, 1, 2) AS AccrualTransactionType,
  substring(P_ID_StRpTaxItemFromBilling.DocumentReferenceID, 3, 1) AS CharcStatus,
  P_ID_StRpTaxItemFromBilling.NetAmount AS NetAmount,
  P_ID_StRpTaxItemFromBilling.GrossAmount AS GrossAmount,
  P_ID_StRpTaxItemFromBilling.Subtotal1Amount AS Subtotal1Amount,
  P_ID_StRpTaxItemFromBilling.Subtotal2Amount AS Subtotal2Amount,
  P_ID_StRpTaxItemFromBilling.Subtotal3Amount AS Subtotal3Amount,
  P_ID_StRpTaxItemFromBilling.Subtotal4Amount AS Subtotal4Amount,
  P_ID_StRpTaxItemFromBilling.Subtotal5Amount AS Subtotal5Amount,
  P_ID_StRpTaxItemFromBilling.Subtotal6Amount AS Subtotal6Amount,
  CompanyCodeCurrency,
  case when TaxBox = 'VAT_OUT_TAX' and P_T007B_GLO.stgrp = '1' then P_ID_StRpTaxItemFromBilling.TaxRate end as TaxRate AS TaxRateendasTaxRate,
  case when TaxBox = 'VAT_OUT_LUX' and P_T007B_GLO.stgrp = '3' then P_ID_StRpTaxItemFromBilling.TaxRate end as LuxuryTaxRate AS TaxRateendasLuxuryTaxRate,
  case when TaxBox = 'VAT_OUT_LUX' and P_T007B_GLO.stgrp = '3' then case when P_ID_StRpTaxItemFromBilling.TaxAmountinTransCrcy is initial then round(P_ID_StRpTaxItemFromBilling.NetAmount * division(P_ID_StRpTaxItemFromBilling.TaxRate,100,2), 2) else P_ID_StRpTaxItemFromBilling.TaxAmountinTransCrcy end end as LuxuryTaxAmt AS TaxAmountinTransCrcyendendasLuxuryTaxAmt
FROM P_ID_StRpTaxItemFromBilling
LEFT OUTER JOIN I_StRpTaxItemBoxConfiguration ON /* join condition not captured in parsed metadata */
;