I_PRAWhldgForm1042sCurrent

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_PRAWhldgForm1042sCurrent.
-- 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_PRAWhldgForm1042sCurrent AS
SELECT
  run_id AS ProcessRun,
  vendor AS PRAOwner,
  form_cat AS PRAWhldgFormCatCode,
  form_state AS WhldgFormState,
  payer_ein AS OwnerTaxpayerNumber,
  income_code AS PRAIncomeCode,
  tax_rate AS PRAWhldgTaxRate,
  exempt_code AS TaxExemptCode,
  nra_tax_wh AS PRANonResidentAlienWhldgAmount,
  recipient_name AS PRARecipientName,
  recipient_name2 AS RecipientName2,
  recipient_code AS PRARecipientCode,
  recipient_addr AS PRARcpntAddress,
  recipient_addr1 AS PRARcpntAddress1,
  recipient_addr2 AS PRARcpntAddress2,
  recipient_addr3 AS PRARcpntAddress3,
  recipient_addr4 AS PRARcpntAddress4,
  recipient_city AS PRARcpntCityName,
  recipient_state AS PRARecipientState,
  recipient_cntry AS PRARecipientCountry,
  recipient_zip AS PRARecipientPostalCode,
  recipient_en_typ AS PRALegalForm,
  recipient_tax_id AS PRARecipientTaxId,
  recipient_tax_ty AS PRARecipientTaxIDType,
  payer_name AS PRAPayerName,
  payer_addr AS PRAPayerAddress,
  payer_addr1 AS PRAPayerAddress1,
  payer_city AS PRAPayerCityName,
  payer_state AS PRAPayerState,
  payer_cntry AS PRAPayerCountry,
  payer_zip AS PRAPayerPostalCode,
  gross_value AS OwnerGrossAmount,
  net_value AS OwnerNetAmount,
  marketing_cost AS OwnerMarketingAmount,
  reimbursements AS OwnerReimbursementAmount,
  taxes AS OwnerTaxAmount,
  other_deducts AS OwnerOtherDeductsAmount,
  interest_value AS PRANetIntrstCalcdAmount,
  state_wh_value AS OwnerStateWithholdingAmount,
  reissue AS PRAIsReissued,
  send AS PRAIsSent,
  county_list AS PRAAgencyCountyList,
  cast ( timestamp as oiu_vdm_tmstmp ) AS PRAWhldgDateTimeStamp,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS CreationDateTime,
  cast( '/PRA/WH_WORKPLACE' as fqm_origin_trans_id ) AS OriginTransaction,
  _PRAPaymentHeader.CompanyCodeCurrency AS CompanyCodeCurrency
FROM /pra/wh_fm_1042s
LEFT OUTER JOIN I_PRAWhldgFormCatVH AS _PRAWhldgFormCatVH ON _PRAWhldgFormCatVH.PRAWhldgFormCatCode = PRAWhldgFormCatCode  -- association [0..1]
LEFT OUTER JOIN I_PRALegalForm AS _PRALegalForm ON _PRALegalForm.PRALegalForm = PRALegalForm  -- association [0..1]
LEFT OUTER JOIN I_PRATaxTypeVH AS _PRATaxTypeVH ON _PRATaxTypeVH.TaxType = PRARecipientTaxIDType  -- association [0..1]
LEFT OUTER JOIN I_ProcessRun AS _ProcessRun ON ProcessRun = _ProcessRun.ProcessRun  -- association [0..1]
LEFT OUTER JOIN I_PRAOwner AS _PRAOwner ON PRAOwner = _PRAOwner.PRAOwner  -- association [0..1]
LEFT OUTER JOIN I_PRAPaymentHeader AS _PRAPaymentHeader ON _PRAPaymentHeader.ProcessRun = ProcessRun  -- association [1..1]
LEFT OUTER JOIN I_Country AS _PayerCountry ON PRAPayerCountry = _PayerCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Region AS _PayerRegion ON PRAPayerCountry = _PayerRegion.Country AND PRAPayerState = _PayerRegion.Region  -- association [0..1]
LEFT OUTER JOIN I_Country AS _RecipientCountry ON PRARecipientCountry = _RecipientCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Region AS _RecipientRegion ON PRARecipientCountry = _RecipientRegion.Country AND PRARecipientState = _RecipientRegion.Region  -- association [0..1]
;