A_FinPlanEntryItemVariableFix

API Financial Planning Entry Item Variable and Fixed Amounts | view: AFIFINPLANENTVF | 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
📏 Unit of Measure for Reference Quantity (ReferenceQuantityUnit):
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 FIS_JAHRPER_C
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)
  • Client
  • Budget Type (Subcategory)
Budget Period
  • Client
  • Budget Period
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == FMBUDGETPD.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.BUDGETPERIOD == FMBUDGETPD.BUDGET_PD
Budget Process Type
  • Client
  • Budget Process Type
Business Area
  • Business Area
  • Client
  • A_FINPLANENTRYITEMVARIABLEFIX.BUSINESSAREA == TGSB.GSBER
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == TGSB.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == T004.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == T001.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • A_FINPLANENTRYITEMVARIABLEFIX.CONTROLLINGAREA == TKA01.KOKRS
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • A_FINPLANENTRYITEMVARIABLEFIX.[column in domain "DATBI"] == CSKS.DATBI
  • A_FINPLANENTRYITEMVARIABLEFIX.CONTROLLINGAREA == CSKS.KOKRS
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == CSKS.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.COSTCENTER == CSKS.KOSTL
Customer Number
  • Client
  • Customer Number
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == KNA1.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.CUSTOMER == KNA1.KUNNR
Customer Group
  • Client
  • Customer Group
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == T151.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.CUSTOMERGROUP == T151.KDGRP
Country/Region of Customer or Supplier
  • Client
  • Country/Region of Customer or Supplier
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == T005.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
Industry Key
  • Industry Key
  • Client
  • A_FINPLANENTRYITEMVARIABLEFIX.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == T016.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == TVTW.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == TSPA.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.DIVISION == TSPA.SPART
Financial Management Area
  • Client
  • Financial Management Area
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == FM01.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.FINANCIALMANAGEMENTAREA == FM01.FIKRS
Transaction type
  • Client
  • Transaction type
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == T856.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Functional Area
  • Client
  • Functional Area
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == TFKB.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Client
  • Fund
  • Financial Management Area
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == FMFINCODE.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.FUND == FMFINCODE.FINCODE
  • A_FINPLANENTRYITEMVARIABLEFIX.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
G/L Account
  • Client
  • Chart of Accounts
  • G/L Account
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == SKA1.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.CHARTOFACCOUNTS == SKA1.KTOPL
  • A_FINPLANENTRYITEMVARIABLEFIX.GLACCOUNT == SKA1.SAKNR
Grant
  • Client
  • Grant
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == GMGR.CLIENT
  • A_FINPLANENTRYITEMVARIABLEFIX.GRANTID == GMGR.GRANT_NBR
Ledger
  • Client
  • Ledger
Product Sold Group
  • Client
  • Product Sold Group
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == T023.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.MATERIALGROUP == T023.MATKL
Partner Business Area
  • Client
  • Partner Business Area
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == TGSB.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == T880.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.PARTNERCOMPANY == T880.RCOMP
Partner Cost Center
  • ?
  • Controlling Area
  • Client
  • Partner Cost Center
  • A_FINPLANENTRYITEMVARIABLEFIX.[column in domain "DATBI"] == CSKS.DATBI
  • A_FINPLANENTRYITEMVARIABLEFIX.CONTROLLINGAREA == CSKS.KOKRS
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == CSKS.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Client
  • Partner Functional Area
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == TFKB.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Profit Center
  • ?
  • Controlling Area
  • Partner Profit Center
  • Client
  • A_FINPLANENTRYITEMVARIABLEFIX.[column in domain "DATBI"] == CEPC.DATBI
  • A_FINPLANENTRYITEMVARIABLEFIX.CONTROLLINGAREA == CEPC.KOKRS
  • A_FINPLANENTRYITEMVARIABLEFIX.PARTNERPROFITCENTER == CEPC.PRCTR
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == FAGL_SEGM.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Plan Category
  • Client
  • Plan Category
Plant
  • Client
  • Plant
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == T001W.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.PLANT == T001W.WERKS
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • Client
  • A_FINPLANENTRYITEMVARIABLEFIX.[column in domain "DATBI"] == CEPC.DATBI
  • A_FINPLANENTRYITEMVARIABLEFIX.CONTROLLINGAREA == CEPC.KOKRS
  • A_FINPLANENTRYITEMVARIABLEFIX.PROFITCENTER == CEPC.PRCTR
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == CEPC.MANDT
Sales District
  • Client
  • Sales District
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == T171.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Client
  • Sales Organization
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == TVKO.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == FAGL_SEGM.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.SEGMENT == FAGL_SEGM.SEGMENT
Product Sold
  • Client
  • Product Sold
  • A_FINPLANENTRYITEMVARIABLEFIX.MANDT == MARA.MANDT
  • A_FINPLANENTRYITEMVARIABLEFIX.SOLDMATERIAL == MARA.MATNR