I_IN_GSTRetSalesRegRunCube

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_IN_GSTRetSalesRegRunCube.
-- 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.
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW I_IN_GSTRetSalesRegRunCube AS
SELECT
  I_IN_GSTRetsSlsRegDocument.ElectronicDocUUID AS ElectronicDocUUID,
  I_IN_GSTRetsSlsRegTaxItem.TaxItem AS TaxItem,
  I_IN_GSTRetsSlsRegTaxItem.TaxItemAcctgDocItemRef AS TaxItemAcctgDocItemRef,
  I_IN_GSTRetsSlsRegTaxItem.IndianTaxConditionName AS IndianTaxConditionName,
  I_IN_GSTRetsSlsRegDocument.CompanyCode AS CompanyCode,
  I_IN_GSTRetsSlsRegDocument.AccountingDocument AS AccountingDocument,
  I_IN_GSTRetsSlsRegDocument.FiscalYear AS FiscalYear,
  I_IN_GSTRetsSlsRegDocument.BillingDocument AS BillingDocument,
  I_IN_GSTRetsSlsRegTaxItem.TaxRate AS TaxRate,
  cast(I_IN_GSTRetsSlsRegTaxItem.TaxRate as abap.char(25) ) AS TaxRateInPercentAsText,
  I_IN_GSTRetsSlsRegDocument.IN_EDocEInvcExtNmbr AS IN_EDocEInvcExtNmbr,
  I_IN_GSTRetsSlsRegDocument.ReportingDate AS ReportingDate,
  I_IN_GSTRetsSlsRegDocument.ElectronicDocProcessStatus AS ElectronicDocProcessStatus,
  I_IN_GSTRetsSlsRegDocument.IN_EDocEInvcEditActionFlag AS IN_EDocEInvcEditActionFlag,
  I_IN_GSTRetsSlsRegDocument.InvoiceGrossAmount AS InvoiceGrossAmount,
  I_IN_GSTRetsSlsRegTaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_IN_GSTRetsSlsRegDocument.ElectronicDocSourceType AS ElectronicDocSourceType,
  I_IN_GSTRetsSlsRegDocument.Country AS Country,
  I_IN_GSTRetsSlsRegDocument.IN_GSTPlaceOfSupply AS IN_GSTPlaceOfSupply,
  I_IN_GSTRetsSlsRegDocument.IN_GSTPlaceOfSupplyName AS IN_GSTPlaceOfSupplyName,
  I_IN_GSTRetsSlsRegDocument.IN_IsGSTReverseCharged AS IN_IsGSTReverseCharged,
  I_IN_GSTRetsSlsRegDocument.IN_InvoiceType AS IN_InvoiceType,
  I_IN_GSTRetsSlsRegDocument.IN_NoteType AS IN_NoteType,
  I_IN_GSTRetsSlsRegDocument.IN_HasNilType AS IN_HasNilType,
  case when I_IN_GSTRetsSlsRegTaxItem.IN_GSTNilType = 'NR' then I_IN_GSTRetsSlsRegTaxItem.TaxBaseAmountInCoCodeCrcy else cast( 0.00 as hwbas) end as IN_NilAmountInCoCodeCrcy AS 00ashwbasendasIN_NilAmountInCoCodeCrcy,
  case when I_IN_GSTRetsSlsRegTaxItem.IN_GSTNilType = 'EX' then I_IN_GSTRetsSlsRegTaxItem.TaxBaseAmountInCoCodeCrcy else cast( 0.00 as hwbas) end as IN_ExpAmountInCoCodeCrcy AS 00ashwbasendasIN_ExpAmountInCoCodeCrcy,
  case when ( abs(I_IN_GSTRetsSlsRegTaxItem.IN_CentralGSTAmount) > 0 or abs(I_IN_GSTRetsSlsRegTaxItem.IN_IntegratedGSTAmount) > 0 or abs(I_IN_GSTRetsSlsRegTaxItem.IN_UnionGSTAmount) > 0 ) then I_IN_GSTRetsSlsRegTaxItem.TaxBaseAmountInCoCodeCrcy else cast( 0.00 as hwbas) end as TaxBaseAmountInCoCodeCrcy AS 00ashwbasendasTaxBaseAmountInCoCodeCrcy,
  I_IN_GSTRetsSlsRegTaxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  I_IN_GSTRetsSlsRegTaxItem.IN_IntegratedGSTAmount AS IN_IntegratedGSTAmount,
  I_IN_GSTRetsSlsRegTaxItem.IN_CentralGSTAmount AS IN_CentralGSTAmount,
  I_IN_GSTRetsSlsRegTaxItem.IN_CessGSTAmtInCoCodeCrcy AS IN_CessGSTAmtInCoCodeCrcy,
  I_IN_GSTRetsSlsRegTaxItem.IN_StateGSTAmount AS IN_StateGSTAmount,
  I_IN_GSTRetsSlsRegTaxItem.IN_UnionGSTAmount AS IN_UnionGSTAmount,
  I_IN_GSTRetsSlsRegTaxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_IN_GSTRetsSlsRegTaxItem.IN_GSTNilType AS IN_GSTNilType,
  I_IN_GSTRetsSlsRegDocument.IN_GSTIdentificationNumber AS IN_GSTIdentificationNumber,
  I_IN_GSTRetsSlsRegDocument.IN_PrtnGSTIdentificationNmbr AS IN_PrtnGSTIdentificationNmbr,
  I_IN_GSTRetsSlsRegDocument.BusinessPlace AS BusinessPlace,
  I_IN_GSTRetsSlsRegDocument.IN_DifferentialPercentageRate AS IN_DifferentialPercentageRate,
  I_IN_GSTRetsSlsRegTaxItem.IN_HSNOrSACCode AS IN_HSNOrSACCode,
  I_IN_GSTRetsSlsRegTaxItem.MaterialName AS MaterialName,
  I_IN_GSTRetsSlsRegTaxItem.SelectedValueIsExcluded AS SelectedValueIsExcluded,
  I_IN_GSTRetsSlsRegTaxItem.Quantity AS Quantity,
  I_IN_GSTRetsSlsRegTaxItem.QuantityUnit AS QuantityUnit,
  I_IN_GSTRetsSlsRegTaxItem.IN_GSTUnitQuantityCode AS IN_GSTUnitQuantityCode,
  I_IN_EDocReference.StatryRptgEntity AS StatryRptgEntity,
  I_IN_EDocReference.StatryRptCategory AS StatryRptCategory,
  I_IN_EDocReference.StatryRptRunID AS StatryRptRunID,
  I_IN_EDocReference.StatryRptRunUUID AS StatryRptRunUUID,
  I_IN_GSTRetsSlsRegTaxItem.IN_EDocAmendmentDte AS IN_EDocAmendmentDte
FROM I_IN_GSTRetsSlsRegDocument
INNER JOIN I_IN_GSTRetsSlsRegTaxItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_IN_EDocReference ON /* join condition not captured in parsed metadata */
;