I_IN_EDocITC04SlsReg

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_EDocITC04SlsReg.
-- 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_EDocITC04SlsReg AS
SELECT
  I_ElectronicDoc.ElectronicDocUUID AS ElectronicDocUUID,
  I_ElectronicDoc.ElectronicDocCompanyCode AS ElectronicDocCompanyCode,
  I_ElectronicDoc.ElectronicDocSourceType AS ElectronicDocSourceType,
  cast(I_ElectronicDoc.ElectronicDocSourceKey as vbeln_vf ) AS BillingDocument,
  I_ElectronicDoc.ElectronicDocSourceKey AS ElectronicDocSourceKey,
  I_ElectronicDoc.ElectronicDocType AS ElectronicDocType,
  I_ElectronicDoc.ElectronicDocLogicalSystem AS ElectronicDocLogicalSystem,
  I_ElectronicDoc.ElectronicDocLastChangedByUser AS ElectronicDocLastChangedByUser,
  I_ElectronicDoc.ElectronicDocLastChangeDate AS ElectronicDocLastChangeDate,
  I_ElectronicDoc.ElectronicDocLastChangeTime AS ElectronicDocLastChangeTime,
  I_ElectronicDoc.ElectronicDocCreatedByUser AS ElectronicDocCreatedByUser,
  I_ElectronicDoc.ElectronicDocCreationDate AS ElectronicDocCreationDate,
  I_ElectronicDoc.ElectronicDocCreationTime AS ElectronicDocCreationTime,
  I_ElectronicDoc.ElectronicDocSrceCreatedByUser AS ElectronicDocSrceCreatedByUser,
  I_ElectronicDoc.ElectronicDocProcess AS ElectronicDocProcess,
  I_ElectronicDoc.ElectronicDocPostingDate AS ElectronicDocPostingDate,
  I_IN_EDocGSTRetsSalesRegister.IN_DocumentSectionCode AS IN_DocumentSectionCode,
  I_IN_EDocGSTRetsSalesRegister.IN_EDocGSTRetsTaxReportingDate AS TaxReportingDate,
  _StateCodeMapbp.IN_GSTLegalStateCode AS IN_GSTPlaceOfSupplyName,
  I_IN_EDocGSTRetsSalesRegister.IN_EDocGSTRetsBusinessPlace AS IN_EDocEInvcBusinessPlace,
  I_IN_EDocGSTRetsSalesRegister.IN_NoteType AS IN_NoteType,
  coalesce(_BusPartAddrDepdntTaxNmbr.BPTaxNumber,_BpPartnerTaxNum.BPTaxNumber) AS IN_PrtnGSTIdentificationNmbr,
  _Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_ElectronicDoc.ElectronicDocProcessStatus AS ElectronicDocProcessStatus,
  _BusinessPlace.IN_GSTIdentificationNumber AS IN_EDocEInvcPullTaxPayerGSTIN
FROM I_IN_EDocGSTRetsSalesRegister
INNER JOIN I_ElectronicDoc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Businesspartnertaxnumber AS _BpPartnerTaxNum ON _BpPartnerTaxNum.BusinessPartner = I_IN_EDocGSTRetsSalesRegister.IN_GSTPartner AND _BpPartnerTaxNum.BPTaxType = 'IN3'  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON _Country.Country = 'IN'  -- association [0..1]
LEFT OUTER JOIN I_IN_GSTStateCodeMap AS _StateCodeMapbp ON _StateCodeMapbp.Country = 'IN' AND _StateCodeMapbp.Region = I_IN_EDocGSTRetsSalesRegister.IN_GSTPlaceOfSupply  -- association [0..1]
LEFT OUTER JOIN I_IN_BusinessPlace AS _BusinessPlace ON _BusinessPlace.CompanyCode = ElectronicDocCompanyCode AND _BusinessPlace.Branch = IN_EDocEInvcBusinessPlace  -- association [0..1]
;