I_IN_GSTR6DistrInvoiceCube

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_GSTR6DistrInvoiceCube.
-- 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_GSTR6DistrInvoiceCube AS
SELECT
  DistributedInv.ElectronicDocUUID AS ElectronicDocUUID,
  DistributedInv.ElectronicDocCompanyCode AS ElectronicDocCompanyCode,
  DistributedInv.InputServiceDistrBusPlace AS InputServiceDistrBusPlace,
  DistributedInv.IN_EDocFiscalYear AS IN_EDocFiscalYear,
  DistributedInv.AccountingDocument AS AccountingDocument,
  DistributedInv.ElectronicDocCountry AS ElectronicDocCountry,
  DistributedInv.ElectronicDocSourceType AS ElectronicDocSourceType,
  DistributedInv.ElectronicDocType AS ElectronicDocType,
  DistributedInv.ElectronicDocSourceKey AS ElectronicDocSourceKey,
  DistributedInv.ElectronicDocProcessStatus AS ElectronicDocProcessStatus,
  DistributedInv.IN_EDocGSTRetsBusinessPlace AS IN_EDocGSTRetsBusinessPlace,
  DistributedInv.IN_DocumentSectionCode AS IN_DocumentSectionCode,
  DistributedInv.IN_GSTPlaceOfSupply AS IN_GSTPlaceOfSupply,
  DistributedInv.IN_InvoiceType AS IN_InvoiceType,
  DistributedInv.IN_NoteType AS IN_NoteType,
  _IN_BusinessPlace.IN_GSTIdentificationNumber AS IN_GSTIdentificationNumber,
  DistributedInv.TaxCalculationProcedure AS TaxCalculationProcedure,
  DistributedInv.DocumentDate AS DocumentDate,
  DistributedInv.PostingDate AS PostingDate,
  DistributedInv.Currency AS CompanyCodeCurrency,
  DistributedInv.IN_InptSrvcDistrDocType AS IN_InptSrvcDistrDocType,
  DistributedInv.IncomingAccountingDocument AS IncomingAccountingDocument,
  IncomingDocuments.ElectronicDocProcessStatus AS IncomingAccountingDocStatus,
  IncomingDocuments.IN_EDocInptTaxCrdtAccptdDate AS IN_EDocInptTaxCrdtAccptdDate,
  IncomingDocuments.IN_EDocInptTaxCrdtAccptdPeriod AS IN_EDocInptTaxCrdtAccptdPeriod,
  cast(IncomingDocuments.ElectronicDocUUID as edoc_guid) AS IncomingAccountingDocUUID,
  DistributedInv.IN_EDocEInvcEditActionFlag AS IN_EDocEInvcEditActionFlag,
  DistributedInv.ReceivingBusPlaceCentralGST AS ReceivingBusPlaceCentralGST,
  DistributedInv.ReceivingBusPlaceStateGST AS ReceivingBusPlaceStateGST,
  DistributedInv.ReceivingBusPlaceIntegratedGST AS ReceivingBusPlaceIntegratedGST,
  DistributedInv.ReceivingBusPlaceCESS AS ReceivingBusPlaceCESS,
  DistributedInv.TaxIsNotDeductible AS TaxIsNotDeductible,
  DistributedInv.ReceivingBusPlace AS ReceivingBusPlace,
  DistributedInv.CntrlGST AS CntrlGST,
  DistributedInv.StateGST AS StateGST,
  DistributedInv.IntegratedGST AS IntegratedGST,
  DistributedInv.InputServiceDistrTaxCESS AS InputServiceDistrTaxCESS,
  DistributedInv.IN_HSNOrSACCode AS IN_HSNOrSACCode,
  DistributedInv.IN_InptSrvcDistrInvc AS IN_InptSrvcDistrInvc,
  DistributedInv.IN_InptSrvcDistrInvcFsclYr AS IN_InptSrvcDistrInvcFsclYr,
  _gststatecodemap.IN_GSTLegalStateCode AS IN_GSTLegalStateCode
FROM P_IN_GSTR6DistrInvoices AS DistributedInv
INNER JOIN I_IN_EDocGSTPurRegDoc AS IncomingDocuments ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JournalEntry AS ISDReference ON ISDReference.CompanyCode = DistributedInv.ElectronicDocCompanyCode AND ISDReference.AccountingDocument = DistributedInv.IN_InptSrvcDistrInvc AND ISDReference.FiscalYear = DistributedInv.IN_InptSrvcDistrInvcFsclYr  -- association [0..1]
LEFT OUTER JOIN I_IN_GSTStateCodeMap AS _gststatecodemap ON _gststatecodemap.Country = DistributedInv.ElectronicDocCountry AND _gststatecodemap.Region = DistributedInv.IN_GSTPlaceOfSupply  -- association [0..1]
;