P_PT_DocItemPartnerJoinWit

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_DocItemPartnerJoinWit.
-- 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: PPTPARTJOINWIT

CREATE VIEW P_PT_DocItemPartnerJoinWit AS
SELECT
  p.CompanyCode AS CompanyCode,
  p.FiscalYear AS FiscalYear,
  p.AccountingDocument AS AccountingDocument,
  p.AccountingDocumentItem AS AccountingDocumentItem,
  p.ClearingDate AS ClearingDate,
  p.PostingDate AS PostingDate,
  p.Customer AS Customer,
  p.Supplier AS Supplier,
  p.DocumentDate AS DocumentDate,
  p.DebitCreditCode AS DebitCreditCode,
  p.WithholdingTaxCode AS WithholdingTaxCode,
  p.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  p.CashDiscountAmtInCoCodeCrcy AS CashDiscountAmtInCoCodeCrcy,
  p.TransactionCurrency AS TransactionCurrency,
  p.IsSalesRelated AS IsSalesRelated,
  p.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  p.FinancialAccountType AS FinancialAccountType,
  p.VATRegistration AS VATRegistration,
  p.CompanyCodeCurrency AS CompanyCodeCurrency,
  p.ExchangeRate AS ExchangeRate,
  p.AccountingDocumentType AS AccountingDocumentType,
  p.SupplierVATRegistration AS SupplierVATRegistration,
  p.CustomerVATRegistration AS CustomerVATRegistration,
  p.VATRegistrationCountry AS VATRegistrationCountry,
  p.SupplierVATRegistrationCountry AS SupplierVATRegistrationCountry,
  p.CustomerVATRegistrationCountry AS CustomerVATRegistrationCountry,
  p.OneTimeVendor AS OneTimeVendor,
  p.OneTimeCustomer AS OneTimeCustomer,
  p.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  p.CashDiscountAmount AS CashDiscountAmount,
  W.TransactionTypeDetermination AS TransactionTypeDetermination
FROM P_PT_DocItemPartner AS p
LEFT OUTER JOIN P_PT_DocItemWIT AS W ON /* join condition not captured in parsed metadata */
;