A_HR_EmployeeExpense

DDL: A_HR_EMPLOYEEEXPENSE Type: view_entity CONSUMPTION Package: GLO_FIN_IS_HR_JOPPD_API
21 Fields 1 Data Sources 1 OData Services

GS FI IS Croatia JOPPD Employee Expenses

A_HR_EmployeeExpense is a Consumption CDS View that provides data about "GS FI IS Croatia JOPPD Employee Expenses" in SAP S/4HANA. It reads from 1 data source (R_HR_EmployeeExpenseTP) and exposes 21 fields with key fields CompanyCode, FiscalYear, Ledger, AccountingDocument, LedgerGLLineItem. It is exposed through 1 OData service (API_HR_EMPLOYEEEXPENSE). Part of development package GLO_FIN_IS_HR_JOPPD_API.

Data Sources (1)

SourceAliasJoin Type
R_HR_EmployeeExpenseTP R_HR_EmployeeExpenseTP projection

Annotations (11)

NameValueLevelField
EndUserText.label GS FI IS Croatia JOPPD Employee Expenses view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
OData.entitySet.name HR_EmployeeExpense view
OData.entityType.name HR_EmployeeExpense_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_HR_EMPLOYEEEXPENSE API_HR_EMPLOYEEEXPENSE V4 C2 C1

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY Ledger Ledger Ledger
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
AccountingDocumentItem AccountingDocumentItem Posting View Item
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
AccountingDocumentType AccountingDocumentType Journal Entry Type
ClearingDate ClearingDate Clearing Date
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
NetDueDate NetDueDate Net Due Date
FinancialAccountType FinancialAccountType Fin. Account Type
Supplier Supplier Supplier
GLAccount GLAccount General Ledger
PaymentMethod PaymentMethod Pymt Meth.
PersonnelNumber PersonnelNumber Personnel No.
ExpenseType ExpenseType
PaymentType PaymentType
AuthorizationGroup AuthorizationGroup AuthorizGroup
SupplierAccountGroup 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 A_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 A_HR_EmployeeExpense AS
SELECT
  CompanyCode,
  FiscalYear,
  Ledger,
  AccountingDocument,
  LedgerGLLineItem,
  AccountingDocumentItem,
  AccountingDocumentCategory,
  AccountingDocumentType,
  ClearingDate,
  PostingDate,
  DocumentDate,
  NetDueDate,
  FinancialAccountType,
  Supplier,
  GLAccount,
  PaymentMethod,
  PersonnelNumber,
  ExpenseType,
  PaymentType,
  AuthorizationGroup,
  SupplierAccountGroup
FROM R_HR_EmployeeExpenseTP
;

Learn More