P_PlanLineItemSemTag

Plan Line Item With Semantic Tag | view: PFIPLANLITST | Extraction: Not supported | Component: Information System
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
PlnRevenueAmountInCCCrcy Plan Revenue Amount in Company Code Currency
PlnGrossRevenueAmtInCCCrcy Plan Gross Revenue Amount in Company Code Currency
PlnRecognizedRevnAmtInCCCrcy Plan Recognized Revenue Amount in Company Code Currency
PlnRevnAdjustmentAmtInCCCrcy Plan Revenue Adjustment Amount in Company Code Currency
PlnDeferredRevenueAmtInCCCrcy Plan Deferred Revenue Amount in Company Code Currency
PlnAccruedRevenueAmtInCCCrcy Plan Accrued Revenue Amount in Company Code Currency
PlnBilledRevenueAmtInCCCrcy Plan Billed Revenue Amount In Company Code Currency
PlnRecognizedMargAmtInCCCrcy Plan Recognized Margin Amount in Company Code Currency
PlnCostAmtInCompanyCodeCrcy Plan Cost Amount in Company Code Currency
PlnRecognizedCOGSAmtInCCCrcy Plan Recognized Cost Of Goods Sold Amount In CC Currency
PlnCOGSAdjustmentAmtInCCCrcy Plan Cost Of Goods Sold Adjustment Amount In CC Currency
PlnDeferredCOGSAmtInCCCrcy Plan Defferred Cost Of Goods Sold Amount In CC Currency
PlnAccruedCOGSAmtInCCCrcy Plan Accrued Cost Of Sold Goods Amount in CC currency
PlnRecgblCostAmtInCCCrcy Plan Recognizable Cost Amount in Company Code Currency
PlnImmntLossRsrvAmtInCCCrcy Plan Reserves for Imminent Loss Amount in CC Currency
PlnSalesDeductRsrvAmtInCCCrcy Plan Reserve for Anticipated Sales Deductions Amt InCCCrcy
PlnUnrlzdCostsRsrvAmtInCCCrcy Plan Reserves for Unrealized Costs Amt in CompanyCode Crcy
PlnSlsDeductionAmtInCCCrcy Planned Sales Deduction Amount In Company 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
PlnLongTermInvmtAmtInCCCrcy Plan Long-term Investments Amount in Company Code Currency
PlnAcctsRblAmtInCCCrcy Plan Accounts Receivable Amount in Company Code currency
PlnAcctsOthRblAmtInCCCrcy Plan Accounts Other Receivable Amt In CompanyCode Currency
PlnAcctsPyblAmtInCCCrcy Plan Accounts Payable Amount InCompanyCodeCurrency
PlnAcctsOthPyblAmtInCCCrcy Plan Accounts Other Payable Amount In CompanyCode Currency
PlnProvisionAmtInCCCrcy Plan Provision Amount In CompanyCode Currency
PlnNotesReceivableAmtInCCCrcy Plan Notes Receivable Amount In CompanyCode Currency
PlnTangibleAstDeprAmtInCCCrcy Plan Depreciation of Tangible Assets Amount In CC Currency
PlnIntngblAstAmtznAmtInCCCrcy Plan Intangible Assets Amortization Amt in Co Code Crcy
PlnTangibleAstAmtInCCCrcy Plan Tangible Asset Amount InCompanyCodeCurrency
PlnIntangibleAstAmtInCCCrcy Plan Intangible Asset Amount InCompanyCodeCurrency
PlnFxdAstRtrmtAmtInCCCrcy Plan Investing Fixed Asset Retirement Amt In CC Currency
PlnInventoryAmtInCCCrcy Plan Inventory Amount In CompanyCode Currency
PlnCommonStockAmtInCCCrcy Plan Common Stocks Amount in Company Code Currency
PlnCshAndCshEqvlntAmtInCCCrcy Plan Cash And Cash Equivalent Amount InCompanyCodeCurrency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
PlnRecgdRevenueAmtInGlobCrcy Planned Recognized Revenue Amount In Global Currency
PlnBilledRevenueAmtInGlobCrcy Plan Billed Revenue Amount In Global Currency
PlnCostOfGdsSoldAmtInGlobCrcy Planned Cost of Goods Sold Amount In Global Currency
PlnSlsDeductionAmtInGlobCrcy Plan Sales Deduction Amount In Global Currency
PlnPrcDifferenceAmtInGlobCrcy Plan Price Differences Amount In Global Currency
PlnAdminOverheadAmtInGlobCrcy Plan Administration Overhead Amount in Global Currency
PlnSalesOverheadAmtInGlobCrcy Plan Sales Overhead Amount in Global Currency
PlnMarketingOvhdAmtInGlobCrcy Plan Marketing Overhead Amount in Global Currency
PlnRnDOverheadAmtInGlobCrcy Plan Research and Development Overhead Amt in Global Crcy
💲 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
ControllingDebitCreditCode CO Debit/Credit Indicator Show values
IsStatisticalOrder Indicator: Internal Order is Statistical Account Assignment Show values
IsStatisticalCostCenter Indicator: Cost Center is Statistical Account Assignment Show values
IsStatisticalSalesDocument Indicator: Sales Order Item is Statisticl Account Assignment Show values
WBSIsStatisticalWBSElement Indicator: WBS Element is Statistical Account Assignment Show values
Column Name Description Domain name
FiscalYear Fiscal Year GJAHR
LedgerFiscalYear Ledger Fiscal Year GJAHR
Project Project definition PS_PSPID
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
PartnerWBSElementInternalID Partner WBS Element Internal ID FIS_WBSINT_NO_CONV
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
Master Data Relations Join Conditions
Transaction Type Category P_PLANLINEITEMSEMTAG.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Billing Type
  • Client
  • Billing Type
  • P_PLANLINEITEMSEMTAG.MANDT == TVFK.MANDT
  • P_PLANLINEITEMSEMTAG.BILLINGDOCUMENTTYPE == TVFK.FKART
