C_PL_ExcessDelayFinalAcctDataC

DDL: C_PL_EXCESSDELAYFINALACCTDATAC SQL: CEDFINACCDATAC Type: view CONSUMPTION Package: GLO_FIN_IS_PL
33 Fields 1 Data Sources

Final acct data for Excess Delay - Cube

C_PL_ExcessDelayFinalAcctDataC is a Consumption CDS View (Cube) that provides data about "Final acct data for Excess Delay - Cube" in SAP S/4HANA. It reads from 1 data source (P_PL_ExcessDelayInvcFinalAmt) and exposes 33 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, FiscalYear. Part of development package GLO_FIN_IS_PL.

Data Sources (1)

SourceAliasJoin Type
P_PL_ExcessDelayInvcFinalAmt P_PL_ExcessDelayInvcFinalAmt from

Parameters (3)

NameTypeDefault
P_KeyDate dats
P_CustomerSupplier char1
P_FactoryCal char2

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CEDFINACCDATAC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
Analytics.dataCategory #CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Analytics.internalName #LOCAL view
EndUserText.label Final acct data for Excess Delay - Cube view

Fields (33)

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

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

CREATE VIEW C_PL_ExcessDelayFinalAcctDataC AS
SELECT
  ExcessDelayInvcFinalAmt.StatryRptgEntity AS StatryRptgEntity,
  ExcessDelayInvcFinalAmt.StatryRptCategory AS StatryRptCategory,
  ExcessDelayInvcFinalAmt.StatryRptRunID AS StatryRptRunID,
  ExcessDelayInvcFinalAmt.CompanyCode AS CompanyCode,
  ExcessDelayInvcFinalAmt.FiscalYear AS FiscalYear,
  ExcessDelayInvcFinalAmt.AccountingDocument AS AccountingDocument,
  ExcessDelayInvcFinalAmt.AccountingDocumentItem AS AccountingDocumentItem,
  ExcessDelayInvcFinalAmt.ClearingJournalEntry AS ClearingJournalEntry,
  ExcessDelayInvcFinalAmt.AccountingDocumentType AS AccountingDocumentType,
  ExcessDelayInvcFinalAmt.DebitCreditCode AS DebitCreditCode,
  ExcessDelayInvcFinalAmt.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  ExcessDelayInvcFinalAmt.CompanyCodeCurrency AS CompanyCodeCurrency,
  ExcessDelayInvcFinalAmt.Supplier AS Supplier,
  ExcessDelayInvcFinalAmt.Customer AS Customer,
  ExcessDelayInvcFinalAmt.DocumentDate AS DocumentDate,
  ExcessDelayInvcFinalAmt.PostingDate AS PostingDate,
  ExcessDelayInvcFinalAmt.DueCalculationBaseDate AS DueCalculationBaseDate,
  ExcessDelayInvcFinalAmt.NetDueDate AS NetDueDate,
  ExcessDelayInvcFinalAmt.ClearingDate AS ClearingDate,
  ExcessDelayInvcFinalAmt.InvoiceReceiptDate AS InvoiceReceiptDate,
  ExcessDelayInvcFinalAmt.DocumentReferenceID AS DocumentReferenceID,
  ExcessDelayInvcFinalAmt.DocumentItemText AS DocumentItemText,
  ExcessDelayInvcFinalAmt.InvoiceReference AS InvoiceReference,
  ExcessDelayInvcFinalAmt.InvoiceItemReference AS InvoiceItemReference,
  ExcessDelayInvcFinalAmt.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  ExcessDelayInvcFinalAmt.FollowOnDocumentType AS FollowOnDocumentType,
  ExcessDelayInvcFinalAmt.PaymentTerms AS PaymentTerms,
  ExcessDelayInvcFinalAmt.CashDiscount1Days AS CashDiscount1Days,
  ExcessDelayInvcFinalAmt.CashDiscount2Days AS CashDiscount2Days,
  ExcessDelayInvcFinalAmt.NetPaymentDays AS NetPaymentDays,
  ExcessDelayInvcFinalAmt.CashDiscount1Percent AS CashDiscount1Percent,
  ExcessDelayInvcFinalAmt.CashDiscount2Percent AS CashDiscount2Percent,
  ExcessDelayInvcFinalAmt.AssignmentReference AS AssignmentReference
FROM P_PL_ExcessDelayInvcFinalAmt
;

Learn More