C_GenericPlanQ3001

Financial Plan Data | view: CFIGENERICPLAN | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting

Tables used: SCAL_TT_DATE, AFKO, PRTE, ACDOCA, ACDOCP, MARA, T003, T003T, TGSB, TGSBT, FINSC_CUSTBTTYPE, FINSC_CUSTBTTYPT, 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, AUFK, T001W, MARA, T023T, T023, CRTX, MAKT, CEPC, CEPC, CEPCT, PROJ, T171, T171T, TVKO, TVKOT, T000, FAGL_SEGM, FAGL_SEGMT, T016T, PRPS, PRPS, CRHD, SKAT, T004, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD

🔑 Keys
💰 Amounts (18)
∑ Quantities (2)
📅 Dates (3)
☰ Categorical (1)
Other (27)
🔗 Relations (67)

Column Name	Description

Column Name	Description
💲 Transaction Currency (TransactionCurrency):
PlanAmountInTransactionCrcy	Amount in Transaction Currency
PlanPriceInTransactionCurrency	Price in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
PlanAmountInCompanyCodeCrcy	Amount in Company Code Currency
FixedAmountInCoCodeCrcy	Fixed Amount in Company Currency
PlanPriceInCompanyCodeCurrency	Price in Company Code Currency
💲 Global Currency (GlobalCurrency):
PlanAmountInGlobalCurrency	Amount in Global Currency
FixedAmountInGlobalCrcy	Fixed Amount in Global Currency
PlanPriceInGlobalCurrency	Price in Global Currency
💲 CO Object Currency (ControllingObjectCurrency):
PlanAmountInObjectCurrency	Amount in Object Currency
💲 Functional Currency (FunctionalCurrency):
PlanAmountInFunctionalCurrency	Amount in Functional Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
PlanAmountInFreeDefinedCrcy1	Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
PlanAmountInFreeDefinedCrcy2	Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
PlanAmountInFreeDefinedCrcy3	Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
PlanAmountInFreeDefinedCrcy4	Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
PlanAmountInFreeDefinedCrcy5	Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
PlanAmountInFreeDefinedCrcy6	Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
PlanAmountInFreeDefinedCrcy7	Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
PlanAmountInFreeDefinedCrcy8	Amount in Freely Defined Currency 8

Column Name	Description
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity	Valuation quantity
📏 Unit of Measure for Reference Quantity (ReferenceQuantityUnit):
ReferenceQuantity	Reference quantity

Column Name	Description
JointVentureProductionDate	Joint Venture Production Date
PostingDate	Posting Date
SettlementReferenceDate	Settlement Reference Date

Column Name	Description
ControllingDebitCreditCode	Controlling Debit Credit Code	Show values

Column Name	Description	Domain name
GteeMBudgetValidityNumber	Budget Validity Number	GM_BDGT_VLDTY_NBR
BudgetProcess	Budget Process Type	BUDGET_PROCESS
BudgetingType	Budget Type (Subcategory)	BUDGET_SUBCATEGORY
CustomerSupplierCorporateGroup	Customer Supplier Corporate Group	KONZS
FiscalPeriod	Fiscal Period	POPER
FiscalYearPeriod	Fiscal Year Period	FIS_JAHRPER_CONV
GrantID	Grant	GM_GRANT_NBR
LedgerFiscalYear	Ledger Fiscal Year	GJAHR
AccountingDocument	Journal Entry	BELNR
LedgerGLLineItem	Ledger Journal Entry Item	DOCLN6
PartnerProject	Partner Project	FIS_PROJECT
PartnerWBSElement	Partner WBS Element	FIS_WBS
PlanningCategory	Plan Category
PersonnelNumber	Personnel Number	PERNR
Project	Project	FIS_PROJECT
REBusinessEntity	RE Business Entity	REBDVDMBENO
RealEstateBuilding	Real Estate Building	REBDVDMBUNO
RealEstateProperty	Real Estate Property	REBDVDMPRNO
RERentalObject	RE Rental Object	REBDVDMRONO
RealEstateContract	Real Estate Contract	RECNVDMCNNR
REServiceChargeKey	RE Service Charge Key	RESCVDMSCKEY
RESettlementUnitID	RE Settlement Unit	RESCVDMSUID
SalesOrderItem	Sales Order Item	POSNR
SponsoredProgram	Sponsored Program	GM_SPONSORED_PROG
SponsoredClass	Sponsored Class	GM_SPONSORED_CLASS
WBSElement	WBS Element	FIS_WBS
WorkItem	Work Item ID	/CPD/PFP_WORKITEM_ID

