I_PubSecBdgtActlItemCube

Budget Cmtmt and Actual Items - Cube | view: IPSMS4CBDACTANC | TRAN | Extraction: Not supported | Component: Information system
Tables used: SCAL_TT_DATE, AFKO, PRTE, ACDOCA, ACDOCP, T001, TKA02, FMFINCODE, FMFUNDTYPE, SKB1, GMGR, GMGRANTNONE, GMGRTYPE, AUFK, PROJ, PSM_D_BDGTCNSTY, T001, FCOMC_CATEGORY, PRPS, PRPS, PSM_D_GLACCTX, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD, PSM_D_AVC_PRF_AS
Column Name Description
SourceLedger FK Source Ledger
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
FinancialPlanningReqTransSqnc Financial Planning Request Transaction Sequence Number
FinancialPlanningDataPacket Financial Planning Data Packet Number
ActualPlanJournalEntryItem Actual Plan Journal Entry Item
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
ActualAmountInTransactionCrcy Actual Amount in Transaction Currency
PlanAmountInTransactionCrcy Plan Amount in Transaction Currency
PlanPriceInTransactionCurrency Price in Transaction Currency
ActlPlnDiffAmtInTransCrcy Actual plan difference in transaction currency
PubSecExpnBdgtAmtInTransCrcy Budget Expense Amount in Transaction Currency
PubSecExpnCmtmtAmtInTransCrcy Commitment Expense Amount in Transaction Currency
PubSecExpnActlAmtInTransCrcy Actual Expense Amount in Transaction Currency
PubSecRevnBdgtAmtInTransCrcy Budget Revenue Amount in Transaction Currency
PubSecRevnCmtmtAmtInTransCrcy Commitment Revenue Amount in Transaction Currency
PubSecRevnActlAmtInTransCrcy Actual Revenue Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
ActualAmountInCompanyCodeCrcy Actual Amount in Company Code Currency
PlanAmountInCompanyCodeCrcy Plan Amount in Company Code Currency
PlanPriceInCompanyCodeCurrency Price in Company Code Currency
ActlPlnDiffAmtInCoCodeCrcy Actual plan difference in company code currency
PubSecExpnBdgtAmtInCoCodeCrcy Budget Expense Amount in Company Code Currency
PubSecExpnCmtmtAmtInCoCodeCrcy Commitment Expense Amount in Company Code Currency
PubSecExpnActlAmtInCoCodeCrcy Actual Expense Amount in Company Code Currency
PubSecRevnBdgtAmtInCoCodeCrcy Budget Revenue Amount in Company Code Currency
PubSecRevnCmtmtAmtInCoCodeCrcy Commitment Revenue Amount in Company Code Currency
PubSecRevnActlAmtInCoCodeCrcy Actual Revenue Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
ActualAmountInGlobalCurrency Actual Amount in Global Currency
PlanAmountInGlobalCurrency Plan Amount in Global Currency
PlanPriceInGlobalCurrency Price in Global Currency
ActlPlnDiffAmtInGlobalCrcy Actual plan difference in global currency
PubSecExpnBdgtAmtInGlobalCrcy Budget Expense Amount in Global Currency
PubSecExpnCmtmtAmtInGlobalCrcy Commitment Expense Amount in Global Currency
PubSecExpnActlAmtInGlobalCrcy Actual Expense Amount in Global Currency
PubSecRevnBdgtAmtInGlobalCrcy Budget Revenue Amount in Global Currency
PubSecRevnCmtmtAmtInGlobalCrcy Commitment Revenue Amount in Global Currency
PubSecRevnActlAmtInGlobalCrcy Actual Revenue Amount in Global Currency
Column Name Description
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity Valuation quantity
ActualValuationQuantity Actual Valuation Quantity
PlanValuationQuantity Plan Valuation Quantity
ActlPanDiffValuationQuantity Actual Plan Difference Valuation Quantity
Column Name Description
PostingDate Posting Date
ServicesRenderedDate Date on which services are rendered
PubSecBudgetCnsmpnDate Budget Consumption Date
Column Name Description
ActualPlanCode Actual Plan Code Show values
FinancialAccountType Account Type Show values
ControllingDebitCreditCode Controlling Debit Credit Code Show values
IsStatisticalOrder Indicator: Internal Order is Statistical Account Assignment Show values
IsStatisticalCostCenter Indicator: Cost Center is Statistical Account Assignment Show values
IsStatisticalSalesDocument Sales Document is statistical Show values
WBSIsStatisticalWBSElement Indicator: WBS Element is Statistical Account Assignment Show values
IsCommitment Indicator: Is Commitment Show values
PubSecBudgetCnsmpnAmtType Budget Consumption Amount Type Show values
PubSecBudgetIsRelevant Budget-Relevant Indicator Show values
PubSecBdgtAcctRevnExpnCode Expense or Revenue on Budget Account Show values
Column Name Description Domain name
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
FinancialPlanningEntryItem Financial Planning Entry Item RSNUMRECORD
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
CtrlObjForFund Control Object for a Fund
HierarchyIDForFund Hierarchy ID for Fund DHRYID
CtrlObjForFunctionalArea Control Object for a Functional Area
HierarchyIDForFunctionalArea Hierarchy ID for Functional Area DHRYID
CtrlObjForBudgetPeriod Control Object for a Budget Period
HierarchyIDForBudgetPeriod Hierarchy ID for Budget Period DHRYID
CtrlObjForCostCenter Control Object for a Cost Center
HierarchyIDForCostCenter Hierarchy ID for Cost Center DHRYID
CtrlObjForWBSElement Control Object for a WBS Element
HierarchyIDForWBSElement Hierarchy ID for WBS Element DHRYID
CtrlObjForBudgetAccount Control Object for a Budget Account
HierarchyIDForBudgetAccount Hierarchy ID for Budget Account Element DHRYID
CtrlObjForGrant Control Object for a Grant
GrantHierarchy Grant Hierarchy DHRYID
CtrlObjForSponsoredClass Control Object for a Sponsored Class
SponsoredClassHierarchy Sponsored Class Hierarchy DHRYID
CtrlObjForSponsoredProgram Control Object for a Sponsored Program
SponsoredProgramHierarchy Sponsored Program Hierarchy DHRYID
CtrlObjForBdgtValidityNmbr Control Object for a Budget Validity Number
ReferenceDocumentContext Reference Document Context AWORG
ReferenceDocument Reference document number AWREF
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
PlanningCategory Plan Category FCOM_CATEGORY
PersonnelNumber Personnel Number PERNR
SalesDocumentItem Sales Document Item POSNR
CustomerSupplierCorporateGroup Customer Supplier Corporate Group KONZS
OrderOperation Operation/Activity Number VORNR
OrderItem Order item number CO_POSNR
SourceReferenceDocumentCntxt Source Reference Document Context AWORG
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
SourceReferenceDocSubitem Source Reference Document Subitem NUMC6
GrantID Grant GM_GRANT_NBR
SponsoredClass Sponsored Class GM_SPONSORED_CLASS
SponsoredProgram Sponsored Program GM_SPONSORED_PROG
GteeMBudgetValidityNumber Budget Validity Number GM_BDGT_VLDTY_NBR
PartnerGrant Partner Grant GM_GRANT_NBR
PubSecBudgetAccount Budget Account SAKNR
PubSecBudgetAccountCoCode Budget Account Company Code BUKRS
PubSecBudgetCnsmpnFsclPeriod CC Fiscal Period for Budget Consumption Date POPER
PubSecBudgetCnsmpnFsclYear CC Fiscal Year for Budget Consumption Date GJAHR
BudgetProcess Budget Process Type BUDGET_PROCESS
BudgetingType Budget Type (Subcategory) BUDGET_SUBCATEGORY
BudgetDocument Budget Document Number AWREF
PurchaseOrder Purchase Order Number EBELN
PurchaseRequisition Purchase requisition number BANFN
EarmarkedFundsDocument Document Number for Earmarked Funds KBLNR
GLAccountAuthorizationGroup Authorization Group BRGRU
SupplierBasicAuthorizationGrp Authorization Group BRGRU
CustomerBasicAuthorizationGrp Authorization Group BRGRU
AcctgDocTypeAuthorizationGroup Authorization Group BRGRU
OrderType Order Type AUFART
SalesOrderType Sales Document Type AUART
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == T003.MANDT
Asset Class
  • Client
  • Asset Class
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == ANKA.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.ASSETCLASS == ANKA.ANLKL
Budget Availability Control Profile for Public Sector Mgmt
  • Client
  • Budget Availability Control Profile for Public Sector Mgmt
