I_PubSecBdgtLineItemCube

Budget Line Items - Cube | view: IPSMS4CBDLNANC | TRAN | Extraction: Not supported | Component: Information system
Tables used: ACDOCP, T001, TKA02, FMFINCODE, SKB1, PROJ, T001, FCOMC_CATEGORY, PRPS, PSM_D_GLACCTX, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
FinancialPlanningReqTransSqnc Financial Planning Request Transaction Sequence Number
FinancialPlanningDataPacket Financial Planning Data Packet Number
FinancialPlanningEntryItem Financial Planning Entry Item
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
PubSecExpnBdgtAmtInTransCrcy Budget Expense Amount in Transaction Currency
PubSecRevnBdgtAmtInTransCrcy Budget Revenue Amount in Transaction Currency
PlanPriceInTransactionCurrency Price in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
PubSecExpnBdgtAmtInCoCodeCrcy Budget Expense Amount in Company Code Currency
PubSecRevnBdgtAmtInCoCodeCrcy Budget Revenue Amount in Company Code Currency
PlanPriceInCompanyCodeCurrency Price in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
FixedAmountInGlobalCrcy Fixed Amount in Global Currency
PubSecExpnBdgtAmtInGlobalCrcy Budget Expense Amount in Global Currency
PubSecRevnBdgtAmtInGlobalCrcy Budget Revenue Amount in Global Currency
PlanPriceInGlobalCurrency Price in Global Currency
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency Amount in CO Object Currency
Column Name Description
📏 Unit of Measure (CostSourceUnit):
ValuationQuantity Valuation quantity
Column Name Description
PostingDate Posting Date
Column Name Description
IsLotSizeIndependent Is Lot Size Independent Show values
ControllingDebitCreditCode CO Debit/Credit Indicator Show values
PubSecBdgtAcctRevnExpnCode Expense or Revenue on Budget Account Show values
Column Name Description Domain name
FiscalYear Fiscal Year GJAHR
LedgerFiscalYear Ledger Fiscal Year GJAHR
ProjectExternalID Project External ID FIS_PROJECTEXT_NO_CONV
PartnerProjectExternalID Partner Project External ID FIS_PROJECTEXT_NO_CONV
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
PartnerWBSElementInternalID Partner WBS Element Internal ID FIS_WBSINT_NO_CONV
PartnerWBSElementExternalID Partner WBS Element External ID FIS_WBSEXT_NO_CONV
WorkPackage Plan Item /CPD/PLAN_ITEM_ID
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
ReferenceDocumentType Reference Document Type AWTYP
ReferenceDocumentContext Reference Document Context AWORG
ReferenceDocument Reference document number AWREF
FiscalYearVariant Fiscal Year Variant PERIV
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
PersonnelNumber Personnel Number PERNR
CustomerSupplierCorporateGroup Corporate Group of Customer or Supplier KONZS
PubSecBudgetAccount Budget Account SAKNR
PubSecBudgetAccountCoCode Budget Account Company Code BUKRS
BudgetDocument Budget Document Number AWREF
OrderOperation Operation/Activity Number VORNR
OrderItem Order item number CO_POSNR
GLAccountAuthorizationGroup Authorization Group BRGRU
CustomerBasicAuthorizationGrp Authorization Group BRGRU
OrderType Order Type AUFART
SalesOrderType Sales Document Type AUART
Master Data Relations Join Conditions
Transaction Type Category I_PUBSECBDGTLINEITEMCUBE.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Billing Type
  • Client
  • Billing Type
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == TVFK.MANDT
  • I_PUBSECBDGTLINEITEMCUBE.BILLINGDOCUMENTTYPE == TVFK.FKART
Bill-to Party
  • Client
  • Bill-to Party
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == KNA1.MANDT
  • I_PUBSECBDGTLINEITEMCUBE.BILLTOPARTY == KNA1.KUNNR
Budget Type (Subcategory)
  • Budget Type (Subcategory)
  • Client
Budget Period
  • Budget Period
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.BUDGETPERIOD == FMBUDGETPD.BUDGET_PD
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == FMBUDGETPD.MANDT
Budget Process Type
  • Budget Process Type
  • Client
Business Area
  • Business Area
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.BUSINESSAREA == TGSB.GSBER
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == TGSB.MANDT
Business Transaction Category
  • Business Transaction Category
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.BUSINESSTRANSACTIONTYPE == FINSC_BTTYPE.BTTYPE
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == FINSC_BTTYPE.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == T004.MANDT
  • I_PUBSECBDGTLINEITEMCUBE.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.COMPANYCODE == T001.BUKRS
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • I_PUBSECBDGTLINEITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_PUBSECBDGTLINEITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == CSKS.MANDT
  • I_PUBSECBDGTLINEITEMCUBE.COSTCENTER == CSKS.KOSTL
Customer Number
  • Client
  • Customer Number
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == KNA1.MANDT
  • I_PUBSECBDGTLINEITEMCUBE.CUSTOMER == KNA1.KUNNR
Customer Group
  • Client
  • Customer Group
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == T151.MANDT
  • I_PUBSECBDGTLINEITEMCUBE.CUSTOMERGROUP == T151.KDGRP
Country/Region of Customer or Supplier
  • Client
  • Country/Region of Customer or Supplier
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == T005.MANDT
  • I_PUBSECBDGTLINEITEMCUBE.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
