C_EarmarkedFundsItemForObjP

DDL: C_EARMARKEDFUNDSITEMFOROBJP SQL: CEF4OBJP Type: view CONSUMPTION
38 Fields 1 Data Sources

Auxiliary Cosumption view for Object Page

C_EarmarkedFundsItemForObjP is a Consumption CDS View that provides data about "Auxiliary Cosumption view for Object Page" in SAP S/4HANA. It reads from 1 data source (I_EarmarkedFundsDocumentItem) and exposes 38 fields with key fields EarmarkedFundsDocument, EarmarkedFundsDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_EarmarkedFundsDocumentItem I_EarmarkedFundsDocumentItem from

Annotations (11)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName CEF4OBJP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
UI.headerInfo.typeName Earmarked Funds Document view
UI.headerInfo.typeNamePlural Earmarked Funds Documents view
EndUserText.label Auxiliary Cosumption view for Object Page view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Fund
KEY EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem Document Item
EarmarkedFundsDocumentCategory _EarmarkedFundsDocument EarmarkedFundsDocumentCategory Document Category
EarmarkedFundsDocCategoryText Document Category
EarmarkedFundsDocumentType _EarmarkedFundsDocument EarmarkedFundsDocumentType Document Type
EarmarkedFundsDocTypeText Document Type Text
CompanyCode CompanyCode Company Code
FinancialManagementArea FinancialManagementArea Financial Management Area
PostingDate PostingDate Posting date
FiscalYear
CreatedByUser EmrkdFndsDocItmCreatedByUser Entered By
CreationDate EmrkdFndsDocItmCreationDate Entered On
EmrkdFndsReferenceDocumentItem EmrkdFndsReferenceDocumentItem Reference Document
LastChangedByUser EmrkdFndsDocItmLastChgdByUsr Last Changed By
LastChangeDate EmrkdFndsDocItmLastChangeDate Last Changed On
CommitmentItemFinMgmtArea _CommitmentItemByEmrkdFnds CommitmentItemFinMgmtArea
CommitmentItemFiscalYear _CommitmentItemByEmrkdFnds CommitmentItemFiscalYear Commitment Item Fiscal Year
CommitmentItem CommitmentItem Commitment Item
FundsCenterFinMgmtArea _FundsCenterByEarmarkedFunds FundsCenterFinMgmtArea
FundsCenterKeyDate _FundsCenterByEarmarkedFunds FundsCenterKeyDate Funds Center Key Date
FundsCenter FundsCenter Funds Center
Fund Fund Fund
FundedProgram FundedProgram Funded Program
BudgetPeriod BudgetPeriod Budget Period
FunctionalArea FunctionalArea Functional Area
GrantID GrantID Grant
TransactionCurrency TransactionCurrency Transaction Currency
EmrkdFndsAmountInTransCrcy EmrkdFndsAmountInTransCrcy Overall Amount (TC)
EmrkdFndsRelAmtInTransCrcy EmrkdFndsRelAmtInTransCrcy Release Amount
EmrkdFndsOpenAmtInTransCrcy EmrkdFndsOpenAmtInTransCrcy Open Amount (TC)
EmrkdFndsChgdAmtInTransCrcy EmrkdFndsChgdAmtInTransCrcy Amount Changed
EmrkdFndsCnsmdAmtInTransCrcy EmrkdFndsCnsmdAmtInTransCrcy Reduced Amount
CompanyCodeCurrency CompanyCodeCurrency Local Currency
EmrkdFndsAmountInCCCrcy EmrkdFndsAmountInCCCrcy Total Amount in Local Currency
EmrkdFndsRelAmtInCCCrcy EmrkdFndsRelAmtInCCCrcy Amt for Release
EmrkdFndsOpenAmtInCCCrcy EmrkdFndsOpenAmtInCCCrcy Open Amount in Local Currency
EmrkdFndsChgdAmtInCCCrcy EmrkdFndsChgdAmtInCCCrcy Amount Changed
EmrkdFndsCnsmdAmtInCCCrcy EmrkdFndsCnsmdAmtInCCCrcy Reduced Amount

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_EarmarkedFundsItemForObjP.
-- 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: CEF4OBJP

CREATE VIEW C_EarmarkedFundsItemForObjP AS
SELECT
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  _EarmarkedFundsDocument.EarmarkedFundsDocumentCategory AS EarmarkedFundsDocumentCategory,
  _EarmarkedFundsDocument._EarmarkedFundsDocCategory._Text[1:Language = $session.system_language].EarmarkedFundsDocCategoryText AS EarmarkedFundsDocCategoryText,
  _EarmarkedFundsDocument.EarmarkedFundsDocumentType AS EarmarkedFundsDocumentType,
  _EarmarkedFundsDocument._EarmarkedFundsDocType._Text[1:Language = $session.system_language].EarmarkedFundsDocTypeText AS EarmarkedFundsDocTypeText,
  CompanyCode,
  FinancialManagementArea,
  PostingDate,
  _EarmarkedFundsDocument._FiscalYearForCompanyCode.FiscalYear AS FiscalYear,
  EmrkdFndsDocItmCreatedByUser AS CreatedByUser,
  EmrkdFndsDocItmCreationDate AS CreationDate,
  EmrkdFndsReferenceDocumentItem,
  EmrkdFndsDocItmLastChgdByUsr AS LastChangedByUser,
  EmrkdFndsDocItmLastChangeDate AS LastChangeDate,
  _CommitmentItemByEmrkdFnds.CommitmentItemFinMgmtArea AS CommitmentItemFinMgmtArea,
  _CommitmentItemByEmrkdFnds.CommitmentItemFiscalYear AS CommitmentItemFiscalYear,
  CommitmentItem,
  _FundsCenterByEarmarkedFunds.FundsCenterFinMgmtArea AS FundsCenterFinMgmtArea,
  _FundsCenterByEarmarkedFunds.FundsCenterKeyDate AS FundsCenterKeyDate,
  FundsCenter,
  Fund,
  FundedProgram,
  BudgetPeriod,
  FunctionalArea,
  GrantID,
  TransactionCurrency,
  EmrkdFndsAmountInTransCrcy,
  EmrkdFndsRelAmtInTransCrcy,
  EmrkdFndsOpenAmtInTransCrcy,
  EmrkdFndsChgdAmtInTransCrcy,
  EmrkdFndsCnsmdAmtInTransCrcy,
  CompanyCodeCurrency,
  EmrkdFndsAmountInCCCrcy,
  EmrkdFndsRelAmtInCCCrcy,
  EmrkdFndsOpenAmtInCCCrcy,
  EmrkdFndsChgdAmtInCCCrcy,
  EmrkdFndsCnsmdAmtInCCCrcy
FROM I_EarmarkedFundsDocumentItem
;

Learn More