What is I_PlanLineItemSemTag in SAP S/4HANA?

I_PlanLineItemSemTag is a composite CDS view in SAP S/4HANA. Plan Line Item with Semantic Tag It contains 79 fields.

Which tables does I_PlanLineItemSemTag read from?

I_PlanLineItemSemTag reads data from: P_PlanLineItemSemTag.

What VDM layer is I_PlanLineItemSemTag?

I_PlanLineItemSemTag is classified as a Composite view that combines data from multiple basic views.

I_PlanLineItemSemTag

DDL: I_PLANLINEITEMSEMTAG SQL: IFIPLGLACCTLITST Type: view COMPOSITE

79 Fields 1 Data Sources 10 Associations

Plan Line Item with Semantic Tag

I_PlanLineItemSemTag (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_PlanLineItemSemTag is a Composite CDS View (Cube) that provides data about "Plan Line Item with Semantic Tag" in SAP S/4HANA. It reads from 1 data source (P_PlanLineItemSemTag) and exposes 79 fields with key fields FinancialPlanningReqTransSqnc, FinancialPlanningDataPacket, FinancialPlanningEntryItem, GLAccountHierarchy, SemanticTag. It has 10 associations to related views.

SAP Help Documentation

Category	CDS Views for Transaction Data
Data Category	Cube
Status	Released

Purpose
This CDS view provides the prerequisites for answering the following business questions: What are the plan KPI amounts for each plan entry item? What is my plan net cash amount in company code currency?

Prerequisites
You can create reports for General Ledger Accounting , Asset Accounting or Cost Accounting using this CDS view. Users who want to run these reports must be able to display data for the following fields: Authorization Object Fields with Display Access Needed K_ACDOCP_P CATEGORY_P F_FAGL_LDR GLRLDNR , BUKRS F_BKPF_BUK BUKRS F_BKPF_BES BRGRU F_BKPF_BED BRGRU F_BKPF_GSB GSBER F_FAGL_SEG SEGMENT K_PCAR_REP PRCTR V_KNA1_VKO VKORG , VTWEG V_VBAK_AAT AUART Authorization groups Business areas Company codes Cost centers Distribution channels Ledgers Order types Planning categories Profit centers Sales organizations Segments

Structure
Business Objects This view is built on the following business objects: Semantic tags Measures and attributes The view contains all relevant measures and attributes. Some important measures are: Plan operating activity Plan investing activity Plan financing activity Cash amount in company code currency Plan net cash amount in company code currency Financial statement version Plan revenue amount in company code currency Plan gross revenue amount in company code currency Some important attributes are: Financial planning request transaction sequence number Financial planning data packet number Financial planning entry item

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Accounting and Financial Close
Application Component	FI-GL-IS
Capabilities	Data Provider for Analytical Queries, Data Source in SQL Select, Data Source for Defining CDS Entities
Package	Accounting and Financial Close for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What are the plan KPI amounts for each plan entry item?</p></li> <li><p>What is my plan net cash amount in company code currency?</p></li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
P_PlanLineItemSemTag	P_PlanLineItemSemTag	from

Associations (10)

Cardinality	Target	Alias	Condition
[0..1]	I_WBSElementByExternalID	_WBSElementExternalID	`$projection.WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID`
[0..1]	I_WBSElementByExternalID	_WBSElementExternalIDText	`$projection.WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID`
[0..1]	I_WBSElementByExternalID	_PartnerWBSElementExternalID	`$projection.PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID`
[0..1]	I_WBSElementByExternalID	_PartnerWBSElemntExtrnalIDText	`$projection.PartnerWBSElementExternalID = _PartnerWBSElemntExtrnalIDText.WBSElementExternalID`
[0..1]	I_ProjectByExternalID	_PartnerProjectExternalID	`$projection.PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID`
[0..1]	I_ProjectByExternalID	_PartnerProjctExtrnalIDText	`$projection.PartnerProjectExternalID = _PartnerProjctExtrnalIDText.ProjectExternalID`
[0..1]	I_ProjectByExternalID	_ProjectExternalID	`$projection.ProjectExternalID = _ProjectExternalID.ProjectExternalID`
[0..1]	I_ProjectByExternalID	_ProjectExternalIDText	`$projection.ProjectExternalID = _ProjectExternalIDText.ProjectExternalID`
[0..1]	I_MasterFixedAsset	_MasterFixedAsset	`$projection.CompanyCode = _MasterFixedAsset.CompanyCode and $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset`
[0..1]	I_FixedAsset	_FixedAsset	`$projection.CompanyCode = _FixedAsset.CompanyCode and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset and $projection.FixedAsset = _FixedAsset.FixedAsset`

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	IFIPLGLACCTLITST	view
EndUserText.label	Plan Line Item with Semantic Tag	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
Analytics.dataCategory	#CUBE	view
AbapCatalog.preserveKey	true	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (79)

Key	Field	Source Table	Source Field	Description
KEY	FinancialPlanningReqTransSqnc		FinancialPlanningReqTransSqnc	Financial Planning Request Transaction Sequence Number
KEY	FinancialPlanningDataPacket		FinancialPlanningDataPacket	Financial Planning Data Packet Number
KEY	FinancialPlanningEntryItem		FinancialPlanningEntryItem	Financial Planning Entry Item
KEY	GLAccountHierarchy		GLAccountHierarchy	Financial Statement Version
KEY	SemanticTag		SemanticTag	Semantic Tag of a Hierarchy Node
KEY	ValidityStartDate		ValidityStartDate	Validity Start Date
KEY	ValidityEndDate		ValidityEndDate	Valid To Date
	ControllingArea		ControllingArea	Controlling Area
	CompanyCode		CompanyCode	Receiver Company Code
	Ledger		Ledger	Ledger
	GLAccount		GLAccount	General Ledger
	ChartOfAccounts		ChartOfAccounts	Chart of Accounts
	FiscalYear		FiscalYear	G/L Fiscal Year
	LedgerFiscalYear		LedgerFiscalYear	Fiscal Year of Ledger
	FiscalQuarter	_FiscalCalendarDate	FiscalQuarter	Fiscal Quarter
	BusinessArea		BusinessArea	Business Area
	ProfitCenter		ProfitCenter	Profit Center
	CostCenter		CostCenter	Cost Center
	Project		Project	WBS Element
	ProjectInternalID		ProjectInternalID	Project Internal ID
	ProjectExternalID	_ProjectBasicData	ProjectExternalID	Project Number (External) Edited
	PartnerProjectInternalID		PartnerProjectInternalID	Partner Project Internal ID
	PartnerProjectExternalID	_ProjectBasicData	ProjectExternalID	Project Number (External) Edited
	WBSElement		WBSElement	Work Breakdown Structure Element (WBS Element)
	WBSElementInternalID		WBSElementInternalID	WBS Element Internal ID
	WBSElementExternalID	_WBSElementBasicData	WBSElementExternalID	Work Breakdown Structure Element (WBS Element) Edited
	PartnerWBSElementInternalID		PartnerWBSElementInternalID	Partner WBS Element Internal ID
	PartnerWBSElementExternalID	_WBSElementBasicData	WBSElementExternalID	Work Breakdown Structure Element (WBS Element) Edited
	FunctionalArea		FunctionalArea	Sendr Fctl Area
	Segment		Segment	Segment for Segmental Reporting
	CostCtrActivityType		CostCtrActivityType	Activity Type
	CostAnalysisResource		CostAnalysisResource	Cost Analysis Resource
	WorkPackage		WorkPackage	Plan Item
	WorkItem		WorkItem	Work Item ID
	BillableControl		BillableControl	Billable Control
	IsLotSizeIndependent		IsLotSizeIndependent	Is Lot Size Independent
	PartnerCompanyCode		PartnerCompanyCode	Company Code of Partner
	OriginCostCtrActivityType		OriginCostCtrActivityType	Activity Type of the Origin Cost Center
	PartnerBusinessArea		PartnerBusinessArea	Partner Business Area
	PartnerSegment		PartnerSegment	Partner Segment for Segmental Reporting
	PartnerProfitCenter		PartnerProfitCenter	Partner Profit Center
	PartnerCostCenter		PartnerCostCenter	Partner Cost Center
	PartnerProject		PartnerProject	Partner Project
	PartnerWBSElement		PartnerWBSElement	Partner WBS Element
	PartnerFunctionalArea		PartnerFunctionalArea	Partner Functional Area
	PartnerCostCtrActivityType		PartnerCostCtrActivityType	Partner Cost Center Activity Type
	OrderID		OrderID	Order ID
	PartnerOrder		PartnerOrder	Partner Order (Deprecated)
	PartnerOrder_2		PartnerOrder_2	Partner Order
	PartnerCompany		PartnerCompany	Company ID of Trading Partner
	ReferenceDocumentType		ReferenceDocumentType	Reference Document Type
	ReferenceDocumentContext		ReferenceDocumentContext	Reference Document Context
	ReferenceDocument		ReferenceDocument	Reference Doc. Number
	TransactionCurrency		TransactionCurrency	Transaction Currency
	AmountInTransactionCurrency		AmountInTransactionCurrency	Amount in Transaction Currency
	CompanyCodeCurrency		CompanyCodeCurrency	Company Code Currency
	AmountInCompanyCodeCurrency		AmountInCompanyCodeCurrency	Amount in Company Code Currency
	GlobalCurrency		GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency		AmountInGlobalCurrency	Amount in Global Currency
	FreeDefinedCurrency1		FreeDefinedCurrency1	Freely Defined Currency 1
	AmountInFreeDefinedCurrency1		AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
	FreeDefinedCurrency2		FreeDefinedCurrency2	Freely Defined Currency 2
	AmountInFreeDefinedCurrency2		AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
	FreeDefinedCurrency3		FreeDefinedCurrency3	Freely Defined Currency 3
	AmountInFreeDefinedCurrency3		AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
	FreeDefinedCurrency4		FreeDefinedCurrency4	Freely Defined Currency 4
	AmountInFreeDefinedCurrency4		AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
	FreeDefinedCurrency5		FreeDefinedCurrency5	Freely Defined Currency 5
	AmountInFreeDefinedCurrency5		AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
	FreeDefinedCurrency6		FreeDefinedCurrency6	Freely Defined Currency 6
	AmountInFreeDefinedCurrency6		AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
	FreeDefinedCurrency7		FreeDefinedCurrency7	Freely Defined Currency 7
	AmountInFreeDefinedCurrency7		AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
	FreeDefinedCurrency8		FreeDefinedCurrency8	Freely Defined Currency 8
	AmountInFreeDefinedCurrency8		AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
	ControllingObjectCurrency		ControllingObjectCurrency	CO Object Currency
	AmountInObjectCurrency		AmountInObjectCurrency	Amount in CO Object Currency
	FixedAmountInGlobalCrcy		FixedAmountInGlobalCrcy	Fixed Amount in Global Currency
	CostSourceUnit		CostSourceUnit	Unit of Measure

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_PlanLineItemSemTag.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IFIPLGLACCTLITST

CREATE VIEW I_PlanLineItemSemTag AS
SELECT
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  FinancialPlanningEntryItem,
  GLAccountHierarchy,
  SemanticTag,
  ValidityStartDate,
  ValidityEndDate,
  ControllingArea,
  CompanyCode,
  Ledger,
  GLAccount,
  ChartOfAccounts,
  FiscalYear,
  LedgerFiscalYear,
  _FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  BusinessArea,
  ProfitCenter,
  CostCenter,
  Project,
  ProjectInternalID,
  _ProjectBasicData.ProjectExternalID AS ProjectExternalID,
  PartnerProjectInternalID,
  _ProjectBasicData.ProjectExternalID AS PartnerProjectExternalID,
  WBSElement,
  WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  PartnerWBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS PartnerWBSElementExternalID,
  FunctionalArea,
  Segment,
  CostCtrActivityType,
  CostAnalysisResource,
  WorkPackage,
  WorkItem,
  BillableControl,
  IsLotSizeIndependent,
  PartnerCompanyCode,
  OriginCostCtrActivityType,
  PartnerBusinessArea,
  PartnerSegment,
  PartnerProfitCenter,
  PartnerCostCenter,
  PartnerProject,
  PartnerWBSElement,
  PartnerFunctionalArea,
  PartnerCostCtrActivityType,
  OrderID,
  PartnerOrder,
  PartnerOrder_2,
  PartnerCompany,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  ReferenceDocument,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  ControllingObjectCurrency,
  AmountInObjectCurrency,
  FixedAmountInGlobalCrcy,
  CostSourceUnit
FROM P_PlanLineItemSemTag
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalIDText ON WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElementExternalID ON PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElemntExtrnalIDText ON PartnerWBSElementExternalID = _PartnerWBSElemntExtrnalIDText.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjectExternalID ON PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjctExtrnalIDText ON PartnerProjectExternalID = _PartnerProjctExtrnalIDText.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalID ON ProjectExternalID = _ProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalIDText ON ProjectExternalID = _ProjectExternalIDText.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
;

Depth:

I_PlanLineItemSemTag view

P_PlanLineItemSemTag view

P_GrossMarginUnion view