P_PL_ExcessDelayAccountingItem

DDL: P_PL_EXCESSDELAYACCOUNTINGITEM SQL: PEDACTITM Type: view COMPOSITE Package: GLO_FIN_IS_PL
34 Fields 2 Data Sources

Accounting data for Customer and Vendor

P_PL_ExcessDelayAccountingItem is a Composite CDS View that provides data about "Accounting data for Customer and Vendor" in SAP S/4HANA. It reads from 2 data sources (I_OperationalAcctgDocItem, I_StRpJournalEntryTaxItemLog) and exposes 34 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, FiscalYear. Part of development package GLO_FIN_IS_PL.

Data Sources (2)

SourceAliasJoin Type
I_OperationalAcctgDocItem OperationalAcctgDocItem inner
I_StRpJournalEntryTaxItemLog StRpJournalEntryTaxItemLog from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PEDACTITM 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 Accounting data for Customer and Vendor view

Fields (34)

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

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_ExcessDelayAccountingItem.
-- 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: PEDACTITM

CREATE VIEW P_PL_ExcessDelayAccountingItem AS
SELECT
  StRpJournalEntryTaxItemLog.StatryRptgEntity AS StatryRptgEntity,
  StRpJournalEntryTaxItemLog.StatryRptCategory AS StatryRptCategory,
  StRpJournalEntryTaxItemLog.StatryRptRunID AS StatryRptRunID,
  OperationalAcctgDocItem.CompanyCode AS CompanyCode,
  OperationalAcctgDocItem.FiscalYear AS FiscalYear,
  OperationalAcctgDocItem.AccountingDocument AS AccountingDocument,
  OperationalAcctgDocItem.AccountingDocumentItem AS AccountingDocumentItem,
  OperationalAcctgDocItem.ClearingJournalEntry AS ClearingJournalEntry,
  OperationalAcctgDocItem._JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  OperationalAcctgDocItem.DebitCreditCode AS DebitCreditCode,
  OperationalAcctgDocItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  OperationalAcctgDocItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  OperationalAcctgDocItem.Supplier AS Supplier,
  OperationalAcctgDocItem.Customer AS Customer,
  OperationalAcctgDocItem.DocumentDate AS DocumentDate,
  OperationalAcctgDocItem.PostingDate AS PostingDate,
  OperationalAcctgDocItem.DueCalculationBaseDate AS DueCalculationBaseDate,
  OperationalAcctgDocItem.NetDueDate AS NetDueDate,
  OperationalAcctgDocItem.ClearingDate AS ClearingDate,
  OperationalAcctgDocItem._JournalEntry.InvoiceReceiptDate AS InvoiceReceiptDate,
  OperationalAcctgDocItem._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  OperationalAcctgDocItem.DocumentItemText AS DocumentItemText,
  OperationalAcctgDocItem.InvoiceReference AS InvoiceReference,
  OperationalAcctgDocItem.InvoiceItemReference AS InvoiceItemReference,
  OperationalAcctgDocItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  OperationalAcctgDocItem.FollowOnDocumentType AS FollowOnDocumentType,
  OperationalAcctgDocItem.PaymentTerms AS PaymentTerms,
  OperationalAcctgDocItem.CashDiscount1Days AS CashDiscount1Days,
  OperationalAcctgDocItem.CashDiscount2Days AS CashDiscount2Days,
  OperationalAcctgDocItem.NetPaymentDays AS NetPaymentDays,
  OperationalAcctgDocItem.CashDiscount1Percent AS CashDiscount1Percent,
  OperationalAcctgDocItem.CashDiscount2Percent AS CashDiscount2Percent,
  OperationalAcctgDocItem.AssignmentReference AS AssignmentReference,
  OperationalAcctgDocItem.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction
FROM I_StRpJournalEntryTaxItemLog AS StRpJournalEntryTaxItemLog
INNER JOIN I_OperationalAcctgDocItem AS OperationalAcctgDocItem ON /* join condition not captured in parsed metadata */
;

Learn More