C_EmrkdFndsItmForObjPWST

Auxiliary Cosumption view for EF with Session Languate texts | view: CEFOBJPWT | Extraction: Not supported | Component: Funds Management-Specific Postings

Tables used: KBLK, KBLP, AFKO, FMIOI, FMBUDGETPD, FMBUDGETPDT, TGSB, TGSBT, FMCI, FMHICI, FMCIT, T001, TKA02, CSKS, CSKT, KNA1, FM01, TFKBT, FMFINCODE, FMMEASURET, FMFCTR, FMFCTRT, FMFINT, SKB1, GMGRTEXTS, AUFK, LFA1, PRPS, SKAT, T004, FINSC_FISC_DATE

🔑 Keys (2)
💰 Amounts (12)
∑ Quantities
📅 Dates (3)
☰ Categorical (7)
Other (37)
🔗 Relations (18)

Column Name	Description
EarmarkedFundsDocument FK	Document Number for Earmarked Funds
EarmarkedFundsDocumentItem	Document Item for Earmarked Funds

Column Name	Description
💲 Transaction Currency (TransactionCurrency):
EmrkdFndsAmountInTransCrcy	Total Reserved Amount in Transaction Currency
EmrkdFndsRelAmtInTransCrcy	Amount Following Approval in Transaction Currency
EmrkdFndsOpenAmtInTransCrcy	Open Amount in Transaction Currency
EmrkdFndsChgdAmtInTransCrcy	Amount Change to Be Approved (Transaction Currency)
EmrkdFndsCnsmdAmtInTransCrcy	Funds Reservation Amount Reduced
EmrkdFndsOriglAmtInTransCrcy	Original Amount in Transaction Currency
💲 Local currency key (CompanyCodeCurrency):
EmrkdFndsAmountInCCCrcy	Total Reserved Amount in Local Currency
EmrkdFndsRelAmtInCCCrcy	Amount Following Approval in Local Currency
EmrkdFndsOpenAmtInCCCrcy	Open Amount in Local Currency
EmrkdFndsChgdAmtInCCCrcy	Amount Change to Be Approved (Local Currency)
EmrkdFndsCnsmdAmtInCCCrcy	Funds Reservation Amount Reduced
EmrkdFndsOriglAmtInCCCrcy	Original Amount in Local Currency

Column Name	Description

Column Name	Description
PostingDate	Posting Date in the Document
ValidityEndDate	Funds Center Validity End Date
DueDate	Costs Due On

Column Name	Description
EarmarkedFundsDocumentCategory	Document Category of an Earmarked Funds Document	Show values
EmrkdFndsItmPrdcssrDocCat	Reference Doc.Category: Funds Precommitment or Reservation	Show values
EmrkdFndsItmIsCompleted	Completion Indicator for Earmarked Funds Document Item	Show values
EmrkdFndsItmIsStatistical	Funds Management Statistical Indicator	Show values
EmrkdFndsItmIsBlkdAgainstUsage	Blocking Indicator (Item)	Show values
EmrkdFndsOverrideGlobTolerance	Indicator: Override Global (Percentage-Based) Tolerance	Show values
EmrkdFndsAcctAssgmtChangeable	Account Assignment Can Be Changed in Follow-On Document	Show values

Column Name	Description	Domain name
EarmarkedFundsDocumentType	Earmarked Fund Document Type	FMRE_BLART
GLAccountName	G/L Account Name
CostCenterName	Cost Center Name
InternalOrderDescription	Internal Order Description
WBSElement	Work Breakdown Structure Element (WBS Element) Edited	PS_POSID_EDIT
WBSDescription	WBS Element Name	TEXT40
CommitmentItemFiscalYear	null
CommitmentItem	Commitment Item	FM_FIPEX
CommitmentItemName	Commitment Item Name	TEXT20
CommitItemExtendedName	Commitment Item Name extended with ID
FinMgmtAreaFiscalYear	null
FundsCenterName	Funds Center Name
FundsCenterExtendedName	Funds Center Name extended with ID
FundName	Fund Name
FundExtendedName	Fund Name extended with ID
FundedProgram	Funded Program	FM_MEASURE
FundedProgramName	Funded Program Name	TEXT20
FundedProgramExtendedName	Funded Program Name extended with ID
BudgetPeriod	Budget Period	FM_BUDGET_PERIOD
BudgetPeriodName	Budget Period Name	NAME
BudgedPeriodExtendedName	Budget Period Name extended with ID
FunctionalAreaName	Name of the Functional Area
FunctionalAreaExtendedName	Functional Area Name extended with ID
GrantID	Grant	GM_GRANT_NBR
GrantName	Short Description of the Grant
GrantExtendedName	Grant Name extended with ID
BusinessArea	Business Area	GSBER
BusinessAreaName	Business Area Description
ProjectNetwork	Network Number for Account Assignment	AUFNR
ProjectNetworkDescription	Description
SupplierName	Name of Supplier	TEXT80
CustomerName	Name of Customer	TEXT80
AlternativePayee	Account Number of the Alternative Payee	LIFNR
DocumentItemText	Item Text	TEXT50
EmrkdFndsItmPredecessor	Reference Document Number: Reservation/Funds Precommitment	KBLNR
EmrkdFndsItmPrdcssrItem	Item in Reference Document	KBLPOS
EmrkdFndsItmToleranceLmtInPct	Tolerance Limit for Overrun	PRZ31

