What is C_EmrkdFndsItmForObjPWST in SAP S/4HANA?

C_EmrkdFndsItmForObjPWST is a consumption CDS view in SAP S/4HANA. Auxiliary Cosumption view for EF with Session Languate texts It contains 82 fields.

Which tables does C_EmrkdFndsItmForObjPWST read from?

C_EmrkdFndsItmForObjPWST reads data from: I_EarmarkedFundsDocumentItem.

What VDM layer is C_EmrkdFndsItmForObjPWST?

C_EmrkdFndsItmForObjPWST is classified as a Consumption view optimized for specific business scenarios and reporting.

C_EmrkdFndsItmForObjPWST

DDL: C_EMRKDFNDSITMFOROBJPWST SQL: CEFOBJPWT Type: view CONSUMPTION

82 Fields 1 Data Sources 1 Associations

Auxiliary Cosumption view for EF with Session Languate texts

C_EmrkdFndsItmForObjPWST is a Consumption CDS View that provides data about "Auxiliary Cosumption view for EF with Session Languate texts" in SAP S/4HANA. It reads from 1 data source (I_EarmarkedFundsDocumentItem) and exposes 82 fields with key fields EarmarkedFundsDocument, EarmarkedFundsDocumentItem. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
I_EarmarkedFundsDocumentItem	I_EarmarkedFundsDocumentItem	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	I_FundsCenter	_FundsCenterByDate	`$projection.FinancialManagementArea = _FundsCenterByDate.FinancialManagementArea and $projection.FundsCenter = _FundsCenterByDate.FundsCenter and $projection.PostingDate <= _FundsCenterByDate.ValidityEndDate and $projection.PostingDate >= _FundsCenterByDate.ValidityStartDate`

Annotations (10)

Name	Value	Level
VDM.viewType	#CONSUMPTION	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
AbapCatalog.sqlViewName	CEFOBJPWT	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
EndUserText.label	Auxiliary Cosumption view for EF with Session Languate texts	view

Fields (82)

