C_HR_CustomerItemReference

DDL: C_HR_CUSTOMERITEMREFERENCE Type: view_entity CONSUMPTION
15 Fields 1 Data Sources

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 15 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem.

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 (15)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode Receiver Company Code
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
ClearingDate I_OperationalAcctgDocItem ClearingDate Clearing Date
InvoiceReference I_OperationalAcctgDocItem InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear I_OperationalAcctgDocItem InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
InvoiceItemReference I_OperationalAcctgDocItem InvoiceItemReference Item
InvoiceReferenceNetDueDate
InvoiceReferenceClearingDate
IsReversal
IsReversed
ReverseDocument
ReverseDocumentFiscalYear

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_HR_CustomerItemReference.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_HR_CustomerItemReference AS
SELECT
  CustomerItemReference.CompanyCode AS CompanyCode,
  CustomerItemReference.AccountingDocument AS AccountingDocument,
  CustomerItemReference.FiscalYear AS FiscalYear,
  CustomerItemReference.AccountingDocumentItem AS AccountingDocumentItem,
  CustomerItemReference.PostingDate AS PostingDate,
  CustomerItemReference.ClearingDate AS ClearingDate,
  CustomerItemReference.InvoiceReference AS InvoiceReference,
  CustomerItemReference.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  CustomerItemReference.InvoiceItemReference AS 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,
  CustomerItemReference._JournalEntry.IsReversal AS IsReversal,
  CustomerItemReference._JournalEntry.IsReversed AS IsReversed,
  CustomerItemReference._JournalEntry.ReverseDocument AS ReverseDocument,
  CustomerItemReference._JournalEntry.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear
FROM I_OperationalAcctgDocItem AS CustomerItemReference
;

Learn More