C_HR_CustomerItemReference

DDL: C_HR_CUSTOMERITEMREFERENCE Type: view_entity CONSUMPTION

OPZ STAT 1 Customer Item Reference

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

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem CustomerItemReference from

Annotations (8)

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

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem
PostingDate I_OperationalAcctgDocItem PostingDate
ClearingDate I_OperationalAcctgDocItem ClearingDate
InvoiceReference I_OperationalAcctgDocItem InvoiceReference
InvoiceReferenceFiscalYear I_OperationalAcctgDocItem InvoiceReferenceFiscalYear
InvoiceItemReference I_OperationalAcctgDocItem InvoiceItemReference
InvoiceReferenceNetDueDate
InvoiceReferenceClearingDate 
@VDM.viewType: #CONSUMPTION
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'OPZ STAT 1 Customer Item Reference'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED

/*
  This view returns customer items with a reference to another customer item. In practice such documents are
  expected to be either partial payments or residual items.
*/

define view entity C_HR_CustomerItemReference as select from I_OperationalAcctgDocItem as CustomerItemReference

  inner many to one join I_HR_CustomerItem as ReferredCustomerItem
    on  CustomerItemReference.CompanyCode                = ReferredCustomerItem.CompanyCode
    and CustomerItemReference.InvoiceReference           = ReferredCustomerItem.AccountingDocument
    and CustomerItemReference.InvoiceReferenceFiscalYear = ReferredCustomerItem.FiscalYear
    and CustomerItemReference.InvoiceItemReference       = ReferredCustomerItem.AccountingDocumentItem

{
   key CustomerItemReference.CompanyCode,
   key CustomerItemReference.AccountingDocument,
   key CustomerItemReference.FiscalYear,
   key CustomerItemReference.AccountingDocumentItem,
   CustomerItemReference.PostingDate,
   CustomerItemReference.ClearingDate,
   CustomerItemReference.InvoiceReference,
   CustomerItemReference.InvoiceReferenceFiscalYear,
   CustomerItemReference.InvoiceItemReference,
   cast(ReferredCustomerItem.NetDueDate as fiisvat_hr_opz_ref_due_date preserving type ) as InvoiceReferenceNetDueDate,
   cast(ReferredCustomerItem.ClearingDate as fiisvat_hr_opz_ref_clear_date preserving type ) as InvoiceReferenceClearingDate
}
where
  CustomerItemReference.FinancialAccountType ='D'
  and CustomerItemReference.AccountingDocumentCategory <> 'D'
  and CustomerItemReference.AccountingDocumentCategory <> 'M'
  // All partial payments/residual items refer to another invoice

  and CustomerItemReference.InvoiceReference is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_HR_CUSTOMERITEM",
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More