Billing Type
  • Billing Type
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == TVFK.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.BILLTOPARTY == KNA1.KUNNR
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == KNA1.MANDT
Budget Period
  • Financial Management Area
  • Fund
  • Budget Period
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • I_PUBSECBDGTACTLITEMCUBE.FUND == FMFUNDBPD.FINCODE
  • I_PUBSECBDGTACTLITEMCUBE.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == FMFUNDBPD.MANDT
Business Area
  • Business Area
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.BUSINESSAREA == TGSB.GSBER
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == TGSB.MANDT
Business Transaction Type
  • Client
  • Business Transaction Type
Cash Origin Account
  • Chart of Accounts
  • Client
  • Cash Origin Account
  • I_PUBSECBDGTACTLITEMCUBE.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == SKA1.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.CASHLEDGERACCOUNT == SKA1.SAKNR
Cash Origin Company Code
  • Client
  • Cash Origin Company Code
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == T001.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.CASHLEDGERCOMPANYCODE == T001.BUKRS
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == T001.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == TCURC.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == TKA01.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.CONTROLLINGAREA == TKA01.KOKRS
Cost Analysis Resource
  • ?
  • Client
  • Cost Analysis Resource
  • Controlling Area
  • I_PUBSECBDGTACTLITEMCUBE.[column in domain "DATBI"] == CSKR.DATBI
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == CSKR.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.COSTANALYSISRESOURCE == CSKR.RESRC
  • I_PUBSECBDGTACTLITEMCUBE.CONTROLLINGAREA == CSKR.KOKRS
