I_PlanLineItemSemTagGLAcct

Plan GLAccount LineItem with SemanticTag | view: IFIPLANLITSTGL | TRAN | Extraction: Not supported | Component: Information System
Tables used: ACDOCP, T004, T001, TKA02, SKA1, PROJ, HRRP_FSV_DIR, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
FinancialPlanningReqTransSqnc Financial Planning Request Transaction Sequence Number
FinancialPlanningDataPacket Financial Planning Data Packet Number
FinancialPlanningEntryItem Financial Planning Entry Item
GLAccountHierarchy FK Financial Statement Version
SemanticTag FK Semantic Tag of a Hierarchy Node
ValidityStartDate Valid-From Date
ValidityEndDate FK Valid To Date
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
PlnAssetAmtInCCCrcy Plan Asset Amount In CompanyCode Currency
PlnLbltyEquityAmtInCCCrcy Plan Liabilities and Equity Amount In Company Code Currency
PlnNotAssignedAmtInCCCrcy Plan Not Assigned Amount In Company Code Currency
PlnNetRsltAmtInCCCrcy Plan Net Result Amount In Company Code Currency
PlnPnLResultAmtInCCCrcy Plan P&L Result Amount In company code currency
PlnGLAcctNetIncAmtInCCCrcy Plan Net Income Amount In CompanyCode Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global 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
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate FK Valid To Date
PostingDate Posting Date
Column Name Description
IsLotSizeIndependent Is Lot Size Independent Show values
GLAccountType Type of a General Ledger Account Show values
ControllingDebitCreditCode CO Debit/Credit Indicator Show values
Column Name Description Domain name
FiscalYear Fiscal Year GJAHR
LedgerFiscalYear Ledger Fiscal Year GJAHR
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
Project Project definition PS_PSPID
ProjectExternalID Project Number (External) Edited PS_PSPID_EDIT
PartnerProjectExternalID Project Number (External) Edited PS_PSPID_EDIT
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
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
WorkPackage Plan Item /CPD/PLAN_ITEM_ID
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
PartnerProject Partner Project PS_PSPID
PartnerWBSElement Partner WBS Element PS_POSID
ReferenceDocumentType Reference Document Type AWTYP
ReferenceDocumentContext Reference Document Context AWORG
ReferenceDocument Reference document number AWREF
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
FiscalYearVariant Fiscal Year Variant PERIV
SalesOrder Sales Order VBELN
SalesOrderItem Sales Order Item POSNR
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
PersonnelNumber Personnel Number PERNR
CustomerSupplierCorporateGroup Corporate Group of Customer or Supplier KONZS
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_PLANLINEITEMSEMTAGGLACCT.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Billing Type
  • Billing Type
  • Client
  • I_PLANLINEITEMSEMTAGGLACCT.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == TVFK.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • I_PLANLINEITEMSEMTAGGLACCT.BILLTOPARTY == KNA1.KUNNR
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == KNA1.MANDT
Business Area
  • Client
  • Business Area
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == TGSB.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == T004.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == T001.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • I_PLANLINEITEMSEMTAGGLACCT.CONTROLLINGAREA == TKA01.KOKRS
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Client
  • Cost Center
  • ?
  • I_PLANLINEITEMSEMTAGGLACCT.CONTROLLINGAREA == CSKS.KOKRS
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == CSKS.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.COSTCENTER == CSKS.KOSTL
  • I_PLANLINEITEMSEMTAGGLACCT.[column in domain "DATBI"] == CSKS.DATBI
Customer Number
  • Customer Number
  • Client
  • I_PLANLINEITEMSEMTAGGLACCT.CUSTOMER == KNA1.KUNNR
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == KNA1.MANDT
Customer Group
  • Client
  • Customer Group
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == T151.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.CUSTOMERGROUP == T151.KDGRP
Country/Region of Customer or Supplier
  • Country/Region of Customer or Supplier
  • Client
  • I_PLANLINEITEMSEMTAGGLACCT.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == T005.MANDT
