I_IN_StRpWithholdingTaxItemC

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_StRpWithholdingTaxItemC.
-- 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.
-- Parameters: P_StartDate : datum, P_EndDate : datum, P_DocumentIsPartialExempted : boolean

CREATE VIEW I_IN_StRpWithholdingTaxItemC AS
SELECT
  whtIN.CompanyCode AS CompanyCode,
  whtIN.AccountingDocument AS AccountingDocument,
  whtIN.FiscalYear AS FiscalYear,
  whtIN.AccountingDocumentItem AS AccountingDocumentItem,
  whtIN.WithholdingTaxType AS WithholdingTaxType,
  whtIN.WithholdingTaxCode AS WithholdingTaxCode,
  whtIN.StatryRptgEntity AS StatryRptgEntity,
  whtIN.StatryRptCategory AS StatryRptCategory,
  whtIN.StatryRptRunID AS StatryRptRunID,
  whtIN.OfficialWhldgTaxCode AS OfficialWhldgTaxCode,
  whtIN._CompanyCode.CompanyCodeName AS CompanyCodeName,
  whtIN.BusinessPartner AS BusinessPartner,
  whtIN.TaxSection AS TaxSection,
  whtIN.PostingDate AS PostingDate,
  whtIN.DocumentDate AS DocumentDate,
  whtIN.ReportingDate AS ReportingDate,
  whtIN.Creditor AS Creditor,
  challan.IN_ClrgWithholdingTaxDocument AS IN_ClrgWithholdingTaxDocument,
  challan.IN_ClrgWithholdingTaxDate AS IN_ClrgWithholdingTaxDate,
  whtIN.WithholdingTaxExmptPercent AS WithholdingTaxExmptPercent,
  whtIN.WhldgTaxExmptAmtInCoCodeCrcy AS WhldgTaxExmptAmtInCoCodeCrcy,
  whtIN.WithholdingTaxPercent AS WithholdingTaxPercent,
  whtIN.WhldgTaxExmptCertificate AS WhldgTaxExmptCertificate,
  whtIN.DocumentIsPartialExempted AS DocumentIsPartialExempted,
  whtIN.InvoiceReference AS InvoiceReference,
  whtIN.IN_WhldgTaxRecordTypeTrans AS IN_WhldgTaxRecordTypeTrans,
  whtIN.IN_ReferenceDocumentNumber AS IN_ReferenceDocumentNumber,
  whtIN._JournalEntry.OriginalReferenceDocument AS OriginalReferenceDocument,
  whtIN._Supplier.BusinessPartnerPanNumber AS BusinessPartnerPanNumber,
  whtIN._Supplier.BPPanReferenceNumber AS BPPanReferenceNumber,
  whtIN._Supplier.BPPanValidFromDate AS BPPanValidFromDate,
  whtIN._Supplier.Country AS Country,
  challan.IN_BankChallanNumber AS IN_BankChallanNumber,
  challan.HouseBank AS HouseBank,
  challan.IN_BankChallanDate AS IN_BankChallanDate,
  challan.IN_BkBscStstclReturnCode AS IN_BkBscStstclReturnCode,
  whtIN.ReportingCurrency AS ReportingCurrency,
  whtIN.WhldgTaxBaseAmtInCoCodeCrcy AS WhldgTaxBaseAmtInCoCodeCrcy,
  whtIN.WhldgTaxAmtInCoCodeCrcy AS WhldgTaxAmtInCoCodeCrcy
FROM I_StRpWhldgTaxItem AS whtIN
INNER JOIN I_IN_StRpWhldgTaxChallanItem AS challan ON /* join condition not captured in parsed metadata */
;