P_BOPRblsPyblsMinItem

DDL: P_BOPRBLSPYBLSMINITEM Type: view_entity COMPOSITE

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.

1 data source(s) 7 fields

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
KEY AccountingDocument P_BOPRblsPyblsItemFilter AccountingDocument
KEY FiscalYear P_BOPRblsPyblsItemFilter FiscalYear
KEY BOPForm P_BOPRblsPyblsItemFilter BOPForm
KEY BOPRptgCntry P_BOPRblsPyblsItemFilter BOPRptgCntry
KEY CompanyCodeCountry P_BOPRblsPyblsItemFilter CompanyCodeCountry
AccountingDocumentItem 
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view entity P_BOPRblsPyblsMinItem
  as select from P_BOPRblsPyblsItemFilter
{
  key P_BOPRblsPyblsItemFilter.CompanyCode,
  key P_BOPRblsPyblsItemFilter.AccountingDocument,
  key P_BOPRblsPyblsItemFilter.FiscalYear,
  key P_BOPRblsPyblsItemFilter.BOPForm,
  key P_BOPRblsPyblsItemFilter.BOPRptgCntry,
  key P_BOPRblsPyblsItemFilter.CompanyCodeCountry,
      min(P_BOPRblsPyblsItemFilter.AccountingDocumentItem) as AccountingDocumentItem
}
group by
  P_BOPRblsPyblsItemFilter.CompanyCode,
  P_BOPRblsPyblsItemFilter.AccountingDocument,
  P_BOPRblsPyblsItemFilter.FiscalYear,
  P_BOPRblsPyblsItemFilter.BOPForm,
  P_BOPRblsPyblsItemFilter.BOPRptgCntry,
  P_BOPRblsPyblsItemFilter.CompanyCodeCountry
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_BOPRBLSPYBLSITEMFILTER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More