P_FirstDbtrCrdtrRblsPyblMinItm

DDL: P_FIRSTDBTRCRDTRRBLSPYBLMINITM SQL: PDKMINITEM Type: view COMPOSITE

P_FirstDbtrCrdtrRblsPyblMinItm is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_CustomerVendorLineItem) and exposes 9 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
P_CustomerVendorLineItem P_CustomerVendorLineItem from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PDKMINITEM view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
VDM.private true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
KEY AccountingDocumentItem
ReportingDate ReportingDate
TaxReportingDocumentDate TaxReportingDocumentDate
TaxReportingDate TaxReportingDate
PostingDate PostingDate
DocumentDate DocumentDate 
@AbapCatalog.sqlViewName: 'PDKMINITEM'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #X
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true
@VDM.private: true
define view P_FirstDbtrCrdtrRblsPyblMinItm as select from P_CustomerVendorLineItem
{
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key CompanyCode,
      @ObjectModel.foreignKey.association: '_JournalEntry'
  key AccountingDocument,
      @ObjectModel.foreignKey.association: '_FiscalYear'
  key FiscalYear,
  
  key min(AccountingDocumentItem)       as  AccountingDocumentItem,
  ReportingDate,
  TaxReportingDocumentDate,
  TaxReportingDate,
  PostingDate,
  DocumentDate

}
group by
CompanyCode,
AccountingDocument,
FiscalYear,
ReportingDate,
TaxReportingDocumentDate,
TaxReportingDate,
PostingDate,
DocumentDate
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CUSTOMERVENDORLINEITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More