Industry Key
  • Industry Key
  • Client
  • I_PLANLINEITEMSEMTAGGLACCT.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == T016.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == TVTW.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • Organization Division
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == TSPA.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.DIVISION == TSPA.SPART
  • I_PLANLINEITEMSEMTAGGLACCT.ORGANIZATIONDIVISION == TSPA.SPART
Functional Area
  • Client
  • Functional Area
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == TFKB.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Client
  • G/L Account
  • Chart of Accounts
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == SKA1.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.GLACCOUNT == SKA1.SAKNR
  • I_PLANLINEITEMSEMTAGGLACCT.CHARTOFACCOUNTS == SKA1.KTOPL
Ledger
  • Client
  • Ledger
Material Number
  • Client
  • Material Number
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == MARA.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.MATERIAL == MARA.MATNR
Product Sold Group
  • Client
  • Product Sold Group
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == T023.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.MATERIALGROUP == T023.MATKL
Organization Division
  • Client
  • Division
  • Organization Division
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == TSPA.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.DIVISION == TSPA.SPART
  • I_PLANLINEITEMSEMTAGGLACCT.ORGANIZATIONDIVISION == TSPA.SPART
Partner Business Area
  • Client
  • Partner Business Area
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == TGSB.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • I_PLANLINEITEMSEMTAGGLACCT.PARTNERCOMPANY == T880.RCOMP
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == T880.MANDT
Partner Cost Center
  • Controlling Area
  • Client
  • ?
  • Partner Cost Center
  • I_PLANLINEITEMSEMTAGGLACCT.CONTROLLINGAREA == CSKS.KOKRS
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == CSKS.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.[column in domain "DATBI"] == CSKS.DATBI
  • I_PLANLINEITEMSEMTAGGLACCT.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Client
  • Partner Functional Area
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == TFKB.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Profit Center
  • Controlling Area
  • Partner Profit Center
  • Client
  • ?
  • I_PLANLINEITEMSEMTAGGLACCT.CONTROLLINGAREA == CEPC.KOKRS
  • I_PLANLINEITEMSEMTAGGLACCT.PARTNERPROFITCENTER == CEPC.PRCTR
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == CEPC.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.[column in domain "DATBI"] == CEPC.DATBI
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • I_PLANLINEITEMSEMTAGGLACCT.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == FAGL_SEGM.MANDT
Plan Category
  • Plan Category
  • Client
Plant
  • Client
  • Plant
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == T001W.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.PLANT == T001W.WERKS
Material Group
  • Client
  • Material Group
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == T023.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.PRODUCTGROUP == T023.MATKL
Profit Center
  • Controlling Area
  • Client
  • ?
  • Profit Center
  • I_PLANLINEITEMSEMTAGGLACCT.CONTROLLINGAREA == CEPC.KOKRS
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == CEPC.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.[column in domain "DATBI"] == CEPC.DATBI
  • I_PLANLINEITEMSEMTAGGLACCT.PROFITCENTER == CEPC.PRCTR
Sales District
  • Client
  • Sales District
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == T171.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Sales Organization
  • Client
  • I_PLANLINEITEMSEMTAGGLACCT.SALESORGANIZATION == TVKO.VKORG
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == FAGL_SEGM.MANDT
  • I_PLANLINEITEMSEMTAGGLACCT.SEGMENT == FAGL_SEGM.SEGMENT
Semantic Tag of a Hierarchy Node
  • Semantic Tag of a Hierarchy Node
  • Client
Ship-to Party
  • Ship-to Party
  • Client
  • I_PLANLINEITEMSEMTAGGLACCT.SHIPTOPARTY == KNA1.KUNNR
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Client
  • I_PLANLINEITEMSEMTAGGLACCT.SOLDMATERIAL == MARA.MATNR
  • I_PLANLINEITEMSEMTAGGLACCT.MANDT == MARA.MANDT