Master Data Relations	Join Conditions
Bill-to Party Bill-to Party Client	`C_GENERICPLANQ3001.BILLTOPARTY == KNA1.KUNNR` `C_GENERICPLANQ3001.MANDT == KNA1.MANDT`
Budget Period Financial Management Area Budget Period Fund Client	`C_GENERICPLANQ3001.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS` `C_GENERICPLANQ3001.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD` `C_GENERICPLANQ3001.FUND == FMFUNDBPD.FINCODE` `C_GENERICPLANQ3001.MANDT == FMFUNDBPD.MANDT`
Business Area Business Area Client	`C_GENERICPLANQ3001.BUSINESSAREA == TGSB.GSBER` `C_GENERICPLANQ3001.MANDT == TGSB.MANDT`
Business Transaction Type Business Transaction Type Client	`C_GENERICPLANQ3001.BUSINESSTRANSACTIONTYPE == FINSC_CUSTBTTYPE.CBTTYPE` `C_GENERICPLANQ3001.MANDT == FINSC_CUSTBTTYPE.MANDT`
Chart of Accounts Chart of Accounts Client	`C_GENERICPLANQ3001.CHARTOFACCOUNTS == T004.KTOPL` `C_GENERICPLANQ3001.MANDT == T004.MANDT`
Company Code Company Code Client	`C_GENERICPLANQ3001.COMPANYCODE == T001.BUKRS` `C_GENERICPLANQ3001.MANDT == T001.MANDT`
Company Code Currency Company Code Currency Client	`C_GENERICPLANQ3001.COMPANYCODECURRENCY == TCURC.WAERS` `C_GENERICPLANQ3001.MANDT == TCURC.MANDT`
Controlling Area Controlling Area Client	`C_GENERICPLANQ3001.CONTROLLINGAREA == TKA01.KOKRS` `C_GENERICPLANQ3001.MANDT == TKA01.MANDT`
CO Object Currency Client CO Object Currency	`C_GENERICPLANQ3001.MANDT == TCURC.MANDT` `C_GENERICPLANQ3001.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS`
Cost Analysis Resource Controlling Area Cost Analysis Resource ? Client	`C_GENERICPLANQ3001.CONTROLLINGAREA == CSKR.KOKRS` `C_GENERICPLANQ3001.COSTANALYSISRESOURCE == CSKR.RESRC` `C_GENERICPLANQ3001.[column in domain "DATBI"] == CSKR.DATBI` `C_GENERICPLANQ3001.MANDT == CSKR.MANDT`
Cost Center Controlling Area ? Client Cost Center	`C_GENERICPLANQ3001.CONTROLLINGAREA == CSKS.KOKRS` `C_GENERICPLANQ3001.[column in domain "DATBI"] == CSKS.DATBI` `C_GENERICPLANQ3001.MANDT == CSKS.MANDT` `C_GENERICPLANQ3001.COSTCENTER == CSKS.KOSTL`
Activity Type Activity Type Controlling Area ? Client	`C_GENERICPLANQ3001.COSTCTRACTIVITYTYPE == CSLA.LSTAR` `C_GENERICPLANQ3001.CONTROLLINGAREA == CSLA.KOKRS` `C_GENERICPLANQ3001.[column in domain "DATBI"] == CSLA.DATBI` `C_GENERICPLANQ3001.MANDT == CSLA.MANDT`
Cost Source Unit Client Cost Source Unit	`C_GENERICPLANQ3001.MANDT == T006.MANDT` `C_GENERICPLANQ3001.COSTSOURCEUNIT == T006.MSEHI`
Customer Number Customer Number Client	`C_GENERICPLANQ3001.CUSTOMER == KNA1.KUNNR` `C_GENERICPLANQ3001.MANDT == KNA1.MANDT`
Customer Group Customer Group Client	`C_GENERICPLANQ3001.CUSTOMERGROUP == T151.KDGRP` `C_GENERICPLANQ3001.MANDT == T151.MANDT`
Customer or Supplier Country/Region Customer or Supplier Country/Region Client	`C_GENERICPLANQ3001.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1` `C_GENERICPLANQ3001.MANDT == T005.MANDT`
Customer Supplier Industry Customer Supplier Industry Client	`C_GENERICPLANQ3001.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH` `C_GENERICPLANQ3001.MANDT == T016.MANDT`
Distribution Channel Distribution Channel Client	`C_GENERICPLANQ3001.DISTRIBUTIONCHANNEL == TVTW.VTWEG` `C_GENERICPLANQ3001.MANDT == TVTW.MANDT`
Division Division Client	`C_GENERICPLANQ3001.DIVISION == TSPA.SPART` `C_GENERICPLANQ3001.MANDT == TSPA.MANDT`
Financial Management Area Financial Management Area Client	`C_GENERICPLANQ3001.FINANCIALMANAGEMENTAREA == FM01.FIKRS` `C_GENERICPLANQ3001.MANDT == FM01.MANDT`
Financial Transaction Type Financial Transaction Type Client	`C_GENERICPLANQ3001.FINANCIALTRANSACTIONTYPE == T856.TRTYP` `C_GENERICPLANQ3001.MANDT == T856.MANDT`
Fiscal Year Variant Fiscal Year Variant Client	`C_GENERICPLANQ3001.FISCALYEARVARIANT == T009.PERIV` `C_GENERICPLANQ3001.MANDT == T009.MANDT`
Freely Defined Currency 1 Freely Defined Currency 1 Client	`C_GENERICPLANQ3001.FREEDEFINEDCURRENCY1 == TCURC.WAERS` `C_GENERICPLANQ3001.MANDT == TCURC.MANDT`
Freely Defined Currency 2 Freely Defined Currency 2 Client	`C_GENERICPLANQ3001.FREEDEFINEDCURRENCY2 == TCURC.WAERS` `C_GENERICPLANQ3001.MANDT == TCURC.MANDT`
Freely Defined Currency 3 Freely Defined Currency 3 Client	`C_GENERICPLANQ3001.FREEDEFINEDCURRENCY3 == TCURC.WAERS` `C_GENERICPLANQ3001.MANDT == TCURC.MANDT`
Freely Defined Currency 4 Freely Defined Currency 4 Client	`C_GENERICPLANQ3001.FREEDEFINEDCURRENCY4 == TCURC.WAERS` `C_GENERICPLANQ3001.MANDT == TCURC.MANDT`
Freely Defined Currency 5 Freely Defined Currency 5 Client	`C_GENERICPLANQ3001.FREEDEFINEDCURRENCY5 == TCURC.WAERS` `C_GENERICPLANQ3001.MANDT == TCURC.MANDT`
Freely Defined Currency 6 Freely Defined Currency 6 Client	`C_GENERICPLANQ3001.FREEDEFINEDCURRENCY6 == TCURC.WAERS` `C_GENERICPLANQ3001.MANDT == TCURC.MANDT`
Freely Defined Currency 7 Freely Defined Currency 7 Client	`C_GENERICPLANQ3001.FREEDEFINEDCURRENCY7 == TCURC.WAERS` `C_GENERICPLANQ3001.MANDT == TCURC.MANDT`
Freely Defined Currency 8 Freely Defined Currency 8 Client	`C_GENERICPLANQ3001.FREEDEFINEDCURRENCY8 == TCURC.WAERS` `C_GENERICPLANQ3001.MANDT == TCURC.MANDT`
Functional Area Functional Area Client	`C_GENERICPLANQ3001.FUNCTIONALAREA == TFKB.FKBER` `C_GENERICPLANQ3001.MANDT == TFKB.MANDT`
Functional Currency Functional Currency Client	`C_GENERICPLANQ3001.FUNCTIONALCURRENCY == TCURC.WAERS` `C_GENERICPLANQ3001.MANDT == TCURC.MANDT`
Fund Financial Management Area Fund Client	`C_GENERICPLANQ3001.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS` `C_GENERICPLANQ3001.FUND == FMFINCODE.FINCODE` `C_GENERICPLANQ3001.MANDT == FMFINCODE.MANDT`
G/L Account Company Code G/L Account Client	`C_GENERICPLANQ3001.COMPANYCODE == SKB1.BUKRS` `C_GENERICPLANQ3001.GLACCOUNT == SKB1.SAKNR` `C_GENERICPLANQ3001.MANDT == SKB1.MANDT`
Global Currency Global Currency Client	`C_GENERICPLANQ3001.GLOBALCURRENCY == TCURC.WAERS` `C_GENERICPLANQ3001.MANDT == TCURC.MANDT`
Joint venture ? Client Joint venture	`C_GENERICPLANQ3001.[column in domain "BUKRS"] == T8JV.BUKRS` `C_GENERICPLANQ3001.MANDT == T8JV.MANDT` `C_GENERICPLANQ3001.JOINTVENTURE == T8JV.VNAME`
Joint Venture Cost Recovery Code ? Joint Venture Cost Recovery Code Client	`C_GENERICPLANQ3001.[column in domain "BUKRS"] == T8JJ.BUKRS` `C_GENERICPLANQ3001.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID` `C_GENERICPLANQ3001.MANDT == T8JJ.MANDT`
Joint Venture Equity Group Joint Venture Equity Group ? Client Joint venture	`C_GENERICPLANQ3001.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP` `C_GENERICPLANQ3001.[column in domain "BUKRS"] == T8JF.BUKRS` `C_GENERICPLANQ3001.MANDT == T8JF.MANDT` `C_GENERICPLANQ3001.JOINTVENTURE == T8JF.VNAME`
Ledger in General Ledger Accounting Client Ledger in General Ledger Accounting	`C_GENERICPLANQ3001.MANDT == FINSC_LEDGER.MANDT` `C_GENERICPLANQ3001.LEDGER == FINSC_LEDGER.RLDNR`
Material Number Material Number Product Number Client	`C_GENERICPLANQ3001.MATERIAL == MARA.MATNR` `C_GENERICPLANQ3001.PRODUCT == MARA.MATNR` `C_GENERICPLANQ3001.MANDT == MARA.MANDT`
Product Sold Group Product Sold Group Client	`C_GENERICPLANQ3001.MATERIALGROUP == T023.MATKL` `C_GENERICPLANQ3001.MANDT == T023.MANDT`
Order ID Order ID Client	`C_GENERICPLANQ3001.ORDERID == AUFK.AUFNR` `C_GENERICPLANQ3001.MANDT == AUFK.MANDT`
Partner Business Area Partner Business Area Client	`C_GENERICPLANQ3001.PARTNERBUSINESSAREA == TGSB.GSBER` `C_GENERICPLANQ3001.MANDT == TGSB.MANDT`
Company ID of Trading Partner Company ID of Trading Partner Client	`C_GENERICPLANQ3001.PARTNERCOMPANY == T880.RCOMP` `C_GENERICPLANQ3001.MANDT == T880.MANDT`
Partner Company Code Partner Company Code Client	`C_GENERICPLANQ3001.PARTNERCOMPANYCODE == T001.BUKRS` `C_GENERICPLANQ3001.MANDT == T001.MANDT`
Partner Cost Center Controlling Area Partner Cost Center ? Client	`C_GENERICPLANQ3001.CONTROLLINGAREA == CSKS.KOKRS` `C_GENERICPLANQ3001.PARTNERCOSTCENTER == CSKS.KOSTL` `C_GENERICPLANQ3001.[column in domain "DATBI"] == CSKS.DATBI` `C_GENERICPLANQ3001.MANDT == CSKS.MANDT`
Partner Cost Center Activity Type Partner Cost Center Activity Type Controlling Area ? Client	`C_GENERICPLANQ3001.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR` `C_GENERICPLANQ3001.CONTROLLINGAREA == CSLA.KOKRS` `C_GENERICPLANQ3001.[column in domain "DATBI"] == CSLA.DATBI` `C_GENERICPLANQ3001.MANDT == CSLA.MANDT`
Partner Functional Area Partner Functional Area Client	`C_GENERICPLANQ3001.PARTNERFUNCTIONALAREA == TFKB.FKBER` `C_GENERICPLANQ3001.MANDT == TFKB.MANDT`
Partner Order Partner Order Client	`C_GENERICPLANQ3001.PARTNERORDER == AUFK.AUFNR` `C_GENERICPLANQ3001.MANDT == AUFK.MANDT`
Partner Profit Center Partner Profit Center Controlling Area ? Client	`C_GENERICPLANQ3001.PARTNERPROFITCENTER == CEPC.PRCTR` `C_GENERICPLANQ3001.CONTROLLINGAREA == CEPC.KOKRS` `C_GENERICPLANQ3001.[column in domain "DATBI"] == CEPC.DATBI` `C_GENERICPLANQ3001.MANDT == CEPC.MANDT`
Partner Segment for Segmental Reporting Partner Segment for Segmental Reporting Client	`C_GENERICPLANQ3001.PARTNERSEGMENT == FAGL_SEGM.SEGMENT` `C_GENERICPLANQ3001.MANDT == FAGL_SEGM.MANDT`
Plant Client Plant	`C_GENERICPLANQ3001.MANDT == T001W.MANDT` `C_GENERICPLANQ3001.PLANT == T001W.WERKS`
Product Number Material Number Product Number Client	`C_GENERICPLANQ3001.MATERIAL == MARA.MATNR` `C_GENERICPLANQ3001.PRODUCT == MARA.MATNR` `C_GENERICPLANQ3001.MANDT == MARA.MANDT`
Profit Center Controlling Area Profit Center ? Client	`C_GENERICPLANQ3001.CONTROLLINGAREA == CEPC.KOKRS` `C_GENERICPLANQ3001.PROFITCENTER == CEPC.PRCTR` `C_GENERICPLANQ3001.[column in domain "DATBI"] == CEPC.DATBI` `C_GENERICPLANQ3001.MANDT == CEPC.MANDT`
Unit of Measure for Reference Quantity Client Unit of Measure for Reference Quantity	`C_GENERICPLANQ3001.MANDT == T006.MANDT` `C_GENERICPLANQ3001.REFERENCEQUANTITYUNIT == T006.MSEHI`
Sales District Sales District Client	`C_GENERICPLANQ3001.SALESDISTRICT == T171.BZIRK` `C_GENERICPLANQ3001.MANDT == T171.MANDT`
Sales Organization Client Sales Organization	`C_GENERICPLANQ3001.MANDT == TVKO.MANDT` `C_GENERICPLANQ3001.SALESORGANIZATION == TVKO.VKORG`
Segment for Segmental Reporting Segment for Segmental Reporting Client	`C_GENERICPLANQ3001.SEGMENT == FAGL_SEGM.SEGMENT` `C_GENERICPLANQ3001.MANDT == FAGL_SEGM.MANDT`
Service Contract ID Service Contract Item ID Client Service Contract ID Service Contract Type	`C_GENERICPLANQ3001.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `C_GENERICPLANQ3001.MANDT == FCO_SRVDOC.MANDT` `C_GENERICPLANQ3001.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID` `C_GENERICPLANQ3001.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE`
Service Contract Item ID Service Contract Item ID Client Service Contract ID Service Contract Type	`C_GENERICPLANQ3001.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `C_GENERICPLANQ3001.MANDT == FCO_SRVDOC.MANDT` `C_GENERICPLANQ3001.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID` `C_GENERICPLANQ3001.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE`
Service Contract Type Client Service Contract Type	`C_GENERICPLANQ3001.MANDT == CRMC_PROC_TYPE.CLIENT` `C_GENERICPLANQ3001.SERVICECONTRACTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE`
Service Document ID Service Document Type Service Document ID Client Service Document Item ID	`C_GENERICPLANQ3001.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE` `C_GENERICPLANQ3001.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID` `C_GENERICPLANQ3001.MANDT == FCO_SRVDOC.MANDT` `C_GENERICPLANQ3001.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID`
Service Document Item ID Service Document Type Service Document ID Client Service Document Item ID	`C_GENERICPLANQ3001.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE` `C_GENERICPLANQ3001.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID` `C_GENERICPLANQ3001.MANDT == FCO_SRVDOC.MANDT` `C_GENERICPLANQ3001.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID`
Service Document Type Service Document Type Client	`C_GENERICPLANQ3001.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE` `C_GENERICPLANQ3001.MANDT == CRMC_PROC_TYPE.CLIENT`
Ship-to Party Ship-to Party Client	`C_GENERICPLANQ3001.SHIPTOPARTY == KNA1.KUNNR` `C_GENERICPLANQ3001.MANDT == KNA1.MANDT`
Sold Material Sold Material Client	`C_GENERICPLANQ3001.SOLDMATERIAL == MARA.MATNR` `C_GENERICPLANQ3001.MANDT == MARA.MANDT`
Transaction Currency Transaction Currency Client	`C_GENERICPLANQ3001.TRANSACTIONCURRENCY == TCURC.WAERS` `C_GENERICPLANQ3001.MANDT == TCURC.MANDT`