Cost Center
  • ?
  • Client
  • Controlling Area
  • Cost Center
  • I_PUBSECBDGTACTLITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == CSKS.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_PUBSECBDGTACTLITEMCUBE.COSTCENTER == CSKS.KOSTL
Activity Type
  • Activity Type
  • ?
  • Client
  • Controlling Area
  • I_PUBSECBDGTACTLITEMCUBE.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_PUBSECBDGTACTLITEMCUBE.[column in domain "DATBI"] == CSLA.DATBI
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == CSLA.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.CONTROLLINGAREA == CSLA.KOKRS
Cost Source Unit
  • Cost Source Unit
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.COSTSOURCEUNIT == T006.MSEHI
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == T006.MANDT
Customer Number
  • Customer Number
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.CUSTOMER == KNA1.KUNNR
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.CUSTOMERGROUP == T151.KDGRP
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == T151.MANDT
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == T005.MANDT
Customer Supplier Industry
  • Client
  • Customer Supplier Industry
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == T016.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
Distribution Channel
  • Distribution Channel
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == TVTW.MANDT
Financial Management Area
  • Financial Management Area
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == FM01.MANDT
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == T856.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.FISCALYEARVARIANT == T009.PERIV
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == T009.MANDT
Functional Area
  • Client
  • Functional Area
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == TFKB.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Financial Management Area
  • Fund
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_PUBSECBDGTACTLITEMCUBE.FUND == FMFINCODE.FINCODE
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == FMFINCODE.MANDT
FM Fund Type
  • Financial Management Area
  • Client
  • FM Fund Type
  • I_PUBSECBDGTACTLITEMCUBE.FINANCIALMANAGEMENTAREA == FMFUNDTYPE.FM_AREA
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == FMFUNDTYPE.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.FUNDTYPE == FMFUNDTYPE.FUND_TYPE
G/L Account
  • G/L Account
  • Client
  • Company Code
  • I_PUBSECBDGTACTLITEMCUBE.GLACCOUNT == SKB1.SAKNR
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == SKB1.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == TCURC.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Order ID
  • Order ID
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.ORDERID == AUFK.AUFNR
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == AUFK.MANDT
Organization Division
  • Organization Division
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.ORGANIZATIONDIVISION == TSPA.SPART
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == TSPA.MANDT
Origin Cost Center
  • ?
  • Client
  • Controlling Area
  • Origin Cost Center
  • I_PUBSECBDGTACTLITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == CSKS.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_PUBSECBDGTACTLITEMCUBE.ORIGINCOSTCENTER == CSKS.KOSTL
Origin Cost Center Activity Type
  • ?
  • Origin Cost Center Activity Type
  • Client
  • Controlling Area
  • I_PUBSECBDGTACTLITEMCUBE.[column in domain "DATBI"] == CSLA.DATBI
  • I_PUBSECBDGTACTLITEMCUBE.ORIGINCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == CSLA.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.CONTROLLINGAREA == CSLA.KOKRS
Origin Profit Center
  • ?
  • Client
  • Controlling Area
  • Origin Profit Center
  • I_PUBSECBDGTACTLITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == CEPC.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_PUBSECBDGTACTLITEMCUBE.ORIGINPROFITCENTER == CEPC.PRCTR
FM: Partner Budget Period
  • Financial Management Area
  • FM: Partner Budget Period
  • Client
  • Partner Fund
  • I_PUBSECBDGTACTLITEMCUBE.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • I_PUBSECBDGTACTLITEMCUBE.PARTNERBUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == FMFUNDBPD.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.PARTNERFUND == FMFUNDBPD.FINCODE
Partner Business Area
  • Partner Business Area
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.PARTNERBUSINESSAREA == TGSB.GSBER
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == TGSB.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.PARTNERCOMPANY == T880.RCOMP
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == T880.MANDT
Partner Company Code
  • Partner Company Code
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.PARTNERCOMPANYCODE == T001.BUKRS
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == T001.MANDT
Partner Cost Center
  • ?
  • Client
  • Partner Cost Center
  • Controlling Area
  • I_PUBSECBDGTACTLITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == CSKS.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.PARTNERCOSTCENTER == CSKS.KOSTL
  • I_PUBSECBDGTACTLITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
