P_PL_ExcessDelayInvcFinalAmt

DDL: P_PL_EXCESSDELAYINVCFINALAMT SQL: PEDINVFINAMT Type: view COMPOSITE Package: GLO_FIN_IS_PL
35 Fields

Calculate invoice final amount

P_PL_ExcessDelayInvcFinalAmt is a Composite CDS View that provides data about "Calculate invoice final amount" in SAP S/4HANA. Part of development package GLO_FIN_IS_PL.

Parameters (3)

NameTypeDefault
P_KeyDate dats
P_CustomerSupplier char1
P_FactoryCal char2

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PEDINVFINAMT view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Calculate invoice final amount view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity ExcessDelayFactCal StatryRptgEntity Reporting Entity
KEY StatryRptCategory ExcessDelayFactCal StatryRptCategory Report ID
KEY StatryRptRunID ExcessDelayFactCal StatryRptRunID Report Run ID
KEY CompanyCode ExcessDelayFactCal CompanyCode Receiver Company Code
KEY FiscalYear ExcessDelayFactCal FiscalYear G/L Fiscal Year
KEY AccountingDocument ExcessDelayFactCal AccountingDocument Journal Entry
KEY AccountingDocumentItem ExcessDelayFactCal AccountingDocumentItem Posting View Item
ClearingJournalEntry ExcessDelayFactCal ClearingJournalEntry Clrng doc.
AccountingDocumentType ExcessDelayFactCal AccountingDocumentType Journal Entry Type
DebitCreditCode ExcessDelayFactCal DebitCreditCode Single-Character Flag
CompanyCodeCurrency ExcessDelayFactCal CompanyCodeCurrency Local Currency
Supplier ExcessDelayFactCal Supplier Supplier
Customer ExcessDelayFactCal Customer Sold-to Party
DocumentDate ExcessDelayFactCal DocumentDate Journal Entry Date
PostingDate ExcessDelayFactCal PostingDate Posting Date for GR
DueCalculationBaseDate ExcessDelayFactCal DueCalculationBaseDate Due Calculation Base Date
ClearingDate ExcessDelayFactCal ClearingDate Clearing Date
InvoiceReceiptDate ExcessDelayFactCal InvoiceReceiptDate Invoice Receipt Date
DocumentReferenceID ExcessDelayFactCal DocumentReferenceID Reference
DocumentItemText ExcessDelayFactCal DocumentItemText Text
InvoiceReference ExcessDelayFactCal InvoiceReference Invoice Reference
InvoiceItemReference ExcessDelayFactCal InvoiceItemReference Item
InvoiceReferenceFiscalYear ExcessDelayFactCal InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
FollowOnDocumentType ExcessDelayFactCal FollowOnDocumentType Follow-On Document Type
PaymentTerms ExcessDelayFactCal PaymentTerms Pyt Terms
CashDiscount1Days ExcessDelayFactCal CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days ExcessDelayFactCal CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays ExcessDelayFactCal NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent ExcessDelayFactCal CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent ExcessDelayFactCal CashDiscount2Percent Disc. Percent 2
AssignmentReference ExcessDelayFactCal AssignmentReference Assignment Reference
CustomerSupplier ExcessDelayFactCal CustomerSupplier
NetDueDate ExcessDelayFactCal NetDueDate Net Due Date
IsClearedDoc ExcessDelayFactCal IsClearedDoc
NetDueDateP_KeyDate1endasNumberOfDays

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_PL_ExcessDelayInvcFinalAmt.
-- 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: PEDINVFINAMT
-- Parameters: P_KeyDate : dats, P_CustomerSupplier : char1, P_FactoryCal : char2

CREATE VIEW P_PL_ExcessDelayInvcFinalAmt AS
SELECT
  ExcessDelayFactCal.StatryRptgEntity AS StatryRptgEntity,
  ExcessDelayFactCal.StatryRptCategory AS StatryRptCategory,
  ExcessDelayFactCal.StatryRptRunID AS StatryRptRunID,
  ExcessDelayFactCal.CompanyCode AS CompanyCode,
  ExcessDelayFactCal.FiscalYear AS FiscalYear,
  ExcessDelayFactCal.AccountingDocument AS AccountingDocument,
  ExcessDelayFactCal.AccountingDocumentItem AS AccountingDocumentItem,
  ExcessDelayFactCal.ClearingJournalEntry AS ClearingJournalEntry,
  ExcessDelayFactCal.AccountingDocumentType AS AccountingDocumentType,
  ExcessDelayFactCal.DebitCreditCode AS DebitCreditCode,
  ExcessDelayFactCal.CompanyCodeCurrency AS CompanyCodeCurrency,
  ExcessDelayFactCal.Supplier AS Supplier,
  ExcessDelayFactCal.Customer AS Customer,
  ExcessDelayFactCal.DocumentDate AS DocumentDate,
  ExcessDelayFactCal.PostingDate AS PostingDate,
  ExcessDelayFactCal.DueCalculationBaseDate AS DueCalculationBaseDate,
  ExcessDelayFactCal.ClearingDate AS ClearingDate,
  ExcessDelayFactCal.InvoiceReceiptDate AS InvoiceReceiptDate,
  ExcessDelayFactCal.DocumentReferenceID AS DocumentReferenceID,
  ExcessDelayFactCal.DocumentItemText AS DocumentItemText,
  ExcessDelayFactCal.InvoiceReference AS InvoiceReference,
  ExcessDelayFactCal.InvoiceItemReference AS InvoiceItemReference,
  ExcessDelayFactCal.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  ExcessDelayFactCal.FollowOnDocumentType AS FollowOnDocumentType,
  ExcessDelayFactCal.PaymentTerms AS PaymentTerms,
  ExcessDelayFactCal.CashDiscount1Days AS CashDiscount1Days,
  ExcessDelayFactCal.CashDiscount2Days AS CashDiscount2Days,
  ExcessDelayFactCal.NetPaymentDays AS NetPaymentDays,
  ExcessDelayFactCal.CashDiscount1Percent AS CashDiscount1Percent,
  ExcessDelayFactCal.CashDiscount2Percent AS CashDiscount2Percent,
  ExcessDelayFactCal.AssignmentReference AS AssignmentReference,
  ExcessDelayFactCal.CustomerSupplier AS CustomerSupplier,
  ExcessDelayFactCal.NetDueDate AS NetDueDate,
  ExcessDelayFactCal.IsClearedDoc AS IsClearedDoc,
  case ExcessDelayFactCal.IsClearedDoc when 1 then case when ExcessDelayFactCal.ClearingDate <= ExcessDelayFactCal.NetDueDate then 0 else dats_days_between(ExcessDelayFactCal.NetDueDate, ExcessDelayFactCal.ClearingDate) end else dats_days_between(ExcessDelayFactCal.NetDueDate, :P_KeyDate) + 1 end as NumberOfDays AS NetDueDateP_KeyDate1endasNumberOfDays
;

Learn More