P_HR_CustomerVendorLineItem

DDL: P_HR_CUSTOMERVENDORLINEITEM Type: view_entity COMPOSITE Package: GLO_FIN_IS_VAT_HR

SI VAT Customer Supplier Line Item

P_HR_CustomerVendorLineItem is a Composite CDS View that provides data about "SI VAT Customer Supplier Line Item" in SAP S/4HANA. It reads from 2 data sources (P_HR_FIRSTDBTRCRDTRRBLSPYBLMIN, I_JournalEntry) and exposes 11 fields with key fields CompanyCode, AccountingDocument, FiscalYear. Part of development package GLO_FIN_IS_VAT_HR.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
P_HR_FIRSTDBTRCRDTRRBLSPYBLMIN _CustomerSupplierLine inner
I_JournalEntry I_JournalEntry from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntry CompanyCode
KEY AccountingDocument I_JournalEntry AccountingDocument
KEY FiscalYear I_JournalEntry FiscalYear
AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem
ClearingAccountingDocument I_OperationalAcctgDocItem ClearingAccountingDocument
Customer I_OperationalAcctgDocItem Customer
Supplier I_OperationalAcctgDocItem Supplier
DocumentItemText I_OperationalAcctgDocItem DocumentItemText
VATRegistration I_OperationalAcctgDocItem VATRegistration
SupplyingCountry I_OperationalAcctgDocItem SupplyingCountry
ClearingDate I_OperationalAcctgDocItem ClearingDate 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_HR_CustomerVendorLineItem

  as select from           I_JournalEntry

    inner join             P_HR_FIRSTDBTRCRDTRRBLSPYBLMIN as _CustomerSupplierLine on  I_JournalEntry.CompanyCode        = _CustomerSupplierLine.CompanyCode
                                                                                   and I_JournalEntry.AccountingDocument = _CustomerSupplierLine.AccountingDocument
                                                                                   and I_JournalEntry.FiscalYear         = _CustomerSupplierLine.FiscalYear

    left outer to one join I_OperationalAcctgDocItem                               on  _CustomerSupplierLine.CompanyCode            = I_OperationalAcctgDocItem.CompanyCode
                                                                                   and _CustomerSupplierLine.AccountingDocument     = I_OperationalAcctgDocItem.AccountingDocument
                                                                                   and _CustomerSupplierLine.FiscalYear             = I_OperationalAcctgDocItem.FiscalYear
                                                                                   and _CustomerSupplierLine.AccountingDocumentItem = I_OperationalAcctgDocItem.AccountingDocumentItem

{
  key I_JournalEntry.CompanyCode as CompanyCode,
  key I_JournalEntry.AccountingDocument,
  key I_JournalEntry.FiscalYear,
      I_OperationalAcctgDocItem.AccountingDocumentItem,
      I_OperationalAcctgDocItem.ClearingAccountingDocument,
      I_OperationalAcctgDocItem.Customer,
      I_OperationalAcctgDocItem.Supplier,
      I_OperationalAcctgDocItem.DocumentItemText,
      I_OperationalAcctgDocItem.VATRegistration,
      I_OperationalAcctgDocItem.SupplyingCountry,
      I_OperationalAcctgDocItem.ClearingDate

}

Learn More