P_PT_DocItemWhldgTx

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 P_PT_DocItemWhldgTx.
-- 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.
-- SQL view name: PTDOCITEMWHLDGTX

CREATE VIEW P_PT_DocItemWhldgTx AS
SELECT
  AccountingDocument,
  CompanyCode,
  FiscalYear,
  AccountingDocumentItem,
  ClearingDate,
  PostingDate,
  DocumentDate,
  Customer,
  Supplier,
  DebitCreditCode,
  WithholdingTaxCode,
  BalanceTransactionCurrency,
  cast( case when ExchangeRate is initial or ExchangeRate = 0 or ExchangeRate is null then WithholdingTaxAmount when ExchangeRate > 0 then cast(WithholdingTaxAmount as abap.curr(23,2)) * cast(ExchangeRate as abap.dec( 9, 2 )) when ExchangeRate < 0 then division( cast(WithholdingTaxAmount as abap.curr(23,2)), (ExchangeRate * -1), 2) end as abap.curr(23,2)) as WithholdingTaxAmount AS curr232asWithholdingTaxAmount,
  TransactionCurrency,
  IsSalesRelated,
  IsUsedInPaymentTransaction,
  AmountInCompanyCodeCurrency,
  FinancialAccountType,
  CompanyCodeCurrency,
  SupplierVATRegistration,
  CustomerVATRegistration,
  OneTimeVendor,
  OneTimeCustomer,
  VATRegistration,
  VATRegistrationCountry,
  SupplierVATRegistrationCountry,
  CustomerVATRegistrationCountry,
  ExchangeRate,
  AccountingDocumentType
FROM P_PT_DocItemPartnerJoinWit
;