A_PayrollEarmarkedFundsDocItem

DDL: A_PAYROLLEARMARKEDFUNDSDOCITEM Type: view_entity CONSUMPTION Package: ODATA_PSM_S4C_EARMARKED_FUNDS
62 Fields 1 Data Sources 1 OData Services

Remote API Payroll Earmarked Funds Items

A_PayrollEarmarkedFundsDocItem is a Consumption CDS View that provides data about "Remote API Payroll Earmarked Funds Items" in SAP S/4HANA. It reads from 1 data source (R_EarmarkedFundsDocumentItemTP) and exposes 62 fields with key fields EarmarkedFundsDocument, EarmarkedFundsDocumentItem. It is exposed through 1 OData service (API_PAYROLLEARMARKEDFUNDSDOC). Part of development package ODATA_PSM_S4C_EARMARKED_FUNDS.

Data Sources (1)

SourceAliasJoin Type
R_EarmarkedFundsDocumentItemTP R_EarmarkedFundsDocumentItemTP projection

Annotations (10)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.representativeKey EarmarkedFundsDocumentItem view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.entityType.name PayrollEarmarkedFundsDocItem_Type view
EndUserText.label Remote API Payroll Earmarked Funds Items view

OData Services (1)

ServiceBindingVersionContractRelease
API_PAYROLLEARMARKEDFUNDSDOC API_PAYROLLEARMARKEDFUNDSDOC V4 C2 C1

Fields (62)

