I_FinPlanEntryItemVariableFix

Financial Planning Entry Item Variable and Fixed Amounts | view: IFIFINPLANENTVF | 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
FixedVariableType Amount is of Type Fixed or Variable Show values
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency Amount in CO Object 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
Column Name Description
📏 Unit of Measure (CostSourceUnit):
ValuationQuantity Valuation quantity
ReferenceQuantity Reference quantity
Column Name Description
Column Name Description
FixedVariableType Amount is of Type Fixed or Variable Show values
ControllingDebitCreditCode CO Debit/Credit Indicator Show values
Column Name Description Domain name
LedgerName Ledger Name TEXT30
LedgerFiscalYear Ledger Fiscal Year GJAHR
GLAccountName G/L Account Name CHAR30
CompanyCodeName Company Code Name TEXT25
CostCenterName Cost Center Name TEXT20
ProfitCenterName Description of Profit Center TEXT20
FunctionalAreaName Functional Area Name CHAR30
BusinessAreaName Business Area Name CHAR30
ControllingAreaName Controlling Area Name TEXT25
SegmentName Segment Name TEXT50
PartnerCostCenterName Partner Cost Center Name TEXT20
PartnerProfitCenterName Partner Profit Center Name CHAR50
PartnerFunctionalAreaName Partner Functional Area Name CHAR30
PartnerBusinessAreaName Partner Business Area Name CHAR30
PartnerCompanyName Company Name TEXT30
PartnerSegmentName Partner Segment Name CHAR50
FiscalPeriod Fiscal Period POPER
FiscalYearVariant Fiscal Year Variant PERIV
FiscalYearPeriod Fiscal Year Period JAHRPER
PlantName Plant Name TEXT30
CustomerName Name of Customer TEXT80
Project Project definition PS_PSPID
ProjectDescription Project Description TEXT40
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSElementDescription WBS Element Name TEXT40
PartnerCompanyCodeName Partner Company Code Name TEXT25
CostCtrActivityTypeName Activity Type Name DDTEXT
PartnerCostCtrActivityTypeName Partner Activity Type Name DDTEXT
PartnerProject Partner Project PS_PSPID
PartnerProjectDescription Partner Project Description (1st text line) TEXT40
PartnerWBSElement Partner WBS Element PS_POSID
PartnerWBSElementDescription Partner WBS Element Description TEXT40
SalesOrganizationName Sales Organization Name TEXT20
DistributionChannelName Distribution Channel Name TEXT20
DivisionName Name of Division TEXT30
SoldMaterialName Sold Material Name TEXT40
MaterialGroupName Product Group Description TEXT20
CustomerGroupName Name of Customer Group TEXT30
CustomerSupplierCountryName Country/Region Name of Customer/Supplier TEXT15
CustomerSupplierIndustryName Customer Supplier Industry Name TEXT20
SalesDistrictName Name of the district TEXT20
Master Data Relations Join Conditions
Budget Type (Subcategory)
  • Budget Type (Subcategory)
  • Client
Budget Period
  • Client
  • Budget Period
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == FMBUDGETPD.MANDT
  • I_FINPLANENTRYITEMVARIABLEFIX.BUDGETPERIOD == FMBUDGETPD.BUDGET_PD
Budget Process Type
  • Budget Process Type
  • Client
Business Area
  • Client
  • Business Area
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == TGSB.MANDT
  • I_FINPLANENTRYITEMVARIABLEFIX.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == T004.MANDT
  • I_FINPLANENTRYITEMVARIABLEFIX.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • I_FINPLANENTRYITEMVARIABLEFIX.COMPANYCODE == T001.BUKRS
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == T001.MANDT
Controlling Area
  • Client
  • Controlling Area
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == TKA01.MANDT
  • I_FINPLANENTRYITEMVARIABLEFIX.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Cost Center
  • Controlling Area
  • ?
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == CSKS.MANDT
  • I_FINPLANENTRYITEMVARIABLEFIX.COSTCENTER == CSKS.KOSTL
  • I_FINPLANENTRYITEMVARIABLEFIX.CONTROLLINGAREA == CSKS.KOKRS
  • I_FINPLANENTRYITEMVARIABLEFIX.[column in domain "DATBI"] == CSKS.DATBI
Customer Number
  • Customer Number
  • Client
  • I_FINPLANENTRYITEMVARIABLEFIX.CUSTOMER == KNA1.KUNNR
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • I_FINPLANENTRYITEMVARIABLEFIX.CUSTOMERGROUP == T151.KDGRP
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == T151.MANDT
Country/Region of Customer or Supplier
  • Country/Region of Customer or Supplier
  • Client
  • I_FINPLANENTRYITEMVARIABLEFIX.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == T005.MANDT
Industry Key
  • Client
  • Industry Key
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == T016.MANDT
  • I_FINPLANENTRYITEMVARIABLEFIX.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
