P_CUSTOMERVENDORLINEITEM

CDS View

P_CUSTOMERVENDORLINEITEM is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_FirstDbtrCrdtrRblsPyblMinItm view from COMPOSITE 
@AbapCatalog.sqlViewName: 'PCSTVENLINITM'
@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_CustomerVendorLineItem as select from I_JournalEntry

inner join I_OperationalAcctgDocItem on I_JournalEntry.CompanyCode          = I_OperationalAcctgDocItem.CompanyCode and
                                        I_JournalEntry.AccountingDocument   = I_OperationalAcctgDocItem.AccountingDocument and
                                        I_JournalEntry.FiscalYear           = I_OperationalAcctgDocItem.FiscalYear

/*association [0..1] to I_OneTimeAccountBP  as _OneTimeAccountBP               on  $projection.CompanyCode                     = _OneTimeAccountBP.CompanyCode
                                                                             and $projection.FiscalYear                 = _OneTimeAccountBP.FiscalYear
                                                                             and $projection.AccountingDocument         = _OneTimeAccountBP.AccountingDocument
                                                                             and $projection.AccountingDocumentItem     = _OneTimeAccountBP.AccountingDocumentItem
association [1..1] to I_AccountingDocument as _ClearingAccountingDocument    on  $projection.CompanyCode                = _ClearingAccountingDocument.CompanyCode
                                                                             and $projection.FiscalYear                 = _ClearingAccountingDocument.FiscalYear
                                                                             and $projection.ClearingAccountingDocument = _ClearingAccountingDocument.AccountingDocument*/

 {

      @ObjectModel.foreignKey.association: '_CompanyCode'
  key I_JournalEntry.CompanyCode as CompanyCode,
  key I_JournalEntry.AccountingDocument,
      @ObjectModel.foreignKey.association: '_FiscalYear'
  key I_JournalEntry.FiscalYear,
  key I_OperationalAcctgDocItem.AccountingDocumentItem,

  /*case
  when I_JournalEntry.TaxReportingDate = '00000000' 
  then I_JournalEntry.PostingDate
  else I_JournalEntry.TaxReportingDate
  end as ReportingDate,
  
  case
  when I_JournalEntry.TaxReportingDate = '00000000' 
  then I_JournalEntry.DocumentDate
  else I_JournalEntry.TaxReportingDate
  end as TaxReportingDocumentDate,*/
  '00000000' as ReportingDate,
  '00000000' as TaxReportingDocumentDate,
  I_JournalEntry.TaxReportingDate,
  I_JournalEntry.PostingDate,
  I_JournalEntry.DocumentDate,
  I_OperationalAcctgDocItem.FinancialAccountType
/*  
  
      @ObjectModel.foreignKey.association: '_ClearingAccountingDocument'
  I_OperationalAcctgDocItem.ClearingAccountingDocument,
      @ObjectModel.foreignKey.association: '_Customer'
  Customer,
      @ObjectModel.foreignKey.association: '_Supplier'
  Supplier,
  DocumentItemText,
  ClearingDocFiscalYear,
  FinancialAccountType,
  _Supplier,
  _Customer,
  _OneTimeAccountBP,
  _ClearingAccountingDocument*/

}
where I_OperationalAcctgDocItem.FinancialAccountType = 'D' or
      I_OperationalAcctgDocItem.FinancialAccountType = 'K' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY",
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More