I_IN_GSTRetsSalesRegisterC

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_GSTRetsSalesRegisterC.
-- 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 I_IN_GSTRetsSalesRegisterC AS
SELECT
  I_IN_GSTRetsSlsRegDocument.ElectronicDocUUID AS ElectronicDocUUID,
  _IN_GSTRetsSlsRegTaxItem.TaxItem AS TaxItem,
  _IN_GSTRetsSlsRegTaxItem.TaxItemAcctgDocItemRef AS TaxItemAcctgDocItemRef,
  _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,
  _IN_GSTRetsSlsRegTaxItem.TaxRate AS TaxRate,
  cast(_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,
  _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 _IN_GSTRetsSlsRegTaxItem.IN_GSTNilType = 'NR' then _IN_GSTRetsSlsRegTaxItem.TaxBaseAmountInCoCodeCrcy else cast( 0.00 as hwbas) end as IN_NilAmountInCoCodeCrcy AS 00ashwbasendasIN_NilAmountInCoCodeCrcy,
  case when _IN_GSTRetsSlsRegTaxItem.IN_GSTNilType = 'EX' then _IN_GSTRetsSlsRegTaxItem.TaxBaseAmountInCoCodeCrcy else cast( 0.00 as hwbas) end as IN_ExpAmountInCoCodeCrcy AS 00ashwbasendasIN_ExpAmountInCoCodeCrcy,
  case when ( abs(_IN_GSTRetsSlsRegTaxItem.IN_CentralGSTAmount) > 0 or abs(_IN_GSTRetsSlsRegTaxItem.IN_IntegratedGSTAmount) > 0 or _IN_GSTRetsSlsRegTaxItem.IN_GSTNilType = 'NR'or _IN_GSTRetsSlsRegTaxItem.IN_GSTNilType = 'EX' or _IN_GSTRetsSlsRegTaxItem.IN_GSTNilType = 'NG' or I_IN_GSTRetsSlsRegDocument.IN_DocumentSectionCode = 'NIL' ) then _IN_GSTRetsSlsRegTaxItem.TaxBaseAmountInCoCodeCrcy else cast( 0.00 as hwbas) end as TaxBaseAmountInCoCodeCrcy AS 00ashwbasendasTaxBaseAmountInCoCodeCrcy,
  _IN_GSTRetsSlsRegTaxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  _IN_GSTRetsSlsRegTaxItem.IN_IntegratedGSTAmount AS IN_IntegratedGSTAmount,
  _IN_GSTRetsSlsRegTaxItem.IN_CentralGSTAmount AS IN_CentralGSTAmount,
  _IN_GSTRetsSlsRegTaxItem.IN_CessGSTAmtInCoCodeCrcy AS IN_CessGSTAmtInCoCodeCrcy,
  _IN_GSTRetsSlsRegTaxItem.IN_StateGSTAmount AS IN_StateGSTAmount,
  _IN_GSTRetsSlsRegTaxItem.IN_UnionGSTAmount AS IN_UnionGSTAmount,
  case when ( abs(_IN_GSTRetsSlsRegTaxItem.IN_CentralGSTAmount) > 0 or abs(_IN_GSTRetsSlsRegTaxItem.IN_IntegratedGSTAmount) > 0 ) then _IN_GSTRetsSlsRegTaxItem.IN_NetAdvanceAmount else cast( 0.00 as hwbas) end as IN_NetAdvanceAmount AS 00ashwbasendasIN_NetAdvanceAmount,
  _IN_GSTRetsSlsRegTaxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  _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,
  _IN_GSTRetsSlsRegTaxItem.IN_HSNOrSACCode AS IN_HSNOrSACCode,
  _IN_GSTRetsSlsRegTaxItem.MaterialName AS MaterialName,
  _IN_GSTRetsSlsRegTaxItem.SelectedValueIsExcluded AS SelectedValueIsExcluded,
  _IN_GSTRetsSlsRegTaxItem.Quantity AS Quantity,
  _IN_GSTRetsSlsRegTaxItem.QuantityUnit AS QuantityUnit,
  _IN_GSTRetsSlsRegTaxItem.IN_GSTUnitQuantityCode AS IN_GSTUnitQuantityCode,
  _IN_GSTRetsSlsRegTaxItem.IN_EDocAmendmentDte AS IN_EDocAmendmentDte,
  _InvoiceTaxAttribute.IN_ShippingBillDate AS IN_ShippingBillDate,
  _InvoiceTaxAttribute.IN_ShippingBillNumber AS IN_ShippingBillNumber,
  _InvoiceTaxAttribute.IN_ShippingBillPortNumber AS IN_ShippingBillPortNumber
FROM I_IN_GSTRetsSlsRegDocument
LEFT OUTER JOIN I_IN_GSTRetsSlsRegTaxItem AS _IN_GSTRetsSlsRegTaxItem ON _IN_GSTRetsSlsRegTaxItem.ElectronicDocUUID = I_IN_GSTRetsSlsRegDocument.ElectronicDocUUID AND _IN_GSTRetsSlsRegTaxItem.CompanyCode = I_IN_GSTRetsSlsRegDocument.CompanyCode  -- association [0..*]
LEFT OUTER JOIN I_IN_OutgInvcTxAttrib AS _InvoiceTaxAttribute ON _InvoiceTaxAttribute.BillingDocument = I_IN_GSTRetsSlsRegDocument.BillingDocument  -- association [0..1]
;