I_FinPlanningEntryItemCube

Financial Planning Entry Item Cube | view: IFIFINPLNENTITC | TRAN | Extraction: Not supported | Component: Information System
Tables used: SCAL_TT_DATE, ACDOCP, MARA, TGSB, TGSBT, T004, T001, TKA02, TKA01, CSKS, CSLA, CSLA, CSLT, CSKS, CSKT, T005, T005T, KNA1, T151, T151T, TVTW, TVTWT, TSPA, TSPAT, TFKB, TFKBT, SKA1, T880, FINSC_LEDGER, FINSC_LEDGER_T, MARA, T023, T023T, MAKT, T001W, MARA, T023, T023T, T023T, T023, MAKT, CEPC, CEPC, CEPCT, PROJ, T171, T171T, TVKO, TVKOT, T000, FAGL_SEGM, FAGL_SEGMT, T016T, PRPS, CRHD, SKAT, T004, FINSC_ACTVE_APPL, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
FinancialPlanningDataPacket Financial Planning Data Packet Number
FinancialPlanningEntryItem Financial Planning Entry Item
FinancialPlanningReqTransSqnc Financial Planning Request Transaction Sequence Number
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
FixedAmountInCoCodeCrcy Fixed Amount in Company Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
FixedAmountInGlobalCrcy Fixed Amount in Global Currency
💲 Functional Currency (FunctionalCurrency):
AmountInFunctionalCurrency Amount in Functional Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency Amount in CO Object Currency
Column Name Description
📏 Unit of Measure (CostSourceUnit):
ValuationQuantity Valuation quantity
📏 Unit of Measure for Reference Quantity (ReferenceQuantityUnit):
ReferenceQuantity Reference quantity
Column Name Description
PostingDate Posting Date
Column Name Description
ControllingDebitCreditCode CO Debit/Credit Indicator Show values
IsStatisticalOrder Indicator: Internal Order is Statistical Account Assignment Show values
IsStatisticalCostCenter Indicator: Cost Center is Statistical Account Assignment Show values
IsStatisticalSalesDocument Indicator: Sales Order Item is Statisticl Account Assignment Show values
WBSIsStatisticalWBSElement Indicator: WBS Element is Statistical Account Assignment Show values
IsLotSizeIndependent Is Lot Size Independent Show values
Column Name Description Domain name
BillToPartyName Name of Bill-to Party TEXT80
BusinessAreaName Business Area Name CHAR30
CompanyCodeName Company Code Name TEXT25
ControllingAreaName Controlling Area Name TEXT25
CostCenterName Cost Center Name TEXT20
CostCtrActivityTypeName Activity Type Name DDTEXT
CustomerName Name of Customer TEXT80
CustomerGroupName Name of Customer Group TEXT30
CustomerSupplierCorporateGroup Corporate Group of Customer or Supplier KONZS
CustomerSupplierCountryName Country/Region Name of Customer/Supplier TEXT15
CustomerSupplierIndustryName Customer Supplier Industry Name TEXT20
DistributionChannelName Distribution Channel Name TEXT20
DivisionName Name of Division TEXT30
FiscalPeriod Fiscal Period POPER
FiscalYear Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
FiscalYearVariant Fiscal Year Variant PERIV
FunctionalAreaName Functional Area Name CHAR30
GLAccountName G/L Account Name CHAR30
GLAccountLongName G/L Account Long Name CHAR50
LedgerName Ledger Name TEXT30
LedgerFiscalYear Ledger Fiscal Year GJAHR
MaterialName Material Description TEXT40
MaterialGroupName Product Group Description TEXT20
ProductName Product Description TEXT40
ProductGroupName Product Group Description TEXT20
OrderItem Order item number CO_POSNR
PartnerBusinessAreaName Partner Business Area Name CHAR30
PartnerCompanyName Company Name TEXT30
PartnerCompanyCodeName Partner Company Code Name TEXT25
PartnerCostCenterName Partner Cost Center Name TEXT20
PartnerCostCtrActivityTypeName Partner Activity Type Name DDTEXT
PartnerFunctionalAreaName Partner Functional Area Name CHAR30
PartnerProfitCenterName Partner Profit Center Name CHAR50
PartnerProject Partner Project PS_PSPID
PartnerProjectDescription Partner Project Description (1st text line) TEXT40
PartnerSegmentName Partner Segment Name CHAR50
PartnerWBSElement Partner WBS Element PS_POSID
PartnerWBSElementDescription Partner WBS Element Description TEXT40
PersonnelNumber Personnel Number PERNR
PlantName Plant Name TEXT30
ProfitCenterName Description of Profit Center TEXT20
Project Project definition PS_PSPID
ProjectExternalID Project Number (External) Edited PS_PSPID_EDIT
PartnerProjectExternalID Project Number (External) Edited PS_PSPID_EDIT
ProjectDescription Project Description TEXT40
ReferenceDocument Reference document number AWREF
ReferenceDocumentContext Reference Document Context AWORG
ReferenceDocumentType Reference Document Type AWTYP
SalesDistrictName Name of the district TEXT20
SalesOrder Sales Order VBELN
SalesOrderItem Sales Order Item POSNR
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
SalesOrganizationName Sales Organization Name TEXT20
SegmentName Segment Name TEXT50
ShipToPartyName Name of Ship-to Party TEXT80
SoldMaterialName Sold Material Name TEXT40
SoldProductName Sold Material Name TEXT40
SoldProductGroupName Product Group Description TEXT20
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
PartnerWBSElementInternalID Partner WBS Element Internal ID FIS_WBSINT_NO_CONV
PartnerWBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
WBSElementDescription WBS Element Name TEXT40
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
WorkPackage Plan Item /CPD/PLAN_ITEM_ID
WorkCenter Work Center ARBPL
OrderOperation Operation/Activity Number VORNR
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarYearQuarter Year Quarter NUM5
CalendarMonth Calendar Month NUM2
CalendarYearMonth Year Month NUM6
CalendarWeek Calendar Week NUM2
CalendarYearWeek Year Week NUM6
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalWeek Fiscal Week FINS_FISCALWEEK
FiscalYearQuarter Fiscal Year + Fiscal Quarter FINS_FYEARQUARTER
FiscalYearWeek Fiscal Year + Fiscal Week FINS_FYEARWEEK
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_FINPLANNINGENTRYITEMCUBE.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Billing Type
  • Client
  • Billing Type
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == TVFK.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.BILLINGDOCUMENTTYPE == TVFK.FKART
Bill-to Party
  • Client
  • Bill-to Party
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == KNA1.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.BILLTOPARTY == KNA1.KUNNR
Budget Type (Subcategory)
  • Client
  • Budget Type (Subcategory)
