I_PubSecCmtmtAgingLabel

CDS view to dynamically add the labels | view: IPSCMTAGINGLABEL | Extraction: Not supported | Component: Information system
Tables used: SCAL_TT_DATE, ACDOCA, T004, T001, TKA02, FMFINCODE, SKA1, SKB1, PROJ, PSM_D_BDGTCNSTY, T001, PRPS, PSM_D_GLACCTX, FINSC_LEDGER_REP
Column Name Description
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
PubSecOpnCmtmtAmtInTransCrcy Total Open Commitment Amount in Transaction Currency
PubSecOpnCmtmtAmtInCoCodeCrcy Total Open Commitment Amount in Company Code Currency
PubSecOpnCmtmtAmtInGlobCrcy Total Open Commitment Amount in Global Currency
PubSecOpnCmtmtAmtInGlobCrcy1 Open Commitment Amount in Global Currency for Time Slice A
PubSecOpnCmtmtAmtInGlobCrcy2 Open Commitment Amount in Global Currency for Time Slice B
PubSecOpnCmtmtAmtInGlobCrcy3 Open Commitment Amount in Global Currency for Time Slice C
PubSecOpnCmtmtAmtInGlobCrcy4 Open Commitment Amount in Global Currency for Time Slice D
PubSecOpnCmtmtAmtInGlobCrcy5 Open Commitment Amount in Global Currency for Time Slice E
Column Name Description
Column Name Description
PubSecOpenCmtmtAgingDate Open Commitment Date
Column Name Description
PubSecBdgtAcctRevnExpnCode Expense or Revenue on Budget Account Show values
ReferencePurchaseOrderCategory Category of Reference Purchase Order Show values
Column Name Description Domain name
GrantID Grant GM_GRANT_NBR
SponsoredClass Sponsored Class GM_SPONSORED_CLASS
SponsoredProgram Sponsored Program GM_SPONSORED_PROG
PubSecOpnCmtmtDays Total Number of Days Commitment Is Open INT4
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
SourceReferenceDocumentCntxt Source Reference Document Context AWORG
SourceReferenceDocSubitem Source Reference Document Subitem NUMC6
AccountAssignmentNumber Account Assignment Number NUM02
PubSecOpnCmtmtTme1 Time Slice A for Open Commitment INT4
PubSecOpnCmtmtTme2 Time Slice B for Open Commitment INT4
PubSecOpnCmtmtTme3 Time Slice C for Open Commitment INT4
PubSecOpnCmtmtTme4 Time Slice D for Open Commitment INT4
PubSecOpnCmtmtTme5 Time Slice E for Open Commitment INT4
PurchaseOrder Purchase Order Number EBELN
PurchaseRequisition Purchase requisition number BANFN
EarmarkedFundsDocument Document Number for Earmarked Funds KBLNR
PubSecOpnCmtmtTmeIntvl Shows Time Interval to Which Grouped Open Commitments Belong CHAR20
Master Data Relations Join Conditions
Budget Period
  • Financial Management Area
  • Fund
  • Budget Period
  • Client
  • I_PUBSECCMTMTAGINGLABEL.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • I_PUBSECCMTMTAGINGLABEL.FUND == FMFUNDBPD.FINCODE
  • I_PUBSECCMTMTAGINGLABEL.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • I_PUBSECCMTMTAGINGLABEL.MANDT == FMFUNDBPD.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_PUBSECCMTMTAGINGLABEL.CHARTOFACCOUNTS == T004.KTOPL
  • I_PUBSECCMTMTAGINGLABEL.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_PUBSECCMTMTAGINGLABEL.COMPANYCODE == T001.BUKRS
  • I_PUBSECCMTMTAGINGLABEL.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • I_PUBSECCMTMTAGINGLABEL.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PUBSECCMTMTAGINGLABEL.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_PUBSECCMTMTAGINGLABEL.CONTROLLINGAREA == TKA01.KOKRS
  • I_PUBSECCMTMTAGINGLABEL.MANDT == TKA01.MANDT
