P_BOPRblsPyblsMinItem

DDL: P_BOPRBLSPYBLSMINITEM Type: view_entity COMPOSITE
7 Fields 1 Data Sources

P_BOPRblsPyblsMinItem is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_BOPRblsPyblsItemFilter) and exposes 7 fields with key fields CompanyCode, AccountingDocument, FiscalYear, BOPForm, BOPRptgCntry.

Data Sources (1)

SourceAliasJoin Type
P_BOPRblsPyblsItemFilter P_BOPRblsPyblsItemFilter from

Annotations (3)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_BOPRblsPyblsItemFilter CompanyCode Receiver Company Code
KEY AccountingDocument P_BOPRblsPyblsItemFilter AccountingDocument Journal Entry
KEY FiscalYear P_BOPRblsPyblsItemFilter FiscalYear G/L Fiscal Year
KEY BOPForm P_BOPRblsPyblsItemFilter BOPForm Form
KEY BOPRptgCntry P_BOPRblsPyblsItemFilter BOPRptgCntry Reporting Ctry/Reg.
KEY CompanyCodeCountry P_BOPRblsPyblsItemFilter CompanyCodeCountry Reporting Ctry/Reg.
AccountingDocumentItem

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_BOPRblsPyblsMinItem.
-- 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.

CREATE VIEW P_BOPRblsPyblsMinItem AS
SELECT
  P_BOPRblsPyblsItemFilter.CompanyCode AS CompanyCode,
  P_BOPRblsPyblsItemFilter.AccountingDocument AS AccountingDocument,
  P_BOPRblsPyblsItemFilter.FiscalYear AS FiscalYear,
  P_BOPRblsPyblsItemFilter.BOPForm AS BOPForm,
  P_BOPRblsPyblsItemFilter.BOPRptgCntry AS BOPRptgCntry,
  P_BOPRblsPyblsItemFilter.CompanyCodeCountry AS CompanyCodeCountry,
  min(P_BOPRblsPyblsItemFilter.AccountingDocumentItem) AS AccountingDocumentItem
FROM P_BOPRblsPyblsItemFilter
;

Learn More