I_IT_StRpWhldgTaxItemAddlData

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_IT_StRpWhldgTaxItemAddlData.
-- 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_IT_StRpWhldgTaxItemAddlData AS
SELECT
  bukrs AS CompanyCode,
  gjahr AS FiscalYear,
  lifnr AS Supplier,
  caus AS WithholdingTaxPaymentReason,
  cdinail AS WhldgTxNrOfTerritorialInsur,
  dtiniz AS WhldgTaxInsuranceStartDate,
  dtfine AS WithholdingTaxInsuranceEndDate,
  cdcomu AS WithholdingTaxMunicipalCode,
  rep_lifnr AS WhldgTaxFrgnSuplrRprstv,
  regio_sf AS IT_WhldgTaxRegionCode,
  scexemp_fl AS WhldgTxIsSoclContrbnExmpFlag,
  p_heir AS WithholdingTaxIsHeir,
  ex_events AS WhldgTaxExceptionalEvents,
  cast('' as waers) AS ReportingCurrency,
  p_cost AS WhldgTxExpnsRfnddAmtInRptgCrcy,
  p_tax AS WhldgTxRmbsdAmtInRptgCrcy,
  p_dubank AS WhldgBfrBankruptAmtInRptgCrcy,
  p_pabank AS WhldgAftBankruptAmtInRptgCrcy,
  income_rec AS WhldgTxTotIncRcvdAmtInRptgCrcy,
  taxcode AS IT_TaxCode,
  taxbase AS IT_WhldgTxBaseAmtInRptgCrcy,
  wtax AS IT_WhldgTxAmtInRptgCrcy,
  taxdedu AS WhldgTxDdctdAmtInRptgCrcy,
  sutax AS WhldgTxSuspAmtInRptgCrcy,
  regwtax AS WhldgTxRgnlAmtInRptgCrcy,
  regtax AS IT_RgnlTxAmtInRptgCrcy,
  suregtax AS IT_AddlRgnlSuspAmtInRptgCrcy,
  it_code AS WhldgTaxAdditionalDataCode,
  it_foreign_country AS WhldgTxTmpResidenceFrgnCtryReg,
  it_bytax AS WithheldTxAmtInRptgCrcy,
  it_deemed AS WhldgTxDeemedAmtInRptgCrcy,
  it_returnedamt AS WhldgTxRetdAmtInRptgCrcy,
  it_addwhtamt AS WhldgTxAddlAmtInRptgCrcy,
  it_addtaxamt AS IT_AddlTxAmtInRptgCrcy,
  it_addsusamt AS IT_AddlRgnlSuspAmtInRptgCrcy2,
  it_prevyear AS WithholdingTaxPreviousYear,
  it_prevbaseamt AS IT_PrevYrBaseAmtInRptgCrcy,
  it_prevtaxamt AS IT_PrevYrTxAmtInRptgCrcy,
  addmultitle AS IT_AddlMncplTtlAmtInRptgCrcy,
  addmultax AS IT_AddMncplTtlTxAmtInRptgCrcy,
  addmulsusp AS IT_AddlMncplSuspAmtInRptgCrcy,
  multitle AS IT_MunicipalTtlAmtInRptgCrcy,
  multax AS IT_MunicipalTxAmtInRptgCrcy,
  mulsusp AS IT_MunicipalSuspAmtInRptgCrcy,
  bpcatgry AS WhldgTxAgtSpclCat,
  delidnum AS WhldgTxDelivIdnNumber,
  cunumber AS WhldgTxProgressiveCertNmbr,
  advance AS WhldgTxIsAdvancePaymentFlag,
  othcamt AS IT_OthContrbnAmtInRptgCrcy,
  othcdue AS IT_OthContrbnDuAmtInRptgCrcy,
  othcpaid AS IT_OthContrbnPaidAmtInRptgCrcy,
  ssivcatg AS WhldgTxSoclScrtyInstnCode,
  vendrepr AS WhldgTxSuplrTxRprstv,
  deductible_amount AS WhldgTxDcblAmtInRptgCrcy,
  _t005_it_uicreg.intcn3_it_uic AS WhldgTaxUICCode
FROM rf07
LEFT OUTER JOIN t005_it_uicreg AS _t005_it_uicreg ON _t005_it_uicreg.land1 = WhldgTxTmpResidenceFrgnCtryReg  -- association [0..1]
;