P_CUSTOMERVENDORLINEITEM1

DDL: P_CUSTOMERVENDORLINEITEM1 SQL: PCSTVENLINITM1 Type: view COMPOSITE Package: GLO_FIN_IS_VAT_GEN

Customer Vendor Line Item

P_CUSTOMERVENDORLINEITEM1 is a Composite CDS View that provides data about "Customer Vendor Line Item" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 18 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem. It has 2 associations to related views. Part of development package GLO_FIN_IS_VAT_GEN.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_JournalEntryItemOneTimeData _OneTimeAccountBP $projection.CompanyCode = _OneTimeAccountBP.CompanyCode and $projection.FiscalYear = _OneTimeAccountBP.FiscalYear and $projection.AccountingDocument = _OneTimeAccountBP.AccountingDocument and $projection.AccountingDocumentItem = _OneTimeAccountBP.AccountingDocumentItem and _OneTimeAccountBP.IsOneTimeAccount = 'X'
[1..1] I_AccountingDocument _ClearingAccountingDocument $projection.CompanyCode = _ClearingAccountingDocument.CompanyCode and $projection.FiscalYear = _ClearingAccountingDocument.FiscalYear and $projection.ClearingAccountingDocument = _ClearingAccountingDocument.AccountingDocument

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCSTVENLINITM1 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 (18)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem
ClearingAccountingDocument I_OperationalAcctgDocItem ClearingAccountingDocument
Customer Customer
Supplier Supplier
DocumentItemText DocumentItemText
VATRegistration I_OperationalAcctgDocItem VATRegistration
ClearingDocFiscalYear ClearingDocFiscalYear
FinancialAccountType FinancialAccountType
InvoiceReference InvoiceReference
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear
IsNegativePosting IsNegativePosting
_Supplier _Supplier
_Customer _Customer
_OneTimeAccountBP _OneTimeAccountBP
_ClearingAccountingDocument _ClearingAccountingDocument 
@AbapCatalog.sqlViewName: 'PCSTVENLINITM1'
@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_CUSTOMERVENDORLINEITEM1 as select from  I_OperationalAcctgDocItem

association [0..1] to I_JournalEntryItemOneTimeData  as _OneTimeAccountBP    on  $projection.CompanyCode                = _OneTimeAccountBP.CompanyCode
                                                                             and $projection.FiscalYear                 = _OneTimeAccountBP.FiscalYear
                                                                             and $projection.AccountingDocument         = _OneTimeAccountBP.AccountingDocument
                                                                             and $projection.AccountingDocumentItem     = _OneTimeAccountBP.AccountingDocumentItem
                                                                             and _OneTimeAccountBP.IsOneTimeAccount     = 'X'
association [1..1] to I_AccountingDocument as _ClearingAccountingDocument    on  $projection.CompanyCode                = _ClearingAccountingDocument.CompanyCode
                                                                             and $projection.FiscalYear                 = _ClearingAccountingDocument.FiscalYear
                                                                             and $projection.ClearingAccountingDocument = _ClearingAccountingDocument.AccountingDocument

 {

  key I_OperationalAcctgDocItem.CompanyCode as CompanyCode,
  key I_OperationalAcctgDocItem.AccountingDocument,
  key I_OperationalAcctgDocItem.FiscalYear,
  key I_OperationalAcctgDocItem.AccountingDocumentItem,

  I_OperationalAcctgDocItem.ClearingAccountingDocument,
      @ObjectModel.foreignKey.association: '_Customer'
  Customer,
      @ObjectModel.foreignKey.association: '_Supplier'
  Supplier,
  DocumentItemText,
  I_OperationalAcctgDocItem.VATRegistration,
  ClearingDocFiscalYear,
  FinancialAccountType,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  IsNegativePosting,
  _Supplier,
  _Customer,
  _OneTimeAccountBP,
  _ClearingAccountingDocument

}
where FinancialAccountType                                                              = 'D' or
      FinancialAccountType                                                              = 'K'

Learn More