Key	Field	Source Table	Source Field	Description
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
	FinancialManagementArea		FinancialManagementArea	FM Area
	ControllingArea		ControllingArea	Controlling Area
	PostingDate		PostingDate	Posting Date for GR
	ValidityEndDate	_FundsCenterByDate	ValidityEndDate	ValidTo
	GLAccount		GLAccount	General Ledger
	GLAccountName			GL Account Name
	CostCenter		CostCenter	Cost Center
	CostCenterName			Cost Center Name
	InternalOrder		InternalOrder	Order
	InternalOrderDescription	_InternalOrder	InternalOrderDescription	Internal Order Description
	WBSElement	_WBSElement	WBSElementExternalID	WBS Element External ID
	WBSDescription	_WBSElement	WBSDescription	WBS Element Name
	WBSElementInternalID		WBSElementInternalID	WBS Internal ID
	CostElement		CostElement	G/L Account
	CommitmentItemFinMgmtArea	_CommitmentItemByEmrkdFnds	CommitmentItemFinMgmtArea
	CommitmentItemFiscalYear	_CommitmentItemByEmrkdFnds	CommitmentItemFiscalYear	Commit. Item FY
	CommitmentItem		CommitmentItem	Commitment item
	CommitmentItemName
	CommitItemExtendedName
	FinMgmtAreaFiscalYear	_CommitmentItemByEmrkdFnds	CommitmentItemFiscalYear	Fiscal Year
	FundsCenterFinMgmtArea	_FundsCenterByEarmarkedFunds	FundsCenterFinMgmtArea
	FundsCenterKeyDate	_FundsCenterByEarmarkedFunds	FundsCenterKeyDate
	FundsCenter		FundsCenter	Funds Center
	FundsCenterName			Funds Center Name
	FundsCenterExtendedName
	Fund		Fund	Sender Fund
	FundName			Fund Name
	FundExtendedName
	FundedProgram		FundedProgram	Funded Program
	FundedProgramName
	FundedProgramExtendedName
	BudgetPeriod		BudgetPeriod	Budget Period
	BudgetPeriodName
	BudgedPeriodExtendedName
	FunctionalArea		FunctionalArea	Sendr Fctl Area
	FunctionalAreaName			Functional Area Name
	FunctionalAreaExtendedName
	GrantID		GrantID	Sender Grant
	GrantName	_GrantText	GrantName
	GrantExtendedName
	BusinessArea		BusinessArea	Business Area
	BusinessAreaName			Business Area Name
	ProjectNetwork		ProjectNetwork	Order
	ProjectNetworkDescription	_ProjectNetwork	ProjectNetworkDescription	Network Description
	Creditor		Supplier	Supplier
	Supplier		Supplier	Supplier
	SupplierName	_Supplier	SupplierName	Supplier Name
	Debtor		Customer	Sold-to Party
	Customer		Customer	Sold-to Party
	CustomerName	_Customer	CustomerName	Name of Customer
	AlternativePayee		AlternativePayee	Alternat.payee
	DocumentItemText		DocumentItemText	Text
	DueDate		DueDate	Promised For
	EmrkdFndsItmPrdcssrDocCat		EmrkdFndsItmPrdcssrDocCat	Ref.Doc.Cat.
	EmrkdFndsItmPredecessor		EmrkdFndsItmPredecessor	Ref. Document
	EmrkdFndsItmPrdcssrItem		EmrkdFndsItmPrdcssrItem	Reference Item
	EmrkdFndsItmIsCompleted		EmrkdFndsItmIsCompleted	Item Completed
	EmrkdFndsItmIsStatistical		EmrkdFndsItmIsStatistical	Statistical
	EmrkdFndsItmManualEditBlock		EmrkdFndsItmManualEditBlock	Item Block
	EmrkdFndsItmIsBlkdAgainstUsage		EmrkdFndsItmIsBlkdAgainstUsage	Item Blocked
	EmrkdFndsItmToleranceLmtInPct		EmrkdFndsItmToleranceLmtInPct	Overrun Tol.
	EmrkdFndsOverrideGlobTolerance		EmrkdFndsOverrideGlobTolerance	Override Toler.
	EmrkdFndsAcctAssgmtChangeable		EmrkdFndsAcctAssgmtChangeable	AcctAss.Change.
	TransactionCurrency		TransactionCurrency	Transaction Currency
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	EmrkdFndsAmountInTransCrcy		EmrkdFndsAmountInTransCrcy	Overall Amount (TC)
	EmrkdFndsAmountInCCCrcy		EmrkdFndsAmountInCCCrcy	Total Amount in Local Currency
	EmrkdFndsRelAmtInTransCrcy			Release Amount
	EmrkdFndsRelAmtInCCCrcy			Amt for Release
	EmrkdFndsOpenAmtInTransCrcy		EmrkdFndsOpenAmtInTransCrcy	Open Amount (TC)
	EmrkdFndsOpenAmtInCCCrcy		EmrkdFndsOpenAmtInCCCrcy	Open Amount in Local Currency
	EmrkdFndsChgdAmtInTransCrcy		EmrkdFndsChgdAmtInTransCrcy	Amount Changed
	EmrkdFndsChgdAmtInCCCrcy		EmrkdFndsChgdAmtInCCCrcy	Amount Changed
	EmrkdFndsCnsmdAmtInTransCrcy		EmrkdFndsCnsmdAmtInTransCrcy	Reduced Amount
	EmrkdFndsCnsmdAmtInCCCrcy		EmrkdFndsCnsmdAmtInCCCrcy	Reduced Amount
	EmrkdFndsOriglAmtInTransCrcy		EmrkdFndsOriglAmtInTransCrcy	Original Amount (TC)
	EmrkdFndsOriglAmtInCCCrcy		EmrkdFndsOriglAmtInCCCrcy	Original 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_EmrkdFndsItmForObjPWST.
-- 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: CEFOBJPWT