Budget Period
  • Client
  • Budget Period
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == FMBUDGETPD.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.BUDGETPERIOD == FMBUDGETPD.BUDGET_PD
Budget Process Type
  • Client
  • Budget Process Type
Business Area
  • Client
  • Business Area
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == TGSB.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.BUSINESSAREA == TGSB.GSBER
Business Transaction Category
  • Client
  • Business Transaction Category
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == FINSC_BTTYPE.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.BUSINESSTRANSACTIONTYPE == FINSC_BTTYPE.BTTYPE
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_FINPLANNINGENTRYITEMCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_FINPLANNINGENTRYITEMCUBE.COMPANYCODE == T001.BUKRS
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == T001.MANDT
Controlling Area
  • Client
  • Controlling Area
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == TKA01.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • ?
  • Cost Center
  • Controlling Area
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == CSKS.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_FINPLANNINGENTRYITEMCUBE.COSTCENTER == CSKS.KOSTL
  • I_FINPLANNINGENTRYITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
Customer Number
  • Client
  • Customer Number
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == KNA1.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.CUSTOMER == KNA1.KUNNR
Customer Group
  • Client
  • Customer Group
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == T151.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.CUSTOMERGROUP == T151.KDGRP
Country/Region of Customer or Supplier
  • Client
  • Country/Region of Customer or Supplier
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == T005.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
Industry Key
  • Client
  • Industry Key
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == T016.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
Distribution Channel
  • Client
  • Distribution Channel
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == TVTW.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • Organization Division
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == TSPA.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.DIVISION == TSPA.SPART
  • I_FINPLANNINGENTRYITEMCUBE.ORGANIZATIONDIVISION == TSPA.SPART