Partner Cost Center Activity Type
  • Partner Cost Center Activity Type
  • ?
  • Client
  • Controlling Area
  • I_PUBSECBDGTACTLITEMCUBE.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_PUBSECBDGTACTLITEMCUBE.[column in domain "DATBI"] == CSLA.DATBI
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == CSLA.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.CONTROLLINGAREA == CSLA.KOKRS
Partner Functional Area
  • Client
  • Partner Functional Area
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == TFKB.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Fund
  • Financial Management Area
  • Client
  • Partner Fund
  • I_PUBSECBDGTACTLITEMCUBE.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == FMFINCODE.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.PARTNERFUND == FMFINCODE.FINCODE
Partner Order
  • Partner Order
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.PARTNERORDER == AUFK.AUFNR
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == AUFK.MANDT
Partner Profit Center
  • ?
  • Partner Profit Center
  • Client
  • Controlling Area
  • I_PUBSECBDGTACTLITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_PUBSECBDGTACTLITEMCUBE.PARTNERPROFITCENTER == CEPC.PRCTR
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == CEPC.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
Partner Project Internal ID
  • Client
  • Partner Project Internal ID
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == PROJ.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.PARTNERPROJECTINTERNALID == PROJ.PSPNR
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == FAGL_SEGM.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Plant
  • Client
  • Plant
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == T001W.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.PLANT == T001W.WERKS
Product Number
  • Client
  • Product Number
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == MARA.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.PRODUCT == MARA.MATNR
Profit Center
  • Profit Center
  • ?
  • Client
  • Controlling Area
  • I_PUBSECBDGTACTLITEMCUBE.PROFITCENTER == CEPC.PRCTR
  • I_PUBSECBDGTACTLITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == CEPC.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
Project Internal ID
  • Project Internal ID
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.PROJECTINTERNALID == PROJ.PSPNR
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == PROJ.MANDT
Budget Consumption Type
  • Budget Consumption Type
  • Client
Reference Document Type I_PUBSECBDGTACTLITEMCUBE.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Sales District
  • Sales District
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.SALESDISTRICT == T171.BZIRK
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == T171.MANDT
Sales Organization
  • Sales Organization
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.SALESORGANIZATION == TVKO.VKORG
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.SEGMENT == FAGL_SEGM.SEGMENT
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == FAGL_SEGM.MANDT
Service Contract ID
  • Service Contract Item ID
  • Service Contract ID
  • Service Contract Type
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_PUBSECBDGTACTLITEMCUBE.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID
  • I_PUBSECBDGTACTLITEMCUBE.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == FCO_SRVDOC.MANDT
Service Contract Item ID
  • Service Contract Item ID
  • Service Contract ID
  • Service Contract Type
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_PUBSECBDGTACTLITEMCUBE.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID
  • I_PUBSECBDGTACTLITEMCUBE.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == FCO_SRVDOC.MANDT
Service Contract Type
  • Service Contract Type
  • Client
Service Document ID
  • Service Document ID
  • Service Document Type
  • Client
  • Service Document Item ID
  • I_PUBSECBDGTACTLITEMCUBE.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • I_PUBSECBDGTACTLITEMCUBE.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == FCO_SRVDOC.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
Service Document Item ID
  • Service Document ID
  • Service Document Type
  • Client
  • Service Document Item ID
  • I_PUBSECBDGTACTLITEMCUBE.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • I_PUBSECBDGTACTLITEMCUBE.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == FCO_SRVDOC.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
Service Document Type
  • Service Document Type
  • Client
Ship-to Party
  • Client
  • Ship-to Party
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == KNA1.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.SHIPTOPARTY == KNA1.KUNNR
Product Sold
  • Product Sold
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.SOLDPRODUCT == MARA.MATNR
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == MARA.MANDT
Source Ledger
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Source Logical System I_PUBSECBDGTACTLITEMCUBE.SOURCELOGICALSYSTEM == TBDLS.LOGSYS
Source Reference Document Type I_PUBSECBDGTACTLITEMCUBE.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Supplier
  • Supplier
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.SUPPLIER == LFA1.LIFNR
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == LFA1.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == TCURC.MANDT
  • I_PUBSECBDGTACTLITEMCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
Valuation area
  • Valuation area
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.VALUATIONAREA == T001K.BWKEY
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == T001K.MANDT
Object ID of the resource
  • ?
  • Object ID of the resource
  • Client
  • I_PUBSECBDGTACTLITEMCUBE.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_PUBSECBDGTACTLITEMCUBE.WORKCENTERINTERNALID == CRID.OBJID
  • I_PUBSECBDGTACTLITEMCUBE.MANDT == CRID.MANDT