Bill-to Party
  • Client
  • Bill-to Party
  • P_PLANLINEITEMSEMTAG.MANDT == KNA1.MANDT
  • P_PLANLINEITEMSEMTAG.BILLTOPARTY == KNA1.KUNNR
Business Area
  • Client
  • Business Area
  • P_PLANLINEITEMSEMTAG.MANDT == TGSB.MANDT
  • P_PLANLINEITEMSEMTAG.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_PLANLINEITEMSEMTAG.CHARTOFACCOUNTS == T004.KTOPL
  • P_PLANLINEITEMSEMTAG.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_PLANLINEITEMSEMTAG.COMPANYCODE == T001.BUKRS
  • P_PLANLINEITEMSEMTAG.MANDT == T001.MANDT
Controlling Area
  • Client
  • Controlling Area
  • P_PLANLINEITEMSEMTAG.MANDT == TKA01.MANDT
  • P_PLANLINEITEMSEMTAG.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Cost Center
  • ?
  • Controlling Area
  • P_PLANLINEITEMSEMTAG.MANDT == CSKS.MANDT
  • P_PLANLINEITEMSEMTAG.COSTCENTER == CSKS.KOSTL
  • P_PLANLINEITEMSEMTAG.[column in domain "DATBI"] == CSKS.DATBI
  • P_PLANLINEITEMSEMTAG.CONTROLLINGAREA == CSKS.KOKRS
Customer Number
  • Client
  • Customer Number
  • P_PLANLINEITEMSEMTAG.MANDT == KNA1.MANDT
  • P_PLANLINEITEMSEMTAG.CUSTOMER == KNA1.KUNNR
Customer Group
  • Customer Group
  • Client
  • P_PLANLINEITEMSEMTAG.CUSTOMERGROUP == T151.KDGRP
  • P_PLANLINEITEMSEMTAG.MANDT == T151.MANDT
Country/Region of Customer or Supplier
  • Client
  • Country/Region of Customer or Supplier
  • P_PLANLINEITEMSEMTAG.MANDT == T005.MANDT
  • P_PLANLINEITEMSEMTAG.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
Industry Key
  • Client
  • Industry Key
  • P_PLANLINEITEMSEMTAG.MANDT == T016.MANDT
  • P_PLANLINEITEMSEMTAG.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
Distribution Channel
  • Client
  • Distribution Channel
  • P_PLANLINEITEMSEMTAG.MANDT == TVTW.MANDT
  • P_PLANLINEITEMSEMTAG.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • Organization Division
  • P_PLANLINEITEMSEMTAG.MANDT == TSPA.MANDT
  • P_PLANLINEITEMSEMTAG.DIVISION == TSPA.SPART
  • P_PLANLINEITEMSEMTAG.ORGANIZATIONDIVISION == TSPA.SPART
Functional Area
  • Client
  • Functional Area
  • P_PLANLINEITEMSEMTAG.MANDT == TFKB.MANDT
  • P_PLANLINEITEMSEMTAG.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Chart of Accounts
  • Client
  • G/L Account
  • P_PLANLINEITEMSEMTAG.CHARTOFACCOUNTS == SKA1.KTOPL
  • P_PLANLINEITEMSEMTAG.MANDT == SKA1.MANDT
  • P_PLANLINEITEMSEMTAG.GLACCOUNT == SKA1.SAKNR
Ledger
  • Client
  • Ledger