KeyFieldSource TableSource FieldDescription
KEY EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
KEY EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem Document Item
virtualPayrollSymbolicAccountp_komok40
virtualPayrollEmployeeGroupingp_momag40
virtualPayrollAdditionalModifierp_bklas
virtualTransactionTypeDeterminationktosl
CompanyCode CompanyCode Receiver Company Code
FinancialManagementArea FinancialManagementArea FM Area
ControllingArea ControllingArea Controlling Area
TransactionCurrency TransactionCurrency Transaction Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
PostingDate PostingDate Posting Date for GR
EmrkdFndsDocItmCreatedByUser EmrkdFndsDocItmCreatedByUser Entered By
EmrkdFndsDocItmCreationDate EmrkdFndsDocItmCreationDate Entered On
EmrkdFndsDocItmLastChgdByUsr EmrkdFndsDocItmLastChgdByUsr Last Changed By
EmrkdFndsDocItmLastChangeDate EmrkdFndsDocItmLastChangeDate Changed On
EmrkdFndsReferenceDocumentItem EmrkdFndsReferenceDocumentItem Reference item
GLAccount GLAccount General Ledger
CostCenter CostCenter Cost Center
WBSElementExternalID WBSElementExternalID WBS Element External ID
WBSElementInternalID WBSElementInternalID WBS Internal ID
Fund Fund Sender Fund
BudgetPeriod BudgetPeriod Budget Period
CommitmentItem CommitmentItem Commitment item
FundsCenter FundsCenter Funds Center
FundedProgram FundedProgram Funded Program
FunctionalArea FunctionalArea Sendr Fctl Area
GrantID GrantID Sender Grant
Supplier Supplier Supplier
DocumentItemText DocumentItemText Text
DueDate DueDate Promised For
ProfitCenter ProfitCenter Profit Center
PrdcssrFundsReservationDoc PrdcssrFundsReservationDoc Funds Reservation
PrdcssrFundsReservationDocItem PrdcssrFundsReservationDocItem Funds Reservation Item
PrdcssrFundsPreCmtmtDoc PrdcssrFundsPreCmtmtDoc Funds Precommitment
PrdcssrFundsPreCmtmtDocItem PrdcssrFundsPreCmtmtDocItem Funds Precommitment Item
EmrkdFndsItmPrdcssrCompleted EmrkdFndsItmPrdcssrCompleted Set "Completed"
EmrkdFndsItmCompletionDate EmrkdFndsItmCompletionDate Completed On
EmrkdFndsItmIsCompleted EmrkdFndsItmIsCompleted Item Completed
EmrkdFndsItmManualEditBlock EmrkdFndsItmManualEditBlock Item Block
EmrkdFndsItmIsBlkdAgainstUsage EmrkdFndsItmIsBlkdAgainstUsage Item Blocked
EmrkdFndsItmIsApproved EmrkdFndsItmIsApproved Item Approved
EmrkdFndsAcctAssgmtChangeable EmrkdFndsAcctAssgmtChangeable AcctAss.Change.
EmrkdFndsAmountInTransCrcy EmrkdFndsAmountInTransCrcy Total Amount
EmrkdFndsOpenAmtInTransCrcy EmrkdFndsOpenAmtInTransCrcy Open Amount
EmrkdFndsCnsmdAmtInTransCrcy EmrkdFndsCnsmdAmtInTransCrcy Reduced Amount
EmrkdFndsAmountInCCCrcy EmrkdFndsAmountInCCCrcy Total Amount in Local Currency
EmrkdFndsOpenAmtInCCCrcy EmrkdFndsOpenAmtInCCCrcy Open Amount in Local Currency
EmrkdFndsCnsmdAmtInCCCrcy EmrkdFndsCnsmdAmtInCCCrcy Reduced Amount
_CostCenter _CostCenter
_CurrentCostCenter _CurrentCostCenter
_CurrentProfitCenter _CurrentProfitCenter
_WBSElement _WBSElement
_GLAccountInCompanyCode _GLAccountInCompanyCode
_Fund _Fund
_BudgetPeriod _BudgetPeriod
_FundsMgmtFunctionalArea _FundsMgmtFunctionalArea
_FunctionalArea _FunctionalArea
_Grant _Grant
_CommitmentItemByEmrkdFnds _CommitmentItemByEmrkdFnds
_FundsCenterByEarmarkedFunds _FundsCenterByEarmarkedFunds
_FundedProgram _FundedProgram

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_PayrollEarmarkedFundsDocItem.
-- 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_PayrollEarmarkedFundsDocItem AS
SELECT
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  virtual PayrollSymbolicAccount : p_komok40 AS virtualPayrollSymbolicAccountp_komok40,
  virtual PayrollEmployeeGrouping : p_momag40 AS virtualPayrollEmployeeGroupingp_momag40,
  virtual PayrollAdditionalModifier : p_bklas AS virtualPayrollAdditionalModifierp_bklas,
  virtual TransactionTypeDetermination : ktosl AS virtualTransactionTypeDeterminationktosl,
  CompanyCode,
  FinancialManagementArea,
  ControllingArea,
  TransactionCurrency,
  CompanyCodeCurrency,
  PostingDate,
  EmrkdFndsDocItmCreatedByUser,
  EmrkdFndsDocItmCreationDate,
  EmrkdFndsDocItmLastChgdByUsr,
  EmrkdFndsDocItmLastChangeDate,
  EmrkdFndsReferenceDocumentItem,
  GLAccount,
  CostCenter,
  WBSElementExternalID,
  WBSElementInternalID,
  Fund,
  BudgetPeriod,
  CommitmentItem,
  FundsCenter,
  FundedProgram,
  FunctionalArea,
  GrantID,
  Supplier,
  DocumentItemText,
  DueDate,
  ProfitCenter,
  PrdcssrFundsReservationDoc,
  PrdcssrFundsReservationDocItem,
  PrdcssrFundsPreCmtmtDoc,
  PrdcssrFundsPreCmtmtDocItem,
  EmrkdFndsItmPrdcssrCompleted,
  EmrkdFndsItmCompletionDate,
  EmrkdFndsItmIsCompleted,
  EmrkdFndsItmManualEditBlock,
  EmrkdFndsItmIsBlkdAgainstUsage,
  EmrkdFndsItmIsApproved,
  EmrkdFndsAcctAssgmtChangeable,
  EmrkdFndsAmountInTransCrcy,
  EmrkdFndsOpenAmtInTransCrcy,
  EmrkdFndsCnsmdAmtInTransCrcy,
  EmrkdFndsAmountInCCCrcy,
  EmrkdFndsOpenAmtInCCCrcy,
  EmrkdFndsCnsmdAmtInCCCrcy
FROM R_EarmarkedFundsDocumentItemTP
;

Learn More