P_FR_OverdueInvoiceItem

DDL: P_FR_OVERDUEINVOICEITEM SQL: PFROVRDINVCINVCI Type: view COMPOSITE
33 Fields 1 Data Sources

P_FR_OverdueInvoiceItem is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 33 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem BSEGITEM from

Parameters (2)

NameTypeDefault
P_KeyDate vdm_v_key_date
P_ExchangeRateType kurst

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PFROVRDINVCINVCI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (33)

KeyFieldSource TableSource FieldDescription
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
AccountingDocumentType I_OperationalAcctgDocItem AccountingDocumentType Journal Entry Type
IsUsedInPaymentTransaction I_OperationalAcctgDocItem IsUsedInPaymentTransaction Is Used In Payment Transaction
FinancialAccountType I_OperationalAcctgDocItem FinancialAccountType Fin. Account Type
BusinessPartnerendasBusinessPartner
PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
DocumentDate I_OperationalAcctgDocItem DocumentDate Journal Entry Date
FiscalPeriod I_OperationalAcctgDocItem FiscalPeriod Tax period
GLAccount I_OperationalAcctgDocItem GLAccount General Ledger
DueCalculationBaseDate I_OperationalAcctgDocItem DueCalculationBaseDate Due Calculation Base Date
NetDueDate I_OperationalAcctgDocItem NetDueDate Net Due Date
PaymentTerms I_OperationalAcctgDocItem PaymentTerms Pyt Terms
PaymentBlockingReason I_OperationalAcctgDocItem PaymentBlockingReason Pmnt block
SpecialGLCode I_OperationalAcctgDocItem SpecialGLCode Special G/L Ind
SpecialGLTransactionType I_OperationalAcctgDocItem SpecialGLTransactionType Transact.Type
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency I_OperationalAcctgDocItem AmountInCompanyCodeCurrency Local Crcy Amt
TransactionCurrency I_OperationalAcctgDocItem TransactionCurrency Transaction Currency
AmountInTransactionCurrency I_OperationalAcctgDocItem AmountInTransactionCurrency Pt Crcy Amt
InvoiceAlreadyPaidAmtInCCCrcy
_CompanyCode I_OperationalAcctgDocItem _CompanyCode
_FiscalYear I_OperationalAcctgDocItem _FiscalYear
_JournalEntry I_OperationalAcctgDocItem _JournalEntry
_AccountingDocumentType I_OperationalAcctgDocItem _AccountingDocumentType
_FiscalPeriod I_OperationalAcctgDocItem _FiscalPeriod
_FinancialAccountType I_OperationalAcctgDocItem _FinancialAccountType
_GLAccountInCompanyCode I_OperationalAcctgDocItem _GLAccountInCompanyCode
_SpecialGLCode I_OperationalAcctgDocItem _SpecialGLCode
_CompanyCodeCurrency I_OperationalAcctgDocItem _CompanyCodeCurrency
_TransactionCurrency I_OperationalAcctgDocItem _TransactionCurrency

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_FR_OverdueInvoiceItem.
-- 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: PFROVRDINVCINVCI
-- Parameters: P_KeyDate : vdm_v_key_date, P_ExchangeRateType : kurst

CREATE VIEW P_FR_OverdueInvoiceItem AS
SELECT
  BSEGITEM.CompanyCode AS CompanyCode,
  BSEGITEM.FiscalYear AS FiscalYear,
  BSEGITEM.AccountingDocument AS AccountingDocument,
  BSEGITEM.AccountingDocumentItem AS AccountingDocumentItem,
  BSEGITEM.AccountingDocumentType AS AccountingDocumentType,
  BSEGITEM.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  BSEGITEM.FinancialAccountType AS FinancialAccountType,
  case when BSEGITEM.FinancialAccountType = 'D' then BSEGITEM._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner when BSEGITEM.FinancialAccountType = 'K' then BSEGITEM._Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartner end as BusinessPartner AS BusinessPartnerendasBusinessPartner,
  BSEGITEM.PostingDate AS PostingDate,
  BSEGITEM.DocumentDate AS DocumentDate,
  BSEGITEM.FiscalPeriod AS FiscalPeriod,
  BSEGITEM.GLAccount AS GLAccount,
  BSEGITEM.DueCalculationBaseDate AS DueCalculationBaseDate,
  BSEGITEM.NetDueDate AS NetDueDate,
  BSEGITEM.PaymentTerms AS PaymentTerms,
  BSEGITEM.PaymentBlockingReason AS PaymentBlockingReason,
  BSEGITEM.SpecialGLCode AS SpecialGLCode,
  BSEGITEM.SpecialGLTransactionType AS SpecialGLTransactionType,
  BSEGITEM.CompanyCodeCurrency AS CompanyCodeCurrency,
  BSEGITEM.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  BSEGITEM.TransactionCurrency AS TransactionCurrency,
  BSEGITEM.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  cast( sum( PAYTBSEG.ByKDtEvaldInvcAmtInCoCodeCrc ) as invoicealreadypaidamt ) AS InvoiceAlreadyPaidAmtInCCCrcy,
  BSEGITEM._CompanyCode AS _CompanyCode,
  BSEGITEM._FiscalYear AS _FiscalYear,
  BSEGITEM._JournalEntry AS _JournalEntry,
  BSEGITEM._AccountingDocumentType AS _AccountingDocumentType,
  BSEGITEM._FiscalPeriod AS _FiscalPeriod,
  BSEGITEM._FinancialAccountType AS _FinancialAccountType,
  BSEGITEM._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  BSEGITEM._SpecialGLCode AS _SpecialGLCode,
  BSEGITEM._CompanyCodeCurrency AS _CompanyCodeCurrency,
  BSEGITEM._TransactionCurrency AS _TransactionCurrency
FROM I_OperationalAcctgDocItem AS BSEGITEM
;

Learn More