P_ES_PTRInvoiceItem

DDL: P_ES_PTRINVOICEITEM Type: view_entity COMPOSITE Package: GLO_FIN_IS_AUDIT_ES
38 Fields 1 Data Sources

Invoice Data for Spain Payment Time Reporting

P_ES_PTRInvoiceItem is a Composite CDS View that provides data about "Invoice Data for Spain Payment Time Reporting" in SAP S/4HANA. It reads from 1 data source (P_ES_PTRClearingDateBoE) and exposes 38 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem. Part of development package GLO_FIN_IS_AUDIT_ES.

Data Sources (1)

SourceAliasJoin Type
P_ES_PTRClearingDateBoE BSEGITEM from

Parameters (2)

NameTypeDefault
P_StartDate vdm_v_start_date
P_EndDate vdm_v_end_date

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_ES_PTRClearingDateBoE CompanyCode Receiver Company Code
KEY FiscalYear P_ES_PTRClearingDateBoE FiscalYear G/L Fiscal Year
KEY AccountingDocument P_ES_PTRClearingDateBoE AccountingDocument Journal Entry
KEY AccountingDocumentItem P_ES_PTRClearingDateBoE AccountingDocumentItem Posting View Item
AccountingDocumentType P_ES_PTRClearingDateBoE AccountingDocumentType Journal Entry Type
IsUsedInPaymentTransaction P_ES_PTRClearingDateBoE IsUsedInPaymentTransaction Is Used In Payment Transaction
FinancialAccountType P_ES_PTRClearingDateBoE FinancialAccountType Fin. Account Type
Supplier P_ES_PTRClearingDateBoE Supplier Supplier
PostingDate P_ES_PTRClearingDateBoE PostingDate Posting Date for GR
DocumentDate P_ES_PTRClearingDateBoE DocumentDate Journal Entry Date
TaxFulfillmentDate
ClearingDate P_ES_PTRClearingDateBoE ClearingDate Clearing Date
FiscalPeriod P_ES_PTRClearingDateBoE FiscalPeriod Tax period
GLAccount P_ES_PTRClearingDateBoE GLAccount General Ledger
DueCalculationBaseDate P_ES_PTRClearingDateBoE DueCalculationBaseDate Due Calculation Base Date
NetDueDate P_ES_PTRClearingDateBoE NetDueDate Net Due Date
PaymentTerms P_ES_PTRClearingDateBoE PaymentTerms Pyt Terms
PaymentBlockingReason P_ES_PTRClearingDateBoE PaymentBlockingReason Pmnt block
PaymentMethod P_ES_PTRClearingDateBoE PaymentMethod Pymt Meth.
FollowOnDocumentType P_ES_PTRClearingDateBoE FollowOnDocumentType Follow-On Document Type
DebitCreditCode P_ES_PTRClearingDateBoE DebitCreditCode Single-Character Flag
SpecialGLCode P_ES_PTRClearingDateBoE SpecialGLCode Special G/L Ind
SpecialGLTransactionType P_ES_PTRClearingDateBoE SpecialGLTransactionType Transact.Type
ClearingJournalEntry P_ES_PTRClearingDateBoE ClearingJournalEntry Clrng doc.
CompanyCodeCurrency P_ES_PTRClearingDateBoE CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency P_ES_PTRClearingDateBoE AmountInCompanyCodeCurrency Local Crcy Amt
TransactionCurrency P_ES_PTRClearingDateBoE TransactionCurrency Transaction Currency
AmountInTransactionCurrency P_ES_PTRClearingDateBoE AmountInTransactionCurrency Pt Crcy Amt
_CompanyCode P_ES_PTRClearingDateBoE _CompanyCode
_FiscalYear P_ES_PTRClearingDateBoE _FiscalYear
_JournalEntry P_ES_PTRClearingDateBoE _JournalEntry
_AccountingDocumentType P_ES_PTRClearingDateBoE _AccountingDocumentType
_FiscalPeriod P_ES_PTRClearingDateBoE _FiscalPeriod
_FinancialAccountType P_ES_PTRClearingDateBoE _FinancialAccountType
_GLAccountInCompanyCode P_ES_PTRClearingDateBoE _GLAccountInCompanyCode
_SpecialGLCode P_ES_PTRClearingDateBoE _SpecialGLCode
_CompanyCodeCurrency P_ES_PTRClearingDateBoE _CompanyCodeCurrency
_TransactionCurrency P_ES_PTRClearingDateBoE _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_ES_PTRInvoiceItem.
-- 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.
-- Parameters: P_StartDate : vdm_v_start_date, P_EndDate : vdm_v_end_date

CREATE VIEW P_ES_PTRInvoiceItem 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,
  BSEGITEM.Supplier AS Supplier,
  BSEGITEM.PostingDate AS PostingDate,
  BSEGITEM.DocumentDate AS DocumentDate,
  BSEGITEM._JournalEntry.TaxFulfillmentDate AS TaxFulfillmentDate,
  BSEGITEM.ClearingDate AS ClearingDate,
  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.PaymentMethod AS PaymentMethod,
  BSEGITEM.FollowOnDocumentType AS FollowOnDocumentType,
  BSEGITEM.DebitCreditCode AS DebitCreditCode,
  BSEGITEM.SpecialGLCode AS SpecialGLCode,
  BSEGITEM.SpecialGLTransactionType AS SpecialGLTransactionType,
  BSEGITEM.ClearingJournalEntry AS ClearingJournalEntry,
  BSEGITEM.CompanyCodeCurrency AS CompanyCodeCurrency,
  BSEGITEM.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  BSEGITEM.TransactionCurrency AS TransactionCurrency,
  BSEGITEM.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  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 P_ES_PTRClearingDateBoE AS BSEGITEM
;

Learn More