C_StRpOverdueInvoicesQuery

DDL: C_STRPOVERDUEINVOICESQUERY SQL: CSROVRDUEINVQ Type: view CONSUMPTION Package: GLO_FIN_IS_PL
38 Fields 1 Data Sources

Overdue Invoices Qry for Stat. Reporting

C_StRpOverdueInvoicesQuery is a Consumption CDS View that provides data about "Overdue Invoices Qry for Stat. Reporting" in SAP S/4HANA. It reads from 1 data source (C_StRpOverdueInvoicesCube) and exposes 38 fields. Part of development package GLO_FIN_IS_PL.

Data Sources (1)

SourceAliasJoin Type
C_StRpOverdueInvoicesCube C_StRpOverdueInvoicesCube from

Parameters (1)

NameTypeDefault
P_KeyDate fipl_keydate

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CSROVRDUEINVQ view
VDM.viewType #CONSUMPTION view
Analytics.query true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Overdue Invoices Qry for Stat. Reporting view

Fields (38)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode Receiver Company Code
FiscalYear FiscalYear G/L Fiscal Year
AccountingDocument AccountingDocument Journal Entry
DocumentReferenceID DocumentReferenceID Reference
AccountingDocumentType AccountingDocumentType Journal Entry Type
DocumentDate DocumentDate Journal Entry Date
PostingDate PostingDate Posting Date for GR
TaxReportingDate TaxReportingDate Tax Reporting Date
Customer Customer Sold-to Party
CustomerName CustomerName Name of Customer
Supplier Supplier Supplier
SupplierName SupplierName Supplier Name
GLAccount GLAccount General Ledger
DueCalculationBaseDate DueCalculationBaseDate Due Calculation Base Date
NetDueDate NetDueDate Net Due Date
PaymentTerms PaymentTerms Pyt Terms
CashDiscount1Days CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent CashDiscount2Percent Disc. Percent 2
PL_KSeFReferenceNumber PL_KSeFReferenceNumber KSeF Reference Number
PL_LongInvoiceNumber PL_LongInvoiceNumber Long Invoice Number (ODN)
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
TransactionCurrency TransactionCurrency Transaction Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
DebitCreditCode DebitCreditCode Single-Character Flag
TaxCode TaxCode Tax Code
DocumentItemText DocumentItemText Text
ClearingDate ClearingDate Clearing Date
IsCleared IsCleared Integer
NetDueArrearsDays NetDueArrearsDays
NetDueDays NetDueDays
StatryRptgEntity StatryRptgEntity Reporting Entity
StatryRptCategory StatryRptCategory Report ID
StatryRptRunID StatryRptRunID Report Run ID
_DebitCreditCode _DebitCreditCode

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_StRpOverdueInvoicesQuery.
-- 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: CSROVRDUEINVQ
-- Parameters: P_KeyDate : fipl_keydate

CREATE VIEW C_StRpOverdueInvoicesQuery AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  DocumentReferenceID,
  AccountingDocumentType,
  DocumentDate,
  PostingDate,
  TaxReportingDate,
  Customer,
  CustomerName,
  Supplier,
  SupplierName,
  GLAccount,
  DueCalculationBaseDate,
  NetDueDate,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PL_KSeFReferenceNumber,
  PL_LongInvoiceNumber,
  AmountInTransactionCurrency,
  AmountInCompanyCodeCurrency,
  TransactionCurrency,
  CompanyCodeCurrency,
  DebitCreditCode,
  TaxCode,
  DocumentItemText,
  ClearingDate,
  IsCleared,
  NetDueArrearsDays,
  NetDueDays,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID
FROM C_StRpOverdueInvoicesCube
;

Learn More