P_SI_OpnSupplierInvoiceItems

DDL: P_SI_OPNSUPPLIERINVOICEITEMS Type: view_entity CONSUMPTION Package: GLO_FIN_IS_SI_AP
28 Fields

ePobot Slovenia - Items for Stat. log

P_SI_OpnSupplierInvoiceItems is a Consumption CDS View that provides data about "ePobot Slovenia - Items for Stat. log" in SAP S/4HANA. Part of development package GLO_FIN_IS_SI_AP.

Parameters (3)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id

Annotations (8)

NameValueLevelField
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label ePobot Slovenia - Items for Stat. log view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
KEY FiscalYear FiscalYear G/L Fiscal Year
FiscalPeriod FiscalPeriod Tax period
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
DueCalculationBaseDate DueCalculationBaseDate Due Calculation Base Date
NetDueDate NetDueDate Net Due Date
DebitCreditCode DebitCreditCode Single-Character Flag
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
Reference1IDByBusinessPartner Reference1IDByBusinessPartner Reference Key 1
Reference2IDByBusinessPartner Reference2IDByBusinessPartner Reference Key 2
Reference3IDByBusinessPartner Reference3IDByBusinessPartner Reference Key 3
DocumentReferenceID DocumentReferenceID Reference
SupplierVATRegistration SupplierVATRegistration VAT Registration No.
Supplier Supplier Supplier
CustomerSupplierCountry CustomerSupplierCountry Customer or Supplier Country/Region
Country Country Venue: Ctry/Reg
InvoiceReference InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
InvoiceItemReference InvoiceItemReference Item
GLAccount GLAccount General Ledger
PaymentBlockingReason PaymentBlockingReason Pmnt block
StatryRptgEntity
StatryRptCategory
StatryRptRunID

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_SI_OpnSupplierInvoiceItems.
-- 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_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW P_SI_OpnSupplierInvoiceItems AS
SELECT
  CompanyCode,
  AccountingDocument,
  AccountingDocumentItem,
  FiscalYear,
  FiscalPeriod,
  PostingDate,
  DocumentDate,
  DueCalculationBaseDate,
  NetDueDate,
  DebitCreditCode,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  DocumentReferenceID,
  SupplierVATRegistration,
  Supplier,
  CustomerSupplierCountry,
  Country,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  InvoiceItemReference,
  GLAccount,
  PaymentBlockingReason,
  $parameters.P_StatryRptgEntity AS StatryRptgEntity,
  $parameters.P_StatryRptCategory AS StatryRptCategory,
  $parameters.P_StatryRptRunID AS StatryRptRunID
;

Learn More