Master Data Relations	Join Conditions
Company code Company Code Client	`C_EMRKDFNDSITMFOROBJPWST.COMPANYCODE == T001.BUKRS` `C_EMRKDFNDSITMFOROBJPWST.MANDT == T001.MANDT`
Controlling area Controlling Area Client	`C_EMRKDFNDSITMFOROBJPWST.CONTROLLINGAREA == TKA01.KOKRS` `C_EMRKDFNDSITMFOROBJPWST.MANDT == TKA01.MANDT`
Cost Center Controlling Area Cost Center Costs Due On Client	`C_EMRKDFNDSITMFOROBJPWST.CONTROLLINGAREA == CSKS.KOKRS` `C_EMRKDFNDSITMFOROBJPWST.COSTCENTER == CSKS.KOSTL` `C_EMRKDFNDSITMFOROBJPWST.DUEDATE == CSKS.DATBI` `C_EMRKDFNDSITMFOROBJPWST.MANDT == CSKS.MANDT`
Cost element Cost Element ? Client	`C_EMRKDFNDSITMFOROBJPWST.COSTELEMENT == CSKA.KSTAR` `C_EMRKDFNDSITMFOROBJPWST.[column in domain "KTOPL"] == CSKA.KTOPL` `C_EMRKDFNDSITMFOROBJPWST.MANDT == CSKA.MANDT`
Vendor number Account Number of Supplier Account Number of Supplier Client	`C_EMRKDFNDSITMFOROBJPWST.CREDITOR == LFA1.LIFNR` `C_EMRKDFNDSITMFOROBJPWST.SUPPLIER == LFA1.LIFNR` `C_EMRKDFNDSITMFOROBJPWST.MANDT == LFA1.MANDT`
Customer Number Customer Number Customer Number Client	`C_EMRKDFNDSITMFOROBJPWST.CUSTOMER == KNA1.KUNNR` `C_EMRKDFNDSITMFOROBJPWST.DEBTOR == KNA1.KUNNR` `C_EMRKDFNDSITMFOROBJPWST.MANDT == KNA1.MANDT`
Customer Number Customer Number Customer Number Client	`C_EMRKDFNDSITMFOROBJPWST.CUSTOMER == KNA1.KUNNR` `C_EMRKDFNDSITMFOROBJPWST.DEBTOR == KNA1.KUNNR` `C_EMRKDFNDSITMFOROBJPWST.MANDT == KNA1.MANDT`
Earmarked Funds Item Block Earmarked Funds Item Block Client	`C_EMRKDFNDSITMFOROBJPWST.EMRKDFNDSITMMANUALEDITBLOCK == FMRESLOCKS.LOCKTYPE` `C_EMRKDFNDSITMFOROBJPWST.MANDT == FMRESLOCKS.MANDT`
Financial Management Area Financial Management Area Client	`C_EMRKDFNDSITMFOROBJPWST.FINANCIALMANAGEMENTAREA == FM01.FIKRS` `C_EMRKDFNDSITMFOROBJPWST.MANDT == FM01.MANDT`
Functional Area Functional Area Client	`C_EMRKDFNDSITMFOROBJPWST.FUNCTIONALAREA == TFKB.FKBER` `C_EMRKDFNDSITMFOROBJPWST.MANDT == TFKB.MANDT`
Fund Financial Management Area Fund Client	`C_EMRKDFNDSITMFOROBJPWST.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS` `C_EMRKDFNDSITMFOROBJPWST.FUND == FMFINCODE.FINCODE` `C_EMRKDFNDSITMFOROBJPWST.MANDT == FMFINCODE.MANDT`
Funds Center Financial Management Area ? Funds Center Client	`C_EMRKDFNDSITMFOROBJPWST.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS` `C_EMRKDFNDSITMFOROBJPWST.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS` `C_EMRKDFNDSITMFOROBJPWST.FUNDSCENTER == FMFCTR.FICTR` `C_EMRKDFNDSITMFOROBJPWST.MANDT == FMFCTR.MANDT`
G/L Account Number ? Client G/L Account Number	`C_EMRKDFNDSITMFOROBJPWST.[column in domain "KTOPL"] == SKA1.KTOPL` `C_EMRKDFNDSITMFOROBJPWST.MANDT == SKA1.MANDT` `C_EMRKDFNDSITMFOROBJPWST.GLACCOUNT == SKA1.SAKNR`
Order number Order Number Client	`C_EMRKDFNDSITMFOROBJPWST.INTERNALORDER == AUFK.AUFNR` `C_EMRKDFNDSITMFOROBJPWST.MANDT == AUFK.MANDT`
Vendor number Account Number of Supplier Account Number of Supplier Client	`C_EMRKDFNDSITMFOROBJPWST.CREDITOR == LFA1.LIFNR` `C_EMRKDFNDSITMFOROBJPWST.SUPPLIER == LFA1.LIFNR` `C_EMRKDFNDSITMFOROBJPWST.MANDT == LFA1.MANDT`
Transaction currency = document currency Client Transaction Currency	`C_EMRKDFNDSITMFOROBJPWST.MANDT == TCURC.MANDT` `C_EMRKDFNDSITMFOROBJPWST.TRANSACTIONCURRENCY == TCURC.WAERS`