P_PL_ExcessDelayDetNetDueDt

DDL: P_PL_EXCESSDELAYDETNETDUEDT SQL: PEDDETNETDUEDT Type: view_entity COMPOSITE Package: GLO_FIN_IS_PL
35 Fields 1 Data Sources

Determain Net Due Date based on Cash Discount and C/D Memo

P_PL_ExcessDelayDetNetDueDt is a Composite CDS View that provides data about "Determain Net Due Date based on Cash Discount and C/D Memo" in SAP S/4HANA. It reads from 1 data source (P_PL_ExcessDelayAccountingItem) and exposes 35 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, FiscalYear. Part of development package GLO_FIN_IS_PL.

Data Sources (1)

SourceAliasJoin Type
P_PL_ExcessDelayAccountingItem ExcessDelayAccountingItem from

Parameters (1)

NameTypeDefault
P_KeyDate dats

Annotations (6)

NameValueLevelField
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

Fields (35)

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

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_ExcessDelayDetNetDueDt.
-- 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: PEDDETNETDUEDT
-- Parameters: P_KeyDate : dats

CREATE VIEW P_PL_ExcessDelayDetNetDueDt AS
SELECT
  ExcessDelayAccountingItem.StatryRptgEntity AS StatryRptgEntity,
  ExcessDelayAccountingItem.StatryRptCategory AS StatryRptCategory,
  ExcessDelayAccountingItem.StatryRptRunID AS StatryRptRunID,
  ExcessDelayAccountingItem.CompanyCode AS CompanyCode,
  ExcessDelayAccountingItem.FiscalYear AS FiscalYear,
  ExcessDelayAccountingItem.AccountingDocument AS AccountingDocument,
  ExcessDelayAccountingItem.AccountingDocumentItem AS AccountingDocumentItem,
  ExcessDelayAccountingItem.ClearingJournalEntry AS ClearingJournalEntry,
  ExcessDelayAccountingItem.AccountingDocumentType AS AccountingDocumentType,
  ExcessDelayAccountingItem.DebitCreditCode AS DebitCreditCode,
  ExcessDelayAccountingItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  ExcessDelayAccountingItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  ExcessDelayAccountingItem.Supplier AS Supplier,
  ExcessDelayAccountingItem.Customer AS Customer,
  ExcessDelayAccountingItem.DocumentDate AS DocumentDate,
  ExcessDelayAccountingItem.PostingDate AS PostingDate,
  ExcessDelayAccountingItem.DueCalculationBaseDate AS DueCalculationBaseDate,
  ExcessDelayAccountingItem.ClearingDate AS ClearingDate,
  ExcessDelayAccountingItem.InvoiceReceiptDate AS InvoiceReceiptDate,
  ExcessDelayAccountingItem.DocumentReferenceID AS DocumentReferenceID,
  ExcessDelayAccountingItem.DocumentItemText AS DocumentItemText,
  ExcessDelayAccountingItem.InvoiceReference AS InvoiceReference,
  ExcessDelayAccountingItem.InvoiceItemReference AS InvoiceItemReference,
  ExcessDelayAccountingItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  ExcessDelayAccountingItem.FollowOnDocumentType AS FollowOnDocumentType,
  ExcessDelayAccountingItem.PaymentTerms AS PaymentTerms,
  ExcessDelayAccountingItem.CashDiscount1Days AS CashDiscount1Days,
  ExcessDelayAccountingItem.CashDiscount2Days AS CashDiscount2Days,
  ExcessDelayAccountingItem.NetPaymentDays AS NetPaymentDays,
  ExcessDelayAccountingItem.CashDiscount1Percent AS CashDiscount1Percent,
  ExcessDelayAccountingItem.CashDiscount2Percent AS CashDiscount2Percent,
  ExcessDelayAccountingItem.AssignmentReference AS AssignmentReference,
  ExcessDelayAccountingItem.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  ExcessDelayAccountingItem.CustomerSupplier AS CustomerSupplier,
  $parameters.P_KeyDate AS KeyDate
FROM P_PL_ExcessDelayAccountingItem AS ExcessDelayAccountingItem
;

Learn More