Financial Management Area
  • Client
  • Financial Management Area
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == FM01.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.FINANCIALMANAGEMENTAREA == FM01.FIKRS
Transaction type
  • Client
  • Transaction type
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == T856.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Functional Area
  • Client
  • Functional Area
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == TFKB.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Client
  • Financial Management Area
  • Fund
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == FMFINCODE.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_FINPLANNINGENTRYITEMCUBE.FUND == FMFINCODE.FINCODE
G/L Account
  • Chart of Accounts
  • Client
  • G/L Account
  • I_FINPLANNINGENTRYITEMCUBE.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == SKA1.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.GLACCOUNT == SKA1.SAKNR
Grant
  • Client
  • Grant
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == GMGR.CLIENT
  • I_FINPLANNINGENTRYITEMCUBE.GRANTID == GMGR.GRANT_NBR
Ledger
  • Client
  • Ledger
Material Number
  • Client
  • Material Number
  • Product Number
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == MARA.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.MATERIAL == MARA.MATNR
  • I_FINPLANNINGENTRYITEMCUBE.PRODUCT == MARA.MATNR
Product Sold Group
  • Client
  • Product Sold Group
  • Product Group
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == T023.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.MATERIALGROUP == T023.MATKL
  • I_FINPLANNINGENTRYITEMCUBE.SOLDPRODUCTGROUP == T023.MATKL
Organization Division
  • Client
  • Division
  • Organization Division
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == TSPA.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.DIVISION == TSPA.SPART
  • I_FINPLANNINGENTRYITEMCUBE.ORGANIZATIONDIVISION == TSPA.SPART
Partner Business Area
  • Client
  • Partner Business Area
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == TGSB.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == T880.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.PARTNERCOMPANY == T880.RCOMP
Partner Cost Center
  • Client
  • ?
  • Controlling Area
  • Partner Cost Center
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == CSKS.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_FINPLANNINGENTRYITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_FINPLANNINGENTRYITEMCUBE.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Client
  • Partner Functional Area
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == TFKB.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Profit Center
  • Client
  • ?
  • Controlling Area
  • Partner Profit Center
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == CEPC.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_FINPLANNINGENTRYITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_FINPLANNINGENTRYITEMCUBE.PARTNERPROFITCENTER == CEPC.PRCTR
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == FAGL_SEGM.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Plan Category
  • Client
  • Plan Category
Plant
  • Client
  • Plant
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == T001W.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.PLANT == T001W.WERKS
Product Number
  • Client
  • Material Number
  • Product Number
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == MARA.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.MATERIAL == MARA.MATNR
  • I_FINPLANNINGENTRYITEMCUBE.PRODUCT == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == T023.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.PRODUCTGROUP == T023.MATKL
Profit Center
  • Client
  • ?
  • Controlling Area
  • Profit Center
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == CEPC.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_FINPLANNINGENTRYITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_FINPLANNINGENTRYITEMCUBE.PROFITCENTER == CEPC.PRCTR
Sales District
  • Client
  • Sales District
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == T171.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Client
  • Sales Organization
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == TVKO.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == FAGL_SEGM.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.SEGMENT == FAGL_SEGM.SEGMENT
Ship-to Party
  • Ship-to Party
  • Client
  • I_FINPLANNINGENTRYITEMCUBE.SHIPTOPARTY == KNA1.KUNNR
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Product Sold
  • Client
  • I_FINPLANNINGENTRYITEMCUBE.SOLDMATERIAL == MARA.MATNR
  • I_FINPLANNINGENTRYITEMCUBE.SOLDPRODUCT == MARA.MATNR
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == MARA.MANDT
Product Sold
  • Product Sold
  • Product Sold
  • Client
  • I_FINPLANNINGENTRYITEMCUBE.SOLDMATERIAL == MARA.MATNR
  • I_FINPLANNINGENTRYITEMCUBE.SOLDPRODUCT == MARA.MATNR
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == MARA.MANDT
Product Group
  • Client
  • Product Sold Group
  • Product Group
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == T023.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.MATERIALGROUP == T023.MATKL
  • I_FINPLANNINGENTRYITEMCUBE.SOLDPRODUCTGROUP == T023.MATKL
Subledger-Specific Line Item Type I_FINPLANNINGENTRYITEMCUBE.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE
Object ID of the resource
  • Client
  • ?
  • Object ID of the resource
  • I_FINPLANNINGENTRYITEMCUBE.MANDT == CRID.MANDT
  • I_FINPLANNINGENTRYITEMCUBE.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_FINPLANNINGENTRYITEMCUBE.WORKCENTERINTERNALID == CRID.OBJID