P_BOPRblsPyblsMinItem

DDL: P_BOPRBLSPYBLSMINITEM Type: view_entity COMPOSITE Package: GLO_FIN_IS_BOP_GEN

BOP: Receivables/Payables Base Item Min Line Item

P_BOPRblsPyblsMinItem is a Composite CDS View that provides data about "BOP: Receivables/Payables Base Item Min Line Item" in SAP S/4HANA. It reads from 1 data source (P_BOPRblsPyblsItemFilter) and exposes 7 fields with key fields CompanyCode, AccountingDocument, FiscalYear, BOPForm, BOPRptgCntry. Part of development package GLO_FIN_IS_BOP_GEN.

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

Learn More