CREATE VIEW C_EmrkdFndsItmForObjPWST AS
SELECT
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  _EarmarkedFundsDocument.EarmarkedFundsDocumentCategory AS EarmarkedFundsDocumentCategory,
  _EarmarkedFundsDocument.EarmarkedFundsDocumentType AS EarmarkedFundsDocumentType,
  CompanyCode,
  FinancialManagementArea,
  ControllingArea,
  PostingDate,
  _FundsCenterByDate.ValidityEndDate AS ValidityEndDate,
  GLAccount,
  _GLAccountInCompanyCode._Text[1:Language = $session.system_language].GLAccountName AS GLAccountName,
  CostCenter,
  _CostCenter._Text[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  InternalOrder,
  _InternalOrder.InternalOrderDescription AS InternalOrderDescription,
  _WBSElement.WBSElementExternalID AS WBSElement,
  _WBSElement.WBSDescription AS WBSDescription,
  WBSElementInternalID,
  CostElement,
  _CommitmentItemByEmrkdFnds.CommitmentItemFinMgmtArea AS CommitmentItemFinMgmtArea,
  _CommitmentItemByEmrkdFnds.CommitmentItemFiscalYear AS CommitmentItemFiscalYear,
  CommitmentItem,
  _CommitmentItemByEmrkdFnds._CommitmentItemText[1:Language = $session.system_language].CommitmentItemName AS CommitmentItemName,
  cast( concat_with_space(CommitmentItem, _CommitmentItemByEmrkdFnds._CommitmentItemText[1:Language = $session.system_language].CommitmentItemName, 1) as fmis_commititemextendedname ) AS CommitItemExtendedName,
  _CommitmentItemByEmrkdFnds.CommitmentItemFiscalYear AS FinMgmtAreaFiscalYear,
  _FundsCenterByEarmarkedFunds.FundsCenterFinMgmtArea AS FundsCenterFinMgmtArea,
  _FundsCenterByEarmarkedFunds.FundsCenterKeyDate AS FundsCenterKeyDate,
  FundsCenter,
  _FundsCenterByEarmarkedFunds._FundsCenterText[1:Language = $session.system_language].FundsCenterName AS FundsCenterName,
  cast( concat_with_space(FundsCenter, _FundsCenterByEarmarkedFunds._FundsCenterText[1:Language = $session.system_language].FundsCenterName, 1) as fmis_fundscenterextendedname ) AS FundsCenterExtendedName,
  Fund,
  _Fund._Text[1:Language = $session.system_language].FundName AS FundName,
  cast( concat_with_space(Fund, _Fund._Text[1:Language = $session.system_language].FundName, 1) as fmis_fundextendedname ) AS FundExtendedName,
  FundedProgram,
  _FundedProgramText[1:Language = $session.system_language].FundedProgramName AS FundedProgramName,
  cast( concat_with_space(FundedProgram, _FundedProgramText.FundedProgramName, 1) as fmis_fundedprogextendedname ) AS FundedProgramExtendedName,
  BudgetPeriod,
  _BudgetPeriod._Text[1:Language = $session.system_language].BudgetPeriodName AS BudgetPeriodName,
  cast(concat_with_space(BudgetPeriod, _BudgetPeriod._Text[1:Language = $session.system_language].BudgetPeriodName, 1) as fmis_budperextendedname ) AS BudgedPeriodExtendedName,
  FunctionalArea,
  _FunctionalAreaText[1:Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  cast( concat_with_space(FunctionalArea, _FunctionalAreaText[1:Language = $session.system_language].FunctionalAreaName, 1) as fmis_funcareaextendedname ) AS FunctionalAreaExtendedName,
  GrantID,
  _GrantText.GrantName AS GrantName,
  cast( concat_with_space(GrantID, _GrantText.GrantName, 1) as gmis_grant_nbr_extended_name ) AS GrantExtendedName,
  BusinessArea,
  _BusinessArea._Text[1:Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  ProjectNetwork,
  _ProjectNetwork.ProjectNetworkDescription AS ProjectNetworkDescription,
  Supplier AS Creditor,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  Customer AS Debtor,
  Customer,
  _Customer.CustomerName AS CustomerName,
  AlternativePayee,
  DocumentItemText,
  DueDate,
  EmrkdFndsItmPrdcssrDocCat,
  EmrkdFndsItmPredecessor,
  EmrkdFndsItmPrdcssrItem,
  EmrkdFndsItmIsCompleted,
  EmrkdFndsItmIsStatistical,
  EmrkdFndsItmManualEditBlock,
  EmrkdFndsItmIsBlkdAgainstUsage,
  EmrkdFndsItmToleranceLmtInPct,
  EmrkdFndsOverrideGlobTolerance,
  EmrkdFndsAcctAssgmtChangeable,
  TransactionCurrency,
  CompanyCodeCurrency,
  EmrkdFndsAmountInTransCrcy,
  EmrkdFndsAmountInCCCrcy,
  cast( EmrkdFndsRelAmtInTransCrcy as fmis_efd_amtflwapprintrancrcy preserving type ) AS EmrkdFndsRelAmtInTransCrcy,
  cast( EmrkdFndsRelAmtInCCCrcy as fmis_efd_amtflwapprincccrcy preserving type ) AS EmrkdFndsRelAmtInCCCrcy,
  EmrkdFndsOpenAmtInTransCrcy,
  EmrkdFndsOpenAmtInCCCrcy,
  EmrkdFndsChgdAmtInTransCrcy,
  EmrkdFndsChgdAmtInCCCrcy,
  EmrkdFndsCnsmdAmtInTransCrcy,
  EmrkdFndsCnsmdAmtInCCCrcy,
  EmrkdFndsOriglAmtInTransCrcy,
  EmrkdFndsOriglAmtInCCCrcy
FROM I_EarmarkedFundsDocumentItem
LEFT OUTER JOIN I_FundsCenter AS _FundsCenterByDate ON FinancialManagementArea = _FundsCenterByDate.FinancialManagementArea AND FundsCenter = _FundsCenterByDate.FundsCenter AND PostingDate <= _FundsCenterByDate.ValidityEndDate AND PostingDate >= _FundsCenterByDate.ValidityStartDate  -- association [0..1]
;

Depth:

C_EmrkdFndsItmForObjPWST view

I_EarmarkedFundsDocumentItem view_entity