R_MngJrnlEntrWhgdTaxItem

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 R_MngJrnlEntrWhgdTaxItem.
-- 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 R_MngJrnlEntrWhgdTaxItem AS
SELECT
  CompanyCode,
  AccountingDocument,
  cast(FiscalYear as fis_gjahr_no_conv preserving type) AS FiscalYear,
  AccountingDocumentItem,
  WithholdingTaxType,
  cast(WithholdingTaxCode as fac_wt_withcd preserving type) AS WithholdingTaxCode,
  cast(abs( WhldgTaxBaseAmtInCoCodeCrcy ) as fagl_ale_wt_bs preserving type) AS WhldgTaxBaseAmtInCoCodeCrcy,
  cast(abs( WhldgTaxBaseAmtInTransacCrcy ) as fagl_ale_wt_bs1 preserving type) AS WhldgTaxBaseAmtInTransacCrcy,
  cast(abs( WhldgTaxBaseAmtInAddlCrcy2 ) as fagl_ale_wt_bs2 preserving type) AS WhldgTaxBaseAmtInAddlCrcy2,
  cast(abs( WhldgTaxBaseAmtInAddlCrcy3 ) as fagl_ale_wt_bs3 preserving type) AS WhldgTaxBaseAmtInAddlCrcy3,
  WhldgTaxBaseIsEnteredManually,
  cast(abs( WhldgTaxAmtInCoCodeCrcy ) as fis_qbshh preserving type) AS WhldgTaxAmtInCoCodeCrcy,
  cast(abs( WhldgTaxAmtInTransacCrcy ) as fac_wt_wt1 preserving type) AS WhldgTaxAmtInTransacCrcy,
  cast(abs( WhldgTaxAmtInAddlCrcy2 ) as fac_wt_wt2 preserving type) AS WhldgTaxAmtInAddlCrcy2,
  cast(abs( WhldgTaxAmtInAddlCrcy3 ) as wt_wt3 preserving type) AS WhldgTaxAmtInAddlCrcy3,
  WhldgTaxIsEnteredManually,
  WhldgTaxItemStatus,
  WhldgTaxExmptAmtInCoCodeCrcy,
  WhldgTaxExmptAmtInTransacCrcy,
  WhldgTaxExmptAmtInAddlCrcy2,
  WhldgTaxExmptAmtInAddlCrcy3,
  WhldgTaxExmptCertificate,
  FinancialAccountType,
  cast(CustomerSupplierAccount as farp_account_apar preserving type ) AS CustomerSupplierAccount,
  GLAccount,
  SupplierRecipientType,
  ClearingAccountingDocument,
  ClearingDate,
  WithholdingTaxExmptPercent,
  WithholdingTaxPercent,
  IsSelfWhldgTax,
  IsGrossingUp,
  WithholdingTaxCertificate,
  WhldgTaxCertDate,
  Country,
  cast(CompanyCodeCurrency as fis_hwaer preserving type) AS CompanyCodeCurrency,
  cast(DocumentCurrency as fis_rwcur preserving type) AS DocumentCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  RptgWhldgTxBaseAmtInCoCodeCrcy
FROM I_Withholdingtaxitem AS _Item
LEFT OUTER JOIN I_ExtendedWhldgTaxCodeText AS _WithholdingTaxCodeText ON WithholdingTaxType = _WithholdingTaxCodeText.WithholdingTaxType AND WithholdingTaxCode = _WithholdingTaxCodeText.WithholdingTaxCode AND Country = _WithholdingTaxCodeText.CountryCode AND _WithholdingTaxCodeText.Language = $session.system_language  -- association [1..1]
;