Distribution Channel
  • Client
  • Distribution Channel
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == TVTW.MANDT
  • I_FINPLANENTRYITEMVARIABLEFIX.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == TSPA.MANDT
  • I_FINPLANENTRYITEMVARIABLEFIX.DIVISION == TSPA.SPART
Financial Management Area
  • Financial Management Area
  • Client
  • I_FINPLANENTRYITEMVARIABLEFIX.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == FM01.MANDT
Transaction type
  • Client
  • Transaction type
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == T856.MANDT
  • I_FINPLANENTRYITEMVARIABLEFIX.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Functional Area
  • Functional Area
  • Client
  • I_FINPLANENTRYITEMVARIABLEFIX.FUNCTIONALAREA == TFKB.FKBER
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == TFKB.MANDT
Fund
  • Financial Management Area
  • Client
  • Fund
  • I_FINPLANENTRYITEMVARIABLEFIX.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == FMFINCODE.MANDT
  • I_FINPLANENTRYITEMVARIABLEFIX.FUND == FMFINCODE.FINCODE
G/L Account
  • G/L Account
  • Client
  • Chart of Accounts
  • I_FINPLANENTRYITEMVARIABLEFIX.GLACCOUNT == SKA1.SAKNR
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == SKA1.MANDT
  • I_FINPLANENTRYITEMVARIABLEFIX.CHARTOFACCOUNTS == SKA1.KTOPL
Grant
  • Client
  • Grant
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == GMGR.CLIENT
  • I_FINPLANENTRYITEMVARIABLEFIX.GRANTID == GMGR.GRANT_NBR
Ledger
  • Client
  • Ledger
Product Sold Group
  • Product Sold Group
  • Client
  • I_FINPLANENTRYITEMVARIABLEFIX.MATERIALGROUP == T023.MATKL
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == T023.MANDT
Partner Business Area
  • Client
  • Partner Business Area
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == TGSB.MANDT
  • I_FINPLANENTRYITEMVARIABLEFIX.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == T880.MANDT
  • I_FINPLANENTRYITEMVARIABLEFIX.PARTNERCOMPANY == T880.RCOMP
Partner Cost Center
  • Partner Cost Center
  • Client
  • Controlling Area
  • ?
  • I_FINPLANENTRYITEMVARIABLEFIX.PARTNERCOSTCENTER == CSKS.KOSTL
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == CSKS.MANDT
  • I_FINPLANENTRYITEMVARIABLEFIX.CONTROLLINGAREA == CSKS.KOKRS
  • I_FINPLANENTRYITEMVARIABLEFIX.[column in domain "DATBI"] == CSKS.DATBI
Partner Functional Area
  • Partner Functional Area
  • Client
  • I_FINPLANENTRYITEMVARIABLEFIX.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == TFKB.MANDT
Partner Profit Center
  • Client
  • Controlling Area
  • ?
  • Partner Profit Center
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == CEPC.MANDT
  • I_FINPLANENTRYITEMVARIABLEFIX.CONTROLLINGAREA == CEPC.KOKRS
  • I_FINPLANENTRYITEMVARIABLEFIX.[column in domain "DATBI"] == CEPC.DATBI
  • I_FINPLANENTRYITEMVARIABLEFIX.PARTNERPROFITCENTER == CEPC.PRCTR
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • I_FINPLANENTRYITEMVARIABLEFIX.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == FAGL_SEGM.MANDT
Plan Category
  • Client
  • Plan Category
Plant
  • Client
  • Plant
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == T001W.MANDT
  • I_FINPLANENTRYITEMVARIABLEFIX.PLANT == T001W.WERKS
Profit Center
  • Client
  • Controlling Area
  • Profit Center
  • ?
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == CEPC.MANDT
  • I_FINPLANENTRYITEMVARIABLEFIX.CONTROLLINGAREA == CEPC.KOKRS
  • I_FINPLANENTRYITEMVARIABLEFIX.PROFITCENTER == CEPC.PRCTR
  • I_FINPLANENTRYITEMVARIABLEFIX.[column in domain "DATBI"] == CEPC.DATBI
Sales District
  • Sales District
  • Client
  • I_FINPLANENTRYITEMVARIABLEFIX.SALESDISTRICT == T171.BZIRK
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == T171.MANDT
Sales Organization
  • Client
  • Sales Organization
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == TVKO.MANDT
  • I_FINPLANENTRYITEMVARIABLEFIX.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == FAGL_SEGM.MANDT
  • I_FINPLANENTRYITEMVARIABLEFIX.SEGMENT == FAGL_SEGM.SEGMENT
Product Sold
  • Product Sold
  • Client
  • I_FINPLANENTRYITEMVARIABLEFIX.SOLDMATERIAL == MARA.MATNR
  • I_FINPLANENTRYITEMVARIABLEFIX.MANDT == MARA.MANDT