P_HR_ClearedItem

DDL: P_HR_CLEAREDITEM Type: view_entity COMPOSITE Package: GLO_FIN_IS_HR_JOPPD_API
38 Fields 1 Data Sources

GS IS FI Croatia Cleared items for JOPPD

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

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItemRawData OpenPayables from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_GLAccountLineItemRawData CompanyCode Receiver Company Code
KEY FiscalYear I_GLAccountLineItemRawData FiscalYear G/L Fiscal Year
KEY AccountingDocument I_GLAccountLineItemRawData AccountingDocument Journal Entry
KEY LedgerGLLineItem I_GLAccountLineItemRawData LedgerGLLineItem Journal Entry Item
KEY Ledger I_GLAccountLineItemRawData SourceLedger Source Ledger
AccountingDocumentItem I_GLAccountLineItemRawData AccountingDocumentItem Posting View Item
AccountingDocumentCategory I_GLAccountLineItemRawData AccountingDocumentCategory Journal Entry Category
AccountingDocumentType I_GLAccountLineItemRawData AccountingDocumentType Journal Entry Type
FinancialAccountType I_GLAccountLineItemRawData FinancialAccountType Fin. Account Type
InvoiceReference I_GLAccountLineItemRawData InvoiceReference Invoice Reference
InvoiceItemReference I_GLAccountLineItemRawData InvoiceItemReference Item
InvoiceReferenceFiscalYear I_GLAccountLineItemRawData InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
ClearingDate I_GLAccountLineItemRawData ClearingDate Clearing Date
PostingDate I_GLAccountLineItemRawData PostingDate Posting Date for GR
DocumentDate I_GLAccountLineItemRawData DocumentDate Journal Entry Date
ClearingJournalEntry I_GLAccountLineItemRawData ClearingJournalEntry Clrng doc.
ClearingJournalEntryFiscalYear I_GLAccountLineItemRawData ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
Supplier I_GLAccountLineItemRawData Supplier Supplier
FollowOnDocumentType I_GLAccountLineItemRawData FollowOnDocumentType Follow-On Document Type
SpecialGLCode I_GLAccountLineItemRawData SpecialGLCode Special G/L Ind
GLAccount I_GLAccountLineItemRawData GLAccount General Ledger
CostCenter I_GLAccountLineItemRawData CostCenter Cost Center
ProfitCenter I_GLAccountLineItemRawData ProfitCenter Profit Center
FunctionalArea I_GLAccountLineItemRawData FunctionalArea Sendr Fctl Area
BusinessArea I_GLAccountLineItemRawData BusinessArea Business Area
ControllingArea I_GLAccountLineItemRawData ControllingArea Controlling Area
Segment I_GLAccountLineItemRawData Segment Segment number
PurchasingDocument I_GLAccountLineItemRawData PurchasingDocument Purchasing Document
AssignmentReference I_GLAccountLineItemRawData AssignmentReference Assignment Reference
CompanyCodeCurrency I_GLAccountLineItemRawData CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency
TaxCode I_GLAccountLineItemRawData TaxCode Tax Code
TransactionCurrency I_GLAccountLineItemRawData TransactionCurrency Transaction Currency
AmountInTransactionCurrency I_GLAccountLineItemRawData AmountInTransactionCurrency Pt Crcy Amt
PaymentMethod OperationalAcctgDocItem PaymentMethod Pymt Meth.
PersonnelNumber
AuthorizationGroup
SupplierAccountGroup

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 P_HR_ClearedItem.
-- 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 P_HR_ClearedItem AS
SELECT
  OpenPayables.CompanyCode AS CompanyCode,
  OpenPayables.FiscalYear AS FiscalYear,
  OpenPayables.AccountingDocument AS AccountingDocument,
  OpenPayables.LedgerGLLineItem AS LedgerGLLineItem,
  OpenPayables.SourceLedger AS Ledger,
  OpenPayables.AccountingDocumentItem AS AccountingDocumentItem,
  OpenPayables.AccountingDocumentCategory AS AccountingDocumentCategory,
  OpenPayables.AccountingDocumentType AS AccountingDocumentType,
  OpenPayables.FinancialAccountType AS FinancialAccountType,
  OpenPayables.InvoiceReference AS InvoiceReference,
  OpenPayables.InvoiceItemReference AS InvoiceItemReference,
  OpenPayables.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  OpenPayables.ClearingDate AS ClearingDate,
  OpenPayables.PostingDate AS PostingDate,
  OpenPayables.DocumentDate AS DocumentDate,
  OpenPayables.ClearingJournalEntry AS ClearingJournalEntry,
  OpenPayables.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  OpenPayables.Supplier AS Supplier,
  OpenPayables.FollowOnDocumentType AS FollowOnDocumentType,
  OpenPayables.SpecialGLCode AS SpecialGLCode,
  OpenPayables.GLAccount AS GLAccount,
  OpenPayables.CostCenter AS CostCenter,
  OpenPayables.ProfitCenter AS ProfitCenter,
  OpenPayables.FunctionalArea AS FunctionalArea,
  OpenPayables.BusinessArea AS BusinessArea,
  OpenPayables.ControllingArea AS ControllingArea,
  OpenPayables.Segment AS Segment,
  OpenPayables.PurchasingDocument AS PurchasingDocument,
  OpenPayables.AssignmentReference AS AssignmentReference,
  OpenPayables.CompanyCodeCurrency AS CompanyCodeCurrency,
  -OpenPayables.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  OpenPayables.TaxCode AS TaxCode,
  OpenPayables.TransactionCurrency AS TransactionCurrency,
  OpenPayables.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  OperationalAcctgDocItem.PaymentMethod AS PaymentMethod,
  OpenPayables._Supplier._SupplierCompany[CompanyCode = companycode].PersonnelNumber AS PersonnelNumber,
  OpenPayables._GLAccountInCompanyCode.AuthorizationGroup AS AuthorizationGroup,
  OpenPayables._Supplier.SupplierAccountGroup AS SupplierAccountGroup
FROM I_GLAccountLineItemRawData AS OpenPayables
;

Learn More