P_AU_StRpPaytTmesRptgDoc1

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_StRpPaytTmesRptgDoc1.
-- 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_StRpPaytTmesRptgDoc1 AS
SELECT
  doc.CompanyCode AS CompanyCode,
  doc.AccountingDocument AS AccountingDocument,
  doc.FiscalYear AS FiscalYear,
  doc.AccountingDocumentItem AS AccountingDocumentItem,
  doc._CompanyCode.CompanyCodeName AS CompanyCodeName,
  doc._CompanyCode.VATRegistration AS VATRegistration,
  doc.Supplier AS Supplier,
  doc._Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  doc.VATRegistration AS BPTaxNumber,
  doc.ClearingDate AS ClearingDate,
  case when _ReferenceInvoice.AccountingDocument is not null then case $parameters.P_AU_InvoiceIssueDateType when '1' then _ReferenceInvoice.DocumentDate when '2' then _ReferenceInvoice.PostingDate when '3' then _ReferenceInvoice.InvoiceReceiptDate else _ReferenceInvoice.PostingDate end else case $parameters.P_AU_InvoiceIssueDateType when '1' then doc.DocumentDate when '2' then doc.PostingDate when '3' then doc._JournalEntry.InvoiceReceiptDate else doc.PostingDate end end as InvoiceIssueDate AS PostingDateendendasInvoiceIssueDate,
  doc.PostingDate AS PostingDate,
  doc.AccountingDocumentType AS AccountingDocumentType,
  doc._Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  doc.PartnerCompany AS PartnerCompany,
  doc._Supplier.TradingPartner AS TradingPartner,
  doc.ClearingJournalEntry AS ClearingJournalEntry,
  doc.InvoiceReference AS InvoiceReference,
  doc.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  doc.DebitCreditCode AS DebitCreditCode,
  case when _ReferenceInvoice.AccountingDocument is not null then _ReferenceInvoiceItem.PaymentTerms else doc.PaymentTerms end as PaymentTerms AS PaymentTermsendasPaymentTerms,
  doc.CashDiscount1Percent AS CashDiscount1Percent,
  doc.CashDiscount2Percent AS CashDiscount2Percent,
  doc.CashDiscount1Days AS CashDiscount1Days,
  doc.CashDiscount2Days AS CashDiscount2Days,
  doc.NetPaymentDays AS NetPaymentDays,
  doc.ReferenceDocumentType AS ReferenceDocumentType,
  doc.CompanyCodeCurrency AS CompanyCodeCurrency
FROM I_OperationalAcctgDocItem AS doc
LEFT OUTER JOIN I_AU_StRpPTRSmallBusinessIdn AS _PTRSmallBusiness ON CompanyCode = _PTRSmallBusiness.CompanyCode AND Supplier = _PTRSmallBusiness.Supplier  -- association [0..*]
LEFT OUTER JOIN I_StRpJournalEntryLog AS _ReportedItemsLog ON _ReportedItemsLog.CompanyCode = CompanyCode AND _ReportedItemsLog.AccountingDocument = AccountingDocument AND _ReportedItemsLog.FiscalYear = FiscalYear  -- association [0..*]
LEFT OUTER JOIN I_JournalEntry AS _ReferenceInvoice ON doc.CompanyCode = _ReferenceInvoice.CompanyCode AND doc.InvoiceReference = _ReferenceInvoice.AccountingDocument AND doc.InvoiceReferenceFiscalYear = _ReferenceInvoice.FiscalYear AND doc.InvoiceReference is not null AND doc.InvoiceReference is not initial  -- association [0..1]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _ReferenceInvoiceItem ON doc.CompanyCode = _ReferenceInvoiceItem.CompanyCode AND doc.InvoiceReference = _ReferenceInvoiceItem.AccountingDocument AND doc.InvoiceReferenceFiscalYear = _ReferenceInvoiceItem.FiscalYear AND doc.Supplier = _ReferenceInvoiceItem.Supplier AND doc.InvoiceReference is not null AND doc.InvoiceReference is not initial  -- association [0..1]
LEFT OUTER JOIN I_Businesspartnertaxnumber AS _Businesspartnertaxnumber ON _Businesspartnertaxnumber.BusinessPartner = businesspartner AND _Businesspartnertaxnumber.BPTaxType = 'AU0'  -- association [0..1]
;