I_IN_CntryRsltEDocTaxAuth

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_CntryRsltEDocTaxAuth.
-- 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_CntryRsltEDocTaxAuth AS
SELECT
  I_IN_EDCResultGSTRets.EDCResultUUID AS EDCResultUUID,
  I_IN_EDCResultGSTRets.IN_EDocFiscalYear AS IN_EDocFiscalYear,
  I_IN_EDCResultGSTRets.IN_EDocGSTRetsBusinessPlace AS IN_EDocGSTRetsBusinessPlace,
  I_IN_EDCResultGSTRets.EDCTaxAuthRecordUUID AS EDCTaxAuthRecordUUID,
  I_IN_EDCResultGSTRets.ElectronicDocUUID AS ElectronicDocUUID,
  I_IN_EDCResultGSTRets.EDCCompany AS CompanyCode,
  I_IN_EDCResultGSTRets.IN_DocumentSectionCode AS IN_DocumentSectionCode,
  I_IN_EDCResultGSTRets.IN_EDocGSTRetsTaxReportingDate AS IN_EDocGSTRetsTaxReportingDate,
  I_IN_EDCResultGSTRets.IN_EDCTaxAuthTaxPayerGSTIN AS IN_GSTIdentificationNumber,
  I_IN_EDCResultGSTRets.IN_EDCTaxAuthDocumentDate AS DocumentDate,
  cast ( I_IN_EDCResultGSTRets.IN_EDCTaxAuthBusinessPrtnGSTIN as abap.char( 20 ) ) AS IN_PrtnGSTIdentificationNmbr,
  _EDocRets2HdrItmAggrgn.IN_EDocGSTRetsExtNmbr AS IN_EDocGSTRetsExtNmbr,
  _EDocRets2HdrItmAggrgn.IN_IsGSTReverseCharged AS IN_IsGSTReverseCharged,
  _EDocRets2HdrItmAggrgn.IN_GSTPartner AS IN_GSTPartner,
  _EDocRets2HdrItmAggrgn.IN_EDocInptTaxCrdtAccptdDate AS IN_EDocInptTaxCrdtAccptdDate,
  _EDocRets2HdrItmAggrgn.CompanyCodeCurrency AS CompanyCodeCurrency,
  _EDocRets2HdrItmAggrgn.AccountingDocumentType AS AccountingDocumentType,
  _EDocRets2HdrItmAggrgn.IN_EDocInptTaxCrdtAccptdPeriod AS IN_EDocInptTaxCrdtAccptdPeriod,
  _EDocRets2HdrItmAggrgn.IN_NoteType AS IN_NoteType,
  _EDocRets2HdrItmAggrgn.AccountingDocument AS AccountingDocument,
  _EDocRets2HdrItmAggrgn.IN_InvoiceType AS IN_InvoiceType,
  _EDocRets2HdrItmAggrgn.SupplierName AS SupplierName,
  _EDocRets2HdrItmAggrgn.IN_GSTLegalStateCode AS IN_GSTLegalStateCode,
  _EDocRets2HdrItmAggrgn.IN_EDocTotEligibleAmt AS IN_EDocTotEligibleAmt,
  _EDocRets2HdrItmAggrgn.IN_EDocTotInElgblAmt AS IN_EDocTotInElgblAmt,
  _EDocRets2HdrItmAggrgn.IN_EDocTotalTaxRate AS IN_EDocTotalTaxRate,
  _EDocRets2HdrItmAggrgn.IN_ElgblIntgtdGSTInptTxCrdtAmt AS IN_ElgblIntgtdGSTInptTxCrdtAmt,
  _EDocRets2HdrItmAggrgn.IN_InElgblIGSTInptTxCrdtAmount AS IN_InElgblIGSTInptTxCrdtAmount,
  _EDocRets2HdrItmAggrgn.IN_EDocTotIntgtdGSTAmt AS IN_EDocTotIntgtdGSTAmt,
  _EDocRets2HdrItmAggrgn.IN_ElgblCntrlGSTInptTxCrdtAmt AS IN_ElgblCntrlGSTInptTxCrdtAmt,
  _EDocRets2HdrItmAggrgn.IN_InElgblCGSTInptTxCrdtAmount AS IN_InElgblCGSTInptTxCrdtAmount,
  _EDocRets2HdrItmAggrgn.IN_EDocTotCntrlGSTAmount AS IN_EDocTotCntrlGSTAmount,
  _EDocRets2HdrItmAggrgn.IN_ElgblStateGSTInptTxCrdtAmt AS IN_ElgblStateGSTInptTxCrdtAmt,
  _EDocRets2HdrItmAggrgn.IN_InElgblSGSTInptTxCrdtAmount AS IN_InElgblSGSTInptTxCrdtAmount,
  _EDocRets2HdrItmAggrgn.IN_EDocTotStateGSTAmount AS IN_EDocTotStateGSTAmount,
  _EDocRets2HdrItmAggrgn.IN_EligibleCessInptTxCrdtAmt AS IN_EligibleCessInptTxCrdtAmt,
  _EDocRets2HdrItmAggrgn.IN_IneligibleCessInptTxCrdtAmt AS IN_IneligibleCessInptTxCrdtAmt,
  _EDocRets2HdrItmAggrgn.IN_EDocTotalCESSAmount AS IN_EDocTotalCESSAmount,
  _EDocRets2HdrItmAggrgn.IN_EDocTotalTaxAmount AS IN_EDocTotalTaxAmount,
  _EDocRets2HdrItmAggrgn.IN_EDocTotTaxableAmount AS IN_EDocTotTaxableAmount,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCFsclYr AS IN_EDCFsclYr,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthBusinessPlace AS IN_EDCTaxAuthBusinessPlace,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCAmendmentType AS IN_EDCAmendmentType,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCAmendmentPeriod AS IN_EDCAmendmentPeriod,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCRets2IsTaxRecordExists AS IN_EDCRets2IsTaxRecordExists,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthShipgPortCode AS IN_EDCTaxAuthShipgPortCode,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthTaxPayerGSTIN AS IN_EDCTaxAuthTaxPayerGSTIN,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthDocumentDate AS IN_EDCTaxAuthDocumentDate,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthBusinessPrtnGSTIN AS IN_EDCTaxAuthBusinessPrtnGSTIN,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCOriginalDocumentPeriod AS IN_EDCOriginalDocumentPeriod,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCOriginalDocumentDate AS IN_EDCOriginalDocumentDate,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCOriginalDocumentNumber AS IN_EDCOriginalDocumentNumber,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCInptTxCrdtUnavailRsn AS IN_EDCInptTxCrdtUnavailRsn,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_TaxAuthInptTxCrdtAvailyCode AS IN_TaxAuthInptTxCrdtAvailyCode,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthReportingPeriod AS IN_EDCTaxAuthReportingPeriod,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthReportingDate AS IN_EDCTaxAuthReportingDate,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthStmntPeriod AS IN_EDCTaxAuthStmntPeriod,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthBPRet1FilingDate AS IN_EDCTaxAuthBPRet1FilingDate,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCDocumentNumber AS IN_EDCDocumentNumber,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCDocumentType AS IN_EDCDocumentType,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthBusinessPrtnName AS IN_EDCTaxAuthBusinessPrtnName,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthGSTPlaceOfSupply AS IN_EDCTaxAuthGSTPlaceOfSupply,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_TaxAuthRets2DocSectionCode AS IN_TaxAuthRets2DocSectionCode,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCRets2StmntDate AS IN_EDCRets2StmntDate,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthoritySourceType AS IN_EDCTaxAuthoritySourceType,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthIsBPRet1Filed AS IN_EDCTaxAuthIsBPRet1Filed,
  _EDCTaxAuthRets2HdrItmAggrgn.Currency AS Currency,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthIsBPRet3Filed AS IN_EDCTaxAuthIsBPRet3Filed,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthEInvcGnrtnDate AS IN_EDCTaxAuthEInvcGnrtnDate,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthInvcRefNmbr AS IN_EDCTaxAuthInvcRefNmbr,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthIsReverseCharged AS IN_EDCTaxAuthIsReverseCharged,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthTotTaxRate AS IN_EDCTaxAuthTotTaxRate,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthTotIntgtdGSTAmt AS IN_EDCTaxAuthTotIntgtdGSTAmt,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthTotCntrlGSTAmount AS IN_EDCTaxAuthTotCntrlGSTAmount,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthTotStateGSTAmount AS IN_EDCTaxAuthTotStateGSTAmount,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTxAuthTotalTaxAmount AS IN_EDCTxAuthTotalTaxAmount,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTxAuthTotalCESSAmount AS IN_EDCTxAuthTotalCESSAmount,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthTotTaxableAmount AS IN_EDCTaxAuthTotTaxableAmount,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCIsITCReductionRequired AS IN_EDCIsITCReductionRequired,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCDecldITCIntegratedGSTAmt AS IN_EDCDecldITCIntegratedGSTAmt,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCDecldStateGSTAmount AS IN_EDCDecldStateGSTAmount,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCDecldITCCentralGSTAmount AS IN_EDCDecldITCCentralGSTAmount,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCDecldInptTaxCrdtCESSAmt AS IN_EDCDecldInptTaxCrdtCESSAmt,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCIsITCReductionBlocked AS IN_EDCIsITCReductionBlocked,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCInvcMgmtSystStatus AS IN_EDCInvcMgmtSystStatus,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCInvcMgmtSystActnRemarks AS IN_EDCInvcMgmtSystActnRemarks,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCIsRemarksBlocked AS IN_EDCIsRemarksBlocked,
  _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCIsITCReversal AS IN_EDCIsITCReversal