Material Number
  • Client
  • Material Number
  • P_PLANLINEITEMSEMTAG.MANDT == MARA.MANDT
  • P_PLANLINEITEMSEMTAG.MATERIAL == MARA.MATNR
Product Sold Group
  • Client
  • Product Sold Group
  • P_PLANLINEITEMSEMTAG.MANDT == T023.MANDT
  • P_PLANLINEITEMSEMTAG.MATERIALGROUP == T023.MATKL
Organization Division
  • Client
  • Division
  • Organization Division
  • P_PLANLINEITEMSEMTAG.MANDT == TSPA.MANDT
  • P_PLANLINEITEMSEMTAG.DIVISION == TSPA.SPART
  • P_PLANLINEITEMSEMTAG.ORGANIZATIONDIVISION == TSPA.SPART
Partner Business Area
  • Client
  • Partner Business Area
  • P_PLANLINEITEMSEMTAG.MANDT == TGSB.MANDT
  • P_PLANLINEITEMSEMTAG.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_PLANLINEITEMSEMTAG.MANDT == T880.MANDT
  • P_PLANLINEITEMSEMTAG.PARTNERCOMPANY == T880.RCOMP
Partner Cost Center
  • Client
  • Partner Cost Center
  • ?
  • Controlling Area
  • P_PLANLINEITEMSEMTAG.MANDT == CSKS.MANDT
  • P_PLANLINEITEMSEMTAG.PARTNERCOSTCENTER == CSKS.KOSTL
  • P_PLANLINEITEMSEMTAG.[column in domain "DATBI"] == CSKS.DATBI
  • P_PLANLINEITEMSEMTAG.CONTROLLINGAREA == CSKS.KOKRS
Partner Functional Area
  • Client
  • Partner Functional Area
  • P_PLANLINEITEMSEMTAG.MANDT == TFKB.MANDT
  • P_PLANLINEITEMSEMTAG.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Profit Center
  • Client
  • ?
  • Partner Profit Center
  • Controlling Area
  • P_PLANLINEITEMSEMTAG.MANDT == CEPC.MANDT
  • P_PLANLINEITEMSEMTAG.[column in domain "DATBI"] == CEPC.DATBI
  • P_PLANLINEITEMSEMTAG.PARTNERPROFITCENTER == CEPC.PRCTR
  • P_PLANLINEITEMSEMTAG.CONTROLLINGAREA == CEPC.KOKRS
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • P_PLANLINEITEMSEMTAG.MANDT == FAGL_SEGM.MANDT
  • P_PLANLINEITEMSEMTAG.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Plan Category
  • Client
  • Plan Category
Plant
  • Client
  • Plant
  • P_PLANLINEITEMSEMTAG.MANDT == T001W.MANDT
  • P_PLANLINEITEMSEMTAG.PLANT == T001W.WERKS
Material Group
  • Material Group
  • Client
  • P_PLANLINEITEMSEMTAG.PRODUCTGROUP == T023.MATKL
  • P_PLANLINEITEMSEMTAG.MANDT == T023.MANDT
Profit Center
  • Profit Center
  • Client
  • ?
  • Controlling Area
  • P_PLANLINEITEMSEMTAG.PROFITCENTER == CEPC.PRCTR
  • P_PLANLINEITEMSEMTAG.MANDT == CEPC.MANDT
  • P_PLANLINEITEMSEMTAG.[column in domain "DATBI"] == CEPC.DATBI
  • P_PLANLINEITEMSEMTAG.CONTROLLINGAREA == CEPC.KOKRS
Sales District
  • Client
  • Sales District
  • P_PLANLINEITEMSEMTAG.MANDT == T171.MANDT
  • P_PLANLINEITEMSEMTAG.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Client
  • Sales Organization
  • P_PLANLINEITEMSEMTAG.MANDT == TVKO.MANDT
  • P_PLANLINEITEMSEMTAG.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_PLANLINEITEMSEMTAG.MANDT == FAGL_SEGM.MANDT
  • P_PLANLINEITEMSEMTAG.SEGMENT == FAGL_SEGM.SEGMENT
Semantic Tag of a Hierarchy Node
  • Semantic Tag of a Hierarchy Node
  • Client
Ship-to Party
  • Client
  • Ship-to Party
  • P_PLANLINEITEMSEMTAG.MANDT == KNA1.MANDT
  • P_PLANLINEITEMSEMTAG.SHIPTOPARTY == KNA1.KUNNR
Product Sold
  • Product Sold
  • Client
  • P_PLANLINEITEMSEMTAG.SOLDMATERIAL == MARA.MATNR
  • P_PLANLINEITEMSEMTAG.MANDT == MARA.MANDT