P_AU_STRPPAYTTMESRPTGDOC3

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_AU_STRPPAYTTMESRPTGDOC3.
-- 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.
-- Parameters: P_AU_InvoiceIssueDateType : fiau_invoice_issue_date_type, P_FromReportingDate : figen_rep_date_from, P_ToReportingDate : figen_rep_date_to

CREATE VIEW P_AU_STRPPAYTTMESRPTGDOC3 AS
SELECT
  docs.CompanyCode AS CompanyCode,
  docs.AccountingDocument AS AccountingDocument,
  docs.FiscalYear AS FiscalYear,
  docs.AccountingDocumentItem AS AccountingDocumentItem,
  docs.PostingDate AS PostingDate,
  docs.CompanyCodeName AS CompanyCodeName,
  docs.VATRegistration AS VATRegistration,
  docs.Supplier AS Supplier,
  docs.BusinessPartner AS BusinessPartner,
  docs.SupplierInvoice AS SupplierInvoice,
  docs.SupplierInvoiceFiscalYear AS SupplierInvoiceFiscalYear,
  docs.InvoiceReference AS InvoiceReference,
  docs.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  docs.BPTaxNumber AS BPTaxNumber,
  docs.PurchaseOrder AS PurchaseOrder,
  docs.PurchaseContract AS PurchaseContract,
  docs.PaymentDate AS PaymentDate,
  docs.AU_PartialPaymentFlag AS AU_PartialPaymentFlag,
  docs.InvoiceIssueDate AS InvoiceIssueDate,
  docs.LastGoodsReceiptPostingDate AS LastGoodsReceiptPostingDate,
  docs.ReportingDate AS ReportingDate,
  docs.SupplierInvoiceOrigin AS SupplierInvoiceOrigin,
  docs.AU_SelfInvoiceFlag AS AU_SelfInvoiceFlag,
  case when docs.InvcHasMultiplePurchaseOrders = 1 then docs.PaymentTerms when docs.InvcHasMultiplePurchaseOrders = 0 or docs.InvcHasMultiplePurchaseOrders is null then case when docs.SupplierInvoice = '' or docs.SupplierInvoice is null then docs.PaymentTerms when _ContractTerms.PaymentTerms is not initial and _ContractTerms.PaymentTerms is not null then _ContractTerms.PaymentTerms when _PurchaseTerms.PaymentTerms is not initial and _PurchaseTerms.PaymentTerms is not null then _PurchaseTerms.PaymentTerms else docs.PaymentTerms end end as PaymentTerms AS PaymentTermsendendasPaymentTerms,
  docs.AccountingDocumentType AS AccountingDocumentType,
  docs.SupplierAccountGroup AS SupplierAccountGroup,
  docs.TradingPartner AS TradingPartner,
  docs.DebitCreditCode AS DebitCreditCode,
  docs.CompanyCodeCurrency AS CompanyCodeCurrency,
  docs.AU_AccountingDocumentType AS AU_AccountingDocumentType,
  docs.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  docs._PTRSmallBusiness AS _PTRSmallBusiness,
  docs._ReportedItemsLog AS _ReportedItemsLog
FROM P_AU_StRpPaytTmesRptgDoc2
LEFT OUTER JOIN I_PurchaseContract AS _ContractTerms ON _ContractTerms.PurchaseContract = docs.PurchaseContract  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchaseTerms ON _PurchaseTerms.PurchasingDocument = docs.PurchaseOrder  -- association [0..1]
;