FROM I_IN_EDCResultGSTRets
LEFT OUTER JOIN I_IN_EDocRets2HdrItmAggrgn AS _EDocRets2HdrItmAggrgn ON I_IN_EDCResultGSTRets.ElectronicDocUUID = _EDocRets2HdrItmAggrgn.ElectronicDocUUID AND I_IN_EDCResultGSTRets.EDCCompany = _EDocRets2HdrItmAggrgn.ElectronicDocCompanyCode AND I_IN_EDCResultGSTRets.IN_EDocFiscalYear = _EDocRets2HdrItmAggrgn.IN_EDocFiscalYear AND I_IN_EDCResultGSTRets.IN_EDocGSTRetsBusinessPlace = _EDocRets2HdrItmAggrgn.IN_EDocGSTRetsBusinessPlace AND I_IN_EDCResultGSTRets.IN_DocumentSectionCode = _EDocRets2HdrItmAggrgn.IN_DocumentSectionCode AND I_IN_EDCResultGSTRets.IN_EDocGSTRetsTaxReportingDate = _EDocRets2HdrItmAggrgn.IN_EDocGSTRetsTaxReportingDate  -- association [1..1]
LEFT OUTER JOIN I_IN_TxAuthRets2HdrItmAggrgn AS _EDCTaxAuthRets2HdrItmAggrgn ON I_IN_EDCResultGSTRets.EDCTaxAuthRecordUUID = _EDCTaxAuthRets2HdrItmAggrgn.EDCTaxAuthRecordUUID AND I_IN_EDCResultGSTRets.IN_EDCTaxAuthTaxPayerGSTIN = _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthTaxPayerGSTIN AND I_IN_EDCResultGSTRets.IN_EDocGSTRetsBusinessPlace = _EDCTaxAuthRets2HdrItmAggrgn.IN_EDCTaxAuthBusinessPlace AND I_IN_EDCResultGSTRets.IN_DocumentSectionCode = _EDCTaxAuthRets2HdrItmAggrgn.IN_TaxAuthRets2DocSectionCode  -- association [1..1]
;