I_HR_EmployeeExpense

DDL: I_HR_EMPLOYEEEXPENSE Type: view_entity COMPOSITE Package: GLO_FIN_IS_HR_JOPPD_API
24 Fields 1 Data Sources

GS FI IS Croatia JOPPD Employee Expenses

I_HR_EmployeeExpense is a Composite CDS View that provides data about "GS FI IS Croatia JOPPD Employee Expenses" in SAP S/4HANA. It reads from 1 data source (P_HR_ClearedItem) and exposes 24 fields with key fields CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem, Ledger. Part of development package GLO_FIN_IS_HR_JOPPD_API.

Data Sources (1)

SourceAliasJoin Type
P_HR_ClearedItem ClearedItem from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label GS FI IS Croatia JOPPD Employee Expenses view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_HR_ClearedItem CompanyCode Receiver Company Code
KEY FiscalYear P_HR_ClearedItem FiscalYear G/L Fiscal Year
KEY AccountingDocument P_HR_ClearedItem AccountingDocument Journal Entry
KEY LedgerGLLineItem P_HR_ClearedItem LedgerGLLineItem Journal Entry Item
KEY Ledger P_HR_ClearedItem Ledger Ledger
AccountingDocumentItem P_HR_ClearedItem AccountingDocumentItem Posting View Item
AccountingDocumentCategory P_HR_ClearedItem AccountingDocumentCategory Journal Entry Category
AccountingDocumentType P_HR_ClearedItem AccountingDocumentType Journal Entry Type
ClearingDate P_HR_ClearedItem ClearingDate Clearing Date
PostingDate P_HR_ClearedItem PostingDate Posting Date for GR
DocumentDate P_HR_ClearedItem DocumentDate Journal Entry Date
NetDueDate P_HR_ClearedItem NetDueDate Net Due Date
FinancialAccountType P_HR_ClearedItem FinancialAccountType Fin. Account Type
Supplier P_HR_ClearedItem Supplier Supplier
GLAccount P_HR_ClearedItem GLAccount General Ledger
TaxCode P_HR_ClearedItem TaxCode Tax Code
TransactionCurrency P_HR_ClearedItem TransactionCurrency Transaction Currency
AmountInTransactionCurrency P_HR_ClearedItem AmountInTransactionCurrency Pt Crcy Amt
PaymentMethod P_HR_ClearedItem PaymentMethod Pymt Meth.
PersonnelNumber P_HR_ClearedItem PersonnelNumber Personnel No.
ExpenseType GLAccountExpenseType ExpenseType
PaymentType PaymentMethodPaymentType PaymentType
AuthorizationGroup P_HR_ClearedItem AuthorizationGroup AuthorizGroup
SupplierAccountGroup P_HR_ClearedItem SupplierAccountGroup Account group

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_EmployeeExpense.
-- 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_EmployeeExpense AS
SELECT
  ClearedItem.CompanyCode AS CompanyCode,
  ClearedItem.FiscalYear AS FiscalYear,
  ClearedItem.AccountingDocument AS AccountingDocument,
  ClearedItem.LedgerGLLineItem AS LedgerGLLineItem,
  ClearedItem.Ledger AS Ledger,
  ClearedItem.AccountingDocumentItem AS AccountingDocumentItem,
  ClearedItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  ClearedItem.AccountingDocumentType AS AccountingDocumentType,
  ClearedItem.ClearingDate AS ClearingDate,
  ClearedItem.PostingDate AS PostingDate,
  ClearedItem.DocumentDate AS DocumentDate,
  ClearedItem.NetDueDate AS NetDueDate,
  ClearedItem.FinancialAccountType AS FinancialAccountType,
  ClearedItem.Supplier AS Supplier,
  ClearedItem.GLAccount AS GLAccount,
  ClearedItem.TaxCode AS TaxCode,
  ClearedItem.TransactionCurrency AS TransactionCurrency,
  ClearedItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  ClearedItem.PaymentMethod AS PaymentMethod,
  ClearedItem.PersonnelNumber AS PersonnelNumber,
  GLAccountExpenseType.ExpenseType AS ExpenseType,
  PaymentMethodPaymentType.PaymentType AS PaymentType,
  ClearedItem.AuthorizationGroup AS AuthorizationGroup,
  ClearedItem.SupplierAccountGroup AS SupplierAccountGroup
FROM P_HR_ClearedItem AS ClearedItem
;

Learn More