C_PrdcssrEmrkdFndsItemVH

DDL: C_PRDCSSREMRKDFNDSITEMVH SQL: CPREDEFDITMVH Type: view CONSUMPTION Package: PSM_S4C_EARMARKED_FUNDS
57 Fields 1 Data Sources 2 OData Services

Predec. Earm. Funds Doc. Item Value Help

C_PrdcssrEmrkdFndsItemVH is a Consumption CDS View that provides data about "Predec. Earm. Funds Doc. Item Value Help" in SAP S/4HANA. It reads from 1 data source (I_EmrkdFndsDocumentItemStdVH) and exposes 57 fields with key fields EarmarkedFundsDocument, EarmarkedFundsDocumentItem. It is exposed through 2 OData services (ASQL_F4657, ASQL_F7334). Part of development package PSM_S4C_EARMARKED_FUNDS.

Data Sources (1)

SourceAliasJoin Type
I_EmrkdFndsDocumentItemStdVH I_EmrkdFndsDocumentItemStdVH from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CPREDEFDITMVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey EarmarkedFundsDocumentItem view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
Search.searchable true view
EndUserText.label Predec. Earm. Funds Doc. Item Value Help view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F4657 ASQL_F4657 C2 NOT_RELEASED
ASQL_F7334 ASQL_F7334 C2 NOT_RELEASED

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
KEY EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem Document Item
EarmarkedFundsDocumentCategory _EarmarkedFundsDocument EarmarkedFundsDocumentCategory Document Category
EarmarkedFundsDocumentType _EarmarkedFundsDocument EarmarkedFundsDocumentType Document Type
CompanyCode CompanyCode Receiver Company Code
TransactionCurrency TransactionCurrency Transaction Currency
EarmarkedFundsDocEntryStatus _EarmarkedFundsDocument EarmarkedFundsDocEntryStatus Status
DocumentDate _EarmarkedFundsDocument DocumentDate Journal Entry Date
PostingDate _EarmarkedFundsDocument PostingDate Posting Date for GR
EmrkdFndsDocItmCreatedByUser EmrkdFndsDocItmCreatedByUser Entered By
EmrkdFndsDocItmCreationDate EmrkdFndsDocItmCreationDate Entered On
EmrkdFndsDocItmLastChgdByUsr EmrkdFndsDocItmLastChgdByUsr Last Changed By
EmrkdFndsDocItmLastChangeDate EmrkdFndsDocItmLastChangeDate Changed On
DocumentItemText DocumentItemText Text
DueDate DueDate Promised For
ControllingArea ControllingArea Controlling Area
GLAccount GLAccount General Ledger
CostCenter CostCenter Cost Center
InternalOrder InternalOrder Order
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementExternalID _WBSElementBasicData WBSElementExternalID WBS Element External ID
WBSDescription _WBSElementBasicData WBSDescription WBS Element Name
ProjectNetwork ProjectNetwork Order
CostElement CostElement G/L Account
FinancialManagementArea FinancialManagementArea FM Area
CommitmentItem CommitmentItem Commitment item
FundsCenter FundsCenter Funds Center
Fund Fund Sender Fund
FundedProgram FundedProgram Funded Program
BudgetPeriod BudgetPeriod Budget Period
FunctionalArea FunctionalArea Sendr Fctl Area
GrantID GrantID Sender Grant
BusinessArea BusinessArea Business Area
Product Product Product Sold
Supplier Supplier Supplier
EmrkdFndsOpenAmtInTransCrcy EmrkdFndsOpenAmtInTransCrcy Open Amount
_EarmarkedFundsDocument _EarmarkedFundsDocument
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_FinancialManagementArea _FinancialManagementArea
_CostCenter _CostCenter
_CurrentCostCenter _CurrentCostCenter
_InternalOrder _InternalOrder
_WBSElementBasicData _WBSElementBasicData
_GLAccountInCompanyCode _GLAccountInCompanyCode
_CostElement _CostElement
_ProjectNetwork _ProjectNetwork
_CommitmentItemByEmrkdFnds _CommitmentItemByEmrkdFnds
_Fund _Fund
_CurrentFundsCenter _CurrentFundsCenter
_FundsCenterByEarmarkedFunds _FundsCenterByEarmarkedFunds
_FundedProgram _FundedProgram
_BudgetPeriod _BudgetPeriod
_FundsMgmtFunctionalArea _FundsMgmtFunctionalArea
_FunctionalArea _FunctionalArea
_Grant _Grant
_BusinessArea _BusinessArea

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_PrdcssrEmrkdFndsItemVH.
-- 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.
-- SQL view name: CPREDEFDITMVH

CREATE VIEW C_PrdcssrEmrkdFndsItemVH AS
SELECT
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  _EarmarkedFundsDocument.EarmarkedFundsDocumentCategory AS EarmarkedFundsDocumentCategory,
  _EarmarkedFundsDocument.EarmarkedFundsDocumentType AS EarmarkedFundsDocumentType,
  CompanyCode,
  TransactionCurrency,
  _EarmarkedFundsDocument.EarmarkedFundsDocEntryStatus AS EarmarkedFundsDocEntryStatus,
  _EarmarkedFundsDocument.DocumentDate AS DocumentDate,
  _EarmarkedFundsDocument.PostingDate AS PostingDate,
  EmrkdFndsDocItmCreatedByUser,
  EmrkdFndsDocItmCreationDate,
  EmrkdFndsDocItmLastChgdByUsr,
  EmrkdFndsDocItmLastChangeDate,
  DocumentItemText,
  DueDate,
  ControllingArea,
  GLAccount,
  CostCenter,
  InternalOrder,
  WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  ProjectNetwork,
  CostElement,
  FinancialManagementArea,
  CommitmentItem,
  FundsCenter,
  Fund,
  FundedProgram,
  BudgetPeriod,
  FunctionalArea,
  GrantID,
  BusinessArea,
  Product,
  Supplier,
  EmrkdFndsOpenAmtInTransCrcy
FROM I_EmrkdFndsDocumentItemStdVH
;

Learn More