I_IN_GSTRetsSlsRegDocument

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_GSTRetsSlsRegDocument.
-- 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_GSTRetsSlsRegDocument AS
SELECT
  P_IN_EDocSalesRegister.ElectronicDocUUID AS ElectronicDocUUID,
  P_IN_EDocSalesRegister.ElectronicDocSourceKey AS ElectronicDocSourceKey,
  P_IN_EDocSalesRegister.ElectronicDocCompanyCode AS CompanyCode,
  P_IN_EDocSalesRegister.ReportingCountry AS ReportingCountry,
  P_IN_EDocSalesRegister.AccountingDocument AS AccountingDocument,
  P_IN_EDocSalesRegister.FiscalYear AS FiscalYear,
  P_IN_EDocSalesRegister.BillingDocument AS BillingDocument,
  P_IN_EDocSalesRegister.IN_DocumentSectionCode AS IN_DocumentSectionCode,
  P_IN_EDocSalesRegister.IN_EDocEInvcExtNmbr AS IN_EDocEInvcExtNmbr,
  P_IN_EDocSalesRegister.TaxReportingDate AS ReportingDate,
  P_IN_EDocSalesRegister.ElectronicDocProcessStatus AS ElectronicDocProcessStatus,
  P_IN_EDocSalesRegister.ElectronicDocProcess AS ElectronicDocProcess,
  P_IN_EDocSalesRegister.IN_EDocEInvcEditActionFlag AS IN_EDocEInvcEditActionFlag,
  cast(abs( P_IN_GSTRetsSlsDocValue.TaxAmountInCoCodeCrcy + P_IN_GSTRetsSlsDocValue.TaxBaseAmountInCoCodeCrcy) as hwbas ) AS InvoiceGrossAmount,
  cast((P_IN_GSTRetsSlsDocValue.TaxAmountInCoCodeCrcy + P_IN_GSTRetsSlsDocValue.TaxBaseAmountInCoCodeCrcy) as hwbas ) AS GrossAmount,
  P_IN_GSTRetsSlsDocValue.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_IN_EDocSalesRegister.ElectronicDocSourceType AS ElectronicDocSourceType,
  P_IN_EDocSalesRegister.IN_EDocEInvcBusinessPlace AS BusinessPlace,
  P_IN_EDocSalesRegister.IN_GSTPlaceOfSupply AS IN_GSTPlaceOfSupply,
  P_IN_EDocSalesRegister.IN_GSTPlaceOfSupplyName AS IN_GSTPlaceOfSupplyName,
  P_IN_EDocSalesRegister.IN_IsGSTReverseCharged AS IN_IsGSTReverseCharged,
  P_IN_EDocSalesRegister.IN_DifferentialPercentageRate AS IN_DifferentialPercentageRate,
  P_IN_EDocSalesRegister.IN_NoteType AS IN_NoteType,
  P_IN_EDocSalesRegister.IN_HasNilType AS IN_HasNilType,
  P_IN_EDocSalesRegister.AddressNumber AS AddressNumber,
  P_IN_EDocSalesRegister.BusinessPartner AS IN_GSTPartner,
  P_IN_EDocSalesRegister.IN_InvoiceType AS IN_InvoiceType,
  _CompanyCode.Country AS Country,
  P_IN_EDocSalesRegister.IN_GSTIdentificationNumber AS IN_GSTIdentificationNumber,
  coalesce(P_IN_EDocSalesRegister.IN_PrtnGSTIdentificationNmbr,_JournalEntryOneTimeAcc.TaxID3) AS IN_PrtnGSTIdentificationNmbr,
  P_IN_EDocSalesRegister.BusinessPartnerFullName AS BusinessPartnerFullName,
  '' AS ReconciliationStatus,
  P_IN_EDocSalesRegister._BusPartAddrDepdntTaxNmbr AS _BusPartAddrDepdntTaxNmbr,
  P_IN_EDocSalesRegister._IN_ElectronicDocInvoice AS _IN_ElectronicDocInvoice,
  P_IN_EDocSalesRegister._ElectronicDocEInvc AS _ElectronicDocEInvc,
  P_IN_EDocSalesRegister._ElectronicDocEWbill AS _ElectronicDocEWbill,
  P_IN_EDocSalesRegister._JournalEntry AS _JournalEntry,
  P_IN_EDocSalesRegister.IN_EDocAmendmentDte AS IN_EDocAmendmentDte
FROM P_IN_EDocSalesRegister
INNER JOIN I_IN_BusinessPlace ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_IN_GSTRetsSlsRegTaxItem AS _GSTRetsSlsRegTaxItem ON _GSTRetsSlsRegTaxItem.ElectronicDocUUID = ElectronicDocUUID  -- association [0..*]
LEFT OUTER JOIN I_JournalEntryOneTimeAccount AS _JournalEntryOneTimeAcc ON _JournalEntryOneTimeAcc.CompanyCode = P_IN_EDocSalesRegister.ElectronicDocCompanyCode AND _JournalEntryOneTimeAcc.AccountingDocument = P_IN_EDocSalesRegister.AccountingDocument AND _JournalEntryOneTimeAcc.FiscalYear = P_IN_EDocSalesRegister.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON _JournalEntry.CompanyCode = P_IN_EDocSalesRegister.ElectronicDocCompanyCode AND _JournalEntry.AccountingDocument = I_BillingDocumentBasic.AccountingDocument AND _JournalEntry.FiscalYear = I_BillingDocumentBasic.FiscalYear  -- association [0..1]
-- UNION ALL with additional select branch(es): P_IN_EDocSalesRegister
;