I_HR_CustomerItem

DDL: I_HR_CUSTOMERITEM Type: view_entity COMPOSITE
21 Fields 1 Data Sources

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.

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 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
ClearingDate I_OperationalAcctgDocItem ClearingDate Clearing Date
ClearingJournalEntry I_OperationalAcctgDocItem ClearingJournalEntry Clrng doc.
ClearingJournalEntryFiscalYear I_OperationalAcctgDocItem ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
InvoiceReference I_OperationalAcctgDocItem InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear I_OperationalAcctgDocItem InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
InvoiceItemReference I_OperationalAcctgDocItem InvoiceItemReference Item
NetDueDate I_OperationalAcctgDocItem NetDueDate Net Due Date
PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency Local Currency
Customer I_OperationalAcctgDocItem Customer Sold-to Party
VATRegistration I_OperationalAcctgDocItem VATRegistration VAT Registration No.
TaxCode I_OperationalAcctgDocItem TaxCode Tax Code
TaxItemGroup I_OperationalAcctgDocItem TaxItemGroup Tax doc. item number
SpecialGLCode I_OperationalAcctgDocItem SpecialGLCode Special G/L Ind
AmountInCompanyCodeCurrency I_OperationalAcctgDocItem AmountInCompanyCodeCurrency Local Crcy Amt
Country
_Customer I_OperationalAcctgDocItem _Customer

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 I_HR_CustomerItem.
-- 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 I_HR_CustomerItem AS
SELECT
  CustomerItem.CompanyCode AS CompanyCode,
  CustomerItem.AccountingDocument AS AccountingDocument,
  CustomerItem.FiscalYear AS FiscalYear,
  CustomerItem.AccountingDocumentItem AS AccountingDocumentItem,
  CustomerItem.ClearingDate AS ClearingDate,
  CustomerItem.ClearingJournalEntry AS ClearingJournalEntry,
  CustomerItem.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  CustomerItem.InvoiceReference AS InvoiceReference,
  CustomerItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  CustomerItem.InvoiceItemReference AS InvoiceItemReference,
  CustomerItem.NetDueDate AS NetDueDate,
  CustomerItem.PostingDate AS PostingDate,
  CustomerItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  CustomerItem.Customer AS Customer,
  CustomerItem.VATRegistration AS VATRegistration,
  CustomerItem.TaxCode AS TaxCode,
  CustomerItem.TaxItemGroup AS TaxItemGroup,
  CustomerItem.SpecialGLCode AS SpecialGLCode,
  CustomerItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  CustomerItem._Customer.Country AS Country,
  CustomerItem._Customer AS _Customer
FROM I_OperationalAcctgDocItem AS CustomerItem
;

Learn More