I_HR_CustomerItem

DDL: I_HR_CUSTOMERITEM Type: view_entity COMPOSITE

OPZ STAT 1 Customer Item

I_HR_CustomerItem is a Composite CDS View that provides data about "OPZ STAT 1 Customer Item" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 21 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem CustomerItem from

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
EndUserText.label OPZ STAT 1 Customer Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem
ClearingDate I_OperationalAcctgDocItem ClearingDate
ClearingJournalEntry I_OperationalAcctgDocItem ClearingJournalEntry
ClearingJournalEntryFiscalYear I_OperationalAcctgDocItem ClearingJournalEntryFiscalYear
InvoiceReference I_OperationalAcctgDocItem InvoiceReference
InvoiceReferenceFiscalYear I_OperationalAcctgDocItem InvoiceReferenceFiscalYear
InvoiceItemReference I_OperationalAcctgDocItem InvoiceItemReference
NetDueDate I_OperationalAcctgDocItem NetDueDate
PostingDate I_OperationalAcctgDocItem PostingDate
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency
Customer I_OperationalAcctgDocItem Customer
VATRegistration I_OperationalAcctgDocItem VATRegistration
TaxCode I_OperationalAcctgDocItem TaxCode
TaxItemGroup I_OperationalAcctgDocItem TaxItemGroup
SpecialGLCode I_OperationalAcctgDocItem SpecialGLCode
AmountInCompanyCodeCurrency I_OperationalAcctgDocItem AmountInCompanyCodeCurrency
Country
_Customer I_OperationalAcctgDocItem _Customer 
@VDM.viewType: #COMPOSITE
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@EndUserText.label: 'OPZ STAT 1 Customer Item'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED

define view entity I_HR_CustomerItem as select from I_OperationalAcctgDocItem as CustomerItem

{
   key CustomerItem.CompanyCode,
   key CustomerItem.AccountingDocument,
   key CustomerItem.FiscalYear,
   key CustomerItem.AccountingDocumentItem,
   CustomerItem.ClearingDate,
   CustomerItem.ClearingJournalEntry,
   CustomerItem.ClearingJournalEntryFiscalYear,
   CustomerItem.InvoiceReference,
   CustomerItem.InvoiceReferenceFiscalYear,
   CustomerItem.InvoiceItemReference,
   CustomerItem.NetDueDate,
   CustomerItem.PostingDate,
   CustomerItem.CompanyCodeCurrency,
   CustomerItem.Customer,
   CustomerItem.VATRegistration,
   CustomerItem.TaxCode,
   CustomerItem.TaxItemGroup,
   CustomerItem.SpecialGLCode,

   @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
   CustomerItem.AmountInCompanyCodeCurrency,

   CustomerItem._Customer.Country,
   CustomerItem._Customer
}

where
  CustomerItem.FinancialAccountType = 'D'
  and CustomerItem.AccountingDocumentCategory <> 'D'
  and CustomerItem.AccountingDocumentCategory <> 'M'
  and CustomerItem.InvoiceReference is initial
  /*
    This condition is necessary to exclude residual items which clear the original invoice
  */
  and CustomerItem.AmountInCompanyCodeCurrency > 0

Learn More