Cost Center
  • Cost Center
  • ?
  • Controlling Area
  • Client
  • I_PUBSECCMTMTAGINGLABEL.COSTCENTER == CSKS.KOSTL
  • I_PUBSECCMTMTAGINGLABEL.[column in domain "DATBI"] == CSKS.DATBI
  • I_PUBSECCMTMTAGINGLABEL.CONTROLLINGAREA == CSKS.KOKRS
  • I_PUBSECCMTMTAGINGLABEL.MANDT == CSKS.MANDT
Financial Management Area
  • Financial Management Area
  • Client
  • I_PUBSECCMTMTAGINGLABEL.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • I_PUBSECCMTMTAGINGLABEL.MANDT == FM01.MANDT
Functional Area
  • Functional Area
  • Client
  • I_PUBSECCMTMTAGINGLABEL.FUNCTIONALAREA == TFKB.FKBER
  • I_PUBSECCMTMTAGINGLABEL.MANDT == TFKB.MANDT
Fund
  • Financial Management Area
  • Fund
  • Client
  • I_PUBSECCMTMTAGINGLABEL.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_PUBSECCMTMTAGINGLABEL.FUND == FMFINCODE.FINCODE
  • I_PUBSECCMTMTAGINGLABEL.MANDT == FMFINCODE.MANDT
FM Fund Type
  • Client
  • Financial Management Area
  • FM Fund Type
  • I_PUBSECCMTMTAGINGLABEL.MANDT == FMFUNDTYPE.MANDT
  • I_PUBSECCMTMTAGINGLABEL.FINANCIALMANAGEMENTAREA == FMFUNDTYPE.FM_AREA
  • I_PUBSECCMTMTAGINGLABEL.FUNDTYPE == FMFUNDTYPE.FUND_TYPE
G/L Account
  • G/L Account
  • Company Code
  • Client
  • I_PUBSECCMTMTAGINGLABEL.GLACCOUNT == SKB1.SAKNR
  • I_PUBSECCMTMTAGINGLABEL.COMPANYCODE == SKB1.BUKRS
  • I_PUBSECCMTMTAGINGLABEL.MANDT == SKB1.MANDT
Global Currency
  • Client
  • Global Currency
  • I_PUBSECCMTMTAGINGLABEL.MANDT == TCURC.MANDT
  • I_PUBSECCMTMTAGINGLABEL.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Profit Center
  • Profit Center
  • ?
  • Controlling Area
  • Client
  • I_PUBSECCMTMTAGINGLABEL.PROFITCENTER == CEPC.PRCTR
  • I_PUBSECCMTMTAGINGLABEL.[column in domain "DATBI"] == CEPC.DATBI
  • I_PUBSECCMTMTAGINGLABEL.CONTROLLINGAREA == CEPC.KOKRS
  • I_PUBSECCMTMTAGINGLABEL.MANDT == CEPC.MANDT
Budget Account
  • Budget Account
  • Chart of Accounts
  • Client
  • I_PUBSECCMTMTAGINGLABEL.PUBSECBUDGETACCOUNT == SKA1.SAKNR
  • I_PUBSECCMTMTAGINGLABEL.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_PUBSECCMTMTAGINGLABEL.MANDT == SKA1.MANDT
Budget Account Company Code
  • Budget Account Company Code
  • Client
  • I_PUBSECCMTMTAGINGLABEL.PUBSECBUDGETACCOUNTCOCODE == T001.BUKRS
  • I_PUBSECCMTMTAGINGLABEL.MANDT == T001.MANDT
Budget Consumption Type
  • Budget Consumption Type
  • Client
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • I_PUBSECCMTMTAGINGLABEL.SEGMENT == FAGL_SEGM.SEGMENT
  • I_PUBSECCMTMTAGINGLABEL.MANDT == FAGL_SEGM.MANDT
Source Logical System I_PUBSECCMTMTAGINGLABEL.SOURCELOGICALSYSTEM == TBDLS.LOGSYS
Source Reference Document Type I_PUBSECCMTMTAGINGLABEL.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Transaction Currency
  • Transaction Currency
  • Client
  • I_PUBSECCMTMTAGINGLABEL.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_PUBSECCMTMTAGINGLABEL.MANDT == TCURC.MANDT