Industry Key
  • Industry Key
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == T016.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == TVTW.MANDT
  • I_PUBSECBDGTLINEITEMCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Financial Management Area
  • Financial Management Area
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == FM01.MANDT
Transaction type
  • Client
  • Transaction type
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == T856.MANDT
  • I_PUBSECBDGTLINEITEMCUBE.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Functional Area
  • Client
  • Functional Area
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == TFKB.MANDT
  • I_PUBSECBDGTLINEITEMCUBE.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Financial Management Area
  • Client
  • Fund
  • I_PUBSECBDGTLINEITEMCUBE.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == FMFINCODE.MANDT
  • I_PUBSECBDGTLINEITEMCUBE.FUND == FMFINCODE.FINCODE
FM Fund Type
  • Financial Management Area
  • FM Fund Type
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.FINANCIALMANAGEMENTAREA == FMFUNDTYPE.FM_AREA
  • I_PUBSECBDGTLINEITEMCUBE.FUNDTYPE == FMFUNDTYPE.FUND_TYPE
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == FMFUNDTYPE.MANDT
G/L Account
  • G/L Account
  • Client
  • Chart of Accounts
  • I_PUBSECBDGTLINEITEMCUBE.GLACCOUNT == SKA1.SAKNR
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == SKA1.MANDT
  • I_PUBSECBDGTLINEITEMCUBE.CHARTOFACCOUNTS == SKA1.KTOPL
Grant
  • Client
  • Grant
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == GMGR.CLIENT
  • I_PUBSECBDGTLINEITEMCUBE.GRANTID == GMGR.GRANT_NBR
Budget Validity Number
  • ?
  • ?
  • Budget Validity Number
  • Client
  • Grant
  • I_PUBSECBDGTLINEITEMCUBE.[column in domain "GM_BDGT_STATUS"] == GMBDGTVALIDITY.RELEASE_STATUS
  • I_PUBSECBDGTLINEITEMCUBE.[column in domain "GM_BDGT_PHASE"] == GMBDGTVALIDITY.BDGT_PHASE
  • I_PUBSECBDGTLINEITEMCUBE.GTEEMBUDGETVALIDITYNUMBER == GMBDGTVALIDITY.BDGT_VLDTY_NBR
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == GMBDGTVALIDITY.CLIENT
  • I_PUBSECBDGTLINEITEMCUBE.GRANTID == GMBDGTVALIDITY.GRANT_NBR
Ledger
  • Ledger
  • Client
Organization Division
  • Organization Division
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.ORGANIZATIONDIVISION == TSPA.SPART
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == TSPA.MANDT
Partner Business Area
  • Client
  • Partner Business Area
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == TGSB.MANDT
  • I_PUBSECBDGTLINEITEMCUBE.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.PARTNERCOMPANY == T880.RCOMP
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == T880.MANDT
Partner Cost Center
  • ?
  • Controlling Area
  • Partner Cost Center
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_PUBSECBDGTLINEITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_PUBSECBDGTLINEITEMCUBE.PARTNERCOSTCENTER == CSKS.KOSTL
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == CSKS.MANDT
Partner Functional Area
  • Partner Functional Area
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == TFKB.MANDT
Partner Profit Center
  • ?
  • Controlling Area
  • Client
  • Partner Profit Center
  • I_PUBSECBDGTLINEITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_PUBSECBDGTLINEITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == CEPC.MANDT
  • I_PUBSECBDGTLINEITEMCUBE.PARTNERPROFITCENTER == CEPC.PRCTR
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == FAGL_SEGM.MANDT
Plan Category
  • Plan Category
  • Client
Plant
  • Plant
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.PLANT == T001W.WERKS
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == T001W.MANDT
Product Number
  • Product Number
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.PRODUCT == MARA.MATNR
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == MARA.MANDT
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_PUBSECBDGTLINEITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_PUBSECBDGTLINEITEMCUBE.PROFITCENTER == CEPC.PRCTR
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == CEPC.MANDT
Sales District
  • Sales District
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.SALESDISTRICT == T171.BZIRK
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == T171.MANDT
Sales Organization
  • Client
  • Sales Organization
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == TVKO.MANDT
  • I_PUBSECBDGTLINEITEMCUBE.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.SEGMENT == FAGL_SEGM.SEGMENT
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == FAGL_SEGM.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.SHIPTOPARTY == KNA1.KUNNR
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.SOLDPRODUCT == MARA.MATNR
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == MARA.MANDT
Sponsored Class
  • Client
  • Sponsored Class
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == GMSPCLASS.CLIENT
  • I_PUBSECBDGTLINEITEMCUBE.SPONSOREDCLASS == GMSPCLASS.SPONSORED_CLASS
Sponsored Program
  • Sponsored Program
  • Client
  • I_PUBSECBDGTLINEITEMCUBE.SPONSOREDPROGRAM == GMSPPROGRAM.SPONSORED_PROG
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == GMSPPROGRAM.CLIENT
Object ID of the resource
  • ?
  • Client
  • Object ID of the resource
  • I_PUBSECBDGTLINEITEMCUBE.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_PUBSECBDGTLINEITEMCUBE.MANDT == CRID.MANDT
  • I_PUBSECBDGTLINEITEMCUBE.WORKCENTERINTERNALID == CRID.OBJID