A_FinPlanningEntryItem

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